Import Bookings (Hybrid)

Introduction

OfficeRnD Hybrid can automatically import your bookings and map them to the team and member that created them. The feature is available by navigating to Settings/Import and clicking on the Bookings tab.

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

Prerequisites

• Add employees that bookings will be associated with. If needed, you can import your existing employees as described here.
• Add and configure meeting rooms under Workplace/Resources.

Note: The bookings import feature in Hybrid is set to work only for meeting room bookings by default.

Format

OfficeRnD enables you to import bookings from a .CSV file with the following columns. Download a template.CSV file from here. Note that fields marked with an asterisk * are required.

• Email * - Email of the employee who created the booking. Members must exist in the system prior to importing their bookings.
• Start * - Date and time of the booking's beginning.
• End * - Date and time of the booking end.
  

  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.

You can download a template .CSV file and fill in the columns, if you wish. Feel free to delete the optional columns (or leave them empty) if you don't need them.

Important!

• 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.
• Bookings for custom resources cannot be imported.

Next Steps

1. Click on the Validate and Submit  button.

2. Select your .CSV file and click Open.

If the import is successful, the following message will appear: We Are Working On Importing Your Data.

Otherwise, Validation Error messages (such as the ones below) will appear, explaining what went wrong:

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