Importing a CSV dictionary

The import mechanism allows you to populate the dictionary with data from a CSV file. This makes it possible to edit the dictionary content in any program and then transfer the result to Eximee Designer.

circle-info

Rules for CSV import:

  • only CSV files can be imported,

  • the separator in the file must be a comma,

  • the CSV file must have a first row with a header that specifies the column names:

    • the "key" column must be first,

    • the remaining columns specify languages, e.g. key,pl,en,

  • keys and languages must be unique,

  • the import operation completely overwrites the dictionary content — existing keys and languages before import will be deleted.

Figure 1. Example of a dictionary in CSV format to be imported

CSV file import

Import is possible on an existing request in edit mode. To make the data appear in a new dictionary, first create that dictionary (instructions: Creating a new dictionary).

Figure 2. New dictionary window with the Import from csv button
1

Starting the import

Clicking the Import from csv button will open a popup allowing you to add a CSV file.

2

Selecting a CSV file

Add a file by clicking the area Choose or drag a csv file to import or drag the file into this field.

Figure 3. Dictionary import window with no file selected
Figure 4. Dictionary import window with a selected file
3

Starting the import

After selecting a file, click the Import button — the data import will begin. If the file is invalid or another error occurs, an error message will appear at the bottom of the window.

4

Saving the dictionary

After a successful import, save the dictionary so that the entered data is preserved.

Figure 5. Completed dictionary after a successful import

Possible issues

The file will not be imported in the case of:

  • an incorrect CSV structure,

  • missing first row with a header,

  • the "key" column is not first,

  • duplicate keys,

  • duplicate languages.

In such cases, an error message will appear:

Figure 6. Error message during CSV file import

Last updated

Was this helpful?