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
  

 

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

1. Open with notepad the file configuration\appsettings.config
2. Ensure the ImportEnabled is set to true 
   <add key="BookingImportEnabled" value="true"/>
   
3. Save
4. Open SiW Room
5. Go to Administration->Settings->Import
6. Fill in the required files and click import