Output Format

Overview:

iAuditor uses a Comma Separated Values (.CSV) file to export the audit information. The basic structure of the output CSV is as follows:

Information Headers
Template / Audit information
Audit Headers
Item information

This may seem a little confusing at first but it will be broken down in the steps that follow.

 

Information Rows

Overview:

The first row of the output CSV contains the header row for the template and audit information. This is as follows:

Column Information
Key Contains the key of the audit.
Value Contains the value relating to the key

The next 16 rows will be information pertaining to the template and the audit.

Key Type Value
template_id string ID of the template.
template_name string Name of the template.
audit_id string ID of the audit.
audit_started int UNIX timestamp of the start date. (-1 if not recorded)
audit_completed int UNIX timestamp of the completion date. (-1 if incomplete)
audit_duration int Duration of the audit in seconds.
audit_title string The audit title
audit_client string The audit client
audit_preparedby string Who prepared the audit
audit_location string Location of the audit
audit_latitude float Latitude of the audit
audit_longitude float Longitude of the audit
audit_personnel string Audit personnel
audit_score float Calculated score of the audit
audit_total float Calculated total score of the audit
audit_percentage float Calculated score percentage of the audit

Audit Information

Overview:

After the information rows have been written to the CSV, then the audit information header will follow.

Column Information
ID ID of the item
Type Type of the item
Label Label of the item
Options Options for the item
Parent The ID of the parent item
Primary The primary response for the item
Secondary The secondary response for the item
Media Media ID’s associated with the item, separated by semi-colons.

Items

Overview:

All the items that output responses will be listed below.

Responses:

Type Option Description
address Primary Contains the latitude then the longitude, separated by a semi-colon.
Secondary Contains the text of the address.
checkbox Primary Contains the status of the checkbox.
0 = Unchecked
1 = Checked
datetime Primary Contains the UNIX timestamp of the selected date
list Primary Contains the ID of the response and the response text, separated by a vertical line.

If there is more than one response then they will be separated by semi-colons.
question Primary Contains the ID of the response and the response text, separated by a vertical line.
Secondary Contains the entered response text.
signature Primary Contains the signature name entered.
Secondary Contains the timestamp of the signature.
slider Primary Contains the value of the slider
switch Primary Contains the status of the switch

0 = Off
1 = On

text Primary Contains the entered text
textsingle Primary Contains the entered text

File Structure

Overview:

When exporting a CSV file the application will use specific naming conventions to allow easy importing into other platforms. These will be outlined below.

If Zipped:

If “Zip Files” is enabled then the contents of the CSV will always be placed inside a .zip file. The actual .CSV file will always be named exportedCSV.csv and it will reside in the root of the .zip file.

Media:

If “Use Media Subdirectory” is enabled then any media attached to the audit will be placed in its own “media” folder. If this is disabled then the media will be placed alongside the exportedCSV.csv file.

Examples:

Zipped Only

https://lh6.googleusercontent.com/8ESn4_EDxQ44wvOUJAqt3-WckcysQHvGE7YjTP81fE3lWBQNuX_2CtuXm969gyWQfO1GaBa4GMUWl4H8nKvRdiqf-imrKzNAAvL1oJuifym-_39T90Y

Zipped + using media subdirectory.

https://lh6.googleusercontent.com/AAtKbsNoeokWRiJohHN7Co94sbCq-cPuc9y0LTTZ_ZRLCH_yQB7_8MPJUQPOL_O7SBmADibd6jm95g0TzGBzTN0NXBNyjmtG3IUp0DfXK3J8bwl39PY

Media

Overview:

All of the media in an audit is assigned its own unique ID. When an audit is exported in CSV format then all the media is placed alongside the CSV file. Note that if “use media subdirectory” is enabled then the media will be placed in a /media/ subdirectory.

The media is renamed to its ID and will always have the .jpg extension.

The media size will be resized to the options set under “CSV Options”.