General CSV Format

CSV File Format

The file format is a text file or an Excel CSV formatted file for example. There are a number of mandatory columns that need to be present and a number of optional columns. The order of the columns must be as prescribed here. The first line must be a header line. Suggest the example CSV file is downloaded and edited to test the import process with just one or two test bookings.

Mandatory columns

Optional Fields

Start An Import

Assuming you have a file in the correct format ready to import than access the import bookings page from the menu Setup | Booking Import. This will show the page below.

Import Overview

Click "Choose File", select your import file, click "Upload". You will then either get a set of Validation Messages that prevent uploading or a review of the bookings that have been successfully imported.

Import Success

The above shows all the bookings imported successfully for a single file import. Click "Details" to see the popup booking details. There's a short cut to review any warnings that the imported bookings have. These warnings do not prevent the import of the bookings.

If there are validation issues with the import file then the whole import is stopped and the validation messages displayed as below.

Import Validation Messages

As can be seen above an import file failed pass validation because there are already bookings with the same "Channel Bookings IDs" present. Could indicate that the file has already been imported on a previous attempt.

Other validation conditions include:

  • the room names in the import file don't match those defined in Guestbook 24/7. Either change the data in the import file or edit the room names in Guestbook 24/7

  • conflicting bookings. Either two or more bookings in the import file have overlapping bookings for the same room or a booking on the import file has an overlapping bookings with a booking already in Guestbook 24/7 for the same room.

Limitations

  • currently only CSV file formatted supported

  • by default only 100 bookings per file can be imported

  • by default only 1000 bookings in total can imported - can be increased with agreement, please contact us.

  • payment records information can not be imported. The total rate can.

  • only details of the main guest can be imported not the other guest.