Hi Team, I have created a custom module and when i try to import my records from CSV ( I have the duplicate records). During the Import process is there a way to find the duplicates. I have a required field and i would need to check for duplicate records in CSV. But the duplicate check present in SuiteCRM does not work. Does any one have a solution or fix to this ?
Hi,
The required field will ensure that the field always has the value, but it will not check the uniqueness of the field.
You can try to add a unique index on the field in the database.
If you have any queries, please let me know. Thank you!
Your explanation is too vague to be able to assist you.
Please explain in detail:
- what you are trying to achieve
- what have you done
- what was the expected outcome
- what was the actual outcome
Please also mention:
- SuiteCRM version
- PHP version
- operating system of the server hosting SuiteCRM
Hi, I am trying to import a CSV file to a custom module that i created. During the import process duplicate check feature is not working out and i am unable to check for any duplicates. ( On the Step 4 ) -->In Check for Possible Duplicates window my fields are not getting populated in (FIELDS TO CHECK and AVAILABLE FIELDS). Is there a way to populate the fields? [ I would like to populate the predefined field - Name and perform a duplicate check ]
Is there a way to do the above and check for duplicates during imports ?
SuiteCRM Version :
Version 7.10.20
Sugar Version 6.5.25 (Build 344)
PHP Version : 7.1.32
Operating System : Windows 10 Enterprise Edition.