- Zope - Zope lists

How to set default permissions for objects in extern product
by Dirksen 08 Jul '01

08 Jul '01

Hi, I want default permission settings for my object, which is an external product. I'd like, when people add my object to their folder, the object has already created the appropriate custom roles, and associated with them the appropriate permissions. I've tried to add a line 'self.manage_roles("member", "View management screens")' to the __init__ method of my object, but it doesn't work. Any idea? Cheers Dirksen __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

2 1

Site statistics
by Gitte Wange 08 Jul '01

08 Jul '01

Hello, I was just wondering if Zope logs who visits what on a site ??? Usually everything that happens on your webpages (when you e.g. use apache) ends up in you webservers access_log. But does ZServer logs the same ? If so - has anyone created a product to get this data out of the log files and display them on a webpage ?? Before I started on Zope, I was using something called webalizer. Or - is it hard to "analyze" a log file and display the data from it ??? Regards, Gitte Wange

8 11

ZSQL w/direct traversal look everywhere else before passing value
by Joel Burton 08 Jul '01

08 Jul '01

If I create a ZSQL method called "by_id", and set it to use direct traversal, and give it a URL like this: http://foo.com/by_id/board It returns my page at /board, rather than passing board as the value required by ZSQL method. If I do this; http://foo.com/by_id/board/my_display_method it raises an error, as my_display_method never gets the results of the ZSQL method, therefore, things that would have passed along, like board member name, etc., never arrive. An obvious but icky solution is to not have anything in my acquisition path that might be passed as a value to the ZSQL method. This is really ugly though, since new values are added to the database all the time, and it would be hard to make sure this doesn't happen. Ideas? Fellow sufferers? Workarounds? All would be appreciated. Thanks! -- Joel Burton <jburton(a)scw.org> Director of Information Systems, Support Center of Washington

1 0

Re: [Zope] Access SQL record from list
by Tim Considine 08 Jul '01

08 Jul '01

Hi Alan Thanks for this - I have tried to integrate this into my code as follows (some edited for brevity), but I get an error KeyError on KeyValue ContactID. But I can't see where it is wrong - the SQLContactRecord method works fine manually. SQLContactRecord (SQLMethod) ======================== argument : CID select FirstName from contacts where ContactID=<dtml-sqlvar CID type=int> ViewContact (DTML) =============== <dtml-var standard_html_header> <dtml-call "SQLContactRecord(CID=CID)"> You selected <dtml-var FirstName> <dtml-var standard_html_footer> ShowAllContacts ============ <dtml-var standard_html_header> <dtml-in SQLContactsListLastName> <table> <tr> <td><a href="ViewContact?CID=<dtml-var ContactID url_quote>"><dtml-var ContactID></a></td> <td><dtml-var FIRSTNAME></td> <td><dtml-var LASTNAME></td> </tr> </table> </dtml-in> <dtml-var standard_html_footer> Any thoughts ? Tim Considine On Sunday 08 July 2001 5:13 pm, you wrote: > What you'll want to do is create a link that points to another page > and passes a unique identifier to the page for use in an SQL method. > > Here's an example from a simple Bill of Materials system I wrote. The > first method is called component_list and displays a component > database. The second is the del_component method which call del_comp > (an SQL method) and then redisplays component list. (There are more > pieces to the example, but this is the gist.) > > My system runs on an Access database, and uses an autonumber field to > provide a unique identifier to each record which is used in other > tables to reference the record. You can use any kind of unique > identifier. If the key is not unique, you will return multiple > records (which may be desirable depending on your needs). > > The user sees a list like this, where the first and last colums ar > clickable and act on different records. > 3COM Hub 16-port 16-port 10/100BASE-TX Fast Ethernet Hub Remove > 3COM Hub 8-port 8-port 10/100BASE-TX Fast Ethernet Hub Remove > 3COM 10/100 NIC 10/100 PCI Adapter Remove > > > component_list > ================= > <dtml-var standard_html_header> > > <TABLE border=0 cellpadding=2> > <TR align=center bgcolor=#dd88ff> > <TD>Name</TD><TD>Desc</TD><TD><BR></TD> > </TR> > <dtml-in all_components> > <TR> > <TD><a href="form_edit_component?itemnum=&idnum=&cid=<dtml-var > CIDNum url_quote>"><dtml-var CItem></A><BR></TD> > <TD><dtml-var CDesc></TD> > <TD><a href="del_component?comp=<dtml-var CItem>&cid=<dtml-var > CIDNum url_quote>">Remove</A></TD> > </TR> > </dtml-in> > </TABLE> > <BR><BR> > <a href="/BOM/form_add_component">Add a new component</A><BR> > > <dtml-var standard_html_footer> > > del_component > ================================ > <B></B> > <dtml-if "xref_by_comp(comp=cid)"> > <BR>You cannot delete this component. It is in use in the following > items:<BR><BR> > <BLOCKQUOTE> > <dtml-in "xref_by_comp(comp=cid)" > > <dtml-if first-Parent> > <dtml-in "components_all(item=Parent)"><BR> > <dtml-var CItem><BR> > </dtml-in> > </dtml-if> > </dtml-in> > </BLOCKQUOTE> > <BR>Remove the component from all of the items listed above, then > return here and delete it.<BR> > <dtml-else> > <dtml-call "del_comp(cid=cid)"> > <dtml-call "RESPONSE.redirect('component_list')" > > </dtml-if> > > del_comp > =============== > argument: cid (unique id of record) > DELETE FROM Components > WHERE CIDNum = <dtml-sqlvar cid type=int> > > > > - Alan > --------------------------------------- > Zope tips and tricks site > http://twsite.bizland.com/zopetips.htm > http://www.twstore.com > > > -----Original Message----- > > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of > > Tim Considine > > Sent: Sunday, July 08, 2001 10:40 AM > > To: zope(a)zope.org > > Subject: [Zope] Access SQL record from list > > > > > > > > I am confused how to access a specific record in a MySQL database, > > from an HTML table holding the results of an SQL query. > > > > For example I use a DTML method with a form to specify a name, and > > then call an SQLMethod, which returns a list of names into an HTML > > table. > > > > I can specify an HTML link to another DTML or SQL Method, but I am > > not sure what that method should be. > > > > Any advice ? > > > > > > Tim Considine

