March 2002 - Zope - Zope lists

[NEWBIE] Unambiguous expressions in Z SQL methods
by Biju Chacko 20 Mar '02

20 Mar '02

Hi, I have a legacy database which uses an internal convention of naming the primary key of a table as 'code'. When executing queries which include joins, it is necessary to add a table name prefix in order to make them unambiguous. For example: SELECT foo.*, bar.desc FROM foo INNER JOIN bar ON foo.bar = bar.code WHERE foo.code = some_value I created a Z SQL Method called listFoo thus: -8<------ Parameter: foo.code SELECT foo.*, bar.desc FROM foo INNER JOIN bar ON foo.bar = bar.code <dtml-sqlgroup where> <dtml-sqltest foo.code op="eq" type="int"> </dtml-sqlgroup> -8<------- This works fine when I test it. However, I'm having a bit of trouble calling from my dtml document. I'm trying to use a line like: <dtml-in expr="listFoo(foo.code=code)"> which bombs (naturally). So how do I go about this? I'm sorry if this is a FAQ, I'm a Zope newbie -- I've been using it precisely 5 days. TIA -- Biju -- ------------------------------------------------- Biju Chacko | biju(a)exocore.com (work) Exocore Consulting | biju_chacko(a)yahoo.com (play) Bangalore, India | http://www.exocore.com ------------------------------------------------- You shouldn't wallow in self-pity. But it's OK to put your feet in it and swish them around a little. -- Guindon

3 2

Pydoc and Zope 2.5.0
by Eckhoff, Damon 20 Mar '02

20 Mar '02

Just wondering if pydoc will work with Zope 2.5.0 and if the patches at: http://www.handshake.de/~dieter/pyprojects/zope/pydoc.html will also work. Regards, Damon.

2 1

SecurityGetUser object as text
by Bryan C. Andregg 20 Mar '02

20 Mar '02

I have the following Extention def cryptPass(self,username,password): import crypt return crypt.crypt(password,username[:2]) When I call this with, cryptPass(_.SecurityGetUser(),'some pass phrase') Zope returns an error because it cannot perform a slice on the object that SecurityGetUser() returns. Is there a way to just get the text value of that object? -- Bryan C. Andregg Duke University Medical Center Programmer Dept. of Anesthesiology e <bryan.andregg(a)duke.edu> p +1 919 684 6201

2 1

Re: [Zope] Zope Import Directory
by Casey Duncan 20 Mar '02

20 Mar '02

It looks like you are missing the product that the example uses (OpenFlow). Try installing this product as well into Zope. This is just an educated guess, tho, and I'm no OpenFlow expert. perhaps others know more about this specific example demo. -Casey Schmucler wrote: > Casey: > Thanks a lot for the information, but i have the next error > when i import a workflow example WebOrdes.zexp and Demo_english.zexp: > Workflow(This object from the Openflow engine product is broken)Openflow > > 7.0 and i have no a database connection. > How can i fix this error? > Matias > Casey Duncan wrote: > > >>In your zope installation directory (top level). If its not there, >>create it there. >> >>hth, >>Casey >> >>Schmucler wrote: >> >>>Where is the zope import directory? >>> >>> >>>_______________________________________________ >>>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 ) >>> >>> >>> >

1 0

Worldpilot question
by Miguel Rodríguez 20 Mar '02

20 Mar '02

hi you all, I have installed worldpilot version 1.1 and works everything but the inbox ( the most important!!), this is the error I get : Site Error An error was encountered while publishing this resource. IMAPDataException Sorry, a site error occurred. Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 158, in zpublisher_exception_hook (Object: mail) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: prog) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: prog) File /usr/local/zope/lib/python/Products/WorldPilot/WorldPilot.py, line 2146, in prog (Object: mail) File /usr/local/zope/lib/python/Products/WorldPilot/WorldPilot.py, line 2022, in displayIfLoggedOn (Object: mail) File /usr/local/zope/lib/python/Products/WorldPilot/WorldPilot.py, line 372, in callResource File /usr/local/zope/lib/python/Products/WorldPilot/Resource.py, line 137, in callResource File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: <string>) File /usr/local/zope/lib/python/DocumentTemplate/DT_In.py, line 620, in renderwob (Object: Logon.getIMAPFoldersList(REQUEST)) File /usr/local/zope/lib/python/DocumentTemplate/DT_Util.py, line 159, in eval (Object: Logon.getIMAPFoldersList(REQUEST)) (Info: Logon) File <string>, line 0, in ? File /usr/local/zope/lib/python/Products/WorldPilot/WorldPilot.py, line 465, in getIMAPFoldersList File /usr/local/zope/lib/python/Products/WorldPilot/WorldPilot.py, line 421, in getIMAPFolders File /usr/local/zope/lib/python/Products/WorldPilot/WPUtil.py, line 241, in CreateStruct IMAPDataException All the other functionalities seems to work well, but I can´t watch the messages I recieve. AnyIdea?

1 0

User Folders
by Rajesh.T 20 Mar '02

20 Mar '02

Hello Everbody, I'm a newbie and looking for some help with user folders,I have created a user folder and some users in it. Now the problem is I'm not able to log into that URL (folder) when i give that username and password. It works fine with root folder though. I have looked into the acquired permission settings and worked on that front and i belive i'm not making a mistake there coz i deselected the view option in root folder and acquiring that permission for all the other folders. Am i missing something here.... Any help would be appreciated Rajesh

