November 2000 - Zope

RE: [Zope] Generating text/csv from DTML method, Mime Type?
by Farrell, Troy 10 Nov '00

10 Nov '00

I know this sounds silly, but try making the url end with .csv I wrote a perl cgi script some time ago that spit out a csv file. When it ended with .csv, IE seemed to ignore the server's Content-type: text/html header. http://finance.yahoo.com/q?s=WCG&d=v1 Look, my stock is falling! Actually, if you look at the link below and to the right of the table, you'll see a download spreadsheet link. Yahoo uses a &e=.csv to set the extension. Presumably, the e value is for extension. Troy -----Original Message----- From: zope(a)concision.com [mailto:zope@concision.com] Sent: Friday, November 10, 2000 11:15 AM To: zope(a)zope.org Subject: Re: [Zope] Generating text/csv from DTML method, Mime Type? "Brad Clements" <bkc(a)murkworks.com> writes: > I'm create a CSV file that I would like browsers to get the "save as" > dialog when they select it. > > I'm using RESPONSE.write() to write out the CSV file, and I set the > Content-Type before calling RESPONSE.write > > > Netscape seems to work ok, it pops up a save box for "text/csv" and > "application/vnd.ms-excel". > > However in both cases IE5.5 just ignores the data and re-requests the > page. > > Does anyone know *all* the steps I need to take to get this to work > correctly with IE? I must be doing something wrong. I want to supply a > CSV file, but generated dynamically. I'm sure I'm missing a header > setting or something. FWIW, I recently had to support a customer in downloading files for use by spreadsheet software. After a little investigating, especially at the IETF web/FTP site, I discovered that there is no registered MIME type "text/csv". Can anyone refute this? There is a registered MIME type "text/tab-separated-values". Based on something I read recently on the Zope site, it may be that if you set the MIME type to application/vnd.ms-excel but send a tab separated values file, excel will open it. I haven't tried this though. _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

2 1

RE: [Zope] Generating text/csv from DTML method, Mime Type?
by Oliver Bleutgen 10 Nov '00

10 Nov '00

> I know this sounds silly, but try making the url end with .csv > I wrote a perl cgi script some time ago that spit out a csv file. When it > ended with .csv, IE seemed to ignore the server's Content-type: text/html > header. > http://finance.yahoo.com/q?s=WCG&d=v1 > Look, my stock is falling! Actually, if you look at the link below and to > the right of the table, you'll see a download spreadsheet link. Yahoo > uses > a &e=.csv to set the extension. Presumably, the e value is for extension. That isn't silly, it corresponds exactly with the description you can find at http://msdn.microsoft.com/workshop/networking/moniker/overview/appendix_a.a… There term silly seems much more suitable for that, btw. Btw., it shows that changing the extension to .csv won't help until one has registered an application for .csv-files in windows. And in fact, the "spreadsheet"-link showed up in my IE, no download window came up... cheers, oliver

1 0

restarting zope.org
by ethan mindlace fremen 10 Nov '00

10 Nov '00

we'll be back after these messages. ~ethan

1 0

Re: [Zope] Generating text/csv from DTML method, Mime Type?
by Oliver Bleutgen 10 Nov '00

10 Nov '00

> I'm create a CSV file that I would like browsers to get the "save as" > dialog when they select it. > I'm using RESPONSE.write() to write out the CSV file, and I set the > Content-Type before calling RESPONSE.write > Netscape seems to work ok, it pops up a save box for "text/csv" and > "application/vnd.ms-excel". > However in both cases IE5.5 just ignores the data and re-requests the > page. > Does anyone know *all* the steps I need to take to get this to work > correctly with IE? I must be doing something wrong. I want to supply a > CSV file, but generated dynamically. I'm sure I'm missing a header > setting or something. Adding "Content-Disposition: attachment [; filename=bla.csv]" as a http-header might help... The part in []s is optional . See my mail from yesterday for a bit more info cheers, oliver

2 1

why DTML confusing
by Irene Barg 10 Nov '00

10 Nov '00

