November 2001 - Zope

Help! Trying to create an instance and then change the owner...
by Rob Foster 17 Nov '01

17 Nov '01

First of all, thanks to everyone for their help. I've been trying to figure out how to do this one set of things for ages now. I've sent countless emails to the newsgroup and I still run into problems. Here's my problem, perhaps you can help once more... I'm creating a site where people will come and signup to become members. This is what happens (or should happen): 1. The user fills out a form that has fields to choose their username and password along with a confirmation field. This form posts the python script below which is called "addUser" (I left out the top half of this script which adds a user to the acl_users folder) ------------------------------------------------------------------------------------------ request = container.REQUEST RESPONSE = request.RESPONSE request = context.REQUEST request.set('id', request.form['username']) tmpObj = context.membersfolder.manage_addProduct['MyProduct'] tmpObj.MyZclass_add(tmpObj, request, NoRedir=1) ------------------------------------------------------------------------------------------ As you can see, this script adds an instance of my zclass (MyZclass) in an adjacent folder called "membersfolder" with owner set to my admin account. This works fine, until I add the two lines below which should change the owner: ------------------------------------------------------------------------------------------ #THE FOLLOWING LINE IS LINE 27 - SEE THE TRACEBACK BELOW obj = _.getitem(request.form['username']) context.custom_changeOwnership(request.form['username'], obj) ------------------------------------------------------------------------------------------ The two lines above are supposed to work with the external script below: ------------------------------------------------------------------------------------------ def custom_changeOwnership(self, username, obj): """ explicitly setup changeOwnership for TTW """ acl_users = getattr(self, 'acl_users') #UserFolder source user = acl_users.getUser(username).__of__(acl_users) obj.changeOwnership(user) ------------------------------------------------------------------------------------------ When I add those two lines, I keep getting the following error where "foo" is the username I'm typing in the form: ------------------------------------------------------------------------------------------ Error Type: KeyError Error Value: foo Traceback (innermost last): File /Users/rfoster/Desktop/Zope-2.4.1-MOSX/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /Users/rfoster/Desktop/Zope-2.4.1-MOSX/lib/python/ZPublisher/Publish.py, line 187, in publish File /Users/rfoster/Desktop/Zope-2.4.1-MOSX/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook (Object: LockableItem) File /Users/rfoster/Desktop/Zope-2.4.1-MOSX/lib/python/ZPublisher/Publish.py, line 171, in publish File /Users/rfoster/Desktop/Zope-2.4.1-MOSX/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: addUser) File /Users/rfoster/Desktop/Zope-2.4.1-MOSX/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: addUser) File /Users/rfoster/Desktop/Zope-2.4.1-MOSX/lib/python/Shared/DC/Scripts/Bindings. py, line 324, in __call__ (Object: addUser) File /Users/rfoster/Desktop/Zope-2.4.1-MOSX/lib/python/Shared/DC/Scripts/Bindings. py, line 354, in _bindAndExec (Object: addUser) File /Users/rfoster/Desktop/Zope-2.4.1-MOSX/lib/python/Products/PythonScripts/PythonScript. py, line 363, in _exec (Object: addUser) (Info: ({'script': <PythonScript instance at fdaf60>, 'context': <Folder instance at ffeaf0>, 'container': <Folder instance at ffeaf0>, '_': <TemplateDict object at 0xcbfa20>, 'traverse_subpath': []}, (), {}, None)) File Script (Python), line 27, in addUser (Object: guarded_getitem) KeyError: (see above) ------------------------------------------------------------------------------------------ I should also note that the binding in my script is set to: "_" Any help would be appreciated. I must really suck. I've been working on this same darn problem for almost three weeks now... ugh. I should also mention that I'm pretty green... All this code was written by others and I'm just trying to get it all to work right (I'm no programmer) Thanks in advance, Rob

2 1

Re: [Zope] Change ZClass icon?
by Lars Heber 17 Nov '01

17 Nov '01

Icons are now changed. Don't know, why they are now. It just was updated about half an hour after posting my message. Sorry... -- Lars Heber, mailto:Lars.Heber@t-systems.de T-Systems, debis Systemhaus GEI GmbH, Geschaeftsstelle Sachsen

