The export tool can automatically bulk-export iAuditor inspections directly to a CSV file on your computer. The tool runs in looping mode to automatically export newly completed inspections.

There are other available methods to export inspections in CSV format via the iAuditor website, and iAuditor app. The SafetyCulture Exporter in CSV mode improves upon these options with:

  1. Improved compatibility with spreadsheet software and business intelligence tools.
  2. Automatic exporting of newly completed inspections
  3. An improved format that effectively conveys complex inspections data like dynamic fields, list of images, and quoted text.
  4. A more flexible format that gracefully handles templates that change over time. Templates that change over time disrupts the expected inspection structure.
  5. A more predictable format for easy parsing, database importing, and data analytics.

There is one other method to export inspections in tabular format using Zapier that readers may be interested in. This method is completely automated after initial setup, runs no software on your system, and saves your inspection data directly to cloud spreadsheet software like Google Sheets, or Excel Online.

See an example Zap setup here: Exporting inspection data to an online spreadsheet using Zapier.

IMPORTANT NOTE

The following setup requires an iAuditor Premium subscription.

Installation and Guide

The iAuditor Exporter is part of the Python SDK package which is available for download. The tool is command-line based and needs installing using a Python tool called pip. Prior to following the below commands, you’ll need to install Python on your local machine.

  1. If you’re running macOS, you’ll likely already have Python 2.7 installed. In Terminal if you run the command python --version you should see version 2.7.
  2. For users on Windows, you’ll need to install Python.
  3. Download this file from Python.org –  This is an installation file, so you may need administrator access to download it. If you encounter issues downloading, you may need to speak to your IT admin for further support.
  4. Once downloaded, double click the file to begin the installation
  5. Accept the default options and keep clicking next.
  6. At the very end of the install, you’ll see a tick box to ‘Add Python to PATH’ – ensure you tick the box.
  7. If you’ve already installed and missed the tick box, just run the installer again and you’ll be able to tick the box.
  8. Restart your computer

