Managing Users Using CSV Files

Manage application user settings using a CSV file.

Importing Data from a CSV File

Import application users settings from a CSV file.
If an error occurs while importing a CSV file, the import process will be terminated. The data which has been imported will be eliminated.

Steps:
  1. Create a CSV file to import data.

    For information on items that can be managed in CSV files, refer to the "Application users" section.

  2. Click the administration menu icon (gear icon) in the header.

  3. Click "System settings".

  4. Select "Basic system administration" tab.

  5. Click "Application".

  6. Click "Import application users".

  7. On the "Import application users - Step 1/2" screen, select the CSV file that you created in Step 1.

  8. Set the data to import, and click "Next".

    The setting fields are as follows:

    • Character encoding:
      Encodes data from a CSV file with the selected character code.
      The following character encoding can be selected:
      • Unicode (UTF-8)
      • Japanese (Shift-JIS)
      • ASCII
      • Latin1 (ISO-8859-1)
      • Simplified Chinese (GB2312)
      • Thai (TIS-620)
    • Skip the first row:
      If the header row contains information other than data such as an item name and a comment, select "Yes".
    Screen to select how to import

  9. On the "Import application users - Step 2/2" screen, check the contents of the CSV file, and then click "Import".

Exporting Data to a CSV File

Export application users settings to a CSV file.

Steps:
  1. Click the administration menu icon (gear icon) in the header.

  2. Click "System settings".

  3. Select "Basic system administration" tab.

  4. Click "Application".

  5. Click "Export application users".

  6. On the "Export application users" screen, set the required items for the data to be exported.

    The setting fields are as follows:

    • Character encoding:
      Select the character code that you want to use for encoding.
      Following character codes can be selected.
      • Unicode (UTF-8)
        You can select with BOM as required.
      • Japanese (Shift-JIS)
      • ASCII
      • Latin1 (ISO-8859-1)
      • Simplified Chinese (GB2312)
      • Thai (TIS-620)
    • Include header row:
      To export an item name to the header row of a CSV file, select "Yes".
    Screen to select how to export

  7. Confirm your settings and click "Export".

  8. Save the file with a function provided by your Web browser.