Import creating duplicate records

[Bobhardyoyo]

I am importing in to an existing Sugar database using the internal import tool and a CSV file, I have selected create and update but the system is not updating the records it is creating new ones instead, I could go through and do a duplicate merge but this is not an ideal scenario.

Can anyone help figure out why sugar will not update the records?

This system is running CE 5.5.1 on a Windows 2003 server.

Thanks
Ed

[Bobhardyoyo]

Has no one else come across this problem with Sugar imports before?

[ivit]

Do you have IDs in CSV?
As I can remember, Sugar import update requires IDs in CSV, in order to do an update. If you don't have IDs in CSV, it creates new records.

[Bobhardyoyo]

Do you have IDs in CSV?
As I can remember, Sugar import update requires IDs in CSV, in order to do an update. If you don't have IDs in CSV, it creates new records.

Thanks for the response!

I don't have ID's but I do have multiple fields in the CSV that are identical to existing records in Sugar...do I have to find the ID for the existing records in Sugar in order to import this properly? I have 250 records to import

[robertbmirth]

yes, you have to have IDs for the update feature to work. As far as sugar is concerned, that is really the only unique field in any record, so it only references that to determine if you're trying to update a record or create a new one.

If you need to pull out the IDs, you can always do an export of these records, or if you know a little SQL/PHP you can probably append these IDs to your records.

[angelababy]

Hi! Thank you for this very helpful informations.

[rishavraj]

How can i check the emai-id should be unique while create and update in import module?

i want like that if Email-id exists then it will not save to the database

Please help me out