To install, setup, and start exporting inspections in CSV format, paste the following instructions into the terminal (on macOS, the easiest way to get to Terminal is to search for it using Spotlight (CMD+Space or click the magnifying glass at the top right of your screen. On Windows, in the search box at the bottom left of your screen, type cmd and hit enter.):

  1. cd ~%USERPROFILE%/Desktop (Here we’re just moving to the Desktop as the script will be creating some folders. Feel free to change this to another directory if you wish such as Documents.)
  2. pip install safetyculture-sdk-python
  3. iauditor_exporter --setup
  4. cd iauditor_exports_folder
  5. iauditor_exporter --format csv

The above commands should get the export started. For advanced configuration and further details, please check out the guidance found here. For existing users, update instruction can be found here.

Limitations

The iAuditor CSV Exporter is limited in scope.

  1. Cannot restrict the CSV export to specific item types. All items are exported for each inspection.
  2. Cannot restrict what information is exported for each item. All information is exported for every item.
  3. Cannot restrict which inspections export using a template filter. In bulk export mode, all inspections are exported.
  4. In bulk export mode, a CSV file is created for each unique template. Inspections are appended to an existing CSV file if one exists for the inspection template. If the CSV file for the inspection template does not exist, a new file is created.
  5. Cannot limit the CSV Exporter to only selected templates
  6. If you update an inspection that has already been exported, it will be appended to the CSV file a second time

Format

Column HeaderItem TypeDescription
ItemTypeStringThe type of response selected for questions in the template editor.
e.g. signature, inspection date, location
LabelStringThe label of the questions written in the template editor.
e.g. Are personal protective equipments provided?
ResponseString / Number / BooleanThe response label or value given to a question.
e.g. Safe, TRUE, 18
CommentStringThe relevant notes added to multiple questions.
e.g. This machine is unsafe due to leakage.
MediaHypertextReferenceStringThe relevant hyperlink reference for any images attached to the specific question. See our documentation here for more information on getting the media file.
e.g. https://api.safetyculture.io/audits/audit_0d2ff6f5da4247e8a0ed34a011c4c3d6/media/53e8b154-18f3-4194-a32e-058020de55e4
LatitudeNumberThe latitude of the location data captured for location questions.
e.g. -33.8858784
LongitudeNumberThe longitude of the location data captured for location questions.
e.g. 151.2116864
ItemScoreNumberThe score achieved for the item. See this support article for more information on setting question scores.
e.g. 3
ItemMaxScoreNumberThe maximum score possible for the item. See this support article for more information on setting question scores.
e.g. 5
ItemScorePercentageNumberThe score percentage achieved for the item, calculated by ItemScore ÷ ItemMaxScore × 100.
e.g. 60
MandatoryBooleanThe indicator for whether the item/question is marked as mandatory or not. TRUE if the item is mandatory, FALSE if the item is not. See this support article for more information on setting mandatory items.
e.g. TRUE
FailedResponseBooleanThe indicator for whether the response to the item is marked as failed or not. TRUE if the response is a failed response, FALSE if the response is not. See this support article for more information on setting failed items.
e.g. FALSE
InactiveBooleanThe indicator for whether the item/question is inactive under a logic field. TRUE if the item is not triggered by a logic field response in the inspection. See this support article for more information on using logic fields.
e.g. TRUE
ItemIDStringThe unique identifier of the item/question. This can be used to identify the same items over different inspections, even if the item label changes over time.
e.g. 192e714b-373a-41e9-82da-db1473c7317b
ResponseIDStringThe unique identifier of the response selected. This can be used to identify the same responses over different inspections, even if the response texts changes over time.
e.g. 060ace00-1f61-468e-9c42-918fa93badcf
ParentIDStringThe unique identifier of the item, to which the current item/question is nested under in the template editor.
e.g. 6d27fc5d-47eb-4684-b5ab-3d75e462c49d
AuditOwnerStringThe full username of the account that created the inspection. See this support article for more information on changing usernames.
e.g. iAuditor Administrator
AuditAuthorStringThe full username of the account that last edited the inspection.
e.g. iAuditor Auditor
AuditNameStringThe name of the inspection. See this support article for more information on setting inspection title formats (naming convention).
e.g. 5 Feb 2020 / iAuditor Auditor / DOC000032
AuditScoreNumberThe total score achieved for the inspection.
e.g. 78
AuditMaxScoreNumberThe total maximum score possible for the inspection.
e.g. 100
AuditScorePercentageNumberThe score percentage achieved for the inspection, calculated by AuditScore ÷ AuditMaxScore × 100.
e.g. 78
AuditDurationNumber (seconds)The number of seconds taken from start to completion of the inspection. This is measured when the inspection is conducted on the mobile iAuditor app only.
e.g. 180
DateStartedStringThe date and time the inspection was started in Coordinated Universal Time (UTC). Format is DD/MM/YY HH:MM.
e.g. 5/2/20 0:26
DateCompletedStringThe date and time the inspection was completed in Coordinated Universal Time (UTC). Format is DD/MM/YY HH:MM.
e.g. 5/2/20 0:29
DateModifiedStringThe date and time the inspection was last modified in Coordinated Universal Time (UTC). Format is DD/MM/YY HH:MM.
e.g. 6/2/20 0:10
AuditIDStringThe unique identifier of the inspection.
e.g. audit_0d2ff6f5da4247e8a0ed34a011c4c3d6
TemplateIDStringThe unique identifier of the template used for the inspection.
e.g. template_d8f3011bb7f843dcb699871eaa528361
TemplateNameStringThe name of the template used for the inspection.
e.g. Scope of Work for Construction
TemplateAuthorStringThe full username of the account that created the template used for the inspection.
e.g. iAuditor Administrator
ItemCategoryStringThe label of the page or section, to which the item/question is nested under in the template editor.
e.g. Page 1
DocumentNoNumberThe document number of the inspection. This is a title page specific type of response. See this support article for more information on using document numbers.
ConductedOnStringThe date and time selected for the "Inspection date" type of response. Format is in ISO 8601 standard: yyyy-mm-ddThh:mm:ss.sssZ. This is a title page specific type of response. See this support article for more information on using title page questions.
e.g. 2020-02-05T00:26:05.000Z
PreparedByStringThe auto-populated username for the "Person" type of response. This is a title page specific type of response. See this support article for more information on using title page questions.
e.g. iAuditor Auditor
LocationStringThe auto-populated location for the "Inspection location" type of response. This is a title page specific type of response. See this support article for more information on using title page questions.
e.g. 2 Lacey St, Surry Hills NSW 2010, Australia
PersonnelStringnull
ClientSiteStringnull
AuditSiteStringThe label of the Site selected for the inspection. See this support article for more information on using Sites.
e.g. Sydney CBD
AuditAreaStringThe label of the Area, to which the Site selected for the inspection belongs to. See this support article for more information on using Sites.
e.g. New South Wales
AuditRegionStringThe label of the Region, to which the Area of the Site selected for the inspection belongs to. See this support article for more information on using Sites.
e.g. Australia

 

Was this article helpful?

We love your feedback. Please tell us what you think.


Yes No
Care to share a bit more so we can continue to make improvements for you? Care to share a bit more so we can make this article even better for you? Thanks for your feedback!