File Format for User Details
This page describes the format of a file for adding or changing users.
For details on how to import a file, refer to the following page:
Adding and Editing Users in Bulk
Notes on Creating CSV Files
- Fill in a field with an asterisk (*) when you do not want to update the value of the field.
- You cannot use an asterisk (*) for new user's password.
- You cannot use the feature to inform users of their passwords and the login method by e-mail.
Fields in File Format
Each row contains the information of one user.
Login Name | Display Name | New Login Name | Password | Surname | Given Name | Phonetic Surname | Phonetic Given Name | Localized Name | Language of Localized Name | … |
---|---|---|---|---|---|---|---|---|---|---|
kato | Barbara Miller | * | mmm | Kato | Daisuke | Kato | Daisuke | Daisuke Kato | en | … |
tanaka | Manami Tanaka | * | mmm | Tanaka | Manami | Tanaka | Manami | Manami Tanaka | en | … |
yoshida | Makoto Yoshida | * | mmm | Yoshida | 誠 | Yoshida | Makoto | Makoto Yoshida | en | … |
Field Name | Required | Description |
---|---|---|
Login Name | ✔ |
|
Display Name | ✔ | About the Fields to Register Names |
New Login Name | ✔ |
Rules for Login Name
|
Password | ✔ | Rules for Password
|
Surname | ||
Given Name | ||
Phonetic Surname | ||
Phonetic Given Name | ||
Localized Name | If you specify "Localized Name", you must also specify "Language of Localized Name". | |
Language of Localized Name | Specify one of the following:
|
|
E-mail Address | ||
Status |
|
|
Language | Specify one of the following: Leaving this field blank sets the language to "Use Web browser settings".
|
|
Time Zone | Refer to "List of Time Zones" to specify the ID of the time zone. Leave this field blank to set the time zone to the system time zone. |
|
Phone | ||
Extension | ||
Mobile Phone | ||
URL | ||
Employee ID | ||
Hire Date | Specify a string in either of the following formats: "YYYY-MM-DD" or "YYYY/MM/DD" | |
Birthday | Specify a string in either of the following formats: "YYYY-MM-DD" or "YYYY/MM/DD" | |
About Me | ||
Display Order | Specify an integer between 0 and 99999999. Display Order |
|
Skype Name | ||
To Be Deleted |
|
When "User Details" Has Custom Fields
If any custom field such as the fields shown below has been added to the User Details, you must also include that field in the CSV file to be imported.
If the added custom field does not exist in the CSV file, an error occurs when importing the file. You must include all the fields including custom fields in the CSV file.
Where to Add Custom Fields in the CSV File
Information on custom field needs to be entered in the column that follows the "To Be Deleted" field.
When there are multiple custom fields, list them according to the display order.
Login Name | Display Name | New Login Name | ... | Skype Name | To Be Deleted | Office | Seat |
---|---|---|---|---|---|---|---|
kato | Barbara Miller | * | … | daisuke-kato | * | Head office | 20th floor |