RE: Witango-Talk: Looking for Email (POP3) -> SQL Database Utility

[Ben Johansen]

I will definitely give this a try, Thanks,   While on this subject, I wanted to state that any solutions that is used to update the archive automatically will be temporary until we are running Witango version 5.0 and then the Archive will be all in Witango.   Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WiTangoGoodies.htm  Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Trevor Green Sent: Monday, May 06, 2002 1:17 AM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Looking for Email (POP3) -> SQL Database Utility   Here is a simple perlscript that you can use to retrieve email messages and insert them into a database. The way it would work is that you would create a user on your email server and subscribe that user to the list. Then schedule the perlscript to run every 30 mins or so. It will retrieve the messages and insert them into the specified database.   If you need further help please email me off list. You will obviously need perl installed on a computer somewhere running this script to use this solution. I use ActiveState Perl and so can only help you if you are using this product.   Regards Trevor     -----Original Message----- From: Ben Johansen [mailto:[EMAIL PROTECTED]] Sent: 03 May 2002 08:35 To: Multiple recipients of list witango-talk Subject: Witango-Talk: Looking for Email (POP3) -> SQL Database Utility   Hi All   This was part of reply of another thread, so sorry if you have read this already. (I wanted to give it another shot as a new subject)   -> So here is what it needs to do. <- Periodically use POP3 to collect email from my mail server and then insert the data into a Table in a SQL Database.   I looked all over the web for software to Email->SQL (at least what google could find) and only found one that might do what I need but it costs $300.   I have tested Delphi and I could write one in a couple of hours. But thought I would ask the list here.   I have Exchange Server, And, No I don't want to it. To me that is like buying a HumVee to drive over a speed bump ;-)   Thanks Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WiTangoGoodies.htm  Latest downloads & List Archives @ http://www.witango.ws