The export process is compiled by 3 steps:

  1. Database/table – where you choose the database/table you wish to export.
  2. Settings – where you configure all the necessary settings.
  3. Export – where you verify if everything is good and start.
Step 1 - Database/table interface
Step 1 - Database/table interface


Here you will define what database and table you want to export. First select your database (if you added more than one database in the settings), and after that you can choose your table. When finished, click on the next button right below.


In the second screen of the export process, you can see a couple of fields/elements. We have:

  1. Location - where you choose the location of the file to export to.
  2. CSV settings - where you select the settings of the exported fiele.
  3. Mapping - where you will map the CSV columns with the DB fields.
  4. Filter - where you decide which rows you want to import.
Step 2 - Settings interface
Step 2 - Settings interface


Here you will define where you want to export the CSV file to:

  1. Desktop - the CSV file is saved on your computer.
  2. FTP - the CSV file can be saved on a external FTP server.
  3. Server - the file can be saved on the same location as the CSV Import & Export application (on the current server).

CSV settings

Here you will need to set your CSV file settings. By default, the system will fill the needed fields header, delimiter, enclosure and encoding with the default values. You can change this default values in the Settings > Export tab > CSV settings.


After you have entered the CSV settings, you will have to set the column names for your .CSV file. Our system automatically uses the same name as in the database fields, however, if desired, you can change this to your own input.

On the left of every db field row, you can see the icon that once pressed allows you to move the db field row up and down, so you can change the order of your output CSV file.

On the right of every db field row, you can see the icon. When you click this, the selected DB row will not be included in the export file. If you accidently have removed a row, you can add it again by pressing the ADD button left below, and select the row that you removed.

When all is done, go to the filter section to complete this step.


With the filter you can choose which specific rows you want to export. You can enter row for row that you want to export by using the “,” sign. For instance, if you only want to export row 1, 2 and 10, your input in this field is:


When you want to import row 1, 2 to 5, 10 to 20 and 30 till the last row, your input in this field is:


As you can see, the “-“ symbol represents all of the remaining rows. If you just want to export all the rows, just leave this field empty.

When all is done, click on the next button right below.


In this final screen before you start the export, you can check all of your input and output one last time.

Step 3 - Export interface
Step 3 - Export interface


Export instructions.