NOTE: This article applies to GoldMine Stardard Edition 6.7 and lower versions of GoldMine. Symptom: GoldMine does not let anyone login. Gives message "waiting for permission to log in" Cause: GoldMine license file has been renamed. Reason: Administrator may have reason for not allowing users to login. If you are...
Author: Bob Ritter
GoldMine Error Message: A referral was returned from the server
Recently, many GoldMine users have been encountering a problem, when they double-click the GoldMine shortcut, they’re presented with the error: “A referral was returned from the server.” After the error, GoldMine does not start. What’s going on is that every GoldMine version has a digital signature and the one used...
Invalid BLOB Handle In Record Buffer
GoldMine generates an ‘Invalid BLOB handle in record buffer’ when you are working in GoldMine. Typically this happens when you’re looking at the History Tab, Pending Tab, or Activities List. This is because these areas of GoldMine have more items being viewed with notes than can be handled by your...
Insufficient Memory for This Operation
Sometimes it may take a few seconds for the GoldMine login screen to show up after first clicking on the GoldMine icon to launch the program. We can get a tad impatient and double-click the GoldMine icon again, and again, and again, thinking it will launch even faster. Well it doesn't...
Importing Contacts into Goldmine via Excel 2000-2003
Introduction There are two stages to follow when importing records into GoldMine from an Excel data source. The first is the preparation of the data in Excel, and the second is the using the import feature of GoldMine. This guide should outline the key steps and help you understand the...
GoldMine SQL Query – Show Duplicate E-mail Addresses
select address2, contsupref from contsupp where contsupref <>'' and rectype='p' and contact='E-mail Address' and contsupref in (select contsupref from contsupp group by contsupref having count(contsupref) >1) order by contsupref
GoldMine SQL Query – Duplicate Records based on Company
Many clients have databases that have duplicate records. The SQL query below will return information based on the company name being duplicated in the database. select company,contact,address1, address2, zip,phone1 from contact1 where company <>'' and company in (select company from contact1 group by company having count(*) >1) order by company
How to Properly Backup Your GoldMine Database.
For GoldMine Standard Edition (dBase) Do not rely on GoldMine's backup utility. The best way to back up GoldMine is to copy the entire goldmine folder (and its contents) to another location. You can do this manually with a copy/paste or you can use any number of backup software programs or...
GoldMine SQL Query- Additional Contacts and Email Address with Email & Mail Merge Code
The following is a SQL Query that will display Additional Contacts with their Mailing Address, Email Address and the associated Email Merge Code and Mail Merge Code. select c1.accountno, c1.key1, ac.contact, ac.city, ac.state, ac.mergecodes, em.contsupref, em.mergecodes, substring(em.mergecodes,1,1) as CHECKED from contact1 c1 join contsupp ac on c1.accountno=ac.accountno join contsupp em...
GoldMine SQL Query to Find Duplicates Between Primary and Additional Contacts
select contact1.company, contact1.contact from contact1, contsupp where contact1.contact = contsupp.contact and contact1.accountno = contsupp.accountno order by contact1.contact