Importing Data into Sub Forms

Importing Data into Sub Forms

Importing Data into Sub forms

To add a new sub-form into an inspection from Excel you need to follow the following steps. 

Preparing the data in a spreadsheet

To get a spreadsheet with the correct headers for a sub-form please contact Clarinspect Support.  


Once you have a spreadsheet you can enter the data - one item per row. 


Entering text: Simply type into the relevant cell


Entering list items: You will need to know the exact list items and their ‘lookup’ value. In Clarinspect, every item in a drop down list has the word you see and a ‘lookup value’ in the background. Ask Clarinspect Support for the lookups for your drop down lists.  


GPS Fields : when loading GPS data from excel you need to ensure it is in the format shown below; "latitude,longitude". No spaces and only decimal numbers separated by a comma. There is a single comma in the middle separating the latitude and longitude coordinates. It can have a negative at the front of a number and the decimal point is fine too.


For example: -38.337244,176.391744


Date and Time Fields: These needed to be loaded as YYYY-MM-DD and HH:MM:SS

Save in a format for loading

Save the file as an .xlsx (for your records) and also as a CSV UTF-8 (this is what you will be importing back into the hub). 

Importing Data

In your inspection on the Hub, sub-forms that have a green drop down will have the option to import data from a CSV file.

Follow the prompts as below.


 



    • Related Articles

    • Importing Data into a Clarinspect Work Package

      Importing data into a Clarinspect work package Preparing the data in a spreadsheet You will need to set up a spreadsheet with the right headers. Specifying text for text fields is easy, but if you want to load a specific value into a drop down you ...

    • Bulk Editing Through Importing

      You may want to bulk edit a number of inspections within a Work Package. You will first need to export your data. Instructions can be found here: Exporting Data from the Hub. This is what the output will look like. You should save it as a master copy ...

    • Using Common Data

      Overview Common data is added to a Work Package because it contains information that is used to fill in fields on each inspection done in that Work Package, or because there is supplementary information to show in the App that does not go into the ...

    • Exporting Data from the Hub

      Exporting Data from the hub This brief guide is to step you through exporting data out of the hub. You can export your data as a .zip file with all photos and data, or as a .xlsx Excel file. Step 1: Find your data Log onto the hub ...

    • Removing Data Using a Bulk Edit File

      Removing Data using a Bulk Edit File To remove a field from your inspection, you need to delete the value from your spreadsheet before loading. There is a constraint that at least one other field for that inspection has a value, otherwise that row is ...