Re: Help Encrypt/Decrypt eMail

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 46601
interpreted = N
texte = I copy the contents of a database or just the records I want (from a search/founditems) to a copy of the database that I then rename with the extension .xls. Have this happen after a secure login and then provide a link to the .xls file. They can then click to view it or right click and save target as.I use [cart] to generate a unique name for each copy of the database, something like:[search for all records or just the ones you want returned] [COPYFILE from=customer_report.db&to=databases/[cart].db] [founditems] [append db=databases/[cart].db][!] [/!]site=[url][site][/url][!] [/!]&ddate=[url][ddate][/url][!] [/!]&acct=[Url][acct][/Url][!] [/!]&name=[Url][name][/Url][!] [/!]&card=[Url][card][/Url][!] [/!]&amount=[Url][amount][/Url][!] [/!]&volume=[Url][volume][/Url][!] [/!]&marketer=[Url][marketer][/Url][!] [/!][/append] [/founditems] [/search] [COPYFILE from=databases/[cart].db&to=databases/[cart].xls] [deletefile file=databases/[cart].db] Click to view or right click to save this report (Excel Format)Where customer_report.db is just a copy of the .hdr file from the master database.Same idea as the .csv, but a little more user friendly for folks that don't understand how to import into Excel or don't want to mess with it. It's just a tab-delimited file as the original database is and will open up just fine in Excel without having to import the data in.GK> > > Joe R. Richardson wrote: > > I guess I must be dense, but I don't understand. I'll have to admit, I've > > just enough knowledge to be dangerous. Are you saying download the > > respective databases while connected via https? > > Relax, that's not possible to do with WebDNA - at least not if it's > configured properly. > > What you *can* do (and what I think Bob meant) is to create a download > data document that simply lists all the content of the database (as > html or plain text or whatver formatting you like) and make that > document available thorough http. > > Frank Nordberg > http://www.musicaviva.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:

    
  1. Re: Help Encrypt/Decrypt eMail (Joe R. Richardson 2003)
  2. Re: Help Encrypt/Decrypt eMail (Gary Krockover 2003)
  3. Re: Help Encrypt/Decrypt eMail (Joe R. Richardson 2003)
  4. Re: Help Encrypt/Decrypt eMail (Bob Minor 2003)
  5. Re: Help Encrypt/Decrypt eMail (Bob Minor 2003)
  6. Re: Help Encrypt/Decrypt eMail (Joe R. Richardson 2003)
  7. Re: Help Encrypt/Decrypt eMail (Frank Nordberg 2003)
  8. Re: Help Encrypt/Decrypt eMail (Joe R. Richardson 2003)
  9. Re: Help Encrypt/Decrypt eMail (Frank Nordberg 2003)
  10. Re: Help Encrypt/Decrypt eMail (Gary Krockover 2003)
  11. Re: Help Encrypt/Decrypt eMail (Bob Minor 2003)
  12. Re: Help Encrypt/Decrypt eMail (Frank Nordberg 2003)
  13. Re: Help Encrypt/Decrypt eMail (Bob Minor 2003)
  14. Re: Help Encrypt/Decrypt eMail (Joe R. Richardson 2003)
  15. Re: Help Encrypt/Decrypt eMail (Bob Minor 2003)
  16. Re: Help Encrypt/Decrypt eMail (Joe R. Richardson 2003)
  17. Re: Help Encrypt/Decrypt eMail (Bob Minor 2003)
  18. Help Encrypt/Decrypt eMail (Joe R. Richardson 2003)
I copy the contents of a database or just the records I want (from a search/founditems) to a copy of the database that I then rename with the extension .xls. Have this happen after a secure login and then provide a link to the .xls file. They can then click to view it or right click and save target as.I use [cart] to generate a unique name for each copy of the database, something like:[search for all records or just the ones you want returned] [COPYFILE from=customer_report.db&to=databases/[cart].db] [founditems] [append db=databases/[cart].db][!] [/!]site=[url][site][/url][!] [/!]&ddate=[url][ddate][/url][!] [/!]&acct=[url][acct][/Url][!] [/!]&name=[url][name][/Url][!] [/!]&card=[url][card][/Url][!] [/!]&amount=[url][amount][/Url][!] [/!]&volume=[url][volume][/Url][!] [/!]&marketer=[url][marketer][/Url][!] [/!][/append] [/founditems] [/search] [COPYFILE from=databases/[cart].db&to=databases/[cart].xls] [deletefile file=databases/[cart].db] [cart].xls>Click to view or right click to save this report (Excel Format)Where customer_report.db is just a copy of the .hdr file from the master database.Same idea as the .csv, but a little more user friendly for folks that don't understand how to import into Excel or don't want to mess with it. It's just a tab-delimited file as the original database is and will open up just fine in Excel without having to import the data in.GK> > > Joe R. Richardson wrote: > > I guess I must be dense, but I don't understand. I'll have to admit, I've > > just enough knowledge to be dangerous. Are you saying download the > > respective databases while connected via https? > > Relax, that's not possible to do with WebDNA - at least not if it's > configured properly. > > What you *can* do (and what I think Bob meant) is to create a download > data document that simply lists all the content of the database (as > html or plain text or whatver formatting you like) and make that > document available thorough http. > > Frank Nordberg > http://www.musicaviva.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/ Gary Krockover

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:

How to show via drop down menu? (2000) sort problems....bug or brain fart? (1997) Not really WebCat (1997) addlineitem (2000) search same field twice??? (1999) 2nd WebCatalog2 Feature Request (1996) [input] questions (1997) Newbie questions (1999) Simple way to create unique SKU (1997) [quantity] solved (1997) Total number (2004) Open Market's Transact & Macintosh (1998) Moment of Thanks (1997) Capitalize (2003) &summ=T >> numfound (2002) too many nested tags ... (1997) Netscape Communicator 4 (1997) &fieldsdir=ra truely random?? (2000) Webcatalog server support (1997) Emailer setup (1997)