File (csv) to JDBC

[Former Member]

I am trying to read in a CSV file with the file adapter. I have used file content conversion, and I am getting the following error. Any help would be greatly appreciated.

Thanks

Skip Ford

<b><b>Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Format error in 'xml.recordset' argument: incomplete structure (name,number) pair</b></b>

[Former Member · Accepted solution]

The file looks like below...

John,1/2/2007,Ford

Ralph,2/4/2005,Chevy

Content Conversion Parameters

__________________________

Document Name : output.txt

Docuemnt Namespace : http://companyname.com/sapxi/edhr/vendordata

Recordset Structure : ROW

Recordset Sequrence : Ascending

Ke Field Type : String (Case-sensitive)

ROW.fieldSeparator : ,

ROW.endSeparator : 'nl'

ROW.processFieldNames : fromConfiguration

ROW.FieldNames : name,date,car

Other Note: I am doing mapping also...

[bhavesh_kantilal · Accepted solution]

Reginald,

<i>Document Name : output.txt</i>

This should actually refer to the name of the source messagetype that you have created in your IR.

<i>Recordset Structure : ROW</i>

This should be,

<b>Recordset Structure : ROW,*</b>

Make these changes and then things should work fine.

Regards

Bhavesh

[Former Member · Accepted solution]

Bhavesh is completely right Reginald...

If you implement what he suggested then your scenario will work...

[Former Member · Accepted solution]

I am not sure if this is progress, but I am getting the following error now...

<b>Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Mandatory parameter 'ROW.fieldNames': no value found</b>

I do appreciate the help...

Skip Ford

[bhavesh_kantilal · Accepted solution]

It is progress

<i>ROW.<b>F</b>ieldNames : name,date,car</i>

the f in the above should be small. i,e. make the change as ,

<i>ROW.<b>f</b>ieldNames : name,date,car</i>

regards

Bhavesh

[Former Member · Accepted solution]

no problem in your content conversion parameters you have a capital letter in Field which should be lower case

[Former Member · Accepted solution]

Bhavesh,

Sorry I keep answering just after you with exactly the same info :-)... I guess I type slower than you...

[bhavesh_kantilal · Accepted solution]

Alex

You answers make sense and that is what matters. No need to be aplogetic about anything

Regards

Bhavesh

[Former Member]

This is a problem with your content conversion parameters... The record set field should have something like AAA,1,BBB,* etc..

You have to tell it how many occurrences of each recordset it should expect

Please could you provide your structure as well as all of the Content Conversion Parameters that you have configured...

Message was edited by:

Alex Ong

Message was edited by:

Alex Ong

[bhavesh_kantilal]

Reginald,

Can you provide us the Source File format and the content conversion parameters used in the Sender File Adapter?

Regards

Bhavesh