<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="rss.xsl"?>
<rss version="0.91"><channel>
<title>RSS feed</title>
<link>http://www.consultcore.com/coreblog</link>
<description>An RSS feed for 8pixel.net Blog engine</description>
<language>EN</language>
<item>
<author><![CDATA[Admin]]></author>
<category><![CDATA[GoldMine CRM]]></category>
<title><![CDATA[Auto-Fill sending emails from GoldMine?!?!]]></title>
<description><![CDATA[<p><font size="2" face="Verdana">We received a call from a client who wondered why the GoldMine Auto-Fill address function was intermittent. Intermittent?? We did not even know it existed!</font></p>
<p><font size="2" face="Verdana">The client&nbsp;found that (in 8.0.2) when he goes to add an address to a CC box, if he starts typing an address it auto-fills (like Outlook). This is new in PE, but there is a BIG catch. His issue is that it did not <em>always </em>work. </font></p>
<p><font size="2" face="Verdana">We researched it and found that there is a section in the User.ini called [AutoComplete], and there was a list of names and email addresses in that section. Any of these names will Auto-Fill a CC box in an outgoing email. Next question; how did they get there? We added a CC using the old GoldMine method (click <em>Add|Contact </em>and searched for the CC recipient). Once this was done, the address we searched to was added to the <strong>TOP</strong> of the [AutoComplete] section of the User.ini. When we sent a subsequent email and went to the CC line, if we began typing, the name auto-filled.</font></p>
<p><font size="2" face="Verdana">In order for this to work you need to click in the CC box, as if you were about to <em>manually enter </em>the recipient address. Not well-documented, but it can be a time-saver, especially when you CC the same contacts regularly. </font></p>
<div>By default, the 10 most recently used recipients are stored in the User.ini. To change the&nbsp;size of the auto-complete list, add this setting in user.ini:</div>
<div>&nbsp;</div>
<div>[AutoComplete]</div>
<div>StackMax = ...</div>]]></description>
<pubDate>3/3/2010 11:45:34 AM</pubDate>
<link>http://www.consultcore.com/coreblog?view=plink&amp;id=57</link>
<id>57</id></item>
<item>
<author><![CDATA[Admin]]></author>
<category><![CDATA[GoldMine CRM]]></category>
<title><![CDATA[GoldMine: A referral was returned from the server]]></title>
<description><![CDATA[<p>We received a call from a customer last week (<strong>GoldMine Premium Edition 8.0.2 in a Vista OS</strong>), who was getting the following error when attempting to login: <em><strong>&ldquo;A referral was returned from the server.&rdquo; </strong></em><strong>GoldMine </strong>would not start.</p>
<p>After researching the issue we found that <strong>the digital signature used with GoldMine 8.0.x expired in early December</strong>. In a Vista environment, this means that if the <strong>Vista User Account Control (UAC) </strong>feature is turned &quot;On,&quot; <strong>GoldMine </strong>will not be allowed to run.</p>
<p><strong>UAC</strong> is a feature that is built into <strong>Vista, Server 2008 and Windows 7</strong>. It appears as a warning messages asking for confirmation when you double-click on an icon. Many users have, long ago, turned UAC &quot;Off&quot;. Some Programs however (eg. QuickBooks), require the UAC.</p>
<p>Your two options are to <strong>run Vista with UAC turned &quot;Off&quot; </strong></p>
<p>or</p>
<p><strong>upgrade to version 8.5.x of GoldMine</strong>. (If your Maintenance contract is current, there is no charge for the software and you can take advantage of some new features and fixes, along with an active digital certificate.)</p>
<p><a href="mailto:sales@consultcore.com?subject=Re%3A%20Vista%20Issue%2C%20I%20want%20to%20know%20more%20about%20upgrading%20to%20PE%208.5">Contact Core today to check your eligibility.</a></p>]]></description>
<pubDate>12/14/2009 11:24:26 AM</pubDate>
<link>http://www.consultcore.com/coreblog?view=plink&amp;id=53</link>
<id>53</id></item>
<item>
<author><![CDATA[Steven Matulewicz]]></author>
<category><![CDATA[GoldMine CRM]]></category>
<title><![CDATA[GoldMine - Checking for Orphans]]></title>
<description><![CDATA[<p>Here are some helpful queries you can run through your SQL interface.&nbsp; Records that are not inter-connected in the <strong>Goldmine </strong>database (known as <em><strong>Orphan Records</strong></em>) can cause some major issues, especially if you are planning on upgrading.</p>
<p>--this one gives you a record count:</p>
<p><em><strong>select count(accountno) from contact1</strong></em></p>
<p>-- this one should come back as zero:</p>
<p><em><strong>select count(accountno) from contact1<br />
where accountno not in (select accountno from contact2)</strong></em></p>
<p>--this one should have less than 5:</p>
<p><em><strong>select count(accountno) from contact2<br />
where accountno not in (select accountno from contact1)</strong></em></p>
<p>--lastly, check your history:</p>
<p><em><strong>select count(accountno) from conthist<br />
where accountno not in (select accountno from contact1)</strong></em></p>
<p>If any of the last 3 queries results in any value above 20, you should contact your <em><strong><a href="mailto:support@consultcore.com?subject=I%20want%20help%20with%20GoldMine%20SQL%20Queries">Goldmine Consultant&nbsp; </a></strong></em>and discuss methods of cleaning your database.</p>]]></description>
<pubDate>12/9/2009 1:32:00 PM</pubDate>
<link>http://www.consultcore.com/coreblog?view=plink&amp;id=38</link>
<id>38</id></item>
<item>
<author><![CDATA[Scott Weiss]]></author>
<category><![CDATA[Microsoft CRM]]></category>
<title><![CDATA[Microsoft CRM - The email router service will not start]]></title>
<description><![CDATA[<p>The file: Microsoft.Crm.Tools.EmailAgent.SystemState.xml &nbsp;is corrupt. &nbsp;The file size is probably 0 K. &nbsp;To fix the problem (as always - back up before performing these steps):</p>
<ol>
    <li>On the server running the email router, navigate to the directory where the email router service is installed</li>
    <li>Delete the file - it will be recreated when the service starts. &nbsp;</li>
    <li>Start the service</li>
</ol>]]></description>
<pubDate>12/4/2009 9:03:27 AM</pubDate>
<link>http://www.consultcore.com/coreblog?view=plink&amp;id=51</link>
<id>51</id></item>
<item>
<author><![CDATA[Steven Matulewicz]]></author>
<category><![CDATA[GoldMine CRM]]></category>
<title><![CDATA[Using Gmail with Goldmine]]></title>
<description><![CDATA[<p>There is a known issue when trying to use Gmail or Yahoo with Goldmine.&nbsp; We have found a Freeware item called Stunnel that corrects the issue.&nbsp; The following example uses Gmail as an example, you will need to find out what Yahoo uses for ports and pop/smtp.<br />
<br />
1.&nbsp;&nbsp;&nbsp; Go to http://www.stunnel.org/download/binaries.html and download the most recent .exe.<br />
<br />
2.&nbsp;&nbsp;&nbsp; Install Stunnel to EACH LOCAL MACHINE that will be accessing gmail or yahoo.&nbsp; Use the default settings.<br />
<br />
3. Click Start | All Programs | Stunnel | Edit stunnel.conf <br />
<br />
4. Modify as follows: <br />
a. Uncomment the &quot;client = yes&quot; line (remove the ;&nbsp; ) <br />
b. modify the [pop3s] section as follows: <br />
<br />
[pop3]<br />
accept=995<br />
connect=pop.gmail.com:995<br />
[smtp]<br />
accept=465<br />
connect=smtp.gmail.com:465<br />
<br />
5. Click start | All Programs| Stunnel| Install Service.<br />
6. Click start | All Programs| Stunnel| Run Service.&nbsp; NOTE:&nbsp; always make sure the service is running if you have any issues connecting.<br />
7. Now open GoldMine, and use &quot;127.0.0.1&quot; in place of your POP/STMP server definitions on the the accounts you wish to protect with SSL.</p>
<p>8. Go to the Advanced Options window and set the ports to match the definitions you have just made in stunnel.conf.&nbsp; Also, you will probably have to activate the &quot;This server requires authentication&quot; option in the SMTP half of this window.<br />
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 &lsquo;all messages than come in from now on&rsquo; was the best option.<br />
&nbsp; <code><br />
</code></p>]]></description>
<pubDate>11/12/2009 11:53:12 AM</pubDate>
<link>http://www.consultcore.com/coreblog?view=plink&amp;id=45</link>
<id>45</id></item>
<item>
<author><![CDATA[Steven Matulewicz]]></author>
<category><![CDATA[GoldMine CRM]]></category>
<title><![CDATA[GoldMine - Queries return more than 10,000 records]]></title>
<description><![CDATA[<p>Some companies need to run filters for targeting various campaigns to their customers.&nbsp; However, if they try to view a SQL filter with a large number of members, they hit a snag:&nbsp; the Query&nbsp; Builder has a limit of 10,000 records.&nbsp; So what do you do if your group has more than 10,000 matches?</p>
<p>Not to worry: here is the solution.</p>
<p>For the User who is working with&nbsp;said query, add the following to the <em>[Goldmine] </em>section of their <em>user.ini </em>file:</p>
<p><u><strong>sqlquerylimit=50000</strong></u></p>
<p>This will increase the viewed limit to 50,000. You can, of course, enter in any number; 50,000 is just an example.</p>
<p>Also, if&nbsp; a user needs to see a larger number of items on their <em>Details Tab</em>, add this as well:</p>
<p><u><strong>mssqlmaxbrowserec=xxxxx&nbsp;&nbsp; </strong></u>where &quot;X&quot; is the number of maximum records you want to view.</p>
<p>&nbsp;NOTE:&nbsp; Increasing the size of the view can tend to slow down your Goldmine access:&nbsp; only add this code if it is absolutely necessary.</p>]]></description>
<pubDate>11/2/2009 4:17:28 PM</pubDate>
<link>http://www.consultcore.com/coreblog?view=plink&amp;id=26</link>
<id>26</id></item>
</channel></rss>
