Address Book

This section describes the CSV file format used to import data related to address books.
Even if data other than the selected book is included in a CSV file, only the data for the selected book is imported.

Shared Address Books/Personal Address Books

This section describes the CSV file format used to import shared address books and personal address books.

CSV File Format
Display name, last name, name, last name (pronunciation), name (pronunciation), company name, company name (pronunciation), department name, zip code, address, route, time required, fare, office phone number, office fax number, URL, job title, personal phone number, e-mail, memo (, custom items)

Example Description:

Example of a CSV file for a Shared Address Book/Personal Address Book

CSV File Items and Specifications for Built-in Items
  • Import Item
Item Number of characters Required item Remarks
Name 100 characters  
Last Name 100 characters    
Name 100 characters    
Last Name (pronunciation) 100 characters    
Name (pronunciation) 100 characters    
Company Name 100 characters    
Company Name (pronunciation) 100 characters    
Department Name 100 characters    
Zip code 100 characters    
Address 4,096 characters    
Route 100 characters    
Time Required 100 characters    
Fare 100 characters    
Office Phone Number 100 characters    
Office Fax Number 100 characters    
URL 100 characters    
Position 100 characters    
Personal Phone Number 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.
  • Custom items
    Custom items are described after the built-in item "Memo".
Item Number of characters Required1 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    
1: Required if the "Required field" checkbox is selected in the item settings.

User Rights

This section describes the CSV file format used to import access permissions.
Access permissions are set for book codes. For each book code, 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.
    Book 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.
    Book 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
Book Code 100 characters  
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.
Items and Specifications for Lines to Set User Rights
Item Number of characters Required item Remarks
Category Code 100 characters Specify the same book 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.
  • static_role
    Specify this if you set access permissions for static roles.
Available Values     This item describes the actions allowed for "target". If you want to set multiple permissions, specify both values (e.g. "BE"). The following characters can be used.
  • B
    Specify this if you want to grant view privilege.
  • E
    Specify this if you want to grant edit privilege.
    If you want to grant the permission to edit, 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.
    When a user, organization, or role you specified had already been registered, if you import the CSV file with the empty value, that registration information will be deleted.
Targets 100 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 "static_role", describe the role name of that role.