Scheduler

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:

Example of a CSV file for appointments

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:

Example of a CSV file for personal settings

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:

Example of a CSV file for facility information

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:

Example of a CSV file for facility names

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:

Example of a CSV file for facility group information

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:

Example of a CSV file for facility group names

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 example of operational administrative privileges for a facility group

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:

Example of a CSV file for access permissions

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.

CSV File Format
Login name, item type, item code 1, Item code 2, item code 3,...

Example Description:

Example of default CSV file for "Shared with" users

CSV File Items and Specifications
Item Number of characters Required item Remarks
Login name 128 characters Specify the login name who uses the default "Shared with" users.
Type   This item specifies the item type to be set as the default "Shared with" users. The following item types can be specified.
  • user
    Specify this if you set users for default "Shared with" users.
  • group
    Specify this if you set organizations for default "Shared with" users.
  • role
    Specify this if you set roles for default "Shared with" users.
Item code 128 characters   Depending on the item type, describe a code. The following codes can be described.
  • Login name
    If you specified "user" for item types, describe the login name of that user.
  • Organization code
    If you specified "group" for item types, describe the organization code of that organization.
  • Role name
    If you specified "role" for item types, describe the role name of that role.