Content Conversion in Receiver File Adapter

[Former Member]

Hi Guys,

I have a XML structure as shown below

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

- <ns0:MT_REC xmlns:ns0="http://test.com">

- <TAG>

<NAME>XYZ</NAME>

</TAG>

- <RECORD>

<RECORD_DATA>line1</RECORD_DATA>

</RECORD>

- <RECORD>

<RECORD_DATA>line2</RECORD_DATA>

</RECORD>

- <RECORD>

<RECORD_DATA>line3</RECORD_DATA>

</RECORD>

</ns0:MT_REC>

<TAG> and <RECORD> are at the same level

I want to convert this to a flat file containing

line1

line2

line3

but i am getting the output file with below data

XYZ

line1

line2

line3

I Don't want XYZ in the output file

Could anyone tell me how to acheive this?

Thanks

Kumar

[Former Member]

Hi Kumar,

Are you using mapping between a source and target structure? If so, try to disable the element <TAG> if is not required ...maybe it will work

Cheers,

Ricardo.

[Former Member]

hey

if u dont want XYZ on the receiver side then u dont need that in the receiver data type.

create a data type without the <NAME> tag

thanx

aamir

Message was edited by:

Aamir Suhail

[Former Member]

Hi Aamir,

I am using the <NAME> tag in the payload on Receiver to form a file name.That is required for me.

Thanx,

Kumar

[Former Member]

Hi Guys,

Thanks for ur reply.

We did this in a diff way. We eleminated the mapping and used unix script in the file adapter.

Thanx,

Kumar.

[Former Member]

Hi Kumar,

Using unix script to change or create filename is a burden like you have to maintain these scripts till your production system and it's a overhead to transport all these scripts with your scenario.

You can easily disable this node in final output which you don't require and at the same time use this node to create your filename, by using two additional parameters in the FCC:

Name.fieldFixedLengths = 0

Name.fixedLengthTooShortHandling = Cut.

This will remove the node from your final output.

Regards,

Shridhar.

Reward Points if this suggestion is helpful.

Message was edited by:

Shridhar