File Format for Departments to Which Users Belong

Article Number:020152
Intended audience: Kintone Users & System Administrators

This page describes the file format for configuring departments to which users belong.

For details on how to import a file, refer to the following page:
Adding or Changing Users and Departments Using a File

File Format

Only users' departments entered in the file are changed.

Enter the information of one user in each row.
Each row requires the following items. If the items contain a leading or trailing space, it will be trimmed when the data is imported from the file.

  • Login Name
  • department code
  • Job Title Code

When a user belongs to multiple departments, repeat the combination of "Department Code" and "Job Title Code" multiple times.
The department entered in the first "Department Code" will be the "Priority Department" of the user.

Items to be entered in a file

The first row is used for the field names. You can omit the first row, or select "Skip header row" when importing a file.

Login Name

Enter the login name of the users whose department you want to change.
This item is mandatory.

Department Code

Enter a department code.
If a user does not belongs to any departments, leave the "Department Code" and "Job Title Code" items blank.

Job Title Code

Enter a job title code.
For "No Job Title", leave this item blank.

Example of CSV File Descriptions

The first row can be used for the field names. You can omit the first row, or select "Skip header row" when importing a file.

To add a user to a department

The following is an example of how to add the user with the login name "sato" to "org001."

The content has been copied.
Login Name, Department Code 1, Job Title Code 1, Department Code 2, Job Title Code 2
sato, org001,

To add a user to a department and assign a job title

The following is an example of how to add the user with the login name "kato" to "org001" and "org002."
In this example, no job title is set for "org001", and the job title with the job title code "title01" is set for "org002".

The content has been copied.
Login Name, Department Code 1, Job Title Code 1, Department Code 2, Job Title Code 2
kato, org001, , org002, title001

To remove a user from all their departments

The following is an example of how to remove the user with the login name "tanaka" from all of their departments.

The content has been copied.
Login Name, Department Code 1, Job Title Code 1, Department Code 2, Job Title Code 2
tanaka