XML messages with elemenet names separated by '.'

[Former Member]

Hi Folks,

We have a SOAP(AXIS) to proxy scenario where the 3rd party application has to send XML files to PO 7.31  system.

The problem is, in the XML file the element tags are separated by '.' symbol.

eg.

  <Activity>

    <Message.Id>2672</Message.Id>

    <Activity.Type>SERV</Activity.Type>

    <Data.Groups.Updated>123<DataGroupUpdated>

    <Change.Type>Update</Change.Type>

    <Data.Group>places</Data.Group>

</Activity>

In PI element naming, it is illegal to put '.' character in the element name.

We have 8 interfaces where we could get 8 different types of messages with this type of element names. So, we are looking for a generic solution to all the interfaces rather than 8 different mappings for each interface.

Using a simple java mapping to remove '.' character from elements also removing the '.' from XML header and namespace tags.

We are also trying  to use DOM parser, but as the XML file is of complex hierarchy, it would make the program complex and also, we would have to write 8 separate Java mappings for 8 different interfaces if we use element by tag name as constant.

Please suggest if there is any better solution to achieve the solution.

[Former Member · Accepted solution]

Hi Ashish

Create the data type in PI , then export it as XSD and save it to your local m/c. Then change the XSD and put . do in the element name.

Then import this modified XSD as external definition and create the service interface.

If you have plenty of time, then you can think of writing an generic adapter module which will remove the dot name from element name.

[markangelo_dihiansan]

Hi,

The . in an XML field is not possible using data type editor, but should be possible using external definitions:

Hope this helps,

Mark

[iaki_vila]

Hi Ashish,

In my opinion, if you have several interfaces with this problem and in the future this could happen in more cases i would do a module adapter to delete that point. Finally, you could reuse this module in all the scenarios requeried.

Regards.

[Former Member]

Hello,

>>In PI element naming, it is illegal to put '.' character in the element name.

But, there is a workaround to create structures in PI with this kind of separator.

So, what's ur concern - creating a structure in PI with . separator or finding out a generic mapping program?

Thanks

Amit Srivastava