CSV Files
Many programs support CSV file format.
Translation lists can be exported in CSV format for processing in Microsoft Access or Microsoft Excel, for example. This interface can be configured so that the strings can be reimported after processing.
To export translation lists in the CSV file format, choose the lists to be exported and as Export-Format Customizable Text Export. Click on the Settings button to configure the export.
Encoding
Select in the drop down box Encoding, whether the strings shall be stored as ASCII- or Unicode characters. Unicode character can also be stored in "Big Endian" format. Use Unicode if you want to export strings in Asian languages or if you want to export translation lists that use different Codepages for source and target language.
Separator
Select in the drop down box Separator which character is to be used to separate the data fields. If you use comma or semicolon as separator, text resources will be enclosed with ("). If you choose tabulator as separator, these text delimiters will not be used. Use comma or semicolon as the separator if you want to export data to Microsoft Access, Microsoft Excel or other editors and later want to re-import the changed string resources to Passolo. Choose tabulator as separator, if you want to export in Passolo glossary format for example.
Write strings that are already exported
If you activate this check box, strings that are already translated will be exported.
Write strings that are not translated
If you activate this check box, strings that are not yet translated will be exported. If you also activate the check box Write strings that are already exported, all strings will be exported.
File will be reimported in Passolo
If you activate this check box, the file format will be adapted so that the strings can be reimported. In any case the export file must contain a header line and the ID as the first column. The necessary changes are carried out automatically.
Add a header line
If you activate this check box a header line describing the data fields will be written to the first line of the export file. This information can for example be used by Microsoft Access to assign the names of the database fields automatically.
Column header for languages
You can choose, whether the numeric language ID or the language code shall be used in the header line for the source and target language.
Column Selection
The list Columns in File shows all data fields which the export file shall contain. To add a data field, select the corresponding entry in the list of Available Columns and click << Add. To delete a data field from the list, select the entry in the list of Columns in File and click Remove >>.
The order of the data fields in the list Columns in File determines the order in data will be written in the export file. You can change the order of the data fields by selecting a data field in the list and pressing Move up or Move down to move its position.