November 2003 - Zope

Announce: Zope 2.7.0 beta 3 released
by Brian Lloyd 18 Nov '03

18 Nov '03

Zope 2.7.0 represents a concentration on software configuration and installation improvement over older versions. Note that Zope 2.7 now requires Python 2.3.2. You may download Zope 2.7.0b3 from Zope.org at: http://www.zope.org/Products/Zope/2.7.0b3/2.7.0b3 Particular features of interest in Zope 2.7.0: - DBTab integration (mounted databases for Zope). - New logging module support. - ./configure; make; make install installation from source - configuration-file-driven configuration - integration of ReStructuredText - OrderedFolder support - Many bugxfixes For more information on what is new in this release, see the CHANGES.txt and HISTORY.txt files for the release: - http://www.zope.org/Products/Zope/2.7.0b3/CHANGES.txt - http://www.zope.org/Products/Zope/2.7.0b3/HISTORY.txt For more information on the available Zope releases, guidance for selecting the right distribution and installation instructions, please see: - http://www.zope.org/Documentation/Misc/InstallingZope.html Brian Lloyd brian(a)zope.com V.P. Engineering 540.361.1716 Zope Corporation http://www.zope.com

1 0

CSV or DSV processing
by Brian Sullivan 18 Nov '03

18 Nov '03

I want to read and parse CSV files ( and output CSV files but I can probably do that myself) in a Python script for my Zope site. Any hints on the best strategy? I see a number of Python modules around doing CSV or DSV processing. Would the best strategy be to turn those into an external python method? Is there something around ready to go? What modules have others used successfully?

3 4

Setup on 2 dual-processor machines
by Wade Leftwich 18 Nov '03

18 Nov '03

Hello, I have a Zope application running on a Win2K box in a very stock configuration -- binary install, no ZEO, no Squid. Now I have the high-quality problem of more traffic than this setup can handle. I have two dual-CPU servers available to host this application in a pretty much dedicated way. They both have Win2K server installed, but with a bit of effort (travel to the remote hosting facility) they could run Linux. I can get a third dual-CPU box if it's needed. Anyone care to offer advice on the best architecture for this equipment? I have read up a bit on ZEO and Squid; have never messed with CPU affinity, but am willing to learn. Thanks Wade Leftwich Ithaca, NY

3 2

ZSQL-Caching strategy
by Sebastian Krollmann 18 Nov '03

18 Nov '03

Hi, I am looking for a general advice for a caching-strategy for zsql-methods: I have to execute 2 sql-queries in sequence: Query one (Q1) limits the table-data to a certain amount. This query does not change often and should be cached. Query two (Q2) selects a part of the results of query one. Q2 is dynamic. What is the best strategy (performance, data-transfer) to cache Q1in ZOPE if I can not use views or stored procedures on the db-side? -- thanks for any hint, Sebastian K. (Please answer to my mail address directly as I am currently not subscribed to this list, thanks)

2 1

Installing MySQL on Windows
by Tom P. Allred 18 Nov '03

18 Nov '03

Hi, I want to use MySQL with my Zope 2.6.1 on Windows ME. Searches of the Zope site, mailing list archives and Google provided lots of (sometimes confusing) hits including http://zope.org/Members/horily/mysqldb_install which says: I found a method of install mysqldb. 1. Download python 2.1.3 from www.python.org and install it. 2. Download MySQL-python-0.9.2.win32-py2.1.exe from sourceforge.net and install it. 3. Goto Python2.1 installation dir , copy files list in MySQL-python.exe-wininst.log to "{Zope Home Dir}\lib\python". 4. Install ZMYSQLDA. 5. Restart Zope,everything is Ok. Other leads seem to say I only need the exe. Would someone who has been through this please comment before I goober things up? Thanks, Tom P. Allred, MCSE, RHCE, CCNA Allred Data Consulting, Inc. 888-381-0611 www.AllredData.com Tom(a)AllredData.com

1 0

Event bug
by Roberto Campainha 18 Nov '03

18 Nov '03

Hi folks, Sorry to ask you such stupid question.. I´m a newbie with a weird problem. Everything was working fine with Plone, until yesterday morning. Now there´s a weird form (image attached) instead of the common form, the calendar is transparent, the idiom is misconfigured and nothing seems to make sense. That happens only when I try to create an EVENT. It doesn´t matter if I use an administrator account or a regular user account. Everything else is working fine. Any clue? Thanks in advance, Roberto Campainha --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003

