Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 23, 2011 at 10:59 AM

    /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

    Add comment
    10|10000 characters needed characters exceeded

    • 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