January 2003 - Zope - Zope lists

[Fwd: Re: [Zope] Zope and Excel]
by Oliver Marx 08 Jan '03

08 Jan '03

-- CEO Oliver Marx TEKK Lyngbyvej 20 2100 København Ø Main: +45 39 15 80 60 Direct: +45 39 15 80 62

1 0

Re: [Zope] Newbie Question: Zope crashing
by Ashley Lloyd 08 Jan '03

08 Jan '03

I have also attempted using a dtml-try..except around the <dtml var "convertDate(C_DATE)">, and even around the entire dtml-in, but this had no effect. Sorry, I forgot to put this in when I posted!! From: "Ashley Lloyd" <ashleylloyd(a)hotmail.com> To: zope(a)zope.org Subject: [Zope] Newbie Question: Zope crashing Date: Tue, 07 Jan 2003 14:57:54 +0000 I have posted in the last few days asking for help formatting a date retrieved from an Interbase db (thanks very much to Kevin Carlson for the help with that). I now have a Python script called convertDate, which takes one parameter, aDate: ############################################################ try: thedate = DateTime(aDate) return thedate.strftime('%d/%m/%Y') except: print "Error on date ", aDate return printed ############################################################ I also have an SQL method called all_dates which is simply: select C_DATE from CALENDAR order by C_DATE Finally, I have a DTML method called list_dates which again is simple: ############################################################ <dtml-var standard_html_header> <table border=1 width="60%" cellspacing=1> <tr><th>Date</th><th>Converted</th></tr> <dtml-in all_dates> <tr> <td width="50%"><dtml-var C_DATE></td> <td width="50%"><dtml-var "convertDate(C_DATE)"></td> </tr> </dtml-in> </table> <dtml-var standard_html_footer> ############################################################ If I dtml-comment out the "convertDate(C_DATE)" output line, the DTML method works fine. I have tried testing the SQL, which works fine. I have tried testing the script using an actual date from the database - retrieved by commenting out the line mentioned, and this returns the date fine. I have checked for rogue/empty C_DATE values in the database, there are none. I have also tested the script using a random text input, and the try..except gave the expected error message. I have tried replacing "convertDate(C_DATE)" with something like "convertDate('2000-01-01 00:00:00.00')" (date format retrieved again from the db in the manner outlined above), and this allows the page to be viewed fine. If I try the DTML method as above, though, Zope stops responding completely. The dataset is by no means large (max 30 entries), and I have allowed it 10 mins before giving up! I am using Zope version 2.5.1 (Python version 2.1.3) on Win 2k. Can anyone help? Kind regards Ashley _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail _______________________________________________ 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 ) _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus

1 0

RE: [Zope] Zope and Excel
by pskipworth＠touchcorp.com 08 Jan '03

08 Jan '03

Another option which I use, which is prettier to the user but uglier for the programmer, is to use an ExtMethod and pipe your data through a Spreadsheet::WriteExcel Perl script. This Perl module allows you to do anything that you could do within Excel, including formatting, cell merging, resizing the width and height of columns/rows, etc. If only someone sufficiently proficient in Perl and Python could port it to Python! -----Original Message----- From: paul.browning(a)bristol.ac.uk [mailto:paul.browning@bristol.ac.uk] Sent: Wednesday, 8 January 2003 4:40 PM To: zope(a)zope.org Cc: michael.healy(a)engitech.ie Subject: Re: [Zope] Zope and Excel --On 07 January 2003 10:54 +0000 Micheál Healy <michael.healy(a)engitech.ie> wrote: > Hi all, > > I want to create a report or spreadsheet in MS Excel and populate it from > Zope. Can anyone tell me if there is a product for Zope that will help, > or should I just look for a generic python script that does it and use > that. > > If anyone has a working example, I'd appreciate code samples and anything > else you can provide. It ain't pretty but the following DTML Document does the job for me (and forces Excel to open): ------------- Content-type: application/vnd.ms-excel SURNAME<dtml-var "_.chr(9)">FIRST_NAME<dtml-var "_.chr(9)">STUDENT_NUMBER<dtml-var "_.chr(9)">EMAIL_NAME<dtml-var "_.chr(9)"> <dtml-in expr="students_by_unit_code(unit_code=_['unit_code'])"> <dtml-var SURNAME><dtml-var "_.chr(9)"><dtml-var FIRST_NAME><dtml-var "_.chr(9)"><dtml-var STUDENT_NUMBER>q<dtml-var "_.chr(9)"><dtml-var EMAIL_NAME><dtml-var "_.chr(9)"> </dtml-in> ------------ students_by_unit_code being a SQL Method. Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning(a)bristol.ac.uk URL: http://www.bris.ac.uk/ _______________________________________________ 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

