Convert XML

Use this property convert fields collected from the external XML from a String to a different type.

Note: This procedure will occur after the Mapping XSL has been applied.

Example:

<Convert>

<Column>

<ColumnName>Start Date</ColumnName>

<ColumnType>System.DateTime</ColumnType>

</Column>

<Column>…</Column>

</Convert>

ColumnName (Required) – String

The name of the column you want to convert.

ColumnType (Required) – String

The System Type you would like to convert the column to.

Options:

•      System.Boolean

•      System.Byte

•      System.Char

•      System.DateTime

•      System.Decimal

•      System.Double

•      System.Int16

•      System.Int32

•      System.Int64

•      System.SByte

•      System.Single

•      System.String

•      System.TimeSpan

•      System.UInt16

•      System.UInt32

•      System.UInt64

TableName (Optional) – String

The name of the table which contains the column to convert. The TableName comes from the Table node used in the XML. For instance if your xml looks like “<Data><Title>Hello</Title></Data><Data><Title>World</Title></Data>” the name of your table is “Data”.

Back to Top