RE: Removing bad emails from newsletter db
Blood, It's fairly straight forward to code yourself. You can access the undeliverables folder using CFDIRECTORY and then parse the messages for the e-mail address that bounced and use that to update the database. If on MX I suggest using server.coldfusion.rootDir etc. to locate the undeliverable folder etc. On CF5 and Windows you can use CFREGISTRY etc. Note: the .cfmail file formats are different from CF5 to CFMX. Also, if you want to re-spool messages in CFMX you need to rename the file and restart the CF's mail spool service...which is technically possible to do programmatically using yet more undocumented functions. André -Original Message- From: Blood Python [mailto:[EMAIL PROTECTED] Sent: 28 May 2003 16:40 To: CF-Talk Subject: Removing bad emails from newsletter db One of my client's has about 103k people in his mailing list. He's running his website since 99 and many of these e-mails are bad ones. He wants me to remove the bad e-mails from this list. I used to do that using a software called worldcast, from fairlogic (www.fairlogic.com). It uses DNS to validate e-mails, pretending to send an e-mail and stopping just after he got the 250 code (user exists) or 550 (unknow). Unfortunatly, many networks are not allowing DNS sends, because of spam, so it its not a good solution anymore. I will need to build a tool that interprets the returned e-mails from an actual send (those Undeliverable e-mails) and delete the user based on this e-mail's content. Do you guys knows any software or code that do such thing? Doesn't need to be in cf... I will need to code it myself if i don't find something like that to use, because client needs it very bad (he needs to reduce bandwidth costs). Thank you for your repplies in advance. BP. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Removing bad emails from newsletter db
I have the same problem. I have thought up several possible ways, but there is no good answer that I know of. The best method that I have come up with is to assign a very identifiable ID to each email address and include it in the bottom of the email newsletter body. Then use outlook to check the return account and after about a week I will export the "bad address" folder to an access database. (Or any other client that will export to a file that can be imported to a database) Then do a search for the identifiable IDs and log them as a "strike". After a few newsletter sends the email that have constantly bounced "struck out" are bad. This should take account for temporary mail server failures, out of office replies, email account quota reached, etc... Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Blood Python [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 10:40 AM To: CF-Talk Subject: Removing bad emails from newsletter db One of my client's has about 103k people in his mailing list. He's running his website since 99 and many of these e-mails are bad ones. He wants me to remove the bad e-mails from this list. I used to do that using a software called worldcast, from fairlogic (www.fairlogic.com). It uses DNS to validate e-mails, pretending to send an e-mail and stopping just after he got the 250 code (user exists) or 550 (unknow). Unfortunatly, many networks are not allowing DNS sends, because of spam, so it its not a good solution anymore. I will need to build a tool that interprets the returned e-mails from an actual send (those Undeliverable e-mails) and delete the user based on this e-mail's content. Do you guys knows any software or code that do such thing? Doesn't need to be in cf... I will need to code it myself if i don't find something like that to use, because client needs it very bad (he needs to reduce bandwidth costs). Thank you for your repplies in advance. BP. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Removing bad emails from newsletter db
I've been very happy with a product called BoogieTools (http://boogietools.com/) It ties directly into the SQL database and can handle hundreds of different types of bounces. Managing a large list... it's been invaluable for dealing with bounced email. And... at $350, it was well worth the price, given the time it would've taken me to come up with something similar. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 11:51 AM To: CF-Talk Subject: RE: Removing bad emails from newsletter db Blood, It's fairly straight forward to code yourself. You can access the undeliverables folder using CFDIRECTORY and then parse the messages for the e-mail address that bounced and use that to update the database. If on MX I suggest using server.coldfusion.rootDir etc. to locate the undeliverable folder etc. On CF5 and Windows you can use CFREGISTRY etc. Note: the .cfmail file formats are different from CF5 to CFMX. Also, if you want to re-spool messages in CFMX you need to rename the file and restart the CF's mail spool service...which is technically possible to do programmatically using yet more undocumented functions. André -Original Message- From: Blood Python [mailto:[EMAIL PROTECTED] Sent: 28 May 2003 16:40 To: CF-Talk Subject: Removing bad emails from newsletter db One of my client's has about 103k people in his mailing list. He's running his website since 99 and many of these e-mails are bad ones. He wants me to remove the bad e-mails from this list. I used to do that using a software called worldcast, from fairlogic (www.fairlogic.com). It uses DNS to validate e-mails, pretending to send an e-mail and stopping just after he got the 250 code (user exists) or 550 (unknow). Unfortunatly, many networks are not allowing DNS sends, because of spam, so it its not a good solution anymore. I will need to build a tool that interprets the returned e-mails from an actual send (those Undeliverable e-mails) and delete the user based on this e-mail's content. Do you guys knows any software or code that do such thing? Doesn't need to be in cf... I will need to code it myself if i don't find something like that to use, because client needs it very bad (he needs to reduce bandwidth costs). Thank you for your repplies in advance. BP. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Removing bad emails from newsletter db
Have the e-mail come back to an address you pick up with cfpop.. then parse the e-mail for keywords.. such as 'Undeliverable' and 'not deliver' and 'delivery failure' and 'quota'.. and 'transient delivery failure' etc... -Zine -Original Message- From: Python Python [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 1:51 PM To: CF-Talk Subject: Removing bad emails from newsletter db Oops, i guess i do not make myself clear. I dont need to hangle those cfmail that goest o the undeliverable folder of CF, i need to handle those returned emails that bouces when the user does not exist(Errors returned by SMTP server, like 550, user unknow, mailbox full and so on). BP. >Blood, > >It's fairly straight forward to code yourself. > >You can access the undeliverables folder using CFDIRECTORY and then >parse the messages for the e-mail address that bounced and use that to >update the database. > >If on MX I suggest using server.coldfusion.rootDir etc. to locate the >undeliverable folder etc. > >On CF5 and Windows you can use CFREGISTRY etc. > >Note: the .cfmail file formats are different from CF5 to CFMX. > >Also, if you want to re-spool messages in CFMX you need to rename the >file and restart the CF's mail spool service...which is technically >possible to do programmatically using yet more undocumented functions. > >André > >-Original Message- >From: Blood Python [mailto:[EMAIL PROTECTED] >Sent: 28 May 2003 16:40 >To: CF-Talk >Subject: Removing bad emails from newsletter db > >One of my client's has about 103k people in his mailing list. He's >running >his website since 99 and many of these e-mails are bad ones. > >He wants me to remove the bad e-mails from this list. I used to do that >using a software called worldcast, from fairlogic (www.fairlogic.com). >It >uses DNS to validate e-mails, pretending to send an e-mail and stopping >just >after he got the 250 code (user exists) or 550 (unknow). > >Unfortunatly, many networks are not allowing DNS sends, because of spam, >so >it its not a good solution anymore. I will need to build a tool that >interprets the returned e-mails from an actual send (those Undeliverable > >e-mails) and delete the user based on this e-mail's content. > >Do you guys knows any software or code that do such thing? Doesn't need >to >be in cf... I will need to code it myself if i don't find something like > >that to use, because client needs it very bad (he needs to reduce >bandwidth >costs). > >Thank you for your repplies in advance. > >BP. > >_ >STOP MORE SPAM with the new MSN 8 and get 2 months FREE* >http://join.msn.com/?page=features/junkmail > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Removing bad emails from newsletter db
oi Blood!! have a gander at http://www.mach5.com mach5 mailer... Wednesday, May 28, 2003, 11:39:45 AM, you wrote: BP> One of my client's has about 103k people in his mailing list. He's running BP> his website since 99 and many of these e-mails are bad ones. BP> He wants me to remove the bad e-mails from this list. I used to do that BP> using a software called worldcast, from fairlogic (www.fairlogic.com). It BP> uses DNS to validate e-mails, pretending to send an e-mail and stopping just BP> after he got the 250 code (user exists) or 550 (unknow). BP> Unfortunatly, many networks are not allowing DNS sends, because of spam, so BP> it its not a good solution anymore. I will need to build a tool that BP> interprets the returned e-mails from an actual send (those Undeliverable BP> e-mails) and delete the user based on this e-mail's content. BP> Do you guys knows any software or code that do such thing? Doesn't need to BP> be in cf... I will need to code it myself if i don't find something like BP> that to use, because client needs it very bad (he needs to reduce bandwidth BP> costs). BP> Thank you for your repplies in advance. BP> BP. BP> _ BP> STOP MORE SPAM with the new MSN 8 and get 2 months FREE* BP> http://join.msn.com/?page=features/junkmail BP> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Removing bad emails from newsletter db
If you are interested only in people who read the mail and you send your mail as HTML, include a CFCONTENT'ed image in the HTML e.g http://server/[EMAIL PROTECTED]" height="1" width="1"> and then collect the email addresses found by your cfm and ditch the rest of them... Neil > -Original Message- > From: Python Python [mailto:[EMAIL PROTECTED] > Sent: 28 May 2003 20:24 > To: CF-Talk > Subject: Removing bad emails from newsletter db > > > Oi Critz, tudo bem? ;) > > The newsletters i send are highly customized, based on > customers past purchases, preferences and so on. Thus, i cant > use some of the desktop mailer tools available. > > Either way, have you tried WorldCast? Personaly, i think it > is much better than mach5. Just my thoughts. > > Regards. > > BP > > >oi Blood!! > > > >have a gander at http://www.mach5.com mach5 mailer... > > > > > > > > > > > >Wednesday, May 28, 2003, 11:39:45 AM, you wrote: > > > >BP> One of my client's has about 103k people in his mailing > list. He's running > >BP> his website since 99 and many of these e-mails are bad ones. > > > >BP> He wants me to remove the bad e-mails from this list. I > used to do that > >BP> using a software called worldcast, from fairlogic (www.fairlogic.com). It >BP> uses DNS to validate e-mails, pretending to send an e-mail and stopping just >BP> after he got the 250 code (user exists) or 550 (unknow). > >BP> Unfortunatly, many networks are not allowing DNS sends, because of spam, so >BP> it its not a good solution anymore. I will need to build a tool that >BP> interprets the returned e-mails from an actual send (those Undeliverable >BP> e-mails) and delete the user based on this e-mail's content. > >BP> Do you guys knows any software or code that do such thing? Doesn't need to >BP> be in cf... I will need to code it myself if i don't find something like >BP> that to use, because client needs it very bad (he needs to reduce bandwidth >BP> costs). > >BP> Thank you for your repplies in advance. > >BP> BP. > >BP> _ >BP> STOP MORE SPAM with the new MSN 8 and get 2 months FREE* >BP> http://join.msn.com/?page=features/junkmail > >BP> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
