Duplicate Cleaner is a SuiteCRM add-on that allows you to set up rules to find duplicate data in your SuiteCRM and helps you eliminate duplicates manually or automatically by our cleaner process. It supports multiple numbers of duplicate detection rules that you can configure from the admin.
#3120 - Custom Module Relationships Not Transferring
Hello,
I have a custom module built using the module builder that has a relationship with the builtin lead module. When I run the duplicate cleaner process and check the box to copy over relationships, the custom module's relationships are orphaned rather than merged to the primary record.
Example: Every record from my custom module has an associated lead. Leads have a one to many relationship to these custom records. As in, a lead can have multiple custom records, a record only belongs to a single lead. After the dedupe process runs there are custom module records that now have no lead associated with them. They originally belonged to the duplicate (now merged and deleted) and the relationship didn't transfer to the primary lead record.
Are custom modules supported in the relationship transfer functionality? If so, how does the module retrieve the relationships it needs to merge? Any particular steps to help troubleshoot this?
Thanks
-
"Like all Urdvha software; it just works and the support is more than excellent!" - pvzijl
Read More Reviews
3 years ago
Hi muradmin,
Yes, the custom modules are supported in relationship transfer functionality. So in your case, 1 Lead can have multiple Custom module records, and while merging the leads, the Custom module records should get transferred to the primary record.
I thank you for drawing our attention to this, there was a minor glitch in the addon, which has now been solved. I would insist you to download the latest package(DuplicateCleaner-1.2) from the store and check.
Thanks & Regards, Team Urdhva Tech.
3 years ago
Thanks for the quick response.
I will install the 1.2 update and monitor the behaviour.
Cheers.s
3 years ago
Hello muradmin,
Have you gone through the latest changes of DuplicateCleaner? I am closing the case, Do feel free to ask if you have any questions.
Thanks & Regards, Team Urdhva Tech.
3 years ago
Hi,
There seems to still be an issue.
I'm seeing multiple entries in the relationship table, but they are all marked as deleted. This is leaving the custom module record with no active lead linked to it.
Above is a picture of the relationship table between my custom module and leads after the dedupe process ran and merged records. As you can see all the records are marked deleted. The field that is highlighted is the final lead that is currently active, the other two refer to the lead that was deleted during the dedupe process. So the record gets created, but I'm not sure why it's getting marked as deleted.
I also have seen the inverse of this happening, where the relationship table has the deleted lead as active and the real adctive lead as deleted in the relationship table. This, too, leaves the custom module record orphaned without a valid lead relationship.
Hoping you can help me figure this out.
Cheers
3 years ago
Hi,
Did you check this with the new version 1.2? I am a bit confused, Can you come on skype so we can address it properly? My skype id is: urdhvatech
3 years ago
Hi,
I did use the 1.2 version. However, I may have found my issue. It looks like when I installed the update, it duplicated the scheduled cron job. It was running twice, at almost the same time. I'm guessing this would cause some race conditions and throw things off course.
I'll fix my broken records, remove the duplicate scheduler and see if my issues persists.
Thanks