Export Config

You can change export format or path here.

export tables

Select which tables will be export, all tables by default. Alternatively, if you want to export only the specific tables, you can select tables individually.

 

export format

1. xls

An excel file will be export hold the data tables, you can change the file's path and name.

If you check the export column headers option, the columns' names will be exported to the first row.

 

2. csv

Every data tables will be export as a csv file, here you can change the directory to hold these exported files.

If you check the export column headers option, the columns' names will be exported to the first row.

 

3. sqlite

Export tables to a sqlite file, and you can change the file's path and name.

 

4. xml/html

Export table to xml or html file, here you can change the format as you like with the grammar of Django Template (http://django.readthedocs.org/en/1.2.X/topics/templates.html).

 

5. json

Export table to json file.

 

6. database (just for Pro/Mac edition)

Here the data tables will be export to the database by ODBC engine, the database connection string will be automatically generated by filling some fields(e.g database type, username, password), and you can also manually fill ODBC connection string for any database.

NOTE: To export tables to database, you should make sure the database has the same tables and columns as the exporting tables.

 

Add a unique time suffix to the output file/folder name

 

Add time suffix to the output file/folder name when export data, For example: when set output file path to output.xlsx and checked this option, the output file will like these:

output_2013-08-02_17-49-31.xlsx
output_2013-08-02_17-49-37.xlsx
output_2013-08-02_17-49-39.xlsx
output_2013-08-02_17-49-42.xlsx