File Format for Departments

Article Number:020151

This page describes the file format for adding or changing departments.

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

File Format

Enter the information of one department in each row.
Each row requires the following items. These items are mandatory and cannot be omitted.

  • department code
  • Display Name
  • New Department Code
  • Localized Name
  • Language for Localized Name
  • Parent Department Code
  • Description

For details on the items above, refer to the following page:
Items of Department Information

Notes on creating a file

Enter all necessary departments in a file to be imported.
Departments that are not entered in the file will be deleted from Kintone.
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

To delete departments

To delete department information, remove the departments you want to delete from the file to be imported.
Notes on Deleting Departments

Items to be entered in a file

Enter an asterisk (*) for the items that you want to leave unchanged.
The row of a parent department must precede the rows of its child departments.

Department Code

To add a new department

Enter a string that does not duplicate existing department codes.

To change the information of existing departments

Enter the existing department code.
When you want to change the existing department code, enter it in "Department Code". Enter a new department code in "New Department Code".

Display Name

"Display Name" must be a string.

New Department Code

To change "Department Code"

Enter a new department code.

To add a new department, or to change information other than "Department Code"

Enter a string that is identical to "Department Code", or enter "*".

Localized Name

Other than the default "Display Name", you can enter a display name for each language.
For example, you can type "営業部" for users who use Japanese or "Sales.Div" for users who use English.

Language for Localized Name

If you enter a "Localized Name", you also need to enter one of the following for this item:

  • Japanese: ja
  • English: en
  • Simplified Chinese: zh
  • Traditional Chinese: zh-TW
  • Spanish: es

Parent Department Code

Enter a department code of a parent department.
If you leave this item blank, a top-level department will be configured as the parent department.

Trimming Whitespaces

If the following items contain a leading or trailing space, it will be trimmed when the data is imported from the file.

  • department code
  • Display Name
  • New Department Code
  • Localized Name
  • Language for Localized Name
  • Parent Department Code

Example File

Prerequisite

  • "org001" exists.
  • "org001-1" exists as a child department of "org001".
  • "org001-2" exists as a child department of "org001".

Example of actions to perform

  • Do not change "org001".
  • Change the display name of "org001-1" to "Sales Department".
  • Add "org001-1-1" as a child department of "org001-1".
  • Delete "org001-2".
  • Add "org002" as a top-level department.

Example of CSV file descriptions

The content has been copied.
Department Code, Display Name, New Department Code, Localized Name, Language for Localized Name, Parent Department Code, Description
org001, *, *, *, *, ,*
org001-1, Sales Department, *, *, *, org001,*
org001-1, Group 1, *, Sales Group#1, en, org001-1,
org002, HR Department, *, , , ,

The first row contains "Field Name". Omit the first row containing the field names, or select "Skip header row" when importing a file.

Do not enter the department to be deleted (org001-2) in the file.