- Zope - Zope lists

Web reporting
by Jeff Sacksteder 07 Dec '01

07 Dec '01

I have recently been generating web reports from relational data in our ERP system and would like to process the results a little more than what I can accomplish with SQL alone. Are there any reporting packages available for Zope that are similar in spirit to Crystal Reports or anything like that? I'd like to have a few basic functions like sum and average, etc. I could do this in python, but I would think this kind of thing should be a Product that everyone can use. Does such a thing already exist somewhere?

3 2

Authentication by IP address
by Arian de Wit 07 Dec '01

07 Dec '01

Hi All, I'd like all users browsing the site from 192.168.*.* (i.e. our intranet) to see some additional content. I've read and implemented the HowTo (although * isn't allowed in IP addresses, apparently) and then found via the mailing list archives the "setAuthenticationMode" thing to actually make it work, and only then discovered that it takes *much* longer for pages to load under this scheme. Is there some other way to achieve my goal? Basically, I want intranet users to see an "update/correct this page" form at the bottom of every page, in an effort to help them to help us keep our content fresh and accurate. FYI, I am running Zope 2.4.2 with ZServer on Win2K Server SP2. Many thanks, Arian ------------------------------------------------------------------ Arian de Wit Information Systems Integration Manager NIWA (National Institute of Water & Atmospheric Research) Gate 10 Silverdale Road, Box 11-115, Hamilton, New Zealand 2001 Phone (+64) 7-856 1769 Fax (+64) 7-856 0151 Web http://www.niwa.co.nz ------------------------------------------------------------------

2 1

RE: [Zope] Newbie - User Attributes
by Joshua Lanza 07 Dec '01

07 Dec '01

To answer my own question for posterity, there's a product called User Info Folders that performs this function and stays synchronized with the acl_users object. URL: http://www.zope.org/Members/did/UserInfoFolder Josh -----Original Message----- From: Joshua Lanza Sent: Thursday, December 06, 2001 12:22 PM To: zope(a)zope.org Subject: [Zope] Newbie - User Attributes Hi, Trying to extend the User object (the object exposed in the acl_users folders) to associate some additional fields with a user - essentially creating a user profile. (Ex: when adding a user, have a checkbox asking "do you want us to send you our spam?") Am I looking in the wrong place for persisting user data? It looks like the User object only supports Name, Password, Domains, and Role. TIA, Josh _______________________________________________ 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

Upload HTML crashes zope
by Kari-Hans Kommonen 07 Dec '01

07 Dec '01

hi! we are running ZOPE with CMF on MacOSX, 2.4.1 if I remember correctly, and uploading an HTML file most of the time crashes Zope, unless it only contains the stuff between <BODY> and </BODY> tags. is this a bug or a feature? How to debug if bug? TIA, Kari-Hans Kommonen

1 0

Newbie-ish dtml-with vs dtml-in question
by Russell Hires 07 Dec '01

07 Dec '01

Hello everyone, Is there a way to use the dtml-in tag, and not iterate over the results? The problem I'm having is that I can call a ZSQL method, and pull a variable out of it using dtml-in, and I get a nice iteration over that variable. But in the case of one of my variables, I just want to pull it out, without iteration. I've tried to do it with both dmtl-call and dtml-with, but they don't do what I want, and I get a key error for that variable. Can any one offer any hints at what I should do? Thanks! Russell

3 2

Overflow error with Catalog
by Chris Muldrow 07 Dec '01

07 Dec '01

I'm throwing an Overflow Error when I try to catalog a file--it says "Error Value: long int too large to convert" I'm creating an instance of a catalog-aware ZClass. Following is the traceback. Any ideas? Thanks- Chris M. Traceback (innermost last): File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook (Object: News) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: copy_of_NightStoryUpdate) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: copy_of_NightStoryUpdate) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/OFS/DTMLMethod.py, line 195, in __call__ (Object: copy_of_NightStoryUpdate) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/DocumentTemplate/DT_String .py, line 546, in __call__ (Object: copy_of_NightStoryUpdate) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/DocumentTemplate/DT_Let.py , line 148, in render (Object: thisyear="_.str(ZopeTime().year())" thismonth="_.str(ZopeTime().mm())" thisday="_.str(ZopeTime().dd())" todaysURL="thisyear+thismonth+thisday+'report'") File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/DocumentTemplate/DT_Let.py , line 148, in render (Object: workDir=TestRaw) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/DocumentTemplate/DT_Let.py , line 148, in render (Object: doneDir=Test) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/DocumentTemplate/DT_Util.p y, line 231, in eval (Object: objectMeth(workDir, doneDir)) (Info: doneDir) File <string>, line 2, in f File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/Products/ExternalMethod/Ex ternalMethod.py, line 281, in __call__ (Object: objectMeth) (Info: ((<Folder instance at 9131a90>, <Folder instance at 8c1d870>), {}, (None,))) File /var/zope/Extensions/objectMeth.py, line 32, in objectAdd (Object: News) File /var/zope/Extensions/objectMeth.py, line 362, in addFLSNews (Object: 12062001) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/OFS/ObjectManager.py, line 324, in _setObject (Object: 12062001) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/Products/ZCatalog/CatalogA wareness.py, line 114, in manage_afterAdd (Object: 464799) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/Products/ZCatalog/CatalogA wareness.py, line 184, in index_object (Object: 464799) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/Products/ZCatalog/ZCatalog .py, line 554, in catalog_object (Object: Catalog) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/Products/ZCatalog/Catalog. py, line 439, in catalogObject File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/Products/PluginIndexes/Tex tIndex/TextIndex.py, line 381, in index_object (Object: PrincipiaSearchSource) File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/SearchIndex/GlobbingLexico n.py, line 161, in getWordId File /usr/src/redhat/SOURCES/Zope-2.4.2-src/lib/python/ZODB/Connection.py, line 519, in setstate File /var/zope/lib/python/ZEO/ClientStorage.py, line 365, in load (Object: ('', 8800)) File /var/zope/lib/python/ZEO/zrpc.py, line 239, in __call__ OverflowError: (see above)

