Forward booking import error messages

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

The date you have used in either the Start or End column isn’t in the required format.

Change the date needs to be in the format YYYY-MM-DDTHH:MM.

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.

Provide a suitable email address. If that email address doesn’t exist as a user, a new user will be created for it.

ownerEmail: not a well-formed email address

The email address provided for the owner of the booking isn’t a valid email format.

Check that there’s an @ symbol, that there are no spaces in the email, and that there are no other symbols or special characters.

Please enter a cost code for the booking.

You’re trying to import a booking to a resource that has the Cost code is mandatory setting, but a cost code hasn’t been provided on the import file.

Either:

• Enter a cost code where it’s needed.

• Remove the setting from the resource that makes the cost code mandatory.

timeFrom: may not be empty

The booking being imported doesn’t have a start time, and therefore, can’t be imported

Add the start times to all bookings that don’t have them.

timeTo: may not be empty

The booking being imported doesn’t have an end time, and therefore, can’t be imported.

Add the end times to all bookings that don’t have them.

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

You’re trying to import a booking that’s starting in the past. The system can’t process previous bookings; only future ones.

Change the start times to all bookings that are currently set in the past.

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.

Change the status to all bookings that aren’t currently set to TENTATIVE or CONFIRMED (case sensitive).

Unable to identify the location [LOCATION]

The location field is the name of the resource that the booking is being imported into. This location field must match exactly to the name of the resource in Matrix Booking, including any spaces and with case sensitivity.

Change the location to all bookings that don’t match exactly with the location name within Matrix Booking.

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

You’ve tried to import a booking to a resource, but that resource already has a booking in that slot. Therefore, this new booking being uploaded is being rejected.

Remove one of the overlapping bookings either in Matrix Booking or the import file.

Multi day booking not enabled in your organisation.

You’ve tried to import a booking that spans more than one day (a single booking that runs past midnight rather than a repeat booking), but the resource doesn’t have multi-day bookings enabled.

Either:

• Edit the booking to be a single day booking

• Edit the booking to be a repeat booking

• Change the setting on the resource to allow multi-day bookings.

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

You’ve 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 per person and that limit has been reached.

Temporarily edit or remove the limit from the category until after the file has been imported again.

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 error needs to be resolved, and will have its own entry in this list.