Saving and Using Templates During Data Export

Template is a set of export settings stored in a file.

It’s no use wasting your time on selecting the same settings each time you export data. Select once, save multiple settings to a file, and use it to have customized export without efforts.

For example, you need to export data from an existing table to text format once a day. You can set up the export options once, and next time all you need to do is to select the Text export format and a location of the data source and click Export. To illustrate the case, let’s export data from the sales database to the sales_export.txt file, create a template, and then use it.

To create a template:

On the Database menu, click Export Data.
In the Export format tab, select Text.
In the Source tab, select a required connection, a schema, and a database if needed.
In the Options tab, set text alignment to Left, the column length to 60, and click Next.
In the Output settings tab, specify a path and a name of a destination file (the one where the exported data will be saved.) Click Next.
To start exporting the data, click Export.
To save all settings, click Save Template and specify a name and a location of a template file in the Save As dialog box. This template will appear in the User templates area of the Template section.

To load a template:

On the Database menu, click Export Data.
In the Templates section, select a previously saved user template.
To save the exported data, specify a path and a name of the destination file .
In the Source tab, select the Source connection, database, schema, and table.
Other user’s settings are loaded automatically.

Want to Find out More?

Download a free 30-day trial

Saving and Using Templates During Data Export

To create a template:

To load a template:

Want to Find out More?

Overview

All features

Request a demo