...
We are going to use the IntegrationManager instance to load data into a specific partition. So, before we begin this process we need to create our partition connection.
First, select your IntegrationManager instance from list:
...
2. Then, open your Connections for this integration instance to verify that the partition connection has been defined and deployed:
...
Access Integration Templates
...
Navigate to Marketplace and select Integration Templates
Select the Import CSV from FTP to Pricefx option:
Click on the Deploy button.
From the drop-down list select your IntegrationManager instance. Click on the Deploy button.
The import wizard will now begin:
| Info |
|---|
NOTE: When using Integration Templates option, |
...
it will display all IM connections that are of a specific type and that type is called “pricefx”. It will |
...
present these in a drop-down list and if it doesn’t exist then this step will fail. |
6. Click on the drop-down list for Pricefx connections:
...
| Info |
|---|
Only by selecting a partition connection can the deployment process continue. |
7. Update the Name to CSV Import-Product, then click Next button.
8. The CSV FTP import panel will appear:
...
9. On the panel, we will need to input the FTP information received via email for Instance Manager (userid, password, server and port address). Refer to this email for this information.
...
Next, we need to update FTP path to reflect the location on the FTP server where uploaded file will be stored. All IM servers have a default path of /filearea/inbound, we will append to this the folder for our integration data. Update FTP path to /filearea/inbound/products.
Click Test SFTP Connection button.
Click Next button.
Next, we need to drag and drop our CSV file for the upload:
Drag and drop ProductMaster.csv onto the page.
The default parsing will appear for the first three rows:
Verify that the CSV file is being parsed correctly. Click Continue button.
Next, we need to select the Entity Type of Product:
Now we need to perform the data mapping to link our CSV columns to Product Master in our partition:
...