Re: email database file
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62130
interpreted = N
texte = I am going to take a stab at this. My first question is why not install WebCat 4.5? If that is not an option, which I will assume it is not since you have not done that, then we try other solutions. You could send a link in the email to a copy of the DB that has been renamed to something like database.txt. This would allow you to download the txt version with all tabs in place. You could also create a comma seperated version of the DB in the body of the email. This would then email you a comma seperated version that will copy and paste straight into Excel. I will think on this and see if I can come up with another solution. But will either of these work? Ron ----- Original Message ----- From: "paul"
To: "WebDNA Talk" Sent: Sunday, June 05, 2005 11:01 AM Subject: Re: email database file > Unfortunately it does not work, I have webcat 4 so the encrypt does not > work > here > > Help appreciated > > Thanks > Paul > ----- Original Message ----- > From: "WebDna @ Inkblot Media" > To: "WebDNA Talk" > Sent: Sunday, June 05, 2005 6:36 PM > Subject: Re: email database file > > >> This should be all throughout the archives, but here is the code we use. >> >> [TEXT]line_ending=[UnURL]%0D%0A[/UnURL][/TEXT] >> >> [sendmail > to=ron@inkblotmedia.com&from=sales@inkblotmedia.com&subject=Sales >> Reports&Content-Type=multipart/mixed; >> boundary="1234abcd"&MIME-version=1.0][!] >> [/!]--1234abcd >> Content-Type: text/plain >> File attached. >> --1234abcd[!] >> [/!]Content-Type: text/plain; name="sales.db"[line_ending][!] >> [/!]Content-Transfer-Encoding: base64[line_ending][!] >> [/!]Content-Disposition: attachment; >> filename="sales.db"[line_ending][line_ending][!] >> [/!][encrypt >> > method=base64&file=sales.db&EMAILFORMAT=T][/encrypt][line_ending][line_endin > g][!] >> [/!]--1234abcd-- >> --1234abcd-- >> [/sendmail] >> >> Ron >> >> >> ----- Original Message ----- >> From: "paul" >> To: "WebDNA Talk" >> Sent: Sunday, June 05, 2005 8:31 AM >> Subject: Re: email database file >> >> >> > Hi Donavan >> > >> > When I hit the page I get the .db file sent to me as text in the email >> > rather than as an attachment, sorry I did not explain better in the >> > last >> > emaiul >> > >> > What do I specify in the sendmail tag to sent thsiu as a file? >> > >> > THanks >> > Paul >> > ----- Original Message ----- >> > From: "Donovan Brooke" >> > To: "WebDNA Talk" >> > Sent: Sunday, June 05, 2005 4:08 PM >> > Subject: Re: email database file >> > >> > >> >> paul wrote: >> >> > I need to write a trigger to email me the products.db file once a > week >> >> > >> >> > How would I do thsi and does anyone have an example I can work from >> >> > >> >> > Thanks >> >> > Paul >> >> >> >> Hi Paul, >> >> rather than counting on a trigger to initiate code at a given time, > count >> >> on your code within a page to initiate at a given time. This will > enable >> > you >> >> to run the trigger in a more frequent routine (about every hour) which >> > overcomes >> >> network problems. This is a philosophy about triggers that is often >> >> not >> > realized. >> >> >> >> I would do a .db that keeps track of the sent triggers and sets a >> >> check >> > flag >> >> each week when the code has been enacted. This criteria keeps the > second >> > hours >> >> trigger from enacting the code again for that new week. >> >> >> >> Donovan >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >> >> DONOVAN D. BROOKE Euca Design Center >> >> <-Web Development (specializing in eCommerce), -> >> >> <- Graphic Design, Custom Tags and Labels -> >> >> >> >> ADDRESS:> Donovan Brooke >> >> DBA Euca Design Center >> >> 1871 HWY MM >> >> Fitchburg, WI 53575 >> >> PH:> 1.608.835.2476 >> >> Web:> http://www.euca.us >> >> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >> >> >> >> ------------------------------------------------------------- >> >> 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://webdna.smithmicro.com/ >> >> >> > >> > >> > >> > ------------------------------------------------------------- >> > 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://webdna.smithmicro.com/ >> >> >> ------------------------------------------------------------- >> 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://webdna.smithmicro.com/ >> > > > > ------------------------------------------------------------- > 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://webdna.smithmicro.com/ ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I am going to take a stab at this. My first question is why not install WebCat 4.5? If that is not an option, which I will assume it is not since you have not done that, then we try other solutions. You could send a link in the email to a copy of the DB that has been renamed to something like database.txt. This would allow you to download the txt version with all tabs in place. You could also create a comma seperated version of the DB in the body of the email. This would then email you a comma seperated version that will copy and paste straight into Excel. I will think on this and see if I can come up with another solution. But will either of these work? Ron ----- Original Message ----- From: "paul" To: "WebDNA Talk" Sent: Sunday, June 05, 2005 11:01 AM Subject: Re: email database file > Unfortunately it does not work, I have webcat 4 so the encrypt does not > work > here > > Help appreciated > > Thanks > Paul > ----- Original Message ----- > From: "WebDna @ Inkblot Media" > To: "WebDNA Talk" > Sent: Sunday, June 05, 2005 6:36 PM > Subject: Re: email database file > > >> This should be all throughout the archives, but here is the code we use. >> >> [text]line_ending=[unurl]%0D%0A[/UnURL][/TEXT] >> >> [sendmail > to=ron@inkblotmedia.com&from=sales@inkblotmedia.com&subject=Sales >> Reports&Content-Type=multipart/mixed; >> boundary="1234abcd"&MIME-version=1.0][!] >> [/!]--1234abcd >> Content-Type: text/plain >> File attached. >> --1234abcd[!] >> [/!]Content-Type: text/plain; name="sales.db"[line_ending][!] >> [/!]Content-Transfer-Encoding: base64[line_ending][!] >> [/!]Content-Disposition: attachment; >> filename="sales.db"[line_ending][line_ending][!] >> [/!][encrypt >> > method=base64&file=sales.db&EMAILFORMAT=T][/encrypt][line_ending][line_endin > g][!] >> [/!]--1234abcd-- >> --1234abcd-- >> [/sendmail] >> >> Ron >> >> >> ----- Original Message ----- >> From: "paul" >> To: "WebDNA Talk" >> Sent: Sunday, June 05, 2005 8:31 AM >> Subject: Re: email database file >> >> >> > Hi Donavan >> > >> > When I hit the page I get the .db file sent to me as text in the email >> > rather than as an attachment, sorry I did not explain better in the >> > last >> > emaiul >> > >> > What do I specify in the sendmail tag to sent thsiu as a file? >> > >> > THanks >> > Paul >> > ----- Original Message ----- >> > From: "Donovan Brooke" >> > To: "WebDNA Talk" >> > Sent: Sunday, June 05, 2005 4:08 PM >> > Subject: Re: email database file >> > >> > >> >> paul wrote: >> >> > I need to write a trigger to email me the products.db file once a > week >> >> > >> >> > How would I do thsi and does anyone have an example I can work from >> >> > >> >> > Thanks >> >> > Paul >> >> >> >> Hi Paul, >> >> rather than counting on a trigger to initiate code at a given time, > count >> >> on your code within a page to initiate at a given time. This will > enable >> > you >> >> to run the trigger in a more frequent routine (about every hour) which >> > overcomes >> >> network problems. This is a philosophy about triggers that is often >> >> not >> > realized. >> >> >> >> I would do a .db that keeps track of the sent triggers and sets a >> >> check >> > flag >> >> each week when the code has been enacted. This criteria keeps the > second >> > hours >> >> trigger from enacting the code again for that new week. >> >> >> >> Donovan >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >> >> DONOVAN D. BROOKE Euca Design Center >> >> <-Web Development (specializing in eCommerce), -> >> >> <- Graphic Design, Custom Tags and Labels -> >> >> >> >> ADDRESS:> Donovan Brooke >> >> DBA Euca Design Center >> >> 1871 HWY MM >> >> Fitchburg, WI 53575 >> >> PH:> 1.608.835.2476 >> >> Web:> http://www.euca.us >> >> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >> >> >> >> ------------------------------------------------------------- >> >> 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://webdna.smithmicro.com/ >> >> >> > >> > >> > >> > ------------------------------------------------------------- >> > 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://webdna.smithmicro.com/ >> >> >> ------------------------------------------------------------- >> 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://webdna.smithmicro.com/ >> > > > > ------------------------------------------------------------- > 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://webdna.smithmicro.com/ ------------------------------------------------------------- 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://webdna.smithmicro.com/
"WebDna @ Inkblot Media"
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:
Trigger: Only on Saturday (2001)
Sort Order on a page search (1997)
A Global Variable (1997)
Errata: WCS Newbie question (1997)
Emailer setup (1997)
hmmm (2006)
[ModDate] & [ModTime] ? (1997)
autocommit problem (1998)
Security (1998)
PCS Frames (1997)
Ticket Ordering Question (2003)
Date subtraction (2002)
Failed SQL Query (2005)
New command suggestion (1997)
Help with Repost Data msg from form (1997)
Cookies (1998)
numfound=0 for a search after going into the SSL (2003)
Strange Question (2003)
Searching for (field1 OR field2) AND field3 (2000)
2.1b2 was SLOW ... but 2.1b3 is FAST! (1997)