Merge duplicates

[akba]

Dear All,

Just updated to 6.02 and I don't find "Merge Duplicates" any more.
Is it somewhere?

Thanks!

[akba]

Action that I would like to perform is cleaning hole database from duplicate account entries. There is several account so manually that would be quite a task.

Thanks again.

[gmichael7]

I'm really surprised that there isn't more info on the forum about this. Andropes had an entry on another thread about writing some code to take care of this, but the code wasn't provided. There should be an easy feature to allow for this. I've got a ton of duplicates from an import, and am removing them manually. There's got to be a better way.

[davidboris]

Hello,

I see "Merge" option under "Actions". I hope you are looking for that only.

[PeaceFlower]

Hello,

I use Sugar 6.1.
I know that I can merge duplicates contacts with the button "find duplicates".
But, when a duplicate record is deleted, it is considered a “soft” delete; which means that while the record no longer appears in Sugar, it is retained in the database.

I want to delete in the database. Is there a batch script which can help me? Or, should I change a .php file?

Thank you for your help!

[davidboris]

Hello,

Yes, there is a scheduler job(Prune Database on 1st of Month) to delete the mark deleted records.

[PeaceFlower]

SugarCRM shows me:

Note: In order to run the Sugar schedulers, create a batch file to run using Windows Scheduled Tasks. The batch file should include the following commands:
cd C:\Program Files\VertrigoServ\www\sugarcrm php.exe -f cron.php

I create a sugar.bat file in C:\ and I wrote in the file:
cd C:\Program Files\VertrigoServ\www\sugarcrm php.exe -f cron.php

Then in Windows command line interface, I tried :
cd c:\
cmd /k sugar.bat

But it does not work because the path is not recognized.

I don't understand why.

Thank you

[PeaceFlower]

Hello,

There are no answers.

Prune Database on 1st of Month deletes duplicates datas on the database ,which are first deleted by the users.
Besides, is there a module which can delete duplicates data on the database directly (I mean not deleted by the users )?

Thanks!