There is a known issue when trying to use Gmail or Yahoo with Goldmine.  We have found a Freeware item called Stunnel that corrects the issue.  The following example uses Gmail as an example, you will need to find out what Yahoo uses for ports and pop/smtp.

1.    Go to http://www.stunnel.org/download/binaries.html and download the most recent .exe.

2.    Install Stunnel to EACH LOCAL MACHINE that will be accessing gmail or yahoo.  Use the default settings.

3. Click Start | All Programs | Stunnel | Edit stunnel.conf

4. Modify as follows:
a. Uncomment the "client = yes" line (remove the ;  )
b. modify the [pop3s] section as follows:

[pop3]
accept=995
connect=pop.gmail.com:995
[smtp]
accept=465
connect=smtp.gmail.com:465

5. Click start | All Programs| Stunnel| Install Service.
6. Click start | All Programs| Stunnel| Run Service.  NOTE:  always make sure the service is running if you have any issues connecting.
7. Now open GoldMine, and use "127.0.0.1" in place of your POP/STMP server definitions on the the accounts you wish to protect with SSL.

8. Go to the Advanced Options window and set the ports to match the definitions you have just made in stunnel.conf.  Also, you will probably have to activate the "This server requires authentication" option in the SMTP half of this window.
9. Finally, go to the Gmail account on the Gmail web page and go to your settings area and enable pop3 access. I found that enabling it for ‘all messages than come in from now on’ was the best option.
 


Some companies need to run filters for targeting various campaigns to their customers.  However, if they try to view a SQL filter with a large number of members, they hit a snag:  the Query  Builder has a limit of 10,000 records.  So what do you do if your group has more than 10,000 matches?

Not to worry: here is the solution.

For the User who is working with said query, add the following to the [Goldmine] section of their user.ini file:

sqlquerylimit=50000

This will increase the viewed limit to 50,000. You can, of course, enter in any number; 50,000 is just an example.

Also, if  a user needs to see a larger number of items on their Details Tab, add this as well:

mssqlmaxbrowserec=xxxxx   where "X" is the number of maximum records you want to view.

 NOTE:  Increasing the size of the view can tend to slow down your Goldmine access:  only add this code if it is absolutely necessary.