Re: [WebDNA] Generating Excel File Via WebDNA
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104655
interpreted = N
texte = I installed winzip on my server to do this: [dos]C:\winzip\wzzip -rP D:\myarchives\myfile.zip C:\ArchiveThis\* [/dos] This command will create a zip archive on the D drive of the contents of = ArchiveThis from the C Drive. The file will be named. myfile.zip On Jan 30, 2010, at 9:52 AM, Terry Nair wrote: > Hi all, >=20 > 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. >=20 > 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. >=20 > 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. >=20 > 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.... >=20 > [quote] >=20 > xmlns:x=3D"urn:schemas-microsoft-com:office:excel" > xmlns=3D"http://www.w3.org/TR/REC-html40"> >=20 > >
>
>=20 > [/quote] >=20 > 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 ...;-) >=20 > Cheers all and thanks for trying to help ....TDn >=20 > -----Original Message----- > From: Kenneth Grome [mailto:kengrome@gmail.com]=20 > Sent: Saturday, January 30, 2010 23:21 > To: talk@webdna.us > Subject: Re: [WebDNA] Generating Excel File Via WebDNA >=20 > Any idea what the [DOS]...[/DOS] zip command to use? >=20 > I have no idea, but I'm sure someone else will. Or do a google search = and > you're likely to find a solution ... :) >=20 > Sincerely, > Kenneth Grome > www.KenGrome.com >=20 > ---------------------------- >=20 > Hi Ken, >=20 > Any idea what the [DOS]...[/DOS] zip command to use? >=20 > Cheers TDn >=20 > -----Original Message----- > From: Kenneth Grome [mailto:kengrome@gmail.com]=20 > Sent: Saturday, January 30, 2010 13:22 > To: talk@webdna.us > Subject: Re: [WebDNA] Generating Excel File Via WebDNA >=20 > Why don't you just zip it? >=20 > Sincerely, > Kenneth Grome > www.KenGrome.com > --------------------------------------- >=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 > --------------------------------------------------------- >=20 >=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:
I installed winzip on my server to do this: [DOS]C:\winzip\wzzip -rP D:\myarchives\myfile.zip C:\ArchiveThis\* [/dos] This command will create a zip archive on the D drive of the contents of = ArchiveThis from the C Drive. The file will be named. myfile.zip On Jan 30, 2010, at 9:52 AM, Terry Nair wrote: > Hi all, >=20 > 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. >=20 > 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. >=20 > 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. >=20 > 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.... >=20 > [quote] >=20 > xmlns:x=3D"urn:schemas-microsoft-com:office:excel" > xmlns=3D"http://www.w3.org/TR/REC-html40"> >=20 > > > >=20 > [/quote] >=20 > 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 ...;-) >=20 > Cheers all and thanks for trying to help ....TDn >=20 > -----Original Message----- > From: Kenneth Grome [mailto:kengrome@gmail.com]=20 > Sent: Saturday, January 30, 2010 23:21 > To: talk@webdna.us > Subject: Re: [WebDNA] Generating Excel File Via WebDNA >=20 > Any idea what the [DOS]...[/DOS] zip command to use? >=20 > I have no idea, but I'm sure someone else will. Or do a google search = and > you're likely to find a solution ... :) >=20 > Sincerely, > Kenneth Grome > www.KenGrome.com >=20 > ---------------------------- >=20 > Hi Ken, >=20 > Any idea what the [DOS]...[/DOS] zip command to use? >=20 > Cheers TDn >=20 > -----Original Message----- > From: Kenneth Grome [mailto:kengrome@gmail.com]=20 > Sent: Saturday, January 30, 2010 13:22 > To: talk@webdna.us > Subject: Re: [WebDNA] Generating Excel File Via WebDNA >=20 > Why don't you just zip it? >=20 > Sincerely, > Kenneth Grome > www.KenGrome.com > --------------------------------------- >=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 > --------------------------------------------------------- >=20 >=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
Bob Minor
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:
Please help (2004)
Why is my easy [AddLineItems] NOT working?? MORE (2000)
Grepping a hostname (2003)
Using [Showif] tag. Mac (1997)
Disappearing data (2002)
[WebDNA] Triggers issue, or sendmail? (2012)
RE: Writefile outside WebSTAR hierarchy? (1997)
Authorize.net (2001)
Problem (1997)
WCS Newbie question (1997)
P2: How to make webcatalog more stable. - LONG (1999)
Date+time (2004)
Time code! (2002)
WCS Newbie question (1997)
Form Submition (2003)
Calculating Shipping charges for multiple items and qtys > 1 (1997)
[WebDNA] WebDNA slow processing (2011)
Problems with date math (1997)
WCS Newbie question (1997)
CommandSecurity? (1997)