December 2001 - Zope

delete multiple records sql python etc
by Todd Graham 06 Dec '01

06 Dec '01

I've looked through the archives and seen similar posts but none of the replies seem to solve my problem. Here goes... I've got a table called user_accounts that has user_id, application, username that make up the primary key, this is a child table to the user_info table which has user_id as the primary key. As part of the application I want my users to be able to delete multiple rows from the user_accounts table that are displayed in a form via a zsql method that looks like : select * from user_accounts where user_id = <dtml-sqlvar user_id> Based on the result sets of the sql method I build a form that lists the username, user_id, application etc, with one checkbox for each record. My question is how do I pass the all the values from one or more rows to a python script based on whether or not the box is checked. I've tried several combinations of using record(s) converters and list converters but at this point I'm stumped. Thanks in advance, Todd

4 4

Re: [Zope] delete multiple records sql python etc
by H.de.Wit＠SFK.NL 06 Dec '01

06 Dec '01

>I'm stumped because I need to pass three values to the delete method (which >has three arguments) based on one checkbox in the html form: Ideally I'd >like to pass the values to a python script where I can check the value of >the APPLICATION attribute and call different methods based on that value. >The three values are what make the record unique. May be you can add extra hidden <inputs>, which can be also part of a list near the checkbox input. Something like: <form action=throw_away_script method=post> <dtml-in expr="SQL_from_useraccount(user_id=REQUEST['user_id'])"> <input type=hidden name=extra_info1:list value="<dtml-var whateveritmaybe>" <input type=hidden name=extra_info2:list value="<dtml-var whateveritmaybe2>" <input type="checkbox" name="throw_away_list:list" value="<dtml-var user_id>"> </dtml-in> </form> In the python script you can handle the lists (but the lists are not parameters of the pythonscript). Met vriendelijke groeten, Hans de Wit Stichting Farmaceutische Kengetallen Postbus 30460 2500 GL DEN HAAG Tel. 070-3737448 Fax 070-3737445

1 0

Trying to get tree working
by Frans C.H. Schneider 06 Dec '01

06 Dec '01

Hi * Maybe this is a stupid question but I just can not get it working. I have a page from which the user can view basic item data and which has a link to a page to display the bill of material of the item. <TD bgcolor="#97bae6" width="20%"> <dtml-with "_(abs_path=bmpsiq.absolute_url())"> <a href="&dtml-abs_path;?ps_par=<dtml-var pt_part>" target="main"> Stuklijst </a> </dtml-with> </TD> To get the bill of material I have the following sql method: <params>ps_par</params> select ps_comp, ps_start, ps_end from ps_mstr <dtml-sqlgroup where> <dtml-sqltest ps_par type=string op=eq> <dtml-and> <dtml-sqlgroup> ps_start = ? <dtml-or> ps_start <= today </dtml-sqlgroup> </dtml-sqlgroup> The dtml method to display the tree is : <dtml-let ps_comp=ps_par> <dtml-tree id=ps_comp branches_expr="ps_childLookup(ps_par=ps_comp)"> <b><dtml-var ps_comp></b> <dtml-var ps_start> </dtml-tree> </dtml-let> It works for the first time but when I try to expand it I get a key error on ps_par. What goes wrong?? Hope somebody can help Frans -- Frans C. H. Schneider <mailto:f.schneider@nido.nl> NIDO Universal Machines BV <http://www.nido.nl> Industriestraat 34 <mailto:info@nido.nl> PO Box 30 tel. +31 (0) 548 370 000 7450 AA Holten fax +31 (0) 548 370 233 the Netherlands

3 4

Zope Directory and WebRing News
by lozinski＠openstepnews.com 06 Dec '01

06 Dec '01

The zope webring has grown up into a zope directory. The new home page is at www.pythonandzope.org There are 15 websites currently sharing traffic in the webring and directory. 5000 hits since we started in August. You are invited to join. Just click on the about button in the upper right hand corner of the web site to find out more. There is also a section on Resumes and Jobs. You are invited to list your resume or job there. Regards Chris 1-510-795-6086 lozinski(a)openstepnews.com lozinski(a)jobmart.com

2 1

Product help
by Todd Loomis 06 Dec '01

06 Dec '01

Hi All: After creating a product to use in my site I realized I need to add auto id naming when they use it. How can I add this, I want to just use number so they don't have to worry about naming them. Thanks, Todd

1 0

Help on mass import of images
by Sven Rudolph 06 Dec '01

06 Dec '01

Hello, I have a problem to import images automatically. All in all I have 2000 images to import into zope, and I tried the following method: I created an external method "import_images.py": >>>>>>>>>>>> from OFS.Image import Image def import_pictures(self): id='picture1' handle=Image(id,'','',content_type='image/gif') self._setObject(id,handle) self._getOb(id).updata_data('''TheImage''',content_type='image/gif') id='picture2' handle=Image(id,'','',content_type='image/gif') self._setObject(id,handle) self._getOb(id).updata_data('''TheImage''',content_type='image/gif') .....and so on <<<<<<<<<<<<<<<<<< I copied it to <zope-path>/Extensions, created an "External Method"-object in my image folder and then clicked on the "Test"-tab of my external method. I got two different types of errors, depending on the encoding of my image-data. If the string "TheImage", which contains the image data, was base64 encoded, an image object was created, but the image data was broken (view tab of the image object). If the string "TheImage" contained the pure binary data of the image (starting with GIF89a...), I got a syntax error from the parser when I tried to create the external method, as I expected. I also tried to upload the image data with self._getOb(id).manage_upload('''TheImage''') but with the same results. Can anybody help me? P.S. By the way: the script "import_images.py" is automatically created by a perl script. Thanks in advance Sven -- Sven Rudolph GermanMedicalServices.de GmbH Unter den Eichen 5, 65195 Wiesbaden Tel.: 06 11 / 97 46 25 2

