What's Fixed in GoldMine Premium Edition 9.2.1 HOTFIX 7 (9.2.1.175) Note: GoldMine Premium Edition 9.2.1 Hotfix 7 includes fixes from all prior 9.2.1 releases, including hotfix 1 through 6. Connection failed. access to the host was denied after applying Windows update KB2813170 on x64 Hosts Contact search center (CSC) window...
Category: Tech Tips
SQL Query – ALL GoldMine Email Addresses (Primary and Additional)
select contact1.company, contsupp.address2, isnull(contsupp.contsupref,'') + isnull(contsupp.address1,'') as Email, contsupp.mergecodes from contact1 left outer join contsupp on contact1.accountno=contsupp.accountno where contsupp.rectype='P' and contsupp.contact='E-Mail Address'
Free Disk Space Analyzer
I recently had a customer call in about not being able to save email attachments. Upon investigating the issue it turns out they had run out of disk space on the hard drive that they were storing email attachments on. The hard drive itself was about 500 gigs and it...
SQL Query – Duplicate Contacts
The following SQL Query will display a list of contacts with the same contact name. You can then browse through the list to see if they are any potential duplicates. Select accountno, contact, company, phone1, city, state From contact1 Where contact in (Select contact from contact1 group by contact having...
SQL Query – Additional GoldMine Contacts E-mail Address and Email Merge Code
The following SQL Query shows all Additional GoldMine Contacts with their Email Address and Email Merge Code: SELECT Company, ac.contact AS 'Additional Contact', COALESCE(em.contsupref, '')+COALESCE(em.address1, '') AS 'Email Address', em.mergecodes FROM contact1 JOIN contsupp ac on contact1.accountno=ac.accountno JOIN contsupp em on ac.recid=em.linkacct WHERE ac.rectype='c' AND em.contact='E-Mail Address' AND (em.linkacct NOT...
SQL Query – GoldMine Primary Contacts with Primary Email, and Email Merge Code
The following SQL Query will display all of the GoldMine Primary Contacts with their associated Primary Email Address, as well as the Email Merge Code. select contact1.contact, isnull(contsupp.contsupref,'') + isnull(contsupp.address1,'') as Email, contsupp.mergecodes from contact1 left outer join contsupp on contact1.accountno=contsupp.accountno where contsupp.rectype='P' and contsupp.contact='E-Mail Address' and contsupp.zip like...
Is Your PC Running Slow? Maybe it’s time to DEFRAG!!
Defragging is one of those things – like doing the dishes or picking up the clothes off the floor – that you know you should get around to doing, but for some reason it’s so very difficult to find the time to do. There’s no doubt that it’s important. Yet,...
SQL Query – Possible Missed Follow-ups
The following SQL Query shows who you’ve had a call or appointment with in the last 60 days. The list generated can then be used to determine who you've followed up with and who you haven't. You can update/modify the query below to show more or less days and don't...
GoldMine Premium Edition 2013.1 now in Beta
The latest version of GoldMine Premium Edition is now going through its final 'beta' testing phase before being released to the public. Whats New in GoldMine Premium Edition 2013.1: Integration with Constant Contact Office 2013 x86 Support (Outlook, Word and Excel links) 50+ Customer and Partner reported issues fixed, including...
Outlook Auto-Complete List
Most people that have used Outlook know that it will remember addresses you have sent E-mails to, but it only relies on E-mails already sent for this functionality to work. This is done with Outlook’s Auto-Complete function, which is a list that Outlook uses to store E-mail addresses that have...