Xequte User Forums
Xequte User Forums
Profile | Join | Active Topics | Search | Forum FAQ
     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 MailList King
 ODBC connector

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

  Attach a photo to your post
 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
Andrew Dearing Posted - Jan 17 2008 : 05:54:09
Nigel,

You may recall, I need to do a comparison between the MLK database and a CRM database. So far, I've been dumping the MLK database and history to text files and processing those, but I decided to give the ODBC connector another try. I've sorted out several of the tables, but am a bit stuck with the history table, mlk_hist.

How do I interpret (e.g.) the value of the HistoryCode field in the table records, which typically look like this:

'UserID' => '15001',
'Index' => '1',
'DetailID' => '2',
'Date' => '2004-06-30 00:00',
'Detail' => undef,
'SearchHit' => undef,
'Email' => 'email@site',
'HistoryCode' => '9001'

1   L A T E S T    R E P L I E S    (Newest First)
xequte Posted - Jan 17 2008 : 11:49:17
Hi Andrew

To minimize the size of the database all repetitive data is encoded, so a numeric HistoryCode describes each history item:

The codes are outlined at:

http://www.xequte.com/support/maillistking/history_codes.txt


Some History items will require further data, e.g. user id, email address, group code, etc, and those are stored in the Detail fields.

So, for example, your item below (Code 9001) is:

'email@site' attmpted to subscribe to Group ID 2(listed in DetailID)

Nigel
Xequte Software
nigel@xequte.com