desknet's マニュアル

Import from CSV File

You can import all the facility reservation status from a CSV file and edit it.
* You should open Sub-window to use this function.
* If you are going to change the purpose by the importing, the purpose of the reservation in the facility reservation will be changed but the purpose in the event in the schedule will not be changed.

Step 1. Click [Import from CSV File] Link

Click [Personal Preferences]-[Import from CSV File] in Sub-window.

Step 2. Choose Character Encoding and Delimiter

Click [Show Character Encoding and Delimiter Selection] link.
* To hide the selection, click [Hide Character Encoding and Delimiter Selection] link.

Step 3. Setup Preferences

Choose character encoding and delimiter for importing the CSV file.

Field	Selection Value	Description
Character Encoding	Shift_JIS (Enable to Input Japanese and Alphanumeric Only)	Choose this option if the file contains Japanese and alphanumeric characters only.
	UTF8 without BOM (Enable to Input Any Characters)	Choose this option if the file contains characters other than Japanese and alphanumeric characters without BOM.
	UTF8 with BOM (Enable to Input Any Characters)	Choose this option if the file contains characters other than Japanese and alphanumeric characters with BOM.
Delimiter	Comma	Use a comma (",") to separate data. * When you choose "Comma" as the delimiter, the extension of the output file will be CSV (.csv).
Delimiter	Tab	Tab Use a tab to separate data. * When you choose "Tab" as the delimiter, the extension of the output file will be TXT (.txt).

Step 4. Select Facilities

Select facilities to be imported in [Group List] or [Facility List].

Use the following buttons to select facilities and a facility group.

Button	Description
	You can choose a facility group in the list and then click [Show] button to display belonging facilities in the facility group in the facility list. You can choose (All) and then click [Show] button to display all the facilities.
	Select a facility to be imported in [Facility Groups] or [Facilities] and click [Add >>].
	If you want to delete a facility from [Import Target], select the facility and click [<< Remove].

Step 5. Select a File to Be Imported

Specify the full path name of the file you edited by spread sheet Software. You can use [Browse] button to specify the path without entering the path manually.

Step 6. Click .

Click this button to start import.

* If you are an Administrator

If you login as an administrator, you can specify "Owner ID" in a CSV file to add reservations to specific facility.