PI 7.11 - FCC Receiver Adapter

[michael_buchli]

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

[Shabarish_Nair · Accepted solution]

stick to removing the data node.

/people/shabarish.vijayakumar/blog/2010/01/14/file-conversion-using-nodeception

[Former Member]

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

[michael_buchli]

Hi Veeru

I need the FCC only on the receiver CC side. I have the datatype designed by myself following our default structure. Any suggestions beside reducing the structure deep by removing the <data> node?

Cheers

Michael

[Former Member]

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_buchli]

Hi again

That ist just what i did.

Thanks for your support.

Michael

[Former Member]

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