This section describes precautions that you must take when you are adding a CSV file. You must check the following before importing a CSV file.
You must use Unicode (UTF-8) or Shift JIS.
One of the following codes must be used to separate records:
CRLF for Windows or MS-DOS
LF for Linux
You must use the half-width double quotation marks ( " ) for the following characters:
Comma (,)
Carriage return code LF
A half-width double quotation mark ( " )
Application data that can be managed using CSV files are as follows:
Appointment data of Scheduler
Timesheet
Address data of Personal address book
Event data of My calendar
Refer to the chapters for each application for instructions on importing and exporting CSV files.
The items that can be managed in a CSV file are as follows:
Order within the file | Item | Notes |
---|---|---|
1 | Start date | Specify the date in either YYYY-MM-DD, or YYYY/MM/DD format.
|
2 | Starting Time | |
3 | End date | |
4 | Ending time | |
5 | Appointment type | |
6 | Appointment details | |
7 | Notes |
You cannot export all day appointments to a CSV file.
If period to export is not specified on the "Export appointment data" screen of Scheduler, no data is exported to a CSV file.
You can export only your time sheet data. You cannot export the time sheet data of other users.
The items that can be exported to a CSV file are as follows:
Order within the file | Item | Notes |
---|---|---|
1 | Log in name | |
2 | User name | |
3 | Date | |
4 | Start of work time | |
5 | End of work time | |
6 | Out | |
7 | Back | |
8 | Notes |
The items that can be managed in a CSV file are as follows:
Order within the file | Item | Notes |
---|---|---|
1 | Display as | |
2 | Last name | |
3 | First name | |
4 | Pronunciation of last name | |
5 | Pronunciation of first name | |
6 | Company name | |
7 | Pronunciation of company name | |
8 | Department name | |
9 | Postcode | |
10 | Address | |
11 | Route | |
12 | Travel time | |
13 | Travel expense | |
14 | Company phone number | |
15 | Company FAX number | |
16 | URL | |
17 | Position | |
18 | Personal phone number | |
19 | E-mail address | |
20 | Notes |
The items that can be managed in a CSV file are as follows:
Order within the file | Item | Notes |
---|---|---|
1 | Date | Specify the date in either YYYY-MM-DD, or YYYY/MM/DD format.
|
2 | Event type | Event time is entered with a number:
|
3 | Event details |