CanMan2004 Posted October 18, 2006 Share Posted October 18, 2006 Hi allI have a email which comes in every 3 days to me, the email contains a CSV file which I have to import into a sql database, I want to try and automate this and let phpaccess emailpick the file from a selected emailimport the file into the databaseCan this be done? I'm sure it's quite complex, so any help or guidence would be greatRegardsDave Quote Link to comment Share on other sites More sharing options...
printf Posted October 18, 2006 Share Posted October 18, 2006 Why not just fetch it from your mail server (POP/IMAP), then do the insert!Tell me the OS, mail server type (pop, imap) your doing this from, so I can tell you if you can pipe it, or if you need to login and get it from the mail server! After I'll give you a example!me! Quote Link to comment Share on other sites More sharing options...
CanMan2004 Posted October 18, 2006 Author Share Posted October 18, 2006 Well I would do, but this is new to me, so i'm not sure how to do it.The server is a linux serverThe mail type is pop3ThanksDave Quote Link to comment Share on other sites More sharing options...
Ninjakreborn Posted October 18, 2006 Share Posted October 18, 2006 Just simply set it as an attachment.http://www.phpfreaks.com/tutorials/130/0.php Quote Link to comment Share on other sites More sharing options...
CanMan2004 Posted October 18, 2006 Author Share Posted October 18, 2006 HiSet what as an attachment? How do I get it to automatically open the file and upload the CSV file at a chosen time.Is it going to be more hassle than it's worth? Quote Link to comment Share on other sites More sharing options...
CanMan2004 Posted October 18, 2006 Author Share Posted October 18, 2006 EveningCan anyone shed any light on this, it would be a great helpThanksDave Quote Link to comment Share on other sites More sharing options...
CanMan2004 Posted October 22, 2006 Author Share Posted October 22, 2006 Can anyone help me on this? I'm still stuck and don't know where to go next with itRegardsDave Quote Link to comment Share on other sites More sharing options...
Ninjakreborn Posted October 24, 2006 Share Posted October 24, 2006 OhI didn't realize what you wanted. I question whether this is possible. If it's going to your server email, I would guess set up a cron job 30-46 minutes after the email come's in to open all your email's or a bot with access information, I really have no idea. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.