<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="wordpress/1.5.2" -->
<rss version="2.0" 
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
>

<channel>
	<title>Castell Computers</title>
	<link>http://www.castellcomputers.com</link>
	<description>Tips and tech tricks from Doug Castell</description>
	<pubDate>Wed, 25 Aug 2010 18:21:05 +0000</pubDate>
	<generator>http://wordpress.org/?v=1.5.2</generator>
	<language>en</language>

		<item>
		<title>The GoldMine Wiki Is Online</title>
		<link>http://www.castellcomputers.com/?p=119</link>
		<comments>http://www.castellcomputers.com/?p=119#comments</comments>
		<pubDate>Wed, 25 Aug 2010 18:20:02 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=119</guid>
		<description><![CDATA[My buddy (and fellow GoldMine consultant Paul) has put up a GoldMine wiki.]]></description>
			<content:encoded><![CDATA[	<p>My buddy, and fellow GoldMine consultant, Paul, has put up a GoldMine wiki.</p>
	<p>I encourage everyone to check it out!  Take a few minutes to contribute your favorite bit of GoldMine geekery!  I know I will get around to doing so myself, eventually!  <img src='http://www.castellcomputers.com/wp-images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' />  </p>
	<p>The GoldMine Wiki can be found <a href="http://www.goldminewiki.com" target="_new" onclick="javascript:urchinTracker ('/outbound/article/www.goldminewiki.com');">HERE.</a>
</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=119</wfw:commentRSS>
	</item>
		<item>
		<title>GoldMine 9.0 Flash Demo</title>
		<link>http://www.castellcomputers.com/?p=118</link>
		<comments>http://www.castellcomputers.com/?p=118#comments</comments>
		<pubDate>Mon, 16 Aug 2010 18:38:29 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=118</guid>
		<description><![CDATA[Interested to see what's in GoldMine 9.0?  Got about 10 minutes to spare?]]></description>
			<content:encoded><![CDATA[	<p>Interested to see what&#8217;s in GoldMine 9.0?  Got about 10 minutes to spare?  Take a look at this quick <a href="http://www.frontrange.com/registration/Register.aspx?regid=6698&#038;HDA=513887" target="_new" onclick="javascript:urchinTracker ('/outbound/article/www.frontrange.com');">flash demo</a> on the FrontRange web site.
</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=118</wfw:commentRSS>
	</item>
		<item>
		<title>GoldMine Premium Edition 9.0 Released!</title>
		<link>http://www.castellcomputers.com/?p=116</link>
		<comments>http://www.castellcomputers.com/?p=116#comments</comments>
		<pubDate>Fri, 18 Jun 2010 23:09:21 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>database</dc:subject><dc:subject>frontrange</dc:subject><dc:subject>GMPE</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>GoldMine 9</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>rumors</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=116</guid>
		<description><![CDATA[GoldMine Premium Edition 9.0 has been released to the public.  ]]></description>
			<content:encoded><![CDATA[	<p>GoldMine Premium Edition 9.0 has been released.</p>
	<p>This is the first major version upgrade to the GoldMine Premium Edition line.</p>
	<p>Now in it&#8217;s second week of release, the 9.0 upgrade seems to be pretty stable and, as of this posting, no major issues have been identified with core functionality. The combination of some nice price offerings and the long list of fixes and improvements that make GoldMine Premium Edition 9.0 a good upgrade for users of GoldMine versions 4/5/6/7.</p>
	<p>From the Release notes included with 9.0.0.102:</p>
	<blockquote>
	<p><strong>WHAT&#8217;S NEW IN GOLDMINE PREMIUM EDITION 9.0</strong></p>
	<p><i>Operating System Compatibility</i><br />
<i>Windows 7</i> is now supported, both in 32-bit and 64-bit versions.<br />
<i>Windows Server 2008 R2</i> is now supported.</p>
	<p><i>Dashboards</i><br />
Dashboards provide a real-time, graphical, and interactive view into key business processes. GoldMine Premium Edition includes eight standard dashboards and also provides a Dashboard Designer for administrators to create additional dashboards, representing data in GoldMine or in other databases. Please see the GoldMine documentation for details.</p>
	<p><i>Outlook Integration</i><br />
Outlook integration includes several major enhancements in this release.</p>
	<p>• New GoldMine panes in Outlook show related contact information. Administrators can configure the display to select the fields and layout to be shown in Outlook.<br />
• E-mails can be linked to contacts, opportunities, projects, and cases from Outlook.<br />
• Automatic linking for messages sent and received in Outlook, with the ability to prompt the user to find or create a contact if there is no matching e-mail address in GoldMine.<br />
• Centralized administration for Outlook synchronization enables administrators to set synchronization settings and schedules for GoldMine users.<br />
• Support for recurring activities when synchronizing with Outlook<br />
• Option to automatically link attachments without prompting the user. In Outlook, go to Setup GoldMine Plus > Options > Use GoldMine attachment handling settings. This option will apply the Existing Attachment Default Action that is established here in GoldMine: Tools > Options > E-mail > More Options > Advanced.<br />
• One-Button Synchronization Profiles can be applied without using the GoldMine internal e-mail client. To update a profile when using Outlook for e-mail, save the profile attachment from the e-mail in Outlook, open GoldMine, go to Tools > Synchronize > Synchronization Settings, browse to the file, and click Update.<br />
• Outlook can be used for composing messages when clicking the E-mail hyperlink in GoldMine. Go to Tools > Options > E-mail and click Use Outlook for linked e-mail addresses.<br />
• Improved usability in Outlook when re-linking an e-mail message to a different contact<br />
• A new navigation pane in Outlook displays clickable links to recently viewed items in GoldMine, to make it easier to switch between applications.<br />
• An option to include the contact’s address in the subject that appears in Outlook after synchronizing calendar items. Go to Tools > Configure > Outlook Integration Settings > Sychronization > Set Up… > Next > Advanced and check Add contact’s address to subject.</p>
	<p><i>Administration</i><br />
GoldMine includes native support for Microsoft SQL Server Express instead of the Firebird database. Firebird is no longer a supported database in GoldMine Premium Edition. During the upgrade to GoldMine Premium Edition 9, a default Firebird database will automatically be rehosted to Microsoft SQL Server. After the upgrade, GoldMine will rehost any other Firebird database if a user attempts to open it.</p>
	<p>GoldMine now supports unattended installation for undocked users and environments with multiple GoldMine configurations. Go to Tools > Configure > System Settings > Script for Unattended Installation and select the type of configuration to install, and fill in the fields shown. Then click Create to generate .ini and .bat files that are used, along with gmsetup.exe, to install GoldMine without requiring a user to click through the installation wizard. Please read the GoldMine Install Guide for more information about unattended installation.</p>
	<p>New options for password policy are included. Administrators can set the following policies at Tools > Configure > System Settings > Password Policy:<br />
• Minimum password length<br />
• Block accounts after three invalid login attempts<br />
• New password cannot repeat any previous password, up to a specified number of previous passwords</p>
	<p>GoldMine now provides a master list of all field label names and database names, to facilitate data import and export. Go to Tools > Configure > Record Types and click All Fields in the left panel. A list of all contact database fields and labels will be shown, for view or export to Excel.</p>
	<p><strong>WHAT&#8217;S ENHANCED IN GOLDMINE PREMIUM EDITION 9.0</strong></p>
	<p><i>Search</i><br />
The options shown in the &#8220;Search By&#8221; list in the Contact Search Center can be reduced to improve usability. Go to Tools > Options > Lookup > More Options and check the boxes corresponding to fields you want to use for searching in the Contact Search Center.</p>
	<p>Last Name is now an option in the Search List drop-down in the Contact List, to simplify searching for a contact by last name.</p>
	<p>The Search List selection in the Contact List is now retained between sessions, so your preferred method of searching is kept automatically. </p>
	<p>When the SQL Query Editor is used in the Contact Search Center, GoldMine now shows a clear error message to the user if the SQL syntax is incorrect.</p>
	<p><i>Administration</i><br />
For improved auditing, archiving, and smartphone access to messages generated within GoldMine, there is a new option to force all e-mail sent to a user to go through the mail server. To enable or change this setting, go to Tools > Users’ Settings > Properties > Choose how to deliver e-mail messages to this user</p>
	<p>GoldMine now automatically repairs corrupted e-mail records, rather than displaying a &#8220;Cal record for this e-mail is missing&#8221; message as in previous versions.</p>
	<p>With the ClearTLogByDelFilter setting customers can control whether to delete TLog records when applying a deletion filter during synchronization. This setting is placed in the [GoldSync] section of the GoldSync.ini file.<br />
• To delete TLog records (default): ClearTLogByDelFilter =1<br />
• To retain TLog records: ClearTLogByDelFilter=0</p>
	<p><i>Calendar</i><br />
GoldMine now provides the option to add or remove users and contacts from an existing activity. To use this feature, edit an existing activity and select the Contacts tab or Users tab to make changes.</p>
	<p>GoldMine now provides the ability to schedule recurring activities with no end date. When this option is used, GoldMine will add a number specific instance of activities corresponding to the recurring activity, and then continue to add more over time to keep calendars booked appropriately.</p>
	<p>The Preview Pane in the Activity List now includes a hyperlink to navigate to the contact record related to the selected activity.</p>
	<p>With the EditWhenDblClick setting customers can choose what happens when they double-click on a calendar item. This setting is placed in the [CalObj] section of the <i>username</i>.ini file.<br />
• To open the activity (default): EditWhenDblClick=1<br />
• To open the contact record: EditWhenDblClick=0</p>
	<p><i>Customer Service</i><br />
Column and Tab Selection in Case Management is now applied only to the logged-in user, not changed globally. Other customizations, as shown on the Labels and Options tabs, are now read-only for users without Master Rights.</p>
	<p>Case Tasks now have a lookup list available to make task names more consistent and easier to enter.</p>
	<p><i>Marketing Campaigns</i><br />
Marketing campaigns now include the ability to add a contact group or filter to an existing campaign. Select a campaign, click Assign Contacts, then select Link All Group/Filter Contacts.</p>
	<p><strong>WHAT&#8217;S FIXED IN GOLDMINE PREMIUM EDITION 9.0</strong></p>
	<ol>
	<li> Selecting different filters on the Filters tab may cause erroneous filter name to be displayed </li>
	<li> When all opportunities are shown in the opportunity manager, the pipeline chart only shows opportunities owned by a single user </li>
	<li> Cannot set GoldMine as default e-mail client on Windows 7 </li>
	<li> GoldMine Address Book not available for selection after installation due to buffer overflow </li>
	<li> From: address is incorrect in a redirected e-mail </li>
	<li> &#8220;Look-up a replacement value in lookup.ini&#8221; is grayed out for Update Field action in Automated Process options </li>
	<li> When select 5 hours in graphical calendar, the scheduled activity defaults to 5 minutes </li>
	<li> Lookup list for Code field is different when creating a Project from when editing a Project </li>
	<li> Application error when changing to non-default Status value while closing lost Opportunity </li>
	<li> Opening the case management module is slow when you have a lot of cases in the database </li>
	<li> Link to opportunity or project is broken when sending an e-mail message </li>
	<li> E-mail created from Opportunity/Project Manager Influencer/Contacts tab has empty Regarding field </li>
	<li> When editing multiple extended details in succession GoldMine will edit the last detail and not the current one highlighted </li>
	<li> Performance issue when browsing through records after selecting first record from Contact Search Center </li>
	<li> Regarding: field in e-mail window shows items sorted by creation date, not alphabetically </li>
	<li> &#8216;Font increase&#8217; and &#8216;Font decrease&#8217; buttons work only after the font is manually changed using &#8216;Font&#8217; button </li>
	<li> Incorrect results in Contact Search Center if no Contact2 column is shown when applying a power search filter with Contact2 fields </li>
	<li> Resolved Date for cases does not synchronize back to server if case was created on remote system and previously synchronized to server </li>
	<li> Cannot add a contact with empty Company field to a case </li>
	<li> Error when opening e-mail from sender with apostrophe in e-mail address </li>
	<li> When performing a two-way sync with Outlook, some calendar items become unlinked from contacts in GoldMine </li>
	<li> Upgraded opportunities not displayed when selecting a user group in the Manager dropdown </li>
	<li> The drop-down list for Manager in the opportunity detail view does not include user groups </li>
	<li> User and Date are not populated in &#8216;Assigned Cases by User&#8217; report </li>
	<li> Create Unicode Database option is enabled during upgrade but has no effect </li>
	<li> Copy current record takes wrong current record information when auto-retrieval in background is active </li>
	<li> When a new user logs in for the first time, Case tab names are reset to default settings </li>
	<li> the f2 lookup for product in a new opportunity shows incorrectly if the product field has cross-field validation in the forecasted sale dialog </li>
	<li> E-mail address for additional contact gets deleted from database when record is opened by user associated with recid ending in a space </li>
	<li> Reference column is too narrow in task list on calendar </li>
	<li> Preview pane in Opportunity History tab does not display e-mails </li>
	<li> Activities occurring on the same date in Case History are displayed in incorrect order after sorting by date </li>
	<li> &#8220;Auto name assignment&#8221; setting for attachments in GoldMine is not applied when forwarding e-mail in Outlook </li>
	<li> Incorrect labels shown in preview pane for completed Case Task </li>
	<li> GMAPI call MenuCommand produces “Access Denied” status </li>
	<li> Opportunity Forecast field does not refresh when adding sales line items </li>
	<li> Number of units and price are not visible in Opportunity detail view after closing Opportunity </li>
	<li> Extended detail tabs do not sort in date order correctly </li>
	<li> When adding a Competitor to an Opportunity, the Select button adds the first Competitor from the lookup list </li>
	<li> Unlinked phone message does not save the Contact name entered </li>
	<li> F2 lookup for Product field varies, depending on where the field is accessed </li>
	<li> Switching from Fields tab to Summary tab causes incorrect editable fields to appear </li>
	<li> There is no vertical scroll bar for Tasks in Opportunities or Projects </li>
	<li> Users without master rights cannot see cases associated to curtained contact records owned by a group of which user is member </li>
	<li> Cannot link messages to additional contacts in Outlook </li>
	<li> EditWhenDblClick setting produces inconsistent results when double-clicking on an activity </li>
	<li> Font is set to Times New Roman 3 while composing new e-mail from HTML template </li>
	<li> &#8216;Remember lookup by&#8217; option does not retain &#8216;contact (primary and additional)&#8217; selection after closing contact search center </li>
	<li> When E-mail Center is opened, keyboard focus is on the folder tree rather than the message list </li>
	<li> Changes made to tabs of master users do not remain static </li>
	<li> User column in History contains wrong value when overriding required field entry </li>
	<li> &#8216;Send Outlook Message&#8217; defaults always to Plain Text format if a default template exists in GoldMine </li>
	<li> Changes made to maximized Case Description field do not save </li>
	<li> E-mail fields [subject, date, linked to, from] occasionally disappearing when opening e-mails linked from Outlook </li>
	<li> Only one instance of a recurring GoldMine appointment syncs into Outlook </li>
	<li> Time Clock sorts dates numerically, not chronologically </li>
	<li> Contact Search Center does not display more than two decimal places for a numeric field </li>
	<li> Main Dictionary Language does not have a default value </li>
	<li> Only one case is included in service report when run for current contact only </li>
	<li> Ctrl + C does not copy highlighted text on Pending or History preview pane </li>
	<li> Incorrect results in contact search center with Power Search using filters </li>
	<li> Cannot use tab key to select field displayed off screen in Fields tab </li>
	<li> Last Attempt is only updated by an unsuccessful call or message, not any other activity </li>
	<li> Revoked menu items are still visible for GoldMine user </li>
	<li> revoking ALL rights and almost all menus from a User still allows User to change / create Relationships and set access options </li>
	<li> Inconsistent retention of Show field between Activity List sessions </li>
	<li> Notes field from extended details are not displayed on reports </li>
	<li> GoldMine macro in e-mail subject line pulls data from active contact instead of merged contact if filter/group is selected before template </li>
	<li> When replying to an e-mail with spell checking disabled, double-clicking the Send button causes application error </li>
	<li> Non-Master users see non-functional menu items for features that are only available to Master users </li>
	<li> Required Fields setting does not alert always </li>
	<li> Incorrect sort on Date column for Extended Details </li>
	<li> Merged document has different format for Phone1 and FAX fields </li>
	<li> When replying to plain text emails, HTML formatting is set if using original text in reply </li>
	<li> Tempdb is not used when running reports, so users require more rights than needed in previous versions </li>
	<li> When replying with original message, the whole original message is not included if it contains &#8220;&lt;&lt; &gt;&gt;&#8221; </li>
	<li> When entering F2 lookup, // is required when creating non-displayed descriptive info but list shows the descriptive info in parentheses. </li>
	<li> Clicking header to sort Activated and Previewed filter in Contact Search Center releases filter but doesn&#8217;t change tab text </li>
	<li> Selecting Relate to when creating a New Record will not add an relationship tree to existing record if one does not already exist </li>
	<li> E-mail fields [subject, date, linked to] intermittently disappear when scrolling through inbox </li>
	<li> Using an e-mail template to reply doesn&#8217;t allow quoting original message with &#8216;>>&#8217; symbol </li>
	<li> User preference for &#8216;Show numerics aligned to the right&#8217; does not stick for non-master users </li>
	<li> calendar displays closed amount of a forecasted sale on all completed activities </li>
	<li> E-mail message body is lost after closing error message regarding digital certificate </li>
	<li> when creating a opportunity after editing one the opportunity always defaults to the first if you edited </li>
	<li> Completion of a Literature request is based on the Assigned To field, not on who completes the literature request </li>
	<li> Relationship tab does not refresh properly when expanding a section </li>
	<li> Import from Outlook does not bring Notes over correctly </li>
	<li> When editing a follow-up activity that did not have Send a request selected but this option was selected on original activity, Send a Meeting Request Update is checked </li>
	<li> Delete key does not work when trying to remove attachment from outgoing e-mail </li>
	<li> Reports Center does not display preview of report if HTML_CAL_NOTES=0 is set </li>
	<li> Cannot copy/paste e-mail headers </li>
	<li> When scrolling between cases, the notes from the last case are displayed </li>
	<li> User name is incorrect on the History tab in a Case when the user name starts with a &#8220;K&#8221; </li>
	<li> Contact record focus changes after filing message with Sync Contact enabled </li>
	<li> Activity List displays wrong entries after automatically releasing an active contact filter </li>
	<li> If e-mail address is set as required data entry, user is prompted to fill in all required fields when creating a new record with an e-mail address </li>
	<li> HTML_CAL_NOTES=0 setting causes pending and completed activity notes to suppress blank lines </li>
	<li> When editing a History record you cannot click the New button to create a new opportunity </li>
	<li> Add ClearTLogByDelFilter setting to optimize sync performance with deletion filter </li>
	<li> When pasting text, an extra carriage return is added to the e-mail body </li>
	<li> Cannot drag and drop files from Windows Explorer to Details/Links tab of Opportunity </li>
	<li> When using a rich-text e-mail as a default reply template, the font always defaults to Times New Roman </li>
	<li> GoldMine installer does not alert user that Windows 2000 is incompatible </li>
	<li> Address macros that include City, State, ZIP have an extra comma </li>
	<li> Expanded details labels are incorrect when selecting the Setup or Info tab for the detail </li>
	<li> After closing e-mail message tab, focus shifts to the E-mail Center folder tree and not the e-mail message list </li>
	<li> The Copy Current Record box adds data to new record even though it has been removed from the dialog box before the record is created </li>
	<li> Relationship tab does not refresh automatically after adding a new record to a company. </li>
	<li> Some e-mails with embedded images are not linked from Outlook </li>
	<li> Days are shown as bold in calendar when containing activities that are removed from display </li>
	<li> Contacts under Company are not sorted alphabetically in Contact Search Center </li>
	<li> Schedule Follow-up does not carry over time and duration when completing activity via Pending tab or Activity List </li>
	<li> Opportunity creation with Wizard should be consistent with creation without Wizard related to Product field. </li>
	<li> Column order from &#8216;Column Selection&#8217; dialog is not respected by Contact List grid </li>
	<li> Context-dependent lookup setting is not retained if lookup is used in several areas of GoldMine </li>
	<li> &#8216;Assertion failed&#8217; error creating transfer set with serialized sync disabled </li>
	<li> List Existing Data option does not apply to all screens </li>
	<li> Deleting an activity is slow when using Activity List with Sync Contact option </li>
	<li> ADO errors recorded during sync processing </li>
	<li> When completing activities, user can bypass Force Valid Input setting by canceling the entry and clicking on a different field </li>
	<li> &#8220;Daily - DayTimer (detailed)&#8221; Fixed page layout creates duplicate entries on the report </li>
	<li> Copy current record option does not recognized blank edits </li>
	<li> Activating a Relationship tree at root only activates section containing current contact, unless all sections have been expanded </li>
	<li> After upgrade some e-mail addresses do not appear next to hyperlink on contact record view </li>
	<li> Incorrect times posted for activities falling after time-change </li>
	<li> Error sending read receipt message in response to message created in Outlook </li>
	<li> Relationship tree couldn&#8217;t be found if it was created for contact with empty Company field </li>
	<li> Inbox tree is collapsed when Deleted folder is selected </li>
	<li> Clicking on a date in My Calendar pane may navigate to wrong dates on Weekly view after the 28th of the month </li>
	<li> User must reselect e-mail address when sending message to additional contact from the Influencers tab </li>
	<li> Field label length is not respected when limited in layout tab of field properties </li>
	<li> Merge tagged records does not keep first record tagged if subsequent tagged records are above the first record in the contact search center </li>
	<li> Log Away feature does not support passwords over 11 characters </li>
	<li> When selecting Users&#8217; Security in GoldSync site group, some override options are unavailable </li>
	<li> Improper spacing before Country when applying &#038;FullAddress macro </li>
	<li> Adding contacts to a Relationships tab with an activated filter does not add all records in the filter </li>
	<li> Last field populates with data from current record when creating New Record with Copy current record option and no Contact name entered </li>
	<li> When editing from the Contact List view, edits to user-defined fields are not reflected in the Contact List until the user clicks the refresh button </li>
	<li> Status number of contacts when sorting a group exceeds the total number of contacts in the group </li>
	<li> Deleting system fields from Wide View can interfere with search functions </li>
	<li> PHP file from WebImport script generator is programmed incorrectly </li>
	<li> Cannot refresh results in Contact Search Center </li>
	<li> Ctrl + A to select All in the mail folder no longer works </li>
	<li> Users who cannot schedule a forecast sale can still create a sale against an opportunity </li>
	<li> Request a return receipt option is not respected when applied in a default template </li>
	<li> Inbound e-mail shows wrong activity type when viewed in Case History tab </li>
	<li> Notes duplicated with sync after upgrade </li>
	<li> Preference to set alarms by default is not respected when reassigning or escalating cases </li>
	<li> User is prompted three times when using Word document with FILLIN prompt </li>
	<li> GoldMine not listed as available mail program for mailto protocol on Vista </li>
	<li> Detail header records in the CONTSUPP table (rectype = ‘H’) have some blank or null field values after moving record to new database </li>
	<li> .docx preview is not displayed in lower right pane of Document Management Center </li>
	<li> Output To: >> Word function fails when using a localized version of Word </li>
	<li> Crystal Reports ODBC data source limited to SQL Server type, not SQL Native Client </li>
	<li> Completing an activity for one user while logged in as a different user displays the name of the original GoldMine user </li>
	<li> Process monitor logs appear under the GoldSync site logs in the GoldSync Admin Center </li>
	<li> &lt;&lt;cursor&gt;&gt; field is lost after editing existing document template </li>
	<li> Ability to select a group or filter of contacts to add to an existing campaign </li>
	<li> Cannot create an email rule that applies to case escalation messages </li>
	<li> custom details field are being truncated </li>
	<li> Notify via E-mail option does not support external e-mail clients such as smartphones </li>
	<li> Relationship Tree folders are limited to 68 on root level </li>
	<li> Peg Board does not show current data </li>
	<li> Date field does not function correctly when using new default Record Type </li>
	<li> Cannot drag and drop sections of Relationship Tree </li>
	<li> Peg Board column width is not adjustable </li>
	<li> Web Site is not copied when using Copy Current Record option </li>
	<li> User notifications for scheduled activities are not delivered to external e-mail clients </li>
	<li> Output To Printer Option is grayed out in Activity List for Non-Master users. </li>
	<li> When editing an existing document in the Document Management Center, carriage returns are double spaced </li>
	<li> Nothing returned with &#038;AdditionalContact macro </li>
	<li> Incorrect name displayed on Opportunity related to an Additional Contact </li>
	</ol>
	</blockquote>
	<p class="MsoNormal"><b style=""><span style="">DATABASE SCHEMA CHANGES IN GOLDMINE PREMIUM EDITION 9.0</span></b></p>
	<p class="MsoNormal"><b style=""><span style="">&nbsp;</span></b></p>
	<h1><i><span style="font-size: 10pt; font-family: Tahoma; font-weight: normal;">New database tables</span></i></h1>
	<p class="MsoNormal">&nbsp;</p>
	<p class="MsoNormal"><b style="">CUSTVIEW</b>(dashboard)</p>
	<table class="MsoNormalTable" style="border: medium none ; width: 495.9pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="661">
	<tbody>
	<tr style="">
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><span style="">Column<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><span style="">Type<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal"><span style="">Allow nulls<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal"><span style="">Description<b></b></span></p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>NAME</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(100)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Dashboard&rsquo;s name</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>CATEGORY</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(100)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Dashboard&rsquo;s category</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>USERID</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Who has access (user or group name)</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>CREATED_BY</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">User who created the dashboard</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>CREATED</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">When created</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>MODIFIED_BY</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">User who modified the dashboard</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>MODIFIED</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">When modified</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>DEVELOPED</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Who developed: 1- FrontRange, 2 &ndash; Others</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>METAINFO</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">text</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Meta information</p>
	</td>
	</tr>
	<tr style="">
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>recid</b></p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Unique ID</p>
	</td>
	</tr>
	</tbody>
	</table>
	<p class="MsoNormal">&nbsp;</p>
	<p><span style="font-size: 10pt; font-family: Tahoma; font-style: normal;">CUSTDATASOURCE</span> <span style="font-size: 10pt; font-family: Tahoma; font-weight: normal; font-style: normal;">(dashboard data source)</span> <span style="font-size: 10pt; font-family: Tahoma; font-style: normal;"></span></p>
	<table class="MsoNormalTable" style="border: medium none ; width: 495.9pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="661">
	<tbody>
	<tr style="">
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><span style="">Column<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><span style="">Type<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal"><span style="">Allow nulls<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal"><span style="">Description<b></b></span></p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>NAME</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(100)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Data source name</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>CATEGORY_ID</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Category id</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>USERID</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Used for sorting </p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>CREATED_BY</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Who created</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>CREATED</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">When created</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>MODIFIED_BY</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Who modified </p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>MODIFIED</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">When modified</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>DEVELOPED</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Who developed: 1- FrontRange, 2 &ndash; Others</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>RECTYPE</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(1)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">C &ndash; category, D &ndash; data source</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>METAINFO</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">text</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Meta information</p>
	</td>
	</tr>
	<tr style="">
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>recid</b></p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Unique ID</p>
	</td>
	</tr>
	</tbody>
	</table>
	<p class="MsoNormal">&nbsp;</p>
	<p><span style="font-size: 10pt; font-family: Tahoma; font-style: normal;">CUSTRELATIONS </span><span style="font-size: 10pt; font-family: Tahoma; font-weight: normal; font-style: normal;">(which dashboard uses which data sources)</span> <span style="font-size: 10pt; font-family: Tahoma; font-style: normal;"></span></p>
	<table class="MsoNormalTable" style="border: medium none ; width: 495.9pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="661">
	<tbody>
	<tr style="">
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><span style="">Column<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><span style="">Type<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal"><span style="">Allow nulls<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal"><span style="">Description<b></b></span></p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>VIEW_ID</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Dashboard&rsquo;s id</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>DS_ID</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Data source&rsquo;s id</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>CONTROL_ID</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Dashboard part&rsquo;s id</p>
	</td>
	</tr>
	<tr style="">
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>recid</b></p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Unique ID</p>
	</td>
	</tr>
	</tbody>
	</table>
	<p class="MsoNormal">&nbsp;</p>
	<p><span style="font-size: 10pt; font-family: Tahoma; font-style: normal;">REPORTTEMP</span><br />
<span style="font-size: 10pt; font-family: Tahoma; font-weight: normal; font-style: normal;">(used for creating reports)</span> <span style="font-size: 10pt; font-family: Tahoma; font-style: normal;"></span></p>
	<table class="MsoNormalTable" style="border: medium none ; width: 495.9pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="661">
	<tbody>
	<tr style="">
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><span style="">Column<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><span style="">Type<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal"><span style="">Allow nulls<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal"><span style="">Description<b></b></span></p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>REC</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Record id</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal"><b>EXPR</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.05pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(256)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">Expression</p>
	</td>
	</tr>
	<tr style="">
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>USERID</b></p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Who is printing the report</p>
	</td>
	</tr>
	</tbody>
	</table>
	<p><span style="font-size: 10pt; font-family: Tahoma; font-style: normal;">CALDEF</span> <span style="font-size: 10pt; font-family: Tahoma; font-weight: normal; font-style: normal;">(recurrence pattern for an activity)</span> <span style="font-size: 10pt; font-family: Tahoma; font-style: normal;"></span></p>
	<table class="MsoNormalTable" style="border: medium none ; width: 495.9pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="661">
	<tbody>
	<tr style="">
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><span style="">Column<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal"><span style="">Type<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal"><span style="">Allow nulls<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal"><span style="">Description<b></b></span></p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>RECTYPE</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">1 = recurrence series pattern</p>
	<p class="MsoNormal">2 = modified exception &ldquo;pattern&rdquo;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>STARTDATE</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>STARTTIME</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(5)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>ENDDATE</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>ENDTIME</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(5)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>DURATION</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>ENDNOCCUR</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">The number of occurrences after which the recurrence ends. If specified, the value of ENDDATE is ignored.</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>RECUR_TYPE</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">1 = hourly</p>
	<p class="MsoNormal">2 = daily</p>
	<p class="MsoNormal">3 = weekly</p>
	<p class="MsoNormal">4 = monthly</p>
	<p class="MsoNormal">5 = yearly</p>
	<p class="MsoNormal">&nbsp;</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>INTERVAL</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">A value which represents how often the activity repeats; e.g. a value of 2 for weekly recurrence means the activity occurs every 2 weeks.</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>SKIPNONWORK</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">0 = no skip</p>
	<p class="MsoNormal">1 = skip weekend/non-work hours</p>
	<p class="MsoNormal">Null for weekly recurrence.</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>REPEATBY</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">1 = by specific day</p>
	<p class="MsoNormal">2 = by day of the week</p>
	<p class="MsoNormal">Null for hourly, daily recurrence.</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>ONDAY</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">For monthly and yearly recurrence, represents: a specific day of the month if Flags = 1; Nth day of the week if Flags = 2.</p>
	<p class="MsoNormal">Null for hourly, daily, weekly recurrence.</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>ONDOW</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">For weekly recurrence, represents the day(s) of week when the activity occurs. E.g. Sunday and Tuesday = 20 + 22 = 5.</p>
	<p class="MsoNormal">For monthly and yearly recurrence, represents an Nth day of the week if Flags = 2.</p>
	<p class="MsoNormal">Null otherwise.</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>ONMONTH</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">For yearly recurrence, represents a month of the year (for both Flags = 1 and Flags = 2).</p>
	<p class="MsoNormal">Null for the other types of recurrence.</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>USERS</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Text</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	<p class="MsoNormal">List of user items separated by a delimiter; a user item consists of a userid.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>RESOURCES</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Text</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">List of resources separated by a delimiter.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>CONTACTS</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Text</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">List of contact items separated by a delimiter; a contact item consists of an ACCOUNTNO and an optional CONTSUPP.RECID, separated by another delimiter, if the contact is an additional contact.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>EXCEPTIONS</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Text</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">List of exception items separated by a delimiter; an exception item consists of the original datetime of the instance, separated by another delimiter from the type:</p>
	<p class="MsoNormal">1 = modified</p>
	<p class="MsoNormal">2 = deleted</p>
	<p class="MsoNormal">3 = completed</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>COMPEXC</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Text</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Data on partially-completed activity occurences</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>PRIMARYUSER</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">User assigned to the activity; has full security rights over the activity.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>IS_INFINITE</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">0 = recurrence has end date, or no recurrence;</p>
	<p class="MsoNormal">1 = recurrence is infinite</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>LAST_ROLL_OCCUR</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">The last instance of an infinite recurrence that was generated during rolling. The next rolling should base its calculation of instances on this value. Null for finite recurrence.</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>ROLL_DATE</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">For infinite recurrence, date when rolling of recurrence should occur.</p>
	<p class="MsoNormal">Null for exception pattern record.</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>CREATED_BY</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">User who created the activity</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>CREATED_ON</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Activity creation date</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>CREATED_AT</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(5)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">Activity creation time</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>MODIFIED_BY</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">User who modified the activity</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>MODIFIED_ON</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">Activity modification date</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>MODIFIED_AT</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(5)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Activity modification time</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>ORIG_DATA</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Text</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">Some original information (color, rectype, ref, private, alarm flag, linked to)</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>ORIG_NOTES</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Text</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Original notes</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>ORIG_DATE</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">Original date</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>ORIG_TIME</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(5)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Original time</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>LINKRECID</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">Mail id</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>ATTENDEES_EX</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Text</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">List of attendees separated by a delimiter</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>CALRECTYPE</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(1)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">Type of calendar activity</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>ORGANIZER_EX</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(100)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Real organizer&rsquo;s name if it is not a user</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>GLOBALID</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(200)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">Global Appointment ID from Outlook</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>BLOCKEDBY</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(8)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">For internal use in synchronization process</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>BLOCKEDON</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Datetime</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">For internal use in synchronization process</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99.15pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal"><b>BLOCKEDAT</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 99pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="132">
	<p class="MsoNormal">Varchar(5)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.45pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">For internal use in synchronization process</p>
	</td>
	</tr>
	<tr style="">
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 99.15pt;" valign="top" width="132">
	<p class="MsoNormal"><b>recid</b></p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 99pt;" valign="top" width="132">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; width: 238.45pt;" valign="top" width="318">
	<p class="MsoNormal">Record&rsquo;s id</p>
	</td>
	</tr>
	</tbody>
	</table>
	<p class="MsoNormal">&nbsp;</p>
	<h1><i><span style="font-size: 10pt; font-family: Tahoma; font-weight: normal;">New columns in existing tables</span></i></h1>
	<p class="MsoNormal">&nbsp;</p>
	<p><span style="font-size: 10pt; font-family: Tahoma; font-style: normal;">CAL</span><span style="font-size: 10pt; font-family: Tahoma; font-style: normal;"></span><span style="font-size: 10pt; font-family: Tahoma; font-weight: normal; font-style: normal;">(calendar activities)</span></p>
	<table class="MsoNormalTable" style="border: medium none ; width: 495.9pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="661">
	<tbody>
	<tr style="">
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 1.45in;" valign="top" width="139">
	<p class="MsoNormal"><span style="">Column<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 93.7pt;" valign="top" width="125">
	<p class="MsoNormal"><span style="">Type<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal"><span style="">Allow nulls<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal"><span style="">Description<b></b></span></p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 1.45in; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="139">
	<p class="MsoNormal"><b>CALDEF_ID</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 93.7pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="125">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 1.45in;" valign="top" width="139">
	<p class="MsoNormal"><b>ORIG_DATE</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 93.7pt;" valign="top" width="125">
	<p class="MsoNormal">DATETIME</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 1.45in; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="139">
	<p class="MsoNormal"><b>ORIG_TIME</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 93.7pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="125">
	<p class="MsoNormal">Varchar(5)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 1.45in;" valign="top" width="139">
	<p class="MsoNormal"><b>IS_EXCEPTION</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 93.7pt;" valign="top" width="125">
	<p class="MsoNormal">Smallint</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 1.45in; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="139">
	<p class="MsoNormal"><b>CALDEFEX_ID</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 93.7pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="125">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border: medium none ; padding: 0in 5.4pt; width: 1.45in;" valign="top" width="139">
	<p class="MsoNormal"><b>FLAGS</b></p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 93.7pt;" valign="top" width="125">
	<p class="MsoNormal">Int</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border: medium none ; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	<tr style="">
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 1.45in; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="139">
	<p class="MsoNormal"><b>ATTENDEES_EX</b></p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 93.7pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="125">
	<p class="MsoNormal">Varchar(100)</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">&nbsp;</p>
	</td>
	</tr>
	</tbody>
	</table>
	<p class="MsoNormal">&nbsp;</p>
	<p><span style="font-size: 10pt; font-family: Tahoma; font-style: normal;">CONTHIST</span><span style="font-size: 10pt; font-family: Tahoma; font-weight: normal; font-style: normal;">(contact history)</span></p>
	<table class="MsoNormalTable" style="border: medium none ; width: 495.9pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="661">
	<tbody>
	<tr style="">
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 1.45in;" valign="top" width="139">
	<p class="MsoNormal"><span style="">Column<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 93.7pt;" valign="top" width="125">
	<p class="MsoNormal"><span style="">Type<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 59.3pt;" valign="top" width="79">
	<p class="MsoNormal"><span style="">Allow nulls<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal"><span style="">Description<b></b></span></p>
	</td>
	</tr>
	<tr style="">
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 1.45in; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="139">
	<p class="MsoNormal"><b>COMPLETEDID</b></p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 93.7pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="125">
	<p class="MsoNormal">Varchar(15)</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 59.3pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="79">
	<p class="MsoNormal">No</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">Used for synchronizing completed activities</p>
	</td>
	</tr>
	</tbody>
	</table>
	<p class="MsoNormal">&nbsp;</p>
	<p><span style="font-size: 10pt; font-family: Tahoma; font-style: normal;">USERS</span></p>
	<table class="MsoNormalTable" style="border: medium none ; width: 495.9pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="661">
	<tbody>
	<tr style="">
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 104.35pt;" valign="top" width="139">
	<p class="MsoNormal"><span style="">Column<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 90.05pt;" valign="top" width="120">
	<p class="MsoNormal"><span style="">Type<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 63pt;" valign="top" width="84">
	<p class="MsoNormal"><span style="">Allow nulls<b></b></span></p>
	</td>
	<td style="border-style: solid none; border-color: rgb(79, 129, 189) -moz-use-text-color; border-width: 1pt medium; padding: 0in 5.4pt; width: 238.5pt;" valign="top" width="318">
	<p class="MsoNormal"><span style="">Description<b></b></span></p>
	</td>
	</tr>
	<tr style="">
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 104.35pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="139">
	<p class="MsoNormal"><b>EMC_ACC_EMAILS</b></p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 90.05pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="120">
	<p class="MsoNormal">Text</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 63pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="84">
	<p class="MsoNormal">Yes</p>
	</td>
	<td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(79, 129, 189); border-width: medium medium 1pt; padding: 0in 5.4pt; background: rgb(211, 223, 238) none repeat scroll 0%; width: 238.5pt; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial;" valign="top" width="318">
	<p class="MsoNormal">List of all user&rsquo;s e-mails</p>
	</td>
	</tr>
	</tbody>
	</table>
	<p class="MsoNormal"><b style=""><span style="">&nbsp;</span></b></p>
	<p>Feel free to contact Doug directly for more information about this patch, upgrade pricing or GoldMine Premium Edition, in general!</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=116</wfw:commentRSS>
	</item>
		<item>
		<title>Solving the Error Message: A referral was returned from the server</title>
		<link>http://www.castellcomputers.com/?p=115</link>
		<comments>http://www.castellcomputers.com/?p=115#comments</comments>
		<pubDate>Wed, 09 Dec 2009 19:14:24 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=115</guid>
		<description><![CDATA[A recent Microsoft patch has resulted in an unrecoverable error for many GoldMine users, "A referral was returned from the server."  There's a solution!]]></description>
			<content:encoded><![CDATA[	<p>Recently, many GoldMine users have been encountering a problem that stops their GoldMine in its tracks.  When they double-click the GoldMine shortcut, they&#8217;re presented with an inscrutable error: <strong>&#8220;A referral was returned from the server.&#8221;</strong>  After the error, GoldMine does not start.</p>
	<p>What&#8217;s going on is that every GoldMine version has a digital signature and the one used with GoldMine 8.0.x <strong>expired </strong>in early December, 2009.  That means that the windows <a href="http://en.wikipedia.org/wiki/User_Account_Control" target="_new" onclick="javascript:urchinTracker ('/outbound/article/en.wikipedia.org');">User Account Control</a> (UAC) feature will not allow it to run.</p>
	<p>UAC is a feature that is built into Windows Vista, Server 2008 and Windows 7.  You know it as that annoying feature that produces a constant stream of messages along the lines of, <em>&#8220;Hey, it looks like you are trying to double-click an icon.  Did you know that icons could run terrible viruses?  Please click OK to confirm you want to run the thing you double-clicked!&#8221;</em>  A lot of people have simply turned UAC off (including me!) but those who have not are now finding themselves unable to run GoldMine.</p>
	<p>There are two possible solutions</p>
	<ol>
	<li>Turn off UAC like the rest of us.  Of course, if you haven&#8217;t done that by now, you probably have a very good reason (like you use Quickbooks, which requires it) or you enjoy the implied additional security features.</li>
	<li>Patch to version 8.5.x of GoldMine (free to customers current on their Frontrange Maintenance) and enjoy the many fixes and new features introduced therein (including a new digital certificate.)</li>
	</ol>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=115</wfw:commentRSS>
	</item>
		<item>
		<title>GoldMine Premium Edition Patch 8.5.2 Available</title>
		<link>http://www.castellcomputers.com/?p=114</link>
		<comments>http://www.castellcomputers.com/?p=114#comments</comments>
		<pubDate>Fri, 04 Dec 2009 19:43:12 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=114</guid>
		<description><![CDATA[GoldMine Premium Edition Patch 8.5.2 Available]]></description>
			<content:encoded><![CDATA[	<p>GoldMine Premium Edition sees it&#8217;s fifth patch, version 8.5.2 (aka 8.5.2.8)</p>
	<p>This is the sixth patch since the initial release of GoldMine Premium Edition (8.0) and the third one in the 8.5 line.  It&#8217;s also very likely to be the final 8.x patch we&#8217;ll see before the release of version 9.0 in the spring of 2010.</p>
	<p>The main goal of this patch was to clean up lingering issues primarily in the Opportunity/Project and E-mail areas of 8.5   There are some nice tweaks to the Universal Search area and general stability too.</p>
	<p>From the Release notes included with 8.5.2:</p>
	<blockquote>
	<p><strong>WHAT&#8217;S ENHANCED IN GOLDMINE PREMIUM EDITION 8.5.2</strong></p>
	<p>The Opportunity Manager and Project Manager provide a filter that lets users select opportunities or projects by Status.  To use this filter, click on the dropdown arrow next to the &#8220;Show:&#8221; label and select the corresponding Status.  To view all opportunities or projects that are not completed, select &#8220;Active&#8221; in the dropdown menu.  This is a new option in GoldMine Premium Edition 8.5.2..</p>
	<p><strong>WHAT&#8217;S FIXED IN GOLDMINE PREMIUM EDITION 8.5.2</strong></p>
	<p>Note:  GoldMine Premium Edition 8.5.2 also provides the fixes and enhancements included with GoldMine Premium Edition 8.5.0 and <a href="http://www.castellcomputers.com/?p=111" >8.5.1</a>.</p>
	<ol>
	<li>	111458	Multiple Projects created when converting an Opportunity with associated Tasks	</li>
	<li>	110790	Users without master rights cannot see opportunities associated to curtained contact records owned by a group of which user is member	</li>
	<li>	108551	&#8216;An exception occurred&#8217; windows appearing during e-mail merge	</li>
	<li>	108224	Error message during auto-retrieve if message is simultaneously deleted from server by another e-mail client	</li>
	<li>	108134	Edit E-mail (from template) pulls wrong current record information when auto-retrieval in background is active	</li>
	<li>	107450	Linked documents do not get retrieved if pointer is a sub-folder of a mapped drive	</li>
	<li>	106708	AutoComplete section in User.ini grows to include thousands of spaces, causing slow performance	</li>
	<li>	106472	Forecast field is not refreshed properly after scheduling an additional forecasted sale for an opportunity	</li>
	<li>	106525	Incorrect data created when several WebImport e-mails are received at once	</li>
	<li>	106190	When opening an e-mail from the Online folder, the wrong email opens for the end-user	</li>
	<li>	106053	Notes modified in GMSE / GMCE to remove return following user/datetime stamp do not display in GMPE 8.03 but do exist in the contact1 > notes field.  When upgraded to GMPE 8.5.1.12, notes do not display in GoldMine and are not in notes > note field. 	</li>
	<li>	105911	Transfer set with over 4GB of documents results in ‘Unable to set end of file: %s’ error when retrieving on remote	</li>
	<li>	105672	Memory leak causes &#8216;The Cal record for the requested e-mail is missing&#8217; message	</li>
	<li>	105315	Non-master users cannot see pending activities of other users after upgrade from 6.7 to GMPE 8.5.1	</li>
	<li>	105238	Free/Busy information is not displayed on the Free/Busy tab when scheduling an activity when plain text notes are used	</li>
	<li>	105228	Sorting for Age column in Opportunity manager crashes GoldMine	</li>
	<li>	105224	Performance issue when loading a lot of opportunities	</li>
	<li>	105222	Go to Opportunity from Contact&#8217;s Opportunity tab browses to sometimes to wrong opportunity	</li>
	<li>	105212	Probability column in Opportunity list is sorted alphanumerically, not by numeric value	</li>
	<li>	105209	Unable to move in Opportunities from last to first using the FIRST RECORD toolbar navigation arrow	</li>
	<li>	104961	Notes do not import form DBF, CSV, SQL tables, or Excel	</li>
	<li>	104726	When you do an override, the contact on the history record is not the contact you&#8217;re on	</li>
	<li>	104718	Unable to move between projects in sequential order using the toolbar navigation arrows	</li>
	<li>	104665	Not all empty required fields are displayed in the List of Required field alert window	</li>
	<li>	104503	Closed column in Opportunity list is sorted alphanumerically, not by numeric value	</li>
	<li>	104492	Sort on Forecast Column does not work if there are any opportunities shown with no forecast value	</li>
	<li>	104490	Copy\Move process creates unlinked activities	</li>
	<li>	104410	Notes deleted when moving contact record to a different database	</li>
	<li>	104358	Release a group takes up to a full minute, during that time the end user can not use GMPE.	</li>
	<li>	104066	When you click the drop down menu for the MANAGER field in the Opportunity Manager you can only see 30 users	</li>
	<li>	103996	The Regarding: field on E-mail creation window is smaller than in former GMPE versions. Additionally there is even less space as it also displays the linked type (opportunity, project or case)	</li>
	<li>	103786	‘Unable to load gm7s32.dll’ error when installing GMPE 8.5.0 with Outlook integration	</li>
	<li>	103434	‘Unable to load gm7s32.dll’ error when installing GMPE 8.5.0	</li>
	<li>	103408	Opportunities are sometimes shown multiple times in the opportunity manager	</li>
	<li>	103184	Universal search performance is very slow for users that do not have access to all contact records	</li>
	<li>	102767	Grid filter doesn&#8217;t work in Real Time folder or Opportunity History tab	</li>
	<li>	102632	CPU spikes when opening Opportunity or Project manager with tasks tab in focus	</li>
	<li>	102408	Tab order changes to the fields do not &#8220;stick&#8221;	</li>
	<li>	102379	When the goldmine e-mail center refreshes it resets the users selected e-mail view and sort	</li>
	<li>	102037	Selecting a tab with a custom sort order saved does not highlight the first record for that sort order.  The sort will be correct, but the highlighted record is always the first record of the default sort.  User must scroll to get to desired record.	</li>
	<li>	101910	Opportunity pipeline chart only shows data for logged in user	</li>
	<li>	101700	Word merge is slow when running GoldMine on a server that is not part of a domain	</li>
	<li>	101467	Members tab incorrectly edits the group name when editing the reference field	</li>
	<li>	100708	Changes in the details pane of an active opportunity seems to change the wrong opportunity - only after a refresh correct data displayed again	</li>
	<li>	100458	When using same return address for several e-mail accounts only the first SMTP server in the list is used to send e-mails	</li>
	<li>	100377	Sync contact option inhibits calendar function/navigation	</li>
	<li>	100284	Merge/Purge tagged records does not update Accountno for all history items from deleted record	</li>
	<li>	95919	Messages not previewed in project / opportunity history tab	</li>
	<li>	95648	When sorting opportunities by actual close date, the sort is not chronological	</li>
	<li>	82779	“Chilkat” error displayed when receiving an improperly formed e-mail message	</li>
	</ol>
	</blockquote>
	<p>Feel free to contact Doug directly for more information about this patch or GoldMine Premium Edition, in general!</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=114</wfw:commentRSS>
	</item>
		<item>
		<title>GoldMine Premium Edition Patch 8.5.1 Available</title>
		<link>http://www.castellcomputers.com/?p=111</link>
		<comments>http://www.castellcomputers.com/?p=111#comments</comments>
		<pubDate>Tue, 21 Jul 2009 18:13:10 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=111</guid>
		<description><![CDATA[GoldMine Premium Edition Patch 8.5.1 is now Available!]]></description>
			<content:encoded><![CDATA[	<p>GoldMine Premium Edition sees it&#8217;s fifth patch, version 8.5.1 (aka 8.5.1.12)</p>
	<p>This is the fifth patch since the initial release of GoldMine Premium Edition (8.0) and the second one in the 8.5 line.  Let&#8217;s face it: the original 8.5.0 patch was a bit of a bust in that it fixed lots of things but unfortunately brought with it a couple of major issues surrounding e-mail.</p>
	<p>Now in it&#8217;s third week of release, the 8.5.1 patch seems to be much more stable.  It provides a nice list of fixes and improvements that make GoldMine Premium Edition 8.5 a compelling choice for users still living with GoldMine 4/5/6/7.</p>
	<p>From the Release notes included with 8.5.1:</p>
	<blockquote>
	<p><strong>WHAT&#8217;S NEW IN GOLDMINE PREMIUM EDITION 8.5.1</strong></p>
	<p>Note:  GoldMine Premium Edition 8.5.1 also provides the enhancements included with GoldMine Premium Edition 8.5.0, listed below.</p>
	<p>GoldMine now supports Windows Vista SP2. </p>
	<p>GoldMine now supports Windows 2008 SP2.</p>
	<p>GoldMine now supports Microsoft SQL Server 2008 SP1.</p>
	<p>GoldMine now supports Microsoft Office 2007 SP2.</p>
	<p>GoldMine now supports Windows Internet Explorer 8.</p>
	<p><strong>WHAT&#8217;S NEW IN GOLDMINE PREMIUM EDITION 8.5.0</strong></p>
	<p>GoldMine now supports 32-bit and 64-bit versions of Windows Server 2008.</p>
	<p>GoldMine now supports Microsoft SQL Server 2008.</p>
	<p>GoldMine now supports the 64-bit version of Windows Server 2003.</p>
	<p>Universal Search provides a single search box from which you can find contacts, notes, activities, e-mail messages, documents, and other items in GoldMine.  This new feature is located at Go To > Search > Universal Search.</p>
	<p>GoldMine Integration Services for Microsoft Outlook (GISMO) is now included in the GoldMine installer, no longer requiring a separate installation.</p>
	<p>Cross-field validation enables an F2 lookup list to change based on the value in another field.  For example, you can enter a value for the Title field that is only valid for a specific Department.  To enable this option, click the Setup button in the Field Lookup (F2) screen and select “Lookup list depends on another field”.  Check the “Force valid input” box to enforce the validation.</p>
	<p>A Preview Pane is available in the tabs within a contact record, providing a faster view into activities, e-mails, details, and linked documents. </p>
	<p>Unattended installation enables GoldMine to be installed or upgraded without end-user intervention.  To enable this option, check the box labeled “Create configuration file for unattended installation” when installing GoldMine on an end-user’s computer.  Then place the gmsetup.exe, gm_is.ini,  and gmsetup_si.bat files into the same directory on another end-user’s computer, and execute the gmsetup_si.bat file to install GoldMine.<br />
In addition, future workstation upgrades can be setup to install automatically.  After installing GoldMine on a server and creating the files listed above, go to Tools -> Configure -> System Settings -> Upgrade and enter the paths for the files.  This automatic upgrade process will take effect in releases after GoldMine Premium Edition 8.5.0.<br />
 As a result of the changes described above, the Minimal Setup and option was removed from the GoldMine installer and the Install Locally option was removed from the License Manager.</p>
	<p>The E-mail Center and Opportunity/Project Manager user interfaces have been redesigned for better usability.</p>
	<p>Secure SSL connections now are supported in the E-mail Center.  To configure an SSL connection, go to Tools > Options > E-mail.</p>
	<p>The IMAP protocol now is supported in the E-mail Center, providing more security and better interoperability with other e-mail clients.  To configure an IMAP e-mail account, go to Tools > Options > E-mail.</p>
	<p>A new System Settings screen is available for administrators to establish global system settings for search performance tuning and other items.</p>
	<p>Unicode database support enables multiple languages to be stored within a single GoldMine database.  This option is available when installing, upgrading, or rehosting GoldMine.  Note: selecting this option will significantly increase the size of the database.</p>
	<p>New user settings are available for administrators to permit a user to Insert notes, Edit/delete own notes, and Edit/delete others’ notes.  These permissions can be set by clicking on Tools > Users’ Settings > Properties > Access.</p>
	<p>A new user setting is available to grant permission for end users to customize their toolbars.  To prevent end users from customizing their toolbars, go to Tools > Users’ Settings > Properties > Access and uncheck “Customize toolbar”.</p>
	<p>The GoldMine Lookup Wizard now enables users to look up contacts matching multiple fields within Details.  To use this feature, click on Tools > Filters and Groups > SQL Query > Build… to launch the wizard, and then select “Contact Information” and “Contacts containing the following Details tab information”.</p>
	<p>A new Pending RSVP folder is available in the Activity List, displaying the pending activities for which the user has requested notification via RSVP.</p>
	<p>Additional configuration options are available in the Service Center.  Category, Offering, and Origin now are optional columns to be displayed in the case list view.  Case field labels also can be modified by users with master rights.</p>
	<p>A single case can be associated with multiple contacts, using the new Contacts tab displayed in the case view.  With this feature, activities and e-mail messages associated with multiple contacts also can be linked to the same case.</p>
	<p>When a case is reassigned, escalated, abandoned, or resolved, there now is a History entry that indicates what occurred.  This history is viewable from the case or from the primary contact for the case.</p>
	<p>GoldMine includes new tools for managing relationships between records in your database.  To set up relationships between records that already are in your database, use the new relationship tree builder at Tools > Data Management > Create Default Relationship Trees.  To add relationships as new records are created, check the “Relate To” box when adding a new record.  The section name used when creating a new record can also be set by record type (Tools > Configure > Record Types, select a record type, click Edit, and enter a Relationship Tree Section Name).</p>
	<p>The updated column chooser in the Contact Search Center now includes the ability to display the contact’s e-mail address and web site as columns in the Search Center and Contact List views.</p>
	<p>Users now can run a single search for primary and additional contacts within the Contact Search Center.  To use this option, select Search by:  Contact (primary or additional).</p>
	<p>Individual activities can be printed or copied to other applications.  To print or copy an activity, right-click on the activity and select Output To.</p>
	<p>The Field Properties screen has been redesigned to simplify the process of changing global field labels.  To access the previous settings, including the ability to define a local label specific to a contact set, click the More Options button on the Profile tab of Field Properties.</p>
	<p>The user interface for scheduling an activity with multiple contacts has been redesigned to be easier to use and more powerful.  To add multiple contacts to an activity, click on the search icon next to the contact field on the Activity Detail tab.  By default, the activity will be set at the same time for all contacts.  To make the activities occur in a series, select the Series tab and choose “Schedule a series of activities with different times for different contacts”.<br />
	Activities now can be scheduled based on a maximum number of activities per day, or based on fixed activity duration.  In addition, a “wrap up time after each activity” can be used to provide a delay between the completion of one activity and the beginning of the next activity.</p>
	<p><strong>WHAT&#8217;S ENHANCED IN GOLDMINE PREMIUM EDITION 8.5.0</strong></p>
	<p>Keyboard navigation has been enhanced to provide better access to core product features without using the mouse. </p>
	<p>Synchronization and database rehosting performance has been enhanced, especially when using the Firebird database.</p>
	<p>The 2 GB size limit has been removed for synchronization transfer sets and installation files for one-button synchronization.</p>
	<p>Concurrent GoldSync connections are queued to improve reliability.  As users connect to a GoldSync server, they automatically are placed in a queue, up to the number of users established in the Number of Connections screen within GoldSync configuration.  If simultaneous processing of concurrent connections is required instead of queuing, please contact your Solutions Partner or FrontRange Support Services for recommendations and instructions.</p>
	<p>E-mail messages sent when viewing a case are automatically linked to the case.  While viewing a case in the service center, click on Actions > Send E-mail Message in the top menu bar.</p>
	<p>The Linked Document Mover has been enhanced with the ability to restrict the locations from which documents will be moved.  This feature is available at Tools > Data Management > Move Linked Docs and Attachments.</p>
	<p>The Details tab now provides 12 customizable fields for each type of Detail.  Previous versions of GoldMine provided 8 customizable fields for Details.</p>
	<p>The import and export wizards now have simplified support for comma-separated (CSV) files.  To import a CSV file, click on File > Import and Export > Import Contact Records.</p>
	<p>Automated Processes can create cases, using the Create Case action in Event Properties.  To create or edit a process, click on Tools > Automated Processes > Manage Processes.</p>
	<p>For consistent terminology, the Tracks tab has been renamed to Processes.</p>
	<p>The sort order of records displayed in the Contact List and Contact Search Center can be synchronized to allow users to scroll through records in the same order as they are displayed in the Contact Search Center.  To enable this option, right-click on the results in the Contact Search Center and select “Set Record Scroll Order”.</p>
	<p>The Contact Search Center supports the percent symbol (%) as a ‘wildcard’ for matching partial names of contacts or companies.</p>
	<p>Macros can be added to custom toolbars.  To use macros, first add the macro buttons (Record, Edit, Stop, and Pause) to the standard toolbar by clicking on the down-arrow button at the right end of the toolbar, and clicking on each button.  Click the Edit button to view existing macros and drag-and-drop them to a custom toolbar.</p>
	<p>Notes are now stored in a dedicated NOTES table for better reporting, auditing, and data synchronization.  Previous versions of GoldMine combined all notes for a contact in a single field.<br />
	Because of this new structure for Notes, GoldMine does not support Global Replace on notes or filters based on notes.  However, Universal Search provides similar functionality, as it enables the user to search within notes and then use the list of matching contacts as an active filter.  To do this, check the Advanced box in Universal Search and select Notes as the only item within “Find these items”.  Enter the search term and click Go.  Check the box in the Tag column in the first row of the search results.  Scroll to the bottom of the search results and shift-click the Tag column in the last row.  This will activate a contact list of all the contacts with notes that include the search term.</p>
	<p>A cancel button has been added to the toolbar that appears when editing notes for a contact record.  To cancel the entry of a note, click the red X that appears in the Notes tab.</p>
	<p>The Tasks folder of the Activity List now shows the related opportunity, project or case and enables the user to navigate directly to it, by clicking on the link shown in the Regarding column.</p>
	<p>The Fax field in the Additional Contact record can be relabeled for use as a Mobile number or for storing other data.  To change the label of this field, include the following entry in the [GoldMine] section of the gm.ini configuration file:  AddContactFaxLabel=[yourlabel]</p>
	<p>Users can now cut, copy, and paste field data with a right-click on the field.  In previous versions of GoldMine, right-clicking on a selected field would display the lookup list for the field.  To display the lookup list, press F2 or the Application Key (on most keyboards, this is a button with a picture of a drop-down menu).  In addition, the auto-complete feature is activated when a user begins typing data into a field, as an alternative to opening the lookup list window.</p>
	<p>The E-mail Center now supports integrated Windows authentication using NTLM.  With this feature, e-mail access can be set up without entering or updating the password in GoldMine.  To configure this option, go to Tools > Options > E-Mail.</p>
	<p>E-mail Center performance can be configured with the following settings:  </p>
	<p>1.  (New) When messages are deleted in the E-mail Center, they are not immediately deleted from the server until the connection is closed.  This behavior provides the fastest performance but can cause deleted messages to reappear as duplicates in some scenarios.  If this problem appears, the following [UserName].INI setting can be used:</p>
	<p><code>[Internet]<br />
PopImmediateDelete=1		(closes server connection after each message is deleted)</code></p>
	<p>The default value for this setting is 0, which keeps the connection open after deleting a message.</p>
	<p>2.  (New) GoldMine automatically sends periodic messages (“no-ops”) to the e-mail server to keep the connection open for fast response time.  By default these messages occur every 10 seconds.  Some e-mail servers require more frequent messages to maintain the connection.  To change the frequency of these messages, use the following [UserName].INI setting:</p>
	<p><code>[Internet]<br />
PopNoopTimer=nnnn		(where nnnn is the number of seconds between messages)</code></p>
	<p>3.  GoldMine automatically disconnects from the e-mail server if it has no related activity for 10 minutes, by default.  This is useful, for example, when using both the Online and Auto-retrieve options with an e-mail server that permits only one connection.  To change the time delay before automatically disconnecting, use the following [UserName].INI setting:</p>
	<p><code>[Internet]<br />
PopIdle= nnnn 			(where nnnn is the number of minutes until disconnect)</code></p>
	<p><strong>WHAT&#8217;S FIXED IN GOLDMINE PREMIUM EDITION 8.5.1</strong></p>
	<p>Note:  GoldMine Premium Edition 8.5.1 also provides the fixes included with GoldMine Premium Edition 8.5.0, listed below.</p>
	<ol>
	<li>	Contact Search Center appears to hang when search term is configured to &#8216;popup when selected&#8217; and focus is reset to search center multiple times	</li>
	<li>	When typing the @ sign for an email address on a Danish keyboard, the focus shifts to the search box	</li>
	<li>	When executing an automated process that updates Key1, focus is changed to another contact record	</li>
	<li>	Activities in history are displayed in the incorrect order after sorting by date	</li>
	<li>	E-mails without unique message IDs are not downloaded	</li>
	<li>	Activity scheduled for multiple contacts and multiple users is repeated once per user	</li>
	<li>	There is no feedback to the end user when using &#8216;get selected message&#8217; for a message that is already in the inbox	</li>
	<li>	Sorting on Forecast column in opportunity manager is by characters, not on their numerical value	</li>
	<li>	Cannot uncheck &#8216;Link to selected Contact:&#8217; when editing previously scheduled activity	</li>
	<li>	Page style and column schemes are not available for My GoldMine	</li>
	<li>	Upgrade to 8.5.0 leaves CONTSUPP.CONTACT NOT NULL	</li>
	<li>	Opportunity Manager focuses on oldest entry when selecting History tab	</li>
	<li>	Adding an automated process that updates a field causes the contact tab to change positions	</li>
	<li>	Previews of Office 2007 documents open in a separate window unless registry change is applied	</li>
	<li>	GM7S32.dll call GMW_NewRecID returns a corrupted version of the parameterized LPSTR	</li>
	<li>	Unattended installer does not remove registry key &#8216;GMInProgress&#8217; after installation	</li>
	<li>	Performance issues when opening GoldMine due to usage of COALESCE function in SQL query	</li>
	<li>	After dragging an e-mail to another folder, focus is on the oldest message rather than next message	</li>
	<li>	Toolbar and menu bar customizations are not retained when menu access settings are changed for user	</li>
	<li>	Activating a Group of 1000 or more records takes over a minute	</li>
	<li>	Using the Edit dialog to change stage field on opportunities with multiple forecasts results in overall and first forecasted sale being set to zero	</li>
	<li>	Curtaining of records causes GoldMine to use maximum CPU when non-master user views calendar	</li>
	<li>	Activity on curtained record for non-master user does not appear on calendar	</li>
	<li>	Record counter is not properly updated after opening a record in contact search center that is outside the active filter	</li>
	<li>	Taskbar is duplicated if additional Global items exist before upgrade	</li>
	<li>	Unable to export Knowledge Base topic pages	</li>
	<li>	E-mail Addresses window opens with default action to create a new e-mail address	</li>
	<li>	Case template truncates Subject at 20 characters	</li>
	<li>	Automated Process cloning causes crash	</li>
	<li>	Daily - Day Timer (detailed) and Daily Appointment List Reports display HTML tags in notes	</li>
	<li>	Server location is requested twice for the &#8216;connect to existing database&#8217; installation option	</li>
	<li>	Unexpected sorting for activities in history tab	</li>
	<li>	Certain e-mail signatures can cause e-mail body to become empty after download	</li>
	<li>	Contact List view is not limited via the Tag All feature in the Contact Search Center	</li>
	<li>	Incorrect ‘POST’ method used for web import templates	</li>
	<li>	All data packed into transfer set does not retrieve on remote	</li>
	<li>	Change in stage will insert the Forecast value of the Opportunity into the duration field of the created history item	</li>
	<li>	Incorrect behavior of macros on Vista	</li>
	<li>	Slow response time for first menu action after login on Windows 2008	</li>
	<li>	Preview Pane opens Microsoft Word and Excel documents in separate window	</li>
	<li>	AllUsersForFilteredRecs sync setting is not respected	</li>
	<li>	GoldMine sync process will &#8220;stall&#8221; at random when a site displays a message of &#8220;please wait&#8221; in the process monitor window.	</li>
	<li>	While synchronizing more than one site, the message &#8220;The GoldMine supervisor will perform system maintenance” is displayed	</li>
	<li>	If sync process terminates, users cannot sync until the SYNCTASK table is cleared	</li>
	<li>	Required Field Alert appears intermittently even when required field is populated	</li>
	<li>	In Microsoft Word, fields listed under the heading &#8220;_DATABASE&#8221;  are not sorted	</li>
	<li>	E-mails older than 2 years do not come in with the correct date when converted or linked from Outlook	</li>
	</ol>
	<p>
<strong>WHAT WAS FIXED IN GOLDMINE PREMIUM EDITION 8.5.0</strong>
</p>
	<ol>
	<li>	When editing the alarm time for a previously scheduled Event, the alarm time changes back to 12:00 am	</li>
	<li>	When replying to some HTML e-mails sent from Outlook 2007, the replied text is truncated from the e-mail	</li>
	<li>	Auto-complete enters the wrong field value if the selected lookup list entry contains a semicolon	</li>
	<li>	If the file attribute &#8220;A&#8221; (Archive) is not set on the transfer set file, the file is not downloaded by the remote and is not deleted from the server	</li>
	<li>	Data is not rehosted from dBASE database for user-defined fields with field name in &#8216;u_&#8217; format	</li>
	<li>	When a Forecasted Sale has been scheduled, you cannot edit the Forecasted Sale to change the Contact to an Additional Contact	</li>
	<li>	Manually linking of e-mails in Outlook produces prompts to file in GoldMine, with no means to suppress the prompt	</li>
	<li>	Scheduled For date in History tab is different from the scheduled date of the activity	</li>
	<li>	When selecting a different group in the Groups tab via filter on Group Name column, group members do not refresh	</li>
	<li>	Contact record window not syncing with the Contact List window when you scroll to the bottom of the contact list window then back to the top again	</li>
	<li>	When creating a new contact while linking an e-mail, the phone number is always in USA format	</li>
	<li>	Real-Time folder doesn&#8217;t have a preview pane	</li>
	<li>	Opportunity sales summary is missing from completed opportunity	</li>
	<li>	Text in &#8216;Send request with appt&#8217; dialog says to click &#8216;OK&#8217; but the actual button label is &#8216;Add&#8217;	</li>
	<li>	Contact with Notes Tab report prints notes upgraded from 6.7 with long date in a continuous line	</li>
	<li>	Alarms are set incorrectly for activities scheduled for multiple contacts spanning multiple days	</li>
	<li>	When correcting the spelling of a manually selected section of text, incorrect characters are replaced	</li>
	<li>	Ext field value truncated after autofill	</li>
	<li>	Search for phone numbers with only one character does not return results	</li>
	<li>	Unrelated history items are shown after deleting history record within rolled up relationship tree	</li>
	<li>	Automated Processes not executed in order of designed event number	</li>
	<li>	Web Import template created with Perl script when CDO is selected	</li>
	<li>	With 24 hour format unchecked, GoldMine will still show in 24 hour format based on Windows settings	</li>
	<li>	Editing the view below the contact list can corrupt the view on contact tabs	</li>
	<li>	Notes fields aren&#8217;t shown for some reports	</li>
	<li>	Case becomes unlinked from contact after merging contacts	</li>
	<li>	Activity code and Result code fields do not have lookup list in Statistical Analysis	</li>
	<li>	Selecting to E-mail Contact from a calendar activity linked to an Additional Contact creates email to Primary Contact instead of Additional Contact	</li>
	<li>	If contact record is put into group by more than one user, neither user can remove it	</li>
	<li>	GoldMine closes with no error when selecting Tasks tab for Opportunity Template if Task Dates To Be Based field is not populated in Template Properties	</li>
	<li>	Change to document extension causes corruption in attributes of synchronized document	</li>
	<li>	Incomplete documentation on automated process option “Attempt to trigger only once”	</li>
	<li>	Template loses HTML formatting when switching from primary to additional contact in To: dropdown.	</li>
	<li>	Extra spaces shown on Recently Viewed list for converted additional contact	</li>
	<li>	&#8220;%3E&#8221; appears after recipient e-mail address after adding multiple CC recipients with friendly names on Vista	</li>
	<li>	E-mail attachments not moved from TEMP directory on the last day of a month or the beginning of a new month	</li>
	<li>	Automated process prints documents for incorrect contacts	</li>
	<li>	If GoldMine is minimized and an alarm appears, if the user selects &#8220;View Contact&#8221;, GoldMine will not &#8220;restore&#8221; to show contact	</li>
	<li>	Automated Process is not merging documents in expected order	</li>
	<li>	Change in user&#8217;s access settings not synchronized to remote	</li>
	<li>	Automated process prints documents for incorrect contacts	</li>
	<li>	Forecasted sales for other users are completely hidden from user when access to others Calendars is removed	</li>
	<li>	Slow loading of custom screen with large number of custom fields	</li>
	<li>	Changes to a contact record name will not apply when scheduling activity	</li>
	<li>	Pasting into the activity notes field adds a carriage return	</li>
	<li>	Web Import fails when using Exchange 2007	</li>
	<li>	Lookup Wizard truncated field to 20 characters in SQL query	</li>
	<li>	CSV export does not include Notes and saves as .txt file	</li>
	<li>	Process Monitor interrupts user the first time auto retrieve is processed after logging in	</li>
	<li>	Re-Link button on toolbar always moves the e-mail address to the selected contact	</li>
	<li>	Inconsistent logging of field history changes 	</li>
	<li>	Inconsistency in Lookup lists when completing calls within one Call Type after changing the Call Type in the Completion window	</li>
	<li>	Frequent synchronization using MS SQL 2005 causes event logs on the remote: &#8216;Cannot create new connection because in manual or distributed transaction mode.&#8217;	</li>
	<li>	Line breaks removed when editing a note	</li>
	<li>	Blank date fields rehosted from dBASE database shown as 12/30/1899	</li>
	<li>	Frequently synching on MS SQL 2005 causes event logs on the remote: &#8216;Cannot create new connection because in manual or distributed transaction mode.&#8217;	</li>
	<li>	Document merge in literature fulfillment printed for incorrect contact record	</li>
	<li>	Unable to search on full e-mail address if its over 40 characters	</li>
	<li>	Cannot add a contact to relationship tree using look up an existing contact lookup with E-mail as search criteria	</li>
	<li>	GM+ View is visible when scrolling through Semi-partial curtained records (tabs hidden)	</li>
	<li>	When printing emails, there is no indication of an attached document	</li>
	<li>	Sync logs in GoldSync Administration Center show incorrect site name	</li>
	<li>	Forecasted sales analysis cuts off large numbers	</li>
	<li>	History/Pending tab with large number of records does not show most recent history on first sort	</li>
	<li>	Sync to Outlook doesn&#8217;t display the contact name in Outlook&#8217;s calendar	</li>
	<li>	When recording macro, tabs cannot be opened by keystrokes	</li>
	<li>	Log this alert in history&#8230;&#8217; option appears unchecked even when active	</li>
	<li>	Arabic characters are displayed incorrectly in the contact search center	</li>
	<li>	When scrolling through an active filter, record count changes and an ADO Error is generated in the Windows Event Viewer	</li>
	<li>	Public group not available in drop-down list for the &#8220;add to group&#8221; action in automated process	</li>
	<li>	 E-mail message with 1000 continuous characters generates &#8220;i500 5.5.0 Syntax error - line too long&#8221;	</li>
	<li>	Until contact search center is refreshed, user-defined fields are displayed with a maximum of 25 characters	</li>
	<li>	Forwarded message body does not show all GoldMine E-mail recipients	</li>
	<li>	Projects window is not retained between user sessions	</li>
	<li>	After scrolling past 1000 e-mail messages in the History tab, user cannot open an e-mail message	</li>
	<li>	Sync Spy truncation on Vista	</li>
	<li>	Single-character field appears too small in SQL query results	</li>
	<li>	Completed sales by user ignores cents (only adds whole dollars)	</li>
	<li>	Document name with over 35 characters is truncated on linked documents	</li>
	<li>	GM+View template containing &#038;emailaddress causes application error if active when launching GoldMine	</li>
	<li>	E-mail template sent to a filtered group will only merge the information of the current contact	</li>
	<li>	Option to send a meeting request update is re-activated after user unchecks the option	</li>
	<li>	Forecasted Sales of amount/price of xx.74 will automatically be reduced to xx.73 (for 64 &lt; xx &lt; 82)	</li>
	<li>	New Record creation via Referrals tab context menu causes application error	</li>
	<li>	Activities scheduled with a “Notification” but NO Alarm are still sending an Alarm to the scheduled user	</li>
	<li>	Incomplete documentation on Service Center 	</li>
	<li>	Plain Text e-mail allows HTML text to be pasted in	</li>
	<li>	dBASE expressions are not respected in signature file	</li>
	<li>	Calendar refresh in outline view causes GoldMine to take focus from every other application	</li>
	<li>	Incorrect results when sorting on Age column in opportunity manager 	</li>
	<li>	Case History tab sort is not most recent at top and does not remember user selection	</li>
	<li>	Error message:  Cannot insert duplicate key row in object  &#8216;dbo.HISTORY_ITEM&#8217; with unique index &#8216;HISTITSEL&#8217;	</li>
	<li>	Office documents (Word/Excel) added via hyperlinks cannot be seen in GM+View Tab	</li>
	<li>	&#8216;Remember Lookup By&#8217;  does not work when clicking Search button with CSC open	</li>
	<li>	Notes print from earliest to latest	</li>
	<li>	Missing CAL record message appears when syncing a &#8220;draft&#8221; e-mail to the server	</li>
	<li>	User defined fields are not populated in Contact Search Center when searching by a Filter or Group	</li>
	<li>	Some options in context menu become inactive in CSC when scrolling down more than 1000 records with activated filters	</li>
	<li>	Export wizard truncates secondary contact e-mail addresses to 35 characters	</li>
	<li>	Special characters are not showing correctly when receiving e-mails	</li>
	<li>	E-mail History reference text longer than 20 characters is truncated	</li>
	<li>	GoldMine automatically displays the date format from the Windows regional date settings	</li>
	<li>	When printing the &#8220;Contact with notes&#8221; report, the notes are listed with the oldest date first	</li>
	<li>	Report with large history record only showing &#8216;Notes&#8217; information on first page	</li>
	<li>	Title is incorrectly displayed for additional contact added as Influencer when field is empty	</li>
	<li>	Leads Analysis does not show values when table name begins with numbers or contains blanks	</li>
	<li>	Merge &#038; Edit do not give a message that GoldMine Plus for Microsoft Word is not installed	</li>
	<li>	Filter counts correctly but does not show correct numbers in search center	</li>
	<li>	Free/Busy tab when scheduling activities falsely alerting of a conflict	</li>
	<li>	Result Code checkbox is always disabled in graphical analysis	</li>
	<li>	F2 lookup is empty for second filter condition added in the contact search center	</li>
	<li>	Hot key for Mark as Private does not check box in Schedule an Activity window	</li>
	<li>	Upgraded data does not have appropriate friendly name associated to email address of additional contact following merge.	</li>
	<li>	Clone of closed-won opportunity creates too many opportunity records	</li>
	<li>	Unable to use Office Link (Word) with Vista - User Account Control (UAC) Enabled	</li>
	<li>	Application error when using alarm notification taskbar setting in GMPE	</li>
	<li>	INSERT INTO error when converting an additional contact to a new record	</li>
	<li>	If laptop user has an active filter, a saved sync wizard profile will update to the active filter instead of its saved settings	</li>
	<li>	After creating a macro with keyboard shortcuts, the edit macro button is grayed out on the toolbar	</li>
	<li>	If CSC is opened with no value entered and operator that does not require a value is selected (Is Empty or Is Not Empty), search does not trigger	</li>
	<li>	When filtering a Group of contacts, only those records in the first 500 display unless the entire list is loaded prior to filtering	</li>
	<li>	Label customizations in the opportunity manager are not respected in the opportunity tab on the contact record	</li>
	<li>	SQL temp tables created when creating new record do not consistently drop	</li>
	<li>	If multiple detail names begin with the same characters, then entries for the detail with the longer names will display on the custom tab for the detail with the shorter name	</li>
	<li>	GSSITES table rebuilds itself every other time GMPE is launched on Vista	</li>
	<li>	Process Monitor window can get saved off the screen, making it inaccessible	</li>
	<li>	Contact search center does not show all data after resorting by a column header	</li>
	<li>	Inconsistent prompts for completed activity information when linking a message in Outlook	</li>
	<li>	Contact notes saved to a wrong record using &#8216;Recently viewed&#8217; list	</li>
	<li>	Data not populated correctly in Adobe document	</li>
	<li>	Dates on the navigation pane calendar do not display in bold font for days with Events scheduled 	</li>
	<li>	Sorting a group does not retain the sort order when scrolling through the contacts record in the active group	</li>
	<li>	While editing a SQL query, if an alarm pops up, the text in the SQL query box gets erased	</li>
	<li>	Unmarked button available in Process Monitor Window  -  “close when all processes are done&#8221;"	</li>
	<li>	Selecting &#8216;options&#8217; for a calendar report actually opens the &#8216;profile&#8217; tab instead of the &#8216;options&#8217; tab	</li>
	<li>	Scrolling by Company via arrows does not display all records seen in Contact Search Center	</li>
	<li>	Double click on e-mail button in the toolbar causes GoldMine to become unresponsive	</li>
	<li>	Using the mouse wheel when editing a contact note changes contact record in view	</li>
	<li>	&#8220;Start time cannot be empty&#8221; message appears when scheduling an activity to a group without spanning across multiple days	</li>
	<li>	Macro icons cannot be reused for different users with different macros	</li>
	<li>	When viewing another users preferences, the &#8220;Full Name&#8221; value is taken from the logged in user	</li>
	<li>	Notes are saved to a wrong contact if arrow buttons are used while typing a note	</li>
	<li>	Notes upgraded from GoldMine 6.7.70226 are incorrectly formatted	</li>
	<li>	Activities are duplicated in the activity list, when viewing data for another user with activities scheduled against curtained records	</li>
	<li>	Cannot activate a Group and a Filter at the same time	</li>
	<li>	Time Clock sorts by day of week instead of day of year 	</li>
	<li>	Sync with Outlook profile does not save mapping settings or respect the setting when deleted	</li>
	<li>	Information on the bottom status bar does not update properly when sorting by different criteria	</li>
	<li>	User toolbar settings documentation update	</li>
	<li>	When searching on Company is not Empty, nothing comes up	</li>
	<li>	Issue seen when editing the pending activity that is created by escalating a case	</li>
	<li>	Idle time logout is not configurable on Vista Machines	</li>
	<li>	Lookup.ini is not respected when new contacted is created via gmxmlapi	</li>
	<li>	Military time is displayed in opened e-mail message	</li>
	<li>	Command Line parameter -a does not allow user to enter GoldMine username	</li>
	<li>	MSSQLMaxBrowseRecs setting no longer affects Contact Search Center Searches and results in inconsistent query against CONTSUPP table	</li>
	<li>	When adding an influencer or team member to an opportunity, an unrelated contact record will open	</li>
	<li>	When creating New Company and Contact, doesn&#8217;t check for duplicates the first time	</li>
	<li>	When a group member is deleted from Groups tab in Filters and Groups screen, the screen refresh moves you back to the top of the list	</li>
	<li>	Default Sort for Opportunities is Account descending	</li>
	<li>	When adding cc to email, sporadically receive error Runtime Error! [path to \gmw.exe] R6025 - pure virtual function call	</li>
	<li>	If service case mask is changed to #### , pending activities disappear when edited	</li>
	<li>	When a detail is deleted, the screen refreshes and moves you back to the top of the list	</li>
	<li>	Unable to delete books with no name from Knowledge Base	</li>
	<li>	Import Wizard does not respect [Autoupdate] section of lookup.ini with option to do so selected	</li>
	<li>	Unchecking the group option in the History tab does not release the group	</li>
	<li>	Recently viewed items do not sync with the main opportunity manager window	</li>
	<li>	Sale amount is doubled when you complete a sale from the opportunity pending tab	</li>
	<li>	Linked Documents default sort is by date in ascending order	</li>
	<li>	User can&#8217;t scroll beyond a certain number of history records with filter applied	</li>
	<li>	When you type in a zip code for a newly created contact, the field doesn&#8217;t auto fill	</li>
	<li>	Renamed folder in knowledge base can become non-editable	</li>
	<li>	cannot re-enable menu item once deselected for non-master user	</li>
	<li>	&#8216;Adding Contact to an Existing Company&#8217; Help topic is incorrect	</li>
	<li>	ZIP code lookup activated after single character of ZIP code is entered for additional contact	</li>
	<li>	Only one e-mail address is moved when converting an additional contact to primary	</li>
	<li>	Fields to insert don&#8217;t show up in order by Contact 1 or Contact2	</li>
	<li>	Sync Service does not respect Sync Settings	</li>
	<li>	Classic menu causes GM toolbar to be reset to default every time the user logs in	</li>
	<li>	Alarms associated with activities that auto roll-over are not updated to match activity date	</li>
	<li>	Zoom / previous option does not allow you to scroll through all history records in history tab	</li>
	<li>	Scroll order for activated filter does not respect Optimize Sort Order field	</li>
	<li>	Date field corrupted in new record dialog	</li>
	<li>	Follow-up activity from email linked to case is not automatically linked to the case	</li>
	<li>	Address2 field not populated when retrieving linked document	</li>
	<li>	Cannot import VCard after Web Import is configured	</li>
	<li>	GoldMine Hangs and freezes when editing a project from the project management centre	</li>
	<li>	User without scheduling permissions can schedule activities from search center	</li>
	<li>	Address &#038; Phone Report with sort on Contact2 field run against a filter does not return all records meeting filter criteria	</li>
	<li>	Scrolling messages in Inbox also scrolls messages in Inbox sub-folders	</li>
	<li>	When selecting to print a report, Category field displays as Contact even if Report listing is for another Category	</li>
	<li>	Linking non-linked activities on completion window will not link activities although User has possibility to do so	</li>
	<li>	Clone Crystal Report does not create a copy of existing report.  Clone function behaves like New function	</li>
	<li>	Unable to install GM if there is more than one SQL instance on the system	</li>
	<li>	When deleting a resolution note in Cases, the note is removed from the UI, but still appears in the database with ~~Deleted, instead of removing the note completely	</li>
	<li>	Date format in contact list is different from contact record	</li>
	<li>	Outlook calendar records deleted with synchronization	</li>
	<li>	User can only look at 2 emails from the activity list before they are forced to close the window	</li>
	<li>	Closed amount is being assigned to opened opportunities - amount does not even match forecasted sale	</li>
	<li>	Outlook contact deletions do not sync 	</li>
	<li>	Error message when opening RDP file from links tab	</li>
	<li>	Linked Document Mover only supports a single path	</li>
	<li>	Outlook Sync does not respect New Record Ownership settings	</li>
	<li>	Automated process elapsed time trigger is ignored	</li>
	<li>	Cannot send a meeting request to multiple contacts	</li>
	<li>	Memory leak caused by Relationships tab 	</li>
	<li>	Search entered in box automatically searches by first name only	</li>
	<li>	Incorrect lookup lists displayed for Reference when completing activity	</li>
	<li>	Refresh issue:  The window title does not change to reflect that it is now searching by company	</li>
	<li>	E-mail sent from KB does not include attachment	</li>
	<li>	Cannot vertically scroll the Gantt chart	</li>
	<li>	Old GoldMine Setup File used in one-button installation	</li>
	<li>	On Edit menu, Copy, Cut and Paste are always grayed out	</li>
	<li>	Ability to add multiple contacts to relationship tree	</li>
	<li>	Phone number for Contact Info pasted into Pager Message is incorrect	</li>
	<li>	Option to send e-mail to user when alarm not acknowledged does not work 	</li>
	<li>	Task focus lost after editing task	</li>
	<li>	Unlinked e-mail shows in sent folder as linked e-mail	</li>
	<li>	The import wizard will not import data from a field larger than 50 characters	</li>
	<li>	Text search on primary fields, there are inconsistencies&#8230; unless the key word is the first word in the field search can fail.	</li>
	<li>	Can&#8217;t see opportunities or projects in Activity List when clicking on open activities	</li>
	<li>	Project task created for a user group to not show in the activity list	</li>
	<li>	Project Template tasks dates are not respected when creating a task for a new project created from a template	</li>
	<li>	Documentation does not include information regarding SQL protocols/enabled order for client workstations	</li>
	<li>	Automated Process does not trigger all events and sequential order of events is not respected	</li>
	<li>	Slow response during Relationship tab refresh	</li>
	<li>	Service reports do not appear in Print a report&#8230;&#8221; wizard&#8221;	</li>
	<li>	Auto populate of city and state not working when creating new record	</li>
	<li>	Default path is incorrectly displayed in the installer after browsing to a previous installation	</li>
	<li>	Amount field rounded incorrectly if it exceeds 8 characters when sale is completed	</li>
	<li>	Importing notes does not merge to the existing note	</li>
	<li>	Word Merge bottleneck in automated process execution	</li>
	<li>	Status drop-down list does not refresh when switching between Project and Opportunities	</li>
	<li>	Last Record button jumps only 500 records, and not to the last record as indicated	</li>
	<li>	&#8216;Refresh&#8217; button is always inactive in activity list	</li>
	<li>	Text formatting lost in notes after upgrade	</li>
	<li>	E-mail is linked to the wrong contact after an alarm pops up	</li>
	<li>	Contact Search Center settings ignored when creating a new case	</li>
	<li>	Case number identity seed is ignored	</li>
	<li>	User without merge permission can access merge &#038; edit in Document Management Center	</li>
	<li>	Impossible to schedule a sale to an additional contact	</li>
	<li>	Write button on toolbar provides access to Document Management Center when menu access is removed	</li>
	<li>	Edit Menu (Cut/Copy/Paste) inactive	</li>
	<li>	Administrator unable to control access to tabs	</li>
	<li>	(Copy/)Move functionality: when source and destination database don&#8217;t have the same structure the records in the source database are not deleted	</li>
	<li>	Details tab with over 500 records loses context menu options after scrolling to the end of the list	</li>
	<li>	Wrong activities displayed after activating rollup and switching contact record	</li>
	<li>	Sales Analysis Quota diff % calculation is unintuitive	</li>
	<li>	Window states are not restored when exiting via Switch User	</li>
	<li>	Remove Tracks is only available in Classic Menu	</li>
	<li>	E-mail bodies are truncated if the line length exceeds 998 characters, when sending via certain ISP&#8217;s	</li>
	<li>	Reply to all brings wrong sender&#8217;s and recipient information when several E-mail accounts are setup	</li>
	<li>	Digital Signature Verification Failure	</li>
	<li>	GMW.EXE application continues to run in windows Task Manager after closing GMPE	</li>
	<li>	INSERT errors on upgrade	</li>
	<li>	Activity List only loads first 500 activities, even after scrolling or sorting the list	</li>
	<li>	&#8216;%&#8217; and &#8216;?&#8217; as Wildcards do not work anymore in CSC	</li>
	<li>	The Outlook Sync profiles are not saving field mappings	</li>
	<li>	Month view calendar is not scrollable via keyboard arrows	</li>
	<li>	There is no option to select “All&#8221; users on the activity list	</li>
	<li>	Record Type field not populated correctly in new record for default record type	</li>
	<li>	Unable to scroll past 2000 records with active filter based on contact2 field	</li>
	<li>	User without menu access to Tools > Options is able to customize tabs displayed in contact record	</li>
	<li>	GoldMine does not apply more than one signature.txt file	</li>
	<li>	GoldMine receives multiple copies of e-mail with checked &#8217;skip read&#8217; option	</li>
	<li>	Online help file not upgraded correctly	</li>
	<li>	Completing unscheduled call pops incorrect F2 lookup list for Reference Field	</li>
	<li>	Literature Request - print labels for more then one contact at the same time	</li>
	<li>	Project Manager sorts projects in reverse alphabetical order by default	</li>
	<li>	Group by in Contact List does not display all data	</li>
	<li>	Daily Day-Timer (detailed) report displays incorrect dates if you span multiple days	</li>
	<li>	Selecting the &#8220;Go To&#8221; option for a public opportunity opens the Opportunity manager with display of current user&#8217;s opportunities	</li>
	<li>	Sender&#8217;s Full name truncated (in Header) in sent E-mails if recipient uses Outlook (2003)	</li>
	<li>	notes with *** in older version will lost their formatting after being upgraded to GMPE	</li>
	<li>	&#8220;Unable to initialize&#8221; message when syncing with Outllok 2007 on Vista	</li>
	<li>	Contact list does not display all contacts in a large database	</li>
	<li>	Contact Search Center report, when editing the fields get a &#038;SyParam1 value that is not documented.	</li>
	<li>	Phone Formatting affects phone1 searching	</li>
	<li>	Forwarding e-mails to a secondary contact from an open e-mail does not work, only wks from inbox	</li>
	<li>	E-mail address lost if address for additional contact is entered first	</li>
	<li>	Notes do not merge with target record	</li>
	<li>	Deleted notes are displayed in Reports	</li>
	<li>	New user setting needed to prohibit Notes deletion	</li>
	<li>	Case management report prints BJ instead of the Pound sign (£)	</li>
	<li>	Workstations are not seeing the alias for a new database	</li>
	<li>	Zip Code Validation Does Not Work When Creating New Record	</li>
	<li>	Contact Search Center does not respect size from previous settings	</li>
	<li>	Sales Price and Amount field values do not store data properly	</li>
	<li>	Group count changes when scrolling through large activated group	</li>
	<li>	Noticeable delay between the message request and message display	</li>
	<li>	E-mail Center cannot display Russian text correctly	</li>
	<li>	Greek Chars are destroyed while import from dbf-file	</li>
	<li>	Grid headers are wrong when using Thai Language	</li>
	<li>	Unable to schedule forecasted sales with negative amount values	</li>
	<li>	Cannot disable Status Bar unless Classic View is used	</li>
	<li>	Single click on e-mail folder changes icon but does not open the folder	</li>
	<li>	Users cannot edit case history items	</li>
	<li>	OPMGR Notes are merged when upgrading from an older GoldMine version, for the first note entered in Premium Edition	</li>
	<li>	Cannot display Code on History tab	</li>
	<li>	New Contact is automatically related to current contact	</li>
	<li>	Tabs are not saved when exiting via switch user	</li>
	<li>	Typing a lookup value does not jump to that value in the lookup list	</li>
	<li>	Unable to Dupe Check on e-mail address when creating a new Company	</li>
	<li>	Literature Fulfillment creates invalid History entry	</li>
	<li>	In an F2 lookup window right-click to output to clipboard only outputs first item	</li>
	<li>	Adding an influencer to an opportunity changes contact record to wrong contact	</li>
	<li>	Non-master user cannot perform analysis from the activity list	</li>
	<li>	Printing out Project Notes field onto a report displays the HTML code	</li>
	<li>	Org. Chart folders limited to 68 on root level.	</li>
	<li>	Screen Designer toolbar positioned almost off screen when initially viewed	</li>
	<li>	Undo Change to Contact menu option doesn&#8217;t work	</li>
	<li>	Enable administrators to set permissions around contact record notes	</li>
	<li>	Unable to insert additional contact in the To field when creating a new e-mail message	</li>
	<li>	User&#8217;s full name is missing an apostrophe when saving a note under the notes tab	</li>
	<li>	There is no simple search across different contact data structures	</li>
	<li>	Field security appears to be dependent on record type	</li>
	<li>	Sort Order in Details incorrect	</li>
	<li>	Lookup-window for new time setting on snooze alarm is behind the alarm window	</li>
	<li>	F2 lookups on Info tab of a detail record are not updated on detail type change	</li>
	<li>	Special characters from Notes are destroyed in Summary view of Contact window (Next Activity: / Last Activity: / Last Note:)	</li>
	<li>	Activity List displays events as occurring 12/30/1899	</li>
	<li>	Incremental search does not stay consistent with user input in large contact database	</li>
	<li>	E-mail Is Empty search returns no records	</li>
	<li>	User defined date field in upper half of contact window is not populated correctly on new records	</li>
	<li>	Sort order not retained on tab grids	</li>
	<li>	Delete button remains active after &#8220;delete contact&#8221; menu item is disabled	</li>
	<li>	When using the linked document mover with the option to “Update database references only”, the CONTSUPP.U_ADDRESS1 field is unchanged	</li>
	<li>	Required fields not active during new contact entry	</li>
	<li>	Line breaks stripped out of Notes after upgrade	</li>
	<li>	Local dbalias.ini ignored	</li>
	<li>	Sort Order field not updated	</li>
	<li>	Cannot change contact record notes	</li>
	<li>	SITEID is upgraded incorrectly	</li>
	<li>	Optimized sort order does not work for filters	</li>
	<li>	Case IDs can be duplicated via sync	</li>
	<li>	Column width in calendar Task List is not retained	</li>
	<li>	Obsolete reference to Backup/Restore in online help	</li>
	<li>	Menu item points to obsolete ZIP code import that was replaced by QuickStart Wizard	</li>
	<li>	There are no commands in the toolbar customization window	</li>
	<li>	Obscured attachment listing	</li>
	<li>	Adding Users to Peg Board makes other calendar tabs show multiple users	</li>
	<li>	There is no option to automatically display contact records in the same order as shown in the contact search center	</li>
	<li>	Distribution list refresh when member added	</li>
	<li>	Service Center filter setting is not retained between sessions	</li>
	<li>	Record Type Rules are no longer recognized where Field value based rules exceed 32 rules	</li>
	<li>	The left and the right arrows do not increment by 500 contact records	</li>
	<li>	Text search is limited to primary contact fields	</li>
	<li>	Unable to add Macro to custom toolbar	</li>
	<li>	Column widths and position are not retained after exiting	</li>
	<li>	Intermittent DB connectivity problems	</li>
	<li>	Sort by column in opportunity manager list does not work on all columns	</li>
	<li>	Taskbar customization uses old menu structure	</li>
	<li>	Empty &#8217;service reports&#8217; folder shown in report center	</li>
	<li>	Key field labels are overriden by local labels when creating a new record type	</li>
	<li>	Field inserted in Microsoft Word does not respect decimal place limitation set in GoldMine 	</li>
	<li>	User security template access not applied to e-mail templates	</li>
	<li>	Pipeline Report does not respect opportunity filter	</li>
	<li>	There is no option to automatically display contact records in the same order as shown in the contact search center	</li>
	<li>	Taskbar customization uses old menu structure	</li>
	<li>	&#8220;Log Changes in History&#8221; setting is not respected when change is made to a NULL or empty field	</li>
	<li>	Incorrect calendar dates for Canadian holidays such as Victoria Day	</li>
	<li>	Obsolete reference to Misc tab in documentation	</li>
	<li>	&#8220;Log changes in the history&#8221; in Global replace wizard does not work when a filter is used	</li>
	<li>	Projects and Opportunities lose notes and pending activities after converting	</li>
	<li>	Nothing returned with &#038;AdditionalContact macro	</li>
	<li>	Weekend days included even when applying &#8220;Skip Weekends&#8221; option for scheduled activity in Automated Process	</li>
	<li>	Document path is truncated in Project Management Details/Links tab	</li>
	<li>	SQL Query Wizard on Pending or History items produces query of Activity Code with an extra space	</li>
	<li>	GoldMine does not send a SMTP QUIT command as expected by some SMTP servers	</li>
	<li>	Unable to type Polish characters with using [Right ALT] +[letter]	</li>
	<li>	Additional contacts cannot be added to distribution lists through Contact Search Center	</li>
	<li>	Print button in Forecasted Sales Analysis opens report behind the active dialog box	</li>
	<li>	Behavior of F9 key is not changed by Opview setting in [username].ini	</li>
	<li>	Office link does not prompt to save when closing document	</li>
	<li>	Task Reference is displayed in date column in Tasks folder of Activity List when selecting Today	</li>
	<li>	Mail Merge creates undefined History record	</li>
	<li>	Forecasted Sale linked to an opportunity shows name of Opportunity in Product field	</li>
	<li>	ITS 27954: &#038;FullAddress macro in Word merge doesn’t print ZIP and State values if the City field is blank	</li>
	<li>	ITS 34524: Attachment not opened in e-mail sent from Entourage	</li>
	<li>	ITS 23620: Cannot select font type or size from drop downs when highlighting multiple fonts	</li>
	<li>	ITS 34975: When importing a .csv file with only one record, or choosing to ignore the first record when only two records exist, no records are imported	</li>
	</ol>
	<p>Feel free to contact Doug directly for more information about this patch or GoldMine Premium Edition, in general!</p>
	</blockquote>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=111</wfw:commentRSS>
	</item>
		<item>
		<title>GoldMine Corporate Edition 7.5.1 Hotfix 1 Available</title>
		<link>http://www.castellcomputers.com/?p=112</link>
		<comments>http://www.castellcomputers.com/?p=112#comments</comments>
		<pubDate>Tue, 21 Jul 2009 18:10:01 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=112</guid>
		<description><![CDATA[GoldMine Corporate Edition 7.5.1.81009 Now Available!]]></description>
			<content:encoded><![CDATA[	<p>Frontrange have released a hotfix to patch a number of annoying problems with the original 7.5.1 version of GoldMine Corporate Edition.  Here&#8217;s the word from them:</p>
	<blockquote><p>Several months ago we announced that GMCE 7.5.1 Hotfix 1 (build 81009) was being made available in a controlled release. Since then, a large number of customers have deployed it successfully, and we are now formally making it generally available to make sure that future GMCE deployments will use this build, rather than the original 7.5.1.80827 build.</p>
	<p>The build is already on the partner NFR site. We expect it to be on Net Update and CD this week.<br />
<strong><br />
WHAT&#8217;S FIXED IN GOLDMINE CORPORATE EDITION 7.5.1 HOTFIX 1</strong></p>
	<ol>
	<li>Memory leak on server running GoldSync</li>
	<li>GoldSync does not reprocess a transfer set if it fails to retrieve it the first time</li>
	<li>Incorrect lookup lists displayed for Reference when completing activity</li>
	<li>Upgraded emails linked from Outlook display HTML code</li>
	<li>Contact information not displayed in Outlook for synchronized calendar item</li>
	<li>When the remote syncs, it continuously attempts to start another connection until sync session ends</li>
</ol>
	</blockquote>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=112</wfw:commentRSS>
	</item>
		<item>
		<title>MSSQL Server 2008 Service Pack 1</title>
		<link>http://www.castellcomputers.com/?p=113</link>
		<comments>http://www.castellcomputers.com/?p=113#comments</comments>
		<pubDate>Tue, 21 Jul 2009 17:32:47 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
		<guid>http://www.castellcomputers.com/?p=113</guid>
		<description><![CDATA[MSSQL Server Service Pack 1 is Available]]></description>
			<content:encoded><![CDATA[	<p><strong>MSSQL Server 2008 Workgroup Edition</strong> is shipping with GoldMine 8.5 purchases (including upgrades!) now.  With it, one would expect to be able to run the typical database maintenance and backup routines on their SQL server.  Unfortunately, there was a bit of a problem with that and some users were caught unaware.  Fortunately, the programmers at Microsoft have corrected the problem with service pack 1.  If you run SQL 2008 Workgroup Edition, it&#8217;s not an option &#8212; get it!</p>
	<p>From Microsoft Knowledgebase article <a href="http://support.microsoft.com/kb/968382/" target="_new" onclick="javascript:urchinTracker ('/outbound/article/support.microsoft.com');">968382</a>:</p>
	<blockquote><p><strong>PROBLEM</strong><br />
Consider the following scenario. You install the release version of one of the following editions:</p>
	<p>    * Microsoft SQL Server 2008 Standard x86 or x64 edition<br />
    * Microsoft SQL Server 2008 Developer x86, x64, or IA-64 edition<br />
    * Microsoft SQL Server 2008 Enterprise x86, x64, or IA-64 edition<br />
    * Microsoft SQL Server 2008 Workgroup x86 or x64 edition<br />
    * Microsoft SQL Server 2008 Web x86 or x64 edition </p>
	<p>You install the SQL Server 2008 Client Tools. However, you do not have SQL Server 2008 Integration Services installed. When you create and then execute a maintenance plan, you receive the following error message in the job history:<br />
The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services. The package execution failed. The step failed.</p>
	<p><strong>RESOLUTION</strong><br />
Service pack information To resolve this problem, obtain the latest service pack<br />
Service pack information<br />
To resolve this problem, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:<br />
<a href="http://support.microsoft.com/kb/968382/" target="_new" onclick="javascript:urchinTracker ('/outbound/article/support.microsoft.com');">968382</a>  How to obtain the latest service pack for SQL Server 2008</p>
	<p><em>Cumulative update information</em><br />
The fix for this issue was first released in Cumulative Update 3. For more information about how to obtain this cumulative update package for SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:<br />
<a href="http://support.microsoft.com/kb/960484/" target="_new" onclick="javascript:urchinTracker ('/outbound/article/support.microsoft.com');">960484</a> Cumulative update package 3 for SQL Server 2008<br />
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:<br />
<a href="http://support.microsoft.com/kb/956909/" target="_new" onclick="javascript:urchinTracker ('/outbound/article/support.microsoft.com');">956909</a>  The SQL Server 2008 builds that were released after SQL Server 2008 was released</p></blockquote>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=113</wfw:commentRSS>
	</item>
		<item>
		<title>How to Get Uncle Sam to Buy You More GoldMine</title>
		<link>http://www.castellcomputers.com/?p=60</link>
		<comments>http://www.castellcomputers.com/?p=60#comments</comments>
		<pubDate>Wed, 03 Dec 2008 19:10:54 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Opinion</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject>
		<guid>http://www.castellcomputers.com/?p=60</guid>
		<description><![CDATA[IRS Section 179 tax deduction allows you to put computer software into service in December and still qualify for a full year's deduction - it's a substantial savings! - ]]></description>
			<content:encoded><![CDATA[	<p>IRS Section 179 tax deduction allows you to put computer software into service in December and still qualify for a full year&#8217;s deduction - it&#8217;s a substantial savings - check with your accountant for details.</p>
	<p>More details can be found in this publication on <a href="http://www.irs.gov/publications/p946/ch02.html#d0e2087" target="_new" rel="nofollow" onclick="javascript:urchinTracker ('/outbound/article/www.irs.gov');">the IRS Web Site</a>.</p>
	<p>If this makes you want to buy some software, feel free to contact me!  <img src='http://www.castellcomputers.com/wp-images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' />
</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=60</wfw:commentRSS>
	</item>
		<item>
		<title>FrontRange Needs Your Input</title>
		<link>http://www.castellcomputers.com/?p=109</link>
		<comments>http://www.castellcomputers.com/?p=109#comments</comments>
		<pubDate>Wed, 08 Oct 2008 21:20:05 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=109</guid>
		<description><![CDATA[FrontRange, the makers of GoldMine, are working on the next patch for GoldMine.  If you have any suggestions or would like to report a bug, they need to hear it NOW!]]></description>
			<content:encoded><![CDATA[	<p>FrontRange, the makers of GoldMine, are (perpetually) working on the next patch for GoldMine.  If you have any suggestions or would like to post a bug, they need to hear it NOW!</p>
	<p>Much like people who don&#8217;t vote in an election, you don&#8217;t get to complain about the outcome if you didn&#8217;t do anything to try to make it go your way &#8212; and who doesn&#8217;t like to complain?</p>
	<p>So, that one little thing that&#8217;s annoyed you for ten years and caused you to have to click two extra times every time you do that one thing&#8230;  REPORT IT!</p>
	<p>To submit a <strong>bug report</strong> directly to FrontRange, go <a href="http://support.frontrange.com/maintenancesupport/submitbug.asp" target="_new" rel="nofollow" onclick="javascript:urchinTracker ('/outbound/article/support.frontrange.com');">HERE</a>.</p>
	<p>To submit a <strong>suggestion </strong>directly to FrontRange, go <a href="http://support.frontrange.com/freesupport/submitenhancement.asp" target="_new" rel="nofollow" onclick="javascript:urchinTracker ('/outbound/article/support.frontrange.com');">HERE</a>.</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=109</wfw:commentRSS>
	</item>
		<item>
		<title>Show Contact Name in Activity Tabs</title>
		<link>http://www.castellcomputers.com/?p=108</link>
		<comments>http://www.castellcomputers.com/?p=108#comments</comments>
		<pubDate>Fri, 03 Oct 2008 17:23:44 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=108</guid>
		<description><![CDATA[GoldMine Premium Edition's packed with great new features and options.  One hidden gem is the ability to show the contact name in the Pending and History tab.  ]]></description>
			<content:encoded><![CDATA[	<p>GoldMine Premium Edition&#8217;s packed with great new features and options.  One hidden gem is the ability to show the contact name in the Pending and History tabs.</p>
	<p>If you&#8217;ve ever fumbled around trying to find that one e-mail in from that one person at one of your company&#8217;s best clients, you know that the history tab can sometimes be a big haystack to search.  Sure, you can filter the activity column to show only e-mail&#8217;s in, but that still doesn&#8217;t whittle it down enough to find that one from Joe a few weeks ago.  If only there was a contact name column in the history tab so you could filter or sort by it&#8230;</p>
	<p>Your wish is GoldMine Premium Edition&#8217;s command!</p>
	<p>It&#8217;s a simple matter of setting the option to show that contact column.  To do so, go to <strong>Tools|Options</strong> and then to the <strong>Record </strong>tab and check the option, <strong>Show contact name on activity tabs</strong> (see below).</p>
	<p><img src="http://www.castellcomputers.com/images/record_options_activity_con.png" alt="record options" /></p>
	<p>Looks like you&#8217;ll have to stop telling the boss you can&#8217;t find that e-mail and get back to work, eh?  <img src='http://www.castellcomputers.com/wp-images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' /> </p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=108</wfw:commentRSS>
	</item>
		<item>
		<title>Linking in LinkedIn via GM+View</title>
		<link>http://www.castellcomputers.com/?p=107</link>
		<comments>http://www.castellcomputers.com/?p=107#comments</comments>
		<pubDate>Wed, 24 Sep 2008 21:46:20 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=107</guid>
		<description><![CDATA[LinkedIn, popular business networking site, is a great place to reconnect with ex colleagues and customers and do some networking, but how can you use it with GoldMine?]]></description>
			<content:encoded><![CDATA[	<p><a href="http://www.linkedin.com/" target="_new" rel="nofollow" onclick="javascript:urchinTracker ('/outbound/article/www.linkedin.com');">LinkedIn</a>, popular business networking site, is a great place to reconnect with ex colleagues and customers and do some networking, but how can you use it with GoldMine?<br />
<br />
Download <a href="http://www.castellcomputers.com/files/linkedin.txt" >this .TXT file</a> and create a new GM+View with it.  This view will pass the current contact&#8217;s name and zip to the LinkedIn search.  It might not find a specific match, but it&#8217;ll usually get you pretty close (unless their name is John Smith!)<br />
<br />
For instructions on adding GM+Views to your GoldMine, refer to some of these previous posts:</p>
	<p><a href="http://www.castellcomputers.com/?p=5" >Enhancing GoldMine with Google-based GM+Views</a> <br />and<br /><a href ="http://www.castellcomputers.com/?p=39">Simple Document Management Enhancement for GoldMine</a><br />
<br />
While you&#8217;re at it, check out <a href="http://www.linkedin.com/in/dougcastell" target="_new" rel="nofollow" onclick="javascript:urchinTracker ('/outbound/article/www.linkedin.com');">my profile</a> and add me on LinkedIn if you&#8217;re so inclined!  <img src='http://www.castellcomputers.com/wp-images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' />
</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=107</wfw:commentRSS>
	</item>
		<item>
		<title>GoldMine Premium Edition Patch 8.0.3 Available</title>
		<link>http://www.castellcomputers.com/?p=104</link>
		<comments>http://www.castellcomputers.com/?p=104#comments</comments>
		<pubDate>Fri, 15 Aug 2008 21:25:58 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=104</guid>
		<description><![CDATA[GoldMine Premium Edition Patch 8.0.3 is now available!]]></description>
			<content:encoded><![CDATA[	<p>GoldMine Premium Edition sees it&#8217;s third patch, version 8.0.3 (aka 8.03.80716)</p>
	<p>This is the third patch since the initial release of GoldMine Premium Edition (8.0).  It brings with it a nice list of fixes and improvements that make GoldMine Premium Edition a compelling choice for 6.x users now living with a end-of-life&#8217;d product.</p>
	<p>Here&#8217;s the list of line item fixes (my favorites are in <strong>bold</strong>!) from the release notes included with this patch: </p>
	<ol>
	<li>	Hot key for Schedule a Follow-up does not check box in Complete Activity screen	</li>
	<li>	<strong>Open relationship tree causes performance issues when searching contacts</strong>	</li>
	<li>	AP Print Form prints for incorrect contact and contact record window defaults back to contact list	</li>
	<li>	QuickStart Wizard application error on zip code import	</li>
	<li>	When Syncing with Outlook, cal reference field data is duplicated	</li>
	<li>	Notes lost after clicking on recent contact during edit	</li>
	<li>	Automated Process Event Print Form prints form for incorrect contact and duplicates history	</li>
	<li>	<strong>Manual linking of e-mails in Outlook is slow</strong>	</li>
	<li>	Elapsed Time trigger ignored in Automated Process	</li>
	<li>	Edit of sequential order of Automated Process Events causes failure of AP to process correctly	</li>
	<li>	Branch To Event dropdown is empty during creation process if AP track contains Preemptive Event	</li>
	<li>	Industry Template installer aborts	</li>
	<li>	<strong>E-mail address not found if Linkacct = NULL in CONTSUPP</strong>	</li>
	<li>	DDE buffer too small for heavy note use	</li>
	<li>	Memory Leak Caused By Relationships Tab 	</li>
	<li>	Automated Process does not trigger all events and sequential order of events is not respected	</li>
	<li>	When adding an influencer to opportunity, contact record jumps to a random contact	</li>
	<li>	Last contact viewed is not maintained between sessions if it was not in first 500 by sort order	</li>
	<li>	<strong>Recorded Macros cannot be run from the command line</strong>	</li>
	<li>	<strong>Cannot drag and drop activities to month calendar controls</strong>	</li>
	<li>	Danish characters are no longer visible after upgrading to GMPE	</li>
	<li>	New Company &#038; Contact copies Key1 field from current contact	</li>
	<li>	Snooze options hidden	</li>
	<li>	Cannot open all links if there are over 1000	</li>
	<li>	<strong>Process Monitor window intrusive</strong>	</li>
	<li>	Incorrect sort order for Outlook messages	</li>
	</ol>
	<p>Feel free to contact Doug directly for more information about this patch or GoldMine Premium Edition, in general!</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=104</wfw:commentRSS>
	</item>
		<item>
		<title>GMPE Special Pricing Offer Announced</title>
		<link>http://www.castellcomputers.com/?p=103</link>
		<comments>http://www.castellcomputers.com/?p=103#comments</comments>
		<pubDate>Mon, 21 Jul 2008 17:22:44 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=103</guid>
		<description><![CDATA[FrontRange Solutions, the makers of GoldMine, announced, today, special pricing for upgrades from GoldMine Standard Edition or Corporate Edition -- if the order is placed before July 31st, 2008]]></description>
			<content:encoded><![CDATA[	<p>FrontRange Solutions, the makers of GoldMine, announced, today, special pricing for upgrades from GoldMine Standard Edition or Corporate Edition &#8212; if the order is placed before July 31st, 2008:</p>
	<blockquote><p>Due popular demand by customers wanting to upgrade to GoldMine PE we are extending a special  Special Summer offer:</p>
	<p>To facilitate upgrades and to expand the benefits of GoldMine into marketing, customer service and other departments we have special pricing valid through July 31, 2008.</p>
	<p>    * GoldMine Standard Edition can upgrade and expand to GoldMine Premium Edition for $ 474.00<br />
    * GoldMine Corporate Edition can upgrade and expand to GoldMine Premium Edition for $ 374.00
</p></blockquote>
	<p>To take advantage of this special pricing and/or to learn more about GoldMine Premium Edition, feel free to give Castell Computers&#8217; world headquarters a call at (310)601-4738  <img src='http://www.castellcomputers.com/wp-images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' /> </p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=103</wfw:commentRSS>
	</item>
		<item>
		<title>GoldMine Corporate Edition 7.5 Available</title>
		<link>http://www.castellcomputers.com/?p=102</link>
		<comments>http://www.castellcomputers.com/?p=102#comments</comments>
		<pubDate>Mon, 07 Jul 2008 19:46:58 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=102</guid>
		<description><![CDATA[GoldMine 7 has long suffered from a bad reputation as a bug-riddled version of GoldMine.  With the 7.0.4 patch, last year, this reputation was somewhat redeemed.  With the 7.5 patch, FrontRange aims to banish all the bug demons of the 7.x product and make good on all those Corporate Edition clients' maintenance dollars. ]]></description>
			<content:encoded><![CDATA[	<p>GoldMine 7 has long suffered from a bad reputation as a bug-riddled version of GoldMine.  With the 7.0.4 patch, last year, this reputation was somewhat redeemed.  With the 7.5 patch, FrontRange aims to banish all the bug demons of the 7.x product and make good on all those Corporate Edition clients&#8217; maintenance dollars. </p>
	<p>The 7.5 patch has been a long time coming.  It was originally released in January of &#8216;08 after much testing.  Apparently, not enough testing was done as it was pulled from release within about a week with assurances that it would be back soon.</p>
	<p>Fast-forward seven months later and <em>soon </em>has finally come.  GoldMine 7.50.80618 has been released.  It brings with it a lot of fixes and enhancements that have long been sought after by GoldMine users.  Many of these enhancements are not even available in GoldMine 8 Premium Edition.  This is not a surprise, however, as many late-in-life patches to prior versions of GoldMine brought lots of stability as well as some fledgling features that hadn&#8217;t quite made it into the newer versions of the product.  One has only to look back at GoldMine 3.2, 5.7 and 6.7 to see similar patterns.</p>
	<p>If you&#8217;re still on GoldMine 6 or GoldMine 7 Corporate Edition and are current on your maintenance with Frontrange, you can have GoldMine 7.5 for free.  CD&#8217;s can be ordered from Frontrange with the update.  If you are a <em>new </em>customer, you can&#8217;t have GoldMine 7.5 as <em>new </em>customers receive GoldMine 8 Premium Edition.</p>
	<p>There are a lot of highlights in the release notes, but what really stands out, to me, are the many improvements to the e-mail capabilities.  SSL, IMAP, TLS, NTLM, CRAM-MD5 &#8212; all of these acronyms represent things the old GoldMine e-mail client was incapable of.  No more.</p>
	<p>I wonder if these things will make it into 8.0.3 or if we&#8217;ll have wait for 8.1 to enjoy them?  Regardless of when they make it, stability trumps an early release date any time.  Kudos to the GoldMine team for sticking to it and getting us a good 7.5 release.  Now, who wants to install it first?  <img src='http://www.castellcomputers.com/wp-images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' /> </p>
	<p>Without more rambling from me, I bring you, the 7.5 release notes:</p>
	<blockquote><p>
Support for Microsoft Office 2003 and 2007 enables integration with the latest versions of Microsoft Word, Excel, and Outlook.  Also, the Word and Excel links now are optional components of the main GoldMine installation, rather than being installed separately.</p>
	<p>Support for Windows Vista as an end-user operating system.</p>
	<p>Support for Microsoft SQL Server 2005 Service Pack 2 (SP2).</p>
	<p>Support for Windows Server 2003 R2, Service Pack 2 (SP2).</p>
	<p>Secure SSL connections now are supported in the E-mail Center.  To configure an SSL connection, go to Edit > Preferences > E-mail.</p>
	<p>The IMAP protocol now is supported in the E-mail Center, providing more security and better interoperability with other e-mail clients.  To configure an IMAP e-mail account, go to Edit > Preferences > E-mail.</p>
	<p>The E-mail Center now supports integrated Windows authentication using NTLM.  With this feature, e-mail access can be set up without entering or updating the password in GoldMine.  To configure this option, go to Edit > Preferences > E-Mail.</p>
	<p>E-mail Center performance can be configured with the following settings:  </p>
	<p>1.  (New) When messages are deleted in the E-mail Center, they are not immediately deleted from the server until the connection is closed.  This behavior provides the fastest performance but can cause deleted messages to reappear as duplicates in some scenarios.  If this problem appears, the following UserName.INI setting can be used:</p>
	<p>[Internet]<br />
PopImmediateDelete=1		(closes server connection after each message is deleted)</p>
	<p>The default value for this setting is 0, which keeps the connection open after deleting a message.</p>
	<p>2.  (New) GoldMine automatically sends periodic messages (“no-ops”) to the e-mail server to keep the connection open for fast response time.  By default these messages occur every 10 seconds.  Some e-mail servers require more frequent messages to maintain the connection.  To change the frequency of these messages, use the following UserName.INI setting:</p>
	<p>[Internet]<br />
PopNoopTimer=nnnn		(where nnnn is the number of seconds between messages)</p>
	<p>3.  GoldMine automatically disconnects from the e-mail server if it has no related activity for 10 minutes, by default.  This is useful, for example, when using both the Online and Auto-retrieve options with an e-mail server that permits only one connection.  To change the time delay before automatically disconnecting, use the following UserName.INI setting:</p>
	<p>[Internet]<br />
PopIdle= nnnn 			(where nnnn is the number of minutes until disconnect)</p>
	<p>Synchronization and database rehosting performance has been enhanced, especially when using the Firebird database.</p>
	<p>The 2 GB size limit has been removed for synchronization transfer sets and installation files for one-button synchronization.</p>
	<p>Concurrent GoldSync connections are queued to improve reliability.  As users connect to a GoldSync server, they automatically are placed in a queue, up to the number of users established in the Number of Connections screen within GoldSync configuration.  If simultaneous processing of concurrent connections is required instead of queuing, please contact your Solutions Partner or FrontRange Support Services for recommendations and instructions.</p>
	<p>An updated ZIP code database for the United States is available though the QuickStart Wizard.
</p></blockquote>
	<ol>
	<li>	Branch To Event dropdown is empty during creation process if AP track contains Preemptive Event	</li>
	<li>	Error when creating installation file for one-button synchronization using database with large MAILBOX table	</li>
	<li>	Out of memory error while installing file for one-button synchronization	</li>
	<li>	Automated process elapsed time trigger is ignored	</li>
	<li>	All groups displayed when selecting (public) while adding to a contact group from search center	</li>
	<li>	Sales script question numbers are corrupted when adding a number above 99	</li>
	<li>	Message encoding failed when using e-mail template with attachments	</li>
	<li>	TRIM expression evaluates as True if there is no data 	</li>
	<li>	Attachments are stored but not displayed on some e-mail messages	</li>
	<li>	Line breaks are removed when spell checker corrects first word in paragraph 	</li>
	<li>	Influencer will appear twice following sync if added at server and at remote	</li>
	<li>	Merge / Purge shows the wrong records when using prompt before merging	</li>
	<li>	Long history notes truncated on Contact Profile (Detailed) and History &#038; Pending Report	</li>
	<li>	New Contact Alert and New Contact AP not working in Web Import	</li>
	<li>	Error when inserting accented characters using XML API Writedetail call	</li>
	<li>	Incorrect ratio shown in Leads Analysis total line	</li>
	<li>	Forecast Quotas are wrong if more than 8 digits needed	</li>
	<li>	Linking e-mail to additional contact creates duplicate e-mail address and overwrites previous e-mail address	</li>
	<li>	Pending and e-mail are retrieved only if contact set open during sync 	</li>
	<li>	Crash when trying to print report with another minimized print window open	</li>
	<li>	Crash when clicking the Complete button without selecting an activity	</li>
	<li>	GoldSync service generates multiple messages in Windows Event Log	</li>
	<li>	Expressions in the calendar do not show Contact1 data if there is an unlinked calendar item present	</li>
	<li>	FILTERS field updates are added to TLog without field changes	</li>
	<li>	REPORT32 field updates are added to TLog without field changes	</li>
	<li>	Details tab not updated correctly after starting GoldSync processes	</li>
	<li>	Special characters not displayed correctly in e-mails from Lotus Notes 	</li>
	<li>	Days are not displayed in quota analysis date range	</li>
	<li>	Cancel operation does not work when a draft e-mail is open and user switches database	</li>
	<li>	Deleting contact deletes Mailbox and linked CAL/HIST record at remote	</li>
	<li>	E-mail message records retained after contact deletion do not sync	</li>
	<li>	E-mail address and E-mail merge code data issue with secondary contacts when duplicate e-mail addresses are enabled	</li>
	<li>	Send Request with to: option when scheduling an activity does not work	</li>
	<li>	Lookup.ini erroneously populates date field with today’s date	</li>
	<li>	Cannot add new detail on custom tab if detail name exceeds 20 characters	</li>
	<li>	Contact Search Center does not return all records for non-master user belonging to a user group with a single quote in the name	</li>
	<li>	Calendar Report does not print phone numbers for scheduled calls 	</li>
	<li>	Cannot scroll down through days in month control in day view	</li>
	<li>	dBASE expressions cannot be used to clear a date field	</li>
	<li>	Invalid SQL query causes loss of database connection	</li>
	<li>	Russian characters aren&#8217;t displayed after upgrade from GM 6.5	</li>
	<li>	Opportunities do not sync if GoldSync as service was configured using a contact set code other than the contact set code the remote is using	</li>
	<li>	Non-Master user is unable to delete multi-user scheduled activities if they do not have delete rights	</li>
	<li>	Contact Record Statistics shows inaccurate sales data	</li>
	<li>	Filters containing “not equal to&#8221; criteria do match null values	</li>
	<li>	Impossible to login to GM using Firebird and shortcut install	</li>
	<li>	Notes field will not accept an import of greater than 50 characters	</li>
	<li>	&#8216;Database Operation error&#8217; occurs while generating Graphical Analysis report	</li>
	<li>	Sort by Date on Details tab sorts by User Name	</li>
	<li>	Forced logout UI is unclear 	</li>
	<li>	GoldMine GPFs when user without Schedule menu access tries to schedule from the Contact Search Centre	</li>
	<li>	Crash during Global Replace on Notes using a filter	</li>
	<li>	Notes are not synchronizing	</li>
	<li>	Completed Calls SQL Query returns 0 results	</li>
	<li>	Global replace on a user-defined date field generates incorrect values	</li>
	<li>	E-mail merge performance degradation	</li>
	<li>	Importing notes with more than 75 characters gets truncated	</li>
	<li>	Cannot use phone number for duplicate checking in new record type	</li>
	<li>	When multiple linked activities are edited, the Updated time is not changed	</li>
	<li>	Contact -> Write -> Letter doesn’t create a history entry	</li>
	<li>	E-mail merging/queuing speed degradation compared to 6.7	</li>
	<li>	E-mail are not retrieved correctly unless Windows-1251 encoding was used	</li>
	<li>	Group based on History Items against all Users returns no records	</li>
	<li>	When running a crystal report from GoldMine the parameter values are ignored if run against the current contact record	</li>
	<li>	Merging visible records drops notes from the non-surviving record	</li>
	<li>	Field security not applied when users tab from field to field	</li>
	<li>	Export wizard does not use the sort order defined in filter	</li>
	<li>	Open Org Chart causes performance issues when searching contacts	</li>
	<li>	Opportunity Title over 33 characters is truncated after saving 	</li>
	<li>	Create Duplicate Record does not copy Web Site	</li>
	<li>	Clicking &#8220;Delegate to User(s)&#8221; causes characters to be deleted from the selected users list	</li>
	<li>	Account roll-up does not work for Opportunities and Projects	</li>
	<li>	Field mappings not saved in Outlook Sync profiles 	</li>
	<li>	Printer name of 53 characters generates error message about 59 character limit	</li>
	<li>	Euro sign in e-mail not recognized 	</li>
	<li>	Cannot update time on activity scheduled for multiple users and multiple contacts	</li>
	<li>	No Scheduling Conflict error when activity conflicts with recurring item	</li>
	<li>	E-mails for secondary contact not populating the To: field when selected	</li>
	<li>	Forced logout UI is unclear	</li>
	<li>	AP Update Field action uses wrong field	</li>
	<li>	Some applications can&#8217;t be started from Lookup.ini	</li>
	<li>	To-Do marked as Private can be opened by other users	</li>
	<li>	GoldSync process can be uninstalled before it has been stopped	</li>
	<li>	SQL query truncated	</li>
	<li>	Occasions are not showing up	</li>
	<li>	Undocked users in License Manager are not sorted by Username	</li>
	<li>	There is no way to restart GoldSync process	</li>
	<li>	Completing an e-mail from the Complete Menu can cause the “Cal record is missing or corrupt&#8221; error message	</li>
	<li>	No members are added when selecting All Users option in creating a group 	</li>
	<li>	GoldMine can be launched twice simultaneously	</li>
	<li>	Opportunity Wizard allows Start Date to exceed Close Date	</li>
	<li>	Run instruction breaks XML type WebImport	</li>
	<li>	Crystal Reports use wrong data source	</li>
	<li>	Retrieval of WebImport e-mail containing duplicate e-mail address hangs system	</li>
	<li>	Log Changes in History setting is not respected when change is made to a NULL or empty field	</li>
	<li>	Sync service ignores Send Filter when &#038;RecordType macro is used	</li>
	<li>	Report Sorts settings are ignored running Crystal report	</li>
	<li>	Runtime error accessing report sort properties	</li>
	<li>	Search by details in Build SQL Query does not work with long details	</li>
	<li>	Unnecessary TLogs remain in database, although corresponding source record already was removed 	</li>
	<li>	Scheduled activity time is incorrect when alarms are on by default	</li>
	<li>	Sales Scripts are corrupted after editing the question numbers	</li>
	<li>	Document is merged to the current GoldMine contact instead of the one specified in literature request	</li>
	<li>	AP set to 1000 days goes to incorrect date	</li>
	<li>	Unlinked e-mail that is linked when replying causes endless loop 	</li>
	<li>	Activities notes are duplicated under pending tab	</li>
	<li>	Digital signed e-mails not decoded 	</li>
	<li>	Queries on history built by Query builder, not returning correct data on unscheduled calls	</li>
	<li>	Cannot activate a Group and a Filter at the same time	</li>
	<li>	Performance issues during synchronization with Firebird demo db 	</li>
	<li>	Execute immediately ignored when added from another process	</li>
	<li>	Opportunity record not updated with sale date change	</li>
	<li>	Custom Field view unavailable until restart	</li>
	<li>	Customizations missing with One Button Sync install	</li>
	<li>	XML type WebImport record created with inserted note	</li>
	<li>	CREATEON/CREATEAT fields unpopulated with XML WebImport	</li>
	<li>	Screen Design mode retained between user sessions	</li>
	<li>	Leads analysis does not show any completed sales information	</li>
	<li>	Time and resource usage increase rehosting data to MSSQL	</li>
	<li>	Opportunity Manager custom Field are limited to 60 characters via the UI	</li>
	<li>	Impossible to save any word documents if template folder is indicated incorrectly in gm.ini	</li>
	<li>	The SQL query builder truncates the value to 20 characters	</li>
	<li>	The list of Reports of the Contact Report Category (in Print Report dialog box) is not visible	</li>
	<li>	When e-mail contains a period preceded and followed by a space, message is truncated	</li>
	<li>	Cannot rehost selected tables 	</li>
	<li>	Building a group based on scheduled activities does not add members	</li>
	<li>	History tab does not show the most recent history, if the display limit is active	</li>
	<li>	E-mail inaccessible after delete	</li>
	<li>	Queued doc deletions do not sync	</li>
	<li>	No warning for blank username in initial setup	</li>
	<li>	Plain text signature file loses carriage returns when using HTML e-mail	</li>
	<li>	InfoCenter export to RTF does not convert HTML tags	</li>
	<li>	Contacts with calendar activities from: option does not sync any data to Outlook from GoldMine	</li>
	<li>	Unable to open lead table error on Firebird database	</li>
	<li>	API: DB_QuickSeek function does not work in XML API	</li>
	<li>	API: DB_Search function does not work in XML API	</li>
	<li>	API: DB_Range function does not work	</li>
	<li>	Predial.ini strips area code from non-local number and breaks TAPI dial	</li>
	<li>	Forecasted sale for decimal amounts are not reflected in Sales Analysis	</li>
	<li>	Negative number corrupts formula to calculate Forecast (Potn) and Forecast Diff. amount and Forecast Diff. percentage	</li>
	<li>	Application error occurs when entering data into required fields using F2 lookup	</li>
	<li>	Industry template installer does not delete F2 Lookups	</li>
	<li>	API: Seek function always returns &#8216;2&#8242;	</li>
	<li>	API: ReadSchedulePrefs function does not work	</li>
	<li>	API: WriteCalendarPrefs does not update some parameters	</li>
	<li>	Subset of accessible records NOT returned with Search	</li>
	<li>	GM+View template updates do not synchronize if user’s calendar not included in transfer set	</li>
	<li>	One Button synchronization updates the currently open database	</li>
	<li>	Printing filtered records failed	</li>
	<li>	File NOT found error when selecting Maximizer Import	</li>
	<li>	Project and Opportunity non-forecast activities are not completed in wrap up	</li>
	<li>	Impossible to delete opportunity without deleting the related contact	</li>
	<li>	Incorrect calculation of resulted stats of opportunity after closing all its forecasts	</li>
	<li>	Extended sync times retrieving large transfer sets	</li>
	<li>	Key Field Label Name assignments in QuickStart Wizard do not stick	</li>
	<li>	Inactive alias displayed as blank lines	</li>
	<li>	Changing an alias name is losing DB connection info	</li>
	<li>	Word closes without prompt to save document	</li>
	<li>	Update wording in Database Alias Manager for new functionality	</li>
	<li>	Saving draft emails in Outlook prompts for a save location when the Word link is installed and Word is the default e-mail editor	</li>
	<li>	Closed tab is empty by default in Activity list	</li>
	<li>	Launching GM over network on Vista prompts security warning	</li>
	<li>	SQL login user properties do not work	</li>
	<li>	E-mails containing UTF-8 characters are not rendered correctly	</li>
	<li>	Sort order on the pending tab is incorrect	</li>
	<li>	Change of forecasted sale on the opportunity tab does not change corresponding sale on pending tab	</li>
	<li>	If a user has no e-mail templates in the Document Management center, Mailbox contents will display	</li>
	<li>	Import process leaves temporary tables	</li>
	<li>	E-mail record attached to wrong contact record	</li>
	<li>	E-mail record attached to wrong contact record	</li>
	<li>	DBF import aborts if Date fields are included	</li>
	<li>	Cannot export a SQL query from cal that has HTML notes	</li>
	<li>	APP Identifiers in document management center work wrong	</li>
	<li>	Groups not displayed correctly when adding contact to group in Members tab	</li>
	<li>	DBF import skips remaining records if there is no data in company, contact or row	</li>
	<li>	Sync ignores CONTHIST record change	</li>
	<li>	Cannot click into a user-defined field that is under a user-defined expression field in the fields tab	</li>
	<li>	HTML Signature file shows tags	</li>
	<li>	GM is incompatible with MSXML 6.0	</li>
	<li>	Reference unchanged with Contact Groups creation	</li>
	<li>	Error navigating to merged contact	</li>
	<li>	No Contact data with non-defined FILECODE	</li>
	<li>	Cannot delete custom opportunity fields after editing them	</li>
	<li>	Org charts only show titles for the first member that was added to the org chart	</li>
	<li>	Adding Attachments to InfoCenter Documents doesn&#8217;t work properly	</li>
	<li>	Customized field data not retrieved	</li>
	<li>	Retrieved custom fields show &#8216;n/a&#8217;	</li>
	<li>	Wrap-up information not displayed in Opportunity Manager	</li>
	<li>	“Reference contains” calendar publishing option doesn&#8217;t work	</li>
	<li>	“Skip read mail” option doesn’t work with Microsoft Exchange	</li>
	<li>	No indication of which Groups and Filters are activated and which are released	</li>
	<li>	GoldMine not recognized by Internet Explorer as default mail client	</li>
	<li>	Carriage returns are omitted when pasting text into e-mail message	</li>
	<li>	When an activity scheduled with a secondary contact is completed the name disappears from the completed activity on the calendar	</li>
	<li>	GoldMine&#8217;s ZIP files can only create a 2GB max size transfer set file	</li>
	<li>	Sync Contact associates Opportunity sale to added influencer	</li>
	<li>	GM+Browser does not open web page when enter key is pressed	</li>
	<li>	Lookup By preference not respected when creating e-mail	</li>
	<li>	Add paste functionality for entering serial numbers	</li>
	<li>	Copy/Move Records wizard does not transfer links created by e-mail attachments	</li>
	<li>	Clicking “X” button in InfoCenter does not prompt to save modified text	</li>
	<li>	Contact Search Center text box does not allow focus change from another window	</li>
	<li>	dBase import of records truncates e-mail and web fields	</li>
	<li>	Forced out idle time not obeyed	</li>
	<li>	Carriage returns are omitted when pasting text into activity notes	</li>
	<li>	Age of closed Opportunity is incorrect in Opportunity Mgr	</li>
	<li>	Cal record remains on remote after deletion	</li>
	<li>	Reports dialog doesn&#8217;t remember previous selection	</li>
	<li>	GoldSync Max Retries setting is not honored	</li>
	<li>	Scheduled resources are not included in transfer set when a send filter is used	</li>
	<li>	Queued e-mails are sent even if the option is unchecked	</li>
	<li>	Not all records returned in CSC based on MSSQLMaxBrowseRecs setting	</li>
	<li>	Site can get processed by 2 or more different connections	</li>
	<li>	Contact History Report with Notes with large history record only shows &#8216;Notes&#8217; information on first page	</li>
	<li>	Incorrect text on New Opportunity dialog	</li>
	<li>	Click on title bar of a background e-mail window causes it to maximize	</li>
	<li>	Incorrect Detail if the Lookup entry of the Detail custom tab is deleted	</li>
	<li>	Include a Text File option in HTML e-mail template strips carriage returns 	</li>
	<li>	Request a Return Receipt does not stay checked on an E-mail template	</li>
	<li>	Cursor focus stays in Subject line when replying to an e-mail	</li>
	<li>	Industry templates change key fields incorrectly	</li>
	<li>	Zoom should be an available local menu item in the Calendar Month view	</li>
	<li>	Propose new time by GM recipient is corrupted	</li>
	<li>	Importing a contact record disables existing alerts	</li>
	<li>	Recurring Activities do not activate Conflict message	</li>
	<li>	ZERO length field label and value is irretrievable	</li>
	<li>	Cannot import exactly one contact from an ASCII file	</li>
	<li>	Value in selected Update Field is not transferred to surviving record in merge/purge process	</li>
	<li>	Contact2 data in AP Run An Application action, not processed	</li>
	</ol>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=102</wfw:commentRSS>
	</item>
		<item>
		<title>GoldMine Premium Edition Patch 8.0.2 Available</title>
		<link>http://www.castellcomputers.com/?p=98</link>
		<comments>http://www.castellcomputers.com/?p=98#comments</comments>
		<pubDate>Thu, 13 Mar 2008 21:34:10 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=98</guid>
		<description><![CDATA[GoldMine Premium Edition Patch 8.0.2 is now available!]]></description>
			<content:encoded><![CDATA[	<p>GoldMine Premium Edition sees it&#8217;s second patch, version 8.0.2 (aka 8.02.80208)</p>
	<p>This is the second patch since the initial release of GoldMine Premium Edition (8.0).  It brings with it a long list of fixes and improvements that make GoldMine Premium Edition a compelling choice for 6.x users facing the impending non-supported status of their product by Frontrange on April 30th.</p>
	<p>Here&#8217;s the long list of line item fixes from the release notes included with this patch: </p>
	<ol>
	<li>TLogs have invalid SyncStamp values</li>
	<li>Recently Viewed list is not limited when using Firebird database</li>
	<li>Contact Record Statistics shows inaccurate sales data</li>
	<li>Delegate to User(s) causes characters to be deleted from the selected users list</li>
	<li>Telemarketing Scripts corrupted while editing</li>
	<li>Full Name with apostrophe incorrectly displayed in Notes tab</li>
	<li>Special chars in Notes vanish when upgrading from GMCE to GMPE</li>
	<li>MS SQL 2000 Spanish or German causes error in Case module </li>
	<li>Upgrade from dbase to GMPE failed due to fewer licenses</li>
	<li>lookup.ini erroneously populates date field</li>
	<li>Grouping cases by Due Date does not function correctly</li>
	<li>Drag and drop Attachments, no graphic shows until you add an attachment with attachment button</li>
	<li>Non-Master uses cannot convert additional contact to primary ones in Case Management but can on the contact record under the contacts tab</li>
	<li>Username.INI file expands on upgraded system with customized task bar</li>
	<li>dBASE expressions in the calendar do not show the Contact1 data if there is an unlinked calendar item present</li>
	<li>After upgrade from GMCE to GMPE, added toolbar icon does not remain</li>
	<li>Tab content scrolling causes contact records scrolling</li>
	<li>GoldMine automatically searches entire DB when a blank field is selected to launch the search centre</li>
	<li>Time Clock not populated</li>
	<li>Slow performance in refresh of Recently Viewed list in iGoldMine due to list length</li>
	<li>Toolbar customizations are not maintained after Switch User</li>
	<li>mouse wheel in notes (when reaching end of notes) it scrolls to another record</li>
	<li>Error appears when scheduling activity with Greek regional settings</li>
	<li>search center &#8212; columns that are part of the contact2 table, searching grinds to a halt</li>
	<li>With iGoldMine, tabs do not disappear when closed and titles do not get removed from the window drop down</li>
	<li>Schedule button on contact record intermittently works with large database</li>
	<li>New Record Layout must be manually refreshed when creating a new record</li>
	<li>Extended detail tab does not refresh when scrolling through records</li>
	<li>UI for label customization is broken in Opportunity Management</li>
	<li>Ability to change the number of recent items within user options</li>
	<li>GM crashes if you try to complete non-existent activity</li>
	<li>Changing menu format allows you access to disabled items</li>
	<li>Users not in alphabetical order in Activities User dropdown</li>
	<li>Text in the Notes tab overlap when HTML_CAL_NOTES=0 is set in the GM.ini</li>
	<li>Case mask configuration prevents pending/history from being linked to case</li>
	<li>Cannot schedule call when South African regional settings are used</li>
	<li>Adding high tab order to user-defined field in upper part of contact record (above tabs) causes field to disappear</li>
	<li>Unable to save email attachments in bulk</li>
	<li>Cannot disable Zip code validation for additional contacts </li>
	<li>GM hangs during recently viewed contact list refresh</li>
	<li>Scrolling through the end of GM+View tab causes contact record to scroll </li>
	<li>Adding a sort to an existing group populates member data incorrectly</li>
	<li>Data entry corrupted after switching record types</li>
	<li>Zoom shows incorrect record when filter is active</li>
	<li>Incorrect column headings in History tab when contact name is shown</li>
	<li>Category, Origin, and Offering cannot be added as columns for Service List</li>
	<li>Note in Case is saved when switching to another Windows application</li>
	<li>Complete Event dialog appears when using command button to Schedule Event</li>
	<li>Context menus not accessible via Application Key</li>
	<li>Case task does not appear on Pending tab of contact</li>
	<li>To-Do date appears as 12/30/1899 in Pending tab</li>
	<li>Case task does not appear in calendar</li>
	<li>Non-Master users cannot search on E-Mail address</li>
	<li>Case tasks are not displayed in Calendar</li>
	<li>GoldMine - Filters and Groups - Calls scheduled to a group of users are displaying on the same line of time</li>
	<li>Contact Search Center does not retain column widths</li>
	<li>New Message -> Email TO selection from additional contacts is ignored -> always primary contact selected</li>
	<li>Visual defects in highlighted calendar view tab</li>
	<li>Using scheduled e-mail local menu adds duplicated menu items</li>
	<li>&#8220;Empty Trash when closing E-mail Center&#8221; option ineffective</li>
	<li>Assign focus to first text field</li>
	<li>Missing option to Edit notes</li>
	<li>Non-master user doesn&#8217;t have access to some Leads options</li>
	<li>Toolbar changes are not retained when exiting via Switch User</li>
	<li>Activities become inactive in alert window</li>
	<li>Any GoldMine report pulling data from Notes Tab shows notes as html code</li>
	<li>E-mail window needs attachment bar with icons</li>
	</ol>
	<p>Feel free to contact Doug directly for more information about this patch or GoldMine Premium Edition, in general!</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=98</wfw:commentRSS>
	</item>
		<item>
		<title>Speed up GoldMine Premium Edition Searches</title>
		<link>http://www.castellcomputers.com/?p=97</link>
		<comments>http://www.castellcomputers.com/?p=97#comments</comments>
		<pubDate>Mon, 18 Feb 2008 19:43:22 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=97</guid>
		<description><![CDATA[Do you find the simple act of looking up a contact to be frustratingly slow in GoldMine Premium Edition?  Much better performance is just a settings tweak away!]]></description>
			<content:encoded><![CDATA[	<p>Do you find the simple act of looking up a contact to be frustratingly slow in GoldMine Premium Edition?  Take heart, much better performance is just a settings tweak away!</p>
	<p>When you double-click a field to lookup by contact name, for instance, GoldMine does a search of the database <b>where contact begins with nothing</b> immediately upon the search center opening.  For whatever reason, this returns the entire database.  Have you got more than a few thousand contacts in there?  Better go grab another cup of coffee &#8212; unless you can beat GoldMine to the punch and start typing a name before it &#8216;aligns&#8217; the lookup window with your search term.</p>
	<p>How do you solve this?  Wait for the forthcoming 8.0.2 patch from FrontRange and cross your fingers?  No.  You can correct this behavior with a little tuning of your search center&#8217;s <em>lookup alignment delay</em>.  The setting can be found here: <strong>Tools|Options|Lookup|Lookup alignment delay</strong>.</p>
	<p>I have mine set to 7 tenths of a second and I can usually get my hand from the mouse to the keyboard and type part of a name before that initial search hits &#8212; but I play a lot of video games.  Unless you also have the reflexes of a ninja-sniper, you might want to try 9 or 10 &#8212; maybe higher!  <img src='http://www.castellcomputers.com/wp-images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' /> </p>
	<p>Finding a good balance between minimizing the immediate blank search problem but still retaining that great drill-down responsiveness as you type the search term is somewhat of an art.  The setting&#8217;s optimal number can be different for everyone.</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=97</wfw:commentRSS>
	</item>
		<item>
		<title>Webinar: Keeping GoldMine&#8217;s data clean with MasterMine and MasterMine Updater</title>
		<link>http://www.castellcomputers.com/?p=96</link>
		<comments>http://www.castellcomputers.com/?p=96#comments</comments>
		<pubDate>Thu, 31 Jan 2008 05:42:19 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=96</guid>
		<description><![CDATA[Join me tomorrow afternoon (January 31st) at 1:30 PM PST as I sit in on a free one-hour online webinar that'll show you how a GoldMine add-on tool called MasterMine can help to beat the age-old problem that plagues so many CRM systems today...dirty data.]]></description>
			<content:encoded><![CDATA[	<p>Join me tomorrow afternoon (January 31st) at 1:30 PM PST as I sit in on a free one-hour online webinar that&#8217;ll show you how a GoldMine add-on tool called <a href="http://www.mastermine.net" target="_new" rel="nofollow" onclick="javascript:urchinTracker ('/outbound/article/www.mastermine.net');">MasterMine </a>can help to beat the age-old problem that plagues so many CRM systems today&#8230;dirty data.</p>
	<p>If your company is struggling with GoldMine&#8217;s data hygiene, you can&#8217;t afford to miss this session! </p>
	<p>Register <a href="https://www1.gotomeeting.com/register/727251685" target="_new" rel="nofollow" onclick="javascript:urchinTracker ('/outbound/article/www1.gotomeeting.com');">here</a>.</p>
	<p>Hope to see you there!</p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=96</wfw:commentRSS>
	</item>
		<item>
		<title>Tame the GMPE Recently Viewed Lists</title>
		<link>http://www.castellcomputers.com/?p=95</link>
		<comments>http://www.castellcomputers.com/?p=95#comments</comments>
		<pubDate>Sun, 06 Jan 2008 20:35:08 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=95</guid>
		<description><![CDATA[The Recently Viewed Items list is a great new feature of GoldMine Premium. . . but it's been known to cause a bit of a performance hit when the Recently Viewed lists get long.]]></description>
			<content:encoded><![CDATA[	<p>The Recently Viewed Items list is a great new feature of GoldMine Premium.  It&#8217;s a feature I have wanted for so long that I actually wrote something similar into my <a href="http://www.castellcomputers.com/?p=30" target="_new" >Search4GM tool</a> years ago.  GoldMine Premium Edition, however, takes the concept a step further.  It tracks the last fifty records you visited in other areas as well.  You can backtrack through contacts, campaigns, opportunities, service tickets, knowledgebase articles and more!</p>
	<p>It&#8217;s a handy feature, but it&#8217;s been known to cause a bit of a performance hit when the Recently Viewed lists get long.  There&#8217;s no way to tame this feature from within the GoldMine interface, but if you&#8217;ve got the MSSQL Management Studio (or the Express version of the same tool) you have all you need to get it done.</p>
	<p>Of course, all due caution should be observed before undertaking such steps as you could possibly corrupt your database or confuse your cat with this stuff.  Seriously, backup the database first (or ask whoever&#8217;s in charge of such things to do so)<br/></p>
	<p>1. Fire up Management Studio and expand down to the GoldMine database level.</p>
	<p>2. Hit the &#8216;New Query&#8217; button on the toolbar.</p>
	<p>3. Paste the following query (<b>with your upper-cased GoldMine username in there instead</b>) into the window on the right.</p>
	<p><code>update history set cnt=10 where userid='DOUG'</code></p>
	<p>4. Hit the &#8216;Execute&#8217; button.</p>
	<p>That&#8217;s it!  Head back to GoldMine and look up a contact not already on your recently viewed items list and go to it.  Stay there for a few seconds and you should see your list decrease down to only ten contacts.  The same behavior will occur as you visit other areas of GoldMine and refresh the Recently Viewed lists there.</p>
	<p>Worth mentioning is that you could choose any number.  I chose ten in my example to make it obvious.  In practice, I prefer to keep my Recently Viewed lists at twenty-five items.</p>
	<p>So the query for that would be:</p>
	<p><code>update history set cnt=25 where userid='DOUG'</code></p>
	<p>Heck, you might even want to make this change globally for all of your users at the same time.  To do so, use this query:</p>
	<p><code>update history set cnt=25</code></p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=95</wfw:commentRSS>
	</item>
		<item>
		<title>A Guided Tour of GoldMine Premium Edition 8.0</title>
		<link>http://www.castellcomputers.com/?p=93</link>
		<comments>http://www.castellcomputers.com/?p=93#comments</comments>
		<pubDate>Sat, 24 Nov 2007 23:59:04 +0000</pubDate>
		<dc:creator>Doug Castell</dc:creator>
		
	<dc:subject>General</dc:subject>
	<dc:subject>CRM</dc:subject>
	<dc:subject>GoldMine</dc:subject>
	<dc:subject>Technology</dc:subject>
	<dc:subject>Opinion</dc:subject>
	<dc:subject>SQL</dc:subject><dc:subject>CRM</dc:subject><dc:subject>demo</dc:subject><dc:subject>GMPE</dc:subject><dc:subject>goldmine</dc:subject><dc:subject>GoldMine 8</dc:subject><dc:subject>Opinion</dc:subject><dc:subject>SQL</dc:subject><dc:subject>Technology</dc:subject>
		<guid>http://www.castellcomputers.com/?p=93</guid>
		<description><![CDATA[A fine video tour of GoldMine Premium Edition 8.0 has been posted by a GoldMine consultant in the UK, Ian Wicks.]]></description>
			<content:encoded><![CDATA[	<p>A fine video tour of GoldMine Premium Edition 8.0 has been posted by a GoldMine consultant in the UK, Ian Wicks.</p>
	<p>Ian packs a lot of useful information into the video that should prove valuable to those considering upgrading &#8212; and even those who already have!</p>
	<p>Check it out <a href="http://www.iwicks.com/GoldMine%20Premium%20Edition.html" target="_new" rel="nofollow" onclick="javascript:urchinTracker ('/outbound/article/www.iwicks.com');">here on Ian&#8217;s site</a>.  &#8212; scroll down to the bottom for the link to the video (WMV format.)</p>
	<p>Of course, always remember that Castell Computers not only services Goldmine but sells it too!  So, if you decide to BUY GoldMine Premium Edition 8.0, feel free to thank Ian for his fine video, but go ahead and place your order with <b>me!</b>  <img src='http://www.castellcomputers.com/wp-images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' />  </p>
]]></content:encoded>
			<wfw:commentRSS>http://www.castellcomputers.com/?feed=rss2&amp;p=93</wfw:commentRSS>
	</item>
	</channel>
</rss>
