on 04-21-2010 11:08 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.