June 2005 - Zope - Zope lists

general design question
by Erik Myllymaki 23 Jun '05

23 Jun '05

I am making a small application for sales and marketing reports in-house. Each user has a unique login/username in zope (via NtUserFolder) and they also have a unique employee_id in exisitng SQL database tables. Each page calls numerous SQL methods almost all of which need to know the employee_id number. I can make a small method getEmpID(request.AUTHENTICATED_USER) and map the logins to the employee_ids, but then I am calling that at least once every page. I could call getEmpID(request.AUTHENTICATED_USER) once when the user logs in and then set it in a cookie or a session variable but I am unsure of the possible security issues in doing that. Or I could start using the zope/NT login as the key in various sales and marketing tables. Just thought I'd *throw it out there* for any input, thanks.

3 2

ZopeProfiler and Zope 2.8.0
by Pascal Peregrina 23 Jun '05

23 Jun '05

Hi, I would like to know if anyone has tried using ZopeProfiler (1.4 version from http://www.dieter.handshake.de/pyprojects/zope/) with Zope 2.8.0 It was working fine with Zope 2.7.6 but it appears to cause the instance to hang with Zope 2.8.0... Thanks. Pascal ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************

2 1

RE: [Zope] External editor for ZMI
by Jim Abramson 23 Jun '05

23 Jun '05

I do recommend Boa Constructor, which feels the most like you're actually editing source code files (though you're editing the zope objects in place). This program has actually saved my life. Caveats: It has a few dependencies you'll need to track down, and it's a little buggy/quirky. If you're not comfortable with a bit of DIY, or you're relatively new to zope and/or python, it might be more trouble than its worth. The 'upload' mechanism in ZMI for most objects might do OK for you, then you can use whatever editing environment you want. I'm sure a lot of people have solved this particular problem for themselves in different ways, based on their own editing needs/preferences. After a little trial and error, of course. Jim > -----Original Message----- > From: zope-bounces(a)zope.org [mailto:zope-bounces@zope.org] On > Behalf Of John Poltorak > Sent: Thursday, June 23, 2005 11:28 AM > To: zope(a)zope.org > Subject: [Zope] External editor for ZMI > > > What alternatives are there to editing objects through ZMI? > > -- > John > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) >

1 0

Search path for objects
by John Poltorak 23 Jun '05

23 Jun '05

Does Zope look anywhere apart from the current folder for objects which are specified like this:- ? <link rel="Stylesheet" type="text/css" href="ploneCustom.css" /> I've cobbled together a website and can't work out where certain CSS tags are being specified. Is there a simple way to determine this? -- John

2 1

ZODB performace/banchmarks
by Tamas Hegedus 23 Jun '05

23 Jun '05

Hi, Two months ago I red about the ZODP that it has high performace, can store high amount of data, but there are no banchmarks e.g. for comparison for RDBMS. Are these true? If yes, why is not created a banchmark or something like that? Thanks, Tamas -- Tamas Hegedus | phone: (1) 919-966 0329 UNC - Biochem & Biophys | fax: (1) 919-966 5178 5007A Thurston-Bowles Bldg | mailto:hegedus@med.unc.edu Chapel Hill, NC, 27599-7248 | http://riordans.med.unc.edu

1 0

Using Zope to Manage an Asset Inventory Database
by Spann, John W. 23 Jun '05

23 Jun '05

I run a local area network of about 200 Microsoft Windows based workstations and about 15 servers. The inventory consists of various pieces of information (make, model, serial number ...) relating to CPU, monitor, keyboard etc. At the present time, the computer inventory is maintained using an Excel spreadsheet. I would like to move/convert this inventory information into Zope, but I am having some difficulty in making the transition. My thinking is to have a hierarchy of objects. A CPU object, monitor object, keyboard object, tape drive, disk drives, etc. Some CPUs and monitors are spares and sit in a storage room. I would like to be able to use Zope and the ability to cut and paste objects to manage this information. If a monitor on a working CPU fails, I would like to be able to launch Zope, find the monitor, remove it from the existing system, pick one from the storage area and logically attach it to the working CPU. In addition, I would like to be able to generate reports/lists for auditing purposes. root |--> storage area | -> monitor | -> monitor | -> cpu | -> keyboard |--> room 1 | -> system 1 | -> cpu | -> monitor | -> keyboard | ->system 2 | -> cpu | -> monitor | ->keyboard |--> room 2 | -> system 3 | -> cpu | -> monitor | -> keyboard |--> room 3 | -> system 4 | -> cpu | -> monitor | -> keyboard I have been looking for examples of how this is done within Zope, but I have not found any working examples. Any thoughts on how to implement a system like this would be much appreciated. -- John W. Spann 410.765.4427 (Work) 410.232.0730 (Pager) Text Message: 4102320730(a)archwireless.net

3 2

Cached Variables
by calisp＠gmail.com 23 Jun '05

23 Jun '05

Hi, I am developing an application that is a front end to an RDBMS. Sometimes, when loading a page, several scripts get called that all require the same information from the database. It would obviously be costly for each script to call the same ZSQL method. My method for avioiding this senario is... Get the scripts to call another script that is a wrapper to the ZSQL method. This wrapper script returns context.REQUEST[value_name] if it exists or, if it does not exist, executes the ZSQL method, stuffs the result into REQUEST[value_name] and then returns it. I am not convinced that this is the right way of dealing with this situation however. Is there a better way? Thanks, Calisp

3 4

From Zope 2.5.1 to Zope 2.7.6
by Tim Suter 23 Jun '05

