Skip to Content
0
Former Member
Mar 16, 2010 at 05:19 PM

File Content Conversion -- Receiver File Adpter

26 Views

Hi,

In the Receiver file adapter, we need to convert the

following XML file to CSV file.

Recordset

-|File (1)

-|Item (1 to unbounded)

-|BottomData(1)

and in the CSV file we just need Item and BottomData information

not the File content. We are putting File content

into file adapter to make the varibale substitution

in the file naming and It should not go into the

file content.

I configured the receiver file adapter as

Recordset Structure 			:File,Item,BottomData
File.addHeaderLine			0
File.noOfColumns			0
File.fieldFixedLengths			0
File.fixedlengthTooShortHandling	'Cut'
Item.addHeaderLine			0
Item.fieldFixedLengths	8,6,4,3,20,14,6,30,1,2,18,6,4,12,4,4,1,6,6,8,7,4,6,10,20,1,10
BottomData.addHeaderLine		0
BottomData.fieldFixedLengths		8,6,4,3,40,2,3,2,3,1,19,15,27,7,27

But it is not working. File is still coming.

Is there any way to delete one line in the receiver

file adapter.

Any input is appreciated.

Regards,

Srinivas