February 2000 - Zope

Form and Z SQL
by Pedro Silva 18 Feb '00

18 Feb '00

Hi, I'm making a form that askes for some input. When the fields are with information and we click in the add button, how can I send that information to a Z SQL table? I need something like this, because after I will need to list all the items that I entrered in the form that havw been sent to the SQL Data Base. Can anyone help me with this? thanks, Pedro

1 0

Re: [Zope] user created folders and local owner role problem in 2.1.3
by Cornelis J. de Brabander 18 Feb '00

18 Feb '00

Hi Tres, -----Oorspronkelijk bericht----- Van: Tres Seaver <tseaver(a)palladion.com> Aan: zope(a)zope.org <zope(a)zope.org>; Cornelis J. de Brabander <brabander(a)fsw.LeidenUniv.nl> Datum: donderdag 17 februari 2000 19:29 Onderwerp: Re: [Zope] user created folders and local owner role problem in 2.1.3 [snip] > >At a guess, the folder that you clone has local roles attached? I think you >would be best off to just force the ownership yourself after the clone: > Bull's eye. But why? Is there any reasoning why the owner role can only be set on a object when it has no other local roles. After all the the creator conceptually stays the owner, whether the object has other local roles or not. Furthermore, is there a place where these changes are documented, for without that simply upgrading within version 2.x.x becomes a hazardous adventure. > <dtml-let username="AUTHENTICATED_USER.getUserName()"> > <dtml-call "manage_setLocalRoles( username, [ 'Owner' ] )"> > </dtml-let> > In the meantime I will follow your suggestion and thank you very much for your helpful response. cb

2 1

Where to put business logic?
by Steen Suder 18 Feb '00

18 Feb '00

I know that this issue has been up before, at least partly. Is there an "unwritten" rule on where to put business logic in an Zope app? Example: where to validate data input? In the submit method or somewhere in the underlying database (PostgreSQL, MySQL, Oracle etc.)? What could the underlying motives be for choosing one or the another strategy? In the particular case I'm going to use it for a db case in school and I intend to use Zope to present the data etc. instead of using MS VC++ 6.0 which I don't get the idea of anyway. -- Best regards / Mvh., Steen Suder, sysadm kollegie6400.dk -|- OpenSource --- Sign of the time Scan-Aqua ADVARSEL WARNING http://www.uk.k64.dk/sfs/Scan-Aqua/

2 2

RE: [Zope] Re: Who was Zope?
by Martijn Pieters 18 Feb '00

18 Feb '00

From: LEE, Kwan Soo [mailto:kslee@plaza1.snu.ac.kr] > > Just found from "The Project Gutenberg Etext of The 1913 > Webster Unabridged Dictionary > Version 0.50 Letters X, Y, Z and The "New Words" supplement" > at ftp://ftp.datacanyon.com/pub/gutenberg/etext96/pgw050xz.txt: > > <hw>Zope</hw> (?), <pos>n.</pos> [G.] (Zoöl.) > <def>A European fresh-water bream (Abramis ballerus).</def> > > So Zope appears to be a fish made from a serpent, though Jim > Fulton once said that Zope was meaningless, iirc. > > Reminds me of "Lego" chosen for meaninglessness later found > to be meaningfull in Latin. About a year back, when doing similar research into the name, I also found that 'Zope' is originally am Inca name, and now a common surname in India. And the Central American King Buzzard is locally known as 'Rey Zope' (King Zope? I knew it!). The relevant thread: http://lists.zope.org/pipermail/zope/1999-April/thread.html#4601 -- Martijn Pieters, Software Engineer | Digital Creations http://www.digicool.com | Creators of Zope http://www.zope.org | mailto:mj@digicool.com ICQ: 4532236 | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 -------------------------------------------

1 0

Zope 2.1.3 Crashes on ftp access
by Robb Shecter 18 Feb '00

18 Feb '00

Hi, I'm trying to retrieve a file via ftp, and Zope locks up: either just the ftp transfer, or occasionally the whole server. It's printing the following error message: 2000-02-18T10:28:45 ERROR(200) ZServer exception in trigger thunk: (exceptions.AttributeError:'None' object has no attribute '_producers' [/usr/local/zope/2-1-3/ZServer/medusa/select_trigger.py|handle_read|82] [/usr/local/zope/2-1-3/ZServer/FTPResponse.py|apply|145] [/usr/local/zope/2-1-3/ZServer/FTPServer.py|retr_completion|360]) Anybody got a solution? Thanks, Robb

1 0

