Hello,
I import contacts that I have to update monthly, so after I use create and update contacts in the import wizard.
But it does not update my contacts, it has created others.
What should I do?
Thank you for your help.
Hi,
What updates you are getting when you updated contacts?
Do you want to import new contacts using a PHP script or import wizard?
Can you please share a screenshot?
Hi,
thank you for yuor answer.
I import my contacts via the import wizard. A csv file
1 Like
Contacts update based on Record Id. If Record Id exists in the CSV file then it’ll update records based on id while importing contacts. If the Record Id does not exist in the CSV file then every time it’ll create a new record while importing contacts.
Hello,
thank you for your answer
it is a file that I have to import every month with contacts that are updated.
The problem is that this file does not have the default suitecrm identifier.
Have you ever encountered a similar case for contact updates?
Thank you for your help.
Yes but you must add SuiteCRM Identifier for updating the contacts using CSV file. Without an identifier, it is not possible to update the Contacts in SuiteCRM.
Hi @jessica1 ,
I added the ID and it works.
But sometimes when I do “create and update” it puts me “duplicates found” and in errors “you can’t update this record Field name: ID”
thank you for your help.
Without SuiteCRM Identifier, it’s not possible to Update the Existing Records. If you import a CSV file without SuiteCRM Identifier then it’ll create a new record every time.
yes for that it is good I put the identifier well.
But now I have this error even if I put the login.
Which error are you getting while login?
I don’t have any errors when connecting. It is only during the import. I import my file and at the end it gives me errors and duplicates.
The error message: “You cannot update this record. Field name: ID”
While I have filled in the ID and I chose create and update.
ID must be the same as record Contact Id which exists in the module which you want to update otherwise it displays errors and not import records.
In our case it’s working properly if both ID is same as shown in below:
“Title” is empty and “Department” is “Development” in the module record as shown in the below screenshot.
Our updated Excel Sheet of contacts as shown in the below screenshot.
After importing updated Excel Sheet contact record(Title and Department) updated as shown in the below screenshot.
