Configure File System Data Set

To configure a File system Data Set:

1. Run the Integration Framework - Configurator application.

   The Integration Framework - Configurator window opens.

2. In the Configured Data Server pane, click on FILESYSTEM to expand the tree of File System Data Servers.

3. Click on a previously created FILESYSTEM Data Server (as shown in Figure 1411), to select it.

4. In the toolbar, click the Add icon.

   Alternatively, you can right-click on selected Data Server and select the Add option as shown in the following figure.

   The Configure File System DataServer window opens.

5. In the Name box, type a name for the file system data server.

6. In the File Pattern box, type the file pattern used to look for specific files (i.e., file types).

   This should be the same file pattern as that which was configured on the parent IF Data Server.

7. In the File Type box, select the format type Text/Delimited.

   Currently available options are:

• Text/Delimited - Delimited text files like CSV (Comma Separated Values).
• XML - XML formatted text files.
• Other - Compatible with older version of IF FS datasets.

8. Click the Save and Exit icon.

9. Select the newly created dataset to configure the dataset parsing (only 'Text/Delimited' and 'XML' file types).

10. Click the Configure Parser button to open the parser configuration form.

    The file Selection Dialog window opens.

11. Double-click on the file you want to parse and use as a source for the configuration.

    Alternatively, you can select the file from the list and click the OK button.

    The Configure File System window opens.

12. Select the Delimiter (value separator).

13. Check the Has Header box if the first row in the delimited is a column header.

14. Click on the Parse CSV button.

    The file is parsed and the window refreshes, showing the configuration settings options.

15. In the left pane, check the box for each column you want to have in the final dataset.

16. In the right pane, configure the parsing conversion rules for the selected columns.

17. Target Name - the name of the column in the final dataset.

18. Data Type - The values for the type of data columns in the final dataset. Each data type has specific conversion rules.

19. Data Type Conversion Rule - Each data type has its own specific conversion rules.

20. Repeat the steps for each column you selected in the left pane.

21. Click the Target Preview tab, to see the preview of the final dataset generated from the selected file. An example is shown in the following figure.

22. Click the Save and Exit icon.

    You are returned to the Integration Framework - Configurator window.