This guide will explain how you can import measurement data (in this example groundwater levels) into the portal. It is assumed that you already have DomainObjects created for everything you want to import.
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
- Timestamp
- Value to import
Try to match the names of the columns to those used in the portal.
Now go to your portal and follow these steps:
- Open the Import page in your portal (if you don't see this page please contact our support)
- Click on New Import Job
- Select the CSV file and set the properties requested, the default should be ok. For more information on these settings please see the portal help (the "i" icon)
- When ready click on Upload
- 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
- 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)
- Notice the bottom of the page for any warnings
- If needed correct these warnings with the Mappings option, use the PK checkbox to indicate that that field is used to identify an object
If you use the same column names as the portal uses this should already be set correctly - If needed click Validate Job again until all warnings are solved
- When everything looks OK click on Import Data
- 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
0 Comments