File Format for User Information
This page describes the file format for adding or changing users.
For details on how to import a file, refer to the following page:
Adding or Changing Users and Departments Using a File
File Format
Each row contains the information of one user.
Each row requires the following items. These items are mandatory and cannot be omitted.
- Login Name
- Display Name
- New Login Name
- Password
- Surname
- Given Name
- Phonetic Surname
- Phonetic Given Name
- Localized Name
- Language for Localized Name
- E-mail Address
- Status
- Language
- Time Zone
- Phone
- Extension
- Mobile Phone
- URL
- Employee ID
- Hire Date
- Birthday
- About Me
- Display Order
- Skype Name
- Delete
For details on the items above, refer to the following page:
Items of User Information
Items to be entered in a file
Fill in a field with an asterisk (*) when you do not want to update the value of the field.
Login Name
To add a new user
Enter a string that does not duplicate existing users' login names.
To change the information of an existing user
Specify the current login name.
Even if you want to change the current login name, specify the current login name in "Login Name". A new login name should be specified in "New Login Name".
Display Name
"Display Name" must be a string.
New Login Name
To change "Login Name"
Enter a new login name.
To add a new user, or to change information other than "Login Name"
Enter a string that is identical to "Login Name", or enter "*".
Password
To add a new user
Enter a password.
If a user is added by specifying "*", a valid password will not be set for them. They need to take the following actions to log in.
- Ask the Kintone Users & System Administrator to set a password
- Log in with SAML authentication
To change the password of an existing user
Enter a new password.
Localized Name
Other than the default "Display Name", you can enter a display name for each language.
Displaying Localized User Names in Display Language
Language of Localized Name
If you specify "Localized Name", this item is mandatory.
Specify one of the following:
- Japanese: ja
- English: en
- Simplified Chinese: zh
- Traditional Chinese: zh-TW
Status
Specify one of the following:
- To use Kintone
Specify '1'. - To deactivate a user
Specify '0'.
Language
Specify one of the following:
Leaving this field blank sets the language to "Use Web browser settings".
- Japanese: ja
- English: en
- Simplified Chinese: zh
- Traditional Chinese: zh-TW
- Use Web browser settings: auto
If the Web browser is configured to use a language other than Japanese, English, or Chinese, Kintone will be displayed in English.
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.
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"
To Be Deleted
Specify one of the following:
- When deleting a user
Specify '1'. - When adding or updating a user
Specify "*" or leave the item blank.
Example File
| 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 | Makoto | Yoshida | Makoto | Makoto Yoshida | en | … |
When User Information Has Custom Fields
If any custom fields have been added to user information, you must also include the corresponding columns in the file to be imported.
Custom Fields
If the corresponding columns for added custom fields do not exist in the file, an error occurs when importing the file.
Where to Add Custom Fields
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 |
If You Receive a "Language for Localized Name Is Not Valid" Message
This section provides a solution when importing user information from a file displays the "Language for Localized Name is not valid" message.
Example of an Error Message
Error messages are displayed in "Import Results".
Only "ja", "en", "zh", or "zh-TW" can be entered.
Cause and Solution
The error message above is displayed when the value specified for "Language for Localized Name" is not correct.
It is caused by one of the following reasons:
- Cause 1: You imported a file without selecting "Skip header row" even though the file has field names in the first row.
- Cause2: The specified text cannot be used for "Language for Localized Name".
Perform one of the following solutions respectively.
When you imported a file without selecting "Skip header row"
An error occurs when you import a file without selecting "Skip header row" even though the file has field names in the first row.
Select "Skip header row" when importing a file.
When the specified text cannot be used for "Language for Localized Name"
An error occurs when you enter a string that cannot be used for "Language for Localized Name".
Check Language for Localized Name and correct "Language for Localized Name" for the line that is written in the error message.
If you do not want to specify "Localized Name", leave the item blank.