Exercise 1.3 – Using a Format

Create a Route

1. 1. From the eiConsole File Management screen, select the Add Route button.
   2. In the dialog that appears, enter the name Using a Format and select OK.
   3. The Route should now appear in the table on the screen. Double-click it to open it.

Document the Source System

1. 1. Select the Source System stage in the Route Editing Grid. The configuration panel will appear at the bottom.
   2. Change the System Name to CSV File.
   3. Select the Choose Source Icon button, and scroll down to select one of the CSV icons.

Configure the Listener

1. 1. Select the Listener stage in the Route Editing Grid. The configuration panel will appear at the bottom.
   2. Select Directory/File from the Listener Type selection box. Optionally, click the … button to open the Module Search Dialog, which provides a faster way to find the module you’re looking for.
   3. Assign a polling directory, using the … button to open the file selector. The polling directory should NOT be the directory with all the sample files, since files will be moved/deleted by the listening process.
   4. Go to the Post-Process tab and select Delete from Postprocess Operation:

Configure the Source Transform

1. 1. Select the Source Transform stage in the Route Editing Grid. The configuration panel will appear at the bottom.
   2. Select the Add Format button. In the dialog that appears, enter the name of the format CSV to XML. Click OK, and the Format will be created, and the configuration panel will appear below.
   3. On the left side of the configuration panel, select the CSV option from the Transformation Module selection box. Optionally, click the … button to open the Module Search Dialog, which provides a faster way to find the module you’re looking for.
   4. The configuration panel that appears provides the options for configuring the CSV Transformer. For this exercise, the default settings will suffice.

Configure the Transport

1. 1. Select the Transport stage in the Route Editing Grid. The configuration panel will appear at the bottom.
   2. Select Directory/File from the Transport Type selection box. Optionally, click the … button to open the Module Search Dialog, which provides a faster way to find the module you’re looking for.
   3. Select the Target Directory, using the … button to open the file selector.
   4. Set csv-xml-output as the Target File Name.
   5. Set xml as the Target File Extension.

Document the Target System

1. 1. Select the Target System stage in the Route Editing Grid. The configuration panel will appear at the bottom.
   2. Change the System Name to XML File.
   3. Select the Choose Target Icon button, and scroll down to select one of the XML icons.

Prepare to Test the Route

1. 1. In the menu bar at the top, select Mode -> Testing Mode. Make sure the changes to the Route are saved.
   2. Copy the file called example.csv from the Samples directory provided into the directory chosen as the polling directory.

Test the Route

1. 1. At the top of the Testing Mode screen, select the Execute Test button.
   2. If the Route was configured successfully, all the Stages should light up with green checkmarks.
   3. Select the Transport stage. The configuration panel will appear at the bottom.
   4. Select the View Stage Output button at the bottom. The Results Viewer will appear, displaying the outcome of the test.
   5. In the Results Viewer you should find the CSV content, now in XML form.

Output Files

1. 1. Compare the results from the exercise with the following example output files to see if they are correct.
      1. csv-xml-output.xml