Zope and Excel
by Micheál Healy 08 Jan '03

08 Jan '03

Hi all, I want to create a report or spreadsheet in MS Excel and populate it from Zope. Can anyone tell me if there is a product for Zope that will help, or should I just look for a generic python script that does it and use that. If anyone has a working example, I'd appreciate code samples and anything else you can provide. TIA, Micheál

2 1

External Editor and HTML-Kit
by Paul Browning 08 Jan '03

08 Jan '03

In <http://www.zope.org/Members/Caseman/ExternalEditor/install-win32> Casey notes "The helper application can run any editor program that does not detach itself from the controlling process. As for editors that insist on detaching from the controlling process (EditPad does this by default), you need to configure them so that they do not detach. For EditPad you could use: editor = C:\Program Files\EditPadClassic\EditPad.exe /newinstance" I've just tried EditPadPro and watched the error you get if you don't use /newinstance - things fail on attempting to open the second and subsequent files. I get the same error when trying HTML-Kit when opening the second and subsequent files. The HTML-Kit docs mention a /si parameter to open a single-instance but I want the reverse - a new instance - which, should, from my reading of the docs be the default behaviour. But, as far as I can tell, this is not what HTML-Kit is doing. I know we've got some HTML-Kit enthusiasts on this list - can you help? Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning(a)bristol.ac.uk URL: http://www.bris.ac.uk/

4 4

spell check
by Mark Gibson 08 Jan '03

08 Jan '03

How would I integrate a spell checker into a content object? Ideally it would flag misppellings, and provide a way to correct those - maybe suggestions? How have people handled this? I've seen a reference to www.stuffedog.com in the archive. Can anyone describe how they've integrated this product? Are there other options? Thanks, Mark

3 2

RE: [Zope] Zope and Excel
by pskipworth＠touchcorp.com 08 Jan '03

08 Jan '03

Michael, What's your development platform ? Win32 or *nix ? P -----Original Message----- From: michael.healy(a)engitech.ie [mailto:michael.healy@engitech.ie] Sent: Tuesday, 7 January 2003 9:55 PM To: zope(a)zope.org Subject: [Zope] Zope and Excel Hi all, I want to create a report or spreadsheet in MS Excel and populate it from Zope. Can anyone tell me if there is a product for Zope that will help, or should I just look for a generic python script that does it and use that. If anyone has a working example, I'd appreciate code samples and anything else you can provide. TIA, Micheál _______________________________________________ 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

Obtaining the index (data) from a TextIndex (ZCatalog)
by complaw_rm_＠hal-pc.org 08 Jan '03

08 Jan '03

