TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

GSSERVER

DBase Directory Location: GMBASE
Table Description: GoldSync Server settings.

Table Indexes
Name DBase Index SQL Index ID
GSVID RECTYPE+MACHINEID+PROCID RECTYPE+MACHINEID+PROCID -
GSVSTART RECTYPE+MACHINEID+AUTOSTART+PROCID RECTYPE+MACHINEID+AUTOSTART+PROCID -
GSVSTYPE RECTYPE+MACHINEID+PROCTYPE+PROCNAME RECTYPE+MACHINEID+PROCTYPE+PROCNAME -
GSVTYPE RECTYPE+PROCTYPE+PROCNAME RECTYPE+PROCTYPE+PROCNAME -
GSVRECID RECID RECID -

Table Relationships
Field
None

Table Fields Structure
Field Name Field Type Length Description
RECTYPE String 1 Record type indicating data stored in this record.
     P=Process record
     W
MACHINEID String 15 If RecType=’P’, this is the server name
PROCID String 15 Process ID
PROCTYPE String 2 Process Type
PROCNAME String 50 Description of sync settings
AUTOSTART String 1 Whether to automatically start this process. 0=No, 1=Yes
MAXTASKS String 2 Maximum number of tasks that can be run
SYNCPERIOD String 63 Seven segments of 9 characters each indicating the sync settings for each day of the week. There are no separators between each segment.
Position Description
1 0 (Inactive) or 1 (Active).
2-5 start time in 24 hour time
6-9 end time in 24 hour time
OPTIONS String 20 Options
PARAMS Memo - Various parameters depending on sync type. Parameters separated by double-tildes ‘~~’ and followed by a line break character.
Common parameter is IPPORT=#### where #### is the TCP/IP port on the firewall where the sync communication is passed. Default is 5993.
CURRSTATUS String 4 Current Status
RECID String 15 Record ID


Your IP Address is: 54.167.44.32