GoldMine Premium Edition 9.0 has been released.

This is the first major version upgrade to the GoldMine Premium Edition line.

Now in it’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.

From the Release notes included with 9.0.0.102:

WHAT’S NEW IN GOLDMINE PREMIUM EDITION 9.0

Operating System Compatibility
Windows 7 is now supported, both in 32-bit and 64-bit versions.
Windows Server 2008 R2 is now supported.

Dashboards
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.

Outlook Integration
Outlook integration includes several major enhancements in this release.

• 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.
• E-mails can be linked to contacts, opportunities, projects, and cases from Outlook.
• 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.
• Centralized administration for Outlook synchronization enables administrators to set synchronization settings and schedules for GoldMine users.
• Support for recurring activities when synchronizing with Outlook
• 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.
• 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.
• 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.
• Improved usability in Outlook when re-linking an e-mail message to a different contact
• A new navigation pane in Outlook displays clickable links to recently viewed items in GoldMine, to make it easier to switch between applications.
• 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.

Administration
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.

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.

New options for password policy are included. Administrators can set the following policies at Tools > Configure > System Settings > Password Policy:
• Minimum password length
• Block accounts after three invalid login attempts
• New password cannot repeat any previous password, up to a specified number of previous passwords

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.

WHAT’S ENHANCED IN GOLDMINE PREMIUM EDITION 9.0

Search
The options shown in the “Search By” 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.

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.

The Search List selection in the Contact List is now retained between sessions, so your preferred method of searching is kept automatically.

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.

Administration
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

GoldMine now automatically repairs corrupted e-mail records, rather than displaying a “Cal record for this e-mail is missing” message as in previous versions.

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.
• To delete TLog records (default): ClearTLogByDelFilter =1
• To retain TLog records: ClearTLogByDelFilter=0

Calendar
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.

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.

The Preview Pane in the Activity List now includes a hyperlink to navigate to the contact record related to the selected activity.

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 username.ini file.
• To open the activity (default): EditWhenDblClick=1
• To open the contact record: EditWhenDblClick=0

Customer Service
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.

Case Tasks now have a lookup list available to make task names more consistent and easier to enter.

Marketing Campaigns
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.

WHAT’S FIXED IN GOLDMINE PREMIUM EDITION 9.0

