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 not imported.
In your excel file, remove the top row
Remove all columns APART from; _id, _uuid, and the column holding the data you want removed
In the column of data you want to remove, keep the column header but delete the data itself
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).
Load the file
Go back to the hub. Choose the .csv file and click on ‘Import’.
You will be notified by email when the import has been completed.
The inspections will now be in ‘Draft’ in the hub. ‘Edit’ each inspection, then choose ‘Save and Complete’, then submit the inspection to generate an updated report.
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: ...Using Common Data
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 ...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 ...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 ...Using Approvals
Using Approvals Once an inspection is approved it is uneditable. This stops data changing if it is going to be delivered to a client or an external database. Using Approvals Clarinspect can enable this feature for you. When they do, a new menu item ...