- Zope - Zope lists

Interesting mxDateTime problem (and solution)
by Malcolm Tredinnick 04 May '00

04 May '00

I've just spent most of the morning beating my head against this problem, so I thought I'd post something here in case others hit the same issues: I use Marc Lemburg's mxDateTime package extensively in my Python programs and was trying to incorporate some things using it into Zope. Unfortunately, it is apparently not possible to use it "straight out of the box" with Zope because of problems with the import path. To make DateTime work under Zope, you have to rename the directory to something *other* than DateTime (I'm calling it DateTm, for example). If you have lots of references to DateTime scattered around in your code (as I do), the simplest thing seems to be to change any 'import DateTime' lines to: import DateTm DateTime = DateTm It's ugly, but it works. :-) The reason for this is because when you run 'import DateTime', the __init__.py method tries to do 'from DateTime import *', expecting to import things from DateTime/DateTime.py. However, it appears that the python interpreter starts from the beginning of the import path and looks for the DateTime module again and stumbles across the directory, rather than DateTime.py. Since this doesn't occur outside of Zope, it is a combination of a strange path setup (or environment, I'm not sure which) under Zope and some unlucky (but usually quite ok) naming (DateTime directory and DateTime.py inside that directory). Maybe this will save somebody else some hours. :-) Cheers, Malcolm -- Malcolm Tredinnick ph: +61 2 9440 9885 CommSecure Pty Ltd mobile: 0409 663 876 email: malcolm(a)commsecure.com.au

1 0

RE: [Zope] Serving and Searching PDF's and Word Docs
by a.wacknitz＠francotyp.com 04 May '00

04 May '00

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > I have a client who wants to distribute learning materials via the > web and are looking to move their PDF's and Word docs to a > database . > Has anyone used Zope for this ? Not exactly this but I store documents (word, excel, project) in a revision control system. I have written a python function that checks out and returns documents. But this only works with Merant's PVCS VM and searching within these documents in not needed... > Would you use a third party database ? Relational databases have some problems with these data types. They are usually stored as binary large objects (BLOBs). This results in some impacts on SQL. You cannot use most of the SQL features for projection and such sort of thing. Maybe you should look for a specialized database system. The problem will then be to get an appropriate database adaptor for Zope... > What about searching the documents ? As mentioned above normal RDBMS will propably have some restrictions. I cannot image how to search a document within an RDBMS for a special word or phrase. > > Thanks in advance > > Richard HTH Andreas -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com> iQA/AwUBORFL55rEH3uwEF1BEQIBuwCgsW5HPvfWAZ8sMeo8iu+H64Ox2h0An1Wx Ng4EBdtWssZoXcYIeouCoNhl =ddbO -----END PGP SIGNATURE----- ********************************************************************** This email message has been swept by MIMEsweeper for the presence of computer viruses. Francotyp-Postalia AG & Co.

2 1

Zope Benchmarks Published
by J. Atwood 04 May '00

04 May '00

Upon the request of the DC guys I have published my benchmark results on Zope and Tomcat. http://www.zope.org/Members/BwanaZulia/benchmarks.html Any feedback would be great. Thanks, J

5 4

Re: [Zope] SUMMARY: [Zope] Problems with zope + MS SQL Server
by julio dinis 04 May '00

04 May '00

>Dear Fellow Zope Users, > >Many thanks go to the following persons for their patient assistance. > >Henny van der Linde, >Julio Dinis and >Julio Silva > Hi, Just a correction, Julio Dinis and Julio Silva are the same person, me. I sent mails using different email accounts, thus the confusion. Good thing you didnt give up on Zope Robert. Congratulations! :-) Best Regards, Júlio Dinis Silva :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

1 0

Re: [Zope] newbie ?: zclass propertysheet datatypes
by Tres Seaver 03 May '00

03 May '00

Daniel Chudnov <daniel.chudnov(a)yale.edu> wrote: > Trying to add a date property to a class, Zope's giving me an "Invalid > Date-Time String" when I leave the initial value blank. Is this a > configuration problem (rh6.0, Zope 2.1.6 w/zserver) or by design? There > shouldn't be a default value for this property in the interface I'm > building... This is actually a problem with ZPublisher's marshalling code, rather than the property sheet per se. There is a bug in the Collector describing it: http://classic.zope.org:8080/Collector/645/view The workaround is to supply a "bogus" value ('1970/01/01' is the one I most often use) for the property, and then in the "edit" method, to add code checking for the bogus value:: <dtml-if "REQUEST[ 'dateProperty' ] == _.DateTime( '1970/01/01' )"> <dtml-call "REQUEST.set( 'dateProperty', None )"> </dtml-if> -- ========================================================= Tres Seaver tseaver(a)digicool.com tseaver(a)palladion.com

1 0

Capacity Handling?
by Monty Taylor 03 May '00

03 May '00

