RE: [WebDNA] Generating Excel File Via WebDNA
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104654
interpreted = N
texte = Hi all, To bring closure to this thread ....unlike [Shell] on Unix, there is no [DOS] equivalent that is as straight forward as the archive indicated. On XP systems, you have to run alternative zip compression software and use their command line capability to achieve zipping and it is not'zip -r path path'. You cannot use the built-in Zip capability on XP either ....real bummer. On W2003, the same as XP. However, there is a command line equivalent to achieve zipping and that is 'compress'. Have not tried it because I test and develop on XP Pro before uploading to W2003 server ...and I had no desire to muck around with different ways on 2 OS ...I wanted a common solution to both. In essence, you need to install a secondary zip compression software with command line capability. Now for the poor man's version to this problem on XP or W2003 ...yes there is one ....output the DB extract as an Excel generated HTML file. Yes, prepare your layout on Excel, save the file as HTML, use that saved file as the template for extracting and adding the data (the WebDNA template so to speak for WriteFile) ...adding the records row by row via WebDNA (Search - Founditems). Then, save the file as .xls ....point to it and it will download and launch in Excel when run. Basically ...IE browser was looking for this in the file to allow the download to work even though it was not a true blue xls file.... [quote]
[/quote] Just that bit included in the file, bypasses IE security blocks for xls file that are not true xls files but postfix changes only. It works so I am cool for now until MS decides to block that as well. Anyway, just for info ...there is a PHP script that actually rights and export Excel files that play nice for download and use. Sadly, none for WebDNA but I am sure some genius out there will eventually get round to it ...;-) Cheers all and thanks for trying to help ....TDn -----Original Message----- From: Kenneth Grome [mailto:kengrome@gmail.com] Sent: Saturday, January 30, 2010 23:21 To: talk@webdna.us Subject: Re: [WebDNA] Generating Excel File Via WebDNA Any idea what the [DOS]...[/DOS] zip command to use? I have no idea, but I'm sure someone else will. Or do a google search and you're likely to find a solution ... :) Sincerely, Kenneth Grome www.KenGrome.com ---------------------------- Hi Ken, Any idea what the [DOS]...[/DOS] zip command to use? Cheers TDn -----Original Message----- From: Kenneth Grome [mailto:kengrome@gmail.com] Sent: Saturday, January 30, 2010 13:22 To: talk@webdna.us Subject: Re: [WebDNA] Generating Excel File Via WebDNA 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 ---------------------------------------------------------
Associated Messages, from the most recent to the oldest:
Hi all, To bring closure to this thread ....unlike
[shell] on Unix, there is no
[DOS] equivalent that is as straight forward as the archive indicated. On XP systems, you have to run alternative zip compression software and use their command line capability to achieve zipping and it is not'zip -r path path'. You cannot use the built-in Zip capability on XP either ....real bummer. On W2003, the same as XP. However, there is a command line equivalent to achieve zipping and that is 'compress'. Have not tried it because I test and develop on XP Pro before uploading to W2003 server ...and I had no desire to muck around with different ways on 2 OS ...I wanted a common solution to both. In essence, you need to install a secondary zip compression software with command line capability. Now for the poor man's version to this problem on XP or W2003 ...yes there is one ....output the DB extract as an Excel generated HTML file. Yes, prepare your layout on Excel, save the file as HTML, use that saved file as the template for extracting and adding the data (the WebDNA template so to speak for WriteFile) ...adding the records row by row via WebDNA (Search - Founditems). Then, save the file as .xls ....point to it and it will download and launch in Excel when run. Basically ...IE browser was looking for this in the file to allow the download to work even though it was not a true blue xls file.... [quote]
[/quote] Just that bit included in the file, bypasses IE security blocks for xls file that are not true xls files but postfix changes only. It works so I am cool for now until MS decides to block that as well. Anyway, just for info ...there is a PHP script that actually rights and export Excel files that play nice for download and use. Sadly, none for WebDNA but I am sure some genius out there will eventually get round to it ...;-) Cheers all and thanks for trying to help ....TDn -----Original Message----- From: Kenneth Grome [mailto:kengrome@gmail.com] Sent: Saturday, January 30, 2010 23:21 To: talk@webdna.us Subject: Re: [WebDNA] Generating Excel File Via WebDNA Any idea what the
[DOS]...[/DOS] zip command to use? I have no idea, but I'm sure someone else will. Or do a google search and you're likely to find a solution ... :) Sincerely, Kenneth Grome www.KenGrome.com ---------------------------- Hi Ken, Any idea what the
[DOS]...[/DOS] zip command to use? Cheers TDn -----Original Message----- From: Kenneth Grome [mailto:kengrome@gmail.com] Sent: Saturday, January 30, 2010 13:22 To: talk@webdna.us Subject: Re: [WebDNA] Generating Excel File Via WebDNA 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 ---------------------------------------------------------
"Terry Nair"
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:
math on date? (1997)
Using Plug-In while running 1.6.1 (1997)
New Weird Behavior (bug report) (2000)
PIXO support (1997)
Creating comums (1998)
name of file (2002)
Location of Browser Info.txt file (1997)
WebCommerce: Folder organization ? (1997)
WebDNA Solutions ... sorry! (1997)
Smith Micro - no competition (2000)
Help!!!! (1997)
WebCatalog Beta Documentation (1997)
FW: WebDNA-Talk searchable? (1997)
Deleting Orders (1997)
Is a cart really unique? (2002)
price carry over (1997)
FileMaker Pro (1999)
Am I going senile? (Price recalc based on quantity) (1997)
Resume Catalog ? (1997)
Switching from merge to tab delimited..(v 2.x) (2000)