Sometimes you need to integrate data between two systems, where System_A can export a CSV file and System_B can import a CSV file. Although both systems generate and read CSV files, the files have different structures, with different fields or different field name and order.
This guide will show how to use FileSculptor to process the CSV file exported from System_A and create a CSV file with the structure expected by System_B.
In the example below, System_A exports a CSV file with products data using this format:
Whereas System_B imports a CSV with product data in this format:
The first screen shown is the Import screen, where you can select the file to import.
Keep the File Type as CSV and click on “Browse…” button to select the CSV file generated by System_A on your computer.
Click on Transform tab to create calculated fields with data needed by System_B.
Create calculated fields to convert the fields Productname and Productdescription to upper case, using the function UPPER:
Create calculated fields for the fields that are expected by System_B but doesn’t exist in the file created by System_A, giving them default values.
Now FileSculptor has enough fields to create the destination CSV file.
Click on Export tab to show the configure the file to export. Select the CSV format and click on “Browse…” button to define folder location and file name. You can use an existing file or create a new file.
Then select fields from the source, and calculated fields, reorder them to the same order expected by System_B.
Click on the Field Properties… button to change the header of each field to the header expected by System_B.
Click on Run tab to do the conversion. Click on “Run Now” button and FileSculptor will process the source file and write data to the destination file, creating a new file if it does not exist.
Open the generated CSV file with NotePad to view it contents.
Save the project to do the same file conversion again when needed. You can also use the Automation tabs to create an icon shortcut on the desktop to do the conversion with one click or the parameters to create a scheduled task or run from command prompt.