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.
-
Create a CSV file to import data.
For information on CSV files, refer to the CSV format in the Address Book. -
Click the administration menu icon (gear icon) in the header.
-
Click System settings.
-
Select "Application settings" tab.
-
Click Address Book.
-
Click Import from CSV file.
"Import from CSV file" does not appear if no book has been added to the shared Address Book. -
On "Import from CSV File" screen, select the data to import.
-
Select the CSV file that you created in step 1.
-
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".
- Book:
-
Confirm the CSV file contents and click Import.
Exporting Data to a CSV File
Export the Address book data to a CSV file.
-
Click the administration menu icon (gear icon) in the header.
-
Click System settings.
-
Select "Application settings" tab.
-
Click Address Book.
-
Click Export to CSV file.
"Export to CSV file" does not appear if no book has been added to the shared Address Book. -
On the "Export to CSV File" screen, select the data to export.
-
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)
- Unicode (UTF-8)
- Include header row:
To export an item name to the header row of a CSV file, select "Yes".
- Book:
-
Confirm your settings and click Export.
-
Save the file with a function provided by your Web browser.