Importing Forward Bookings – error messages

Invalid format: "YYYY-MM-DDTHH:MM"

The date you have used in either the START or END column is not in the required format

As the message suggest the date needs to be edited to be in the format YYYY-MM-DDTHH:MM and then the booking needs to be reimported

ownerEmail: may not be empty

The column 'Owner Email' should contain an email address as ALL bookings need an owner and an owner is an email address.

Please resubmit after providing a suitable email address - if that email does not exist as a user then a user will be created for it.

ownerEmail: not a well-formed email address

The email address provide for the owner of the booking is not a valid email format

Please check that there are no spaces in the email, that there is an @symbol and that there are no other symbols such as semi colons or commas and resubmit

Please enter a cost code for the booking.

You are trying to import a booking to a resource that has 'Cost code is mandatory' but you have not provided a cost code in the import file.

Either resubmit with a cost code included in the upload file or remove the setting from the resource that makes the cost code mandatory and resubmit.

timeFrom: may not be empty

The booking being imported does not have a START  time and therefore cannot be imported

Please correct the Start time field so it refelects when the booking is due to start and resubmit.

timeTo: may not be empty

The booking being imported does not have an END time and therefore cannot be imported

Please correct the END time field so it refelects when the booking is due to finish and resubmit.

New bookings must start within the last quarter of the hour.

You are trying to import a booking that is starting in the past. We cannot import bookings in the past.

Please edit the START time so it is a future date / time.  It can be same date but the time always needs to be in the future.

status: must match "(TENTATIVE|CONFIRMED)" ownerEmail: not a well-formed email address

The booking status field is empty or has an incorrect value (Values are TENTATIVE or CONFIRMED).

Currently bookings can only be tentative (ie they still need to be approved) or confirmed. Most bookings being imported will be in confirmed status so please ensure this field reflects that (it is also case sensitive and requires all uppercase) - once this is corrected then the bookings will need to be resubmitted.

Unable to identify the location [LOCATION]

The location field is the name of the resource that the booking is being imported in to. This location field must match EXACTLY the name of the resource in Matrix Booking (including spaces and with case sensitivity)

Correct the import file so the name of the location matches the name within Matrix Booking exactly and resubmit file.

An overlapping booking already exists for this desk at 6:30 AM, 3 Aug - 6:30 AM, 3 Aug 2022.

You have tried to import a booking to a resource however that resource already has a booking in that slot therefore this new booking being uploaded is being rejected.

View the booking that is currently there (using the all bookings view, the resource name and the date) and decide if the existing booking should stay (in which case ignore error and move on) or if the booking being imported is the one to use, in which case delete the booking using the All bookings view and resubmit the file  with just that single booking in or click RETRY 

Multi day booking not enabled in your Organisation.

You have tried to importa booking that spans more than one day (ie a single booking that runs past midnight rather than a repeat booking) but the resource you are trying to import to does not have multi day bookings enabled.

Either edit the booking to be a single day with a repeat or amend the setting on the resource to allow multiday bookings and resubmit the file

Only one desk booking is allowed at a time – you already have B225 booked from 12:31 AM, Thursday 4 August 2022

You have tried to import more than one booking in a certain period for a specific user but there is a setting attached at the CATEGORY level that says only x bookings are allowed person and you already have reached that limit.

Temporarily remove the limit from the category and resubmit the file and then reapply the booking limit, or find an alternative to user to assign the booking to (Owner email) and then resubmit file.

ownerEmail: may not be empty timeTo: may not be empty timeFrom: may not be empty

This is an example of when MULTIPLE errors occur in the import file. Each error will normally be highlighted. 

Each of the errors needs to be resolved, each error will have its own entry in this list