This section describes the CSV file format used to import scheduler data.
Appointment
This section describes the CSV file format used to import appointments.
CSV file format varies depending on whether you import an appointment from the system administration screen or from the personal settings on the user screen.
Appointments in System Administration
This section describes the format of the CSV file used to import appointments in "Scheduler" in system administration.
CSV File Format
Start date, start time, end date, end time, appointment, appointment details, memo, attendees/organizations/facilities, creator(, custom items for facility reservation information)
Example Description:
CSV File Items and Specifications
Item
Number of characters
Required item
Remarks
Start date
Use YYYY-MM-DD format or YYYY/MM/DD format.
Start time
Specify the value in HH:MM:SS format.
End date
Use YYYY-MM-DD format or YYYY/MM/DD format.
End time
Specify the value in HH:MM:SS format.
Appointment
100 characters
Specify the title of the appointment (Appointment type).
Appointment details
100 characters
Describe the details of the appointment title.
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.
Attendees, organization, or facility
100 characters
Describe the login name, organization code, or facility code of the target. If a login name, organization code, or facility code is duplicated, target is added in order of following priority.
1. Login Name
2. Organization Code
3. Facility Code
Created by
Custom items for facility reservation information
Appointments in Personal Settings
This section describes the format of the CSV file used to import appointments in "Scheduler" in personal settings.
CSV File Format
Start date, start time, end date, end time, appointment, appointment details, memo
Example Description:
CSV File Items and Specifications
Item
Number of characters
Required item
Remarks
Start date
Use YYYY-MM-DD format or YYYY/MM/DD format.
Start time
Specify the value in HH:MM:SS format.
End date
Use YYYY-MM-DD format or YYYY/MM/DD format.
End time
Specify the value in HH:MM:SS format.
Appointment
100 characters
Specify the title of the appointment (Appointment type).
Appointment details
100 characters
Describe the details of the appointment title.
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.
Facility Information
This section describes the CSV file format used to import facility information.
CSV File Format
Facility name, facility code, facility group code, memo
Example Description:
CSV File Items and Specifications
Item
Number of characters
Required item
Remarks
Facility Name
100 characters
Specify a standard facility name.
Facility Code
100 characters
Facility Group Code
100 characters
If you import a file without facility group code specified, facility group will not be set, and the group will be imported as unassigned facility group.
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.
Facility Name
This section describes the CSV file format used to import facility names for each language.
CSV File Format
Facility Code, language code, facility name
Example Description:
CSV File Items and Specifications
Item
Number of characters
Required item
Remarks
Facility 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.
Facility Name
100 characters
Specify facility names for each language.
Facility Group Information
This section describes the CSV file format used to import facility groups.
CSV File Format
Parent facility group code, current facility group code, facility group name, notes, new facility group code
Example Description:
CSV File Items and Specifications
Item
Number of characters
Required item
Remarks
Parent Facility Group Code
100 characters
If omitted, the group is placed in the top.
Current Facility Group Code
100 characters
Facility Group Name
100 characters
Specify a standard facility group name.
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.
New Facility Group Code
Facility Group Name
This section describes the CSV file format used to import facility group names for each language.
CSV File Format
Facility Group code, language Code, facility group name
Example Description:
CSV File Items and Specifications
Item
Number of characters
Required item
Remarks
Facility Group 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.
Facility Group Name
100 characters
Specify facility group names for each language.
Operational Administrative Privileges for Facility Groups
This section describes the CSV file format used to import operational administrative privileges for facility groups.
CSV File Format
Facility group code,Items,Targets
Example Description:
CSV File Items and Specifications
Item
Number of characters
Required item
Remarks
Facility Group Code
100 characters
Items
This item specifies the type of target for which you want to grant operational administrative privileges.
The following types can be specified.
user
Specify this if you grant operational administrative privileges to users.
group
Specify this if you grant operational administrative privileges to organizations.
dynamic_role
Specify this if you grant operational administrative privileges to dynamic roles.
role
Specify this if you grant operational administrative privileges to static roles.
Targets
100 characters
Depending on the type you specified, describe a code. The following codes can be described.
Login name
When you specify a "user" as "Items", describe the login name of that user.
Organization code
When you specify a "group" as "Items", describe the organization code of that organization.
Role name
When you specify a "dynamic_role" or "role" as "Items", describe the role name of that role.
User Rights
This section describes the CSV file format used to import access permissions.
Access permissions are set for target codes. For each target code for which you want to set access permissions, describe the lines to set security model and the lines to set access permissions.
CSV File Format
Lines for setting the security model:
Set the security model for the target code. The format is as follows.
Target type,Target code,Items,Values
Lines for setting access permissions:
Describe access permissions to be set in separate lines for each target. The format is as follows.
Target type,Target code,Items,Values,Targets
Example Description:
a): 1st data
b): 2nd data
c): Lines for setting up the security model
d): Lines for setting access permissions
Items and Specifications for the Lines to Set the Security Model
Item
Number of characters
Required item
Remarks
Target type
100 characters
Describes the target type of access permissions. The following types can be specified.
user
Specify this if you set access permissions for a user.
group
Specify this if you set access permissions for an organization.
role
Specify this if you set access permissions for a role.
facility
Specify this if you set access permissions for a facility.
facilitygroup
Specify this if you set access permissions for a facility group.
Target Code
Depending on the type you specified, describe a code. The following codes can be described.
Login Name1
If you specified "user", describe the login name of that user.
Organization Code1
If you specified "group", describe the organization code of that organization.
Role Name1
If you specified "role", describe the role name of that role.
Facility Code2
If you specified "facility", describe the facility code of that facility.
Facility Group Code2
If you specified "facilitygroup", describe the facility group code of that facility group.
Items
Specify "security_model".
Available Values
Specify one of the followings.
revoke
Specify this if you want to select a target to be restricted.
grant
Specify this if you want to select a target to be granted a permission.
For details on "revoke" and "grant", refer to the description regarding the security model.
1: The number of characters is 128 characters.
2: The number of characters is 100 characters.
Items and Specifications for Lines to Set User Rights
Item
Number of characters
Required item
Remarks
Target type
100 characters
Specify the same target type as the one you specified in the line where you set the security model.
Target Code
Specify the same target code as the one you specified in the line where you set the security model.
Items
This item specifies the type of target for which you want to set access permissions. The following types can be specified.
user
Specify this if you set access permissions for users.
group
Specify this if you set access permissions for organizations.
dynamic_role
Specify this if you set access permissions for dynamic roles.
role
Specify this if you set access permissions for a role.
Available Values
This item describes the actions allowed for "target". If you want to set multiple permissions, specify both values (e.g. "RA"). The following characters can be used.
R
Specify this if you want to grant view privilege.
A
Specify this if you want to grant the permission to add.
If you want to grant the permission to add, you must also grant view privilege.
M
Specify this if you want to grant the permission to modify.
If you want to grant the permission to modify, you must also grant view privilege.
D
Specify this if you want to grant the permission to delete.
If you want to grant the permission to delete, you must also grant view privilege.
To restrict all actions, leave the value empty.
If you specified the security model "revoke" to select targets to be restricted:
On the "User Rights List" screen, "x" is displayed in all permission fields. Users cannot perform any action because they do not have any permission.
If you specified the security model "grant" to select targets to be allowed:
Nothing is displayed on the "User Rights List" screen. Users cannot perform any action because permission target has not been set.
To delete user rights settings, specify the value as follows.
If you specified the security model "revoke" to select targets to be restricted:
Specify "RAMD" in "Values".
If you specified the security model "grant" to select targets to be allowed:
Leave the "Values" field empty.
Targets
128 characters
Depending on the type you specified, describe a code. The following codes can be described.
Login name
If you specified "user", describe the login name of that user.
Organization code
If you specified "group", describe the organization code of that organization.
Role name
If you specified "dynamic_role" or "role", describe the role name of that role.
Default "Shared with"
This section describes the CSV file format used to import default "Shared with" users.