From the import tab it is possible to import sql statements or data series in csv.

The sql files are executed without doing any checks on the data.

Enter or update data via CSV

Be careful to load the sql or csv files correctly in their respective input forms.

Delimiter is the character used to divide the column data in the csv
Use first row as Headers If checked the first row will not be imported
Update Preview Updates your chosen settings.

Choose Action

Create table

Create a table in the database starting from the columns of the csv. You will choose later which fields to associate.

Insert / Update records

Select the table and link the fields of the csv to insert. If you associate the primary key with a field, if it exists it will update the row, otherwise it will create a new record.

You can select multiple tables and choose which csv columns to insert in one or the other table. Each time a column is inserted or updated, a field is generated that you can insert in the next table to create a relationship between the two tables.

If you want to modify a field you are inserting, after selecting it in the associations table, change the selection to [custom text]. The related shortcode will appear. At this point you can use all the instructions of the integrated template engine.

Test the import

Generates and runs an import test on temporary tables and displays the result. Check it carefully to avoid any unpleasant surprises when you import the data. If a column does not appear to contain the expected data, perhaps you are trying to insert an incorrect data type (such as a number in a date field).

I feel lucky, import the data

Import the data. Once the operation has started, there is no going back. Once the import is complete, download the report, it will contain the rows of the csv with new columns with the ids associated with the import and the result of the queries.