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.
|
||||||||
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 |