Common Requirements for Files
This page describes common requirements for files that are used to import and export users, departments, and other data.
Character Encoding
The following character codes are available.
Import from File
- Shift-JIS (Japanese)
- Latin1 (Western European)
- GBK/GB2312 (Simplified Chinese)
- UTF-8 (Unicode)
Export to File
- Shift-JIS (Japanese)
- Latin1 (Western European)
- GBK/GB2312 (Simplified Chinese)
- UTF-8 (Unicode)
- UTF-8 with BOM (Unicode)
Delimiter
The following delimiters are available.
- Comma (,)
- Semicolon (;)
- Tab
- Space
Notations for Special Characters
Delimiter
To include the same character as a delimiter in the field value, enclose the value with double quotation marks (").
For example, assume that you import a file that uses comma (,) as the delimiter.
If you want to specify '1,000' as the field value, enter the value as follows in the file.
abc,"1,000",def
Double quotation mark
If the field value contains double quotation marks ("), you should specify two consecutive double quotation marks ("").
For example, to specify 'xy"z' as the field value, enter the value as follows in a file.
abc,xy""z,def