XI Mapping problem?

[Former Member]

Hi

Can some one help me on this issue

My source file out put is like this :

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<soap:Body>

<DownloadDataByUserResponse xmlns="http://ultraasp.net/">

<DownloadDataByUserResult>

<results xmlns="">

<data>

<Report.Agent.Status.Summary rows="268">

<row DateTime="01/04/2010" UserId="104" UserName="test" StateDescription="connected" Duration="22"/>

</Report.Agent.Status.Summary>

</data>

</results>

</DownloadDataByUserResult>

</DownloadDataByUserResponse>

</soap:Body>

</soap:Envelope>

Target file out put should be like this:

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

<ns0:Ultra_BW_Response xmlns:ns0="urn:com.vangent.ultra.agentactivity">

<DateTime>01/04/2010</DateTime>

<UserId>104</UserId>

<UserName>test</UserName>

<StateDescription>allocated</StateDescription>

<Duration>22</Duration>

</ns0:Ultra_BW_Response>

How can i do mapping?

I am gussing XSLT mapping , If yes can some one tell me how to do ( Steps )

Thanks

Babu

[Former Member]

Babu,

Each row in the above source file has a list of columns/fields. you should be able to map 1..1 in this case. you will certainly not be needing XSLT.

Regards,

Pavan

[justin_santhanam]

Babu,

What's the issue with the structure? Isn't it a direct mapping?

<row DateTime="01/04/2010" UserId="104" UserName="test" StateDescription="connected" Duration="22"/>

DateTime, UserId, UserName, StateDescription, Duration - all these will be the attributes of row. Hence it's going to be a direct mapping from each attribute to the target field. It's direct mapping.

raj.

[Former Member]

How can i map

All i can see in my source message type is DownloadDataByUserResult node

How can i map to target filed?

[Former Member]

Hi Babu

It seems the Schema you have imported to external definition is not correct. Basically we can see the Attrbiute nodes in the Message type and directly map the attribute to target.

Do check with your imported schema or WSDL.

Thanks

RamG

Edited by: Ramkumar Ganesh on Apr 21, 2010 3:48 PM

[Former Member]

hi,

you can go with graphical mapping only and use UDF to extract the value from field <row DateTime>.

Store them into global variables and map those to target fields.

Thanks

Jai