Re: [WebDNA] Generating Excel File Via WebDNA

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104665
interpreted = N
texte = we use returnraw [ReturnRaw binarybody=3D../db/[database].db]HTTP/1.0 200 = OK[unurl]%0D%0A[/unurl]Content-type: = application/vnd.ms-excel[unurl]%0D%0A[/unurl]Content-Disposition: = attachment; filename=3D"[database].xls"[unurl]%0D%0A%0D%0A[/unurl][include= file=3D../db/[database].db][/ReturnRaw] On 1 Feb 2010, at 03:48, Stuart Tremain wrote: > I had the same problem on w2003 server & IE. >=20 > I just changed to .csv extension and all worked 100%, just make sure = that client knows to open in Excel. >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 30/01/2010, at 12:21 PM, Terry Nair wrote: >=20 >> Hi all, >>=20 >> Got a client that wants to extract a range of data from an existing = WebDNA >> DB server ...not an issue. He wants the data extracted to be an Excel = file >> that shows up as a link which allows him to click and download the = file via >> his browser. >>=20 >> OK, from the archives ...it was stated that the extracted file saved = in >> tab-delimited format and named xxx.xls will do the trick of getting = the file >> to open in Excel after download. Yes that is true ...after a warning = popping >> up in Excel about format issues ...but it works. >>=20 >> Here is the problem ...downloading the file via a link does not work. = Simply >> pointing it to xxx.xls on the server causes the download to never = start with >> warning boxes popping up on IE stating so. Remember, the xxx.xls is = actually >> a tab-delimited file. However, if the xxx.xls file was converted into = an >> actual Excel XLS file ...the download link works and is allowed to = proceed. >>=20 >> This appears to be an IE thingy that checks the file type before >> downloading. It appears you cannot trick IE to download a file that = is not >> an actual Excel file even though it has the correct postfix. >>=20 >> So ...anyone can propose a solution for me to pursue ...simple = requirement >> ...extract data from WebDNA DB, save it as Excel with a link for = download >> that works (not blocked by IE). >>=20 >> Many thanks ...Terry Nair >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Generating Excel File Via WebDNA (Govinda 2010)
  2. Re: [WebDNA] Generating Excel File Via WebDNA (Toby Cox 2010)
  3. Re: [WebDNA] Generating Excel File Via WebDNA (Stuart Tremain 2010)
  4. Re: [WebDNA] Generating Excel File Via WebDNA (Bob Minor 2010)
  5. RE: [WebDNA] Generating Excel File Via WebDNA ("Terry Nair" 2010)
  6. Re: [WebDNA] Generating Excel File Via WebDNA (Kenneth Grome 2010)
  7. Re: [WebDNA] Generating Excel File Via WebDNA (Kenneth Grome 2010)
  8. Re: [WebDNA] Generating Excel File Via WebDNA (Dan Strong 2010)
  9. Re: [WebDNA] Generating Excel File Via WebDNA (Dan Strong 2010)
  10. RE: [WebDNA] Generating Excel File Via WebDNA ("Terry Nair" 2010)
  11. Re: [WebDNA] Generating Excel File Via WebDNA (Kenneth Grome 2010)
  12. Re: [WebDNA] Generating Excel File Via WebDNA (Govinda 2010)
  13. [WebDNA] Generating Excel File Via WebDNA ("Terry Nair" 2010)
we use returnraw [ReturnRaw binarybody=3D../db/[database].db]HTTP/1.0 200 = OK[unurl]%0D%0A[/unurl]Content-type: = application/vnd.ms-excel[unurl]%0D%0A[/unurl]Content-Disposition: = attachment; filename=3D"[database].xls"[unurl]%0D%0A%0D%0A[/unurl][include= file=3D../db/[database].db][/ReturnRaw] On 1 Feb 2010, at 03:48, Stuart Tremain wrote: > I had the same problem on w2003 server & IE. >=20 > I just changed to .csv extension and all worked 100%, just make sure = that client knows to open in Excel. >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 30/01/2010, at 12:21 PM, Terry Nair wrote: >=20 >> Hi all, >>=20 >> Got a client that wants to extract a range of data from an existing = WebDNA >> DB server ...not an issue. He wants the data extracted to be an Excel = file >> that shows up as a link which allows him to click and download the = file via >> his browser. >>=20 >> OK, from the archives ...it was stated that the extracted file saved = in >> tab-delimited format and named xxx.xls will do the trick of getting = the file >> to open in Excel after download. Yes that is true ...after a warning = popping >> up in Excel about format issues ...but it works. >>=20 >> Here is the problem ...downloading the file via a link does not work. = Simply >> pointing it to xxx.xls on the server causes the download to never = start with >> warning boxes popping up on IE stating so. Remember, the xxx.xls is = actually >> a tab-delimited file. However, if the xxx.xls file was converted into = an >> actual Excel XLS file ...the download link works and is allowed to = proceed. >>=20 >> This appears to be an IE thingy that checks the file type before >> downloading. It appears you cannot trick IE to download a file that = is not >> an actual Excel file even though it has the correct postfix. >>=20 >> So ...anyone can propose a solution for me to pursue ...simple = requirement >> ...extract data from WebDNA DB, save it as Excel with a link for = download >> that works (not blocked by IE). >>=20 >> Many thanks ...Terry Nair >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 Toby Cox

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:

WebCat2.0b15-to many nested [xx] tags (1997) [WebDNA] [data] and RETS (2009) search engine friendly URLS (Mac) (1998) [SearchString] usage (1997) project (1998) Options for http uploading of files (1999) [BULK] [WebDNA] triggers.db "next execute" fails to update (2012) Help! WebCat2 bug (1997) strange problem listfiles and movefile (2000) WebCatalog Use Question (1997) mass mailing (1998) Integration with SQL (1997) Searching for foreign chars (2004) Major Security Hole IIS NT (1998) Re:quit command on NT (1997) WebDNA Solutions ... sorry! (1997) WebCat NT v. Mac (1997) Pipes instead of tabs (1998) Stop page auto. refreshing (2004) syntax question, not in online refernce (1997)