User documentation

  1. Home
  2. User documentation
  3. Booking Activities (advanced)
  4. Export bookings and events

Export bookings and events

1. Export events to iCal and Sync on a calendar app

You can export your events in iCal format (.ics) in order to add them to your favorite calendar app (e.g.: Google Calendar).

  • Create a booking form
  • Configure the “Calendar” field to display the events you want to export
  • Click on the “Calendar” field “export” icon ()
  • Click on the “Export” button in the dialog to get your file
  • Alternatively, you can copy the provided URL and use it to synchronize this calendar field events to your calendar app

Here is the difference between exporting or synchronizing:

  • Export: The events you can see now are exported
  • Sync: The events you can see now are exported. But if in the future, events appear (or disappear) on this calendar field, they will also appear (or disappear) on the synced calendar.

Note that the given URL always provide real-time data. But your calendar app never synchronize in real-time. It may synchronize every 24h or more, so it is normal if your events are not updated in real time on your calendar apps.

The process to import the given file, or to sync the given URL on your calendar app only depends on it. Please check your calendar app documentation.
For example, with Google Calendar, here is how to import iCal files, and here is how to create a calendar from a link.

 

2. Export bookings to iCal and Sync on a calendar app

Your customers also have their own link to export and synchronize their bookings on their calendar app.
You can give them via the notification system.

  • Go to Booking Activities “Settings” menu
  • Go to the “Notifications” tab
  • Select any notification sent to the customer (when a booking turns “booked” or “pending” are relevant)
  • In the message, add the {user_ical_url} tag
    • Tip: You can use the following code <a href="{user_ical_url}">Download your bookings</a> to make a link to the .ics file

This tag will display their personnal URL to export all their bookings. If the customer has made a booking without account, this url will export only the current booking.

On your side, if you want to export bookings as iCal, you need to follow the instruction given in 1., and configure your “Calendar” field to display bookings only.

 

3. Export bookings to CSV and Sync on a speadsheet app

You can export your booking list as a CSV file, along with a lot of bookings data. This is useful to exploit your booking data on spreadsheets (e.g.: Google Sheets, Excel).

  • Go to Booking Activities “Bookings” menu
  • Configure your filters to display the bookings you want to export
  • Select “Export” in the “Bulk actions” selectbox, above the booking list
  • Click on “Apply”

A dialog appears, you need to configure what booking data you want to export:

  • First, choose if you want to export one row per booking groups, or if you want to export one row for each booking of each groups
  • Then, choose the data (the columns) you want to export
    • Tip: mind the order you add the data. It will be the order of the exported columns.
  • Finally, choose whether to set a limit to the number of bookings to export
    • Tip: If you don’t set any limit, it may take more time to export.
  • Click on the “OK” button to generate the export link
  • Click on the “Export” button in the dialog to get your file
  • Alternatively, you can copy the provided URL and use it to synchronize this booking list to a spreadsheet

Here is the difference between exporting or synchronizing:

  • Export: The bookings you can see now are exported
  • Sync: The bookings you can see now are exported. But if in the future, bookings appear (or disappear) on this list (with the current filters applied), they will also appear (or disappear) on the synced spreadsheet.

Note that the given URL always provide real-time data. But your spreadsheet app never synchronize in real-time. It may synchronize every 24h or more, so it is normal if your bookings are not updated in real time on your spreadsheets.

The process to import the given file, or to sync the given URL on your spreadsheet only depends on it. Please check your spreadsheet documentation.
For example, with Google Sheets, you need to use the IMPORTDATA formula for synchronization, or follow these instructions to import a CSV file.

Was this article helpful to you? Yes No

How can we help?