Project

General

Profile

Export

since 3.8.0, available for admins and managers

Export SQL

When clicking the Export SQL button a new SQL dump will be created (pg_dump).

  • SQL dumps are saved in the export/sql folder
  • Filenames begin with the date and time e.g. 2018-08-23_1533_dump.sql.
  • Existing files are shown in a list and can be downloaded or deleted (only admins can delete)
  • If the directory isn't writeable, a warning will be shown on admin and admin > Export SQL

Export CSV

When clicking the Export CSV button a new CSV export file for all marked tables will be created.

  • CSV eports are saved in the export/csv folder
  • Filenames are constructed from the date, time, database schema and database table name e.g. 2018-08-23_1533_model_class.csv
  • Existing files are shown in a list and can be downloaded or deleted (only admins can delete)
  • If the directory isn't writeable, a warning will be shown on admin and admin > Export CSV

Options:

  • Export as ZIP and add info file: if selected all files are compressed and an info file with date, username and domain will be added
  • Created and modified dates: if selected additional columns for creation and last modified dates will be added
  • GIS format: how to format GIS data
    • Coordinates: eg. "15.44986724853516 47.06591257216972", in case of polygons a centerpoint will be calculated (ST_PointOnSurface)
    • WKT: WKT (well known text) e.g. POINT (15.44986724853516 47.06591257216972)
    • PostGIS geometry: PostGIS geometry format