Qommentary
Qommentary Writeback
Qommentary Writeback
  • Welcome
  • Getting started
  • Setting up a connection
  • Defining a primary key
  • Adding data to your table
  • WORKING WITH INPUT DATA
    • Adding input columns
      • Text
      • Number
      • Checkbox
      • Dropdown
      • Rating
      • Color picker
      • Date picker
      • Switch
    • Conditional input control
    • Saving and reverting
  • Writeback Actions
    • Refreshing data
    • Clearing data
    • Reloading data
    • Exporting data
  • Bulk updates
    • Single Column
    • Advance Bulk
  • CUSTOMIZATION
    • Table settings
    • Themes
  • Share
    • Sharing data with your team
    • Customizing email template
  • Advanced
    • Audit Trails
      • File audit trailing
      • Database audit trailing
        • SQL Server example
    • Concurrency
  • Support
    • Submit a ticket
Powered by GitBook
On this page

Was this helpful?

  1. Advanced
  2. Audit Trails

File audit trailing

PreviousAudit TrailsNextDatabase audit trailing

Last updated 4 years ago

Was this helpful?

To enable audit logs for files

1. Open the properties panel and click on the Data Connections section

You need to set up a connection before enabling logs

2. Go to the Enable audit logs option

3. Click on the switch control to enable audit logs

Once you start adding data, a folder with the name Audit\[File name]\ will be created under the path related to the connection. (e.g. if your connection points to C:\test\writeback folder and the file name is Customers, the audit logs will be stored in the C:\test\writeback\Audit\Customers folder)

A new log file will be created per day to avoid performance issues in reading big files.

The audit log files contain a similiar structure as the original file with 3 additional XML nodes: ActionAt, ActionBy and ActionType.

XML Node

Description

ActionAt

Date and time when the action was performed

ActionBy

Which user performed the action (UserDirectory\UserId)

ActionType

What action was performed ( C = create, U = update, D= delete )

In the example below you can see an entry for the Customers audit log XML file.

	<Row>
		<Id xsi:type="string">ABC001</Id>
		<Name xsi:type="string">Micheal Smith</Name>
		<Date/>
		<ActionAt xsi:type="dateTime">2021-04-22T11:58:25.684+00:00</ActionAt>
		<ActionBy xsi:type="string">QOM\jdean</ActionBy>
		<ActionType xsi:type="string">C</ActionType>
	</Row>