Internationalization and CSV Files
Importing and exporting data can be done by using a Comma-Separated Values (CSV) data file or a CSV template file. This section explains how the availability of different languages (Internationalization) impact the various CSV files created, used, imported, or exported.
Note: Number formatting is not supported for Symbols that are based on a right-to-left language such as official languages of Afghanistan or Hebrew.
Generic CSV files
Language preferences are detected from the Preferences settings (Region Format), for both CSV data files and CSV template in:
- All column headers
- All informational text
If importing a CSV file fails, the import error file displays the system generated error messages in the preferred language.
If importing a CSV file fails because of form validation errors, then the custom error message displays the message in the preferred language.
Notes:
- If translation is not available for a custom error message, then the source string is displayed.
- Before importing a CSV file, always check the Preferences settings to see the allowed format and number formatting.
- When importing, or exporting, a CSV file, the date format follows the Preferences window (Region Format) Date Format settings.
Additional information about exporting and importing CSV files
When importing and exporting of a CSV file is conducted by users with two different language settings (for example, French and German), the data entered into an exported file must match the original language set.
Example
The CSV template Export has been done in French and the template is being used by a German User. If the German User enters data without changing the column structure and Imports the file, the Import action will fail and an error message will appear in German, indicating the error.
See Also
Importing Data from an Outside Data Source
Overall Steps for Importing Data
Exporting the CSV Template to Your Machine (Integration)
Importing CSV File into Unifier
Using CSV File to Import Attachments
Internationalization and Web Services
Last Published Friday, June 21, 2024