[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Extracting mail data (for a SQL database)
Hello,
I am trying to extract mail data from mailing list files to put into a
MySQL database. (I want to be able to query an mbox file by certain
fields in the MySQL database.) What I need help with is obtaining the
To, Cc, and Received date fields.
So far I tried adding some code in the doit function in mhamain.pl to
get some data:
foreach $my_index (@my_array) {
$my_date = (split(/$X/o, $my_index))[0];
$my_num = $IndexNum{$my_index};
$my_from = &extract_email_name($From{$my_index});
$my_from_address = &extract_email_address($From{$my_index});
$my_msg_id = $Index2MsgId{$my_index};
$my_in_reply_to = $Refs{$my_index};
$my_subject = $Subject{$my_index};
.
.
.
}
* Is this the appropriate place to do that?
* How might I get the to, cc, and received dates?
Thank you very much for reading :)
- Scott
(I am sorry if this got posted twice - I sent the first one before I
was subscribed so I'm not sure if it went through.)
[Index of Archives]
[Bugtraq]
[Yosemite News]
[Mhonarc Home]