tFileInputMSXML Standard properties

File Name

Name of the file and/or the variable to be processed.

For further information about how to define and use a variable in a Job, see Talend Studio User Guide.

Root XPath query

The root of the XML tree, which the query is based on.

Enable XPath in column "Schema XPath loop" but lose the order

Select this check box if you want to define a XPath path in the Schema XPath loop field of the Outputs table while not keeping the order of the data shown in the source XML file.

Outputs

Schema: Define as many schemas as needed.

Schema XPath loop: Enter the node of the XML tree or XPath path which the loop is based on.

XPath Queries: Enter the fields to be extracted from the structured input.

Create empty row: Select this check box if you want to create empty rows for the empty field(s) in the schema.

Die on error

Select this check box to stop the execution of the Job when an error occurs. Clear the check box to skip the row on error and complete the process for error-free rows.

Trim all column

Select this check box to remove leading and trailing whitespaces from defined columns.

Validate date

Select this check box to check the date format strictly against the input schema.

Generation mode

Select the appropriate generation mode according to your memory availability. The available modes are:

• Slow and memory-consuming (Dom4j)

  Information noteNote:

  This option allows you to use dom4j to process the XML files of high complexity.

• Fast with low memory consumption (SAX)

Encoding

Select the encoding type from the list or select CUSTOM and define it manually. This field is compulsory for DB data handling.

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at a Job level as well as at each component level.

Global Variables

NB_LINE: the number of rows processed. This is an After variable and it returns an integer.

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl + Space to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio User Guide.