"Import CSV to database v3" plugin not working correctly

Question

My requirement is to import a csv document to database. The csv file has header field names with underscore (Eg. "first_name", "last_name"), but the database table column names don't have underscore in it. Thats why the data is not getting written to database successfully. Is there a way out here?

Aditya · Answer

If you are using Import CSV to database plugin component, your csv field names and database table column names must be same. In case they are not same, you can use the plugin CSV to CDT Parser to first parse your CSV into a CDT and then use that CDT to write data to the database. If your CDT field names and table column names are different, you can map them in your CDT's xsd in the following way: @Column(length=255, name="first_name") The highlighted part indicates the table column name and your column name can be different from your which is your CDT field name.

kumara0002 · Answer

Download latest version of Excel Tools -Plugin and use the smart service import csv to database with no headers option ticked. Use all the column headers as per the database and make sure the number of columns in CSV and database are same.Sequence does not matter.