How to import Manual (Validation) Measurements via the Import Data Page

For regular measurements see: How to import Manual (Validation) Measurements

This guide will explain how you can import manual validation measurements through the "Import Data" page in the portal. These measurements differ from regular measurement data as they have a "validator" field (the person who took the measurement) and will be displayed as red dots in the graph.

Make sure you have your exported data ready in a supported format (csv). For example in Excel this can be done by File -> Save as

Make sure to select "CSV" on the bottom of the page.

You'll need at least the following columns:

• Object ID or Description (+optional the project code)
• Timestamp
• Measurement (the value to import), choose from the following
  
  • measurement_relative_to_wellhead -> you did your measurement against your wellhead
    
  • measurement_relative_to_altitude_reference (e.g m NAP)
• Validator

What	Why	CSV header
Object ID	Can be used to target a specific tube directly	#object_id
Description	The name of the tube	#groundwaterwell_description
Project Code	The project code of the tube	#groundwaterwell_project_code
Timestamp	The time your measurement was taken	timestamp
Measurement - Relative to wellhead	Measurement as measured referenced to the well head	measurement_relative_to_wellhead
Measurement - Relative to wellhead	The Measurement is already a NAP value	measurement_relative_to_altitude_reference

Note: The # is added to let the import see this field is regarded as the primary key.

The resulting file could look something like this:

It is sufficient to only supply the description if this is unique in the portal. If not you can either supply the project code or the object ID.

Now go to your portal and follow these steps:

1. Open the Import Data page in your portal
2. Click on New Import Job
3. Select the CSV file and set the properties requested. 
4. When ready click on Upload
5. You will be redirected to the detail view, on this page it is also possible to upload additional files for when you for example have a single file per object
6. It is wise to first click Validate Job to make sure your uploaded files are correct (please note that it can take some time for the validation process to finish)
7. Please check the bottom of the page for any warnings
8. If needed correct your input file and try again. Simply remove the uploaded fine and click Validate Job again until all warnings are solved
9. When everything looks OK click on Import Data
10. You can view the progress of your import by looking at Status in both the detail view as the list, you do not need to keep the import page open. When done the status will be set to Imported

You should now see your measurements in the graph view.

If you see some errors validating you can go to the regular Import page and check if the mapping is correct.

If not: correct the mapping here (no need to upload a new file). Make sure that the PK checkbox is checked for any field that makes your measurement unique. Usually this is project_code + description, however if you have an object_id that field will be the PK.