Import/Export Textlists

Overview

This command (category Text list provides the data exchange with other programs such as Excel. The data format in use is .csv (comma-separated values). When executing the command the following dialog box displays:

Import/Export text lists dialog box

By entering the corresponding paths or by making use of the input assistant (...) the files to be imported, exported, or compared may be specified. Which of the actions should be executed, may be defined by activating the corresponding item in the lower part of the dialog box:

Example - Import of a Replacement File

The replacement file will be executed top/down. Thus, the change history can be accounted for.

The command defines what to do with a text line. The only command available yet is REPLACE. It will have the following effect:

Normally, the text entered in Default column will be replaced by the new text. In the example, Cancel ? will be replaced by Cancel and Do you want to register ? by Do you really want to register ?. Simultaneously, the texts of all visualization elements will be adjusted, that is, the old text entries within the visualization elements will be replaced.

In the case where the new default text is already contained in the Default field of another row of the text list, the row containing the entry to be replaced will be deleted completely. The visualization elements involved receive the corresponding entries of the remaining row with the same default entry. In the example, this will happen for the default entry Do you really want to register ?! that should be replaced by Do you really want to register ?. Due to the change history, there already a row will exist with this default entry when the related REPLACE command shall be carried out. To avoid multiple occurrences of the key, the row containing the old default text Do you really want to register ? will be deleted completely from the text list.

Export

• Exporting text lists all modifications within the project are compared to an external file. A new export file will be created according to the following rules:

Example - Export of a .csv-file

Export only text differences

• If this option is activated, only the lines differing from their corresponding line in the different versions are included in the export file. Such a difference file is suited as input for translation purposes. As the file is intended to be kept as small as possible, missing items in the actual text lists will not be treated as differences.

  Example - Export of text differences only

  NOTE: For locating the corresponding data sets the Default column is used for the GlobalTextList and the Id column for all other text lists. Therefore, the Id column is empty for all data sets of the GlobalTextList.

Example - Import of .csv-file

Data content of external file:

Data content of text list of project before import:

During the import, all differences are incorporated into the project. The 2 lists are adapted so that the following text list will result in the project.

Example - Export of a .csv-file

Data set of external file:

Data content of text lists of project before export:

During the export, all differences are incorporated in the external file. The 2 lists are adapted so the following external file will be created.

Data content of text lists from project after export:

Example - Export of Text Differences Only

Data content of external file:

Data content of text lists of project before export:

During the export all lines differing from the corresponding ones (line 2, 3 and 5 of the actual list) are included in the export file.

Data content of external file after export: