Importing bookings from 3rd party calendar solutions
Customers that are migrating from 3rd party calendars solution, can import simple bookings of rooms into Sign In Workspace(SiW).
This section will guide you on how to prepare data and how to import data into SiW Room.
NOTE - this action requires that the SiW Room solution is prepared with:
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
It is the customer's responsibility to export the data from Exchange.
Data to be imported must be defined in a CSV file. (see attached file for example)
The separator is semicolon ";"
Each line must end with a semicolon
The CSV file consist of 5 columns of data
Like
"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
Save
Open SiW Room
Go to Administration->Settings->Import
Fill in the required files and click import