• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/109

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

109 Cards in this Set

  • Front
  • Back
  • 3rd side (hint)
Which 3 user areas master rights cannot access
1. Personal Contacts
2. PersonalBase files in the InfoCenter
3. Encrypted e-mail
user group members are encrypted in the _____ table.
User.dbt
What is the name of the file that stores user settings
username.ini
What is the max number of characters for user name?
8 Char
Why would an administrator set a force logout option
to manage a limited number of license and for maintenance purposes
Should an undocked user update his goldmine version to the host version before synchronizing
Yes
T or F
Before upgrading undocked users perform a NetUpdate on the on the main GoldMine system then send them the file gm7setup.exe
T
Which license type is the installation file gm7setup.exe based?
License type E
T or F
Undocked users use netUpdate to
sync with the master site.
F
Which two files stores the user parameters information?
username.ini - preferences
username.tbi - task bar settings
How would you copy one users task bar setup to another user without using the admin functions?
Copy the user's .tbi file to the other user and rename
How would you copy toolbar settings between users?
In the Username.ini is a section called [TOOL16]. When creating a toolbar configuration for a user, copy the [TOOL16] section from one username.ini and paste it into another username.ini.
How many custom screens can be created in GM
25
How many custom fields can be placed on a custom screen
250
Which table stores the custom screen information?
Fields5
Which three tables store the user defined fields information
Contact2, ContuDef and Fields5
How many characters can a label store?
15 char
T or F
Changing the field order position of Company, Contact, Phone1, or any of the Key 1–
5 fields cannot cause problems
F - Make these changes will cause problems especially with synchronization and querying the database.
T or F
The notes tab can handle up to 64,000 characters
T
What would you type in the field label box when editing a field property?
** - two asterisks
When creating F2 lookup tables how would you setup coded entries with descriptive information?
entry//description - To place a coded entry with descriptive information in the lookup list, type two
slashes (//) after the entry, followed by the description. The entry for the field is
treated like a comment, and displays the descriptive text in the field.
When setting up the Products Lookup list how would you enter price and description?
Description//Price - The Products lookup list functionality differs from other F2 lookup lists. In addition to the product name, it may also contain the price of the product. This functionality exists in the Product field of “Schedule a Forecasted Sale”, “Complete a Sale” and “Completed Sale” dialogs. The syntax of price info is as follows: “ProductName // Price”
Which version of IE does BM+View uses
IE 6.x and above
What is a Record Type and how is it created?
Use the Record Types Administration Center to create Record Types based on combinations of different Primary Field Views, Custom Screens, and GM+Views, and apply them in GoldMine based on your user-defined Record Type Rules. The full record type combination (Primary Field View, Custom Screens, and GM+View) is an "entity."
What are record type rules?
Create and apply Record Type Rules to govern what record type displays based on a field value-based or dBase expression-based rule, or to disable the rules. Rules can be as simple as when the value in the Acct. Type field is Property display the Property record type; when the value is Buyer, display the Buyer record type; or when the value is Seller, display the Seller Record type.
List the six tables a report can be created from?
1. Contact1: Top four quadrants of the Contact Record and the Summary and Notes tabs.
2. Contact2: Fields tab and user-defined fields.
3. ContSupp: Contacts, Details, Referrals, and Links.
4. Cal: Calendar and Pending tab.
5. ContHist: History tab.
6. OpMgr: Opportunity Manager.
List the special fields that can be incorporated in your report?
1. Dialog: Prompts users to input data used within the report.
2. Calculations: Calculates the total or performs other mathematical operations.
3. Macros: Places multiple fields in the report. Macros are like those used within
GoldMine/Microsoft Word templates.
When saving Goldmine reports what file extension should be used?
.fp
What are Answer Wizard Reports
Answer Wizard is a reporting tool letting users run detailed reports about company issues and trends. When selecting a report from the Answer Wizard tree, the wizard prompts you to answer questions related to the output of your report, such as content parameters and printing options.
Answer Wizard may prompt you to answer report-specific questions, such as date and time ranges, priorities, and so on. The wizard then runs these specifications against information in your database and returns the results.
How would you install the Answer Wizard report function?
The Answer Wizard is installed when you select Management Intelligence during a custom installation of GoldMine using an E-license.
T or F
In a networked environment the Answer Wizard is installed on the host computer only.
FALSE
In a network environment, Answer Wizard must be installed locally (on the computer of those individuals using the reports).
How do you launch the Answer Wizard?
To launch the Answer Wizard, click Start on the Window taskbar and select
Programs>>GoldMine>>Answer Wizard.
In the auto dialer setup how does Goldmine distinguish between a local and long distance call?
A user-created, configuration settings file called predial.ini that is placed in the GoldMine folder handles the differentiation between local and long-distance calls.
T or F
In a GoldMine Corporate Edition installation, the shared database files and Contact files are hosted on the database server while licensing and user files remain local to the GoldMine folder.
True
T or F
In a network environment, you can run workstations from the executable on the server. You can also install GoldMine's executable files locally to a workstation if the data files are centrally located and accessible to all GoldMine users.
True
T or F
The Goldmine executables should be two levels deep in the in a directory structure
False
The main GoldMine executables should always be one level deep in a directory structure. The path to GoldMine should be x:\GoldMine, where x is the network drive where GoldMine is installed. Installing by using Universal Naming Convention (UNC) paths, the server path should be \\server\GoldMine\GoldMine or \\server\sharename\GoldMine.
Is the license and user files stored in the database?
No
In a GoldMine Corporate Edition installation, the shared database files and Contact files are hosted on the server database while licensing and user files remain local to the GoldMine folder.
List the other names for Goldmine Files
GoldMine tables, GoldMine database, or GMBase, are tables storing shared database information. Although you may have multiple Contact Sets, you should only have one set of GoldMine files.
How does the Goldmine Corporate Edition Answer Wizard access the database?
GoldMine Corporate Edition Answer Wizard use Open Database Connectivity (ODBC). When GoldMine is installed, it creates default data sources in the ODBC Data Source Administrator.
Whats the name of the default ODBC DSN created by Goldmine CE?
The default data source is GM Sales_Mktg.
List all 12 Goldmine Tables (not contact table).
Cal - Schedules
Mailbox - Mail
OpMgr - Opportunity and project
OpMgrFld - Op and Proj fields
PerPhone - serves as personal contacts (Rolodex)
Report32 - report definition
ResItems - Resources created
Scripts - telemarketing branch scripts
SPFiles - is the directory of the GoldMine Contact Set databases.
SysLog - records errors occurring
when using the database tables.
Tracks - Automated processes tracks
UserLog
List all 8 Contact Tables.
Contact1
Contact2
ContSupp
ContuDef
ContHist
ContGrps - header defining each group and the members of the groups.
ContTlog - synchronization information for the contact set.

ContHist
Which database function is used to convert database from dBase to SQL server or Firebird?
Rehosting
What would you do if you got the error message "ODBC drivers
are not present" while creating a new firebird database
Install the ODBC driver first, then copy the FBclient32.dll to the GoldMine
installation directory.
What is the function of the Database Alias Manager
The Database Alias Manager lets you establish an alias for each database management system used with GoldMine. An alias is required to connect your database to the application. It tells GoldMine where to find the database, collecting information from which to build the ADO connection string.
What would you do if you got the error message "ODBC drivers
are not present" while creating a new firebird database
Install the ODBC driver first, then copy the FBclient32.dll to the GoldMine
installation directory.
Stopped at page 82
82
What is the character limit for db alias?
100 character
When aliased databases are created where is the ADO connection string stored?
In an INI File called dbalias.ini.
During installation what is the default path for the Firebird database file?
By default the GoldMine installer creates an initial database file in \\\\Program Files\\\\GoldMine\\\\Data\\\\GOLDMINE.fdb. It is advisable to keep the same file naming convention and create additional database files in the same folder and maintain the same .fdb extension.
What is the default Firebird login?
By default, during GoldMine installation, the installer gives you the option to create a login:
GMSYSDBA. If you accepted this default value at the time of the GoldMine installation, enter GMSYSDBA in this field. Otherwise the value you specified during installation should be entered.
How does Goldmine prevent users from accessing the system during backup and database maintenance?
Before the maintenance begins, GoldMine ensures no other user is accessing that data. Once the operation is in progress, GoldMine prevents other users from accessing the system by renaming the License.bin to License.bix. When maintenance is completed, the license renames back to
License.bin.
List all 8 logs you will see when to go to View>>GoldMine Logs.
1. Process Monitor Logs: Activities recorded in the GoldMine Process Monitor.
2. Maintenance Logs: Dates and outcomes of database maintenance procedures.
3. Users' Login Logs: Users' login activity.
4. Sync Wizard Logs: Dates and details for GoldMine synchronization.
5. GoldSync Logs: Details about GoldSync synchronization.
6 Contact Files Logs: Changes made to the Contact Set files.
7 GoldMine Files Logs: Changes made to GoldMine files.
8 Error Logs: Details of errors.
There are 8 in total
List the environments that Firebird can operate in?
Windows
Linux
Unix
Firebird uses Microsoft technology ActiveX Data Objects
(ADO).However, which version of MDAC does it use?
2.6
During installation Goldmine installs the Firebird database. What is the default database name, login and password?
db name: Goldmine.fbd
Login: SYSDBA
password: masterkey
What is the name of the command line tool that comes with Firebired?
ISQL
List three recommended Firebird database tools
FlameRobin
FeniSQL
IBExpert
What is the function of the Firebird command line utility gsec?
Firebird comes with a command-line tool called gsec that is used to manipulate user accounts. You need to be in the Power user group on Win and root on Linux.
What is the gsec command syntax?
Windows: gsec -user sysdba -password masterkey -database
"localhost:C:\Program Files\Firebird\Firebird_1_5\security.fdb"
Unix or Linux: ./gsec -user sysdba -password masterkey -database
Next at the prompt-->
GSEC>modify user -pw newpassword
What are the three steps in creating SQL Server Databases
Where would you go to clean up dos notes?
1. Select Tools>>Import/Export Wizard>>Clean up DOS Notes. The Clean up DOS
GoldMine Notes dialog box appears.
2. To start the conversion, click Go.
T or F
You can undo a merge/purge.
False. Changes are permanent. Back up before proceeding.
Why was the "Move Linked Document and Attachments" feature added to Goldmine?
(Split data from executables) Vista requires a split-path installation for proper operation. This feature allows you to move all documents and attachments currently linked to GoldMine contacts to a storage location outside of the Program Files directory, which is automatically set to "read only" in Vista.
What should be backed up on a regular basis?
1. Goldmine Contact Data
2. Setup Data
3. Program Files

For SQL and FireBird databases use special tools.
List four precautions to prevent corrupt index in GMCE database.
1. Never turn off or reboot your PC before completely exiting GoldMine.
2. Network users should log out of the file server before powering down the PC.
3. Use a battery backup device.UPS
4. Single-user installations should run ScanDisk.exe or a similar utility to test the integrity of your disk drive.
What is the main purpose of verifying a Database?
Verify checks data for readability. It checks to see if all fields in the synchronization records of the database files are populated and for any duplication of unique fields.
What is database indexing?
Ensures data integrity and quick access to the data in indexed fields.
What happens during database rebuilding and packing?
Creates fresh data files and builds tables, then repacks the
database minus deleted records.
When using the import export function, which two tables are involved?
Contact1 and Contact2
List four common thirdparty software used to import calendar, supplemental contact information, or history records
Goldbox Utilities
Inaport
CRMSwitch
Beyond Gold
List the file formates you can import/export data in Goldmine
DBF File
ASCII (Text) files - delimited
SDF (fixed length)
XML file
T or F
The lookup.ini file is created at installation.
False
Lookup.ini does not exist in GoldMine until you create it using a text editor. It writes as a standard configuration file, similar to the Win.ini and System.ini files and stores in the GoldMine directory.
List five functions of Lookup.ini
1. Update Contact1 or Contact2 based on data entered contact field
2. Update Contact1 or Contact2 field based on expression
3. Launch external application based on expression or field entry
4. Apply an activity color code to calendar activities based on either an activity type, an activity code, or both.
5. Launch an external application when a new record is created.
Describe the licensing requirement for synchronization to occure.
To synchronize, each GoldMine system must have a unique license number. However, a user working on a GoldMine network can create a GoldMine sublicense to work on an undocked basis
What is a transfer set?
During remote synchronization, GoldMine creates a transfer set that is a database of all the changes made to a GoldMine database during a specified cut-off date.
Describe the three steps involved in synchronization.
1. Transfer set is created
2. Systems connect and exchange data
3. Retrieving system incorporates the changes into database
How are TLogs used?
GoldSync uses Tlogs to keep track of changes to each field in the database and to track new records. Changes you make to your GoldMine data are tracked to the millisecond and stored in the Tlogs.
When creating a new remote site, is it OK to just copy the host database tables to the remote site?
NO
This causes problems with synchronization. Remote sites should be set up with a fresh installation of GoldMine, and the data should be synchronized with the main GoldMine site.
Why if running GoldSync as a service, you must use UNC paths for the folder location?
Mapped drives are not recognized properly by Windows Services.
How do you install and configure GoldSync as a service?
Install, start, and configure the GoldSync Service from the GoldSync Administration
Center toolbar, but use the GoldSync Service tab to manage the service without
launching the GoldSync Administration Center.
List the two main benefits for running GoldSync as a service.
1. Added security - no need to logon to start Goldsync
2. Saves admin time - no need to start service when computer is rebooted.
What are the main uses of Sync Spy?
Check record updating in sync log
view sync stamp, log stamp, field name and user
What is the licensing requirement for Host and Remote site for GoldSync to work?
Host - Master License
Remote - Undocked or Sublicense
List the SQL Server versions support by GM 7.3 to 7.5 and 5.0 to 7.0.
7.3 to 7.5 - Server 7.0, 2000 and 2005
5.0 to 7.0 - Server 7.0 and 2000
What is the recommended maximum number of sessions per GoldSync server.
10
When configuring the GoldSync IP to IP/Network config, which port is used?
5993
How is the transfer set secured during a GoldSync synchronization?
All transfer sets are encrypted at 128 or 32 bits
Which Goldmine license does not have access to the GoldSync Admin Center?
Systems with U licenses do not have access to the GoldSync Administration Center.
What is the recommended database browsing utility one should use when view the transfer set data?
BR7 from redstonesoftbase.com
Briefly describe how WebImports work?
1. Set up website to collect prospect info
2. Create a Web form in Goldmine
3. Install web form and script in website
4. When prospect submits web form a email is sent to a special Goldmine email address
5. Goldmine recognizes import instructions and creates contact
What is the email content type found in the header of a Goldmine webImport email?
Content-Type: application/x-gm-impdata
Describe how to setup a password on the web import email.
1. Create a [WebImpPassword] section in the GM.INI
2. Add passwords to this section by entering Passwordx=value, where x is a number up to 999
3. In the [Instruction] section of the web import file enter Password=value
Fill in the blanks.
To control calls, Softphone uses __________. To send and receive voiceover
IP, Softphone uses _________.
To control calls, Softphone uses Session Initiation Protocol (SIP). To send and receive voiceover IP, Softphone uses Real-time transport protocol (RTP).
List the types of Master Licenses.
E - Corp Edition - for SQL Server, Firebird and GoldSync
G - GoldSync
O - Goldmine Outlook Integration
List the Sublicenses.
U - Undocked
S - Site License
Y - GoldSync Sublicense for remote office
What are the components of a license?
License type - 1
Number of users - next 4
Version - next 2
HDA Number - next 6
Serial Number - next 15
Key Code - next 15
Net-Update is used to register GoldMine, update your version of GoldMine, or view options to upgrade your GoldMine system.
What are the two menu options that allow you to do this?
1. File>>Configure>>License Manager
OR
2. Help>>Update GoldMine
GoldMine on a Firebird database can store a maximum of __k (SQL is __k) for the combined length of user-defined fields in a record.
32 and 8
GoldMine on a Firebird database can store a maximum of 32k (SQL is 8k) for the combined length of user-defined fields in a record.
To add the results of a dBASE expression to a user defined field, which character would you place at the begining of the expression?
Character "~"
Example ~dtoc(date())
How would you dial a personal contact in GM assuming telephony is setup?
To call a contact in your personal contacts, select View>>Personal Contacts. Click Dial. The Phone Dialer dialog box appears.
T or F
Goldmine cannot use a modem to dial numbers, it only uses SIP with the softphone.
FALSE
You can if you have a TAPI modem connected to your computer you can configure dialing settings to use with GoldMine's auto-dialer feature.
What are tracks?
A sequence of two or more events used as the step-by-step instructions GoldMine evaluates to perform a defined series of activities. Also known as an Automated Process.
What are Events?
Step-by-step instructions contained in an Automated Process, or track, GoldMine evaluates to perform a series of activities. An event consists of a trigger and an action. An Automated Process consists of a sequence of one or more events.
Each Automated Process, or track, can have up to ___ sequential events and ___ preemptive events.
900 and 100
Each Automated Process, or track, can have up to 900 sequential events and 100 preemptive events.
Which user group is most appropriate to run gsec in the windows environment?
On Windows server platforms, you typically need to be in the Power User group or higher to run gsec successfully.
What is the minimum recommended backup schedule?
Back each data for two weeks before rotating tapes.
What are the three database maintenance options?
1. Indexing
2. Rebuilding and Packing
3. Sorting and Verifying
What are the three type of e-mail forwarding rules?
1. Global Primary-A first set of e-mail rules that execute before any others.
2. Private-A set of personal e-mail rules that execute after the global primary e-mail rules.
3. Global Secondary-A third set of e-mail rules that execute after the private e-mail rules.