The process for importing CSV data is exactly the same as it is for AGS data.
The CSV file name must be the group name as it appears in the Project Explorer and the first row of the CSV file must contain headers with the same name as appears on the top of the data grid. In the example below the header would be "Location ID" and the filename would be "Location Details.csv".
An easy way to get an example CSV file is to use the CSV icon on the data grid ribbon to export to CSV. This file can then be edited and imported back into OpenGround Cloud Professional using this CSV import routine.
CSV Import Format Options
When importing a CSV file, an option for Format Options will become available allowing for the selection of the formats of the incoming data.
Selecting this option will open a window where all of the required settings can be set. This helps the application process the incoming data correctly.
The following settings will effect how the number values will be handled in the incoming data. A preview of the applied values is presented in the Example at the bottom of the form.
- Delimiter - This is the character that is used to separate the different values inside of the file (for a CSV file, this will usually be a comma but this can be adjusted as needed)
- Quote Character - This is the character that is used to surround the different values inside of the file (for CSV files, this is usually a double quote but this can be adjusted as needed)
- Decimal Separator - Allows for a character to be placed in between integer and decimal values.
- Digit Grouping Symbol - Allows for a character to be placed in between the values selected in the following Digit Grouping option.
- Digit Grouping - Allows for the selection of when the previous Digit Grouping Symbol character gets inserted into the number string.