RE: Script to move email to from undelivr to spool?
Bobby (and anyone else)... Undelivrnator gets a list of all files in the undelivr folder. It loops over the list checking filename and datestamp against a database entry. If it finds that email filename and datestamp in the db, then it increments the count for it. If it doesn't find it, it inserts a record. After trying 3 times, it simply deletes the email. We have a scheduled task set to run every 12 hours on each of our web servers. Lastly we clear out the db entries on a rolling 90 day interval. Full disclosure, the email piece is based on SpoolMail by Ray Camden. http://undelivrnator.riaforge.org/ andy -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2008 5:14 PM To: cf-talk Subject: RE: Script to move email to from undelivr to spool? Really? No cfexecute solutions? tsk tsk cfexecute name=C:\windows\system32\cmd.exe arguments=/c move C:\coldfusion8\mail\undelivr\* C:\coldfusion8\mail\spool\ / Just setup a scheduled task to hit a page with that on it as often as you need. Of course... you are going to begin to collect emails that CF just can't send for whatever reason and will want to clean it out periodically. I can think of a few ways to handle it. One would be to loop the contents of undelivr into a database with a timestamp or a count to keep track of when or how many times it has been moved back to the spool in an attempt to send it. Delete the files after so many attempts (and the records) And again, have the whole process triggered by a scheduled task. Not sure if Andy's Undelivrnator handles it that way but I plan to find out since we need to do something like this at work soon. :-) ...:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: sachin chawla [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2008 8:02 AM To: cf-talk Subject: Re: Script to move email to from undelivr to spool? Hi Nick try this cfparam name=directorypath default=C:\CFusionMX7\Mail\Undelivr\ cfdirectory directory=#directorypath# name=myDirectory action=list cfoutput#myDirectory.RecordCount#/cfoutput cfif #myDirectory.RecordCount# gt 0 cfoutput query=mydirectory cfif #type# EQ File cffile action=move source=#directorypath##name# destination=C:\CFusionMX7\Mail\Spool /cfif /cfoutput /cfif and add a schedular in the cold fusion administrator. Still apart from this we have another alternative of using Directory watcher Events, which do not need a schedular, they are invoked automatically when a new file comes to the undeliver folder. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Script to move email to from undelivr to spool?
BTW...I meant we as in Dealerskins. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2008 8:25 AM To: cf-talk Subject: RE: Script to move email to from undelivr to spool? Bobby (and anyone else)... Undelivrnator gets a list of all files in the undelivr folder. It loops over the list checking filename and datestamp against a database entry. If it finds that email filename and datestamp in the db, then it increments the count for it. If it doesn't find it, it inserts a record. After trying 3 times, it simply deletes the email. We have a scheduled task set to run every 12 hours on each of our web servers. Lastly we clear out the db entries on a rolling 90 day interval. Full disclosure, the email piece is based on SpoolMail by Ray Camden. http://undelivrnator.riaforge.org/ andy -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2008 5:14 PM To: cf-talk Subject: RE: Script to move email to from undelivr to spool? Really? No cfexecute solutions? tsk tsk cfexecute name=C:\windows\system32\cmd.exe arguments=/c move C:\coldfusion8\mail\undelivr\* C:\coldfusion8\mail\spool\ / Just setup a scheduled task to hit a page with that on it as often as you need. Of course... you are going to begin to collect emails that CF just can't send for whatever reason and will want to clean it out periodically. I can think of a few ways to handle it. One would be to loop the contents of undelivr into a database with a timestamp or a count to keep track of when or how many times it has been moved back to the spool in an attempt to send it. Delete the files after so many attempts (and the records) And again, have the whole process triggered by a scheduled task. Not sure if Andy's Undelivrnator handles it that way but I plan to find out since we need to do something like this at work soon. :-) :.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: sachin chawla [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2008 8:02 AM To: cf-talk Subject: Re: Script to move email to from undelivr to spool? Hi Nick try this cfparam name=directorypath default=C:\CFusionMX7\Mail\Undelivr\ cfdirectory directory=#directorypath# name=myDirectory action=list cfoutput#myDirectory.RecordCount#/cfoutput cfif #myDirectory.RecordCount# gt 0 cfoutput query=mydirectory cfif #type# EQ File cffile action=move source=#directorypath##name# destination=C:\CFusionMX7\Mail\Spool /cfif /cfoutput /cfif and add a schedular in the cold fusion administrator. Still apart from this we have another alternative of using Directory watcher Events, which do not need a schedular, they are invoked automatically when a new file comes to the undeliver folder. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315019 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Script to move email to from undelivr to spool?
Really? No cfexecute solutions? tsk tsk cfexecute name=C:\windows\system32\cmd.exe arguments=/c move C:\coldfusion8\mail\undelivr\* C:\coldfusion8\mail\spool\ / Just setup a scheduled task to hit a page with that on it as often as you need. Of course... you are going to begin to collect emails that CF just can't send for whatever reason and will want to clean it out periodically. I can think of a few ways to handle it. One would be to loop the contents of undelivr into a database with a timestamp or a count to keep track of when or how many times it has been moved back to the spool in an attempt to send it. Delete the files after so many attempts (and the records) And again, have the whole process triggered by a scheduled task. Not sure if Andy's Undelivrnator handles it that way but I plan to find out since we need to do something like this at work soon. :-) ..:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: sachin chawla [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2008 8:02 AM To: cf-talk Subject: Re: Script to move email to from undelivr to spool? Hi Nick try this cfparam name=directorypath default=C:\CFusionMX7\Mail\Undelivr\ cfdirectory directory=#directorypath# name=myDirectory action=list cfoutput#myDirectory.RecordCount#/cfoutput cfif #myDirectory.RecordCount# gt 0 cfoutput query=mydirectory cfif #type# EQ File cffile action=move source=#directorypath##name# destination=C:\CFusionMX7\Mail\Spool /cfif /cfoutput /cfif and add a schedular in the cold fusion administrator. Still apart from this we have another alternative of using Directory watcher Events, which do not need a schedular, they are invoked automatically when a new file comes to the undeliver folder. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314977 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Script to move email to from undelivr to spool?
Thanks bobby! Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314981 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Script to move email to from undelivr to spool?
I simply use this: cfdirectory directory=undelivr action=list name=undelivr cfoutput query=undelivrcffile action=move destination=spool\#undelivr.name# source=undelivr\#undelivr.name# /cfoutput replace undelivr and spool with your actual undelivr and spool directories. Run as often as you deem nec. Remember to run it seperately on all undelivr directories (for instance if you are load balancing you may have one on ever server you load balance). Create a cfm file with the above and schedule it using the task scheduler. If you have received this message multiple times please excuse me, I keep trying to post this and it says it posted but then I don't see anything on the list, perhaps there's a delay I'm not aware of. My project, the Undelivrnator, can be used for this: http://undelivrnator.riaforge.org/ Simply set up a scheduled task, a table in the db to use as a monitor, and you're good to go. andy Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck. Does anyone know if such a script is already built and available? Thanks in advance, Nick Hi i have another option to implement the same below is the code: cfparam name=directorypath default=C:\CFusionMX7\Mail\Undelivr\ cfdirectory directory=#directorypath# name=myDirectory action=list cfoutput#myDirectory.RecordCount#/cfoutput cfif #myDirectory.RecordCount# gt 0 cfoutput query=mydirectory cfif #type# EQ File cffile action=move source=#directorypath##name# destination=C:\CFusionMX7\Mail\Spool /cfif /cfoutput /cfif But still for such type of code we need to depend on the schedulars in cold fusion. In order to perform a more better way we have Directory watcher events, which are called automatically in case a new mail comes to the undeliver folder. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Script to move email to from undelivr to spool?
Hi Nick try this cfparam name=directorypath default=C:\CFusionMX7\Mail\Undelivr\ cfdirectory directory=#directorypath# name=myDirectory action=list cfoutput#myDirectory.RecordCount#/cfoutput cfif #myDirectory.RecordCount# gt 0 cfoutput query=mydirectory cfif #type# EQ File cffile action=move source=#directorypath##name# destination=C:\CFusionMX7\Mail\Spool /cfif /cfoutput /cfif and add a schedular in the cold fusion administrator. Still apart from this we have another alternative of using Directory watcher Events, which do not need a schedular, they are invoked automatically when a new file comes to the undeliver folder. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Script to move email to from undelivr to spool?
My project, the Undelivrnator, can be used for this: http://undelivrnator.riaforge.org/ Simply set up a scheduled task, a table in the db to use as a monitor, and you're good to go. andy -Original Message- From: Nick Gleason [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2008 7:27 AM To: cf-talk Subject: Script to move email to from undelivr to spool? Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck. Does anyone know if such a script is already built and available? Thanks in advance, Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Script to move email to from undelivr to spool?
I simply use this: cfdirectory directory=undelivr action=list name=undelivr cfoutput query=undelivrcffile action=move destination=spool\#undelivr.name# source=undelivr\#undelivr.name# /cfoutput replace undelivr and spool with your actual undelivr and spool directories. Run as often as you deem nec. Remember to run it seperately on all undelivr directories (for instance if you are load balancing you may have one on ever server you load balance). Create a cfm file with the above and schedule it using the task scheduler. My project, the Undelivrnator, can be used for this: http://undelivrnator.riaforge.org/ Simply set up a scheduled task, a table in the db to use as a monitor, and you're good to go. andy Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck. Does anyone know if such a script is already built and available? Thanks in advance, Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Script to move email to from undelivr to spool?
I simply use this: cfdirectory directory=undelivr action=list name=undelivr cfoutput query=undelivrcffile action=move destination=spool\#undelivr.name# source=undelivr\#undelivr.name# /cfoutput replace undelivr and spool with your actual undelivr and spool directories. Run as often as you deem nec. Remember to run it seperately on all undelivr directories (for instance if you are load balancing you may have one on ever server you load balance). Create a cfm file with the above and schedule it using the task scheduler. If you have received this message multiple times please excuse me, I keep trying to post this and it says it posted but then I don't see anything on the list, perhaps there's a delay I'm not aware of. My project, the Undelivrnator, can be used for this: http://undelivrnator.riaforge.org/ Simply set up a scheduled task, a table in the db to use as a monitor, and you're good to go. andy Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck. Does anyone know if such a script is already built and available? Thanks in advance, Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Script to move email to from undelivr to spool?
Paydirt! Thanks for all the feedback! -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2008 9:31 AM To: cf-talk Subject: RE: Script to move email to from undelivr to spool? My project, the Undelivrnator, can be used for this: http://undelivrnator.riaforge.org/ Simply set up a scheduled task, a table in the db to use as a monitor, and you're good to go. andy -Original Message- From: Nick Gleason [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2008 7:27 AM To: cf-talk Subject: Script to move email to from undelivr to spool? Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck. Does anyone know if such a script is already built and available? Thanks in advance, Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Script to move email to from undelivr to spool?
If you decide to use this project, let me know. It'd be nice to hear if anyone likes it, and finds it useful. -Original Message- From: Nick Gleason [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2008 1:30 PM To: cf-talk Subject: RE: Script to move email to from undelivr to spool? Paydirt! Thanks for all the feedback! -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2008 9:31 AM To: cf-talk Subject: RE: Script to move email to from undelivr to spool? My project, the Undelivrnator, can be used for this: http://undelivrnator.riaforge.org/ Simply set up a scheduled task, a table in the db to use as a monitor, and you're good to go. andy -Original Message- From: Nick Gleason [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2008 7:27 AM To: cf-talk Subject: Script to move email to from undelivr to spool? Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck. Does anyone know if such a script is already built and available? Thanks in advance, Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Script to move email to from undelivr to spool?
Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck. Does anyone know if such a script is already built and available? Thanks in advance, Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314790 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Script to move email to from undelivr to spool?
What platform are you on, and what is the criteria needed to move the messages? Speeves On 11/3/08, Nick Gleason [EMAIL PROTECTED] wrote: Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck. Does anyone know if such a script is already built and available? Thanks in advance, Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314791 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Script to move email to from undelivr to spool?
This might give you some ideas http://www.coldfusionjedi.com/index.cfm/2006/1/16/Yet-another-project--announcing-SpoolMail you can manage your undelivered emails from within CFIDE On Mon, Nov 3, 2008 at 10:27 PM, Nick Gleason [EMAIL PROTECTED]wrote: Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck. Does anyone know if such a script is already built and available? Thanks in advance, Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314792 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Script to move email to from undelivr to spool?
Shannon, Hey there. We're on IIS. But I was imagining that this would be a CF file run by scheduled task once a day or so. However, I'm open to other approaches as well. Nick -Original Message- From: Shannon Peevey [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2008 8:11 PM To: cf-talk Subject: Re: Script to move email to from undelivr to spool? What platform are you on, and what is the criteria needed to move the messages? Speeves On 11/3/08, Nick Gleason [EMAIL PROTECTED] wrote: Hi folks, We need to develop a script that can move mail from the undelivr folder to the spool folder in CF. My recollection is that there was some talk on this board a while back about this issue and maybe that a script had been developed. I checked the archives and riaforge with no luck. Does anyone know if such a script is already built and available? Thanks in advance, Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Script to move email to from undelivr to spool?
Hey there. We're on IIS. But I was imagining that this would be a CF file run by scheduled task once a day or so. However, I'm open to other approaches as well. Why not just write a batch file and schedule that using the Windows scheduler? That would likely be far more efficient. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
