Exporting/importing users

Users can be exported on the user management screen, in order to save any already existing users to a user data file on a computer. Users can be added, changed, or deleted by editing the user data file and importing it on the user management screen.

⮊ Import method types (differential import, total import)
⮊ User data file format

Import method types (differential import, total import)

There are two ways to import.

• Differential import
  Specify whether to add/change or delete the users contained in the user data file during import. Users not contained in the user data file will not be changed or deleted.
• Total import
  Add, change, or delete users to match what is contained in the user data file. Note that any users not contained in the user data file will be deleted.

• Note
  
  • Neither method can be used to add, modify, or delete administrator users.

User data file format

Follow the instructions below to edit an exported user data file or create a user data file on the computer.
There are two types of user data files.

• Tab delimited text format (.tsv)
  
  Character encoding: UTF-8 or Shift_JIS
  Line feed code: CRLF
  
  • Note
    
    •  <TAB> and the surrounding spaces in the figure above correspond to a single actual tab character.
• Excel CSV format (.csv)
  
  
  • Note
    
    • When saving in Microsoft Excel, specify [CSV (comma separated values) (* .csv)] as the file type.

Additional explanation

(1) Identification information

When using differential import, enter following identification information on the first line. Do not enter
any information if using total import.

• #Format for differential import

(2) Fields

Enter column definitions. The first character is prefixed with “#”.
When using differential import, enter this on the second line. When using total import, enter this on the
first line.

• Column 1: Contains “email”.
• Column 2: Contains “tag”.
• Column 3: Contains “permission”

(3) User data

Enter user data. This can contain a number of rows equal to the number of administrator users
subtracted from the contracted number of users.
When using differential import, enter this beginning on the third line. When using total import, enter
this beginning on the second line.

• Column 1: Contains email addresses.
• Column 2: Enter tag names.

• Note
  
  • This may contain up to 30 characters. Up to 50,000 unique tag names may be registered.
  • Tabs, line feed characters, and other control characters cannot be entered.

• Column 3: "1" if set as a group leader. Blank if set as a general user.

• Note
  
  • A user cannot be set as an administrator user.

• Important
  • If "Delete" is specified during differential import, the information in columns 1 through 3 for all user data must match the information on the user management screen. Import cannot be performed if even a single item does not match.