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

TRACKS

DBase Directory Location: GMBASE
Table Description: Automated Processes definitions.

Table Indexes
Name	DBase Index	SQL Index	ID
TRACKS	RECTYPE+TRACKNO+EVENTNO	RECTYPE+TRACKNO+EVENTNO	-
TRKCODE	RECTYPE+EVENTNO	RECTYPE+EVENTNO	-
TRKRECID	RECID	RECID	-

Table Relationships
Field
None

Table Fields Structure

RECTYPE

String

Record Type.

Value	Description
B	Track Header record (Process)
E	Track Detail record (Event)

TRACKNO

String

A unique track # that links the event with the header process. Typically the RecID of the Process Header.

EVENTNO

String

Identifies the sequence in which events are processed.

EVENTTYPE

String

Event Type ((P)reemptive, (S)equential)

NAME

String

The process or event description

TRIGGERTYP

String

Trigger Type. See table below for details.

ACTNTYPE

String

Action Type. See table below for details.

NEXTACTN

Integer

Next Action. See table on next page for details.

USERID

String

Username. Used for process owner.

USERTYPE

String

User Type.

Value	Description
O	Record Owner
A	Assigned User
C	Attaching User
L	Logged User
F	User from Field

FIELD

String

Field Name. See tables below for details.

ACTVAGE

Integer

Activity Age. Used for Max Age.

TOPTION1

String

Trigger Options. See table below for details.

TOPTION2

String

Trigger Options. See table below for details.

AOPTION1

String

Action Options. See table below for details.

AOPTION2

String

Action Options. See table below for details.

AOPTION3

String

Action Options. See table below for details.

FILTEREXPR

Memo

Filter.

CONDEXPR

Memo

Condition Expression. See tables below for details.

UPDTEXPR

Memo

Update Expression. See tables below for details.

RECID

String

Record ID

Trigger Fields and Possible Values (Values for first line in each section apply to all rows in that section) Columns that are the same for all triggers:

FILTEREXPR: Filter
ACTVAGE: Max Age (Applicable to Detail, History and Scheduled Activities

Description	TRIGGERTYP			NEXT ACTN	COND EXPR	TOPTION1 (width in parenthesis)	TOPTION2 (width in parenthesis)
Description	Pos 1	Pos 2	Pos 3	NEXT ACTN	COND EXPR	TOPTION1 (width in parenthesis)	TOPTION2 (width in parenthesis)
Elapsed Days	D			Number of Days
Immediate	I
Detail Record	P						Keyword
Detail/Profile		P				Detail
Document Links		L
Additional Contact		C
Referral		R
History Record	H					Activity (10) + Result (5) + User (8)	Outcome (5), 0=Any, 1=Successful, 2=Unsuccessful + Reference (25)
Phone Call		C
E- Mails		M
Next Action		T
Appointments		A
Sales		S
Others		O
Literature Request		F
Event		E
To-Do		D
Forms		L
Scheduled Activity	S					Activity (15) + User (8)	Blank Spaces (5) + Reference (25)
Call Back		C
E-Mail Message		M
Next Action		T
Appointment		A
Forecast Sale		S
Other		O
Literature Request		F
Event		E
dBase Condition	C				dBase Condition
Disabled	X
Attempt to Trigger Only Once (All above records where applicable)			1

Action Fields and Possible Values (Values for first line in each section apply to all rows in that section) Columns that are the same for all actions:

FILTEREXPR: Filter
UPDTEXPR: Numerous parameters (from Activity Details or optional fields). Used by most action types. Each is formatted as ~~FIELDNAME=VALUE.

Description	ACTNTYPE			FIELD	AOPTION1 (width in parenthesis)	AOPTION2 (width in parenthesis)	AOPTION3 (width in parenthesis)	UPDTEXPR
Description	Pos 1	Pos 2	Pos 3	FIELD	AOPTION1 (width in parenthesis)	AOPTION2 (width in parenthesis)	AOPTION3 (width in parenthesis)	UPDTEXPR
Print	L			FormNo Links to Forms table	‘Q’ + Number of days to queue for printing (-1 =Now).
E-Mail	E							Update Ref Field with dBase Expression
Delivery					Pos 1
Now					1
Queue					0
Draft					2
Password					Pos 2=’1’		Password
Activity Code						Pos 7-9
Result Code						Pos 4-6
Create History					Pos 3=0/1
Save Message Body					Pos 4=0/1
Merge Template				FormNo Links to Forms Table
Report	R			RecID Links to Reports Table	Contacts: 0=All 1=Current 2=Filter/Group
Schedule Activity	S						Number of days scheduled in the future.	Field Parameters
(Values applied to all Activities)
Schedule From
Today			0
Trigger Date			1
Call		C
Message		M
Next Action		T
Appointment		A
Forecast Sale		S
Literature Request		F
Other		O
Add History	H							Field Parameters
Call		C
Message		M
Next Action		T
Appointment		A
Forecast Sale		S
Forms		F
Other		O
To-Dos		D
Add Detail	P							Field Parameters
Add to Group	M			RecID Links to ContGrps Table
Update Field	F			Field name				dBase Expression
Remove Track	D
Attach Track	A				RecID Links to Tracks Process	Process Immediately=0/1
Goto Event	G				RecID Links to Tracks Event
Run Program	U							Field Parameters

Your IP Address is: 162.158.79.50

Questions Answered

Articles Written

Overall Points

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

I know my mind. And it's around here someplace.

Darren Lawrence aka MrEnigma/AbsoluteGenius