July 2003 - Zope - Zope lists

Formulator - pre-selecting a line in a multiline field - still unsolved.
by David Washburn 23 Jul '03

23 Jul '03

I am using a multiline Formulator widget and I want to preset the line in a list using a value from the record in the database which I read in my DTML document, and which is going to be updated. I read the record and I can display all the "fixed" fields with no problems. I am still not clear on how to specify the default value, which is gotten from the database record, when I display the form using Formulator. I have successfully created a Python/Script & ZSQL Method (it is in the TALES Item field) to read a code table from a MySQL database and display it in the Formulator form when it is rendered. This list has two values per line, the text displayed and the numeric code that is to be returned when the user make a choice from the list. Dieter made a suggestion that I place the value of the data item that I want to use to point to the correct line in the multiline widget, in a hidden field so that it will be accessible when Formulator renders the field. The document that displays the Formulator widgets is a DTML document that I coded to display the data fields using calls to the Formulator API. The lines look like this: ..... <tr> <td> <input type="HIDDEN" name="company_contact_id_selected:int" value="<dtml-var company_contact_id null="">"> <dtml-var "profile_form.company_contact_id.get_value('title')"></td> <td><dtml-var "profile_form.company_contact_id.render(_['company_contact_id'])"></td> </tr> ..... Which is rendered like this: <tr> <td> <input type="HIDDEN" name="company_contact_id_selected:int" value="6"> ADVANCE Contact ID</td> <td><select size="1" name="field_company_contact_id" ><option value="0" >Unknown </option> <option value="22" >Sam (from: UK)</option> <option value="26" >Bill (from: VN)</option> <option value="6" >Bruce (from: SG)</option> <option value="24" >Seth (from: US)</option> </select> </td> </tr> What I want to be able to do is have the line that displays "Bruce (from: SG)" selected when the form is displayed since he is ID # 6. It should have looked like this: <option value="6" selected>Bruce (from: SG)</option> The question is, what is the syntax I need to use in the Formulator/TALES management screen for a multiline widget to reference the data in the hidden field called "company_contact_id_selected". I think I need to place a reference to the variable "company_contact_id_selected" in the TALES default field, but I can't seem to find the correct syntax to reference it. Does anyone have any ideas? Thanks, David ======================================= David T. Washburn DWashburn(a)AmInfo.com Amherst, MA USA 413 256-3103

1 0

Re: [Zope] How does GroupUserFolder work ?
by Gelin Patrick 23 Jul '03

23 Jul '03

Ok but I don't understand the documentation of ingeniweb. I've installed a GroupUserFolder in my Plone site. There is two user's folder, one for users and one for groups. I create some users and some groups, and then? What can I do with group? I didn't find how to add users into groups... Why to add users into groups???? What is the goal? Patrick Gelin Chef de projet RPN Office de la Statistique et de l'Informatique Scolaire Tour Espace-Citée, 4ième étage CH-2300 La Chaux-de-Fonds Tél: +41 (0)32 919 79 13 Email: patrick.gelin(a)rpn.ch > -----Message d'origine----- > De : Pierre-Julien Grizel [mailto:grizel@mouli.net] > Envoyé : mercredi 23 juillet 2003 08:46 > À : Gelin Patrick > Objet : Re: [Zope] How does GroupUserFolder work ? > > > Hi, > > GroupUserFolder is a generic groups management for Zope. It does provide > groups management inside the ZMI but doesn't provide any kind of > delegation or such. What you seem to want is a content-management > platform. You may want to have a look at Plone which is currently > integrating strongly GroupUserFolder to implement some of the features you > are looking for. > > For more information about GRUF, see > http://ingeniweb.sf.net/Products/GroupUserFolder. > > > > Cheers, > > > P.-J. > > > > Hi, > > > > I would like to understand what exactly GroupUserFolder is. > > > > What I want to do is that each group is independent, with its own > > private forum, documents, members, calendar, etc. I would like a user > > have the ability to belong one or more groups. I would like some users > > have the ability to register others inside groups. Finally, I would like > > a user log in and after he has the ability to choose a group to work > > with. (In fact I would like something like groove) > > > > Is GroupUSerFolder my solution? > > > > Thanks. > > > > Patrick Gelin > > Chef de projet RPN > > Office de la Statistique et de l'Informatique Scolaire > > Tour Espace-Citée, 4ième étage > > CH-2300 La Chaux-de-Fonds > > Tél: +41 (0)32 919 79 13 > > Email: patrick.gelin(a)rpn.ch > > > > > > > > _______________________________________________ > > Zope maillist - Zope(a)zope.org > > http://mail.zope.org/mailman/listinfo/zope > > ** No cross posts or HTML encoding! ** > > (Related lists - > > http://mail.zope.org/mailman/listinfo/zope-announce > > http://mail.zope.org/mailman/listinfo/zope-dev ) > >

3 2

multiple Zope connections to the same database within different branches
by Julian Clark 23 Jul '03

23 Jul '03

Hi list. I'm just curious, if you've got two connections to the same database in 2 different branches at the same level, is it better to put those 2 connections in the 'trunk' of those two branches. Is there performance reasons to do so/ not to do so? for example ZopeRoot ---branch1 --- dbconn billybob ---branch2 --- dbconn billybob as compared to ZopeRoot ---dbconn billybob ---branch1 ---branch2 Say also, if branch1 experiences much more traffic than branch2 (which is the case in my installation), is this much of a consideration? Are there any other issues here which I would need to be aware of? Cheers, Julian

2 1

linking zope/CMF objects to sql databases?
by Kelley, Sean 23 Jul '03

