Skip to Content
author's profile photo Former Member
Former Member

XML messages with elemenet names separated by '.'

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 14, 2014 at 09:18 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 14, 2014 at 08:58 AM

    Hi,

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

    Hope this helps,

    Mark


    test.jpg (68.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 14, 2014 at 08:05 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 14, 2014 at 08:15 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.