August 2003 - Zope - Zope lists

how to generically get a list of tables and columns from a db connector
by Elena Schulz 07 Aug '03

07 Aug '03

Hi, the browse-tab of db connectors offer a listing of tables and columns. How can I access this in python script independent of the db connection(without a sql-query or zsql_method). In the class db.py under class db there is a tables() and columns() method but I didn't find a way of accessing them in a script yet. Also a query() method should be possible to circumvent zsql-Methods more flexibly? Does anybody know the how to? -- Elena

1 0

editing exported XML objects
by Jaroslav Lukesh 07 Aug '03

07 Aug '03

Hi all, does somebody have tips how is organized exported data as XML? I want change some values into XML exported data to repair references in portableHole product (what is impossible to import without these changes). Many thanks, J. Lukesh

1 0

Using ZReST in page templates or python scripts
by Alec Munro 07 Aug '03

07 Aug '03

Hi List, I'm wondering if there's a way to use restructuredText functionality from within a page template or python script? For example, I am storing information in a mysql database. A fair amount of this information could do with the ability to be formatted. I am hoping I can utilize restructuredText for this. I provide a through-the-web interface for editing this content, and I would like to teach my boss + coworkers simple ReST syntax, so they can edit it themselves. I would then like the either store it as is, and transform it when accessed, or transform it immeadiatly after editing, and store it that way. So a function from python that would convert ReST to HTML would really do the trick. Thanks, Alec Munro

3 3

zope.org - The Zope Book Link Broken
by Edward Muller 07 Aug '03

07 Aug '03

