on 11-01-2010 3:53 PM
Hi
I've got a simple xml which i have to convert in a fixed length text file. Is it possible to convert it using FCC with following structure:
<root>
<data>
<record>
<name>john</name>
<surname>doe</surname>
<zip>12345</zip>
<city>abcd</city>
</record>
<record>
<name>bart</name>
<surname>simpson</surname>
<zip>131313</zip>
<city>springfield</city>
</record>
</data>
</root>
I did this conversion already with PI 7.0, but i removed the <data> element to get a simpler substructure. Is it also possible without removing this?
I found following entry [], but it didn't works for me. Any suggestions?
Thanks in advance
Michael
stick to removing the data node.
/people/shabarish.vijayakumar/blog/2010/01/14/file-conversion-using-nodeception
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Are you looking for a content conversion at teh Receiver adapter or the sender adapter?
If you have defined teh structure in ur Data type as u have mentioned then don't remove anything because ur source file would be containing the following structure itself.
If you are getting the XML structure at source
<root>
<data>
<record>
<item1>
<item2>
</record>
</data>
</root>
the follow the same structure at the receiver side as well. If u want to delete the data node at teh receiver side then delete at teh source side FCC as well.
Just try and let me know. I will help you out.
Thanks
Veeru
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Michael,
The structure which you followed at the sender side, please follow teh same structure at the receiver side aswell.
If you want to remove the data node at receiver side then remove it from sender side as well..Then you wuill achieve ur desired result.
Yes, you can simplify your structure. Just keep the top two nodes and remove the rest unnecessary nodes.
Rgds
Veeru
Michael,
Just follow this link. It will help you out.
http://www.riyaz.net/blog/xipi-file-content-conversion-for-complex-structures/technology/sap/79/
Rgds
Veeru
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.