Workflow Tutorial: Integrating CSV Files

Readin', writin' and CSV files. Sounds like a good time. Create a project to make a copy of the selected CSV file using the ReadCsvFromFile component and the WriteDynamicDataToCsv component.

Prerequisite: A file saved in the CSV format. A sample can be created using Microsoft Excel.

Objective: To learn how to use the ReadCsvFromFile component, the WriteDynamicDataToCsv component and the WriteFile component.

Estimated time to complete: 30 minutes

Step 1: Create a new Decision Only project.

Click to view.

Drag and drop the ReadCsvFromFile and the WriteDynamicDataToCSV components from the Components palette under the Process Components / Dynamic Data category.

Drag and drop the WriteFile component from the Input Output / Files category.

Link the components together as shown below:

Click to view.

Step 2: Set the Input Data as shown below:

Click to view.

Step 3: Right click on the ReadCsvFromFile component and select Edit Component. Click the selector box next to the File field. Select 'CSVFile' as the variable name. Also, in the Output Variable Name selector box set it as 'RetValue'.

Click to view.

Step 4: Right click on the WriteDynamicDataToCSV component and select Edit Component. Click the selector button next to the Collection field. Click on the Add Array button in the Variable Data tab and set the variable as 'RetValue'.

Click to view.

Step 5: Click the selector button next to the File field. Select 'CSVFile' as the variable name.

Click to view.

Step 6: Right click on the WriteFile component and select Edit Component. Set the File Variable Name as 'CSVFile'.

Click to view.

Step 7: Set the Output File Name by entering a file path in the Constant Value tab e.g. e :\newcsv.csv

Click to view.

Step 8: Save and Run the project. Click the Run project button on the toolbar (bug with green arrow over it).

Step 9: Double click Execute and click the selector button next to the CSV File field. Click the selector button next to the Contents field.

Click to view.

Step 10: Select a CSV file and click Open.

Click to view.

Step 11: The results are displayed in the Execution window. In the respective folder a copy of selected file will be created with the given name.

Click to view.

Step 12: Finished!