CSV Import Dialog

Previous pageReturn to chapter overviewReturn to Top Next page












Some importers, such as importing Piezometers, allow the file data to be in a flexible CSV (comma-separated values) format, rather than requiring a specific data schema. For these, a common CSV import options dialog is presented in order to specify how the data in the file maps to the required fields for the object being imported. There are two inputs required to consider the import specification complete: assigning all required fields to columns, and specifying the first non-header row.


CSV data files may have one or more header rows that contain either metadata describing the data that follows, or specify the titles of the columns for the data. These rows must be skipped by the importer by setting the first non-header row option in the dialog. For example, if there is a single header row that describes the column data, the first non-header row should be set to 2. The rows that will be skipped are then grayed-out in the preview data table.


The available fields are listed in the Available Data Fields group box, along with a description of each field. Some fields are required, while others may be optional. Any required fields that have not been assigned to a column yet are colored with red text.


The File Data Preview pane shows the contents of the data file (up to 50 lines) with an attempt to separate the data into columns based on comma delimiting. This pane is also used to map columns to fields. This is done by clicking the header row of the data table for each column (the initial text shown is <click to assign>). When a column header is clicked, a dialog will be presented to input the field that should be associated with that column.


Once all the required inputs are given, the dialog OK button is enabled. Note that this does not include any checks regarding whether the data can successfully be interpreted as required by the importer.