23 Jul '03

I need a content management system which acts as an operation and maintenance manual for assets. I need to be able to pull related data from a SQL database and update the SQL database by linking to some plone/zope object like folder id or possibly asset number as a value in the property of plone/zope objects. For example, if I have a record in the sql database, I want to allow users to add documentation, images, and other things to the plone folder and have it relate to the sql data for that asset ID. How might this be done? Is there an existing product? Is there a better way to relate this data? Anybody tried this? thanks, Sean

2 1

dtml to tal - advice
by dean hale 23 Jul '03

23 Jul '03

Hi Anyone any ideas, I have this in dtml (it uses other bits to query an sql d/b to return weblinks, does anyone know how to render it in ZPT. I cannot for the life of me figure it out. I may then be able to guess how to do the rest. Hope it's clear. ---find_a_link_search---- <dtml-if "REQUEST.has_key('search_string')"> <dtml-call "REQUEST.set('s',search_string)"> </dtml-if> <dtml-in expr="is_proxy.callRemoteMethod('weblinks_py',s)"> <dtml-if sequence-start> <table border="0" width="100%" align="center"> <tr> <td align="center"> Find a Weblink search results - <dtml-var sequence-length> matching titles found </td> </tr> <tr><td> </td></tr> </table> </dtml-if sequence-start> <dtml-var sequence-item> <dtml-else> <table border="0" width="100%"align="center"> <tr> <td align="center" bgcolor="#CCCCCC"> Find a Weblink search results </td> </tr> <tr><td> </td></tr> <tr><td align="center">Sorry, no matching Weblinks were found.</td></tr> <tr><td align="center">Try Again?</td></tr> </table> </dtml-in> Thanks very much dean -- Dean Hale Information Services Web Development Manager 0191 515 2424

4 3

objectValues and root folder in a VirtualHostMonster site
by Pete Phillips 23 Jul '03

23 Jul '03

Hi I have a site which I developed as a sub site of the root zope folder: /test_web_site I use apache rewriting and the VirtHostMonster to make /test_web_site/ the root of the particular site I'm working on. Unfortunately we used DTML (my other ones now use ZPT but I don't have time to rewrite this one at the moment). I have a piece of code which loops through all the folders: <dtml-in expr="objectValues('Folder')"> ... Previously it was: <dtml-in expr="test_web_site.objectValues('Folder')"> and this worked fine. Now with the test_web_site removed (so that I can relocate as necessary) I get nothing returned. Can anyone point me in the right direction ? I would have thought that something along the lines of expr="root.objectValues('Folder')" would be the right thing to do, but can't find the ccorrect syntax. Regards, Pete PS: using Zope 2.6.0

2 1

python TTW script kills zope
by Gilles Lenfant 23 Jul '03

23 Jul '03

Hi! I noticed a strange behaviour in an old Zope 2.3.3 that's raised by this simple Python script (run by a Manager) aclu = container.acl_users allUsers = aclu.getUsers() print len(allUsers), "users" for someUser in allUsers: print 'an user' # this raises the error print "Terminé" return printed This kills Zope and the console shows this... assertion "STACK_LEVEL() <= f->f_stacksize" failed: file "Python/ceval.c", line 695 ------ 2003-07-23T12:53:03 ERROR(200) zdaemon zdaemon: Wed Jul 23 14:53:03 2003: Aiieee! 83355 exited with error code: 6 When changing "print 'an use'" with "pass", this runs OK. Any idea ? Thanks in advance. --Gilles

3 2

usage of dtml-sqltest tag in Zsql method
by Anitha George 23 Jul '03

23 Jul '03

Hi Someone please help me out with this: I am passing a string in this format (215,216) from the python script to the Zsql method. The SQl query should have the following form: select * from employees where id in (215,216) but is as follows: select * from employees where id in '(215,216)' which does not give the required result.The id is of data type string/nb. It doesnt accept integer values. A sample usage is given in the Zope documentation **************************************** select * from employees <dtml-sqlgroup where> <dtml-sqltest salary op="gt" type="float" optional> <dtml-and> <dtml-sqltest first type="nb" multiple optional> <dtml-and> <dtml-sqltest last type="nb" multiple optional> </dtml-sqlgroup> If first=Bob and last=Smith, McDonald it renders: select * from employees where (first='Bob' and last in ('Smith', 'McDonald') ) *****************************************8 But it is not working when I tried it. I get the following result select * from employees where (first='Bob' and last = 'Smith,McDonald' ) Please help me out!!Is there any other type for declaring the database fields other than int,float,string and nb.I am using Zope version 2.5.1 . The documentation covers Zope 2.5. Thanks Anitha _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

2 1

Re: Windows and Linux
by Josef Meile 23 Jul '03

23 Jul '03

> How can I provide a full traceback ? If you can access the manage interface, then go to the error_log object and copy the last exception. In case that you can't access the manage interface and you are double clicking on start.bat, don't do that because the dos window will disapear as soon as an error occurs. You have to go to the start menu, choose run, type cmd, then go to the folder where start.bat is and execute it. Finally copy the exception that apears in the dos window. Regards, Josef

1 0

ZPT macro using a macro from the same page template
by Gilles Lenfant 23 Jul '03

23 Jul '03

Hi, I made an all purpose widget macros collection template, and one macro from the template is used by another one. Is there a kind of shortcut to tell the main macro that the secondary macro is defined in the same template ? <div metal:define-macro="aux"> </div> <div metal:define-macro="main"> <div metal:use-macro="xxx/aux"> </div> </div> Thanks in advance for the hints --Gilles

4 9