Export Pricefx Live Price Grid to CSV via FTP

When Live Price Grid calculation finishes, this template exports approved or auto-approved LPG items to a CSV file and stores it on customer defined FTP server. The template will always export the following fields based on the Live Price Grid type:

• SIMPLE – sku, activePrice

• MATRIX – sku, key2, activePrice

Additional fields can be configured by the customer (see Configuration steps).

Integration created using this template uses Events produced by the Pricefx partition. For this reason, you need to configure the event CALCULATION_COMPLETED_PG to be created by the partition. See how to set up events in IM and in PlatformManager.

Installation

Go to PlatformManager > Marketplace, find Export Pricefx Live Price Grid 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:

   • Set delay between events fetch (in milliseconds), i.e. how often the template will poll the Pricefx instance for completed calculation events.

   • Set maximum events that can be fetched.

   • Decide which Price Grid Item fields will be exported to a file. Multiple fields are separated with comma (for example “typedId,sku,label“).

   • Set batch size when fetching Price Grid items.

   • Decide whether Price Grid items with negative prices should be exported too.

   • Enter directory path where exported CSV files will be stored (relative to the path defined in SFTP connection).

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

   • Enter name of the exported file. You can use the following tokens that will be replaced with actual values:
     [object.id] – ID of the exported Price Grid
     [timestamp] – time of the export
     Example: export_[object.id][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.