FIELD CLEANUP: Do you need to see an instant listing of all unique values in a GoldMine field? Perhaps you are looking to expunge stray values from a critical field, for reporting, email blasts, exports, group building. Distinct field values can be listed with a SQL Query, such as:
Select Distinct KEY3 from CONTACT1 Order By KEY3
GoldBox has the Unique Field Listing to provide a bit more:
1. Case-sensitivity. CUSTOMER and Customer and CUSTomer would all be broken out separately as unique field entries. In the above SQL statement, they would all be seen as the same.
2. You get columns displaying the number of records filled by the value, the percentage of the table containing that value, plus entries showing the total number of records and the total number of unique values.
3. It’s FAST. A before and after test on a 43,000 record table revealed:
GoldBox 2008-U: 18 minutes
GoldBox 2008-W: 5 seconds
4. Instant report generation. Your default TXT editor (such as Notepad) immediately pops open with the results. This can be used as a guide while you perform standardizations on the field, either through manual entry or Global Replace.
GOLDBOX BROWSER: Expect major speed improvements for Global Replace, Delete, UN-delete and the Filled Field Count report. At the Options dropdown, any table open in GXBrowser can now be closed and RE-opened in the BR7 Utility.
LOCATOR LOGIC: GoldBox has the best Import and Export technology available for your GoldMine data. At the Field Mapping Templates, accessing particular fields can prove challenging, especially if we’re talking about a Main Contact File with 250+ user-defined fields. In 2008-W, you can quickly move around the template with partial searches on all of the major columns. You also get NEXT logic, whereby clicking a button takes you to the next occurrence, then the next and so forth. Look for the Locator at the bottom row of the Field Mapping screens for Import and Export.
CONTACT FILE VERIFIER: Introduced in version 2008-U. Enhanced to identify ACCOUNTNOs containing single-quotes, which, as we know, can cause some issues with SQL Queries. If desired, those records can be given a new Alpha-Numeric ONLY Accountno value with GoldBox’s ACCOUNTNO Regenerator (at Global Replace).
The VERIFIER also points out discrepancies between original field values and their U_Field counterparts. The U_Fields are indexed, and this new capability lets you identify and optionally update the U_Fields directly.
QUERY BUILDER: The advanced SQL Query Builder now recognizes UPDATE and DELETE FROM statements and will operate directly upon your table should you decide to use them. Exercise CAUTION when doing so.
SEAT PURCHASE: This has been improved and simplified, when you wish to add Seat Licenses for GoldBox Views.