The traditional Unix tool for this job is procmail[1]. You can configure it to process all incoming mail in an account with a shell script -- decoding the attachment and saving it to a file would be very easy to do, assuming the server is also a FTP or web server. Of course, the script could also just decode the attachment and load it directly into MySQL.
1. http://partmaps.org/era/procmail/mini-faq.html#rtfm
-Esme
--
Esme Cowles <[log in to unmask]>
"I don't need to be forgiven." -- The Who, Baba O'Reilly
On 10/17/2012, at 11:46 AM, Nate Hill <[log in to unmask]> wrote:
> Maybe someone can offer me a suggestion here...
> I bought a nifty new gadget that records data and spits out csv files as
> email attachments.
> I want to go from csv > MySQL and build a web application to do cool stuff
> with the data.
> The thing is, the device can only email the files as attachments, it
> doesn't give me the ability to upload them to a server.
> Can anyone suggest how I can securely email a file directly to a folder on
> a server?
>
> The scenario is nearly identical to what is described here:
> http://www.quora.com/How-can-I-upload-to-an-FTP-site-via-email
>
> --
> Nate Hill
> [log in to unmask]
> http://4thfloor.chattlibrary.org/
> http://www.natehill.net
|