Hi Dave, Are you still actively sending out the newsletter? If so, maybe you could set up your own pop box to receive the bounces (this would depend on how you're sending the newsletter, you need contol -- if cfmail then set the failto attribute), then download them via your favorite email client (thunderbird or whatever) to your local box overnight or something. Then you copy them into a directory (on Windows they are automatically converted to .eml text files when you do this), then ftp them as text files up to your server and use cfdirectory to loop over the files, parse out the email addresses and update your db. That way you don't have to worry about cfpop.
It will still take a long time to move all the files around but probably way faster than cfpopping each one. I had to do something similar recently, although it was more like 300 emails than 10,000, it worked dandy. I also used Ray's getEmail function to parse out the email addresses. -- Josh ----- Original Message ----- From: "Dave Lyons" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, October 05, 2006 7:08 PM Subject: removing bad emails from bounced emails and db > yes I know we have gone over this before, sorta > > the deal is that we have a mailing list db that wasnt cleaned out for over > 8 years so there are like 10,000 no good emails in it. I made some script > to go in ang get the bounced emails, parse them for email addresses then > delete them from the list (checking the mail account with cfpop). > > The problem is that cfpop is so slow that it times out, i fixed that by > using forwarding the page to another page inbetween emails then > cflocation'n them back to start again but after awhile i get errors about > it not being able to forward the page. > The other problem is that it is god awefully slow, bout 30-40 seconds for > each email. > > So the situation really is this, this first batch of cleaning out is gunna > be a bitch for whomever does it, which they really dont want to do, so I > am looking to see if any of you know of any programs that can do it > effectively. > > Again, here is the problem. > They send a newsletter out and they will get about 10,000 bounced > addresses back and basically we just need to grab all those 10,000 emails > and delete them from mailing list. Although its not that simple but, do > any of you have anything or now of anything to effectively do it, doesnt > matter if it costs $$. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
