Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Removing Bad Records from Goldmine 5.5

Status
Not open for further replies.

gypsi96

Programmer
Sep 13, 2002
22
US
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?

Thankx
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top