Organizations/Users/Roles

This section describes the CSV file format used to import data related to organizations, users, and roles.

Organization Details

This section describes the CSV file format used to import organization information.
When a child organization recognizes a parent organization, these organizations are nested. To import nested organizations using a CSV file, describe the parent organization in a record of the child organization.

Caution

In Garoon, only "Organization details" imported from CSV files will be overwritten without being appended.
Therefore, when you import "Organization details" from a CSV file, existing organizations that are not listed in the "Current Organization Codes" in the CSV file will be deleted.If you want to import "Organization details" from a CSV file, all organization information must be listed in the CSV file.
Operational administrators can manage organization information in a CSV file, only for organizations for which they have operational administrative privileges and organizations in the subordinate hierarchy.
If you are an operational administrator, describe all "Organization details" for which you have administrative privileges in the CSV file.
Parent organizations must be written before child organizations.
If you want to import organization data from a CSV file, you cannot specify an asterisk(*) as a parent organization code.

Note

If you specify an asterisk (*) in a field, that field is not overwritten.
To add new organizations:
For the current organization code and the new organization Code, configure the following.
- For the current organization code, set an asterisk (*).
- For the new organization code, set the organization code of the organization you want to add.
To change existing organization information without changing the organization code of the existing organization:
For the current organization code and the new organization Code, configure the following.
- For the current organization code, set the organization code of the organization registered in Garoon.
- For the new organization code, set an asterisk(*).
To change an organization code of the existing organization:
For the current organization code and the new organization Code, configure the following.
- For the current organization code, set the organization code of the organization you want to change.
- For the new organization code, set the changed organization code.

CSV File Format

Current organization code, organization name, new organization code, parent organization code, notes

Example Description:

Example of a CSV file for organization information

CSV File Items and Specifications

Item	Number of characters	Remarks
Current Organization Code	100 characters
Organization name data	100 characters	Specify a standard organization name.
New Organization Code	100 characters
Parent Organization Code	100 characters	When omitted, the top level organization is set.
Memo	65,535 characters	The maximum number of characters is 65535 with single-byte characters. The maximum number of characters varies depending on the character type.

Organization Member Data

This section describes the CSV file format used to import organization members.

CSV File Format

Organization code, login name 1, login name 2, login name 3,...

Example Description:

Example of a CSV file for users who are members of the organization

CSV File Items and Specifications

Item	Number of characters	Required item	Remarks
Organization code	100 characters		Describe the organization code of the organization for which you want to set up members.
Login Name 1 Login Name 2 Login Name 3 ...	100 characters		Describe the login name of the member.

Organization Name

This section describes the format of the CSV file used to import organization names for each language.

CSV File Format

Organization Code, language code, organization name

Example Description:

Example of a CSV file for organization name data

CSV File Items and Specifications

Item	Number of characters	Remarks
Organization code	100 characters
Language code		Specify one of the following language codes. ja Language code for Japanese. en Language code for English. zh Language code for Chinese (Simplified). zh-tw Language code for Chinese (Traditional). This is used for Chinese characters displayed in Traditional Chinese.
Organization name data	100 characters	Specify organization names for each language.

User Information

This section describes the CSV file format used to import user information.
In Garoon, when you manage users using a CSV file, you can perform following actions using one file.

Adding users
Updating user information
Deleting Users

CSV File Format

Current login name,Name,Language of the Name,English spelling,New login name,Password,Locale,Office,Display order,Status,Delete flag,Pronunciation,E-mail,Notes,Position,Contact,URL(,Customized items of user information...)

Example Description:

Screenshot: CSV file with sample user information

Note

To add users:
The "Current login name" of the user you want to add must be different from the login names of users who are already registered in Garoon. When duplicated login name is specified, it is considered as a change to the user information.
To change user information:
User information can be changed for all fields. For fields that you do not want to change information, set asterisks (*) in them.
For example, when you use Garoon for the first time, you set the default password in the password field, but from the next time, you set an asterisk (*) in it. If you do not set an asterisk (*) in it next time or later and the users have changed their passwords, they will be overwritten by the ones in the CSV file.
To delete users:
If you want to delete users who are registered in Garoon, set "1" for "Delete flags". Data such as schedules and messages of users who have been deleted will be deleted automatically at the deletion time set on the "User Data deletion time" screen of the system administration.
For details, see Setting the Time to Delete User Data.

