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

Each row contains the information of one department.
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:
Department Information Fields

Notes on creating a file

You must provide all necessary departments in a file to be imported.
Departments that are not provided 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

Fill in a field with an asterisk (*) when you do not want to update the value of the field.
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

Specify the current department code.
Even if you want to change the current department code, specify the current department code in "Department Code". A new department code should be specified 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 specify "Localized Name", select one of the following languages:

  • 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.

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.