Re: Bulk Email >>>>Any ideas?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37957
interpreted = N
texte = Adam,I did something similar to this, however my use as to update about 4 fieldsin every record in a 10,000 record database.What I did was to perform the search based on known criteria at the VERY TOPof the page. Meaning before the etc...Then, if the [numfound] was 0 I hide the meta refresh tag. If the resultswere anything nut 0 then the meta refresh tag reloaded the page in xxseconds.So create a field in the database for list_sent with a known default value- you can even leave it blank and search on that (guess what, you can usethis technique to load the field initially too!).So do the search at the top of the page, in the section do a[hideif [numfound]=0]
[/hideif]In your search you can also set a max items - or have that value in aninclude file that you have some other way for the user to set.Then send the message - I would also have that in an include file using anadmin interface for the customer - e.g. create a page that has a defaultnumber of emails to send at once, the refresh value, and the message. Youcould even set the date to send the email. You can store this in a database,or if you don't need archive copies, just write out an include with thecontent in [text] [/text] variables.Then, you could have a trigger that executes this page, loads the includefile, checks the date to match today's date, if matches finish execution, ifdoesn't match, quits then.Or if the user wants to execute the mailing himself, give him a page to copyand paste his message into, on submit it loads the sending page with themeta refresh. When the sending finishes, then reverse the process and reset thelist_sent field to 0 and clean up the sent mail folder (if you use theemailer app).The down side of this is that the user must leave the page open in order tocomplete the sending and clean up.Dale> From: Adam O'Connor
> Reply-To: (WebCatalog Talk)> Date: Thu, 16 Aug 2001 21:18:01> To: (WebCatalog Talk)> Subject: Bulk Email >>>>Any ideas?> > I am trying to control the amount of files that are written into the email> folder at one time. In addition, once the number has been reached continue> onto the next amount of files/emails to be written.> > Reason for doing this is, my client has around 5000 subscribers to his> mailing list and would like to have webcatalog perform the mailing in> segments, reducing the chance of server trouble. If possible the process> needs to be 'semi-automated', that is, either executed by a link, or> secondly, a trigger.> > I have thought of a number of possible scenarios to do this, but wanted some> input before diving in.> > -Adam O'Connor> -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Adam,I did something similar to this, however my use as to update about 4 fieldsin every record in a 10,000 record database.What I did was to perform the search based on known criteria at the VERY TOPof the page. Meaning before the etc...Then, if the [numfound] was 0 I hide the meta refresh tag. If the resultswere anything nut 0 then the meta refresh tag reloaded the page in xxseconds.So create a field in the database for list_sent with a known default value- you can even leave it blank and search on that (guess what, you can usethis technique to load the field initially too!).So do the search at the top of the page, in the section do a[hideif [numfound]=0] [/hideif]In your search you can also set a max items - or have that value in aninclude file that you have some other way for the user to set.Then send the message - I would also have that in an include file using anadmin interface for the customer - e.g. create a page that has a defaultnumber of emails to send at once, the refresh value, and the message. Youcould even set the date to send the email. You can store this in a database,or if you don't need archive copies, just write out an include with thecontent in [text] [/text] variables.Then, you could have a trigger that executes this page, loads the includefile, checks the date to match today's date, if matches finish execution, ifdoesn't match, quits then.Or if the user wants to execute the mailing himself, give him a page to copyand paste his message into, on submit it loads the sending page with themeta refresh. When the sending finishes, then reverse the process and reset thelist_sent field to 0 and clean up the sent mail folder (if you use theemailer app).The down side of this is that the user must leave the page open in order tocomplete the sending and clean up.Dale> From: Adam O'Connor > Reply-To: (WebCatalog Talk)> Date: Thu, 16 Aug 2001 21:18:01> To: (WebCatalog Talk)> Subject: Bulk Email >>>>Any ideas?> > I am trying to control the amount of files that are written into the email> folder at one time. In addition, once the number has been reached continue> onto the next amount of files/emails to be written.> > Reason for doing this is, my client has around 5000 subscribers to his> mailing list and would like to have webcatalog perform the mailing in> segments, reducing the chance of server trouble. If possible the process> needs to be 'semi-automated', that is, either executed by a link, or> secondly, a trigger.> > I have thought of a number of possible scenarios to do this, but wanted some> input before diving in.> > -Adam O'Connor> -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
dale
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[random] only for 1-100??? (1997)
rotating thumbnails (1997)
Checkboxes (1998)
WebCat2 beta 11 - new prefs ... (1997)
ISAPI WC6a and Windows 2003 Web Edition (2006)
Almost a there but..bye bye NetCloak (1997)
WebCatalog f2 Installation (1997)
PCS Frames-Default page is solution! (1997)
Advanced WebCat Guidelines - do they exist beyond docs (1999)
Netscape (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Anyone selling 4.5 NT License? (2003)
Why do extra quotation marks sometimes appear in my databases? (1998)
WebDNA 5.0 Questions (2003)
Error 11 (1996)
Weird cart problem (webcat 2.x) (2000)
2.0 Info (1997)
normal users.db calls ... (1998)
Return records from another (1997)
WebCat2 Append problem (B14Macacgi) (1997)