Import Bookings

Introduction

OfficeRnD can automatically import your bookings and map them to the team and member that created them.

• The feature is available in Settings/Data & Extensibility/Import/Bookings tab.
• The step-by-step import process in OfficeRnD is explained here.

In this article, you'll find the format we use to import your existing data.

Prerequisites

• Add members that bookings will be associated with. You can import all your existing members as described here.
• Add and configure meeting rooms under Space/Meeting rooms.

Format

OfficeRnD enables you to import bookings from a .CSV file with the following columns. Note that fields marked with '*' are required.

• Email * - Email of the member who created the booking. Members must exist in the system prior to importing their bookings.
• Start * - Date and time of the beginning of the booking.
• End * - Date and time of the end of the booking.
  
  The Start and End fields should be in the following format: YYYY-MM-DD HH:mm.
• Meeting room * - Name of the meeting room. It needs to match the meeting room name in OfficeRnD.
• Title (optional) - Summary of the booking.
• Description (optional) - Additional information about the booking.
• Free (yes/no) (optional) - Mark the booking as Free. The default value is No. If set to No, a fee will be created or credits will be allocated.
• Custom price (optional) for the booking.
• Extras and their quantities (optional)

Important Information

• Make sure to use the exact headers listed above and add an email for every record. Otherwise, your data won't be imported correctly as bookings without a valid email are skipped in the importing phase.
• Quantity can be omitted (both the column and the value).
• The plan name cannot be omitted.
• Bookings for custom resources cannot be imported. 

Get in touch with our support team if you need assistance in importing your bookings or other data.