1 0

manage_defined_roles pb.
by Didier Georgieff 08 Jul '01

08 Jul '01

Hello, I've created a Zclass, with a need for some roles. So i've created a setup method (localized on the root folder) for adding this role. Looking at the ZMI code shows that this should work. <dtml-call "REQUEST.set('role','PopotoGest')"> <dtml-call "REQUEST.set('submit','Add Role')"> <dtml-call "manage_defined_roles(REQUEST['role'],REQUEST['submit'],)"> This raise no error BUT doesn't create the role. Did I missed something ? And what ? Thanks in advance.

2 1

Fishbowl process for private intranets
by Mark Langkau 08 Jul '01

08 Jul '01

Hi, We think the Fishbowl process is a Very Good Thing (TM) and would like to implement it on our company intranet for our own development projects. Are project templates available for download anywhere? In other words, when a new proposal for a project is initiated in the DC Fishbowl process, are those "starter" outlines/wiki pages available for others to use outside of dev.zope.org? Even if we didn't implement the workflow process, having the blank templates and links would be incredibly helpful. (And would perhaps spark an internal interest here to contribute to the Zope development process ). I believe that the best software development practices are being developed and implemented within the Open Source community. And, specifically, the Zope Fishbowl process looks like a great model that we would like to implement. (Using Zope of course ;-) I have already started the process on our intranet - with the code name "Palmolive Project." Remember the old TV commercial for the dishwashing zope.. er, soap? Madge would be telling her manicure customer about how great the product was on your hands, when she would casually say "you know, you're soaking in it?" Well, now that our Zope/CMF intranet has become the accepted source for internal docs and such, I can now say "you know, you're soaking in it." Suddenly everyone wants to participate. (hehehe) Thanks, Mark

2 1

Los Angeles Zopistas ?
by Jason Cunliffe 08 Jul '01

08 Jul '01

Hi Visiting LA for a few weeks starting 18-July. Anyone know of any Zope LA meetings/group? ./Jason

2 1

Access SQL record from list
by Tim Considine 08 Jul '01

08 Jul '01

I am confused how to access a specific record in a MySQL database, from an HTML table holding the results of an SQL query. For example I use a DTML method with a form to specify a name, and then call an SQLMethod, which returns a list of names into an HTML table. I can specify an HTML link to another DTML or SQL Method, but I am not sure what that method should be. Any advice ? Tim Considine

2 1

Zope + SVG = killer map server ?
by Didier Georgieff 08 Jul '01

08 Jul '01

Hello, We are thinking about replacing our Arcview Internet Map Server (serve map datas images to web clients, ans more) with a Zope + SVG architecture. We already can see the huge benefits for such a framework : - benefits of SVG on the client (make the application more interactive and quite speedy after the data download) - benefits for a geographical base class (*any* document being able to self represent or localize on a map, ...) - benefits of interoperability with gis data - benefits of zope for managing all the complexity, - so and so Before going further (architecture and implementation), is there any one who already had same thought, or is there any similar project where we can drop in ? I already have some working pieces and some conceptual pieces, and all that needs to be properly discussed. Honnestly, this could be the next CMFlike killer app because maps are soooooooo sexy ;-))) Regards. Didier.

1 0

ZDOM ... un-domlike?
by Matt 08 Jul '01

08 Jul '01

Hi, I have a simple question. I have been plying around with the ZDOM interface to Zope objects, and there seems to be something I don't quite understand. I have figured out that the attributes of any particular zope object are its properties. However when I print out attribute values using getNodeValue() on items in a list returned by getAttributes(), I get values of different types!! That is very un-domlike. The result should be a DOMString. I understand that this would make it less nice for people wanting to access their content and properties without fuss, but there are other object methods that already let you do this. I was wondering the reasoning behind this, and perhaps, if I am looking at the ZDOM in the wrong light. thanks Matt

1 0