Skip to Content
0
Former Member
Jul 20, 2011 at 07:32 AM

Issue in String List To XML Parser action block in MII 12.2

150 Views

Hi Experts,

I am facing the following problem in MII 12.2

When I am using the action block "String List To XML Parser" in any transaction,the given input string cannot be parsed properly and an error occurs.An example is given below to illustrate the problem:

The given input string is : PPPI_PHASE_STATUS|PPPI_PROCESS_ORDER|PPPI_EVENT_DATE|PPPI_PHASE|PPPI_EVENT_TIME

Now,instead of parsing the whole string as PPPI_PHASE_STATUS or PPPI_PROCESS_ORDER ,it is getting parsed as individual letters as shown in the following xml.Here,we are using '|' instead of default ',' as taken by Delimiter and it is running fine with ',' but not working with '|'.

<?xml version="1.0" encoding="UTF-8"?>

<Rowsets DateCreated="2011-07-20T06:29:01" EndDate="2011-07-20T06:29:01" StartDate="2011-07-20T06:29:01" Version="12.2.2 Build(224)">

<Rowset>

<Columns>

<Column Description="Item" MaxRange="0" MinRange="0" Name="Item" SQLDataType="1" SourceColumn="Item"/>

</Columns>

<Row>

<Item></Item>

</Row>

<Row>

<Item>P</Item>

</Row>

<Row>

<Item>P</Item>

</Row>

<Row>

<Item>P</Item>

</Row>

<Row>

<Item>I</Item>

</Row>

<Row>

<Item>_</Item>

</Row>

<Row>

<Item>P</Item>

</Row>

<Row>

<Item>H</Item>

</Row>

<Row>

<Item>A</Item>

</Row>

<Row>

<Item>S</Item>

</Row>

<Row>

<Item>E</Item>

</Row>

<Row>

<Item>_</Item>

</Row>

<Row>

<Item>S</Item>

</Row>

<Row>

<Item>T</Item>

</Row>

<Row>

<Item>A</Item>

</Row>

<Row>

<Item>T</Item>

</Row>

<Row>

<Item>U</Item>

</Row>

<Row>

<Item>S</Item>

</Row>

<Row>

<Item>|</Item>

</Row>

<Row>

<Item>P</Item>

</Row>

<Row>

<Item>P</Item>

</Row>

<Row>

<Item>P</Item>

</Row>

<Row>

<Item>I</Item>

</Row>

<Row>

<Item>_</Item>

</Row>

......................

......................

......................

<Row>

<Item>_</Item>

</Row>

<Row>

<Item>T</Item>

</Row>

<Row>

<Item>I</Item>

</Row>

<Row>

<Item>M</Item>

</Row>

<Row>

<Item>E</Item>

</Row>

</Rowset>

</Rowsets>

Can you please suggest a solution?

The MII version is 12.2 SP02 Patch 3.

Edited by: ShawnaG on Jul 20, 2011 1:13 PM