With Beacon, it's easy to export data from your database in the way that works for you. Whilst you can do ad-hoc exports directly from record list pages, often you'll want to export data in a standard format that only includes the data that matters to you.
Meet export templates. You can manage your templates in your sidebar: Export data > Manage templates.
Check out our overview of exporting data in this video:
When exporting your data, you can choose either CSV or PDF as your export format.
CSV is the tried and tested format for moving data into spreadsheets and between system. If you need access to the raw data then this is the format for you.
PDF is for exporting data into a beautiful bank-statement-style file. This is often useful when presentation matters, like when you're reporting internally or to clients. Here's an example.
With export templates, you can define and label the exact columns you'd like to export:
Since you have a lot more control over the columns, export templates make more columns available to you than ad-hoc exports.
link Filters: fixed or dynamic?
You can define your export templates to have either "fixed" or "dynamic" filters - and they're each useful for quite different things.
link Dynamic filters
Dynamic filters allow you to define a standard format for exporting a particular record type in Beacon. You can then export records directly from the record list page.
You'd like to export people from the people list page that meet a wide variety of conditions, so they can be uploaded elsewhere. Each time you run the export, the filter criteria is quite different.
link Fixed filters
Fixed filters are... fixed. They don't change. You can "run" your fixed exports from the Export data > Run export page. (As opposed to record list pages)
Every month, you want to export all of the donations that were made last month. You don't want to define the filters each time, you just want to go and click a button to run the same export with the same set of filter criteria.
link Sending emails
For export templates using fixed filters, Beacon makes it possible to send your exported files as attachments via email to one or more people.
link How it works
After running an export from the Run export page, you'll see the options to download the file, and dispatch the file as an email attachment:
If sent, the recipients defined in the export template will receive an email similar to the below:
The exported file will be attached to the email:
link Configuring your emails
You can configure the recipients, sender, subject, and body in your export template settings:
Tip: the "recipients" of the email can be Beacon users, or any other email address for someone who isn't a Beacon user.