May 2002 - Zope - Zope lists

Best way to go
by Tom Deprez 03 May '02

03 May '02

Hi, I need to offer keywords to users to choose from to use to index documents. There will be so much keywords that the only way to present them in a proper way is probably through a tree view. Now, what would be the best way to make this: 1) create a 'tree' keyword python product and create zope management interfaces for that. Thus we've one product which keeps the keys internally 2) create a keyword product and build the tree in the ZODB as like you could build a hierarchy with folders 3) use plain folders for the keywords. I'm not sure which would be the best choice. Anybody who can give me some advice? Thanks in advance, Tom.

1 0

RE: [Zope] SQL to Excel
by Christian.Fissgus＠haufe.de 03 May '02

03 May '02

> select URL from [qas$] where Month='March' and Year=2000 > > Note that the table name is the name of the worksheet with a > $ appended to > the end. You have to append the $ in order for the query to work. Why? Because spreadsheets aren't tables... You have several ways of telling, which data you want: [qas$] refers to the entire worksheet qas [qas$B2:G20] refers to the unnamed range B2:G20 or you can use named ranges: then you can use the name of the range like any "normal" table ( select * from myRangeInQas ) > Because. The brackets are there because $ is a reserved > character in SQL. > Life is never easy. > ----------------------- > > Now all I want to do is SELECT *...I don't need anything > fancier than that, > I'm just trying to publish the entire worksheet. No variation > on the above > code snippet seems to work. > > Has anybody gotten SQL queries into excel to work? And how > did you do it? The way you described works fine for me... Does the first row of your worksheet show the columnnames? Any of them starting with blank ? Maybe you tell us, what happens when "it doesn't work"... Chris

1 0

RE: [Zope] color-syntax editor for dtml
by Schmidt, Allen J. 03 May '02

03 May '02

So how do you turn on Editplus color highlight for dtml documents? I found the dtml file and installed it and found the settings tab to enable a new file type, but it is looking for an extension to associate with. How did you work around that? Looks like Editplus has made some improvements since I last looked at it. BUT, it will have to be VERY improved to get me to switch away from HomeSite - which IMHO is the BEST (Windows) tool with which to work with Zope files. I would be glad to talk offline about it since I have bored the group too often with it's praises in the past. <8^) -Allen -----Original Message----- From: hans [mailto:hans@beehive.de] Sent: Tuesday, April 30, 2002 6:43 AM To: Wendy Langer Cc: Zope List Subject: Re: [Zope] color-syntax editor for dtml Wendy Langer wrote: > Hi everyone, > I was just wondering on what people's opinions are on the best applications > to use for editing dtml files - I want something with at least a bit of > syntax coloring - is there anything designed specifically for dtml? If not, > what else would be best to use? http://www.editplus.com/ has dtml-syntaxcolor -- ------------------------------------------------------------- Who's got only a hammer sees the world as a nail hans augustin (software developer) hans(a)beehive.de beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299 _______________________________________________ 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 )

9 11

ZPT reverse ordering
by Tom Nixon 03 May '02

03 May '02

I want to list items on a page with the newest at the top. I have got part of the way there with this code: <tr tal:define="thelist python:p.objectValues('Kube')" tal:repeat="subitems python:sequence.sort(thelist, (('bobobase_modification_time',),) )"> Two problems with this though: 1) I want it sorted by the creation date, rather than modification date. 2) I need the results reversed so newest is at the top, not bottom. I suspect I need to create a python script to build the list. Does anyone have the code to do this? Cheers Tom

4 5

ZOPE/PYTHON CLASS ES (El Paso/Las Cruces/Juarez Area )
by Luis Cortes 03 May '02

03 May '02

Hello, I am an instructor at New Horizons El Paso and I wanted to see if there was any interest in a Zope/Python class in the El Paso TX /Las Cruces NM /Juarez Mex area. I have 6 years software engineering experience and would like to teach either course IF there are people interested. If YOU are, please zap me an email and cc: jessej(a)nh-elpaso.com and let us know! Thanks, Luis.

1 0

Re: How to use a ZSQLMethod from a Python Script
by Stefano Vedovelli 03 May '02

03 May '02

Hello under zope 2.5.1, I have a folder called temp. In the folder I have a connection object, a zsql method called test_sql and a python script called test_zsql. The script is: from Products.PythonScripts.standard import html_quote res = context.test_sql() for name in res.names(): print name dict = res.data_dictionary() for key in dict.keys(): print dict[key] return printed Works good. Sure you do not have some other issues? Note that I run under Linux and as far as I can see you run it under Windows. regards Stefano On Friday 03 May 2002 13:47, zope-request(a)zope.org wrote: > >Igor Leturia writes: > > > I want to call a ZSQLMethod from a Python Script. In Zope.org, > > I > couldn't find a specific how-to on the subject, but > > accidentally I found some other how-to's in which there are examples > > that use ZSQLMethods > from Python scripts. It seemed very easy, so I tried > > it that way: > > > res = context.mysqlmethod() > > > It gives an error message, 'resource not found'.

2 1

Built in support for renaming multiple titles (a la manage_renameObjects)?
by Michael LaPera 03 May '02

03 May '02

I have a project were I'm generating random ID's and displaying only the titles (instead of ids and titles) though a custom CMF "folder_contents" skin. I want the user to be able to bulk rename the titles simular to OFS.CopySupport.manage_renameObjects. Is there any built in functionality for bulk title renaming or do I need to write it? Thanks, Michael LaPera

2 1

Searching Developer: Mapping WebDAV to Drive Letter
by Thomas Guettler 03 May '02

03 May '02

During the last evenings I investigated a little how difficult it would be to write Windows NT Internal File System which mounts a webdav server to a drive letter (like Teamdrive, or WebDrive). This way we could get rid of the problems we have with WebDAV and MS-Office. I is an interesting challenge. The building blocks are already there: neon: (WebDAV Client Library) http://www.webdav.org/neon/ Examples of an IFS (Internal Filesystem Driver): http://www.acc.umu.se/~bosse/ I thought about doing it myself, but I have a fulltime job. Maybe someone at a university could convince his professor to do this in a project. thomas

2 2

R: [Zope] acquisition or inheritance?
by Zanotti Michele 03 May '02

03 May '02

I think inheritance is a "genetic" concept, an object inherits an attribute and has it forever, where acquisition depends on the container the object has, and then on his context. There are several how-tos about acquisition where you can find better explanations, see also http://webdev.zopeonarope.com/ and http://www.byte.com/documents/s=705/byt20010614s0001/ Michele > -----Messaggio originale----- > Da: Bill Kerr [mailto:kerrb@senet.com.au] > Inviato: giovedì 2 maggio 2002 21.16 > A: zope(a)zope.org > Oggetto: [Zope] acquisition or inheritance? > > > why does the zope literature use the term acquisition and not > inheritance? > - Bill > > > > _______________________________________________ > 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

Bug in Zope-Book CVS
by Tille, Andreas 03 May '02

03 May '02

Hello, im the Debian maintainer of the Zope Book and there is a bug report which can be read under: http://bugs.debian.org/142451 Unfortunetely I do not understand structured text and I'm not able to fix this problem. I guess the authors have currently other problems than fixing this bug and I do not really want to apply the patch the bug reporter sended against the HTML output. Thus I would like to ask wether somebody is sane enough to fix the stx source AdvZPT.stx to get well prepared HTML output. For those who do not know about what file I'm talking about. It can be obtained via CVS-Web from http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/zope-book/Book/AdvZPT.stx Thanks for any help Andreas.

2 1