- Zope - Zope lists

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

Reinstall system for use with Zope
by Roel Van den Bergh 06 Aug '03

06 Aug '03

Hi all, during the holidays our server went down: two drives of a raid-5 system on a PowerApp 120 failed. It seems our server kept running solely on it's RAM memory, but it finally died this morning. Mayor bummer because I have to reinstall everything from scratch, there goes my weekend. We were using zope 2.5.1 and CMF 1.3 with Apache 1.3.23 on RedHat 7.3 Our Data.fs file has been backed up, I hope we can recuperate that one :-) We now have the opportunity to upgrade to whatever is best. Here are some questions: 1. I'm not sure wheiter to use RH7.3, 8.0 or 9.0 (I've seen some issues with 9.0 on the mailing list) 2. Also I'm thinking of installing Zope 2.6.1 or 2.6.2b5 in stead of 2.5.1. 3. Is there a difference between Apache 1.3.X and Apache 2.X regarding the communication with Zope? Any suggestions are very welcome. WKR, Roel. - - - Roel Van den Bergh 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

Errors reStructuredText under 2.7
by Alec Munro 06 Aug '03

06 Aug '03

Hi List, This happens whenever I try to add a reStructuredText document in the ZMI, and also whenever I try to render a page template containing a call to ReST. I get the following Zope Error: *Error Type: AttributeError* *Error Value: 'module' object has no attribute 'TitledHelpFormatter' Is this a known issue, or specific to my installation? Thanks, Alec Munro *

2 1

webdav access defaults to anonymous?
by Lee Harr 06 Aug '03

06 Aug '03

Hi; I am starting to learn about webdav, so I downloaded the cadaver client and out of curiousity pointed it at my zope server. I was a bit surprised (!) to find that I could wander around in there getting listings of all of the directories... There is a setting for "WebDAV Access" which was marked "Anonymous" and which I am sure I never changed. Should this default to manager only? _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

3 2

callback function when object is deleted
by Carsten Gehling 06 Aug '03

06 Aug '03

I'm writing a product where users can maintain information about electronic equipment. I've made a class called eg. "Equipment", and an instance is created for each piece of equipment the user has. The user can also make a maintainance log entry for each instance. These log entries are stored in an external databases. If the user deletes an equipment object through the ZMI, I'd like the object to set a "deleted" flag on each log entry beforehand. Similar, if the deletion is undone, the object should remove the "deleted" flag. I suspect that this should be done through some inherited method from the Zope superclasses that is called by the ZMI, but which? - Carsten

2 1