✨ This feature is in beta, please contact us to report any issues.
Introduction
Tito already allows you to download attendee and order data as a spreadsheet but we’ve now added a custom option for better control over data columns, ordering and formatting.
Getting started
Custom Exports first need to be defined at the account level. Go to your Account Settings, click “Custom Exports” in the side menu, and “Create a custom export”.
The template starts with some initial fields to get you started.
From here you can add, remove and modify columns to suit your requirements:
Click on the column headers to change the label for that column
Click on any of the cells (e.g. “{{registration.reference}}”) and choose other values from the options provided.
You can even type in your own custom values and format the cell exactly as you want. The export uses Mustache and supports whatever Mustache allows.
Using your custom export
Once you have created your custom export template you can navigate to the relevant event. You can then find your template either under the Attendees or Orders view depending on the type of export you created.
Custom exports are only available in the .csv format so choose “CSV” and you will see your custom template along with the standard Tito export option.
Exporting the CSV will give you something like this:
Advanced options
When creating your custom export template clicking “Show advanced options” gives you access to the “Add line” and “JSON” options.
Add line
Each “line” in the export is a line per record. So in the above example you would get two rows in your export per order, like this:
JSON
Switching to the JSON tab exposes the code used to generate the custom export. From here you can edit the JSON directly if you wish although please note that invalid JSON will cause an error — this option gives you the power to break things!
