Prior to this step, we have created defined the mapping between CSV and Product master, identified the partition and SFTP connections and which IntegrationManager instance will be used for the loading process.
We will need to perform the upload itself using an FTP client. Using this FTP client, we will push the actual CSV file onto the Integration Manager instance.
-
Start the WinSCP FTP client and define a new FTP session using IM instance provided earlier when it was created:
-
Make sure the protocol type is set to SFTP.
-
Then, use the host name, port number, user name and password provided in your IM activation email and update the Login panel.
-
Click Login button.
-
Connection should be successful:
Upload Data File
Upon successful connection it should open FTP server path:
6. On the left-side, we will need to locate the path to the Product Master CSV file that you wish to upload - this is a path on your local machine. ( Reference Lab Step 2 )
NOTE: In this example I have positioned myself on a directory path on my C drive where all the CSV files for uploading are located.
7. Next, on the right-hand side is the FTP target path - a location on the FTP server. We will need to drill down to /filearea/inbound/ path.
8. If the products folder beneath the /filearea/inbound/ folder does not already exist, perform following: Click on the New option and choose the Directory option:
-
Define the directory name as products:
NOTE: With the addition of the products directory, the file path will match the FTP path that was defined during the creation of CSV FTP integration template process.
9. Drill down to the products folder:
10. Next, we will upload our Product Master CSV file to this folder.
11. As soon as it appears, then the FTP process will be initiated, and the uploaded data will be visible in our partition. Drag and drop ProductMaster.csv file.
12. If using WinSCP it will appear as:
13. Click OK button.
14. File upload should be processed in 10-15 seconds.
15. Return to your IntegrationManager instance and select the Integration Overview and review your log file for confirmation that the uploaded .csv file has been consumed.
16. Return to your partition and verify that Product Master has been loaded successfully.
NOTE: Care should be taken to ensure that the .csv is encoded in UTF-8 versus something such as ANSI. The Camel Route, by default, will expect UTF-8. One means of accomplishing this is by using an editor which displays and allows conversion from one encoding format to another ( i.e. Notepad++ )
