• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

How to import email messages into MySQL

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
jordanaustin
Asked:
jordanaustin
1 Solution
 
SidFishesCommented:
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
 
jordanaustinAuthor Commented:
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
 
Alex-w474Commented:
You can save the files into text/csv format and load them into MySQL using LOAD DATA INFILE MySQL database command.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now