- Zope - Zope lists

Retrieving ans processing multiple list selections
by Sabine_Ritter＠t-online.de 25 Jun '01

25 Jun '01

Hi there, I am using a form with several drop-down lists which allow multiple options to be selected. example: <select name="country" size="8" multiple> <option selected value="">entire Europe <option value="1">France <option value="2">Germany ..................... <option value="15">Denmark <option value="16">Spain </select> The selections are used in an ZSQL-Method: SELECT x, y, COUNT(lfdnr) AS Anzahl FROM table <dtml-sqlgroup where> <dtml-sqltest country type=int multiple optional> <dtml-and> .................... </dtml-sqlgroup> GROUP BY x, y, z The result of the ZSQL-Method is shown on a report page with <dtml-in ZSQL-Method size=50 start=query_start> ...................... Before displaying the result of the query I would like to summarize the selection like: "You have selected: country: France and Denmark age-group: 10-14 years and 15-19 years ----- Here is the result of your query: <table> As long as only one option is selected is can use <dtml-if expr="country=='1'"> France <dtml-elif expr="country=='2'"> Germany .................... However, if multiple options are selected, <dtml-var bl> will return a list of values like ['3','4','6'] and the above 'translation' doesn't work any more. Q u e s t i o n: How can I process ('translate') the list-values? Is there a way to directly adress the option text??? Thanks for supporting a real Newbie Sabine One more question: can anybody tell me, where I can get more information about all this "" , ' ', [' '], _.[ ()] stuff ? (meaning and proper use of it)

2 1

skip_unautorized is based on what permission?
by Jean Lagarde 25 Jun '01

25 Jun '01

Good day, I was hoping to be able to simply control what buttons get displayed on a form, depending on user roles, by using the skip_unauthorized attribute of dtml-in. I have not been able to make it work so far, so I would appreciate some help. The dtml-in statement is: <dtml-in "problemTable.objectItems('formButton')" skip_unauthorized> where formButton is a ZClass I defined. I would like to restrict permissions to some of my buttons to certain roles, so that they only get displayed when the user has the relevant role. I thought that using skip_unauthorized would be easier than adding tests on the user in my own code (why add more code if built-in facilities can do what I need). I have tried to change the 'View' and the 'Access contents information' permissions for my button objects, but neither does what I would hope. 'Access contents information' seems to do nothing at all, and 'View' pops the login panel, which I assumes happens within the body of the dtml-in. I can't see what other permission to change within the available list, to make dtml-in skip the object. Any clue? Cheers, Jean

1 0

WinMe / Win2k / RedHat / data.fs
by rlanham＠speakeasy.net 25 Jun '01

25 Jun '01

Henny(s), This weekend I successfully re-partitioned my hd and got redhat 7.1 running, got the network running, got apache running. Next break I get, I'll get zope running. Then the big plan is to get my wiki moved to linux/zope, AND port my asp/sqlserver apps to PHP/postgresql. Then maybe I'll make another linux partition out of dev/hda1 where winMe lives. I'll get another box for win2k and my legacy asp--someday. My data.fs is actually about 300meg: 1/3 of a gig. Yes, zope was running on the win2k box before I copied the winMe data.fs. Then nostart. No error either, as I remember, just hung. No, haven't tried the export/import. I'll have to look into that. Won't work for me if source and target have to be running at the same time, cause now I am wanting to go from winme to linux on dual boot--same machine. I have used the FS product to write folders and items to the filesystem, then FTP those to another zope. That works, I'll have to recreate all the ownership, but that's doable. Throwing off the chains, Richard > > Wait a minute, ... Both you guys are named Henny? > > I mean,...that's great... and run zope on winMe... > > Not to mention that we 're both from the Netherlands, have exactly the > same > problems. Weird was the first thing that came to my mind ;) > > > I have tried to use data.fs from my WinMe machine > > on win2K at work. No luck. The WinMe data.fs comes > > from a Zope version: Zope 2.2.2 (binary release, > > python 1.5.2, win32-x86) and the win2k zope is > > more recent. Zope wouldn't start when I copied it > > to /var. Shouldn't this work going from 2.2.2 to > > 2.3 (backward compatability)? Or is the problem > > the OS: FAT vs NTFS? > > I copied data.fs from Win95 to Win98 to WinNt to WinMe without problems > (mainly Zope 2.1.6, but the data.fs should be backward compatible). We > have > also a Win2000 machine running Zope but we never copied a data.fs to that > thing. > Did Zope start before you copied the data.fs? > Have you tried to export and import your sites/folders? > Have you tried to copy the whole website directory from one machine to the > other? > How large is your data.fs? > > Henny

