|
| |
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
|
|
| Author |
 Topic  |
|
|
Andrew Dearing
France
15 Posts |
Posted - Jan 17 2009 : 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'
|
|
|
xequte
7504 Posts |
Posted - Jan 17 2009 : 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 |
 |
|
| |
Topic |
|
|
|
| |
Search
ODBC connector
