Solved

How to import email messages into MySQL

Posted on 2008-06-13
3
211 Views
Last Modified: 2012-06-27
Hello,
I'm not 100% sure this is possible but I'll throw it out there in hopes that it is.

I have reports that get sent to me weekly with various data that needs to be placed into a MySQL database. What I am interested in doing is having some type of script pull these email messages from the pop server and place the data into the MySQL database.

If anyone has any idea how to do this I'd be very thankful, as it would save me massive work of retyping all the data.

Thanks!

-Jordan
0
Comment
Question by:jordanaustin
3 Comments
 
LVL 36

Accepted Solution

by:
SidFishes earned 250 total points
ID: 21782720
use cfpop

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_p-q_08.html
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=email_01.html#1120458

which basically retruns pop3 message as a query struct which you can loop over and do the same kind of things you do with a standard query object. (like insert to a db)

0
 
LVL 2

Author Closing Comment

by:jordanaustin
ID: 31467076
Thanks SidFishes, I had tried using cfpop for about 2 hours trying to get it to work, but the second link to the likedocs was exactly what I needed.

Thanks again!
0
 
LVL 5

Expert Comment

by:Alex-w474
ID: 21782793
You can save the files into text/csv format and load them into MySQL using LOAD DATA INFILE MySQL database command.
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Creating and Managing Databases with phpMyAdmin in cPanel.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question