2 1

Deleting ZClasses
by Ben Ocean 16 Nov '01

16 Nov '01

Hi; How do I get rid of old ZClasses? TIA, BenO

2 4

Houston, TX. Zopers?
by alan runyan 16 Nov '01

16 Nov '01

Hi. I'm just doing a quick poll to see if there are any Houston Zope Users around these days ;) I lost most people's email addresses. I will be doing a ZOPE presentation at HLUG on December 3. I have a surprise for all that come. Please email me, runyaga(a)thisbox.com if you in or around the Houston area. Especially if you are interested in doing ZOPE development. thanks, runyaga

1 0

Using DTML in filename_expr=" "
by Trevor Toenjes 16 Nov '01

16 Nov '01

This should be simple, but has escaped me. What is the syntax to insert a variable into ""? This is to name the file attachment to an email. I have tried the entity syntax(reserved for HTML), but nothing works. <dtml-boundary type="application/octet-stream" disposition="attachment" encode="base64" filename_expr="'&dtml.-filename;'+'.vcf'"> TIA, -Trevor

1 1

Re: [Zope] Editing ZClasses - Hole in Documentation
by complaw＠hal-pc.org 16 Nov '01

16 Nov '01

Casey: As always, Thanks for your reply. I did actually find out about the manage_editProperties way to change things. However, what is left unsaid (and was really the purpose of my message) was that the way to set up the edit functionality in a ZClass is lacking. How can I have an extra method in a ZClass that sets up the edit screen and then tells a particular function to perform the edit? What I see now is that I have to have a separate DTML method (for the edit form) and a separate python script or DTML Method to actually modify the properties. What would be really nice would be to have the ZClass wizard set up an "editForm/edit" set of objects, just as it does the "addForm/add" objects. If you don't want the user to edit anything, simply restrict their access from the editForm object. That would make ZClasses much more attractive to site developers that just want to have a few extra properties of say, a DTML Document, but don't want to go through the hassle of making a python product. The way the system works now is that ZClasses are relatively easy to make and a real bear to edit (from the developer side). This makes ZClasses intitially attractive (because they are easy to make) but largely unwieldy in real life if your application needs to edit parameters in classes (which happens all the time). I will look into the book. Thanks for the plug. Best wishes (to all), Ron > On Thursday 15 November 2001 06:55 am, Ronald L. Chichester allegedly wrote: > [snip] > > Some of us have products we would like to roll out that require that > > users (including managers, owners, and yes, sometimes even anonymous (if > > your organization can handle that)) to edit the ZClass instance once it > > has been instantiated. I'm still hunting for either documentation or an > > example that has this capability. In a few instances, I have seen > > people say it is "trivial." It may be, once you find out how. > > Unfortunately, there is still some smoke and mirrors here. The solution > > isn't obvious to the casual developer. > > > > If someone can prove me wrong, I would be thrilled to know about it. > > > > Best, > > > > Ron > > You dare to suggest that there is a capability of Zope that is undocumented? > I find the mere suggestion of this utterly infathomable! > > Seriously, tho, the API of Zope and especially ZClasses is pretty opaque in > places, unless you like hunting through the source code, which in the case of > ZClasses doesn't help much without Jim F. looking over your shoulder... 8^) > > Actually there is an example of how to do this right under your nose. The > default constructor method of the ZClass has the important call syntax in a > comment as an example. Something like: > > <dtml-call expr="propertysheets.Basic.manage_editProperties(REQUEST)"> > > Now, manage_editProperties is fine so long as you want to change all of the > properties at once, but not if you only need to change one or two. For that, > use manage_changeProperties. > > This call would work in response to a form (either from Python or DTML): > > propertysheets.my_property_sheet.manage_changeProperties(REQUEST) > > just make sure the ZClass instance is at the top of the namespace stack, > which is easily accomplished using the URL as in: > > http://zope/path/to/instance/editMethod > > <plug type="shameless"> > You can find a complete example of a ZClass based app in the newly-published > "Book of Zope" which is sadly only available in dead-tree form. Although you > can download the ZCatalog chapter at www.nostarch.com. > </plug> > > hth, > /---------------------------------------------------\ > Casey Duncan, Sr. Web Developer > National Legal Aid and Defender Association > c.duncan(a)nlada.org > \---------------------------------------------------/ >