23 Jun '05

I am upgrading our current Zope from 2.5.1 to Zope 2.7.6. I have the new version installed as a different instance on a different server. The Zope 2.5.1 is in tact and what I am wondering is, how do you migrate everything from the older to the newer? I thought exporting the .zexp out of Zope 2.5.1 would be ok. However, when I import it into the new install, it isn't the same as the original. For example, I exported knowledge.zexp from the 2.5.1 and imported into the 2.7.6. Now, when I go to pull up the page that points to info related to this data, the subtopics are now listed below the contents of the original page. In looking at the html (I am no HTML expert at ALL), it did not appear that there was even anything related to subtopics. It must be a control from within the Zope management interface. I guess I just want to know how to migrate properly with little administrative effort. Thanks, Tim

4 7

bytecode cache?
by Jaroslav Lukeš 23 Jun '05

23 Jun '05

Dear zope core developers, I have idea about bytecode cache in Zope, it is possible to implement? What I mean: python scripts (in ZODB), DTML documents/methods, ZPT will be bytecode compiled in similar way like ordinary .py scripts into .pyc and then run much faster than "noncompiled" ZODB objects. I think that it should have significant speed improvement. ... or I am totally out? Best regards, -- Jaroslav Lukesh ------------------------------------------------------------- This e-mail could not contain any viruses because I use Linux

3 2

TypeError: Cache values must be persistent objects.
by Nikko Wolf 23 Jun '05

23 Jun '05

Help! I'm trying to develop a filesystem-based Product (here 'ABCD') and unless I remove the "ABCD" folder from my Products directory, I get the following error IN THE MANAGEMENT INTERFACE. Is it possible to determine what's causing the problem? After multiple restarts, I did a global "Find" in the ZMI and (I think) deleted all objects of type "ABCD Content". But still the problem persists (no pun intended). Gaah! How can I fix this? ===== event.log contains ========== 2005-06-21T14:57:17 ERROR(200) ZODB Couldn't load state for 0x28b5 Traceback (most recent call last): File "/usr/local/zope/lib/python/ZODB/Connection.py", line 600, in setstate self._set_ghost_state(obj, p) File "/usr/local/zope/lib/python/ZODB/Connection.py", line 639, in _set_ghost_state state = unpickler.load() File "/usr/local/zope/lib/python/ZODB/Connection.py", line 227, in _persistent_load self._cache[oid] = object TypeError: Cache values must be persistent objects. ========== FROM THE ============================= Traceback (innermost last): Module ZPublisher.Publish, line 101, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module Shared.DC.Scripts.Bindings, line 306, in __call__ Module Shared.DC.Scripts.Bindings, line 343, in _bindAndExec Module App.special_dtml, line 175, in _exec Module DocumentTemplate.DT_Let, line 76, in render Module DocumentTemplate.DT_In, line 643, in renderwob Module DocumentTemplate.DT_In, line 771, in sort_sequence Module ZODB.Connection, line 600, in setstate Module ZODB.Connection, line 639, in _set_ghost_state Module ZODB.Connection, line 227, in _persistent_load - __traceback_info__: ('\x00\x00\x00\x00\x00\x009^', ('Products.ABCD.XML_File', 'XML_File')) TypeError: Cache values must be persistent objects. ============================= Plone version: 2.0.5 Zope version: (Zope 2.7.6-final, python 2.3.4, linux2) Apache version: CMF version (if known): CMF-1.4.7 Browser(s) and version(s): Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050511 Operating system: linux2 Python version: 2.3.4 (#1, Feb 2 2005, 12:11:53) [GCC 3.4.2 20041017 (Red Hat 3.4.2-6.fc3)] Debug mode: Yes ============================= ABCD 0.4 ATExtensions 0.6 installed Archetypes 1.3.3-final installed BTreeFolder2 BTreeFolder2-1.0.1 CMFActionIcons 0.9 installed CMFCalendar CMF-1.4.7 installed CMFCore CMF-1.4.7 CMFDefault CMF-1.4.7 CMFFormController 1.0.4 installed CMFMember 1.0.1 installed CMFPlone 2.0.5 CMFQuickInstallerTool 1.5.1 CMFTopic CMF-1.4.7 CMFTutorial 0.1.2 CompositePage CompositePage-0.2 DCWorkflow CMF-1.4.7 Epoz 0.8.5 installed ExternalEditor 0.8 ExternalMethod External Method-1-0-0 FlexibleTopic 1.1 installed Formulator Formulator 1.6.2 GroupUserFolder 2.0.1 installed Lesson 0.1 LocalFS LocalFS-1-7-andreas MIMETools MailHost MailHost-1-3-0 MimetypesRegistry 1.3.3-final05 installed Minimal 0.1 MySite 0.4 installed OFSP OFSP-1-0-0 OpenFlow 1.1.0 PageTemplates PageTemplates-1-4-0 PlacelessTranslationService 1.0 PloneCollectorNG 1.2.6 installed PloneErrorReporting 0.11 installed PluginIndexes PortalTransforms 1.3.4-final installed PythonScripts PythonScripts-2-0-0 Sessions SiteAccess SiteAccess-2-0-0 SiteErrorLog StandardCacheManagers StandardCacheManagers-1-1-0 TemporaryFolder Transience ZCTextIndex ZCatalog ZCatalog-2-2-0 ZGadflyDA ZODBMountPoint ZReST 1.1 ZSQLMethods ZopeTutorial Zope Tutorial 1.2 generator 1.3.0-final17 mxmCounter 1.1.0 validation 1.3.2-final

2 3