Managed File Transfer User Guide

10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Example 1: Read XML File

Follow the steps below to read a XML file and load the data into a RowSet. The following page shot represents the input file:

From within the Project Designer page, expand the Data Translation folder in the Component Library, and then drag the Read XML task to the Project Outline.

On the Basic tab of the Read XML task, specify values for the File attribute:

File: The file path and file name of the XML file to read.

When complete, click the

Add

button and select

RowSet

On the Basic tab of the RowSet element, specify a value for the Variable Name attribute:

Variable Name: The name of a variable which will contain the parsed data. The variable will be of type RowSet and may be used in subsequent tasks that accept a RowSet input variable.

When complete, click the

Add

button and select to add a Column.

On the Basic tab of the Column element, specify values for the following attributes:

Index: The index of the column in the input file(s). The first column starts with index 1.
Value: The path to the element or attribute from which this column should draw data. To retrieve data from an element, the element path should be defined like "/Element1/Element2/Element3". To retrieve data from an attribute, the attribute should be defined like "Element1/Element2/@Attribute".

When complete, click the

Add

button and select to add another Column

On the Basic tab of the Column element, specify values for the following attributes:

Index: The index of the column in the input file(s). The next column is index 2.
Value: The path to the element or attribute from which this column should draw data. To retrieve data from an element, the element path should be defined like "/Element1/Element2/Element3". To retrieve data from an attribute, the attribute should be defined like "Element1/Element2/@Attribute".

Click the

Add

button in the sub-menu and select the Add Same. Repeat steps 6-9 for each attribute or element you wish to retrieve.

Click the

Save

button when finished.

The following image illustrates the Project Outline for the Read XML task, and contains columns for each element and attribute read from the XML file:

The following table illustrates the data contained in the RowSet variable created from the XML Read task:

${myData} RowSet Variable
${myData[1]}	${myData[2]}	${myData[3]}	${myData[4]}	${myData[5]}	${myData[6]}
34594	Heather	Banks	1998-01-19	BB001	72000
34593	Tina	Young	2010-04-01	BB001	65000

Rename Saved Search

Table of Contents

Managed File Transfer User Guide

Managed File Transfer User Guide

Example 1: Read XML File

Example 1: Read XML File