![]() |
GoldBox The number One Add on for all GoldMine systems. Read about all the ways GoldBox can add to the power and flexibility of your GoldMine system. Call Tech.Sell to order or to learn how to put the power of GoldMine to work. |
What is GoldMine without
GoldBox? It's a much smaller system, for data management. Let's take a good
hard look:
IMPORT: You have 2 choices in
GoldMine - both for the Main Contact file only. You have 28 choices in GoldBox
- every one of them affecting a different GoldMine table. From Lookup Lists to
Email Distribution Lists, from Opportunity Competitors to Record Alerts. Just
for this reason alone, GoldBox should have been licensed. Why deny the user
base the ability to bring outside data into so many areas of GoldMine, unless
they pay for an addon?
MAPPED EXPORT: You have 1 choice in
GoldMine - the Main Contact file. You have every single GoldMine table
available in GoldBox. But more. GoldBox can do a mapped Export of ANY table
accessible via a BDE Alias. dBase, SQL, Access, Excel, Text. An automated,
mapped Export, with calculated fields, custom labels... The Export logic in
GoldBox is some of the finest you will encounter anywhere, regardless of the
application.
MERGE-PURGE: This originated in
GoldBox, and was the only way to do it for about 2 years. Then GoldMine came
out with theirs. But it turns out that the original one in GoldBox is generally
faster, it has more options, and most importantly, is safer than the one in
GoldMine. Examples: In GoldBox, you can match on 'smoothed' versions of Company
and Contact for dupes. You can autocopy deleted dupes to an 'archive' Contact
File. You have 4 Backfill settings, field specific. You can save Field
Differences to History.
GROUP BUILDER: About the only common
point between GoldMine's Group Builder and GoldBox's is that they both produce
standard GoldMine Groups. GoldBox saves every Group setup, with 1-button
refresh. 2-way optimization. GoldBox even allows you to build a standard
GoldMine Group - upon data that is not even stored in GoldMine! Because GoldBox
can virtually link to any outside table, with full access to all the fields of
the linked record.
GLOBAL REPLACE, GLOBAL DELETE, GLOBAL UN-DELETE, GLOBAL PATH CHANGER, GLOBAL
USER NAME CHANGER, AUTOMATED ORG CHART BUILDER, MAIN NOTES ARCHIVAL TO HISTORY:
These are either non-existent in GoldMine, or their counterparts are much less
functional. For example, in GoldBox-SQL, you can replace up to 15 fields at
once.
TABLE BROWSER: Best available in
GoldBox - including a DDE hotlink back to the GoldMine Main record for many
tables.
QUERY ANALYZER: Not only is this far
ahead of GoldMine's - it's ahead of Microsoft's in some respects. Like the
ability to build an entire Query without ever taking your hand off the mouse.
Selecting a Date from a graphical calendar, with auto-conversion to SQL format.
Clicking on a record from the Result Set and having it display in a Text
window, for View or Print - including Notes. Pinpoint analysis on unique values
in any field, any table. Guess what happens when you try to run this Query in
Microsoft's Query Analyzer: SELECT * FROM CONTHIST WHERE ONDATE >=
GXinput("UIBEGDATE") AND ONDATE <= GXinput("UIENDDATE") You're going to get a
big error. But when this is run in GoldBox-SQL, it works very well. Why?
Because you can prompt the user to supply the Beginning and Ending Dates from a
graphical calendar. Giving you a lot more flexibility for querying data for
whatever purpose.
AUTOMATION: Some of the best
automation and scripting logic you will find anywhere is in GoldBox, via its
Q-file logic. Did you know there are about 35 different categories of
operations you can automate with a Q-file? They are: Import, Update, Export,
Merge-Purge, Dupes Between Contact Files, Dedupe any single Table, Group
Builder, Groups-by-Break, Org Chart Creation, Referral Generation, Global
Delete, Global Replace, Global Path Changer, Global User Name Changer, Notes
Archival, INI Settings Replicator, Run any EXE, Run any DOS Batch Program, Copy
a Disk File, Rename a Disk File, Delete a Disk File, Modify any dBase4 Field
Structure, Create any Index, Pack any dBase4 table, Zap any dBase4 table, Turn
Sync Stamping ON or OFF, Refresh GoldMine indexes, Rebuild any GoldMine table,
Run Area Code Split Replacement, Convert any BDE Alias to dBase4, Convert Text
File to dBase4, Drop a SQL Index Tag, Pause the Q-file processor and Collect
User-supplied Input.