March 2001 - Zope - Zope lists

MySQL user folder broken!!
by angie tel 26 Mar '01

26 Mar '01

I have been downloaded the MySQL user folder version 0.5.3 and MySQLdb 0.3.4 into my website products, the Zope version is 2.3 ,but when i restart my zope it shows that the MySQL user folder is broken and the traceback is like this:- Import Traceback Traceback (innermost last): File "C:\Program Files\WebSite\lib\python\OFS\Application.py", line 530, in import_products product=__import__(pname, global_dict, global_dict, silly) File "C:\Program Files\WebSite\lib\python\Products\mysqlUserFolder\__init__.py", line 12, in ? import mysqlUserFolder File "C:\Program Files\WebSite\lib\python\Products\mysqlUserFolder\mysqlUserFolder.py", line 11, in ? import cfg, util, vdb, db, log File "C:\Program Files\WebSite\lib\python\Products\mysqlUserFolder\vdb.py", line 16, in ? from db import dbConnection File "C:\Program Files\WebSite\lib\python\Products\mysqlUserFolder\db.py", line 10, in ? import MySQLdb, _mysql ImportError: No module named MySQLdb i have tried to copy the MySQLdb into website/bin/lib and also on top of the website but still not work. Please let me know as soon as possible TQ! _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

2 1

Z Class problem
by Kenneth Ellested 26 Mar '01

26 Mar '01

I'm trying to make a list of available properties in a Z Class like: list = [] for x in context.Control_Panel.Products.MyProduct.MyZClassItem.propertysheets.common. MySheet1.propertyIds(): list.append(x) list.sort() return list This works fine _IF_ the ZClass are located in the root of the product. However I'd like to put this class inside another ZClass. But then I get into problems when trying to find the "path" to the propertysheet. Like (NOT working): context.Control_Panel.Products.MyProduct.MyZClassContainer.MyZClassItem.prop ertysheets.common.MySheet1.propertyIds(): I've tryed with everything in the path, methods, common, methods['MyZClassItem'] etc. - I can't figure it out... HELP ! Regards

1 0

[SybDA+Solaris]Connection closed randomly
by Tony Moutaux 26 Mar '01

26 Mar '01