4 4

How do I set configure my zclass so only an instance owner can edit permissions?
by Rob Foster 16 Nov '01

16 Nov '01

I've got a script that creates an instance of my zclass and sets the owner as the currently logged in user. How do I set it up so only instance owners can edit their properties and/or view certain methods? Any help would be appreciated. Thanks, Rob

2 1

RE: [Zope] updating excel as an odbc datasource
by Meilicke, Scott 16 Nov '01

16 Nov '01

The problem is that I can't replace the production version while zope is running. Even when I close the database connection, then try to erase the file I get: 'The process cannot access the file because it is being used by another process' I have also tried to change the odbc source from file1.xls to file2.xls, stop and start the database connection within zope, but zope, or the odbc connection, just won't let go of file1.xls, and does not see the new file2.xls. - Scott -----Original Message----- From: Alan C [mailto:alanc@tech-world.com] Sent: Friday, November 16, 2001 9:03 AM To: zope(a)zope.org Subject: RE: [Zope] updating excel as an odbc datasource Since you said that this will be updated periodically, you might consider having a production version and an updateable version of the xls. When the updates are made, copy it to the production folder. This should eliminate the locking contention. Not a good solution for constantly updated databases, but good for periodic things. - Alan --------------------------------------- Zope tips and tricks site http://twsite.bizland.com/zopetips.htm > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of > Meilicke, Scott > Sent: Friday, November 16, 2001 10:21 AM > To: zope(a)zope.org > Subject: RE: [Zope] updating excel as an odbc datasource > > > I have enabled sharing on the worksheet, and I can actually modify/rename > the file while zope isn't running, but not when zope is running. I have > also ensured odbc is read only, as well as passing the 'Read' > string in the > zope connector. Oh I think I see, perhaps the odbc driver isn't > locking it > until Zope requests it? If that is the case, then using Access as the > datasource may not work out either. I haven't yet tried making the file > read only on the filesystem yet - that may help. > > Hmmm. Perhaps I'll use the excel com object to extract the cells I need. > Using excel as a database source just isn't pleasant. More and > more I like > the idea of re writing using zope... > > Scott > > -----Original Message----- > From: Casey Duncan [mailto:c.duncan@nlada.org] > Sent: Friday, November 16, 2001 8:14 AM > To: Meilicke, Scott; zope(a)zope.org > Subject: Re: [Zope] updating excel as an odbc datasource > > > On Friday 16 November 2001 10:56 am, Meilicke, Scott allegedly wrote: > > I think I explained this incorrectly. > > > > I just want to display information from excel with zope. I have no need > to > > update the excel spreadsheet from zope. The customer needs to > be able to > > update the excel spreadsheet by opening the excel file with excel, > > modifying the contents, and save the contents back to the file. Zope > > should then see these changes and display the web page appropriately. > > > > Based on the feedback so far, I have a few options: > > > > 1. Build it all in zope - more work, but may be worth it > > 2. Since it is zope that is doing the locking, have an access > db that gets > > it's info from excel, and use the access db as the datasource > feeding zope > > 3. Update everything manually, as the data change about once a week > > > > I'm currently using #3, and I will be pursuing #2 today. The > advantage of > > #1 is I can reuse the functionality across more applications, all user > > maintained - the best long term solution, as I understand the > requirements. > > > > Thanks for everyone's feedback. > > > > Scott > > It is not really Zope locking it, it is the ODBC driver. Perhaps > there is a > setting or a newer version that does not lock. I know in Excel it is > possible > to set up a file so that it can be shared. Perhaps you need to do this so > that editing can take place while Zope is reading the file. > > hth, > /---------------------------------------------------\ > Casey Duncan, Sr. Web Developer > National Legal Aid and Defender Association > c.duncan(a)nlada.org > \---------------------------------------------------/ > > _______________________________________________ > 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 ) > > _______________________________________________ > 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 ) > _______________________________________________ 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

RE: [Zope] updating excel as an odbc datasource
by Meilicke, Scott 16 Nov '01

