Precautions When Adding a CSV File

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.

Character Encoding

You must use Unicode (UTF-8) or Shift JIS.

Line Breaks Code

One of the following codes must be used to separate records:

Special Characters

You must use the half-width double quotation marks ( " ) for the following characters:

Tip
When the field includes a half-width double quotation ( " ), you must insert a half-width double quotation ( " ) in the front of the word that has the original half-width double quotation, and insert a set of half-width double quotation marks ( " ) in front and end of the word that comes right after the word with the original placement of a half-width double quotation ( " ).
Example:
Written text: abc, xy", z, def
must be written in a CSV file as: abc, "xy""z", def

Date Management with CSV Files

Application data that can be managed using CSV files are as follows:

Refer to the chapters for each application for instructions on importing and exporting CSV files.

Tip
You cannot import a CSV file if the number of items in the CSV file differs from the number of items listed below.
Scheduler

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.

  • YYYY: Year

  • MM: Month

  • DD: Date

Specify the time in HH:MM:SS format.

  • HH: Hour

  • MM: Minutes

  • SS: Seconds
2 Starting Time
3 End date
4 Ending time
5 Appointment type  
6 Appointment details  
7 Notes  
Tip

  • 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.

Timesheet

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  
Personal Address Book

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  
My Calendar

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.

  • YYYY: Year
    If a year is not specified, the year that is set in the server is exported.

  • MM: Month

  • DD: Date
2 Event type Event time is entered with a number:

  • Anniversaries: 2

  • Notes (User notes): 4

An error occurs if you specify a number other than above.
3 Event details  

Back to top