Google
 
Return Home  
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

Hot Links

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

Site Menu

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

 Downloads

 

MAILBOX

DBase Directory Location: GMBASE
Table Description: Lookup file – contains a record for each defined look-up entry

Table Indexes
Name DBase Index SQL Index ID
MBOXLINK LINKRECID LINKRECID 77
MBOXUSER USERID+FOLDER+FOLDER2+DTOS(MAILDATE) USERID+FOLDER+FOLDER2+MAILDATE 78
MBOXACCT ACCOUNTNO ACCOUNTNO 79
MBXRECID RECID RECID 80

Table Relationships
Field Related Table to Field Type Notes
RecID Cal->LinkRecID 1-1 E-mails still in inbox or waiting to be sent
LinkRecID Cal->RecID 1-1 E-mails still in inbox or waiting to be sent
LinkRecID ContHist->RecID 1-1 Filed, sent or otherwise completed e-mails
LopRecID OpMgr->RecID M-1 Records related to opportunities/projects
AccountNo Contact1->AccountNo M-1 Linked e-mails, does not include folder records in Mailbox.

Table Fields Structure
Field Name Field Type Length Description
LINKRECID String 15 Linked Record ID (from Cal or ContHist RecID)
FLAGS String 8 The Flags field is a String type, but actually stores a number. When the number is converted to binary, the following rules apply:
Bit On Off
1 Read Not Read
2 In History Not In History
3 OutBound InBound
4 Attachment No Attachments
5 Redirect  
6 As Links  
7 ICAL Marker  
8 Signed Not Signed
9 Encrypted Not Encrypted
USERID String 8 User Name
FOLDER String 20 The Folder field contains the name of the folder in which mail is stored.
GoldMine uses the following predefined folders
    X-GM-INBOX -Inbox
    X-GM-OUTBOX -Outbox
    X-GM-TEMPLATES -Templates
    X-GM-GROUPS - Folder 2 is Distribution List Name
         RFC822 holds the members (CACCOUNTNO or Eemailaddress
         Each record is seperated by CHAR(1)
          Records
         CACCOUNTNO = Primary Email
         EEmailAddres = Unlinked Email
         SRECID = ContSupp Recid
         GUSERNAME = GoldMine User
FOLDER2 String 20 Subfolder
ACCOUNTNO String 20 Account Number of linked contact. If '--' and the record is an Email then the email was linked but then subsequently unlinked
CREATEON Date - Creation Date
MAILSIZE String 8 Mail size in bytes
MAILDATE Date - Mail date/Date to be sent if in queue
MAILTIME String 8 Mail time/Time to be sent if in queue
MAILREF String 100 E-mail reference/subject line
LOPRECID String 15 Linked Opportunity Manager Record ID
RFC822 Memo - Entire Mail Message
RECID String 15 Record ID


Welcome
Information

Your IP Address is: 54.167.95.51

Experts Exchange
#1
#2
#3
Questions Answered
Overall Points
Exchange Links
Do you want to
exchange links?
Click on my banner
for more information.

EnigmaWare Products - Home of IRCDominatorXT
Messages


Diplomacy is saying: "Nice doggie!"... till you can find a rock.

 

Other great places to visit
   
Silver Sphere Designs
VPOP3 Mail Server Software  
 
 
News

     
  This site is copyright © 2005 EnigmaWare Software Inc - Darren Lawrence aka MrEnigma/AbsoluteGenius