1 0

RE: [Zope] Pathnames in uploaded files
by Wilson, Derek 18 Nov '03

18 Nov '03

Well, I'd create a python expression to first reverse the string, then un-reverse it while scanning for a "/,\,:" and stop. Thanks, Derek Wilson -----Original Message----- From: J Cameron Cooper [mailto:jccooper@jcameroncooper.com] Sent: Thursday, November 13, 2003 3:00 PM To: Mark Barratt Cc: ZOPE ZOPE mailingliste Subject: Re: [Zope] Pathnames in uploaded files Mark Barratt wrote: > I have a dialogue that uploads files to LocalFS. When I upload a file > from my Windows machine it uploads filename.ext. When another person > uploads a file from their Windows machine it uploads a file called > \\complete\path\to\filename.ext. > > Any idea why this should be? It shouldn't be. But IE in at least some popular incarnations uploads the entire path of the file as a name. Naturally, this is against considerations of privacy, security, and interoperability. (Plus, probably, standards compliance.) > And how to stop it? Glibly, use a browser that isn't broken. There are work-arounds, of course, and you can find them on the list (or simply think up a simple Python expression that will fix this.) But it's very hard to make a universal solution to the problem because of the wide variety of path notations. --jcc -- "Code generators follow the 80/20 rule. They solve most of the problems, but not all of the problems. There are always features and edge cases that will need hand-coding. Even if code generation could build 100 percent of the application, there will still be an endless supply of boring meetings about feature design." (http://www.devx.com/java/editorial/15511) _______________________________________________ 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 )

3 2

XML processing
by Brian Sullivan 18 Nov '03

18 Nov '03

I need to be able to examine ( and perhaps modify) an xml file using Python scripts in zope ( 2.6.2). I am currently examining Zope XML Objects (http://zope.org/Members/haqa/XMLKit) for use -- is this recommended strategy or are their other strategies or products? Hints?

3 4

Adding new property to an image file
by Mico Siahaan 18 Nov '03

18 Nov '03

Hi, I am making a form that would permit user to upload image file into Zope system. The user have to fill the information required such as: id, title, file to upload and short story about that image. So I make this DTMLs: addImage_html: <dtml-var standard_html_header> <form method="post" action="addGalery" enctype="multipart/form-data"> <p>Id : <input type="text" name="id"> <p>Title: <input type="text" name="title"> <p>Description: <input type="text" name="description"> <p>File: <input type="file" name="file" value=""> <p><input type="submit" name="submit" value="Save Image"> </form> <dtml-var standard_html_footer> addGalery: <dtml-var standard_html_header> <dtml-var REQUEST> <dtml-call "manage_addImage(REQUEST.id, REQUEST.file, REQUEST.title)"> <dtml-call "RESPONSE.redirect(URL1+'/toc')"> <dtml-var standard_html_footer> --- The problem is I want to add a new property (description) to each image created by addGalery DTML Method. I have put this in addGalery: <dtml-call "REQUEST.id.manage_addProperty('description',REQUEST.description,'string')"> But it failed. I know that manage_addProperty method is an object method and REQUEST.id would not return the object I need. My question is: how to correct the DTML statement above? TIA -- Mico Siahaan ------------- mico(a)intermatik.co.id

2 1

getting at ZCatalog data object in Python
by Tom P. Allred 18 Nov '03

18 Nov '03

I'd like to return the data object a ZCatalog entry points to so a ZPT can display the data. Currently I'm doing it in a 2-step process where a Python script finds/returns the catalog entry and the ZPT uses getObject to define a variable to get at the actual data. What I want to do is have the Python script find the catalog entry then return the actual data object to the ZPT. CatalogClientTest Script excerpt: # normally uses variables instead of hard-coded values zcat = context.Catalog(datatype='client',id='12346') return zcat ZPT excerpt: <body tal:define="results container/CatalogClientTest"> ... <div tal:define="cdata result/getObject"> ... <span tal:replace="cdata/cl_lastname">client lastname</span> I can get at the data object in the Python script if I hardcode the data_record_id: clientrec = context.Catalog.getobject(833051159) return clientrec but I can't figure out how to get from zcat to clientrec programmatically. Any advice? Thanks, Tom P. Allred Tom(a)AllredData.com

3 3