Hello all. I'm wondering if anyone has done something similar to something I'm thinking about doing. The company I work for does Business Data Analysis. Amongst the tools we provide to our analysts is a stream of processed news articles, and events derived from them. The events part is fine, that's not that much data, but they also want access to the original articles and the ability to do full-text searches of them. I'm working on re-writing the 'event' part of things in Zope. That part is fairly straight forward. It seems that I could also add each article to Zope as a 'News Article.' This is done a quite a lot. Then we could arrange and sort them, search them or do lots of things with them. The question: Over the past few months, we have accumulated around 2 GIGs of articles. This trend is expected to continue. Can Zope and ZCatalog handle this kind of load? Will the searching capabilities be shot in the ass if I stored the articles as external files? (Does ZCatalog even know about those things?) OR, should I stick with the articles in the filesystem with ht://dig like we've got now, and just build the interface to ht://dig in Zope? Any thoughts? Thanks. Monty

4 3

RE: [Zope] SUMMARY: [Zope] Problems with zope + MS SQL Server
by Chris McDonough 03 May '00

03 May '00

Robert, Would you mind constructing a HowTo on Zope.org about this (maybe just paste the contents of your mail message into a HowTo you create)? > -----Original Message----- > From: Robert Honore [mailto:robert@digi-data.com] > Sent: Wednesday, May 03, 2000 3:32 PM > To: zope(a)zope.org > Subject: [Zope] SUMMARY: [Zope] Problems with zope + MS SQL Server > > > Dear Fellow Zope Users, > > Many thanks go to the following persons for their patient assistance. > > Henny van der Linde, > Julio Dinis and > Julio Silva > > Success at last. > > Here, finally is what I had to do. > > After installing the ZODBC DA, I needed to ensure that the > Zope server runs as a > known username (with a known password). Then I needed to > create a Windows NT > account to correspond to that username and password. Next I > needed to ensure > that the SQL Server admits a login using that combination of > username and > password with at least dbowner access to the database I want > the ZOPE server to > use. Once I did that, I was able to simply choose a DSN from > the list box that > appears on the add ODBC connection screen and it worked. > > It all came together when Julio Dinis asked me if the server > I was trying to > connect to was a remote server or a local (on the same > machine as the ZOPE > installation) SQL server. When I tried it on a local SQL > Server DSN it worked, > but when I tried it on my remote SQL Server it worked. When > Henny van der Linde > suggested I use SQL Server's logging to see if the > connections were being > rejected, I saw that ZOPE was trying to establish a trusted > connection with an > undefined username. That was when I finally figured out what > I needed to do. > > And I was just about to give up on ZOPE. Good thing I did > not. Perhaps they > need to update the documentation. > > If you need any further explanation of the setup, drop me a line. > > Original Question: > > > > Anyone ever figured out how to get ZOPE's ODBC DA to work > with MS SQL Server? > > > > I am a Zope newbie using MS SQL Server 7.0, Zope version > 2.1.6, Python 1.5.2 Win > > 386 and ZODBC > > Version 3.1.0b2. > > > > Whenever I attempt to open an ODBC connection to the SQL > Server I get the > > message "Invalid connection string:" followed by the name > of the DSN I am trying > > to use. Can anyone help me along with this or is this the > curse for using > > Microsoft software? > > > Yours sincerely, > Robert Honore. > > _______________________________________________ > 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: RelationalStorage (was LocalFS)
by Chris McDonough 03 May '00

03 May '00

Absolutely! Here's what I think needs to be done: - finalize the recommended table structures - come up with as-generic-as-possible SQL queries for use in each Storage method that is anticipated to be used by this storage. - make sure the current table structure doesn't neglect to anticipate versioning and undo Though this should be abstracted to be able to use any SQL database, I had anticipated developing this against Oracle (using DCOracle) initially. Is this a problem for you? > -----Original Message----- > From: Jonothan Farr [mailto:jfarr@real.com] > Sent: Wednesday, May 03, 2000 3:27 PM > To: Chris McDonough; Jason Spisak > Cc: zope(a)zope.org > Subject: Re: RelationalStorage (was LocalFS) > > > > I've put some stuff about a proposed RelationalStorage in > the ZODB wiki > > at http://www.zope.org/Members/jim/ZODB > > > > Its goal is to allow you to use a SQL database as a Storage, which > > somewhat coincidentally would also get around the single-file 2GB > > limitation. > > > > I would appreciate comments (in the wiki or here). The > table structure > > I'm not sure on, it's only a skeleton right now... > > I like it. I'm much more interested in working on this than a > FileSystem > storage, for different reasons. Care to collaborate? > > --jfarr > >

1 0

More namespace fun
by Ken Kinder 03 May '00

03 May '00

Does anyone know how I can easily put ALL my queries into a folder like: /queries And access them easily w/o <dtml-in "PARENT[-1]"> kind of stuff? -- Ken Kinder 303.381.7631

3 2

Problems with zope + MS SQL Server
by Robert Honore 03 May '00

03 May '00

Anyone ever figured out how to get ZOPE's ODBC DA to work with MS SQL Server? I am a Zope newbie using MS SQL Server 7.0, Zope version 2.1.6, Python 1.5.2 Win 386 and ZODBC Version 3.1.0b2. Whenever I attempt to open an ODBC connection to the SQL Server I get the message "Invalid connection string:" followed by the name of the DSN I am trying to use. Can anyone help me along with this or is this the curse for using Microsoft software? Yours sincerely, Robert Honore.

2 2