2 1

introspection and DatabaseResults objects
by Tom Smith 07 Dec '01

07 Dec '01

Hi, I've created a Python (unsafe) method called "get_related_sql()" which returns a list of <Shared.DC.ZRDB.RDB.DatabaseResults instance at 23023f0> objects. In order to try and work out how to get the data out of these objects, I created another Python (unsafe) method called "inspect()" and tried this... <dtml-in get_related_sql()> <dtml-var "inspect(obj=_['sequence-item'] ) "> </dtml-in> inspect() contains the code... from types import * if type(obj) == InstanceType: return "instance", obj.__members__, obj.__methods__ if type(obj) == StringType: return "string" + ' ' + obj But neither the __members__ or __methods__ bits work. Any ideas how I can discover attributes and methods of arbitrary zope objects thanks -- tom smith | tom(a)othermedia.com http://www.othermedia.com/blog 3rd Floor, The Pavilion, Newhams Row, London, SE1 3UZ 0207 089 5959

2 1

Simple Question about PATH environment variable
by Paul Merrill 07 Dec '01

07 Dec '01

Dear All, I'm doing some content creation for a Zope site and have run into a problem with the PATH variable but need some help. Our system admin has installed zope in the /usr/share/Zope directory and created an init script on the Mandrake System it runs on to start Zope when the system boots. All very standard and works fine. I can access the site with the /manage extension to the url. I have installed DocumentLibrary1.0b3, as downloaded from www.zope.org, and downloaded wvWare from www.wvWare.com so that I can search MSWord files that I stick in the library. wvWare seems to work fine if I login to the system with ssh and execute wvWare from the bash command prompt in my home directory. Now, wvWare is located in /usr/local/bin/wvWare and I when I try and search for text that I know is in one of the files, nothing is found. I have a similar install of Zope on my home PC and it works there BUT at home I start Zope from my bash shell (./start &), thus 'which wvWare' returns /usr/local/bin/wvWare because the PATH contains /usr/local/bin. I'm thinking that for some reason the production site cannot find wvWare in the /usr/local/bin directory because the PATH environment variable has not been set properly since the Zope server is started at system startup and not from a user login. Now for the questions. Can someone give me a dtml or python snip of code to dump the PATH variable to see what it is? Assuming it's wrong, where would one modify the PATH variable so that it could find the wvWare executable? Alternatively, would it make more sense to modify the DocumentLibrary code so that the total path /usr/local/bin/wvWare is referenced from Python? Finally, lets assume nothing above works. What I'd like to do is add some debugging code to the Python code to dump out the input parameters and output results. What's the best approach given that starting Zope from the python debugger is a problem since the site is already running? Is it possible to create a trace file in /tmp that I could shoot some text to and then SSH to the machine and "moreing" the /tmp file? I was thinking of just modifying the appropriate .py file in DocumentLibrary, deleting .pyc and letting Zope figure out the rest (like re-compiling) when I referenced the code. Ideas please would be appreciated. Paul

