Export, Import and Query Tools

• General Overview

You can export the data to CSV file. Similarly, you can import from CSV files.

Export

Type: It is the table you want to export.

Columns: Either select the columns from the dropdown or enter names of columns as comma separated values.

Order (Optional): It is the order in which data will be exported. For example: id DESC

Limit (Optional): The number of records to export. If empty, it will export all the records.

Offset (Optional): The offset value for exporting data.

Filter (Optional): Here, you can add one or more where conditions to export certain set of data.

Import

Type: It is the table where want to import data.

Columns: Enter the names of the columns separated by comma. This should match with the ordering in the CSV file.

CSV File: Upload the CSV file. The CSV file should not contain ID column as it is automatically generated.

Available Columns: This is for reference. It contains all the columns available in the table.