Re: A little help on e-mail (HELP!!! :-) )
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18935
interpreted = N
texte = You said earlier that their email address was in a database. Is it in a database, or in the order file? What you describe below would imply the email address is in the shoppingcart order file. That is a different ball of wax!Once the customer hits the purchase button, you have a choice on how to process the purchase -- either with the command in the URL or a context on the thankyou page. Once the command/context is processed, the shopping cart is moved to another folder Orders. (and moved from there by WebMerchant if you use that). To be able to send email from a shopping cart, WebCat has to know which shopping cart and where it is. If the purchase hasn't been completed yet, a simple showcart gives access to [email] inside the cart. If the purchase has been completed, you'd have to know where the cart is and do an [orderfile] context to find the [email] value. So I'd recommend doing the purchase in a context after sending out the email so you know where the cart is for sure (ie webmerchant isn't munching it) (unless the email is what they are paying for, in which case you need to do web delivery techniques). If you have the [email] in a database, then other solutions are what you want. If it is in an orderfile, then the above techniques are the correct aproach.Good luck! Sandy> > >Perhaps I am approching this from the wrong view. Since I have no examples >to go by, and no references to this anywhere I can find. Here is the >concept of what I would need to do, and if anyone on the list can help me, >I will pay for your time: > >The database uses the standard WebCat Store setup. The database is set to >look up records only. Each record has an unique email field in it. >(called E-MAIL) It is set to go to the cart.tpl as a list. The cart.tpl is >set to go to the invoice.tpl, allowing the person searching to enter their >information. > >This is where I need to break from standard format: > >Example: If someone has 4 records selected and on their list, they enter >their information, and click on SUBMIT > >They go to the Thank you page... > >The four records are send to their respective E-MAIL addresses; The Thank >You e-mail goes to the e-mail address they have entered so they have a >record of the information requested. > >If anyone can help me with this, (I am totally lost, as I am most of the >time), I can send the .tpl files as they exist, or you can send me an >example, whatever works for you. > > >A note: > I would like to point out a minor thing to whoever has been >responding to me, regarding the reply below. You have a working knowledge >of this software, what appears to be simple to you, and indeed may be, yet >can be very complex to others. I have owed this software for some time >now, and have only recently come to understand the some of the basic >functions of it. It is very elegant software, and easy to use, (no >DUHHH's please), as long as one has some kind of working examples, or even >an idea of the internal process that the information in the d-base goes >through. > Your manual has been useless, I know must have been written by a >Tech., because it ranks up with the MSAccess manual, which no average >person can understand. I had to dig into this software and make it work >by trial and error. I do thank you for this information, and it will help >when I know where to put it in the .tpl files... > > >>Gotcha. Then my earlier answer is the one that works in this situation. >>It uses the [e-mail] field from your database in the [SendMail] context to >>send to a different person each time through the [FoundItems] loop. >> >>(Greatly simplified for clarity) >> >>[FoundItems] >>[SendMail to=[e-mail]] >>[/SendMail] >>[/FoundItems] >Mail to: jv1@ee.net >Visit my Page: http://www.web-maya.com > >Life IS what You Make it, so Make It GREAT! >In your pondering of life, remember: >1) Life is what happens, while you are making plans! >2) Life is what happens as we walk through eternity! >3) We are all one. > >
Associated Messages, from the most recent to the oldest:
You said earlier that their email address was in a database. Is it in a database, or in the
order file? What you describe below would imply the email address is in the shoppingcart
order file. That is a different ball of wax!Once the customer hits the purchase button, you have a choice on how to process the purchase -- either with the command in the URL or a context on the thankyou page. Once the command/context is processed, the shopping cart is moved to another folder Orders. (and moved from there by WebMerchant if you use that). To be able to send email from a shopping cart, WebCat has to know which shopping cart and where it is. If the purchase hasn't been completed yet, a simple showcart gives access to [email] inside the cart. If the purchase has been completed, you'd have to know where the cart is and do an
[orderfile] context to find the [email] value. So I'd recommend doing the purchase in a context after sending out the email so you know where the cart is for sure (ie webmerchant isn't munching it) (unless the email is what they are paying for, in which case you need to do web delivery techniques). If you have the [email] in a database, then other solutions are what you want. If it is in an orderfile, then the above techniques are the correct aproach.Good luck! Sandy> > >Perhaps I am approching this from the wrong view. Since I have no examples >to go by, and no references to this anywhere I can find. Here is the >concept of what I would need to do, and if anyone on the list can help me, >I will pay for your time: > >The database uses the standard WebCat Store setup. The database is set to >look up records only. Each record has an unique email field in it. >(called E-MAIL) It is set to go to the cart.tpl as a list. The cart.tpl is >set to go to the invoice.tpl, allowing the person searching to enter their >information. > >This is where I need to break from standard format: > >Example: If someone has 4 records selected and on their list, they enter >their information, and click on SUBMIT > >They go to the Thank you page... > >The four records are send to their respective E-MAIL addresses; The Thank >You e-mail goes to the e-mail address they have entered so they have a >record of the information requested. > >If anyone can help me with this, (I am totally lost, as I am most of the >time), I can send the .tpl files as they exist, or you can send me an >example, whatever works for you. > > >A note: > I would like to point out a minor thing to whoever has been >responding to me, regarding the reply below. You have a working knowledge >of this software, what appears to be simple to you, and indeed may be, yet >can be very complex to others. I have owed this software for some time >now, and have only recently come to understand the some of the basic >functions of it. It is very elegant software, and easy to use, (no >DUHHH's please), as long as one has some kind of working examples, or even >an idea of the internal process that the information in the d-base goes >through. > Your manual has been useless, I know must have been written by a >Tech., because it ranks up with the MSAccess manual, which no average >person can understand. I had to dig into this software and make it work >by trial and error. I do thank you for this information, and it will help >when I know where to put it in the .tpl files... > > >>Gotcha. Then my earlier answer is the one that works in this situation. >>It uses the [e-mail] field from your database in the
[sendmail] context to >>send to a different person each time through the
[founditems] loop. >> >>(Greatly simplified for clarity) >> >>
[founditems] >>[SendMail to=[e-mail]] >>[/SendMail] >>[/FoundItems] >Mail to: jv1@ee.net >Visit my Page: http://www.web-maya.com > >Life IS what You Make it, so Make It GREAT! >In your pondering of life, remember: >1) Life is what happens, while you are making plans! >2) Life is what happens as we walk through eternity! >3) We are all one. > >
Sandra L. Pitner
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:
BBEdit and WebCatalog 2.0? (1997)
I'm having trouble using [url][interpret][math] together inlookup (1997)
Crashing Server (2000)
Date Time Oddness (1999)
PIXO support (1997)
cybercash question (2000)
WebCatalog as a ListServ (1998)
Save Word/Excel Docs to Server (2002)
Generating Options for a Form. (1997)
Strange ThisURL under Linux (2000)
emailer settings and control questions (1997)
suffix mapping, use of cache, etc. (1997)
WebCat B13 Mac CGI -- Frames question (1997)
WebCat2final1 crashes (1997)
Web Catalog 2 demo (1997)
Caching [include] files ... (1997)
Simple Database close connection (2001)
RE: 2nd WebCatalog2 Feature Request (1996)
Cookies and WebCat?? (1999)
I have observed and I am gone. (1998)