Export Pricefx Table to CSV via FTP

This template exports a CSV version of new/updated rows from any Pricefx table. The FTP location can be anywhere, but is most often placed in the outbound area of the Pricefx FTP area.

Note the following limitations:

• No file name editing; the name of the integration will be used when deploying in PlatformManager.

• There is no timestamp or flag reuploaded for exported rows. This means that there is no way to look at the data within Pricefx for validation that it was exported.

Installation

Go to PlatformManager > Marketplace, find Export Pricefx Table to CSV via FTP, select Deploy and then select a target integration instance and template version.

Configuration Steps

1. In Integration Initialization step, provide a name of your template installation and select a connection (or add a new one).

2. In the next step select an SFTP connection (or add a new one).

3. In Integration Properties step:

   • Define Cron expression determining how often the template will poll Pricefx to find new rows to export. This is set up using the Cron syntax which allows for very detailed scheduling.

   • Choose the directory in which to place the CSV file. When using the Pricefx FTP area, it is usually /filearea/outbound/.

   • Leave the default batch size. This setting has no affect on the final outcome.

   • Decide if you want to skip header row and not to have it included in the output file.

   • Enter delimiter which should be used in the exported CSV file. If you want to use a tab as delimiter, use \t.

   • Specify the maximum number of lines in the exported file.

   • Decide if incremental export should be used. If set to yes, the export from the Pricefx table contains only new records. If set to no, all data are exported (even if there was no change).

   • Specify custom timestamp column name. You enter here the name of a column which contains a timestamp information. Then the data will be fetched only if it was modified after the date defined in the column. The timestamp format is: "yyyy-MM-cc'T'HH:mm:ss" where “T” separates the date and time and is not replaced. Example: 2023-09-04T15:30:45.

   • Enter name of the exported file. You can use the following tokens that will be replaced with actual values:
     [object.type] – exported object type
     [object.name] – object name for extension objects
     [timestamp] – time of the export
     Example: export_[object.type][object.name][timestamp].xml
     If you leave the field blank, the default file name will be used.

   • Define your own timestamp in the exported file. It uses standard Java date and time pattern.

   • Decide if .done file should be used. If Yes is chosen, there will be an empty marker file created with the “.done” suffix added to the actual data file. This .done file is a signal saying that the export was completed.

4. Select a filter.

5. Create a mapper to choose which fields from the Pricefx table you want to be exported, and what you would like the header of the CSV to read.

Open