File adapter: Receiver File Content Conversion problem.. XML to CSV..!!

[Former Member]

Hi,

I am facing some problem in FCC for Receiver adapter. It has to convert from XML to CSV File.

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

- <ns0:PaymentFull_Target xmlns:ns0="http://sdn.com/Payment">

- <RECORDSET>

- <Header>

<LineItem>1</LineItem>

<SaleNumber>102</SaleNumber>

<TransNumber>105</TransNumber>

<Store>1326</Store>

<variant>Z6</variant>

<TransType>NEW</TransType>

<Adjustm_Type />

</Header>

- <Header>

<LineItem>2</LineItem>

<SaleNumber>102</SaleNumber>

<TransNumber>105</TransNumber>

<Store>1326</Store>

<variant>Z6</variant>

<TransType>NEW</TransType>

<Adjustm_Type />

</Header>

- <Header>

<LineItem>3</LineItem>

<SaleNumber>102</SaleNumber>

<TransNumber>105</TransNumber>

<Store>1326</Store>

<variant>Z6</variant>

<TransType>NEW</TransType>

<Adjustm_Type />

</Header>

</RECORDSET>

</ns0:PaymentFull_Target>

Output File is coming only with lineitem values , remaining fields are not coming.

*1,2,3*

FCC Used...

RecordSet Structure -- Header

Header.fieldNames -

---

LineItem,SaleNumber,TransNumber,Store,variant,TransType,Adjustm_Type

Header.fieldSeparator----- ,

Header.endSeparator----- 'nl'

Did I miss anything.. any idea whats going wrong?

Thanks

Deepthi

[Former Member]

Thank you for the responses.

I tried all the options but in vain.

Finally I removed the node "Recordset" and kept only with "Header" and it worked.

Looks like hierarchy problem while converting from XML to CSV.

[former_member581827]

Hi Deepthi,

Have you tried specifying Header.fieldFixedLengths and Header.fixedLengthTooShortHandling parameters.

Please try by keeping these 2 parameters and test.

Regards,

Chandra.

[Former Member]

Hi Deepthi,

Mention the occurrence of header in Recordset

You specify like this:

Recordset: Header, *

Header.fieldSeparator : u2018Field Separatoru2019

-->For FCC on Receiver side you donu2019t have to mention the field names.

-->The u2018endSeparatoru2019 parameter needs to given for substructure only

Check this links:

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

Rgds,

Akhila

[Former Member]

Hi Deepthi,

Define Recordset Name to Recordset in FCC, all other configuration looks fine.

[Former Member]

Hi,

use

Header.addHeaderLine = 0

instead of Header.fieldNames

Regards,

Manisha

[Former Member]

Hi...

You just specify,

Header.fieldSeparator -- ,

Remove Header.fieldNames and try.

Regards,

Leela.