WorldPilot Calendar function error
by Jack Ungerleider 18 Feb '00

18 Feb '00

First off let me say that WorldPilot its slick. I have been banging on it for a while and I can't seem to get around the following problem. Whenever I add an event to the calendar I get the error message and traceback shown below. I have tried a variety of combinations. This particular instance was with no adjustments to the date-time defaults. As far as I can tell its croaking on the redisplay. Ryan are you out there? Any suggestions? Anyone else on the list used WorldPilot's calendar without a problem? TIA for any suggestions. ------------start of error message------------ Zope Error Zope has encountered an error while publishing this resource. exceptions.KeyError Sorry, a Zope error occurred. Traceback (innermost last): File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage) File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage) File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/Products/WorldPilot/Components/Events.py, line 278, in manage File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/Products/WorldPilot/Storage/LocalStorage.py, line 955, in manage File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/Products/WorldPilot/Storage/LocalStorage.py, line 893, in addItem File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/Products/WorldPilot/Components/Events.py, line 261, in listview File /usr/local/worldpilot/Zope-2.0.1-linux2-x86/lib/python/Products/WorldPilot/Components/Objects.py, line 91, in displayIfLoggedOn File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/Products/WorldPilot/WorldPilot.py, line 2147, in displayIfLoggedOn (Object: RoleManager) File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/Products/WorldPilot/WorldPilot.py, line 367, in callResource File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/Products/WorldPilot/Resource.py, line 137, in callResource File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: <string>) File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: <string>) File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: getCalendar(-86400+getMonthStartLong(GMTDayLong(+0,REQUEST)), REQUEST=REQUEST)) (Info: GMTDayLong) File <string>, line 0, in ? File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/Products/WorldPilot/Components/Events.py, line 783, in getCalendar File /usr/local/zoperoot/Zope-2.1.4-linux2-x86/lib/python/Products/WorldPilot/Components/Events.py, line 352, in getIncludedEvents KeyError: DTEND ---------------------end of error message------------------------- -- Jack Ungerleider The Ungerleider Group Creative Solutions for Cooperative Computing jack(a)jacku.com www.jacku.com

3 2

should my Zope site have multiple instances of pcgi-wrapper running? running?
by Tony McDonald 18 Feb '00

18 Feb '00

subject says it all really, I have a server that is hosting three different sites (from Apache ReWrite rules) and I'm seeing this sort of thing; nobody 23793 2349 0 11:50:07 ? 0:01 /home/zope/NLE_SITES/pcgi/pcgi-wrapper /home/zope/NLE_SITES/Zope.cgi nobody 24396 2476 0 11:55:39 ? 0:00 /home/zope/NLE_SITES/pcgi/pcgi-wrapper /home/zope/NLE_SITES/Zope.cgi nobody 23816 2308 0 11:51:11 ? 0:00 /home/zope/NLE_SITES/pcgi/pcgi-wrapper /home/zope/NLE_SITES/Zope.cgi with this from 'top' PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND 23793 nobody 1 33 0 34M 34M sleep 0:00 0.02% Zope.cgi This is with a 6 Megabyte database. Is this normal? Would I be better off splitting the sites to use different instances of Zope? tone ------ Dr Tony McDonald, FMCC, Networked Learning Environments Project http://nle.ncl.ac.uk/ The Medical School, Newcastle University Tel: +44 191 222 5888 Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2

2 3

[ZGotW] Issue #5 (Open)
by Zope Guru of the Week 18 Feb '00

18 Feb '00

A new issue of "Zope Guru of the Week" is available: =================================================================== Issue #5 -- Rendering DTML in Properties =================================================================== Status: Open Zen Level: Disciple (3/8) Keywords: DTML ZClasses Submitted by: Chuck Burdick chuck.burdick(a)tradingtechnologies.com ------------------------------------------------------------------- This problem occurs when you try to make a DTMLDocument-ish ZClass. 1. Suppose you have created a ZClass that you call 'myClass'. 1. Give 'myClass' a property sheet called 'properties'. 1. Create a text property called 'content' on 'properties'. 1. Create a view to edit 'properties'. 1. Create an instance of 'myClass'. Q: If you put dtml tags in 'content', how can you render the object and interpret the tags? For example, suppose you created 'index_html' as a DTMLMethod in 'myClass' as:: <dtml-var standard_html_header> <dtml-var content> <dtml-var standard_html_footer> This will not work. It will display the text value of 'content' but the dtml tags will not have been evaluated. This is a problem I frequently encounter. I do not want to create a complicated subclass of the existing DTMLDocument classes. Instead, I want a quick-and-dirty ZClass in which DTML tags are valid. ------------------------------------------------------------------- To reply and win undying glory and mondo guru points: http://zope.palladion.com/demos/ZGotW/5