16 Nov '01

I have enabled sharing on the worksheet, and I can actually modify/rename the file while zope isn't running, but not when zope is running. I have also ensured odbc is read only, as well as passing the 'Read' string in the zope connector. Oh I think I see, perhaps the odbc driver isn't locking it until Zope requests it? If that is the case, then using Access as the datasource may not work out either. I haven't yet tried making the file read only on the filesystem yet - that may help. Hmmm. Perhaps I'll use the excel com object to extract the cells I need. Using excel as a database source just isn't pleasant. More and more I like the idea of re writing using zope... Scott -----Original Message----- From: Casey Duncan [mailto:c.duncan@nlada.org] Sent: Friday, November 16, 2001 8:14 AM To: Meilicke, Scott; zope(a)zope.org Subject: Re: [Zope] updating excel as an odbc datasource On Friday 16 November 2001 10:56 am, Meilicke, Scott allegedly wrote: > I think I explained this incorrectly. > > I just want to display information from excel with zope. I have no need to > update the excel spreadsheet from zope. The customer needs to be able to > update the excel spreadsheet by opening the excel file with excel, > modifying the contents, and save the contents back to the file. Zope > should then see these changes and display the web page appropriately. > > Based on the feedback so far, I have a few options: > > 1. Build it all in zope - more work, but may be worth it > 2. Since it is zope that is doing the locking, have an access db that gets > it's info from excel, and use the access db as the datasource feeding zope > 3. Update everything manually, as the data change about once a week > > I'm currently using #3, and I will be pursuing #2 today. The advantage of > #1 is I can reuse the functionality across more applications, all user > maintained - the best long term solution, as I understand the requirements. > > Thanks for everyone's feedback. > > Scott It is not really Zope locking it, it is the ODBC driver. Perhaps there is a setting or a newer version that does not lock. I know in Excel it is possible to set up a file so that it can be shared. Perhaps you need to do this so that editing can take place while Zope is reading the file. hth, /---------------------------------------------------\ Casey Duncan, Sr. Web Developer National Legal Aid and Defender Association c.duncan(a)nlada.org \---------------------------------------------------/ _______________________________________________ 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] first logging
by Chris Keyes 16 Nov '01

16 Nov '01

Hi Hamzatk looks like your mail got mangled my the mail client... Your having problems creating the access file under Windows? I've really not used zope much on Windows having now moved to Linux no my desktop, but I'm pretty sure it should work... Ok, there are a few posibilities 1) Python is not in your path, and therefore the python program did not run... 2) There is a problem due to the lack of some of the unix libraries under windows (but this is unlikely) 3) Something else is getting in the way? Ok, so, here goes... You'll want to be in a dos / command prompt window change to your Zope Root directory type the command if it doesn't work, copy the error messages and what you typed (all of it if possible) and post it back to the list so we can see whats happening... There are lots of windows people out there, so were sure to be able to sort this one quickly... I expect its something simple:-) Chris hamzatk(a)3dresearch.com wrote: > At 10:43 AM 11/15/01 +0000, you wrote: > > As far as I know, they are not going to be the same as any on your system, > when Zope installs for the first time (in a normal install) it creates a > username and password... Once you have logged in you _MUST_ create a new > user, log out and log in again. The default user does not allow you to do > much. > > Under SuSE there may be a default password, but I suspect that it is > generated randomly... > > The good news is that zope comes with a script that allows you to change > this 'emergency' password so that you can get in should you forget your > password. > > To do this, you need to go to your Zope directory, and run the zpasswd.py > file like this > python zpasswd.py -u"MyEmergencyUserName" -p"MyEmergencyPassword" access > > I tried it and didn't work for me on win 98. Is there another way to do it > on win platform? > > > > > > access is the name of the file that contains the emergency user. > > When you restart zope you will be able to log in with this username and > password. > > Hope that gets you up and running... > > ChrisK > > Gaetan GUYODO wrote: > > > Hi, > I'm new user of zope. > I'm under SuSe 7.2, with a zope default installation, but I don't know what > are the default loggin and password for zope access... > anyone can help me ? > thanks, > Gaetan > > > > >

1 0