putBookings CSV

Import bookings from a CSV file

CSV file
save bookings
date format
Click submit once only or you may import duplicates.


1. Create a CSV file in the correct format.

You can do this by first downloading your bookings using: getbookingscsv

2. Create your CSV import file.

Use the file you downloaded. If you already have bookings in the file delete the rows and enter the information of the new bookings.

The first row must contain the header for each colum to identify the contents of that column. Each following row contains one booking.

Data has to be entered exactly in the required format and position otherwise the import can not work or will import false data.

The minimum information required is a roomid number, a check-in date and either a last-night or check-out date. The file must be CSV format, saved with UTF-8 encoding and use commas, tabs or semicolons to separate the data fields.

The REF number must be blank for new bookings or the booking id number of an existing booking to modify it. If it is the word GROUP, the booking will be added as a new booking to the previous booking in the file to create a booking group.

The Roomid number must be set to a room id in your account, otherwise the booking will not import.

To reliably import dates use the FirstNight and one of LastNight or CheckOut columns (no space between words), the dates should be in YYYY-MM-DD format (i.e. 2015-01-30). The unused date columns can be deleted or left blank.

If the dates are not in YYYY-MM-DD format they must be in English and use the date format selector to specify the order of month and date.

Valid values for the status column are the words New, Confirmed, Cancelled Request or Black.

Valid values for the sub status must match a text available in the control panel selector for this setting.

If the Balance column is used, it will add a single invoice item to the booking to create the specified balance amount.

Not all columns can be imported, the preview will show the information that will be imported.

3. Preview import.

Upload the file WITHOUT ticking the "Save Changes" checkbox. A report will be shown of the information read from the file. If the preview shows errors fix them in your CSV file and upload again.

4. Import.

Imports cannot be undone. Only if you are sure the data is ok select the file again and tick the "Save Changes" checkbox and upload the file.


You should only use this function if you are comfortable working with CSV files.

It is a good idea to test with just a few bookings and upload a maximum of 50 at a time. It can take up to a minute to process a file, do not re-click submit while the file is processing or you may end up with duplicate imports.

Once bookings are uploaded they can only be deleted manually so make sure they are correct before making a bulk upload. If you upload the file twice you will create duplicate bookings.

The data fields (columns) must not contain the data seperator character within the data (comma, tab or semicolon) unless the whole field is enclosed in double quotes.

To check your file format import it into your spreadsheet with only a comma, tab or semicolon allowed as the field seperator.