August 2003 - Zope - Zope lists

using ExternalFile and Plone
by Lee J. McAllister 26 Aug '03

26 Aug '03

Does anyone have any experience using the ExternalFile product in conjunction with Plone? I've successfully made some minor modifications to it (added a few additional properties) and it works fine through the management interface, however I need to allow my users to upload new ExternalFiles without using the ZMI. What appears to be happening is that when attempting to access the manage_addObjectViaGui() function while not in the ZMI zope gives me a 404 error. Since it works fine through the ZMI I'm guessing this is a permissions issue? I'd really appreciate any input or insights on this, it's a big part of a co-op project I'm working on that's coming down to the wire. Lee McAllister ps: thanks to all for the scripting tips the other day _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

2 1

ZopeTime
by garry saddington 26 Aug '03

26 Aug '03

I have managed to add a NisUserFolder to my Plone site, but whenever i try to test it by logging in with an ordinary user account i get an attribute error saying Error value ZopeTime Will this happen if the server has the wrong time or is there another reason? regards garry

2 1

dtml-tree behaviour
by Lee J. McAllister 26 Aug '03

26 Aug '03

Hi, I'm using the <dtml-tree> tag and I'm seeing an unexpected behaviour. Whenever you expand or contract a position of the tree (using the plus/minus icon) it throws me to the last page I viewed as if I'd hit the back button. If there is an instance of the <dtml-tree> on that page the tree will show the tree state correctly but it usually leaves me on the wrong page/folder. Can anyone help me out with where it's pulling the refering page from and what I need to do to override that behaviour? Is it a cookie value, something in the request object that I can work around or am I up the creek on this one? Any insights?? Thanks, Lee _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail

2 1

Virtual Hosting and save forms
by Matt Hapke 26 Aug '03

26 Aug '03

Well, any help on this one would surely be appreciated. I've gone about as far as I think I can go without asking here... I have a Zope server that is relayed through a portal set up like this: The web server is at www.me.com Anything destined for the zope server will have a address of www.me.com/zope/* OK, I actually have this part working 95% correctly. I've tried doing this with an Apache Front end and virtual Hosting, and I've tried using the ol SiteRoot Folder. I've got both to work except, when I fill in a typical form in manager, or plone, or whatever, it never saves the data. I'm bewildered. Examples: I got into root properties under /manage, and change the title. I hit the Save button, and it comes back to the root zope page. I surf up to the properties page again, and no changes. no error either. I go to plone, which has all the links looking perfect as far as I can tell, open a document, make some changes, hit save, and bingo, it doesn't save, just returns me to the page with no changes. I'm at a loss as to what the problem might be. The action URLs in each of the forms are what I think they should be (mapped through the web relay). I would appreciate any help I can get.

2 1

Continuation of my Trials and Tribulations with creating a ZClass Product
by Bill Hewitt 26 Aug '03

26 Aug '03

First off, thanks to everyone for answers to problems I had trouble explaining..... This has been extremely painful to understand so far. Anyway, the query code I have below works up to the return.... It returns the correct stylesheet, but I need to know how to insert a standard template in the Style Sheet ZClass (based on DTMLDocument) so I dont have to edit/add the view every time I create an instance. (manage_clone, manage_add, DTMLFile ?????) Looking into DTMLDocument, I see how to do it in python, but I dont understand how to apply that to python script..... Can someone show me an example of how to do this? WPH My code so far is below: --------- --------- Python code used to create the Style Sheet Instance --------- # Add a new instance of the Style Sheet ZClass request = context.REQUEST from DateTime import DateTime ts=DateTime().strftime('%Y%m%d%H%M%S') id=str(ts) instance = container.StyleSheet.createInObjectManager(id, request) ################################################################## ### I would assume I need to add the Style Sheet document_src here ################################################################## # ***************************************************************** # Perform any initialization of the new instance here. # For example, to update a property sheet named "Basic" from the # form values, uncomment the following line of code: instance.propertysheets.Base.manage_editProperties(request) instance.propertysheets.Custom.manage_editProperties(request) instance.propertysheets.a.manage_editProperties(request) instance.propertysheets.body.manage_editProperties(request) instance.propertysheets.h1.manage_editProperties(request) instance.propertysheets.h2.manage_editProperties(request) instance.propertysheets.h3.manage_editProperties(request) instance.propertysheets.h4.manage_editProperties(request) instance.propertysheets.h5.manage_editProperties(request) instance.propertysheets.p.manage_editProperties(request) # ***************************************************************** if redirect: # redirect to the management view of the instance's container request.RESPONSE.redirect(instance.aq_parent.absolute_url() + '/manage_main') else: # If we aren't supposed to redirect (ie, we are called from a script) # then just return the ZClass instance to the caller return instance --------- --------- Python Code used for the building the public view.... ---------- DATE=DateTime().dd() MONTH=DateTime().Month() DAY=DateTime().Day() YEAR=DateTime().year() ## Build a Date/Time Output to Match variations on "title" String Formats in Style Sheet Properties DAYMONTHDATEYEAR="%s %s %s %s" % (DAY, MONTH, DATE, YEAR) MONTHDATEYEAR=" %s %s %s" % (MONTH, DATE, YEAR) DAYMONTHYEAR="%s %s %s" % (DAY, MONTH, YEAR) DAYMONTHDATE="%s%s%s " % (DAY, MONTH, DATE) DAYDATEYEAR="%s %s %s" % (DAY, DATE, YEAR) MONTHDATE=" %s %s " % (MONTH, DATE) DAYMONTH="%s %s " % (DAY, MONTH) DAYDATE="%s %s " % (DAY, DATE) DATEYEAR=" %s %s" % (DATE, YEAR) DAYYEAR="%s %s" % (DAY, YEAR) MONTHYEAR=" %s %s" % (MONTH, YEAR) MONTHKEY=" %s " % (MONTH) DATEKEY=" %s " % (DATE) DAYKEY="%s " % (DAY) YEARKEY=" %s" % (YEAR) DEFAULT="DEFAULT" ## Look for Day Year (ie - Monday 2003) in Style Sheet (a DTML Document subclass) ## NOTE THAT StyleBook is a container (subclass of Folder) for stylesheet in container.StyleBook.objectValues(['Style Sheet']): if stylesheet.title == DAYYEAR: return stylesheet() #### Here I am returning the proper stylesheet instance - :) #### But how do I template the document_src in the Style Sheet ZClass #### to keep from having to rewrite it for every instance I create? #### (like the default view in DTML Document)

