Log out?

Exercise 1.3 – Using a Format

Purpose:

To practice building a Route using a Format to transform the data.



Steps:

  1. Create a Route
    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.


  2. Document Source System
    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


  3. Configure the Listener
    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 chooser. The polling directory should NOT be the directory with all the sample files, since files will be moved/deleted by the listening process.


  4. Configure the Source Transformation
    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 bellow.
    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.


  5. Configure the Transport
    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 chooser.
    4. Set “csv-xml-output” as the “Target File Name”.
    5. Set “xml” as the “Target File Extension”.


  6. Document the Target System
    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


  7. Prepare to Test
    1. In the menu bar at the top, select “Route” -> “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.


  8. Perform the Test
    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” should be the CSV content, now in XML form.


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


This is a unique website which will require a more modern browser to work! Please upgrade today!

Thanks!

Our editors are notified.

Close