GoldMine Table Definitions

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

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

»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«

» Downloads

GSSITES

DBase Directory Location: GMBASE
Table Description: GoldSync remote site configuration settings.

Table Indexes
Name	DBase Index	SQL Index	ID
GSSEC	SECRECID+RECTYPE+SYNCTYPE+SITEID	SECRECID+RECTYPE+SYNCTYPE+SITEID	-
GSSID	RECTYPE+SITEID+SNAME	RECTYPE+SITEID+SNAME	-
GSSPROF	RECTYPE+USERID+SITEID+SNAME	RECTYPE+USERID+SITEID+SNAME	-
GSSQ	RECTYPE+QPROCESS+NEXTSYNC+SYNCTYPE	RECTYPE+QPROCESS+NEXTSYNC+SYNCTYPE	-
GSSRES	RECTYPE+SYNCTYPE+LASTRESULT+SITEID	RECTYPE+SYNCTYPE+LASTRESULT+SITEID	-
GSSRECID	RECID	RECID	-

Table Relationships

None

Table Fields Structure

RECTYPE

String

Record Type, indicating data stored in this record.

Value	Description
M
P	PDA settings (Palm, Windows CE, Outlook, etc)
S	Site settings (server side)
T	Site group
W	Site settings (remote side)

ACCOUNTNO

String

Account number

QPROCESS

String

SYNCTYPE

String

Synchronization type

SITETYPE

String

For ‘S’ rectype, this is ‘U’ for Undocked or ‘S’ for Remote Site (Sub-License).

USERID

String

Username of the user assigned to this site record.

SECRECID

String

SITEID

String

Site ID – license number and name assigned to this site.

SNAME

String

Site name (description)

SPASSWORD

String

Site password (if applicable)

CONTCO

String

All Contact records cutoff (Format: YYYYMMDDHH:MM)

CALCO

String

Activities linked records cutoff (Format: YYYYMMDDHH:MM)

CALCO2

String

(Format: YYYYMMDDHH:MM)

NEXTSYNC

String

Next sync date/time (Format: YYYYMMDDHH:MM)

LASTSYNC

String

Last sync date/time (Format: YYYYMMDDHH:MM)

STARTSYNC

String

Date/time to start the next sync (Format: YYYYMMDDHH:MM)

NEXTCONTCO

String

Next sync contact records cutoff (Format: YYYYMMDDHH:MM)

NEXTCALCO

String

Next sync activities linked records cutoff (Format: YYYYMMDDHH:MM)

NXTSSEND

String

For ‘S’ rectype, this is the next transfer set filename to send.

NXTSCREATE

String

For ‘S’ rectype, this is the next transfer set filename to create.

LASTRTRVTS

String

For ‘S’ rectype, this is the last transfer set filename retrieved.

LASTSESS

String

Date/time of the last session (Format: YYYYMMDDHH:MM)

RETRIES

String

Number of retries if sync unsuccessful

OPTIONS

String

Options

OPTIONS2

String

Options

OVERRIDES

String

Overrides

LASTRESULT

String

If blank or 0, no message, if greater than 0, see LastRParam for message

LASTRPARAM

String

First few characters of message if LastResult is greater than 0.

CURRSTATUS

String

Current Status

PARAMS

Memo

Numerous parameters indicating many of the sync settings.

LOGRECID

String

Log Record ID

RECID

String

Record ID

Your IP Address is: 216.73.216.59

Questions Answered

Articles Written

Overall Points

Do you want to
exchange links?
Click on my banner
for more information.

Your friends will know you better in the first minute you meet than your acquaintances will know you in a thousand years.
~ Richard Bach, "Illusions?

Darren Lawrence aka MrEnigma/AbsoluteGenius