clicking on the Documentation -> The Zope Book link on the nav on the left side gives a 'IndexError : string index out of range' error. -- Edward Muller Interlix (http://www.interlix.com) Phone: 417-862-0573 - Cell: 417-844-2435 - Fax: 417-862-0572 Web Hosting - PC Service & Support - Custom Programming - Network Service & Support Specializing in Open Source Solutions

2 2

Batch Update/Insert Problem
by Chan YH 07 Aug '03

07 Aug '03

I phrased my question wrongly in my previous email and wished to thanks those who replied. I am trying to insert/update a table in a batch mode. The coding below is a simplified version. What I wanted to do is to INSERT/UPDATE a table (contact ) in a BATCH mode. The user will see a form listing (company) and select the option from table (person). Upon completion, the user a submit the matched listing to be inserted in another table (contact). I need some help in doing this in a BATCH mode. For e.g. if I have 10 companies with the selected persons in a batch to be inserted into contact table. Company name Person (company table) (person table) ---------------- -------- 1. company A Chan 2. company B Henry ... 10. company X Robert insert/update batch to contact table. Could someone give me some guidance? TQ Data Entry Form ============ <dtml-var standard_html_header> <h2><dtml-var title_or_id></h2> <form method="post" action="form2_action" enctype="multipart/data"> <table> <dtml-in listCompany_sql> <tr> <td>Company:</td><td><dtml-var co_name></td> <td><select name="last_name" value=""> <dtml-in listPerson_sql> <option value="&dtml-last_name;">&dtml-last_name;</option> </dtml-in listPerson> </select> </td> </tr> </dtml-in listCompany> <tr> <td><input type="submit" value="Submit" name="submit" /></td> </tr> </table> </form> <dtml-var standard_html_footer> SQL methods ========== listCompany_sql ----------------- select * from company listPerson_sql ------------- select * from person CREATE TABLE contact ( first_name char(20), last_name char(20), co_name char(20), co_phone char(20) ); CREATE TABLE person ( name_id int PRIMARY KEY, first_name char(20), last_name char(20) ); CREATE TABLE company ( co_id int PRIMARY KEY, co_name char(20), co_phone char(20) );

1 0

: Java Based Open Source Portal
by Vic Cekvenich 06 Aug '03

06 Aug '03

From: Vic Cekvenich To: zope(a)zope.org Sent: Wednesday, August 06, 2003 6:18 PM Subject: Java Based Open Source Portal Here is another Java open source Portal/CMS built w/ Struts: http://basebeans.com/do/newsBlgCmntsLstPg?ID=14 Download here: https://sourceforge.net/project/showfiles.php?group_id=55539&release_id=176… Support/training is available. .V

1 0

where has the mailman for this list gone ?
by Joachim Schmitz 06 Aug '03

06 Aug '03

I just wanted to disable my delivery for a while, but the list administration for this list is gone mail.zope.org Mailing Lists says "No such list zope" -- Mit freundlichen Grüßen Joachim Schmitz -------------------------------------------------------------------- AixtraWare Ingenieurbüro für Internetanwendungen Telefon: +49-2464-8851, FAX: +49-2464-905163 --------------------------------------------------------------------

3 4

problème sur le téléchargement
by Nicolas REBUFFET 06 Aug '03

06 Aug '03

Bonjour, Jai des problèmes pour télécharger la dernière version de zope. « Corrupt installation detected » comment puis-je faire pour télécharger ? Merci de me répondre rapidement Cordialement Nicolas rebuffet

2 1

Problem with PABlog
by Tom Scheidt 06 Aug '03

06 Aug '03

I've followed the install instructions exactly (a few times) and have all of the right versions of the prerequisites. Every time I try to view the site (Plone Version, but happens on both the same) I get the error below. Thanks in advance. - Tom Site Error An error was encountered while publishing this resource. KeyError Sorry, a site error occurred. Traceback (innermost last): Module ZPublisher.Publish, line 150, in publish_module Module ZPublisher.Publish, line 114, in publish Module Zope.App.startup, line 182, in zpublisher_exception_hook Module ZPublisher.Publish, line 98, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module Shared.DC.Scripts.Bindings, line 252, in __call__ Module Shared.DC.Scripts.Bindings, line 283, in _bindAndExec Module Products.PageTemplates.ZopePageTemplate, line 228, in _exec Module Products.PageTemplates.PageTemplate, line 95, in pt_render <ZopePageTemplate at /site/blogindex_html used for /site/blog/2003/08> Module TAL.TALInterpreter, line 200, in __call__ Module TAL.TALInterpreter, line 244, in interpret Module TAL.TALInterpreter, line 703, in do_useMacro Module TAL.TALInterpreter, line 244, in interpret Module TAL.TALInterpreter, line 295, in do_startTag Module TAL.TALInterpreter, line 363, in attrAction_tal Module Products.PageTemplates.TALES, line 223, in evaluateText Module Products.PageTemplates.TALES, line 217, in evaluate URL: blogindex_html Line 27, Column 1 Expression: standard:'here/zpt_stylesheet.css/absolute_url' Names: {'container': <PloneSite instance at 90b7f38>, 'default': <Products.PageTemplates.TALES.Default instance at 0x86afd54>, 'here': <PortalFolder instance at 9215538>, 'loop': <SafeMapping instance at 8f8ebf0>, 'modules': <Products.PageTemplates.ZRPythonExpr._SecureModuleImporter instance at 0x86b8e4c>, 'nothing': None, 'options': {'args': ()}, 'repeat': <SafeMapping instance at 8f8ebf0>, 'request': <HTTPRequest, URL=http://www.modscape.com/site/blog/2003/08/blogindex_html>, 'root': <Application instance at 8eee058>, 'template': <ZopePageTemplate at /site/blogindex_html used for /site/blog/2003/08>, 'traverse_subpath': [], 'user': Anonymous User} Module Products.PageTemplates.Expressions, line 206, in __call__ Module Products.PageTemplates.Expressions, line 194, in _eval Module Products.PageTemplates.Expressions, line 150, in _eval __traceback_info__: here Module Products.PageTemplates.Expressions, line 353, in restrictedTraverse __traceback_info__: {'path': ['zpt_stylesheet.css', 'absolute_url'], 'TraversalRequestNameStack': ['absolute_url']} Module OFS.ObjectManager, line 652, in __getitem__ KeyError: zpt_stylesheet.css (Also, an error occurred while attempting to render the standard error message.) 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. ---------------------------- Tom Scheidt tscheidt(a)nyc.rr.com ----------------------------

2 1

RE: [Zope] FQ Path Names in container
by Roy Rapoport 06 Aug '03

06 Aug '03

> If you want to get substructures in Python, you can do one of > these things: > > container.A.B.C # can't go to something with a dot in the name > container.A.B['C.pdf'] > container['A']['B']['C.pdf'] > container.restrictedTraverse('A/B/C.pdf') > > Restricted traverse is probably the best way to deal with a variable > path, as you seem to have. > > See also: > http://www.zopelabs.com/cookbook/1001104105 > http://www.zopelabs.com/cookbook/1032051886 Apologies, a typo in my original example made my problem less clear. I have no problem accessing a given file, even if it has a .extension; my problem is trying to figure out how to do traversal and require it to be from the root folder, rather starting at the current directory. In other words, yes, I can do this: container.restrictedTraverse('A/B/C.pdf') But what I want to be able to do is: container.restrictedTraverse('/A/B/C.pdf'). Note the leading '/' before 'A' And, err, 'nevermind' -- I figured I might as well trawl ZopeLabs (I didn't know about them until you sent the links above), and found 'get Root Object', cookbook recipe #994090604. That should do the trick. Thanks! -roy Content-Type: text/plain; charset="iso-8859-1" ------------------------------------------------- PLEASE READ THIS WARNING: All e-mail sent to or from this address will be received or otherwise recorded by the Fisher Investments corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient.

2 1