Import CSV to Database not able to insert data

Hi All ,

I am using Import CSV to Database smartservice to insert data to MySQL database table but data is not inserting I am getting following error


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[Data Store Entity:"7db49057-d16b-495d-9a26-a1156390fb73@451789"]' at line 1

 

C S V Document : I have referred a document in knowledge base (CSV file I have downloaded from the data base table ) 

Data Source Name : Given a constant which contain jdbc connection string

Delimiter: , and ; both these two I have tried

Table Name: I have created a constant which is of type Data store entity and referred the desired entity

 

Please correct me where I am doing wrong.

 

And also let me know this plugin will do update also i.e If I gave the data which is already exist for primary key value , will it update the data ?? or only insert it will do

 

Thank you,

Bhargavi

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data