Hi All,
I want to add Record ID field for duplicate check while importing a list of records.
Thanks & Regards,
Sundar
Hi All,
I want to add Record ID field for duplicate check while importing a list of records.
Thanks & Regards,
Sundar
a duplicate check for record id? The record id is used to define if teh record should be updated or not. What is your use case?
Hi Jeroen,
I want ID field should be visible in the available fields list while importing any data (If I have ID field column in importing data file)
Thanks & Regards,
Sundar
You don't want to update data if the ID is already specified. Is that what you want?
yes. correct
This is already default functionality. If you have the import screen there are two radiobuttons. If you check the first it will only do an import and doesn't update data if the ID is already found.
We are talking about the sugar id are we not?
I think of it like: If you provide the ID (in your .csv) it will update, else create.
no, only if you specify that it should update otherwise it will only create
Sorry yes... that is more concise I agree. Well corrected Jeroen.
Sundar I am just now updating via .csv into our Serial Number custom module.
As Jeroen says I am selecting "create new records AND update existing records"
In this .csv I set the ID field as the Name so we end up with the ID being the same as the name, aka the printers serial number is the ID.
If that ID already matches an existing records ID it will update that record.
If the ID does not match another ID then the record will be created.
Hope that helps.