- Rooms with a unique name that doesn't contain " , " and that matches those that are to be imported
- Users with login - that matches the owners of the bookings that are to be imported. If the owner can't be found, the booking won't be imported.
- Only one file can be imported. If you need to import additional bookings, add them to the original file and import all the bookings in one file.
- the imported bookings won't be connected to an outlook booking
- If you don't want to overwrite existing bookings, remember to disable the box
”Delete all existing bookings of imported resources in the specified period” OFF
Preparing data
The separator is semicolon ";"
Each line must end with a semicolon
The CSV file consist of 5 columns of data
Title | Resource | Start | End | Owner | |
My meeting with XYZ | {Type:Name,Identifier:B116-IT010} | 26-09-2013 12:00 | 26-09-2013 14:00 | {Type:Login,Identifier:akme} |
"Title"
This is the title of the meeting, where a room resource is booked for
Ex.
My meeting;...;....;...;....;
"Resource"
This is the name of the room resource that is booked for the meeting
The format dictates that it must be written in the following format:
Ex
.....;{Type:Name,Identifier:B116-IT010};...;...;...;
In the example above the unique name of the room is "B116-IT010"
"Start"
Start date and time for the booking of the room resource.
The date/time format must be dd-mm-yyyy hh:mm
Ex
...;...;26-09-2014 12:00;...;...;
"End"
End date and time for the booking of the room resource.
The date/time format must be dd-mm-yyyy hh:mm
Ex
...;...;...;26-09-2014 14:00;...;
"Owner"
The login of the owner of the bookingEnd date and time for the booking of the room resource.
The format dictates that it must be written in the following format:
Ex
...;...;...;...;{Type:Login,Identifier:kasper.ullits};
In the example above the login of the user is "kasper.ullits"
Importing
Before data can be imported - you must ensure that both the room names and the users, referred to in the import file, can be matched to the respective rooms and users in SiW Room.
- Open with notepad the file configuration\appsettings.config
- Ensure the ImportEnabled is set to true
<add key="BookingImportEnabled" value="true"/>
- Save
- Open SiW Room
- Go to Administration->Settings->Import
- Fill in the required files and click import
Comments
1 comment
Vær opmærksom på at indlæsning ikke kan foretages hvis ressourcerne er Exchange integreret /Charlotte
Please sign in to leave a comment.