| Author |
 Topic  |
|
|
Andrew Dearing
France
15 Posts |
 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'
|
|
|
xequte
7042 Posts |
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 |
 |
|
| |
Topic |
|
|
|
ODBC connector