CSV File Items and Specifications

Import Item

Item	Number of characters	Remarks
Current Login Name	100 characters	You cannot specify an asterisk (*) for the current login name. It must be unique throughout Garoon.
Name	100 characters	Specify a standard user name.
Language		Specify this if you have specified English as a language to be used for entering user profile items in the General settings screen for localization. Specify one of the following language codes. ja Language code for Japanese. en Language code for English. zh Language code for Chinese (Simplified). zh-tw Language code for Chinese (Traditional). This is used for Chinese characters displayed in Traditional Chinese.
English	100 characters	Specify user names in English if you have specified English as a language to be used for entering user profile items in the General settings screen for localization.
New Login Name	100 characters
password	64 characters	If you want to prevent a CSV file from overwriting user-specified passwords when importing the CSV file, specify an asterisk (*).
Locale	100 characters	Specify a locale code.
Office	100 characters	Specify an office code.
Display order	8 characters	Specify the user list's display priority using an integer of 0 (zero) or higher. You can specify up to eight digits.
Use/Stop		Specify one of the following values: 0 Specify this if you want to prohibit access. 1 Specify this if you want to allow access. If omitted, "0" is loaded to prevent user access.
Delete Flag		To delete registered users, specify "1".
Pronunciation	100 characters
E-mail	100 characters
Memo	65,535 characters	The maximum number of characters is 65535 with single-byte characters. The maximum number of characters varies depending on the character type.
Job title	100 characters
Contacts	100 characters
URL	255 characters

Custom items

Item	Number of characters	Remarks
String (one line)	100 characters
String (Multiple lines)	65,535 characters	The maximum number of characters is 65535 with single-byte characters. The maximum number of characters varies depending on the character type.
URL	255 characters
Image URL	255 characters
E-mail	100 characters
IP Phone	100 characters
password	64 characters

¹: Required if the "Required field" checkbox is selected in the item settings.

CSV file format for version 3.0 or earlier

Version You cannot export or import information about localization using the format in version 3.0 or earlier.

Current login name,Name,New login name,Password,Display order,Status,Deletion flag,Pronunciation,E-mail,Notes,Position,Contact,URL(,Customized items of user information...)

Membership Information Data

This section describes the CSV file format used to import organizations where users belong.

CSV File Format

Example Description:

Example of a CSV file for users' organizations

CSV File Items and Specifications

Item	Number of characters	Required item	Remarks
Login name	100 characters		Describe the login name of the user for whom you set up the organization.
Organization Code 1 Organization Code 2 Organization Code 3 ...	100 characters		Describe the organization code of the organization. The first organization code is the "priority organization".

Role Data by User

Describe the format of a CSV file used to import users' roles.

CSV File Format

Example Description:

Example of a CSV file for roles by users who have the roles

CSV File Items and Specifications

Item	Number of characters	Required item	Remarks
Login name	100 characters		Describe the login name of the user for whom you set up the role.
Role Name 1 Role Name 2 Role Name 3 ...	100 characters		Describe the role name of the role.

Role Details

This section describes the CSV file format used to import role information.

CSV File Format

Role name, notes

Example Description:

Example of a CSV file for role details

CSV File Items and Specifications

Item	Number of characters	Required item	Remarks
Role name	100 characters		Everyone, LoginUser, Owner, CommandLine, and Administrators cannot be used as role names.
Memo	65,535 characters		The maximum number of characters is 65535 with single-byte characters. The maximum number of characters varies depending on the character type.

User Data by Role

Describe the format of a CSV file used to import user data by role.

CSV File Format

Role name, login name 1, login name 2, login name 3,...

Example Description:

Example of a CSV file for users by roles which have the users

CSV File Items and Specifications

Item	Number of characters	Required item	Remarks
Role name	100 characters		Describe the name of the role for which you want to set up users.
Login Name 1 Login Name 2 Login Name 3 ...	100 characters		Describe the login name of the user.