Skip to main content
sudipd0003
March 6, 2023
Question

Issue in Import CSV to Database plugin

  • March 6, 2023
  • 2 replies
  • 0 views

Hi,

I am using Import CSV to Database plugin to save data from CSV to database table. However the last row of the CSV data is getting stored twice in the database table. Can anyone please let me know how to overcome the issue?

Below is the configuration of the smart service we are using:

Delimiter: ,

File Has Header: true

Column names: <no value>

Csv header names: <no value>

2 replies

jakubf0002
March 7, 2023

without file example it is hard to guess but maybe there is just additional line break that you do not see when you open file in notepad? Instead of avoiding this just query cdt in your process model to get item that is empty/duplicate and then delete it.

abhayd3663
March 7, 2023

Need more information to suggest the exact root cause. Generally speaking it seems the csv file data issue.