October 2000 - Zope - Zope lists

INSTANCE_HOME breaks cross products import
by Johan Carlsson 18 Oct '00

18 Oct '00

Hi, I'm using then the INSTANCE_HOME to have separate Zope instances use a base zope installation and a shared products directory with symlink's to the instance product folder. As described in the "How-To: Make your life easier with INSTANCE_HOME" by 4am. Now the LoginManager can't import anything from the ZPattern module. <start up error message> 2000-10-17T21:59:14 ERROR(200) Zope Couldn't import Products.LoginManager Traceback (innermost last): File /bigshare/zopeservers/Zope-2.2.2-base/lib/python/OFS/Application.py, line 397, in import_products (Object: string) File /bigshare/zopeservers/unitedrings/Products/LoginManager/__init__.py, line 1, in ? File /bigshare/zopeservers/unitedrings/Products/LoginManager/LoginManager.py, line 9, in ? ImportError: cannot import name SheetProviderContainer </start up error message> Now this works fine if I start Zope from the base Zope installation. So what goes wrong and why? Does I do anything wrong or should/could this be fixed in the product? If so I guess it would be practical to document som product author guidelines. Regards, Johan Carlsson

1 0

Re: [Zope] Want to access ZClass Instance from external program
by Jon Prettyman 18 Oct '00

18 Oct '00

Well, I've gotten xmlprclib and fixed it up so I can talk to my server. So far I can retrieve objectIds and retrieve objects via an objectid, but I can't figure out how to get to the property sheets. Here's what I've got: server = Server( "http://jonprettyman.com" ) print server for k,v in server.EBQ.id_company_apply_html.propertysheets.common.propertyItems(): print "%-15s: %s" % (k, v) My ZClass has a propertysheet named ``common'' The error I get is: -2 Unexpected Zope Error Value and a bunch of HTML which boils down to: Resource not found -jon Kapil Thangavelu <kthangavelu(a)earthlink.net> writes: > its easiest to it with (IMO) > > xml-rpc > > and find your zclasses with calls to objectids and query the > propertysheets directly for property info. > > > check out > > http://www.zope.org/Members/Amos/xmlrpclib.py > you'll need to fix a base class and an import. > > www.xml-rpc.com > > www.xml.com search for amos > > and zope.org for howtos on xmlrpc > > Cheers > > Kapil > > _______________________________________________ > 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 )

2 1

DCOracle + LOB
by Peter Sabaini 18 Oct '00

18 Oct '00

hi all, i have this shiny brand new oracle 8i server and now read (on the mailinglist) that there's no lob support for oracle 8i in dcoracle 1.3.2, and indeed it does not appear to work. is that true? i need lob support! is there any workaround? through stored procedures maybe? thanks a lot! peter. -- _________________________________________________ peter sabaini, mailto: sabaini(a)niil.at -------------------------------------------------

2 1

RE: [Zope] MySQL and Zope struggles
by dale.w.lance＠mail.sprint.com 18 Oct '00

18 Oct '00

