February 18, 2019

Excel to CSV using SFTP In IICS

Problem Description Customers/Users face issues with loading Excel files from SFTP remote server to local machine and convert the excel file to CSV file in mapping on IICS. Challenges to User/Developer In IICS, above-mentioned problem can be solved through Java Transformation. The Excel file needs to be transferred to the local machine (where the secure agent is installed). The locally available Excel file needs to be converted to CSV file. Move the original Excel file which we got from SFTP remote server to other location.