MultiFlatXmlStringReader Properties

The MultiFlatXmlStringReader component handles messages quickly, provides the flexibility to set defaults based on message content, and splits data into multiple tables in Event Stream Processor.

This reader uses a simple XML format, where the name of the table is the tag and the fields are the attributes.

If MultiFlatXmlStringReader is selected as the parsing method, sources can populate multiple tables (defined streams). Specify an internal table or tables that Event Stream Processor updates based on data from the source. Also define the fields within each source record by specifying the name and datatype for each field.

Source records for MultiFlatXmlStringReader have this format:

<TableName field1=’field1 data’ field2=’field2 data’ … />

Property	Description
`AcceptAmpersand`	(Default required) Enter a true or false value to indicate whether the adapter accepts non-XML uses of the ampersand (&). True indicates that the adapter accepts non-XML uses of the ampersand. For example, the adapter converts "&" , "<" , and so on, but it also accepts values such as "Marks & Spencer". False indicates that the adapter rejects non-XML uses of the ampersand.
`Type++`	(Required) Type the name of the base stream or streams that Event Stream Processor updates based on the data in the source. Repeat this process for each stream you are updating. Ensure each system table has its own `Typen` property.
`Typen.AttName++`	(Required) Type the name of the table field that Event Stream Processor updates based on the data in the source. This field is case-sensitive. `Typen` is the name of the related table. Note: Specify a name for each record field in the source data.
`Typen.AttType++`	(Default required) The system defaults the datatype for the field. `Typen` is the name of the related table. Event Stream Processor supports these datatypes: `string` – for strings `datetime` – for dates `float`– for floating-point numbers `short` – for 16-bit signed integers `integer` – for 32-bit signed integers `long` – for 64-bit signed integers Note: Specify a datatype for each record field in the source data.
`Typen.Format++`	(Dependent optional) If you created a field with a datetime datatype, enter the format that the adapter understands when reading data for that field. The adapter rejects any data that is not in this format. `Typen` is the name of the related table. If you do not specify a value, the adapter understands only datetime values with the format `yyyyMMdd` or `yyyyMMdd HH:mm:ss` for the field. It rejects any other datetime data.
`Typen.Match`	(Required) Enter the regular expression to match records for this table. `Typen` is the name of the related table. Provide a regular expression for each table. For example: .table_is_x.
`Typen.UTCTimeZone++`	(Dependent optional) If you created a field with a datetime datatype, you can enter the time zone for the field. `Typen` is the name of the related table. The adapter converts and normalizes the corresponding datetime value from its originating time zone value to an equivalent UTC value. The UTC value is then passed to Event Stream Processor for storage. You can enter any time zone that Java recognizes (for example, Europe/London or America/New_York). If there is no specified value, the datetime value passes through as local time to Event Stream Processor for storage.