1. Selecting different filters on the Filters tab may cause erroneous filter name to be displayed
2. When all opportunities are shown in the opportunity manager, the pipeline chart only shows opportunities owned by a single user
3. Cannot set GoldMine as default e-mail client on Windows 7
4. GoldMine Address Book not available for selection after installation due to buffer overflow
5. From: address is incorrect in a redirected e-mail
6. “Look-up a replacement value in lookup.ini” is grayed out for Update Field action in Automated Process options
7. When select 5 hours in graphical calendar, the scheduled activity defaults to 5 minutes
8. Lookup list for Code field is different when creating a Project from when editing a Project
9. Application error when changing to non-default Status value while closing lost Opportunity
10. Opening the case management module is slow when you have a lot of cases in the database
11. Link to opportunity or project is broken when sending an e-mail message
12. E-mail created from Opportunity/Project Manager Influencer/Contacts tab has empty Regarding field
13. When editing multiple extended details in succession GoldMine will edit the last detail and not the current one highlighted
14. Performance issue when browsing through records after selecting first record from Contact Search Center
15. Regarding: field in e-mail window shows items sorted by creation date, not alphabetically
16. ‘Font increase’ and ‘Font decrease’ buttons work only after the font is manually changed using ‘Font’ button
17. Incorrect results in Contact Search Center if no Contact2 column is shown when applying a power search filter with Contact2 fields
18. Resolved Date for cases does not synchronize back to server if case was created on remote system and previously synchronized to server
19. Cannot add a contact with empty Company field to a case
20. Error when opening e-mail from sender with apostrophe in e-mail address
21. When performing a two-way sync with Outlook, some calendar items become unlinked from contacts in GoldMine
22. Upgraded opportunities not displayed when selecting a user group in the Manager dropdown
23. The drop-down list for Manager in the opportunity detail view does not include user groups
24. User and Date are not populated in ‘Assigned Cases by User’ report
25. Create Unicode Database option is enabled during upgrade but has no effect
26. Copy current record takes wrong current record information when auto-retrieval in background is active
27. When a new user logs in for the first time, Case tab names are reset to default settings
28. the f2 lookup for product in a new opportunity shows incorrectly if the product field has cross-field validation in the forecasted sale dialog
29. E-mail address for additional contact gets deleted from database when record is opened by user associated with recid ending in a space
30. Reference column is too narrow in task list on calendar
31. Preview pane in Opportunity History tab does not display e-mails
32. Activities occurring on the same date in Case History are displayed in incorrect order after sorting by date
33. “Auto name assignment” setting for attachments in GoldMine is not applied when forwarding e-mail in Outlook
34. Incorrect labels shown in preview pane for completed Case Task
35. GMAPI call MenuCommand produces “Access Denied” status
36. Opportunity Forecast field does not refresh when adding sales line items
37. Number of units and price are not visible in Opportunity detail view after closing Opportunity
38. Extended detail tabs do not sort in date order correctly
39. When adding a Competitor to an Opportunity, the Select button adds the first Competitor from the lookup list
40. Unlinked phone message does not save the Contact name entered
41. F2 lookup for Product field varies, depending on where the field is accessed
42. Switching from Fields tab to Summary tab causes incorrect editable fields to appear
43. There is no vertical scroll bar for Tasks in Opportunities or Projects
44. Users without master rights cannot see cases associated to curtained contact records owned by a group of which user is member
45. Cannot link messages to additional contacts in Outlook
46. EditWhenDblClick setting produces inconsistent results when double-clicking on an activity
47. Font is set to Times New Roman 3 while composing new e-mail from HTML template
48. ‘Remember lookup by’ option does not retain ‘contact (primary and additional)’ selection after closing contact search center
49. When E-mail Center is opened, keyboard focus is on the folder tree rather than the message list
50. Changes made to tabs of master users do not remain static
51. User column in History contains wrong value when overriding required field entry
52. ‘Send Outlook Message’ defaults always to Plain Text format if a default template exists in GoldMine
53. Changes made to maximized Case Description field do not save
54. E-mail fields [subject, date, linked to, from] occasionally disappearing when opening e-mails linked from Outlook
55. Only one instance of a recurring GoldMine appointment syncs into Outlook
56. Time Clock sorts dates numerically, not chronologically
57. Contact Search Center does not display more than two decimal places for a numeric field
58. Main Dictionary Language does not have a default value
59. Only one case is included in service report when run for current contact only
60. Ctrl + C does not copy highlighted text on Pending or History preview pane
61. Incorrect results in contact search center with Power Search using filters
62. Cannot use tab key to select field displayed off screen in Fields tab
63. Last Attempt is only updated by an unsuccessful call or message, not any other activity
64. Revoked menu items are still visible for GoldMine user
65. revoking ALL rights and almost all menus from a User still allows User to change / create Relationships and set access options
66. Inconsistent retention of Show field between Activity List sessions
67. Notes field from extended details are not displayed on reports
68. GoldMine macro in e-mail subject line pulls data from active contact instead of merged contact if filter/group is selected before template
69. When replying to an e-mail with spell checking disabled, double-clicking the Send button causes application error
70. Non-Master users see non-functional menu items for features that are only available to Master users
71. Required Fields setting does not alert always
72. Incorrect sort on Date column for Extended Details
73. Merged document has different format for Phone1 and FAX fields
74. When replying to plain text emails, HTML formatting is set if using original text in reply
75. Tempdb is not used when running reports, so users require more rights than needed in previous versions
76. When replying with original message, the whole original message is not included if it contains “<< >>”
77. When entering F2 lookup, // is required when creating non-displayed descriptive info but list shows the descriptive info in parentheses.
78. Clicking header to sort Activated and Previewed filter in Contact Search Center releases filter but doesn’t change tab text
79. Selecting Relate to when creating a New Record will not add an relationship tree to existing record if one does not already exist
80. E-mail fields [subject, date, linked to] intermittently disappear when scrolling through inbox
81. Using an e-mail template to reply doesn’t allow quoting original message with ‘>>’ symbol
82. User preference for ‘Show numerics aligned to the right’ does not stick for non-master users
83. calendar displays closed amount of a forecasted sale on all completed activities
84. E-mail message body is lost after closing error message regarding digital certificate
85. when creating a opportunity after editing one the opportunity always defaults to the first if you edited
86. Completion of a Literature request is based on the Assigned To field, not on who completes the literature request
87. Relationship tab does not refresh properly when expanding a section
88. Import from Outlook does not bring Notes over correctly
89. 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
90. Delete key does not work when trying to remove attachment from outgoing e-mail
91. Reports Center does not display preview of report if HTML_CAL_NOTES=0 is set
92. Cannot copy/paste e-mail headers
93. When scrolling between cases, the notes from the last case are displayed
94. User name is incorrect on the History tab in a Case when the user name starts with a “K”
95. Contact record focus changes after filing message with Sync Contact enabled
96. Activity List displays wrong entries after automatically releasing an active contact filter
97. 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
98. HTML_CAL_NOTES=0 setting causes pending and completed activity notes to suppress blank lines
99. When editing a History record you cannot click the New button to create a new opportunity
100. Add ClearTLogByDelFilter setting to optimize sync performance with deletion filter
101. When pasting text, an extra carriage return is added to the e-mail body
102. Cannot drag and drop files from Windows Explorer to Details/Links tab of Opportunity
103. When using a rich-text e-mail as a default reply template, the font always defaults to Times New Roman
104. GoldMine installer does not alert user that Windows 2000 is incompatible
105. Address macros that include City, State, ZIP have an extra comma
106. Expanded details labels are incorrect when selecting the Setup or Info tab for the detail
107. After closing e-mail message tab, focus shifts to the E-mail Center folder tree and not the e-mail message list
108. 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
109. Relationship tab does not refresh automatically after adding a new record to a company.
110. Some e-mails with embedded images are not linked from Outlook
111. Days are shown as bold in calendar when containing activities that are removed from display
112. Contacts under Company are not sorted alphabetically in Contact Search Center
113. Schedule Follow-up does not carry over time and duration when completing activity via Pending tab or Activity List
114. Opportunity creation with Wizard should be consistent with creation without Wizard related to Product field.
115. Column order from ‘Column Selection’ dialog is not respected by Contact List grid
116. Context-dependent lookup setting is not retained if lookup is used in several areas of GoldMine
117. ‘Assertion failed’ error creating transfer set with serialized sync disabled
118. List Existing Data option does not apply to all screens
119. Deleting an activity is slow when using Activity List with Sync Contact option
120. ADO errors recorded during sync processing
121. When completing activities, user can bypass Force Valid Input setting by canceling the entry and clicking on a different field
122. “Daily – DayTimer (detailed)” Fixed page layout creates duplicate entries on the report
123. Copy current record option does not recognized blank edits
124. Activating a Relationship tree at root only activates section containing current contact, unless all sections have been expanded
125. After upgrade some e-mail addresses do not appear next to hyperlink on contact record view
126. Incorrect times posted for activities falling after time-change
127. Error sending read receipt message in response to message created in Outlook
128. Relationship tree couldn’t be found if it was created for contact with empty Company field
129. Inbox tree is collapsed when Deleted folder is selected
130. Clicking on a date in My Calendar pane may navigate to wrong dates on Weekly view after the 28th of the month
131. User must reselect e-mail address when sending message to additional contact from the Influencers tab
132. Field label length is not respected when limited in layout tab of field properties
133. Merge tagged records does not keep first record tagged if subsequent tagged records are above the first record in the contact search center
134. Log Away feature does not support passwords over 11 characters
135. When selecting Users’ Security in GoldSync site group, some override options are unavailable
136. Improper spacing before Country when applying &FullAddress macro
137. Adding contacts to a Relationships tab with an activated filter does not add all records in the filter
138. Last field populates with data from current record when creating New Record with Copy current record option and no Contact name entered
139. 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
140. Status number of contacts when sorting a group exceeds the total number of contacts in the group
141. Deleting system fields from Wide View can interfere with search functions
142. PHP file from WebImport script generator is programmed incorrectly
143. Cannot refresh results in Contact Search Center
144. Ctrl + A to select All in the mail folder no longer works
145. Users who cannot schedule a forecast sale can still create a sale against an opportunity
146. Request a return receipt option is not respected when applied in a default template
147. Inbound e-mail shows wrong activity type when viewed in Case History tab
148. Notes duplicated with sync after upgrade
149. Preference to set alarms by default is not respected when reassigning or escalating cases
150. User is prompted three times when using Word document with FILLIN prompt
151. GoldMine not listed as available mail program for mailto protocol on Vista
152. Detail header records in the CONTSUPP table (rectype = ‘H’) have some blank or null field values after moving record to new database
153. .docx preview is not displayed in lower right pane of Document Management Center
154. Output To: >> Word function fails when using a localized version of Word
155. Crystal Reports ODBC data source limited to SQL Server type, not SQL Native Client
156. Completing an activity for one user while logged in as a different user displays the name of the original GoldMine user
157. Process monitor logs appear under the GoldSync site logs in the GoldSync Admin Center
158. <<cursor>> field is lost after editing existing document template
159. Ability to select a group or filter of contacts to add to an existing campaign
160. Cannot create an email rule that applies to case escalation messages
161. custom details field are being truncated
162. Notify via E-mail option does not support external e-mail clients such as smartphones
163. Relationship Tree folders are limited to 68 on root level
164. Peg Board does not show current data
165. Date field does not function correctly when using new default Record Type
166. Cannot drag and drop sections of Relationship Tree
167. Peg Board column width is not adjustable
168. Web Site is not copied when using Copy Current Record option
169. User notifications for scheduled activities are not delivered to external e-mail clients
170. Output To Printer Option is grayed out in Activity List for Non-Master users.
171. When editing an existing document in the Document Management Center, carriage returns are double spaced
172. Nothing returned with &AdditionalContact macro
173. Incorrect name displayed on Opportunity related to an Additional Contact

