File Format for User Details

Article Number:020155

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.

Example CSV 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 Yoshida Makoto Makoto Yoshida en
Fields and Their Values
Field Name Required Description
Login Name
  • When registering a new user:
    Enter a name that does not match with an existing login user name.
  • When changing an existing user's login name:
    Specify the current login name.
  • When changing information other than the existing user's login name:
    Specify the current login name.
Display Name About the Fields to Register Names
New Login Name Rules for Login Name
  • When registering a new user:
    Specify a value that is the same as the value in "Login Name" or "*".
  • When changing an existing user's login name:
    Enter a new login name.
  • When not changing an existing user's login name:
    Specify "*".
Password Rules for Password
  • When registering a new user:
    Enter a new password. Note that you cannot use "*".
  • When changing the existing user's password
    Enter a new password.
  • When not changing the existing user's password
    Enter "*".
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:
  • Japanese: ja
  • English: en
  • Simplified Chinese: zh
  • Traditional Chinese: zh-TW
E-mail Address
Status
  • User who uses the service:
    Specify '1'.
  • User to be deactivated:
    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.
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 deleting a user:
    Specify '1'.
  • When adding or updating a user:
    Specify "*" or leave the field blank.

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.
Screenshot: Edit User screen. The custom fields are highlighted 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.

When Custom Fields Are in the Display Order of "Office", "Seat"
Login Name Display Name New Login Name ... Skype Name To Be Deleted Office Seat
kato Barbara Miller * daisuke-kato * Head office 20th floor