File Content Conversion -- Receiver File Adpter

[Former Member]

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

[Former Member · Accepted solution]

Hi Srinivas,

There are other ways also to get the filename. See this link for this:

http://wiki.sdn.sap.com/wiki/display/XI/CombiningthreedifferentaspectsofPIinoneshot

Regards,

---Satish

[Former Member · Accepted solution]

Satish,

My Source structure and target structire are same, Filename is the mandatory field,so i could not avoid it in mapping.

is there any way in FCC to avoid filename in the target file.

Regards

Srinivas

[Former Member · Accepted solution]

Hi Srinivas,

Please check then sravyas blog for the same approach:

/people/sravya.talanki2/blog/2005/08/11/solution-to-the-problem-encountered-using-variable-substitution-with-xi-sp12

Regards,

---Satish

[Former Member · Accepted solution]

Satish,

I Had done exactly the same way,but still it is showing the error

Thanks

Srinivas

[Former Member · Accepted solution]

Hi Srinivas,

What is the error you are getting in receiver file adapter comm.channel?

Also you said you are getting file in your question, with what config the file is getting and how the file look like. Can you put here so that somebody will help you out.

Regards,

---Satish

[Former Member]

Solved