DATABASE SCHEMA CHANGES IN GOLDMINE PREMIUM EDITION 9.0

 

New database tables

 

CUSTVIEW(dashboard)

Column	Type	Allow nulls	Description
NAME	Varchar(100)	No	Dashboard’s name
CATEGORY	Varchar(100)	No	Dashboard’s category
USERID	Varchar(8)	No	Who has access (user or group name)
CREATED_BY	Varchar(8)	No	User who created the dashboard
CREATED	Datetime	No	When created
MODIFIED_BY	Varchar(8)	No	User who modified the dashboard
MODIFIED	Datetime	No	When modified
DEVELOPED	Smallint	No	Who developed: 1- FrontRange, 2 – Others
METAINFO	text	Yes	Meta information
recid	Varchar(15)	No	Unique ID

 

CUSTDATASOURCE (dashboard data source)

Column	Type	Allow nulls	Description
NAME	Varchar(100)	No	Data source name
CATEGORY_ID	Varchar(15)	No	Category id
USERID	Varchar(8)	No	Used for sorting
CREATED_BY	Varchar(8)	No	Who created
CREATED	Datetime	No	When created
MODIFIED_BY	Varchar(8)	No	Who modified
MODIFIED	Datetime	No	When modified
DEVELOPED	Smallint	No	Who developed: 1- FrontRange, 2 – Others
RECTYPE	Varchar(1)	No	C – category, D – data source
METAINFO	text	Yes	Meta information
recid	Varchar(15)	No	Unique ID

 

