Export Package

Export package is a specific kind of a package, which loads data from cloud applications and relational databases to CSV files.

Creating an Export Package

To create an export package, click +NEW in the top menu and select Export in the Integration column. When the package details page opens, perform the following steps:

  1. Specify a source connection you export data from and a target connection you load data to;
  2. Create export tasks for the package;
  3. Optionally schedule the package for automatic execution.

Source and Target Connection

Source Connection

Under Source, in the Connection list, select a source connection you want to use from the drop-down list or create a new one if you have not created it yet. You can use the Type to filter box to quickly find the necessary source connection. In order for you to create a new connection, click +New connection in the drop-down list (learn how).

Source Connection

Target Connection

There are two scenarios of data export to target:

  1. By default, data are exported to CSV file(s) downloaded manually.

    Target Type 1

  2. If you want to save CSV file(s) to a file storage service or FTP, click CSV to storage service in the target type. After this, click Select target and select a target connection or create a new one if you have not created it yet. In order to create a new connection, click +New connection in the drop-down list.

    After this, select the Folder where to place the result file(s).

    Target Type 2

Additional Options

If necessary, specify the Code Page of the exported file with data.

Code Page parameter

Additionally, you may click the More options link and specify CSV options shown below to detect columns correctly.

CSV Options

The Append timestamp to the file name checkbox determines whether to add the timestamp to the end of the result CSV file name. It is applied only for export tasks using simple mode, and only if you don’t specify the custom target file name in an export task.

This check box is selected by default. This means that the result file name will consist of the name of exported object and a timestamp of package run, for example, Account_20211201_1447.csv. If you clear this check box, the result file name will be the same as the name of the exported object.

Please note that if you specify a custom target CSV file name in an export task, it will not be followed by the timestamp regardless of this checkbox.

The Exclude header in target CSV checkbox determines whether to exclude the header row (with column names) from the result CSV file.

Creating Export Tasks

To create an export task, click the Add new link and configure a new export task as described in the How to Create Export Task topic.

How to Download Exported Files

After you create a package, the following three tabs are displayed in the middle of the toolbar of the details page: Model, Monitor and Log.

The Model tab shows source and target connections, tasks/schedule/parameters of the package, etc.

The Monitor tab shows 5 most recent package runs and whether the package is currently running.

The Log tab shows runs for the selected period.

When you export data to a CSV file, you can download the result file manually in the following way:

  1. Сlick the Monitor tab of the package details page.

  2. In the open tab, click the package run you want to download the results of.

    Run History

  3. After you do it, the History Details window will open with detailed information.

    History Details window

  4. Under Result, click the number of records to download the result CSV file.

Files are available for download for 7 days since the package run.

Note if you have more than 5 package runs, you cannot see all of them on the Monitor tab. Instead you should go to the Log tab, which shows all package runs for any selected period.

To download the result file, perform the following steps:

  1. Click the Log tab of the package details page.
  2. Select Last 7 Days.
  3. Click the package run you want to download the results of.
  4. After you do it, the History Details window will open with detailed information.
  5. Under Result, click the number of records to download the result CSV file.