Is there a way to get the entire list of words from the data property of a ZCatalog's TextIndex? I'm trying to obtain the list of words from a TextIndex. In this case, the list of words are very instructive for the client. The idea is to load up a bunch of documents, and then use the ZCatalog to get a list of words in the various documents. We are looking for technical terms (that we don't know a priori). Is there a way to do that? A review of the TextIndex.py source indicates that the TextIndex class has a _data property that contains the list of words. The problem is getting at that property. For example, the following code: S = '' lst = [] if container.abstract_tracker.Indexes: lst = container.abstract_tracker.Indexes.PrincipiaSearchSource.data S = 'Found it' else: S = 'Not there' return S Prompts the following error message... Traceback (innermost last): File /usr/local/zope/2-4-3/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /usr/local/zope/2-4-3/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope/2-4-3/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook (Object: ncr) File /usr/local/zope/2-4-3/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/zope/2-4-3/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: obtain_index) File /usr/local/zope/2-4-3/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: obtain_index) File /usr/local/zope/2-4-3/lib/python/Shared/DC/Scripts/Bindings.py, line 324, in __call__ (Object: obtain_index) File /usr/local/zope/2-4-3/lib/python/Shared/DC/Scripts/Bindings.py, line 354, in _bindAndExec (Object: obtain_index) File /usr/local/zope/2-4-3/lib/python/Products/PythonScripts/PythonScript.py, line 363, in _exec (Object: obtain_index) (Info: ({'script': <PythonScript instance at 9726880>, 'context': <Folder instance at 9cab578>, 'container': <Folder instance at 9cab578>, 'traverse_subpath': []}, (), {}, None)) File Script (Python), line 5, in obtain_index (Object: guarded_getattr) File /usr/local/zope/2-4-3/lib/python/AccessControl/ZopeGuards.py, line 109, in guarded_getattr (Object: ) AttributeError: (see above)

1 0

RE: [Zope] Connecting Mysql
by pskipworth＠touchcorp.com 07 Jan '03

07 Jan '03

Have you extracted the ZMySQLDA package to /var/zope/lib/python/Products ? Cheers, P -----Original Message----- From: lmcdonnell(a)protonenergy.com [mailto:lmcdonnell@protonenergy.com] Sent: Wednesday, 8 January 2003 3:42 AM To: zope(a)zope.org Subject: [Zope] Connecting Mysql Hi, I am trying to install the Mysql Zope adaptor but I get this message: 2003-01-07T09:26:16 ERROR(200) Zope Could not import Products.ZMySQLDA Traceback (innermost last): Module OFS.Application, line 541, in import_product Module Products.ZMySQLDA, line 106, in ? Module Products.ZMySQLDA.DA, line 108, in ? Module Products.ZMySQLDA.db, line 106, in ? ImportError: No module named MySQL I have the MySQLmodule.so in the following path ..\usr\lib\python2.1\site-packages. Any ideas? Thanks. Larry McDonnell Proton Energy Systems 10 Technology Drive Wallingford, CT 06492 (203) 678-2181 Email:lmcdonnell@protonenergy.com www.protonenergy.com _______________________________________________ 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

Re: [Zope] RE: External Editor/SSL
by Paul Browning 07 Jan '03

07 Jan '03

--On 07 January 2003 08:55 -0500 Casey Duncan <casey(a)zope.com> wrote: > What is the error? Is it one of those "Can't find the file > foobar[1].html" errors? Nope. When I click on the pencil icon in the ZMI over https IE6 gives me --------- Internet Explorer cannot download foobar.htm from xxx.yyy.zzz Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later. --------- If I click on the foobar.htm link in the ZMI over https it opens just fine. In attemopting to isolate the problem I tried the following URLs from a Windows box without ExternalEditor client installed. In Netscape: http://xxx.yyy.zzz/blah/externalEdit_/foobar.htm - I save the file https://xxx.yyy.zzz/blah/externalEdit_/foobar.htm - I save the file In IE: http://xxx.yyy.zzz/blah/externalEdit_/foobar.htm - I save the file https://xxx.yyy.zzz/blah/externalEdit_/foobar.htm - I get the message above My Zope is being fronted by Apache with mod_rewrite and VHM being used in what I think is a standard way. Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning(a)bristol.ac.uk URL: http://www.bris.ac.uk/

1 0