CUSTRELATIONS (which dashboard uses which data sources)

Column	Type	Allow nulls	Description
VIEW_ID	Varchar(15)	No	Dashboard’s id
DS_ID	Varchar(15)	No	Data source’s id
CONTROL_ID	Varchar(15)	No	Dashboard part’s id
recid	Varchar(15)	No	Unique ID

 

REPORTTEMP
(used for creating reports)

Column	Type	Allow nulls	Description
REC	Varchar(15)	No	Record id
EXPR	Varchar(256)	No	Expression
USERID	Varchar(8)	No	Who is printing the report

CALDEF (recurrence pattern for an activity)

Column	Type	Allow nulls	Description
RECTYPE	Smallint	No	1 = recurrence series pattern 2 = modified exception “pattern”
STARTDATE	Datetime	Yes
STARTTIME	Varchar(5)	Yes
ENDDATE	Datetime	Yes
ENDTIME	Varchar(5)	Yes
DURATION	Smallint	Yes
ENDNOCCUR	Smallint	Yes	The number of occurrences after which the recurrence ends. If specified, the value of ENDDATE is ignored. Null for exception pattern record.
RECUR_TYPE	Smallint	Yes	1 = hourly 2 = daily 3 = weekly 4 = monthly 5 = yearly   Null for exception pattern record.
INTERVAL	Smallint	Yes	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. Null for exception pattern record.
SKIPNONWORK	Smallint	Yes	0 = no skip 1 = skip weekend/non-work hours Null for weekly recurrence. Null for exception pattern record.
REPEATBY	Smallint	Yes	1 = by specific day 2 = by day of the week Null for hourly, daily recurrence. Null for exception pattern record.
ONDAY	Smallint	Yes	For monthly and yearly recurrence, represents: a specific day of the month if Flags = 1; Nth day of the week if Flags = 2. Null for hourly, daily, weekly recurrence. Null for exception pattern record.
ONDOW	Smallint	Yes	For weekly recurrence, represents the day(s) of week when the activity occurs. E.g. Sunday and Tuesday = 20 + 22 = 5. For monthly and yearly recurrence, represents an Nth day of the week if Flags = 2. Null otherwise. Null for exception pattern record.
ONMONTH	Smallint	Yes	For yearly recurrence, represents a month of the year (for both Flags = 1 and Flags = 2). Null for the other types of recurrence. Null for exception pattern record.
USERS	Text	Yes	List of user items separated by a delimiter; a user item consists of a userid.
RESOURCES	Text	Yes	List of resources separated by a delimiter.
CONTACTS	Text	Yes	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.
EXCEPTIONS	Text	Yes	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: 1 = modified 2 = deleted 3 = completed Null for exception pattern record.
COMPEXC	Text	Yes	Data on partially-completed activity occurences
PRIMARYUSER	Varchar(8)	Yes	User assigned to the activity; has full security rights over the activity.
IS_INFINITE	Smallint	Yes	0 = recurrence has end date, or no recurrence; 1 = recurrence is infinite Null for exception pattern record.
LAST_ROLL_OCCUR	Datetime	Yes	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. Null for exception pattern record.
ROLL_DATE	Datetime	Yes	For infinite recurrence, date when rolling of recurrence should occur. Null for exception pattern record.
CREATED_BY	Varchar(8)	No	User who created the activity
CREATED_ON	Datetime	No	Activity creation date
CREATED_AT	Varchar(5)	No	Activity creation time
MODIFIED_BY	Varchar(8)	No	User who modified the activity
MODIFIED_ON	Datetime	No	Activity modification date
MODIFIED_AT	Varchar(5)	No	Activity modification time
ORIG_DATA	Text	Yes	Some original information (color, rectype, ref, private, alarm flag, linked to)
ORIG_NOTES	Text	Yes	Original notes
ORIG_DATE	Datetime	Yes	Original date
ORIG_TIME	Varchar(5)	No	Original time
LINKRECID	Varchar(15)	No	Mail id
ATTENDEES_EX	Text	Yes	List of attendees separated by a delimiter
CALRECTYPE	Varchar(1)	Yes	Type of calendar activity
ORGANIZER_EX	Varchar(100)	Yes	Real organizer’s name if it is not a user
GLOBALID	Varchar(200)	Yes	Global Appointment ID from Outlook
BLOCKEDBY	Varchar(8)	Yes	For internal use in synchronization process
BLOCKEDON	Datetime	Yes	For internal use in synchronization process
BLOCKEDAT	Varchar(5)	Yes	For internal use in synchronization process
recid	Varchar(15)	No	Record’s id

 

New columns in existing tables

 

CAL(calendar activities)

Column	Type	Allow nulls	Description
CALDEF_ID	Varchar(15)	No
ORIG_DATE	DATETIME	Yes
ORIG_TIME	Varchar(5)	No
IS_EXCEPTION	Smallint	Yes
CALDEFEX_ID	Varchar(15)	No
FLAGS	Int	Yes
ATTENDEES_EX	Varchar(100)	Yes

 

CONTHIST(contact history)

Column	Type	Allow nulls	Description
COMPLETEDID	Varchar(15)	No	Used for synchronizing completed activities

 

USERS

Column	Type	Allow nulls	Description
EMC_ACC_EMAILS	Text	Yes	List of all user’s e-mails

 

Feel free to contact Doug directly for more information about this patch, upgrade pricing or GoldMine Premium Edition, in general!