Problem in using module AF_Modules/StrictXml2PlainBean in xml to file scena

[Former Member]

Hi Expert ,

I have problem in converting XML to CSV in the following structure.

MT_EAN_MASTER

-E1WBB01

-E1WBB03

-EAN_MASTER

-Item_no

-Item_desc

-ean

I am using AF_Modules/StrictXml2PlainBean in receiver communication channel.

modulekey parametername parametervalue

abc EAN_MASTER.fieldSeparator , (comma)

abc recordTypes EAN_MASTER

I have to use 3 level hierarchy structure because of a requirement where an item can have multiple ean.

CSV is not getting generated as it is giving me an error in RWB as

The element nesting level for the structure EAN_MASTER is too deep (reference: 3 levels, found: 4 levels): com.sap.aii.af.modules.conversion.xml2plain.ConversionException: The element nesting level for the structure EAN_MASTER is too deep (reference: 3 levels, found: 4 levels) at XML element MT_EAN_MASTER,E1WBB01,E1WBB03,EAN_MASTER

Please provide some solution to generate a CSV with end seperator as newline.

[Shabarish_Nair]

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

there is a limitation on the XML structure while doing FCC

One Option can be - /people/shabarish.vijayakumar/blog/2010/01/14/file-conversion-using-nodeception

[Former Member]

For this scenario,

First I have used FCC for the same structure and CSV is also generated, but the CSV when opened with NOTEPAD it is not showing endSeparator , i.e my first row last element is concatenated with second row first element,there is no row seperator.

But the same when opened with WordPad,we can see the data, row wise

now the destination system open the file in notepad only.

for that i tried using this Bean specified above but it is not fulfilling the requirement.

The parameters I have mentioned in FCC are as follows:

Recordset Structure : E1WBB01,E1WBB03,EAN_MASTER

NAME VALUE

EAN_MASTER.fieldSeparator , (comma)

EAN_MASTER.endSeparator 'nl'

E1WBB03.fieldSeparator ,

E1WBB03.endSeparator 'nl'

E1WBB01.fieldSeparator ,

E1WBB01.endSeparator 'nl'

Please provide a solution,why thr endSeparator is not shown in notepad.

Thanks