Follow

Importing bookings from 3.rd party calendar solutions

Customers that are migrating from 3rd party calendars solution, can import simple bookings of rooms into Pronestor.
 
This section will guide you on how to prepare data and how to import data into Pronestor Room.
 
NOTE - this action requires that the Pronestor Room solution is prepared with:

  • Rooms with a unique name - that matches those that are to be imported
  • Users with login - that matches the owners of the bookings that are to be imported
  • There must not exist any bookings in Pronestor Room for the rooms before importing 

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 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 mm-dd-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 mm-dd-yyyy hh:mm

Ex
...;...;...;26-09-2014 14:00;...; 

"Owner"  

The name 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 unique name 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 Pronestor 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 Pronestor Room
  5. Go to Administration->Settings->Import
  6. Fill in the required files and click import

Note - the import can't be performed twice of the same data.

 

 

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk