Live chat by Boldchat

CALL TODAY: 845-221-3800
  View upcoming training & events

 

 

"Great tool, great service. Business is booming... we made the right decision with GoldMine and First Direct."

Chris Onan
Sales Manager
RCS Enterprises

Store Front Account Login View Shopping Basket Checkout

Home >> CRM Software >> GoldMine Software >> GoldMine Premium Edition

GoldMine Premium Edition 9.0
                                                                          
Release Notes

 
Quick links
spacer spacer

Quick links

 

Updated May 21, 2010

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

ID #

Issue Description

120111

Selecting different filters on the Filters tab may cause erroneous filter name to be displayed

117221

When all opportunities are shown in the opportunity manager, the pipeline chart only shows opportunities owned by a single user

114357

Cannot set GoldMine as default e-mail client on Windows 7

114133

GoldMine Address Book not available for selection after installation due to buffer overflow

113759

From: address is incorrect in a redirected e-mail

113683

"Look-up a replacement value in lookup.ini" is grayed out for Update Field action in Automated Process options

113653

When select 5 hours in graphical calendar, the scheduled activity defaults to 5 minutes

113568

Lookup list for Code field is different when creating a Project from when editing a Project

113476

Application error when changing to non-default Status value while closing lost Opportunity

113457

Opening the case management module is slow when you have a lot of cases in the database

112858

Link to opportunity or project is broken when sending an e-mail message

112855

E-mail created from Opportunity/Project Manager Influencer/Contacts tab has empty Regarding field

112851

When editing multiple extended details in succession GoldMine will edit the last detail and not the current one highlighted

112792

Performance issue when browsing through records after selecting first record from Contact Search Center

112135

Regarding: field in e-mail window shows items sorted by creation date, not alphabetically

111974

'Font increase' and 'Font decrease' buttons work only after the font is manually changed using 'Font' button

111846

Incorrect results in Contact Search Center if no Contact2 column is shown when applying a power search filter with Contact2 fields

110090

Resolved Date for cases does not synchronize back to server if case was created on remote system and previously synchronized to server

110085

Cannot add a contact with empty Company field to a case

109921

Error when opening e-mail from sender with apostrophe in e-mail address

109341

When performing a two-way sync with Outlook, some calendar items become unlinked from contacts in GoldMine

109030

Upgraded opportunities not displayed when selecting a user group in the Manager dropdown

109027

The drop-down list for Manager in the opportunity detail view does not include user groups

108594

User and Date are not populated in 'Assigned Cases by User' report

108270

Create Unicode Database option is enabled during upgrade but has no effect

108023

Copy current record takes wrong current record information when auto-retrieval in background is active

107943

When a new user logs in for the first time, Case tab names are reset to default settings

107638

the f2 lookup for product in a new opportunity shows incorrectly if the product field has cross-field validation in the forecasted sale dialog

107133

E-mail address for additional contact gets deleted from database when record is opened by user associated with recid ending in a space

107116

Reference column is too narrow in task list on calendar

107021

Preview pane in Opportunity History tab does not display e-mails

106872

Activities occurring on the same date in Case History are displayed in incorrect order after sorting by date

106611

"Auto name assignment" setting for attachments in GoldMine is not applied when forwarding e-mail in Outlook

106564

Incorrect labels shown in preview pane for completed Case Task

106529

GMAPI call MenuCommand produces “Access Denied” status

106472

Opportunity Forecast field does not refresh when adding sales line items

106426

Number of units and price are not visible in Opportunity detail view after closing Opportunity

106295

Extended detail tabs do not sort in date order correctly

106112

When adding a Competitor to an Opportunity, the Select button adds the first Competitor from the lookup list

105380

Unlinked phone message does not save the Contact name entered

105317

F2 lookup for Product field varies, depending on where the field is accessed

105310

Switching from Fields tab to Summary tab causes incorrect editable fields to appear

105253

There is no vertical scroll bar for Tasks in Opportunities or Projects

105235

Users without master rights cannot see cases associated to curtained contact records owned by a group of which user is member

104975

Cannot link messages to additional contacts in Outlook

104879

EditWhenDblClick setting produces inconsistent results when double-clicking on an activity

104782

Font is set to Times New Roman 3 while composing new e-mail from HTML template

104757

'Remember lookup by' option does not retain 'contact (primary and additional)' selection after closing contact search center

104734

When E-mail Center is opened, keyboard focus is on the folder tree rather than the message list

104688

Changes made to tabs of master users do not remain static

104672

User column in History contains wrong value when overriding required field entry

104655

'Send Outlook Message' defaults always to Plain Text format if a default template exists in GoldMine

104635

Changes made to maximized Case Description field do not save

104550

E-mail fields [subject, date, linked to, from] occasionally disappearing when opening e-mails linked from Outlook

104192

Only one instance of a recurring GoldMine appointment syncs into Outlook

104191

Time Clock sorts dates numerically, not chronologically

104177

Contact Search Center does not display more than two decimal places for a numeric field

104080

Main Dictionary Language does not have a default value

103837

Only one case is included in service report when run for current contact only

103818

Ctrl + C does not copy highlighted text on Pending or History preview pane

103808

Incorrect results in contact search center with Power Search using filters

103729

Cannot use tab key to select field displayed off screen in Fields tab

103727

Last Attempt is only updated by an unsuccessful call or message, not any other activity

103702

Revoked menu items are still visible for GoldMine user

103674

revoking ALL rights and almost all menus from a User still allows User to change / create Relationships and set access options

103638

Inconsistent retention of Show field between Activity List sessions

103608

Notes field from extended details are not displayed on reports

103418

GoldMine macro in e-mail subject line pulls data from active contact instead of merged contact if filter/group is selected before template

103192

When replying to an e-mail with spell checking disabled, double-clicking the Send button causes application error

103040

Non-Master users see non-functional menu items for features that are only available to Master users

102971

Required Fields setting does not alert always

102797

Incorrect sort on Date column for Extended Details

102790

Merged document has different format for Phone1 and FAX fields

102751

When replying to plain text emails, HTML formatting is set if using original text in reply

102643

Tempdb is not used when running reports, so users require more rights than needed in previous versions

102609

When replying with original message, the whole original message is not included if it contains "<< >>"

102581

When entering F2 lookup, // is required when creating non-displayed descriptive info but list shows the descriptive info in parentheses.

102566

Clicking header to sort Activated and Previewed filter in Contact Search Center releases filter but doesn't change tab text

102539

Selecting Relate to when creating a New Record will not add an relationship tree to existing record if one does not already exist

102477

E-mail fields [subject, date, linked to] intermittently disappear when scrolling through inbox

102474

Using an e-mail template to reply doesn't allow quoting original message with '>>' symbol

102412

User preference for 'Show numerics aligned to the right' does not stick for non-master users

102410

calendar displays closed amount of a forecasted sale on all completed activities

102373

E-mail message body is lost after closing error message regarding digital certificate

102290

when creating a opportunity after editing one the opportunity always defaults to the first if you edited

102277

Completion of a Literature request is based on the Assigned To field, not on who completes the literature request

102213

Relationship tab does not refresh properly when expanding a section

102032

Import from Outlook does not bring Notes over correctly

102020

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

102017

Delete key does not work when trying to remove attachment from outgoing e-mail

102009

Reports Center does not display preview of report if HTML_CAL_NOTES=0 is set

102001

Cannot copy/paste e-mail headers

101909

When scrolling between cases, the notes from the last case are displayed

101906

User name is incorrect on the History tab in a Case when the user name starts with a "K"

101846

Contact record focus changes after filing message with Sync Contact enabled

101713

Activity List displays wrong entries after automatically releasing an active contact filter

101704

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

101686

HTML_CAL_NOTES=0 setting causes pending and completed activity notes to suppress blank lines

101632

When editing a History record you cannot click the New button to create a new opportunity

101613

Add ClearTLogByDelFilter setting to optimize sync performance with deletion filter

101592

When pasting text, an extra carriage return is added to the e-mail body

101567

Cannot drag and drop files from Windows Explorer to Details/Links tab of Opportunity

101564

When using a rich-text e-mail as a default reply template, the font always defaults to Times New Roman

101482

GoldMine installer does not alert user that Windows 2000 is incompatible

101381

Address macros that include City, State, ZIP have an extra comma

101372

Expanded details labels are incorrect when selecting the Setup or Info tab for the detail

101287

After closing e-mail message tab, focus shifts to the E-mail Center folder tree and not the e-mail message list

101257

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

101225

Relationship tab does not refresh automatically after adding a new record to a company.

101213

Some e-mails with embedded images are not linked from Outlook

101212

Days are shown as bold in calendar when containing activities that are removed from display

101208

Contacts under Company are not sorted alphabetically in Contact Search Center

101137

Schedule Follow-up does not carry over time and duration when completing activity via Pending tab or Activity List

100928

Opportunity creation with Wizard should be consistent with creation without Wizard related to Product field.

100859

Column order from 'Column Selection' dialog is not respected by Contact List grid

100679

Context-dependent lookup setting is not retained if lookup is used in several areas of GoldMine

100587

'Assertion failed' error creating transfer set with serialized sync disabled

100400

List Existing Data option does not apply to all screens

100346

Deleting an activity is slow when using Activity List with Sync Contact option

100236

ADO errors recorded during sync processing

100024

When completing activities, user can bypass Force Valid Input setting by canceling the entry and clicking on a different field

100003

"Daily - DayTimer (detailed)" Fixed page layout creates duplicate entries on the report

99855

Copy current record option does not recognized blank edits

99717

Activating a Relationship tree at root only activates section containing current contact, unless all sections have been expanded

99665

After upgrade some e-mail addresses do not appear next to hyperlink on contact record view

99597

Incorrect times posted for activities falling after time-change

99390

Error sending read receipt message in response to message created in Outlook

99193

Relationship tree couldn't be found if it was created for contact with empty Company field

98821

Inbox tree is collapsed when Deleted folder is selected

97691

Clicking on a date in My Calendar pane may navigate to wrong dates on Weekly view after the 28th of the month

97652

User must reselect e-mail address when sending message to additional contact from the Influencers tab

97031

Field label length is not respected when limited in layout tab of field properties

96949

Merge tagged records does not keep first record tagged if subsequent tagged records are above the first record in the contact search center

96930

Log Away feature does not support passwords over 11 characters

96602

When selecting Users' Security in GoldSync site group, some override options are unavailable

96438

Improper spacing before Country when applying &FullAddress macro

96406

Adding contacts to a Relationships tab with an activated filter does not add all records in the filter

96149

Last field populates with data from current record when creating New Record with Copy current record option and no Contact name entered

96139

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

96100

Status number of contacts when sorting a group exceeds the total number of contacts in the group

96032

Deleting system fields from Wide View can interfere with search functions

95952

PHP file from WebImport script generator is programmed incorrectly

95785

Cannot refresh results in Contact Search Center

95747

Ctrl + A to select All in the mail folder no longer works

95692

Users who cannot schedule a forecast sale can still create a sale against an opportunity

95595

Request a return receipt option is not respected when applied in a default template

95076

Inbound e-mail shows wrong activity type when viewed in Case History tab

95050

Notes duplicated with sync after upgrade

94565

Preference to set alarms by default is not respected when reassigning or escalating cases

94003

User is prompted three times when using Word document with FILLIN prompt

93992

GoldMine not listed as available mail program for mailto protocol on Vista

92886

Detail header records in the CONTSUPP table (rectype = ‘H’) have some blank or null field values after moving record to new database

83612

.docx preview is not displayed in lower right pane of Document Management Center

83595

Output To: >> Word function fails when using a localized version of Word

82882

Crystal Reports ODBC data source limited to SQL Server type, not SQL Native Client

77164

Completing an activity for one user while logged in as a different user displays the name of the original GoldMine user

76904

Process monitor logs appear under the GoldSync site logs in the GoldSync Admin Center

73456

<<cursor>> field is lost after editing existing document template

70932

Ability to select a group or filter of contacts to add to an existing campaign

70443

Cannot create an email rule that applies to case escalation messages

70348

custom details field are being truncated

68895

Notify via E-mail option does not support external e-mail clients such as smartphones

62591

Relationship Tree folders are limited to 68 on root level

61295

Peg Board does not show current data

57569

Date field does not function correctly when using new default Record Type

57387

Cannot drag and drop sections of Relationship Tree

57173

Peg Board column width is not adjustable

57170

Web Site is not copied when using Copy Current Record option

56650

User notifications for scheduled activities are not delivered to external e-mail clients

56624

Output To Printer Option is grayed out in Activity List for Non-Master users.

49788

When editing an existing document in the Document Management Center, carriage returns are double spaced

48519

Nothing returned with &AdditionalContact macro

8775

ITS 17260: 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

Copyright 2010 FrontRange Solutions USA Inc.  All Rights Reserved.  GoldMine, HEAT and other FrontRange Solutions products, brands and trademarks are property of FrontRange Solutions USA Inc. and/or its affiliates in the United States and/or other countries.  Other products, brands and trademarks are property of their respective owners/companies. 

THE INFORMATION CONTAINED IN THIS DOCUMENT (I) IS INTENDED FOR INFORMATION PURPOSES ONLY; (II) DOES NOT CONSTITUTE A WARRANTY, EXPRESS OR IMPLIED, OF ANY KIND, OR EXTEND THE TERMS OF ANY EXISTING WARRANTY; AND (III) DOES NOT ALTER OR AMEND THE TERMS AND CONDITIONS OF THE END-USER LICENSE AGREEMENTS UNDER WHICH FRONTRANGE SOLUTIONS SOFTWARE PRODUCTS ARE LICENSED.

 

© Copyright 2010 First Direct Corp. All Rights Reserved

spacer