Advanced Flat File Parser

This is an enhanced action of Flat File parser which provides a flexible parser to convert any flat file with any delimiter and end of line character to an XML document. The output is in standard SAP Manufacturing Integration and Intelligence (SAP MII) XML format. The column names and data are encoded in XML format to accommodate the XML document standard output.

Features

You have to specify the end of line character and the delimiter. Optionally, you can configure the columns with minimum and maximum values. You can also add, delete and rearrange the columns.

Following are the field names along with their descriptions:

Field Names	Description
Column Definition
Columns	Choose Define Columns to configure column properties. You can enter name, description, minimum and maximum values, and choose data types. Alternatively, you can dynamically link values to the properties using Link Editor.
Has Columns	If the check box is selected, the action uses the first row or input data to define the XML document column names. If deselected, the column names will be automatically generated as Column 1...Column N. All column names are of type String. Note If the columns and their data types are defined in Columns, then Has Columns field is deselected and disabled. End of the note.
Auto Expand	If the check box is selected, the rows with extra data values will be added to the column. If deselected, the extra columns are truncated.
End of Line character	Specifies a new line character and delimiter between the lines. If blank, a line feed or a carriage return is considered as end of line.
Delimiter	Splits the various data values from each flat file row and load the values to a XML document. If blank, comma will be the default delimiter.
Input Text	Data for conversion to an XML format
Output Details
Success	Set this boolean indicator to True to check if the parse is successful
LastErrorMessage	Contains error message received during execution
OutputXML	Contains contents of the flat file parser parsed into MII XML document format
Truncated Data	Displays the rows with extra data values if Auto Expand check box is deselected.

Activities

To configure the columns and the delimiters, right click on the action block and choose Configure.

You can define the columns with the maximum and minimum values using the Define Columns of Column Definition screen.