Importing Data into a Clarinspect Work Package

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 will need to know the lookup used. Ask Clarinspect for the lookups for drop down lists etc.


To get the headers, create a dummy inspection in the Hub of the type you want to load, then export it as xlsx. (For more information on how to export data please read Exporting Data from the Hub).


When you open this you will see two two rows of headers - one for humans to read and one for computers. Row 2 are the field names the software uses.


This is what the output will look like:



1. DELETE ROW 1

2. You can also safely delete columns A → J (unless you are planning on doing a bulk edit, in which case please read Bulk Editing through Importing).

3. Add in the data to the relevant columns that you are wanting to import.


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 the data

You can pre-load your Workpackage with data about the items that are being assessed.


  1. Click on the 'Workpackages' link in the Left Menu to show the Workpackage List.

  2. Then click on the Workpackage name to open it.


Now choose the file to import, go to the “Import inspections from csv” on the lower right side of the screen.


If you have more than one type of inspection on your Work Package you will need to choose which type you are loading the data into. Click on the drop down list (for example,  “Bridge Inspection v0.1” in the image below) to select the template format you want to import. The CSV file and the assessment template need to be appropriate for the target template you are trying to load.

​


  1. Click on the 'Choose File' button and browse to a file with the data for the specified system to load.

  2. Click on the 'Import' button only when you have chosen a file to load.


Note: The loading of data is done in the background, and you will be notified by email when it has finished. The 'Import' button is only enabled if you have chosen a File.You can repeat this for each template on the workpackage if you have many assigned.

    • Related Articles

    • Bulk Editing Through Importing

      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: ...

    • 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 ...

    • Adding a Work Package Manager

      Adding a Work Package Manager A Work Package manager is an operator of the Hub who has been granted elevated permissions within a Work Package. This enables Administration type tasks to be delegated within the confines of a Work Package. This ...

    • Set up a Work Package for your Project

      Set up a Work Package for your Project Checklist Here are the things you need to check before you set up a new Work Package to hold the work for your site: Staff Are the staff you want to use added to your organisation? Have you added Monitors ...

    • Adding Staff to a Work Package

      Adding Staff to a Work Package To add new members to a work package in Clarinspect. NOTE: Only Administrators can add and remove Staff, or change assignments. Click on the ‘Work Packages': Click on 'Edit’ By clicking on the ‘Staff on Work Package’ ...