3 2

strange behavior with manage_pasteObjects and proxy scripts
by Christopher N. Deckard 06 Dec '01

06 Dec '01

I have a proxy script which Authenticated people can call. It runs as a role that has permissions to do most things, but not completely like normal Manager roles. It basically needs to be able to Add Folders, Delete Objects, Add Properties, etc. The script is called "delete" and it's purpose is to remove a folder from its parent folder. Prior to actually deleting the object, the script calls manage_copyObjects on the folder to be deleted, and then calls manage_pasteObjects in a different context, where I want to put the folder. Folder structure is kind of like this: root people user1 events deleted_events user2 events deleted_events tools events delete Say user1 is logged in. What I want is for him to be able to be in user2's events folder, and delete events from the events folder. With the proxied script, he should be able to do this. Here is a code snippet that does the copy and the deletes where "userContext" is the context of user2's folder: # Copy the object to deleted_events what = userContext.events.manage_copyObjects(ids=[eventId]) userContext.deleted_events.manage_pasteObjects(what) # Delete the event from the user's folder userContext.events.manage_delObjects(ids=[eventId]) I think this used to work. At least I never had complaints about it not working, until today. Here's the Zope error message: <H2>Site Error</H2> <P>An error was encountered while publishing this resource. </P> <P><STRONG>Unauthorized</STRONG></P> Sorry, a site error occurred.<p> <!-- Traceback (innermost last): File /data/www/Zope.6/src/Zope-2.4.3-src/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /data/www/Zope.6/src/Zope-2.4.3-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /data/www/Zope.6/src/Zope-2.4.3-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /data/www/Zope.6/src/Zope-2.4.3-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: delete) File /data/www/Zope.6/src/Zope-2.4.3-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: delete) File /data/www/Zope.6/src/Zope-2.4.3-src/lib/python/Shared/DC/Scripts/Bindings.py, line 324, in __call__ (Object: delete) File /data/www/Zope.6/src/Zope-2.4.3-src/lib/python/Shared/DC/Scripts/Bindings.py, line 354, in _bindAndExec (Object: delete) File /data/www/Zope.6/src/Zope-2.4.3-src/lib/python/Products/PythonScripts/PythonScript.py, line 363, in _exec (Object: delete) (Info: ({'script': <PythonScript instance at 8edd9d8>, 'context': <Folder instance at 8d84390>, 'container': <Folder instance at 8d84390>, 'traverse_subpath': []}, ('1007589520SK', 'Confirm'), {}, (None, None))) File Script (Python), line 48, in delete File /data/www/Zope.6/src/Zope-2.4.3-src/lib/python/OFS/CopySupport.py, line 215, in manage_pasteObjects (Object: deleted_events) File /data/www/Zope.6/src/Zope-2.4.3-src/lib/python/OFS/CopySupport.py, line 414, in _verifyObjectPaste (Object: deleted_events) Unauthorized: Add Folders It's saying that I don't have permission to Add Folders, yet that script has proxy roles which do allow it to. Again, I think this used to work, so there must have been a change and it is either broken now or was broken before. manage_delObjects works if I don't do the copy/pasteObjects prior to it. Any ideas? Should I not even be using manage_copy/pasteObjects()? -Chris

2 1

How to update DTML Document contents?
by Carlson, Christopher W. 06 Dec '01

06 Dec '01

I know I've seen this answered before, but for the life of me I can't seem to find where. How does one update the contents of a DTML Document via DTML or Python? Many thanks in advance. --- Chris

2 1