1 0

Zope upload
by Aaron Hunt 25 Jun '01

25 Jun '01

I there any way to automate uploading of files to zope. I have a site with a large number of pages and uploading them all by had would be painful Thank you for any help Aaron

4 3

FW: Xron
by Loren Stafford 25 Jun '01

25 Jun '01

The best way to debug Xron methods is to enable the STUPID_LOG_FILE, schedule the method for execution soon, and view the results in the log file. The "Trigger" tab can be useful, but it provides only a half-hearted simulation of what the Dispatcher does. -- Loren ----- Original Message ----- From: "Mikael Berthe" <mikael.berthe(a)fr.alcove.com> To: <lstaffor(a)dynalogic.com> Sent: Thursday, June 21, 2001 5:50 AM Subject: Xron > Hello, > > I'm currently trying your Xron Zope product, and something strange > happens. The Xron dtml script just call the method of another product; > when I click on the "View" panel, everything is ok. But, when I > "trigger", my method is called, but nothing else happens. > > I don't really know how to give you useful information, but perhaps you > have a clue about what's going on? (proxy option is ok). > > I'm using Zope 2.3.x (perhaps this is the problem?). > > Regards, > Mikael > -- > Mikael BERTHE -- <mikael.berthe(a)fr.alcove.com> > Alcôve, l'informatique est libre -- <http://www.alcove.com/> > EFREI <mikael.berthe(a)efrei.fr> >

1 0

PoPy.2.0.1 Needs Postgresql?
by Russell Hires 25 Jun '01

25 Jun '01

The error I get is listed below. I'm trying to install the stuff that will allow for me to work with Postgresql, and I'm following the HOWTO -- actually, I'm not. I can't believe that I have to *un*install Postgresql to get PoPy to work. That doesn't make sense. Besides, I don't work with source much anyway, I've got Debian ;-) Anyway, I did the ./configure, and this is the error I get. Anyone know what I can change to get it to work? checking for PQconnectStart in -lpq... no configure: error: can't build without PostgreSQL libraries Thanks! Russell

4 5

RE: [Zope] Restrict object list in folderish product, it works, b ut how?
by Max Møller Rasmussen 25 Jun '01

25 Jun '01

> From: Rene Pijlman [mailto:rpijlman@wanadoo.nl] > Restrict the available objects list of a Python-based > folderish product: > http://www.zope.org/Members/rpijlman/FolderishProduct/Restrict > AvailableObjec > ts >From the Zope Developers guide: http://www.zope.org/Documentation/ZDG/Products.dtml "If you wish to control which types of objects can be contained by instances of your product you can set the meta_types class attribute. This attribute should be a tuple of meta_types. This keeps other types of objects from being created in or pasted into instances of your product. The meta_types attribute is mostly useful when you are creating specialized container products." This would probably be easier... regards Max M

2 2

Mail delivery failed: returning message to sender
by Mail Delivery System 25 Jun '01

25 Jun '01

