Dump Data with an SQL Statement

The following statement could be used to grab the data in the folder and dump it with admin account as the owner and the first folder in your system.

SELECT 1 as owner, name, description, data, 1 as folder FROM reporter.template

or use the following to capture your folder names for export

SELECT 1 as owner, t.name, t.description, t.data, f.name as folder
        FROM reporter.template t
        JOIN reporter.template_folder f ON t.folder=f.id
  1. Run the above query
  2. Click the download link at the bottom of the page
  3. Select the file format (CSV or Tabbed)
  4. Check download
  5. A text file with the report template data will be downloaded.