/
Export Pricefx Table to CSV via FTP (Templates)

Export Pricefx Table to CSV via FTP (Templates)

Owned by Mike Deskis
Last updated: May 11, 2022
2 min read

Overview

This integration template will export 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. It utilizes the connection to the partition to extract the selected data, converts it into CSV format, and then after connecting to the SFTP server it updates the corresponding folder.

 

Installation

For the installation process to work successfully, you will need to following available:

  • Partition connection

  • SFTP connection

  • Product master table

  • SFTP outbound folder

  • Extract schedule

To perform the extraction via this template, go to PlatformManager > Marketplace > Integration Templates, find Export Pricefx Table to CSV via FTP, select Deploy and then select a target integration instance.

During the installation dialog, you will have the opportunity to provide specific attributes that impact the export process (scheduling, Pricefx object type, export folder, etc)

Additionally, during the export process we can determine which particular attributes of the Pricefx object we need to extract the CSV file. This will create a mapping file that will link the attributes of the object in Pricefx to columns in the CSV file.

NOTE: You can select only those attribute columns that you need in the CSV file using the Add Field button on the panel. You can use either the internal names (as defined in the metadata) or the attributexx versions (attribute1, attribute2, etc).

Related content