This message was created automatically by mail delivery software. A message that you sent could not be delivered to all of its recipients. The following address(es) failed: joe.nicholls(a)zope.co.uk: SMTP error from remote mailer after RCPT TO: <joe.nicholls(a)zope.co.uk>: host mail.zope.co.uk [212.67.208.19]: 550 5.7.1 <joe.nicholls(a)zope.co.uk>... Relaying denied ------ This is a copy of the message, including all the headers. ------ Return-path: <zope(a)zope.org> Received: from uwcmcm1m.uwcm.ac.uk ([193.63.112.49]) by crane2.cf.ac.uk with esmtp (Exim 3.03 #1) id 15EYor-0001LN-00 for joe.nicholls(a)zope.co.uk; Mon, 25 Jun 2001 17:02:33 +0100 Received: from UWCMCM1M/SpoolDir by UWCMCM1M.UWCM.AC.UK (Mercury 1.48); 25 Jun 01 17:02:47 GMT0BST Received: from SpoolDir by UWCMCM1M (Mercury 1.48); 25 Jun 01 17:02:26 GMT0BST Received: from UWCMCM1M/SpoolDir by UWCMCM1M.UWCM.AC.UK (Mercury 1.48) for <Wmljan.STF.MEDIA.DACS.CM(a)UWCMCM1M.UWCM.AC.UK>; 25 Jun 01 17:02:26 GMT0BST Resent-from: Wmljan.STF.MEDIA.DACS.CM(a)UWCMCM1M.UWCM.AC.UK Resent-to: joe.nicholls(a)zope.co.uk Resent-Date: Mon, 25 Jun 2001 17:02:26 GMT0BST X-Autoforward: 1 Received: from pigeon.cf.ac.uk (131.251.0.2) by UWCMCM1M.UWCM.AC.UK (Mercury 1.48) with ESMTP; 25 Jun 01 17:02:22 GMT0BST Received: from mail.python.org ([63.102.49.29]) by pigeon.cf.ac.uk with esmtp (Exim 3.22 #1) id 15EYoS-00019C-00 for nichollsja(a)cf.ac.uk; Mon, 25 Jun 2001 17:02:08 +0100 Received: from localhost.localdomain ([127.0.0.1] helo=mail.python.org) by mail.python.org with esmtp (Exim 3.21 #1) id 15EYnl-0008Cs-00; Mon, 25 Jun 2001 12:01:25 -0400 From: zope-request(a)zope.org Subject: Zope digest, Vol 1 #1487 - 8 msgs Reply-to: zope(a)zope.org X-Mailer: Mailman v2.0.5 (101270) MIME-version: 1.0 Content-type: text/plain To: zope(a)zope.org Sender: zope-admin(a)zope.org Errors-To: zope-admin(a)zope.org X-BeenThere: zope(a)zope.org X-Mailman-Version: 2.0.5 (101270) Precedence: bulk List-Help: <mailto:zope-request@zope.org?subject=help> List-Post: <mailto:zope@zope.org> List-Subscribe: <http://lists.zope.org/mailman/listinfo/zope>, <mailto:zope-request@zope.org?subject=subscribe> List-Id: Users of the Z Object Publishing Environment <zope.zope.org> List-Unsubscribe: <http://lists.zope.org/mailman/listinfo/zope>, <mailto:zope-request@zope.org?subject=unsubscribe> List-Archive: <http://lists.zope.org/pipermail/zope/> Message-Id: <E15EYnl-0008Cs-00(a)mail.python.org> Date: Mon, 25 Jun 2001 12:01:25 -0400 Resent-Message-Id: <E15EYor-0001LN-00(a)crane2.cf.ac.uk> Send Zope mailing list submissions to zope(a)zope.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.zope.org/mailman/listinfo/zope or, via email, send a message with subject or body 'help' to zope-request(a)zope.org You can reach the person managing the list at zope-admin(a)zope.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Zope digest..." Today's Topics: 1. Re: A tale of two systems.... (Thomas B. Passin) 2. select_question (Kathrin Deubrecht) 3. Twin Cities (MN, USA) Zope User Group (Michael Fraase) 4. Re: [Zope-dev] Zcatalog bloat problem (berkeleydb is a solution?) (abel deuring) 5. Re: 2.4 beta1 on win2k doesnt run?? (Andy McKay) 6. Re: Restrict object list in folderish product, it works, but how? (Joachim Werner) 7. Re: A tale of two systems.... (Chris Beaumont) 8. File locking. (=?iso-8859-1?q?J=F8rgen=20Hermanrud=20Fjeld?=) --__--__-- Message: 1 From: "Thomas B. Passin" <tpassin(a)mitretek.org> To: <zope(a)zope.org> Subject: Re: [Zope] A tale of two systems.... Date: Mon, 25 Jun 2001 11:05:53 -0400 [Michael Sullivan] > > Is there an up-to-date, cogent, step by step > information on hooking > up a MySQL database to Zope in Windows? > Not quite what you asked for, but get the mySQL ODBC driver working, then you don't have to do anything specific about mySQL within Zope, just us a Zope ODBC data source and you'll be all set. I use ODBC to get Zope talking to SQLAnywhere, Access, Interbase, and (previously) mySQL. The only hitch I've had is that sometimes you have to set up the connect string manually and sometimes the one in the ODBC setup works, so just experiment. Otherwise, it works well. Cheers, Tom P --__--__-- Message: 2 Date: Mon, 25 Jun 2001 17:12:05 +0200 (MET DST) From: Kathrin Deubrecht <kathrin(a)iei.tu-clausthal.de> Reply-To: Kathrin Deubrecht <kathrin(a)iei.tu-clausthal.de> To: zope(a)zope.org Subject: [Zope] select_question Hello , I have a folder 'project' with some subfolders (the projects). The subfolders have different properties. Now I created a form in which I can include new properties for a new subfolder. A DTML-method called 'project_prozessor' adds this new subfolder with its new properties to folder 'project'. Now my problem : I want to create a selection list with all my subfolders from folder 'project' and when I click on a subfolder, the properties which belong to my selected folder should be in the parts of the form , now. How can I generate my side with the form new? I don't know how can I realize it? I only want to do this with DTML-Syntax not with properties.sheets or so. I would be very happy about your answer. best regards kathrin --__--__-- Message: 3 Reply-To: <mfraase(a)farces.com> From: "Michael Fraase" <mfraase(a)farces.com> To: <zope(a)zope.org> Date: Mon, 25 Jun 2001 10:17:01 -0500 Organization: ARTS & FARCES LLC Subject: [Zope] Twin Cities (MN, USA) Zope User Group Any interest in forming a Twin Cities (Minneapolis, Saint Paul) Zope User Group? If so, please contact me directly. Thanks kindly. -- Michael Fraase ARTS & FARCES LLC mfraase(a)farces.com www.farces.com PGP Fingerprint: 3D85 F3F4 9E65 4949 176A 260C CB47 190D C864 9A96 --__--__-- Message: 4 Date: Mon, 25 Jun 2001 17:49:02 +0200 From: abel deuring <adeuring(a)gmx.net> Reply-To: a.deuring(a)satzbau-gmbh.de To: Giovanni Maruzzelli <maruzz(a)open4.it> CC: zope(a)zope.org, zope-dev(a)zope.org, erik(a)thingamy.net, barry(a)digicool.com, chrism(a)digicool.com Subject: [Zope] Re: [Zope-dev] Zcatalog bloat problem (berkeleydb is a solution?) Giovanni Maruzzelli wrote: > = > Hello Zopistas, > = > we are developing a Zope 2.3.3 (py 1.5.2) application that will add, in= dex > and reindex some tens of thousands > objects (Zclass that are DTMLDocument on steroids) on some twenty prope= rties > each day, while > the absolute number of objects cataloged keeps growing (think at conten= t > management for a big > portal, where each day lots of content are added and modified and all t= he > old content remains as a > searchable archive and as material to recycle in the future). > = > This seems for some aspects a task similar to what Erik Enge impacted c= ouple > a weeks ago. > = > We first derived from CatalogAware, then switched to manage ourselves t= he > cataloging - uncataloging - recataloging. > = > The ZODB still bloat at a too much fast pace. > = > ***Maybe there's something obvious we missed***, but when you have some= > 4thousands object in the catalog, if you add and catalog one more objec= t > the ZODB grows circa a couple of megabyte (while the object is some 1 k= of > text, and some twelve boolean and datetime and strings properties). If = we > pack the ZODB, Data.fs returns to an almost normal size (so the bloat a= re > made by the transactions as tranalyzer.py confirms). > = > Any hints on how to manage something like? > We use both textindexes, fieldindexes, and keywordsindexes (textindex o= n > string properties, fieldindexes on boolean and datetime, keywordindex o= n > strings). Maybe one kind of indexes is to be avoided? > = > Erik, any toughts? > = > We are almost decided to switch to berkeleydb storage (the Minimal one)= to > get rid of the bloating, we are testing with it, but it seems to be > discontinued because of a lack of requests. > = > Any light on it? Is it production grade? Giovanni, I experienced similar problems trying to catalog =B7~200000 objects with ~500 MB text. Using CatalogAware objects will indeed lead to a "really fat" data base, and using the "find objects" for a ZCatalog requires considerable resources. A text index (more precise: the class UnTextIndex) works, as far as I understood it, this way: 1. The method UnTextIndex.index_object splits the text into single words, using the method [Globbing]Lexicon.Splitter. = 2. UnTextIndex.index_object looks up the wordID (an integer) of each word in the lexicon. If a word is not yet listed in the lexicon, it is added to the lexicon. = 3. All wordIDs are inserted into self._index, which maps wordIDs to the list of documents containing this word. 4. The "unindex" BTree , which maps the documentIds to the the list of all words appearing in an document is updated. If you are adding only one CatalogAware object during a transaction, this is quite expensive: Even if the indexed object contains only one new word, the entire lexicon needs to be updated. In my tests with the 200000 objects (containing ordinary German texts) the lexicon contained ~ 1 million words. (BTW, I had not had a very close look into the contents of the lexicon, so I don't know yet exactly, why it is so large. But I noticed quite many entries like "38-j=E4hrige", "42-j=E4hrig= e" ("NN-year-old") entries. So a configurable splitter method might help quite much to reduce the size of the lexicon.) Hence, the above mentioned step 2 alone can result in a really bloated data base. A solution might be a kind of "lazy catalog awareness": Instead of mangling a new object through one or more catalogs when it is created, this object could be added to a list of objects to be cataloged later. This way, the transaction to insert a new object would become much "cheaper". I'm working on this, but right now it is quite messy. (I'm new to Python and Zope, and hence I'm stumbling over a few, hmmm, trip-wires...) But even using such a "lazy catalog awareness", you might get into trouble. Using the ZCatalog's "find objects" function, I hit the limits of my Linux box: 640 MB RAM were not enough... As I see it, the main problem is that UnTextIndex.index_object tries to do all work at once: Updating the lexicon _and_ self._index _and_ self._unindex So I tried to separate these tasks by writing the data to be stored in self._index (wordId, documentId, score) into a pipe. This pipe is connected to sort(1). After all objects have been "scanned", the pipe is closed, the sorted results are read back and self._index is updated. This way, Zope needed "only", uuhh, somewhat aroud 200 or 300 MB RAM. A few weeks ago, I've posted this (admittedly not fully cooked) patch to this list, but did not get yet any response. Abel --__--__-- Message: 5 From: "Andy McKay" <andym(a)ActiveState.com> To: "bdorn(a)vup.at" <bdorn(a)mopa.at>, "Phil Harris" <phil.harris(a)zope.co.uk>, <zope(a)zope.org> Subject: Re: [Zope] 2.4 beta1 on win2k doesnt run?? Date: Sat, 25 Aug 2001 08:36:51 -0700 Works fine for me too. We do get an intermittent problem with Zope 2.3.x not starting on windows though, sometimes after retrying it a few times, it works fine. Still havent had the time to investigate it much though... -- Andy McKay ----- Original Message ----- From: "bdorn(a)vup.at" <bdorn(a)mopa.at> To: "Phil Harris" <phil.harris(a)zope.co.uk>; <zope(a)zope.org> Sent: Monday, June 25, 2001 3:12 AM Subject: Re: [Zope] 2.4 beta1 on win2k doesnt run?? > it's already running form cmd > debugging is enabled (-D) > it's running at 8080 > i haven't changed the bat so its default port is used - i think > > the win2k box is my development box and i run four different zopes (not at > the same time) > but they all work - only this new release doesn't > > it seems that it really doesn't do anything, because there is completely no > output > > ???? > > thx bernd > > > ----- Original Message ----- > From: "Phil Harris" <phil.harris(a)zope.co.uk> > To: "bdorn(a)vup.at" <bdorn(a)mopa.at>; <zope(a)zope.org> > Sent: Monday, June 25, 2001 12:06 PM > Subject: Re: [Zope] 2.4 beta1 on win2k doesnt run?? > > > > Works fine for me on w2k advanced server sp2. > > > > Have you checked the port it's running on? Have you got anything else on > > that port? > > > > Try running the start.bat file from a command prompt, in debug mode you > > should get some error message. > > > > hth > > > > Phil > > ----- Original Message ----- > > From: bdorn(a)vup.at > > To: zope(a)zope.org > > Sent: Monday, June 25, 2001 10:57 AM > > Subject: [Zope] 2.4 beta1 on win2k doesnt run?? > > > > > > does anybody know this problem ... > > > > I installed Zope 2.4 b1 this morning on a win2k server > > > > its running manually ( it should) - not as a service > > > > but when I start z2.py it exits without any message immediately > > > > thanks in advance, bernd > > > > _______________________________________________ > 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 ) > --__--__-- Message: 6 From: "Joachim Werner" <joe(a)iuveno-net.de> To: =?iso-8859-1?Q?Max_M=F8ller_Rasmussen?= <maxm(a)normik.dk>, "'Rene Pijlman'" <rpijlman(a)wanadoo.nl>, <zope(a)zope.org> Subject: Re: [Zope] Restrict object list in folderish product, it works, but how? Date: Mon, 25 Jun 2001 17:57:10 +0200 Organization: iuveno AG Stephan Richter's "OrderedFolder" (http://www.zope.org/Members/srichter/Products/OrderedFolder) has two new features now: - There is a "Subobjects" tab like in ZClasses (That's what you seem to be looking for) - You can switch on/off "Transparency" if you have installed Shane's TransparentFolder So the name of the thing should probably be "ConfigurableFolder" or so. If you think this thing could make your life easier, we can publish the new version as a standalone product. It was meant to be published with the next version of Kontentor. Just tell us what you think ... Joachim --__--__-- Message: 7 Date: Mon, 25 Jun 2001 08:54:02 -0700 To: "Thomas B. Passin" <tpassin(a)mitretek.org> From: Chris Beaumont <cbeaumon(a)msri.org> Subject: Re: [Zope] A tale of two systems.... Cc: zope(a)zope.org But this only works if you are hosting Zope on Windows, right? From what I understand, there is no ODBC adaptor for any of the *nix platforms.. Mybe somebody here knows.. What is the best way of getting access to a ODBC datasource from a Zope instance hosted on Linux? Is there a (perhaps third party) ODBC driver that runs on Linux that is cross-compatible? -Chris >[Michael Sullivan] > >> >> Is there an up-to-date, cogent, step by step >> information on hooking >> up a MySQL database to Zope in Windows? >> > Not quite what you asked for, but get the mySQL ODBC driver working, then >you don't have to do anything specific about mySQL within Zope, just us a >Zope ODBC data source and you'll be all set. > >I use ODBC to get Zope talking to SQLAnywhere, Access, Interbase, and >(previously) mySQL. The only hitch I've had is that sometimes you have to >set up the connect string manually and sometimes the one in the ODBC setup >works, so just experiment. Otherwise, it works well. > >Cheers, > >Tom P --__--__-- Message: 8 From: =?iso-8859-1?q?J=F8rgen=20Hermanrud=20Fjeld?= <jhf(a)hex.no> Organization: Fjeld Kurs og Konsulenttjenester To: zope(a)zope.org Date: Mon, 25 Jun 2001 17:57:15 +0200 Subject: [Zope] File locking. Hi. Is there a way to support file locking? It seems it is supported through WebDAV, although I haven't tried. But how doe's one do this with the management interface? The goal is to prevent several people from changing the same document at = the=20 same time. --=20 MVH J=F8rgen H. Fjeld --__--__-- _______________________________________________ Zope maillist - Zope(a)zope.org End of Zope Digest

1 0

Twin Cities (MN, USA) Zope User Group
by Michael Fraase 25 Jun '01

25 Jun '01

Any interest in forming a Twin Cities (Minneapolis, Saint Paul) Zope User Group? If so, please contact me directly. Thanks kindly. -- Michael Fraase ARTS & FARCES LLC mfraase(a)farces.com www.farces.com PGP Fingerprint: 3D85 F3F4 9E65 4949 176A 260C CB47 190D C864 9A96

1 0

Windows ME reboots on starting Zope
by Henny van Esch 25 Jun '01

25 Jun '01

Hi, I have just installed Zope on a Windows ME machine. With both version 2.3.3 and 2.4.0b1 the PC reboots when running the start.bat script. Any idea what this can be? - Henny

3 2