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