File format for departments to which users belong

Article Number:020152
Intended audience: cybozu.cn 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 "Primary department" of the user.

Items to be entered in 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

Each example in this section includes a header row. The header row can be omitted.
If you include a header row in a file and import that file, select the "Skip header row" checkbox.

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