Data Dumps

If you need an "offline" copy of your data, we can provide it as a "dump" of the Insights database documented on this website. This dump service is available at a standard rate - contact our support team for details.

Important: Most date/time fields are in the venue’s local time zone. However, some are “time-stamp” fields which were generated by the system; these will be in UTC (aka "Greenwich Mean Time"). These typically end with “_on” -- examples:

  • created_on
  • booked_on

Contents of the data dump

When you receive the dump, you will see two different files:

  • csv.zip - This contains all of the Insights data in standard comma-separate text files that are compatible with Excel and many other programs. Each file corresponds to one of the views.
  • private-files-*.zip - This contains all of the documents and attachment files (images, contracts, etc.) that were attached to the various events, accounts, etc.

Using csv.zip

Unzip the csv.zip to a folder and you will see a list of files that looks like this:

vw_account_addresses.csv
vw_account_credits.csv
vw_account_emails.csv
...

Each of these files corresponds to one of the views in the Insights database and contains the same rows and columns. These files are in standard comma-separate text files that are compatible with Excel and many other programs.

Documents and attachment files

You will receive a file named private-files.zip, or possibly several files with names like private-files-001.zip and private-files-002.zip. Unzip these to a folder and you see a list of files that looks like this:

7e488a9955d54c97a5d30449bdaa1f4f
3dd2497866304308aed3e76b21a2edfe
9cd89006b3554e3d887dcf34c30c26bb
...

These names are ugly -- sorry! -- and you will have to some digging in the CSV data in order to make sense of them. These are obviously not the original file names; instead they are "File Ids." Anywhere in an Insights view that you see a FileId column, that will contain one of these Ids and you can then locate the physical file for it.

For an example, let's take the vw_event_documents view.

  • event_id will contain an EventId - such as event-1-A
  • file_id will contain the FileId - such as 7e488a9955d54c97a5d30449bdaa1f4f, which will correspond to a physical file in private-files.zip
  • name will contain the original name of the file - such as Smith Wedding Proposal.pdf

Important: Do not expect the number of document files to equal the number of rows in vw_event_documents. Document files are used for multiple purposes such as invoice PDFs, system report definitions, and so on.

Requesting MySQL Backup

In addition to the CSV data described above, it is also possible for us to send a full backup of the actual MySQL database. This requires technical knowledge to restore to a database server and then run queries against it, but if you have this expertise you can use it to more easily integrate the data into your organization's IT systems.

In this case, you will receive a sql.zip file which contains a single .SQL file containing the raw data backup.