#1
  1. No Profile Picture
    Craig.p
    Guest
    Devshed Newbie (0 - 499 posts)
    I get about 200 messages per day that are reports from different machines. What I am tring to do is import these to a MySQL db, for archiving purposes and also so that I can create a web page that I can view the latest messages only( and not have to look at all these damn messages in my regular email box)
    I have tried (with NO success) to use Procmail to send these to text files that could then be imported. Does anyone have an idea on another approach to this?
    ANY help would be greatly appreciated!
  2. #2
  3. No Profile Picture
    Kyuzo
    Guest
    Devshed Newbie (0 - 499 posts)
    I had a similar problem with trying to get emailed reports dumped directly into a database. The solution (on UNIX) was to create an email address (reports@yourdomain.com) which was piped directly to a PERL script using the DBI module to then strip out all unnecessary info and pass it right along into the database. There's a lot of formatting issues to deal with but it worked out fine. If you're interested, I can give you more details.

    HNY

    Kyuzo
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    2
    Rep Power
    0
    Similar problem. I needed a log of all outgoing mail that I could later search. I also wanted a way allow multiple users to access the same mailboxes at the same time.

    Solution: Apache, imp (web-based IMAP mail) and mysql. modified the imp files (compose.php3) to insert the outgoing messages into the database. More modification and added a few files to allow searching.

    Not quite what you're trying to do but perhaps gives you some ideas.

Similar Threads

  1. Replies: 2
    Last Post: December 2nd, 2003, 03:52 PM
  2. MySql database access problem, plz help
    By spapmonkey in forum MySQL Help
    Replies: 0
    Last Post: October 6th, 2003, 04:06 PM
  3. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 11:05 AM
  4. transfering MySQL database
    By mwoolgar in forum MySQL Help
    Replies: 5
    Last Post: March 11th, 2002, 02:54 PM
  5. Replies: 21
    Last Post: January 26th, 2002, 05:21 PM

IMN logo majestic logo threadwatch logo seochat tools logo