Adding or Changing Users and Departments Using a File
This page describes the steps to add or change data such as users, departments, job titles, and groups (or roles) in Kintone in bulk using text files.
Types of the Data That Can Be Changed Using Files
As for the data in Kintone that can be changed using files, refer to the following page:
How to Prepare Import Files
To prepare an import file, export the data in Kintone or download a template file.
For details on the file formats for each data, refer to the following page:
Notes on Changing the Data Using Files
When you add users using a file, you will not receive an e-mail notifying password and login information.
An administrator must notify users of password and login information.
When you change department information, you must include all necessary departments in a file.
Importing a file deletes the existing departments, unless the departments are specified in the import file.
We recommend that you export existing departments to a file and edit the exported file to create an import file.
For details on how to export a file, refer to the following page:
Exporting Users, Departments, and Other Information to Files
Groups (or Roles)
You cannot specify the conditions for dynamic groups when you use a text file to update information.
Add dynamic groups using a file, and specify conditions for the added dynamic groups.
Specifying Conditions for Dynamic Groups
Click the gear-shaped menu button in the header.
Click Users & System Administration.
Click Import from File.
From the "Contents to Import" dropdown list, select a type of data to be imported.
- User available services
- Departments to Which Users Belong
- Job Titles
- Groups (or Roles)
- Groups (or Roles) to Which Users Belong
Click Browse and select a file to import.
Select "Skip header row" if the first line of the file contains field names.
Select "Character Encoding".
Select "Shift-JIS (Japanese)" if the file contains data in Japanese characters.
In "Delimiter", specify one of the following:
Use "Preview" to check that the data is correct.
"Preview" displays the first five lines of the file.
If a confirmation screen appears, check the description and then click Import.
Check the processing status in "Import Results".
If "Failed" is displayed, it indicates that the file failed to be imported. Read the error description and correct the data in the file.
If You Receive a 'Language for Localized Name Is Not Valid' Message