Google
 
Return Home  
GoldMine web import forms and GoldMine API programming, Automatic Web Update software

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

   The home of IRCDominatorXT, NETUpdate automatic web update and GMGoldLINK the new GoldMine API

Hot Links

» Home Page
» My Forum
» Email Me
» My Shop

Site Menu

»Affiliate Market«
     »Featured Product


»GoldMine«
     »GoldFORM
     »GoldMine API
     »GoldMine Tables
     »Services
     »Downloads

»NETUpdate Suite«
     »Client
     »Admin Part1
     »Admin Part2
     »ActiveX
     »Features
     »News
     »Downloads
»Visual Basic Stuff«
     »CodeSmartX
     »PikLink
     »Links

»Fun Stuff«

Old Projects
»IRCDominatorXT«
     »Latest
     »Known Bugs
     »Using Passport
     »Trouble Shoot
     »Downloads
»Legend Of Mir2«
     »Server Config
     »Converter
     »Browser
     »Other

»Work In Progress«
Links

» Downloads

 

GoldMine Table Structures.

Please go here for GoldMine Premium Specific Tables

Detailed here are the GoldMine tables and Indexes for both DBase and SQL (usually the same functionally), also field definitions. This information has been obtained from a number of places and from my own use of GoldMine

It is important to note that writing directly to any of these tables (whether dBase or SQL) is not supported by FrontRange Solutions (GoldMine). You risk data corruption and at best you will lose all synchronization information for these changes you make. To safely update GoldMine’s database, you should use the API specifications that GoldMine provides to update their tables.

GoldMine Data Table Name Location
Additional Contacts and Other Records ContSupp Contact Set
Alert Definitions InfoMine GMBase
Assigned Alerts ContSupp Contact Set
Automated Processes (Assigned) ContSupp Contact Set
Automated Processes (Definitions) Tracks GMBase
Completed Appointments, Calls, To-Dos, Actions ContHist Contact Set
Contact Groups ContGrps Contact Set
Primary Contact Information Contact1 Contact Set
Secondary Contact Information Contact2 Contact Set
Custom Data Fields Contact2 Contact Set
Custom Field Definitions ContUDef Contact Set
Custom Field Layouts Fields5 GMBase
Details Records / Profiles ContSupp Contact Set
Details/Profiles Header Definitions ContSupp Contact Set
E-Mail Addresses ContSupp Contact Set
E-Mails (sent, received / Filed) MailBox GMBase
Filters and Queries Filters GMBase
InfoCenter InfoMine GMBase
Lead analysis files LeadDbfs GMBase
Linked Documents ContSupp Contact Set
F2 Lookups LookUp GMBase
Merge Documents Forms GMBase
Information about fields in merge forms. Formsfld GMBase
Queue of mail-merged documents waiting to be sent. FormsQue GMBase
Opportunities/Projects OpMgr
OpMgrFld
GMBase
GMBase
Organizational Tree ContSupp Contact Set
Pending Appointments, Calls, To-Dos, Actions Cal GMBase
Personal Rolodex PerPhone GMBase
Referrals ContSupp Contact Set
Reports Report32 GMBase
Resources ResItems GMBase
Synchronization Settings GSServer
GSSites
GMBase
GMBase
Web Addresses ContSupp Contact Set
     
GoldMine Premium Specific Tables Table Name Location
Contacts Notes Notes Contact Set
Service Centre Cases GMBase
     
     
     
GoldMine Misc Tables and Logs Table Name Location
Database Locations SPFiles GMBase
Script definitions. Scriptsw GMBase
Saved Import/Export profiles for all databases. ImpExp GMBase
System log Syslog GMBase
Log file of user logins Userlog GMBase
Synchronization Records
(changes, deletes)
ContTLog
GMTLog
GSLogs
Contact Set
GMBase
GMBase
Character set Information for installation CharSet GM Folder
Field names dictionary Datadict GM Folder
Logged In users flags Flags GM Folder
Licensing Information License GM Folder
Locking table used in synchronizations. Synclock GM Folder
network synchronization. Synctask GM Folder
Usernames and Settings Users GM Folder
     
GoldMine Table Relationships    
Welcome
Information

Your IP Address is: 44.213.99.37

Experts Exchange
#1
#2
#3
Questions Answered
Overall Points
Exchange Links
Do you want to
exchange links?
Click on my banner
for more information.

EnigmaWare Products - Home of IRCDominatorXT
Messages


The statistics on sanity are that one out of every four Americans is suffering from some form of mental illness. Think of your three best friends. If they are okay, then it's you.
Jerry Seinfeld

 

Other great places to visit
   
Silver Sphere Designs
VPOP3 Mail Server Software  
 
 
News

  This site is copyright © 2005 EnigmaWare Software Inc - Darren Lawrence aka MrEnigma/AbsoluteGenius