1 0

Displaying users in acl_users caused error
by Andreas Rippel 20 Mar '02

20 Mar '02

Hi, we are managing users in the acl_users folder mostly via python. Our applications works, but when we click on individual users within the acl_users folder, we get the following error message: ... Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: domains ... Traceback (innermost last): File .../lib/python/ZPublisher/Publish.py, line 150, in publish_module File .../lib/python/ZPublisher/Publish.py, line 114, in publish File .../lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: acl_users) File .../lib/python/ZPublisher/Publish.py, line 98, in publish File .../lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_users) File .../lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_users) File .../lib/python/AccessControl/User.py, line 923, in manage_users (Object: acl_users) File .../lib/python/Shared/DC/Scripts/Bindings.py, line 252, in __call__ (Object: _editUser) File .../lib/python/Shared/DC/Scripts/Bindings.py, line 283, in _bindAndExec (Object: _editUser) File .../lib/python/App/special_dtml.py, line 172, in _exec (Object: _editUser) File .../lib/python/DocumentTemplate/DT_Util.py, line 160, in eval (Object: user.domains) (Info: user) File <string>, line 0, in ? AttributeError: (see above) -- Andreas Rippel Universität Kaiserslautern Fachbereich Informatik (AG ICSY) Tel: ++49 (0)631 205 3676 Paul Ehrlich Straße (G32/348) Fax: ++49 (0)631 205 3056 D-67653 Kaiserslautern (Germany) EMail: arippel(a)informatik.uni-kl.de PGP: http://www.icsy.de/~arippel/pgpkey.asc GNUPGP: .../gnukey.asc

2 1

Re: [Zope-dev] Impact of additional protocols handled by Zope?
by Eron Lloyd 20 Mar '02

20 Mar '02

Could this be what I had in mind? I'm thinking more along the lines of a platform versus a product, yet this could be interesting. Do you think there's enough consensus for the community to work together on this one? Or will we have several niche systems instead? I'd prefer that latter, personally. Eron On Tue, 2002-03-19 at 12:35, Florent Guillaume wrote: > Hi, > > Myroslav Opyr <myroslav(a)zope.net.ua> wrote: > > Dieter Maurer wrote: > > >There is a European project called "GroupZope" which will provide > > >integration with IMAP and LDAP. The Nuxeo people may be able to > > >tell more. > > > > > Are there anyone on this list who can give information about progress > > and give licensing/availability info? > > This is a project for which we have already committed resources, but the > IMAP part hasn't started. The LDAP client part is designed to interact > with directories using configurable schemas, and is being currently > worked on. > > We will have a visible product this summer. > It will be released under an Open Source license. > > > >Unlike your proposal, they plan to integrate with existing OpenSource > > >protocol servers. I, too, think this is a better idea than to make > > >Zope learn all different protocols itself. > > > > > What servers OpenLDAP? Cyrus? Jabber? Any info would be helpful. > > Interaction with IMAP and LDAP servers, yes. Jabber is not in the > current plans, even though we're thinking about it. > > > Florent > -- > Florent Guillaume, Nuxeo (Paris, France) > +33 1 40 33 79 10 http://nuxeo.com mailto:fg@nuxeo.com > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) > --- > [This E-mail scanned for viruses by Declude Virus] > > --- [This E-mail scanned for viruses by Declude Virus]

2 1

optional authentication
by Bryan C. Andregg 20 Mar '02

20 Mar '02

I would like, in one dtml document, to present different information to authenticated users and non-authenticated users. That's pretty simple. I would like for users who haven't yet authenticated though, be able to follow a link and provide their credentials, returning to the page mentioned above for the authenticated view. That's pretty simple using a document that requires authentication and then redirecting back to the first page. I'm wondering if there is an easier way (say calling a Zope function) to ask for the authentication credentials and return to the same page. -- Bryan C. Andregg Duke University Medical Center Programmer Dept. of Anesthesiology e <bryan.andregg(a)duke.edu> p +1 919 684 6201

1 0

Developing a general groupware platform in Zope/Python
by Eron Lloyd 20 Mar '02

20 Mar '02

Does anyone think it would be practical/feasible to develop a groupware platform in Zope at this point? I'm thinking very big here, taking it to heights that Worldpilot never mentioned, linking email, workflow, filestorage, newsgroups, project management, contacts, journals, Web presence, jabber messaging, calendaring, and Web service interfaces. Following the development of Zope 3 and component architecture, things are looking very promising. The combination of Python 2.2 and Zope 3 could be a *major* glueing layer between multiple service backends (like IMAP, LDAP, SQL, Jabber, etc.), and something like this could probably be attemptable using that as a toolbox. I'm building some of the components already, such as vCard/iCalendar python libraries, and the possibilities of using Zope to do groupware stuff is very exciting. The type of platform I envision would enable (real-world) community groups to take advantage of all the useful groupware services afforded to companies without having to setup Exchange or Domino. phpGroupWare has the right idea, and I believe that if it can be done in PHP, it can seriously be done in Zope. Should I hold off for a while, and let Zope 3 gel some more, or am I completely off my gourd in attempting this? I've gotten some inspiration from that CrankShaft Zope product from Spoke Technologies. Does anyone know what happened to them, anyways? This is the sort of thing I'd like to emulate, only it would be an open-source platform and target community groups, grassroot activists, and small non-profit agencies. Thanks in advance, Eron --- [This E-mail scanned for viruses by Declude Virus]

7 6