Archive

Posts Tagged ‘Goldmine’

Outlook with Goldmine Plugin: Data Error

December 15th, 2010 No comments

If you’re getting the following error message in Outlook, and you have the Goldmine plugin installed, it’s probably the plugin that’s causing it:

Unable to convert ‘System.String’ to ‘System.Int32’

This error occurs when the Goldmine plugin attempts to display invalid data in the Goldnine pane in Outlook. The invalid data could be Null values stored as units or amounts in forecasted sales. You can;

  1. Check for null values for units or amount in forecasted sales: NUMBER1, NUMBER2 fields in CAL table, where RECTYPE = ‘S’
  2. Manually cleanse data by changing the nulls to zeros.

or

  1. Turn off display of Forecasted Sales in Outlook. Go to Setup GoldMine Plus, Options, uncheck Show Forecasted Sales.

Easy.

Share
Categories: Tips Tags: , , , ,

Set up Goldmine with Google Mail

March 18th, 2010 4 comments

Has your company switched to Google Apps and you’re wondering how to get your emails in Goldmine? It’s actually quite easy. (I say Google Apps, but this will work for personal use Gmail as well as Google Apps Mail).

First you need to enable IMAP on your Google Mail account (if it isn’t already). In Google Mail go to Settings. Then click the Forwarding and POP/IMAP tab> Check the radio button to enable IMAP.

Now set up Goldmine to connect to GMail. In Goldmine go to Tools> User settings> Preferences> Email. In the Getting mail section set the server to IMAP and enter address imap.gmail.com. Username is your email address, password is your password. Check the ‘Use encrypted connection (SSL)’ box.

In the Sending Mail section the SMTP server is smtp.gmail.com, return address is your email address. Again, check the ‘Use encrypted connection (SSL)’ box.

Done

Update 16.08.10:

I think Google have made security on their servers a bit tighter. Follow these extra steps to get things working:

On the Email settings tab, click the Accounts button. Select the account in the list and click Edit.
Change the Getting Mail port to 993.
In the Sending Mail section, enter your email address as the username and enter your password. For authentication, select Auto. Check Use Start TLS. Make sure the port number is 587.
That should work.
Share

Goldmine Installation Error

November 30th, 2009 2 comments

Trying to install Goldmine and getting the error message “another Goldmine installation is already running”? This is a very frustrating but easy to fix problem. All you need to do is make a small change to the registry.

Run regedit (Start> Run> regedit).

Go to HKLM> Software> Frontrange solutions. Delete the folder GMinProgress. Exit regedit.

Retry the installation.

Share
Categories: Software, Tips Tags: , ,