Importing and exporting CSV files.

Importing entries from a CSV file.

To import data from CSV files, do the following:
  1. Copy the file you want to import to the sd-card.
  2. Open the Library menu and select Import and export... > Import from CSV.
  3. Select CSV-file from file manager.
  4. After you select the file, you will see the list of columns found in the file which correspond to the entry fields.
  5. 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:
  1. Open the Library menu and select Import and export... > Export to CSV.
  2. Enter the name of the CSV file and press the OK button.