2 1

Script returning a zpt
by Simon Faulkner 26 Aug '03

26 Aug '03

If I call my ZPT with a URL ie show_orders?country=France it works a treat and the ZSql uses the country variable no probs How do I return this URL from a script? return context.show_orders(country='France') doesn't work! Am I miles off? Simon

3 2

Send an email with attachment (from a python script)
by Jean Baltus 26 Aug '03

26 Aug '03

Hi all, How can I send an email with an attachment from a python script? Right now, we are using a script that looks as follows: mailhost=context.MailHost mailApproval = context.mail_template(context, email=email) mailhost.send(mailApproval) where "mail_template" is a page template that looks as follows: To: <span tal:replace="options/email" /> From: "<span tal:replace="here/email_from_address" />" Subject: A Subject Content-Type: text/plain; charset=<span tal:replace="here/portal_properties/site_properties/default_charset" /> BODY BODY BODY BODY BODY BODY BODY BODY BODY BODY BODY BODY BODY Anybody has an idea to add an attachment to this? Regards, -- Jean Baltus

3 2

Get the text, not the result, from external_validator field
by Ralph vd Houdt 26 Aug '03

26 Aug '03

Hi All, For development purposes I am writing myself an overview of all my Fomulator Forms. In this overview I'm trying to print the text, not the result, of the external_validator field of a specific fomulator field. Does anyone know how to get the text of that field? I started like this and tried everything: "container['the_form'].get_field('the_field') --- how to get the external validator text ---" Greetings Ralph vd Houdt

1 0

Photo & Photofolder: broken pipe (err32)
by Tim Willems 26 Aug '03

26 Aug '03

Hi, I'm having trouble with Photo & Photofolder. When adding new jpgs to a new or existing Photofolder I get an "err32: broken pipe" error. In ZMI I can see the thumbnail fails to generate, the actual photo however can be shown when called directly. I'm using Imagemagick but it seems Zope doesn't find it. Never had problems with the product before, but after a server crash we reinstalled everything. Something wrong installed? Incompatible versions? Please feedback, I have this thing running on production sites! Thanks a lot, Tim Met vriendelijke groet, _______________________________________________ Tim Willems - Architect Planet Interior bvba Brouwerijstraat 16 2200 Noorderwijk Belgium mob: +32 (0)496 532377 tel: +32 (0)14 279396 fax: +32 (0)14 264790 email: tim(a)planetinterior.com portfolio: www.planetinterior.com This email and any attached files are confidential and may be legally privileged. If you are not the intended recipient, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this email. Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore is in no way liable for any errors or omissions in the content of this message, which may arise as a result of email transmission. If verification is required, please request a hard copy.

2 1

Z SQL Method, ZMySQLDA, connection pooling, threads, life, the universe, and everything
by Dennis Allison 26 Aug '03

26 Aug '03

I'm about to add connection pooling for MySQL. This necessarily interacts with threading and persistance and other arcane arts. Advice and/or pointers to hidden gotchas would be much appreciated. Mu understanding: Zope runs multiple threads (up to 7 without recompiling -- it's a ZODB connection limit) using the underlying Python threading model. The scheduling unit for threads is a single HTTP transaction. (IS THIS RIGHT?) Threads are scheduled out of the medusa asyncore by polling select. Python local data is, of course, automatically thread-safe. Global data is not and is shared across threads. Persistence is mostly orthogonal to the thread issue. When created, each ZSQL method searches for and binds to one particular RDBMS adaptor. For my pooled connection approach, there'd be only one ZMYSQLDA instance to which all ZSQL Methods would bind. The ZSQL Method would find the connector by acquisiton (as it does currently) and allow binding to one or another of the predefined virtual connections. Most of the changes look simple. The ZMySQLDA mechanism will need some significant changes, some of which need to be thread safe. ZMySQLDA and MySQLdb are thread-safe at level one, that is, threads may share the modules but **not the connections**. On startup, there are no actual database connections only virtual connections. Connections are created (up to a max number) as needed and retired (that is, closed) when they are no longer needed. If the virtual connections are tagged with the Zope thread (how does one identify which thread) virtual connections become thread safe (since a different actual connection is allocated for each executing thread)--a feature which should give a performance boost when certain connections are hot spots. Allocation and deallocation of actual connections will need to be under the control of a lock on some shared data structure. A simple mangement strategy can be used provided database transactions complete before the thread is rescheduled. Because this is being patched into a Zope Product that is a heavy reuser of Zope, I've been pondering the best way to fit this feature transparently (or nearly transparently) into the existing code. Given the system structure, it seems to me that the shared data strutures and methods can be maintained as class variables (that is, shared accross instances) while each instance has its own (lightweight) state. Is there any better system structure which will meld neatly into the Zope structure. -dra

2 2