Skip to content

Import Export

giuliopanda edited this page Dec 5, 2022 · 4 revisions

From the database menu you have various tools for exporting and importing files.

Export

You can export data to CSV from a query or by selecting the values you want to export. export

You can export the tables to SQL from the 'show all tables' page

export

You can import the csv or SQL data from the import page.

If you import from CSV you can create a new table based on the data from the csv before importing it. After uploading the file choose "create table" as action.

import-create-table

When you import data from a csv you can choose which columns to associate each single data with and test the import before executing it.

If you enter an existing primary key, the data will be updated, otherwise a new record will be created.

import-create-table

Export/import in the Form

The pro version of admin form also enables the possibility of exporting and importing data directly from the individual forms. When exporting you can choose either the bulk options as for the database or to export it from the appropriate tab. Here you have the option to export the RAW data. This special format will allow you to edit the data and import it back into the form. The system is able to import data even on several tables at the same time. If the row has a filled primary key, but all other fields are blank, then the record will be removed. If the primary key is empty then the record will be inserted.

Clone this wiki locally