Re: Filemaker Pro Template for Orders

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 25038
interpreted = N
texte = Hi John:Thanks John for the tip...for some reason I forgot that I could use append as a context. This was much simpler than I imagined. However, I have one remaining question.Currently, I am successfully capturing the customer information into a database via an append context. This includes name, address, etc. But, I would also like to capture what that person purchased and the amount they spent. Currently, on the thankyou page where I have placed the append context, it displays items purchased using [lineitems] items and amount information here [/lineitems]. So, I tried to place this within the [append] context like this:&purchase=[lineitems][itempurchased][/lineitems]&totalspent=[grandtotal]But, this did not work. I think part of the trick is that I want to capture both single and multiple item purchases into one field in my capture database.Where am I going wrong?Tim> From: John Butler > You can use an [append] context. See the docs. You will be delighted to find > that you > can stuff your templates with loads of contexts all doing different things. > The basic > templates you got from general store is just a sample skeleton... you can > do LOTS > more... just need to familiarize yourself with webcat commands, contexts > (better to use > these over commands), and global tags... > > -John > > Timothy W. Killian wrote: > >> Thanks for the tip...but that leaves me with some additional questions: >> >>>> Have any of you created a Filemaker Pro file to import the standard WebCat >>>> Order file? Complete with real names of fields and all? If so, would you be >>>> willing to send me a copy of the template? >>>> >>>> Thanks... >> >>> Timothy you would be better writing all your orders to databases and >>> importing that. The orderfiles are great but they are still files, >>> you have much more flexibility with databases. >>> For example we write to 2 .dbs one has the shopper info with the >>> [cart] as key and the other has the products with [cart] again used >>> as a key. These 2 .dbs provide us with all the reporting we need. >>> >>> Micheal O Shea Email:micheal@com4u.ch >> >> I understand how to append information to a database. I am doing this on a >> different part of the web, where individuals can sign up for a mailing list >> and give us some information. >> >> Clearly, I would love to do this with my orders as well, capturing all >> information into a database so that I wouldn't have to get this info from >> the order file as you suggest. But, can I simply use the append command to >> write to a database at the same time I am using the shopping cart? >> >> Here is what confuses me. Currently, I am using the basic shopping cart that >> I took from the general store templates. The form already uses the hidden >> command showcart and purchase, and it is already calling the store db. >> Can I just additionally add a 2nd command to the same form, and call a 2nd >> db as well? How does this all work? >> >> Any help offered would be greatly appreciated. >> >> Tim >> >> ------------------------------------------------------------- >> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >> To end your Mail problems go to . >> >> 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 >> > > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 > ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Filemaker Pro Template for Orders (John Butler 1999)
  2. Re: Filemaker Pro Template for Orders (Nitai 1999)
  3. Re: Filemaker Pro Template for Orders (Timothy W. Killian 1999)
  4. Re: Filemaker Pro Template for Orders (John Butler 1999)
  5. Re: Filemaker Pro Template for Orders (Timothy W. Killian 1999)
  6. Re: Filemaker Pro Template for Orders (Michael O Shea 1999)
  7. Filemaker Pro Template for Orders (Timothy W. Killian 1999)
Hi John:Thanks John for the tip...for some reason I forgot that I could use append as a context. This was much simpler than I imagined. However, I have one remaining question.Currently, I am successfully capturing the customer information into a database via an append context. This includes name, address, etc. But, I would also like to capture what that person purchased and the amount they spent. Currently, on the thankyou page where I have placed the append context, it displays items purchased using [lineitems] items and amount information here [/lineitems]. So, I tried to place this within the [append] context like this:&purchase=[lineitems][itempurchased][/lineitems]&totalspent=[grandtotal]But, this did not work. I think part of the trick is that I want to capture both single and multiple item purchases into one field in my capture database.Where am I going wrong?Tim> From: John Butler > You can use an [append] context. See the docs. You will be delighted to find > that you > can stuff your templates with loads of contexts all doing different things. > The basic > templates you got from general store is just a sample skeleton... you can > do LOTS > more... just need to familiarize yourself with webcat commands, contexts > (better to use > these over commands), and global tags... > > -John > > Timothy W. Killian wrote: > >> Thanks for the tip...but that leaves me with some additional questions: >> >>>> Have any of you created a Filemaker Pro file to import the standard WebCat >>>> order file? Complete with real names of fields and all? If so, would you be >>>> willing to send me a copy of the template? >>>> >>>> Thanks... >> >>> Timothy you would be better writing all your orders to databases and >>> importing that. The orderfiles are great but they are still files, >>> you have much more flexibility with databases. >>> For example we write to 2 .dbs one has the shopper info with the >>> [cart] as key and the other has the products with [cart] again used >>> as a key. These 2 .dbs provide us with all the reporting we need. >>> >>> Micheal O Shea Email:micheal@com4u.ch >> >> I understand how to append information to a database. I am doing this on a >> different part of the web, where individuals can sign up for a mailing list >> and give us some information. >> >> Clearly, I would love to do this with my orders as well, capturing all >> information into a database so that I wouldn't have to get this info from >> the order file as you suggest. But, can I simply use the append command to >> write to a database at the same time I am using the shopping cart? >> >> Here is what confuses me. Currently, I am using the basic shopping cart that >> I took from the general store templates. The form already uses the hidden >> command showcart and purchase, and it is already calling the store db. >> Can I just additionally add a 2nd command to the same form, and call a 2nd >> db as well? How does this all work? >> >> Any help offered would be greatly appreciated. >> >> Tim >> >> ------------------------------------------------------------- >> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >> To end your Mail problems go to . >> >> 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 >> > > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 > ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Timothy W. Killian

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:

Repost: pulldown menu (2000) Running 2 two WebCatalog.acgi's (1996) Nested vs conditional (1997) Emailer Set Up (1997) Public beta 5 of WebCatalog 4.0 is now available (2000) WebCat2: Formulas.db question (1997) Re:2nd WebCatalog2 Feature Request (1996) Pithy questions on webcommerce & siteedit (1997) unsubscribe (2000) Carraige returns [sendmail] (2004) Configuring E-mail (1997) Re:Emailer and encryption (1997) Deleting Orders (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) SMSI (Scott) clues?? Bug fixes for next WebDNA release (2005) Two SynchThreads prefs (2000) Number of Feilds Passed to [append] (2000) Truncated value after space - refresh my memory.... (1997) What is the maximum record length? (1998) possible, WebCat2.0 and checkboxes-restated (1997)