Hello All, I do read HOW-TO's, User-Guides, etc., but I think DTML must be made simpler, or better documentation, or more examples. As an example, within an <dtml-in> loop: 1. You can print the values of sequence-items with: (index=<dtml-var sequence-index>, number=<dtml-var sequence-number>, item=<dtml-var sequence-item>) 2. To test for equality, this does not: <dtml-if "sequence-index == 0"> (<dtml-var count-adassnum> Records found) </dtml-if> 3. While this does work: <dtml-if "_['sequence-index'] == 0"> (<dtml-var count-adassnum> Records found) </dtml-if> I say this is confusing. Don't tell me to read the Namespace How-to, or the Zope User Guides, I did, and it's still confusing! Unless you find an example, that does exactly what you want, trying to figure it out with the documentation available can be difficult. I found my answer to this in the "How-To: (How-to) access the field names and fields of any arbitrary ZSQL query", but it took a lot of searching the Zope site for references to 'dtml-in'. I get so frustrated with DTML, I want to scream. Please don't tell me to buy the Zope book, DTML should be more intuitive. DTML maybe the heart of Zope, but it's also it's achilles heel. -- irene ------------------------------------------------------------------ Irene Barg Email: ibarg(a)as.arizona.edu Steward Observatory Phone: 520-621-2602 933 N. Cherry Ave. University of Arizona FAX: 520-621-1891 Tucson, AZ 85721 http://nickel.as.arizona.edu/~barg ------------------------------------------------------------------

3 2

Re: [Zope] Generating text/csv from DTML method, Mime Type?
by zope＠concision.com 10 Nov '00

10 Nov '00

"Brad Clements" <bkc(a)murkworks.com> writes: > I'm create a CSV file that I would like browsers to get the "save as" > dialog when they select it. > > I'm using RESPONSE.write() to write out the CSV file, and I set the > Content-Type before calling RESPONSE.write > > > Netscape seems to work ok, it pops up a save box for "text/csv" and > "application/vnd.ms-excel". > > However in both cases IE5.5 just ignores the data and re-requests the > page. > > Does anyone know *all* the steps I need to take to get this to work > correctly with IE? I must be doing something wrong. I want to supply a > CSV file, but generated dynamically. I'm sure I'm missing a header > setting or something. FWIW, I recently had to support a customer in downloading files for use by spreadsheet software. After a little investigating, especially at the IETF web/FTP site, I discovered that there is no registered MIME type "text/csv". Can anyone refute this? There is a registered MIME type "text/tab-separated-values". Based on something I read recently on the Zope site, it may be that if you set the MIME type to application/vnd.ms-excel but send a tab separated values file, excel will open it. I haven't tried this though.

1 0

Re: [Zope] Is data.fs corrupted?
by Simon Michael 10 Nov '00

10 Nov '00

Thanks for the informative thread. FWIW, I see this problem too. It's preventing me from importing various PTK & Membership .zexp's. -Simon

1 0

DataSkin Supplier?
by Chris Withers 10 Nov '00

10 Nov '00

Hello... Okay, I'm still staring up at the ZPatterns learning cliff as I write this so forgive my ignorance. I'm looking at ZPatterns WRT to 'dynamically generated dataskins'. You what? Well, okay, I'll try and explain... Firstly, I'm assuming that DataSkins (or their subclasses?) are first-class zope objects, can be 'added', copied, pasted, have security tabs, can be catalogued, URL traversed, etc, etc. Is that assumption correct? I hope so :-S If it is, is there something which can generate DataSkins on the fly? ie: in the same way an AttributeProvider supplier attributes to an object, is there something like a 'DataSkin provider' which provides whole dataskins to a folderish object? Finally, and this is the important bit. Can one of these folderish objects also _be_ a DataSkin? So, to word it differently, there is a root 'DataSkin provider'. This provides DataSkins which are folderish and are also 'DataSkin providers' themselves. Why do I want this? Well, think objects in a tree where the parents/children are stored as a list of names refering to other objects. In addition, objects may have multiple parents, etc... Any ideas? Where should I start reading? cheers, Chris

1 0

Re: [Zope] DTML on Linux client
by Stephan Goeldi 10 Nov '00

10 Nov '00

Sorry, in fact this was a 'cache-problem'. I always have to hit the 'reload' button to get the right content. In Windows the old content was shown, in Linux the actual (because I did not browse before on this page). In the management screens too I always must hit reload after a change of the content. >I checked my website www.goeldi.com with a SuSE Linux 7 client (Netscape) >and discovered, that not all DTML is done right. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

1 0

Generating text/csv from DTML method, Mime Type?
by Brad Clements 10 Nov '00

10 Nov '00

I'm create a CSV file that I would like browsers to get the "save as" dialog when they select it. I'm using RESPONSE.write() to write out the CSV file, and I set the Content-Type before calling RESPONSE.write Netscape seems to work ok, it pops up a save box for "text/csv" and "application/vnd.ms-excel". However in both cases IE5.5 just ignores the data and re-requests the page. Does anyone know *all* the steps I need to take to get this to work correctly with IE? I must be doing something wrong. I want to supply a CSV file, but generated dynamically. I'm sure I'm missing a header setting or something. Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements

1 0