File Format for Groups or Roles
This page describes the file format for adding or changing groups (or roles).
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 groups entered in the file are added or changed.
When the "Group Code" you entered in the file is identical to the existing code of the group in kintone.com, the group information will be overwritten.
Enter the information of one group (or role) in each row.
Each row requires the following items. These items are mandatory and cannot be omitted.
- Group Code
- Name
- New Group Code
- Membership Type
- Description
- Delete
For details on the items above, refer to the following page:
Items of Group Information
Items to be entered in a file
Enter an asterisk (*) for the items that you want to leave unchanged.
Group Code
To add a new group
Enter a string that that does not duplicate existing group codes.
To change the information of existing groups
Enter the existing group code.
When you want to change the existing group code, enter a new group code in "New Group Code".
Name
"Name" must be a string.
Enter a string that does not duplicate existing group names.
New Group Code
To change "Group Code"
Enter a new group code.
To add a new group, or to change information other than "Group Code"
Enter a string that is identical to "Group Code", or enter "*".
Membership Type
To add a new group
Enter one of the following for this item:
- Static group: "static"
- Dynamic group: "dynamic"
As for the difference in membership types, refer to the following page:
Membership Type
To change the information of existing groups
Enter either a membership type of an existing group or "*".
You cannot change the existing membership type, for example from static to dynamic.
To Be Deleted
Enter one of the following for this item:
- To delete a group
Enter "1". - To add a group, or to change group information
Enter "*" or leave the item blank.
Trimming Whitespaces
If the following items contain a leading or trailing space, it will be trimmed when the data is imported from the file.
- Group Code
- Name
- New Group Code
- Membership Type
- Delete
Example File
Example of actions to perform
- Add a static group "grp001".
- Add a dynamic group "grp002".
- Change the group name of "grp003".
- Change the group code of "grp004" to "old-grp004".
- Delete "grp005".
Example of CSV file description
Group Code, Name, New Group Code, Membership Type, Description, To Be Deleted
grp001, Managers, *, static, ,
grp002, Part-timers, *, dynamic, ,
grp003, new-grp003, *, *, ,
grp004, *, old-grp004, *, ,
grp005, *, *, *, , 1
The first row contains "Field Name". Omit the first row containing the field names, or select "Skip header row" when importing a file.