Bookings

Files

File Type Description
bookings/booking.csv main Contains each booking (appointment) that the business would like to import.
bookings/client_bookings.csv linked Each booking may optionally have 1 or more clients associated with it.

Fields

booking-types/booking-type.csv

Field Required Type Description
unique_id required string The id of the booking.
book.id required relation:"books.id" The book (calendar) that this booking is on.
employee_bookings[].employee.id required relation:"employees.id" The employee id that this bookings is linked to.
employee_bookings[].is_taken required boolean Wether or not this employee has taken the appointment.
booking_type.id required relation:"booking_types.id" The booking type that this booking uses.
booking_time.start_time required datetime The start time of the appointment.
booking_time.end_time required datetime The end time of the appointment.
remarks optional string Any notes that should be attached to the appointment.
is_canceled required boolean Wether the appointment has been canceled or not.
is_chargeable required boolean An appointment is "chargeable" if it needs to be deducted from the clients service bank when taken/canceled/no-showed. For most appointments this will be true but for some canceled appointments it might be false.
has_sent_email_reminders required boolean Wether or not email reminders have been sent for this appointment.
has_sent_text_reminders required boolean Wether or not text reminders have been sent for this appointment.
has_auto_reminders required boolean Wether or not automatic reminders are enabled for this appointment.
booked_at required date The date this appointment was booked.

booking/client_bookings.csv

Field Required Type Description
booking_unique_id required linked-id The booking unique_id that links this back to the main booking.
client.id required relation:"clients.id" The id of the client.
is_no_show required boolean Wether or not the client was a no-show.
is_taken required boolean Wether or not the client has taken the appointment.
is_verified required boolean Wether or not the client was verified for the appointment.
verification_method optional verification-method If the client was verified for the appointment, which verification method was used.

Required Rows

none