Importing and exporting data
Jump to navigation
Jump to search
« Page as of 2016-09-16, editions Mobile 3.9.7, Desktop 1.0.3 »
Data import and export is supported via "comma-delimited values" (CSV) files. Such files were designed to enable data import to and export from fielded-data applications, mainly database and spreadsheet applications.
To import data from CSV files:
- Locate the file to be imported to local storage — the SD card or internal storage.
- In the Library Entries List screen, open the Action menu and select Import and export... > Import from CSV.
- The File Manager card will pop up. Select the desired CSV file.
- Columns of the file that match fields defined in the library, if any, will be listed. The card allows the user to change the field delimiter (comma by default) and/or text qualifier (double quote by default).
- If there are any matching columns, press the Import button to perform the import.
When you import data from CSV files, new entries are created each time.
CSV file format
- The name of a column must match the name of the corresponding library field.
- The file must contain a column with the field that is the name of the entry.
- The file must be encoded in UTF-8 format.
Data format notes
- Date
- The date must be in the same format as in the system settings. You can review and modify the date format required for importing in the application's general settings.
- Date/Time
- The values are separated with a space; the date comes first, and then comes time in the HH:MM format.
- Single-choice list
- The value being imported must already be in the parameters of the corresponding field.
- Boolean (Checkbox)
- The following values are acceptable for the truth value: true, yes, 1
- Location
- "latitude,longitude"
- Rating
- A number from 0 to 5.