Re: [WebDNA] Generating Excel File Via WebDNA
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104647
interpreted = N
texte = Why don't you just zip it? Sincerely, Kenneth Grome www.KenGrome.com > 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 >
Associated Messages, from the most recent to the oldest:
Why don't you just zip it? Sincerely, Kenneth Grome www.KenGrome.com > 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 >
Kenneth Grome
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:
FEW QUESTIONS (1997)
Search in 2 or more catalogs (1997)
OT-listserver stuff -WAS-webcat method for waiting (2000)
Showif -what am I missing??? (1999)
Webdna Email and Plesk Control Panel (2005)
Paths change questions ... (2004)
taxTotal, grandTotal (1997)
WebCat for mass emailings (1997)
[OT] Strange bounced message (2000)
Location of Webcat site in folder hierarchy (1997)
Showif probably dumb question (1997)
RE:math context ignores date prefs? (1998)
Where is eudora plugin? (1998)
WebCat2b12plugin - [search] is broken ... not! (1997)
Verify entry into a text field (2005)
frames & carts (1997)
Multiple prices (1997)
test 3 (2003)
Listfiles (2004)
[Webcat 2]Next (1997)