4 3

2 Questions about links and files
by Gordon Holtslander 06 Dec '01

06 Dec '01

1. I have a local file system directory that has Word doc sermon outlines in it. I'd like to have a link to the most recent of those files, but I don't want to change it manually. Is there some way to have the link point to the most recent file? 2. Obviously, not everyone has Word on their system. Is there some way to dynamically take a word doc from the directory and turn it into a "browser doc" so everyone can see it. I don't want to change the Word docs permanently because people still need and use them as Word docs. I don't want to have to manually transform all of them into html, although if that was the least painful method of dealing with this I could. There are about 85 docs now, but there are at least 2 and as many as 9 added each week. Thanks in advance, Gord Gordon W. Holtslander Director of Development & Information Technology The Lung Association - Saskatchewan gordon.holtslander(a)sk.lung.ca <mailto:gordon.holtslander@sk.lung.ca>

3 2

Zope solution.
by Geir Arne Evjen 06 Dec '01

06 Dec '01

I'd heard about this nice product throught a collegue of mine, and I have some questions in which I hope someone can answer me :-) Me and someothers are working with thermodynamic modelling and alogorithms. One year ago we saw the need of distribution of our code, which means that we made our thermodynamic calculation engine as a separate module, and other modules could use this one (The thermodynamic core could also access other modules again). All communication between the modules are in CORBA. When we want to send data to the modules, id.e. modellparameters we use XML. Later we created a dynamic GUI language for manipulation of the parameters and other stuff, inserting values into the XML tree and calling the different module functions. Its our glue module. (which is more or less does the same as Zope (Correct me if I'm wrong.). So to my question: This summer we built a GUI client using java which communicated with our gluemodule. This is a solution we want to have. Is it possible in Zope to accomplish this in some way. (Id.e communication without using a web client) Best regards, Geir Arne Evjen

2 1

Problems writing a new product
by Tille, Andreas 06 Dec '01

06 Dec '01

Hello, I plan to write a product derived from Folder which has some keywords as additional properties. Those keywords should be included as meta tags of the documents of this folder. I tried to understand the Zope Developers Guide and copied the basic folder class to MyFolder and did some changes. While I had some syntactical errors I´ve got a "Broken product" in my Zope product folder and found the error log. After fixing those errors I was quite happy - but now the Product vanished from my products folder after restarting Zope :-((. Any idea what could be wrong here? I'm using Zope 2.4.2 on a Debian GNU/Linux system. I might note that this could be caused by the following side effect. I had trouble installing the PageTemplate Product which was also not presented in the Products folder. When restarting Zope I've got: # /etc/init.d/zope restart Restarting Zope...WARNING: Python C API version mismatch for module pyexpat: This Python has API version 1010, module pyexpat has version 1007. ........ done. While doing my debugging stuff I did not see this Warning message. But when my Product MyFolder seemed to be syntactically OK this warning reapeared - and PageTemplates was in my Products folder mytseriousely. This is kind of strange but it might be that the warning is a hint that one of my products can not be installed and now MyFolder took over the role of PageTemplates? I append my really first try in a tar file. Could somebody please give me a hint? Kind regards Andreas.

3 8

(no subject)
by sanket 06 Dec '01

06 Dec '01

Message: 47 Date: Tue, 4 Dec 2001 21:00:08 -0800 (PST) From: Maneesh Yadav <yadavm(a)scripps.edu> Reply-To: Maneesh Yadav <yadavm(a)scripps.edu> To: zope(a)zope.org Subject: [Zope] newbie... Disclaimer: I think it took me a year to realize what Zope actually is....maybe I still don't know :) Sorry to bother you all, but the Zope environment is so rich with options I'm not sure which path I should take. I am doing a web page for my lab and I have Zope up and running fine and I think I understand most of the basics....now I need to make a web page that I'd like to do a couple of things, keep a little profile of each person in the lab, have a little web interface for POs (just a form with some fields that writes stuff to a database so everyone can see what items have been ordered) and an overview of research. It's not really dynamic content, but I'd like to use Zope for the ordering system and to ease design. I was going to make a bunch of METAL macros but I *think* it'd be smarter to store things like personell profile in a database and have a web page that just prints out the contents and the same kinda thing for lab POs (purchase orders)... Would someone mind giving me a general layout for connectivity between everything? I know Zope has ZopeDB but it is unclear to me as to how to actually make data entries and define a database...or do I have to make my database in postgresql and connect to the database over zope? So I know I should use metal for general site layout (nav bars and the like), but how can I arrange my two underlying databases and what do I use in Zope to connect to them and present the results of the SQL queries? Would it be easy to have a tree like nav bar on the side (like Zope?), what component does the 'tree' code fit under? No need to xplain in too much detail, jbasically just what tool I need to do what and I am sure I can follow one of the tutorials... Many Thanks, Maneesh Hi Maneesh, its good that you have decided to use Zope. Actually its not very clear to me what are your requirements. But as far as creating profiles of people are concern, i think its easily possible with Zope. 1.Maybe you can start with a form with name and other details of your lab members. 2. A small python script will create new entries everytime you feed in the data and create the id's of the entry to number of the employee...or something which will be unique to that employee. 3.This entry (object) will have other details(profile) of the employee as its properties. 4.You can use the unique id you create to look for that particular employee from your webpage. I hope this is what you want to do. Sanket.

1 0