Re: [WebDNA] Generating Excel File Via WebDNA

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104660
interpreted = N
texte = I had the same problem on w2003 server & IE. I just changed to .csv extension and all worked 100%, just make sure = that client knows to open in Excel. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 30/01/2010, at 12:21 PM, Terry Nair wrote: > 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 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)
I had the same problem on w2003 server & IE. I just changed to .csv extension and all worked 100%, just make sure = that client knows to open in Excel. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 30/01/2010, at 12:21 PM, Terry Nair wrote: > 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 Stuart Tremain

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:

Avery 5160 Mailing Labels (2003) can WC render sites out? (1997) disappearing SKU (etc.) fields (1998) Introduction/Tutorial/QuickStart (1997) Country & Ship-to address & other fields ? (1997) WebCat on 10.0.4 - iTools 6.0 (2001) [WebDNA] WebDNA 8.6 announced - New features (2018) Accepting credit cards (1997) Friday night shopping site joke (1997) [ShowCart] and GET vs. POST (1997) carriage returns in data (1997) Another question (1997) Max Record length restated as maybe bug (1997) NT License trade for Mac (2000) RE: WebCatalog2 for NT Beta Request (1997) Formulas.db + Users.db (1997) [Sum] function? (1997) [OT] RSS Feeds (2007) Word search (1997) RE: Sum of Quantities (1997)