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:
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)