Issue in Converting data in CSV(Comma separated value)file format to XML format.

[Former Member]

Hi All,

        I want to convert CSV (Comma Separated Value) to XML format.So here In sender channel I am using File adapter with FileContentConvertion.  I got Exception named bellow   "  conversion initilization Failed ,java.lang.Exception Error(s) in XML Convertion Parameter found.Format Error in 'xml.recordset' argument incomplete structure (name ,number) pair. "

Please help me how to resolve this issue.

PFA Screen shots my Scenario.

Input File Content:

2069,Mahesh,80000.00

Input is CSV , So  In  Sender Channel use File Adapter , and I am using File Content Conversion tab and Specify following details regarding input format

I Tested my Message Mapping, it is success.

But I got Exception  " Conversion initialization Failed ,java.lang.Exception Error(s) in XML Conversion Parameter found.Format Error in 'xml.recordset' argument incomplete structure (name ,number) pair"

   Please help me how to resolve , I think I did mistake in File Content Conversion ,Help me is there any modifications.

--

Thanks

Mahesh Mediboyina

[Former Member · Accepted solution]

Hi Mahesh

You need to add the following parameters in the parameter section

Recordset.fieldSepartor ( value will be , (comma)

Recordset.endSepartor  ( value will be 'nl')

If you use key then you need to add the following paramter

Recordset.keyFieldValue

[Former Member · Accepted solution]

Hi ,

         Thank you ,Error is resolved.Sender and receiver channels monitored successful ,it have not give any errors ,Message Id also generated,, But I have not found File in targer directory

What is the reasons behinds this

[gagandeep_batra · Accepted solution]

Hi Mahesh,

did u check in in sxmb_moni, is there any error

also check in receiver CC

Regards

Gagan

[Former Member · Accepted solution]

Hi Gagandeep ,

I have monitored Sender and Receiver Communication channels , but I have found Run success with out errors , messages id also generated ,to these channels ,but I have not found target file in target directory