cancel
Showing results for 
Search instead for 
Did you mean: 

XML TO XML SCENERIO

Former Member
0 Kudos

Hi ,

i am using XML to XML scenerio.Its working fine.I am using file adapter at both sender and receiver CC.

But issue is that my sender XML have multiple record but on receiver side i am getting very first record(only one) from XML.

Is it need to use File content convirson or anything else i missed.Please suggest.

details are given belw:

sender XML

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

<ns0:MT_XML_SENDER xmlns:ns0="urn:xml2xml">

<PERSONS>

<PERSON>

<Name>mohit</Name>

<Surname>verma </Surname>

<Birthdate>24022010</Birthdate>

</PERSON>

<PERSON>

<Name>amit</Name>

<Surname>giri </Surname>

<Birthdate>24032011</Birthdate>

</PERSON>

</PERSONS>

</ns0:MT_XML_SENDER>

receiver xml

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

<ns0:MT_XML_RECEIVER xmlns:ns0="urn:xml2xml">

<PERSONS>

<PERSON>

<Name>mohitverma </Name>

<Surname>verma </Surname>

<Birthdate>24022010</Birthdate>

</PERSON>

</PERSONS>

</ns0:MT_XML_RECEIVER>

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi.

When you are going to Join Source "PERSON" with Target "Person" make sure that in your occurance of target you have 1..unbounded.

This is in your Data Type or External definition Target structure, the occurance should be 1..unbounded.

Regards,

Lpbuff

Edited by: lpbuff on Jun 28, 2010 4:05 PM

Former Member
0 Kudos

yes ,its occurance is 1..unbounded

Former Member
0 Kudos

when you go to the PI monitoring. Did you see that Target comes just only with one node?....because if this happen all is about the mapping...if the target is ok in the PI monitoring the problem could be on the channel.

Regards,

lpbuff

Former Member
0 Kudos

Is it solved??

Regards,

lpbuff

Answers (4)

Answers (4)

Former Member
0 Kudos

As per my understanding you would like to send multiple records from the sender to receiver. And you are using file adapters in sender and at receiver.

The simple resolution for this issue is:

1. keep the occurance of "person" node to 1..unbounded and map to the target "person" node.

2. Now, try to send multiple records from the sender side. This will help you.

Before, doing this in the runtime, you can test your mapping in "Test" tab in the message mapping to ensure your mappingis correct.

Former Member
0 Kudos

Hi,

You have check what you are getting as output in mapping if your mapping is successful.

Open your message mapping,go to SECOND TAB 'test' & execute it after putting input values.

Check the output,what u r getting

Regards

Nidhi

Former Member
0 Kudos

Did you map Source PERSON to Target PERSON?

Can you check the context also?

If still it is not coming then you can add SplitbyValue function in mapping by that you should get it.

Thanks,

Hetal

Former Member
0 Kudos

Hi Mohit,

As others mentioned you dont need to have any conversion parameters for xml to xml. But first test in message mapping, if you get there then you will get in your output also.

Regards,

---Satish

Former Member
0 Kudos

Hi Satish,

I am not getting u.What u want to tell.Please explane once again.

Former Member
0 Kudos

This may error occur due to erroneous XML formatting.

1. Go to Message Mapping .

1.1 Go to the Test tab

1.2 and test the message mapping with the incoming payload file.

2. Match the source structure with the input file that you are sending to XI. Both structures should be exactly same. I mean all nodes and the node structures.

now after providing proper input ->

Press (Start the transformation Button). ->

check the result , is it desired result or not.

Note you can also directly input your payload into test tab (SRC Button : Source Text View).

Hope this will help you in debugging your message mapping.

Regards

Dragon.

Former Member
0 Kudos

This may error occur due to erroneous XML formatting.

1. Go to Message Mapping .

1.1 Go to the Test tab

1.2 and test the message mapping with the incoming payload file.

2. Match the source structure with the input file that you are sending to XI. Both structures should be exactly same. I mean all nodes and the node structures.

now after providing proper input ->

Press (Start the transformation Button). ->

check the result , is it desired result or not.

Note you can also directly input your payload into test tab (SRC Button : Source Text View).

Hope this will help you in debugging your message mapping.

Regards

Dragon.

Former Member
0 Kudos

Hi Mohit,

Please Map the Source - Person node to the Target - Person node and that should resolve the problem.

Person->Person

This will take care of number of repetitions automatically for you.

regards,