Re: [WebDNA] Generating Excel File Via WebDNA
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104645
interpreted = N
texte = something with [ReturnRaw] & Content-Type:? On Jan 29, 2010, at 6:21 PM, Terry Nair wrote: > Hi all, > > 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. > > 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. > > 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. > > 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. > > 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). > > Many thanks ...Terry Nair > > --------------------------------------------------------- > 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=topics&category=288 ------------ Govinda govinda.webdnatalk@gmail.com
Associated Messages, from the most recent to the oldest:
something with [returnraw] & Content-Type:? On Jan 29, 2010, at 6:21 PM, Terry Nair wrote: > Hi all, > > 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. > > 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. > > 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. > > 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. > > 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). > > Many thanks ...Terry Nair > > --------------------------------------------------------- > 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=topics&category=288 ------------ Govinda govinda.webdnatalk@gmail.com
Govinda
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:
Games (1998)
Upgrade on MacOSX 3.05 to 3.08 (2000)
Emailer problem (1998)
Multiple catalog databases and showcart (1997)
serial number generation (1997)
[WebDNA] ReturnRaw and binarybody (2013)
quantity minimum problem (1997)
Help name our technology! (1997)
Nutscrape Doesn't Render Right (2002)
ListFiles and .DS_Store (2004)
Can't Update records (1997)
[taxrate] question (1997)
Date search - yes or no (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
RE: URL too Long? (1997)
Help! WebCat2 bug (1997)
Emailer (WebCat2) (1997)
[url] (1997)
really wierd date stuff on NT (1997)
Webcatalog Future?!? - Was &fieldsdir=ra truely random?? (2000)