From the monthly archives:

June 2011

GoldMine 9.0.2 Release

June 29, 2011

in Misc.

To everyone in the US & Canada – Happy Independence Day!

GoldMine 9.0.2 is now in General Availability – “Below the Fold” are the Release Notes.

Get a Full Year of GoldMine Training for Less Than .50$/Day!

[click to continue…]

{ 0 comments }

SQL Query to Find Bad Email Addresses in GoldMine

June 8, 2011

in GoldMine Tips,SQL Query

Hey there – hope everyone is having a great summer!

Keeping your data clean in a CRM system like GoldMine, can be a chore. Here’s a nifty SQL Query that’ll help you find invalid email addresses in Goldmine. Simply Copy & Paste this into GoldMine’s SQL Query window (Tools | SQL Query) and start cleaning!

SELECT c1.company                                      ,
 c1.contact                                      ,
 cs.contsupref + ISNULL(cs.address1, '') AS email,
 c1.accountno
FROM   contact1 c1
 INNER JOIN contsupp cs
 ON     c1.accountno = cs.accountno
 AND    cs.contact   = 'E-mail Address'
 AND    cs.rectype   = 'P'
 AND
 (
 (
 cs.contsupref + ISNULL(cs.address1, '') NOT LIKE '%@%'
 )
 OR
 (
 cs.contsupref + ISNULL(cs.address1, '') LIKE '%]%'
 )
 OR
 (
 cs.contsupref + ISNULL(cs.address1, '') LIKE '%[%'
 )
 OR
 (
 cs.contsupref + ISNULL(cs.address1, '') LIKE '%)%'
 )
 OR
 (
 cs.contsupref + ISNULL(cs.address1, '') LIKE '%)%'
 )
 OR
 (
 cs.contsupref + ISNULL(cs.address1, '') LIKE '%,%'
 )
 OR
 (
 cs.contsupref + ISNULL(cs.address1, '') LIKE '%..%'
 )
 OR
 (
 cs.contsupref + ISNULL(cs.address1, '') LIKE '%/%'
 )
 OR
 (
 cs.contsupref + ISNULL(cs.address1, '') LIKE '%\%'
 )
 )

Don’t miss our June Special on GoldMineTraining.NET

{ 0 comments }

CompanionLink Updates

June 8, 2011

in CompanionLink,CompanionLink Affinity Code - Use TB5222

Fixes in companionlink.exe 5/23/2011 build 4044
- Added logic to increase update sync speed for Outlook and/or Google sync.
- Fixed issue where sync with Google would occasionally prompt for .NET 2.0 installation.
- Fixed issue where edited instances of GoldMine 9 recurring events would not sync without a reread.
- Added support for syncing contact linking info with Zoho calendar events.
- Cleaned up some minor UI issues under the Applications tab.
- Stability enhancements for Secure Hosted Sync.
- Stability enhancements for GroupWise sync.
- (Pro only) Added support for syncing Palm custom fields 5 – 9 to Blackberry contact note.
- Fixed issue syncing certain company names with Salesforce.
- Added support for syncing Outlook tasks created from email via drag and drop.
- Fixed issue syncing Highrise account with no contacts present.
- Fixed issue where certain events in Google could be moved to a different Google calendar after syncing with ACT!.
- Added option to transfer cleared records in CLTC.
- Fixed issue where “Acct:” prefix could sync from handheld device back into BCM.
- Added support for sending ACT!/GM linking info to Outlook calendar note when configured for iPhone via Outlook.
- Added conflict resolution settings for WiFi sync.
- Fixed issue where certain unicode characters could prevent data from syncing with Palm Desktop.
- Fixed issues syncing xml characters with Google phone fields.
- Fixed issues syncing “last day of the month” recurring events with Google.
- Improved category filter interface for CompanionLink Express/Pro/FA.
- Fixed issue where relabeled email field in Google could cause email deletion in Zoho.