Managing address Books in CSV files

Manages the data in the Address Book in a CSV file.
The following data can be managed using CSV files:

  • Addresses of shared address books
  • Access Permissions

Importing Data from a CSV File

Import the Address book data 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 CSV files, refer to the CSV format in the Address Book.

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

  3. Click System settings.

  4. Select "Application settings" tab.

  5. Click Address Book.

  6. Click Import from CSV file.

    "Import from CSV file" does not appear if no book has been added to the shared Address Book.

  7. On "Import from CSV File" screen, select the data to import.

  8. Select the CSV file that you created in step 1.

  9. Set the data to import, and click Next.

    The setting fields are as follows:

    • Book:
      Select the books you want to import.
    • 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
      • English (Latin1)
      • Simplified Chinese (GBK/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".
    Screenshot: "Import user rights data" screen

  10. Confirm the CSV file contents and click Import.

Exporting Data to a CSV File

Export the Address book data to a CSV file.

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

  2. Click System settings.

  3. Select "Application settings" tab.

  4. Click Address Book.

  5. Click Export to CSV file.

    "Export to CSV file" does not appear if no book has been added to the shared Address Book.

  6. On the "Export to CSV File" screen, select the data to export.

  7. Set the required items for the data to export.

    The setting fields are as follows:

    • Book:
      Select the books you want to export.
    • Character encoding:
      Select the character code that you want to use for encoding.
      The following character codes can be selected.
      • Unicode (UTF-8)
        You can select with BOM as required.
      • Japanese (Shift-JIS)
      • ASCII
      • English (Latin1)
      • Simplified Chinese (GBK/GB2312)
      • Thai (TIS-620)
    • Include header row:
      To export an item name to the header row of a CSV file, select "Yes".
    Screenshot: "Export user rights data" screen

  8. Confirm your settings and click Export.

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