Automatic GoldMine Data Tuneups
GoldBox 5 for GoldMine 5.x and 6.x dBase
GoldBox SQL for GoldMine 5.x and 6.x SQL
GoldBox 7 for GoldMine 7.x, 8.x and 9.x
GoldBox 9 for GoldMine 7.x, 8.x and 9.x
Q. What is a GoldBox Tuneup of GoldMine data?
A. GoldBox contains lots of diagnostic and data improvement utilities for GoldMine
data. Collectively, they can
- find and fix potentially serious problems that can lead to permanent data loss;
- detect and correct duplication of data by merging (for Main Contacts), or by
archiving, then deleting the duplications (for relational records);
- archive and delete unlinked or blank "dead" data that is inaccessible in
GoldMine, but which still takes up space in the database;
- report on Main Contact field usage, including User-Defined fields. This reveals
rarely-used fields, and can give a complete profile of the data in specific fields,
when requested.
A GoldBox Tuneup makes use of these utilities and reports, performing actual data
repair and improvement; then reports back to you on what was done, and what
additional improvements you may want to consider. Having a GoldBox Tuneup done
on your data regularly can help keep your database at its best.
Q. What is an "automatic" tuneup?
A. See the list at the bottom of this page for details on what is included. It is not
possible (nor would it be a good idea) to fully automate the use of these utilities; but
what we CAN do is to schedule you for a monthly (or quarterly) Tuneup, at a date and
time that is convenient for you.
After an initial Setup (cost $150), the Tuneup is performed regularly. See below for
detailed pricing; AND see the NOTE at the end of this page about the TUNEUP II
Program at a reduced cost.) A report/summary of results will be provided each
month, and any questions you may have will be answered.
This inexpensive investment can help keep your GoldMine system running at it best.
So, give me a call and we'll get started!
Tuneup Services include:
- Run Contact File Validator and Archive/Remove any of the following, if
found:
- Contact1/Contact2 records (unlinked, blank, duped or corrupt)
- History records (unlinked, corrupt or E-mail message missing)
- Additional Contacts (unlinked, blank or corrupt)
- Details (unlinked, or blank)
- Linked Doc records (unlinked, blank, not on disk or corrupt)
- AP Track Events records (unlinked, blank, no AP identified or
corrupt)
- Group Members (unlinked, blank or corrupt)
- Referrals (unlinked, blank, singleton or corrupt)
- Alerts (unlinked, blank or corrupt)
The Archives for the above item can be accessed via GoldBox Views,
furnished (requires Pro Version if GoldBox 5 or GXSQL). Only occasionally
useful, but can show you info that is not available any other way.
- Determine whether any Accountnos include a single quote (may cause
inaccuracies when running SQL queries). If so, use GoldBox's Accountno
Regenerator to replace such Accountnos consistently throughout GoldMine
with new Accountnos that do not include a single quote.
- Archive and remove any unlinked E-mails from the Mailbox Table
(NOTE: strongly recommend that you NOT try this one yourself!).
- Run field usage report for Contact1 and Contact2 fields.
- Perform routine GoldBox maintenance.
- (Optional) Verify, and if necessary rewrite, the Primary tag on all E-mail
Address records. Does nothing if exactly one Primary E-mail Address record
exists for a Contact; otherwise makes the oldest E-mail Address the Primary,
and ensures that there is only one Primary. Self-documenting.
- (Optional) History/E-mail Archive created/updated. Most important for
older versions of GoldMine (6.x and below), but can be useful for any version.
- (Optional) Apply and update Main Notes Migrator. Converts Main Notes to
Notes in History records that are dated and Referenced appropriately; then
removes such Notes from the Main Notes tab. Most important for older
versions of GoldMine (6.x and below). Not recommended for GoldMine 8.5 or
above.
- (Optional) Run Dedupe and Archive for any of the following types of
relational records: Additional Contacts, Details, History, Calendar, Linked
Documents.:
- (Optional) Rebuild and re-index all GoldMine tables (dBase GoldMine
systems only).
NOTE: Items listed as Optional ARE included in the Quarterly price, if applicable
NOTE: NEW June 10, 2010: For less busy databases, and for thrift-conscious
clients, I'm introducing the TUNEUP II Program. This is exactly the same as the
standard monthly program described above, but instead of performing monthly
Tuneup procedures, I'll do them quarterly.
PRICING SUMMARY:
Original (monthly update, total of 12 per year) Tuneups:
First Quarter (includes setup charge): $465
Each additional quarter: $265
Total first year: $1,260 Total each additional year: $1,060
Tuneup II (quarterly update, total of 4 per year):
First Quarter (includes setup charge): $300
Each additional quarter: $96
Total first year: $588 Total each additional year: $384
