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:
WebCat2b13MacPlugIn - [include] (1997)
Protect vs Authenicate (1997)
A quickie question (1997)
Bug - 4.5 (2002)
Frames and WebCat (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
{Grouping} Docs (1999)
Running 2 two WebCatalog.acgi's (1996)
Price and Formula.db (2002)
SPAM (OT) (2004)
Help name our technology! (1997)
system crashes, event log (1997)
Am I going senile? (Price recalc based on quantity) (1997)
WebTen and WebCat (1997)
Weird error/limit - something amiss? (1997)
emailer (1997)
target=_blank and form variables (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
Date Formats (1997)
[WebDNA] example of copyfolder (2010)