1 0

[ZGotW] Issue #4 (Closed)
by Zope Guru of the Week 18 Feb '00

18 Feb '00

The current issue of "Zope Guru of the Week" has closed: =================================================================== Issue #4 -- Best way to output from ZOPE to MS Word =================================================================== Status: Closed Zen Level: Disciple (3/8) Keywords: DTML Submitted by: Brian Hickman bkkr(a)worldnet.att.net ------------------------------------------------------------------- My clients require a printed document, along with a version in MS Word format. What is the best way to send a document created in ZOPE to MS Word? *Editor: I'd like to broaden this to include alternative strategies for exporting formatted documents from Zope, as well as more classic "report writing."* ------------------------------------------------------------------- Reviewed by: Tres Seaver tseaver(a)palladion.com ------------------------------------------------------------------- Summary - David Brown suggests two possibilities: * construct a Word document on theserver-side using an ExternalMethod and the COM interface to Word; maybe even print the document from within the EM. *Ed.: Note that this requires that you run your Zope server on Win32; you would probably need to use the unsupported "COMObject":http://www.zope.org/Products/COMObject Product. It will also require figuring out where on the hard-drive the temporary document should live, and how to stream that document out as part of the response. Has anyone actually done this?* * Generate a RichTextFormat stream, which Word can read "natively". *Ed.: this is not for the faint of heart. Here are a couple of RTF links:* o Microsoft's "spec":http://msdn.microsoft.com/library/specs/rtfspec.htm (version 1.6) o "RTF Tools":ftp://ftp.primate.wisc.edu/pub/RTF o An RTF-to-HTML "translator":http://www.sunpack.com/RTF/ *This solution may not quite meet the spec, either, if the requirement, "document in MS Word format" is not sufficiently elastic as to encompass RTF.* - Shalabh recommends using WebDAV from Word2000, which lets you open, edit, and print Zope documents using WebFolders. *Ed.: I am assuming from his enthusiasm ("Simple, Sweet and Straightforward") that Shalabh is actually using this technique. I haven't managed to make it work yet, but I haven't tried very hard, either; I wiped Office2000 from the <strike>soles of my shoes</strike> HDD after an unhappy install. This looks like a good candidate for a HowTo.* - Lalo Martins notes that Word can read HTML: "just format it in a way that looks good in Word (you'll have to use trial-and-error for that)." *Ed.: anyone have a sample stylesheet or document which would help here? Word does UGLY things when it generates HTML -- I presume that reading it is somewhat simpler. This solution also ignores the poster's stated requirement for generating a "document in MS Word format" -- I don't much care for it as a requirement (it specifies a technical solution, not a business need), but it **is** part of the problem.* WRT the broader, "report-writing" question, Lalo reports success using the "PDFDocument"://http://www.zope.org/Members/gaaros/ZpdfDocument product to generate PDF files from within Zope (I'm guessing that this is the right URL -- it looks good, anyway). *Editor's plea: when possible, **please** include relevant links when you post a reply, whether here or on the mailing list; the usefulness of your reply goes **way** up when it links the resources needed to use it.* Conclusion First, many thanks to Brian, David, Shalabh, and Lalo! All of the proposed solutions have merit, given their respective tradeoffs. PDFDocument may be the best overall "reporting" solution, giving the precise control over layout which HTML simply can't; RTF generation looks like the "sanest" approach to the problem of "extruding" a Word document; reading documents in Word through WebDAV is cool, but may not play nice with DTML: either WebDAV hands out the rendered HTML (in which case Word can read but not edit it) or WebDAV hands out the DTML source (not useful for printing, but essential for editing.) This issue points up a couple of opportunities for product development: * hacking PDFDocument to produce RTF as an option * a framework for building "canned" reports using Zope's dynamic features, e.g., ZCatalog, ZSQL, etc. -------------------------------------------------------------------

1 0

Entry Points for Zope Newbies
by Tres Seaver 18 Feb '00

18 Feb '00

Before reading your rant, I had started to sketch out a "your are here -- where to go next?" map: http://www.zope.org/Members/tseaver/StartHere/ This probably really belongs in a Z[C]Wiki, so that many people can tweak and extend it. Or it should be on the ZDP site, perhaps. I don't see anything quite like it there. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0