Importing and exporting CSV files.
Importing entries from a CSV file.
|
To import data from CSV files, do the following:
- Copy the file you want to import to the sd-card.
- Open the Library menu and select Import and export... > Import from CSV.
- Select CSV-file from file manager.
- After you select the file, you will see the list of columns found in the file which correspond to the entry fields.
- Press the Import button.
When you import data from CSV files, new entries are created each time.
|
CSV file format.
|
The name of a column must correspond to the name of an entry field.
The file must contain a column with the field that is the name of the entry.
The file must be encoding in UTF-8.
Memento allows you to import only fields of certain types: text, integer, real number, date, date/time, rating, currency, single-choice list, multiple-choice list, location, boolean, hyperlink.
Data format notes:
Field type |
Format and 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 |
The following values are acceptable for the truth value: true, yes, 1 |
Location |
"latitude,longitude" |
Rating |
A number from 0 to 5. |
Before you import entries, it is recommended to back up your libraries.
|
Exporting data to CSV
|
To export data to a CSV file, do the following:
- Open the Library menu and select Import and export... > Export to CSV.
- Enter the name of the CSV file and press the OK button.
|
|