Import CSV To Database.

Hi,

What i understand is that you dont want to over ride existing rows when a new CSV is imported at the same time you dont want to have duplicates. See if the following will workout for you,

Lets assume your CSV contains columns as id,name,dob .

Create your DB table (staging table) that has columns as follows
uid(Primary Key),
id,
name,
dob,
batchID,
createdDateTime.

You can populate the Additional columns batchID (autoincrement this value for each file import ),createdDateTime from the smartService . This way you will have visibility to identify imported rows by batchID. Build a stored Proc in Mysql using INSERT () ON DUPLICATE KEY UPDATE() and populate your actual table with data for a specific batch ID.

Hi,

What i understand is that you dont want to over ride existing rows when a new CSV is imported at the same time you dont want to have duplicates. See if the following will workout for you,

Lets assume your CSV contains columns as id,name,dob .

Create your DB table (staging table) that has columns as follows
uid(Primary Key),
id,
name,
dob,
batchID,
createdDateTime.

You can populate the Additional columns batchID (autoincrement this value for each file import ),createdDateTime from the smartService . This way you will have visibility to identify imported rows by batchID. Build a stored Proc in Mysql using INSERT () ON DUPLICATE KEY UPDATE() and populate your actual table with data for a specific batch ID.

Hi,
I already have some records in Database and now i Import my CSV file with some new records to Database,
but it doesn't reflect those records to Database.
My Column name in CSV is also same as CDTs name, still its not working.
Kindly help me out with this.

Are you getting any error messages from the smart service?