Output Flatfile Conversion

[Former Member]

Hi All,

I am doing Flatfile to Flatfile scenario.My input format is like ID,Name,Address.I want to get the output which should be same like Input format but through mapping.I am using J2SE file Adapter in both sending and receiving side.I am getting output in Flatfile but with only one field that is "ID".I am not getting the remaining fields i.e., Name and Address in my output flatfile.

My input structure from SXMB_MONI is

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

- <ns:MT_FCC1 xmlns:ns="namespace">

- <Recordset>

- <Data>

<ID>100</ID>

<Name>X</Name>

<Address>Y</Address>

</Data>

</Recordset>

</ns:MT_FCC1>

Content Conversion Parameters which i have specified at receiver side is

xml.recordsetStructure=Recordset,Data

xml.addHeaderLine=0

xml.fieldSeparator=,

xml.endSeparator='nl'

Can anyone suggest me what to do ASAP?

Thanks in Advance

Dinakar

[Former Member]

Hi Dinakar,

Use

DATA.recordsetStructure=Recordset,Data

DATA.addHeaderLine=0

DATA.fieldSeparator=,

DATA.endSeparator='nl'

INSTEAD OF

xml.recordsetStructure=Recordset,Data

xml.addHeaderLine=0

xml.fieldSeparator=,

xml.endSeparator='nl' and try u will get it in target side.

Regards

Naveen

[former_member529475]

HI

If it is xml file to xml file then no need to go for the FCC

[Former Member]

Hi Vasudeva,

I am doing Flatfile to Flatfile Scenario with mapping and conversions.The xml code which i have meant is from SXMB_MONI .Since mapping is involved XML file is being shown in Moni.

[Former Member]

Hi Dinakar,

Make the following content conversion settings :

RecordsetStructure : Recordset,Data

Content Conversion :

Recordset.fieldSeparator = 'nl'

Data.fieldSeparator = ,

Data.endSeparator = 'nl'

Thanks and regards,

Pravesh.

[former_member529475]

HI Dinakar

In your Content Coinversion Parameters, you forget to add the fields

you have to enter the following data

xml.recordsetStructure = Recordset, Data

<b>xml.fieldNames ** give all ur fieldsnames seperated by comma</b>

xml.addHeaderLine=0

xml.fieldSeperator=,

xml.endSeperator = "\nl"

Cheers..

Vasu

<i>

• REward Points if found useful **</i>

[former_member184619]

Hi Dinakar,

U should use it like this

Recordset Structure :- Recordser,DATA

DATA.addHeaderLine=0

DATA.fieldSeparator=,

DATA.endSeparator='nl'

insted of

xml.addHeaderLine=0

xml.fieldSeparator=,

xml.endSeparator='nl'

chk this link

Sachin

Message was edited by:

Sachin Dhingra