Hi folks ! I run Zope on several platforms. One of them give me a little problem: Sybase v12.0 +Zope2.3.0 + Sun E450 with Solaris 2.7 + SybaseDA v2.0b2 + Python1.5.2 (all recompile and freshly installed). When I run the same system on Linux : no problem. But with the Sun, the Sybase DA closed randomly and don't want to reopen the connection (or can't ?). I just have to restart the Zope Server to have the Sybase DA rerun correctly. 1-Has anybody run Sybase v12.0 + Zope correctly on Sun ? 2-Has anybody got the same problem previously ? 3-How can I log problems from Sybase DA (Is there a Python/Zope "stderr" that I can use ?) Any suggestion (other than" Run on Linux" because I know, but the System Administrator won't) ? Thanks. Tony

1 0

ParsedXML and zope2.3.1b3
by bak 26 Mar '01

26 Mar '01

hi i can't add any ParsedXml instance. i got a name error any ideas, anybody? thanks -- </P> <P><STRONG>NameError</STRONG></P> Sorry, a Zope error occurred.<p>  -----------8<------------------- http://www.kedai.com.my/kk http://www.kedai.com.my/eZine http://www.zope.org/members/kedai use Zope? you got HOPE

1 0

How to pass values from python script back to calling dtml-method ???
by Duncan Booth 26 Mar '01

26 Mar '01

> Greeting, people ! Greetings back, but please could you try not to post HTML to the mailing list. > I may seem completely ignorant, but Zope namespaces are driving me > wild for the last couple of days :-( I need to solve a pretty simple > task: I have a dtml-method which calls a Python script. When that > python script is through, it has a variable (say, returnValue="return > value"). How can I access this variable in calling dtml method ? > Please help !!!!! If you want to return a single value, just return it and use dtml-var to insert it into your document at one location, or dtml-let to save the value for use in several places. DTML: <dtml-var myscript> PythonScript myscript: return "return value" If you want to return multiple values, then return a namespace object and use dtml-with to make the values available for use. The example below shows the technique I prefer, which is to make all python scripts return a namespace. For example, the following code is taken from a simple shopping basket system. basketSummary displays a one line summary of the basket contents: <dtml-comment> This method returns an HTML segment that displays a summary of the contents of the current shopping basket. </dtml-comment> <dtml-with "logic.basketContents()"> <p class="small">Shopping Basket: <dtml-var numlines> lines, <dtml-var numitems> items, Total Value: <dtml-var totalvalue fmt="$%1.2f"> </p> </dtml-with> The python script basketContents, kept in the logic folder, retrieves the current contents of the basket and looks like this: if not context.REQUEST.has_key('SESSION'): context.Session(REQUEST=context.REQUEST) basket = context.REQUEST.SESSION.get('basket', None) or [] customer = container.customerData() # Return the basket contents. contents = [] totalvalue, items = 0.0, 0 for c, d, u, q, p in basket: contents.append(namespace(code=c, description=d, unitprice=u, quantity=q, price=p)[0]) totalvalue, items = totalvalue + p, items + q shipping = 4.95 total = totalvalue + shipping vars = namespace(contents=contents, totalvalue=totalvalue, shipping=shipping, total=total, numlines=len(contents), numitems=items, customer=customer[0]) return vars Notice that for the summary display we are just interested in the totals. The code that does the full display can get at the individual lines using dtml-in: <dtml-with "logic.basketContents()"> <dtml-in contents> <dtml-var description> <dtml-var unitprice> etc. </dtml-in contents> </dtml-with> Note that the namespace function actually returns a tuple containing the namespace as the first (only) element. This is fine when returning the final result, but for building a list of namespaces you have to remove the extra tuple wrapping, hence the [0] in the append call (and also the customer[0] since customer was the result of another call to namespace). -- Duncan Booth duncan(a)rcp.co.uk

1 0

Can I trust the variables?
by Jan-Frode Myklebust 26 Mar '01

26 Mar '01

Hi, I'm doing a external method that's supposed to zip-up files selected via LocalFS, and I'm wondering if I can trust the special variables set in a request. Can I trust that f.ex. URL/URLn/URLPATHn are from where the external method was called, and not set by the user via http-headers? Have anybody else added support for ziping up selected files with LocalFS? -jf

1 0

Re: [Zope] mounted database howto...
by Bak ＠ kedai 26 Mar '01

26 Mar '01

-----Original Message----- From: Chris McDonough <chrism(a)digicool.com> To: zope(a)zope.org <zope(a)zope.org> Date: Monday, March 26, 2001 6:38 AM Subject: [Zope] mounted database howto... >A while back, somebody wrote a mounted database howto (specifically for use >with CoreSessionTracking)... I've not only forgotten where it was, I've >forgotten who wrote it! > >Anyone remember? > > i think randy wrote it www.zope.org/Members/randy/ZEO-Sessions >_______________________________________________ >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

easy python script
by Peter Bengtsson 26 Mar '01

26 Mar '01

in DTML I do this... <dtml-in "folder.objectValues('DTML Document')" sort=title reverse> How do I do the same in a python script? Here's a good start. for thing in context.folder.objectValues('DTML Document'): Strange, that this one's never crossed my mind, but never mind about that. Peter

2 1

mounted database howto...
by Chris McDonough 25 Mar '01

25 Mar '01

A while back, somebody wrote a mounted database howto (specifically for use with CoreSessionTracking)... I've not only forgotten where it was, I've forgotten who wrote it! Anyone remember?

1 0

Python Script problem
by Ronald L. Chichester 25 Mar '01

25 Mar '01

Okay, I think there is a context problem here, but I'm not sure. So I turn to the experts... What I'm trying to do is allow users to create folders in some root folder. There are two DTML Methods and one Python script: 1. The first DTML Method is a form to gather certain information from the user. 2. The second DTML Method is an "action" method which accepts the "post" form data from (1.) and where I have some DTML code to assign a unique ID before I call the script. 3. Is a Python script that is called by (2.) and which is supposed to create a Folder, assign some properties to it, and create an index_html DTML method within that new folder. Here is the code for the first DTML method (1. addClientForm)... <dtml-var standard_html_header> <h2 align="center">Add a client.</h2> <form action="addClientAction" method="post"> <table border="0" width="95%" cellspacing="8" align="center"> <tr> <td width="25%" align="right">Name:</td> <td width="75%" align="left"><input type="text" name="client_name" value="" size="40"></td> </td> <tr> <td width="25%" align="right">City/State:</td> <td width="75%" align="left"><input type="text" name="client_location" value="" size="40"></td> </td> <tr> <td width="25%" align="right">Main Telephone:</td> <td width="75%" align="left"><input type="text" name="client_telephone" value="" size="40"></td> </td> <tr> <td width="25%" align="right">Main Facsimile:</td> <td width="75%" align="left"><input type="text" name="client_facsimile" value="" size="40"></td> </td> <tr> <td width="25%" align="right">Main Web Site:</td> <td width="75%" align="left"><input type="text" name="client_web_site" value="" size="40"></td> </td> <tr> <td width="25%" align="right" valign="top">Description and<br>General Comments:</td> <td width="75%" align="left"><textarea cols="40" rows="10" name="comments" wrap="virtual"></textarea></td> </tr> <tr> <td width="25%" align="right"></td> <td width="75%" align="left"><input type="submit" value="submit client name"></td> </td> </table> </form> <dtml-var standard_html_footer> Here is the code for the second DTML method (2. addClientAction)... <dtml-var standard_html_header> <dtml-call "REQUEST.set('ts', ZopeTime())"> <dtml-call "REQUEST.set('id', _.str(_.int(ts)))"> <dtml-call expr="addClient(id=id, client_name=client_name, client_location=client_location, client_telephone=client_telephone, client_facsimile=client_facsimile, client_web_site=client_web_site, comments=comments)"> <p>If you made it this far, something went right.</p> <p><a href="<dtml-var URL1>">Return</a> to the main window</a> <dtml-var standard_html_footer> Here is the python script (3. addClient) """ This code actually creates a folder for the client and a default index_html file linking to the contact/incident code. """ # Create the index_html template... index_template = """<dtml-var standard_html_header> <H2 ALIGN="center><dtml-ver title_or_id></H2> <P> <TABLE WIDTH="95%" ALIGN="center" BORDER="0" CELLSPACING="8"> <TR> <TD WIDTH="25%" ALIGN="right"><EM>Contacts:</EM></TD> <TD WIDTH="75%" ALIGN="left"> <dtml-in expr="objectValues('DTML Document')" sort="title"> <dtml-if expr="document_type='Contact'"> <a href="&dtml-absolute_url;"><dtml-var title_or_id></a><br> </dtml-if> </dtml-in> </TD> </TR> </TABLE> </P> <P> <TABLE WIDTH="95%" ALIGN="center" BORDER="0" CELLSPACING="8"> <dtml-in expr="objectValues('DTML Document')" sort="contact_date" reverse> <dtml-if contact_date> <TR> <TD WIDTH="25%" ALIGN="left" VALIGN="top"><dtml-var contact_date></TD> <TD WIDTH="25%" ALIGN="left" VALIGN="top"><dtml-var attorney></TD> <TD WIDTH="50%" ALIGN="left" VALIGN="top"><dtml-var description></TD> </TR> </dtml-if> </dtml-in> </TABLE> </P> <P ALIGN="center">Add a <A HREF="addContactForm">Contact</A></P> <P ALIGN="center">Add an <A HREF="addIncidentForm">Incident</A> Report</P> <dtml-var standard_html_footer>""" # Create the folder... newfolder = context.manage_addProduct['OFSP'].manage_addFolder(id=id, title=client_name) # Add the various properties... newfolder.manage_addProperty('client_name', client_name, 'string') newfolder.manage_addProperty('client_location', client_location, 'string') newfolder.manage_addProperty('telephone', client_telephone, 'string') newfolder.manage_addProperty('facsimile', client_facsimile, 'string') newfolder.manage_addProperty('web_site', client_web_site, 'string') newfolder.manage_addProperty('description', description, 'string') # Create the index_html file... newdoc = newfolder.manage_addProduct['OFSP'].manage_addDTMLMethod("index_html","",index_template) Here is the error message when I added some test information... Zope Error Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: 'None' object has no attribute 'manage_addProperty' Troubleshooting Suggestions The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Traceback (innermost last): File C:\Program Files\ZopeSite\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\Program Files\ZopeSite\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\Program Files\ZopeSite\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File C:\Program Files\ZopeSite\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\Program Files\ZopeSite\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: addClientAction) File C:\Program Files\ZopeSite\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: addClientAction) File C:\Program Files\ZopeSite\lib\python\OFS\DTMLMethod.py, line 189, in __call__ (Object: addClientAction) File C:\Program Files\ZopeSite\lib\python\DocumentTemplate\DT_String.py, line 538, in __call__ (Object: addClientAction) File C:\Program Files\ZopeSite\lib\python\DocumentTemplate\DT_Util.py, line 334, in eval (Object: addClient(id=id, client_name=client_name, client_location=client_location, client_telephone=client_telephone, client_facsimile=client_facsimile, client_web_site=client_web_site, comments=comments)) (Info: client_location) File <string>, line 0, in ? File C:\Program Files\ZopeSite\lib\python\Shared\DC\Scripts\Bindings.py, line 324, in __call__ (Object: addClient) File C:\Program Files\ZopeSite\lib\python\Shared\DC\Scripts\Bindings.py, line 353, in _bindAndExec (Object: addClient) File C:\Program Files\ZopeSite\lib\python\Products\PythonScripts\PythonScript.py, line 330, in _exec (Object: addClient) (Info: ({'script': <PythonScript instance at 012D7180>, 'context': <Folder instance at 012C7480>, 'container': <Folder instance at 012C7480>, 'traverse_subpath': []}, (), {'client_web_site': 'http://slashdot.org', 'comments': 'This is it.\015\012\015\012I know that this is it!!', 'client_facsimile': '713-229-7741', 'client_name': 'New Test, Inc.', 'client_telephone': '713-229-1341', 'client_location': 'Kingwood, TX', 'id': 'client_dev'}, None)) File Script (Python), line 49, in addClient File C:\Program Files\ZopeSite\lib\python\Products\PythonScripts\Guarded.py, line 273, in __getattr__ File C:\Program Files\ZopeSite\lib\python\Products\PythonScripts\Guarded.py, line 145, in __careful_getattr__ AttributeError: (see above) I think the problem is somewhere around "client_location" but everything looks right to my eye. Can anyone give me a gentle hint? Thanks, Ron

1 0