May 2000 - Zope - Zope lists

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

Serving and Searching PDF's and Word Docs
by Richard Moon 03 May '00

03 May '00

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 ? Would you use a third party database ? What about searching the documents ? Thanks in advance Richard Richard Moon richard(a)dcs.co.uk

1 0

Doing an object count
by Eron Lloyd 03 May '00

03 May '00

How do I get a count of objects in Zope, either in the current folder or in a subfolder? Do I use the len method? I know this should be simple, but it has me stumped : (. Thanks for any help, Eron

2 1

Fwd: [Zope] Not logging in - what have I missed?
by Andrew Williams 03 May '00

03 May '00

For what it's worth, one thing to remember is that username/passwords are case sensitive. Andrew -----Original Message----- From: Geoff Gardiner ggardiner(a)synomics.com Sent: Wed, 3 May 2000 17:57:43 +0100 To: zope(a)zope.org Subject: [Zope] Not logging in - what have I missed? Another couple of simpleton problems, I think. Direct help, and pointers to existing information, will be very welcome. Installation: - Zope 2.1.6 on Win NT4 SP5 - Zope default installation to D: - starting as a service - var directory has Everyone=All permissions 1) Although I can view Ok as Anonymous, I can't get Zope to recognize any username/password combination other than the superuser. I have defined users at the top level and in the folder where my pages are. When I get to a page that requires authentication, only the superuser pair will work. Those from acl_users keep returning the login prompt until it expires. 2) Although I have set the permissions for Anonymous to permit "change Properties" in the folder I continue to get a "manage_Properties" permissions error when I try to exercise this permission. Thank you for any and all clues. Geoff Gardiner _______________________________________________ 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 ) ____________________________________________________________ ______________ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot. __________________________________________________________________________ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot.

1 0