Importing 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.

CSV import rules:

• 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 define the languages, e.g. key,pl,en,
• keys and languages must be unique,
• the import operation completely overwrites the dictionary content — the keys and languages existing before the import will be removed.

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 have the data appear in a new dictionary, you must first create that dictionary (instruction: 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 — a popup will open 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 file selected

3

Starting the import

After selecting the 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 problems

The file will not be imported if:

• the CSV structure is incorrect,
• there is no 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