Solved

How to import email messages into MySQL

Posted on 2008-06-13
3
208 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PHP Healthcheck 2 84
can windows 10 wamp send mail()? 3 32
updating table data with inner join 9 24
updating the date data 12 21
Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

911 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now