Skip to Content
Menu
This question has been flagged
2 Replies
5694 Zobrazenia

I have 10 customers in my database. First i import a csv file which contains only name & email id. Later i prepare another file which contains name(for the reference), address, phone no, job etc. While  i import the second time, it created as a new record. That is an issue, it duplicate the customer record.

So how can we import datas into the existing records?

Thanks.

Avatar
Zrušiť
Best Answer

Export the customers to a csv file with the columns/fields you need. Make your changes and import the file again. A test data base would be good to check if it works.

The first column contains the ids of the customers. You mustn't change the ids. And don't add new rows to the file. Then the existing customers should be updated only when you import the file again.

Avatar
Zrušiť
Best Answer

Hello,

I see 2 solutions : 

- You create a unique constraint in your postgre database to make the name unique

- You take the id generated while exporting and you put it in id column while import.

Regards,

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
1
máj 19
9352
1
aug 15
3241
1
aug 15
4490
1
mar 15
5656
1
apr 20
2959