We are looking to clean up our Goldmine records and have found that we have several duplicate records, records for people who are no longer clients ect.
Is there a way to cleanly remove them from the database without cause issues?
Check out GoldMine's Merge/Purge Wizard - Found under the Tools menu. Be careful, there's no undo here so be sure you have a backup handy just in case.
---
Chad Smith
michad76@gmail.com
MCP - Microsoft SQL Server
Crystal Reports Certified Professional
GoldMine Certified Professional
Microsoft CRM Certified Professional
Are you using SQL or dBase? If you have it on SQL you can look first at your duplicates like this:
select count(*) as HowMany, Company, SomeSecondField from contact1
group by Company, SomeSecondField having count(*) > 1
order by Company, SomeSecondField
"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.