Skip to Content
0
Former Member
Jun 26, 2009 at 01:57 AM

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

37 Views

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" ?>

- 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