Or you could renormalize your data to have: --------- ----------- | Artist | | Note | |---------|-------|-----------| | id | | id | --------- | artist_id | | note_str | ----------- you now have a list of notes by artist_id. You typically won't have a screen that doesn't have an Artist context to be adding a note to. (or to remove all notes from). Of course this means more work to migrate :-( And I don't know all possible scenarios for which you would need the structure you gave, but it is another way around this. It probably doesn't solve real complex scenarios either. JAT Dale -----Original Message----- From: administrator [mailto:administrator@consotec.de] Sent: Monday, October 16, 2000 6:11 AM To: zope Cc: administrator Subject: Re: [Zope] MySQL and Zope struggles I don't know if the following link can solve your problem, but maybe it gives you an idea: http://www.zope.org/Members/Roug/new_record_with_subrecords (How-To: Creating a new record with subrecords in MySQL) Arno > I'm struggling to migrate an application from Zope/PostgreSQL to Zope MySQL > (Why ? - because I've got a kind offer of free hosting if I use MySQL). > > MySQL offers a limited set of features and is missing, among other things, > the ability to use subqueries - so for example in PostgreSQL you can say > > update note set notes =<dtml-sqlvar notes type=string> > where note_id = > (select note_id from artist where <dtml-sqltest artist_id type=int>) > > and in MySQL you can't. > > If you were working in a traditional programming environment you could > overcome this by splitting the above into two parts - a select to retrieve > the value of note_id from the artist table followed by an update of the > note table using the returned value of note-id. > > For example > > select note-id into note-id-var from artist where artist-id = 23; > update note set notes = 'asdasda' where note-id = note-id-var; > > The problem is that in Zope I believe you can't use a returned value within > an SQL Method, so the above code would fail. The only way I can see to do > the above is to have two separate SQL Methods, one for the select, > returning the note-id-var and another for the update. This is very clumsy. > > I was wondering if anyone could tell me if there was a better way. > > Many thanks > > > Richard > > Richard Moon > richard(a)dcs.co.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 ) > > > To: zope(a)zope.org

3 3

bobobase_modification_time and .zexp
by Wolfgang Strobl 18 Oct '00

18 Oct '00

import/export obviously doesn't preserve time stamps (i.e. bobobase_modification_time). This is unfortunate for any content which depends on those timestamps. How do you people out there solve this problem when it comes to moving content from different Zope installations into a single one?

3 3

status of SOAP for Zope?
by Brad Clements 18 Oct '00

18 Oct '00

MS has released ROPE for client-side SOAP development (finally). I can't seem to find anything in Zope for doing SOAP, but it was announced in Dec 1999 as "upcoming". What is the status of SOAP on Zope, I need to know if I can use ROPE.. Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements

7 11

Mozilla->back button
by brocken22＠gmx.de 18 Oct '00

18 Oct '00

To support Mozilla I'd like to switch to M18, but in the Zope-Management-Interface the back-button doesn't seems to work. What am I missing?? -- Sent through GMX FreeMail - http://www.gmx.net

2 1

transactions howto released
by Chris McDonough 18 Oct '00

18 Oct '00

Hi. There's a short howto describing the semantics of ZODB transactions at http://www.zope.org/Members/mcdonc/HowTos/transaction. Enjoy!

1 0

strange <dtml-sendmail> problem
by Erik Myllymaki 17 Oct '00

17 Oct '00

This is a DTML_Method I call from my standard_error_message: <dtml-sendmail mailhost="MailHost"> To: Webmaster <<dtml-var webstaff>> From: ZopeServer <<dtml-var zopeserveraddress>> Subject: Problem at <dtml-var URL> Error Type: <dtml-var error_type> Error Value: <dtml-var error_value> Error Msg: <dtml-var error_message> <dtml-in "REQUEST.items()"> <dtml-var sequence-key>: <dtml-var sequence-item> </dtml-in> </dtml-sendmail> I call it like this: <dtml-var send_errors> The mail is sent appropriately including all the REQUEST items, but the page that is calling this DTML_Method never finishes downloading. It seems that the loop through the REQUEST items causes page rendering to hang? After several minutes, stopping the page download brings up a *transfer interupted* message and only then do I see the bottom of the page. If I leave this out: <dtml-in "REQUEST.items()"> <dtml-var sequence-key>: <dtml-var sequence-item> </dtml-in> ...it works well. Thanks for you help. -- Erik Myllymaki erik(a)pacific-shores.com

2 1

GUF and IE friendly error messages
by Paulo Eduardo Neves 17 Oct '00

17 Oct '00

Hi, I'm using General User Folder (GUF) in cookie mode for the login in my site. When someone doesn't have the appropriate permission to access a resource, GUF should show the Login screen. It works fine, except for some people (not all) that uses Internet Explorer 5. They see IE http user friendly error page. If the user is told to change the IE configuration for not showing friendly errors, the login screen appears. It is not easy to setup for unexperienced users. When the http status is 400 (not found) IE shows the friendly error just for pages smaller than 512 bytes. Unfortunately, it doesn't work when the error status is 500 (server error). I've tried to change http status with RESPONSE.setStatus(200) in the standard_html_error, but it doesn't work. Is it possible to change the http status after an exception is raised? Can someone suggest a solution or workaround for this problem? Thanks in advance for any help, -- Paulo Eduardo Neves http://www.samba-choro.com.br

1 0