- Zope - Zope lists

Access to Data.fs without Zope ?
by jurgen.defurne＠pandora.be 06 Mar '05

06 Mar '05

Hello, Last summer I wrote an application to inventarise all my media (books, CD's, periodicals, etc) which worked well, but wasn't yet complete. Anyway, I started adding books as an exercise to see how it could be improved. However, I run Debian testing, and after some updates in the fall I could not get access anymore to my data. Today I tried to move the contents of Zope default to a known running instance of Zope, but the moment I do that, the Zope instance cannot be started anymore. Replace the contents back by its originals and the instance can be started once again. So, is there a way to access the contents of the Data.fs file without using Zope alltogether, so that I at least can start working again ? Regards, Jurgen

5 8

ZMySQLDA-2.0.9b3 released
by Andy Dustman 06 Mar '05

06 Mar '05

https://sourceforge.net/project/showfiles.php?group_id=22307&package_id=381… This release fixes the problem of MySQLdb-1.0.0 and newer returning BLOBs as character arrays, and returns them as strings. It also should be a bit more robust if connections time out. I would really like to get some feedback on this release within the next week so I can make a final release for 2.0.9. Here's an open issue: Should character data be returned as unicode? It probably wouldn't be hard to implement, but I wonder how much other stuff would break. There's already a ton of stuff being stuffed in the connection string, but it probably needs to be a connection option, doesn't it? -- Computer interfaces should never be made of meat. Using GMail? Setting Reply-to address to <> disables this annoying feature. You are in a maze of twisty little passages all alike. To go north, press 2. To go west, press 4. To go east, press 6. To go south, press 8. If you need assistance, press 0 and a little dwarf will assist you.

2 1

thanks jonathan but problem remains.
by prabuddha ray 05 Mar '05

05 Mar '05

jonathan sir , thanks for that detailed solution. but i guess my problem was simpler. i cudnt explain it properly . I've to rebuilt a login page in zope which i'd developed in asp. I'd used javascript to do wat u've mentioned in 3rd soln. but the javascript is not at all being executed in zope. This is wat i wanted : as soon as i select a district from a combobox the corresponding user list in next combobox sud appear.the data are being fetched from Mysql using the ZSQL queries. AND CAN WE ANYWAY USE JAVASCRIPT IN DTML DOCUMENTS. please tell me the soln in ZOPE.

3 2

CMF Photo FTP Error?
by Jake 05 Mar '05

05 Mar '05

Zope 2.7.4, CMF 1.4, Photo & Photo Folder (something) I can add photos through the ZMI, but through FTP I get this and it was working great in Zope 2.7b4. Exception Value _data Traceback (innermost last): * Module ZPublisher.Publish, line 101, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module webdav.NullResource, line 152, in PUT * Module OFS.ObjectManager, line 276, in _setObject * Module Products.Photo.Photo, line 623, in manage_afterAdd AttributeError: _data Jake -- http://www.ZopeZone.com

5 6

parameter prob remains
by prabuddha ray 05 Mar '05

05 Mar '05

thnx 4 the tip. but i got the following error when testing Error Type AttributeError Error Value 'dict' object has no attribute 'districtname' I don have anything like 'dict' . the stmt was ; <div tal:repeat="district python:context.getDistrictUser(district_name=request.form.districtname)"> district_name is parameter name in ZSQL method. i must tell u dat this repeat tag is being used to fill data in a combobox n i'm getting the districtname from another combobox selection. The same logic worked with asp but don kno y giving error here.plz help. Hong Yuan wrote: You can use python syntax to pass parameters explicitly to ZSQL methods, like: <div tal:repeat="district python:context.getDistrictUser(some_param=request.form.districtname)"> prabuddha ray wrote: >I've a parmetarized ZSQL method used to fill data in a >combobox. >When changing the selection of another combobox i'm calling the >page >itself again and have to pass the value in the previously >selected >combobox as parameter in the ZSQL method filling data in 2nd >combobox. > >i tried this <div tal:repeat="district >container/getDistrictUser" >request.form.districtname> , districtname is the parameter to be >passed > >what sud be the correct syntax

2 1

Open Source POSIM Systems
by Asad Habib 05 Mar '05

05 Mar '05

I am looking for a reliable open source POSIM(Point of Sale Inventory Management) system to use to build an e-commerce web application. If you know of one, please let me know. Thanks. - Asad

1 0

parameter passing problem.
by prabuddha ray 04 Mar '05

04 Mar '05

I've a parmetarized ZSQL method used to fill data in a combobox. When changing the selection of another combobox i'm calling the page itself again and have to pass the value in the previously selected combobox as parameter in the ZSQL method filling data in 2nd combobox. i tried this <div tal:repeat="district container/getDistrictUser" request.form.districtname> , districtname is the parameter to be passed what sud be the correct syntax

2 1

UploadFile size and Image size (PIL)
by Garito 04 Mar '05

04 Mar '05

Hi all I'm trying to reduce big image uploadfile with PIL But I have a little problem: I know the size of the uploadfile (moving the file pointer with read() and then tell()) but I need to create a PIL.Image object and for that I need to know the Image size (with and heigh) There are any kind of method to know these issue? Thanks

2 1

Post authentication hook and anonymous users
by Cyrille Bonnet 04 Mar '05

04 Mar '05

Hi Zope people, I have been using Dieter Maurer's Post authentication hook quite successfully to restrict access to a folder for a group of users. Now, my problem is that Post authentication hook is only called... for authenticated users (as its name implies). That's a problem for me, because anonymous users that can guess a URL could access private areas that I have set up. (BTW, I am aware that I could restrict the access by changing the "View" permission in the "Security" tab and remove "Acquired", but that's not good enough: it then shows all documents to authorized users, regardless of their worflow state). Anyway, I am thinking of adding an unvalidated_hook call in ZPublisher/BaseRequest.py, something like: if user is not None: if validated_hook is not None: validated_hook(self, user) request['AUTHENTICATED_USER']=user request['AUTHENTICATION_PATH']='/'.join(steps[:-i]) else: unvalidated_hook(request) And then in unvalidated_hook, I would dynamically check if anonymous users can access the current folder. Am I on the right tracks or is there a built-in functionality in Zope to accomplish what I am trying to do?? Advice and pointers are welcome. Cheers Cyrille

2 2

EVENT HANDLING PROBLEM EXPLAINED
by prabuddha ray 04 Mar '05

04 Mar '05

jonathan sir , thanks for that detailed solution. but i guess my problem was simpler. i cudnt explain it properly . below is the code for the html page generated by C_login.asp . I've to rebuilt this page in zope and as u'll see i've alraedy the javascript functionality that u've mentioned in 3rd soln. but the javascript is not at all being executed in zope. it will obviously give error asa u select some district coz the original asp is not there. Ne We this is wat i wanted : as soon as i select a district the the corresponding user list in next combobox sud appear.the data are being fetched from Mysql using the ZSQL queries. AND CAN WE ANYWAY USE JAVASCRIPT IN DTML DOCUMENTS. please tell me the soln in ZOPE. CODE c_login.asp.html " <link REL="stylesheet" TYPE="text/css" HREF="_Themes/expeditn/THEME.CSS" VI6.0THEME="Expedition"> <link REL="stylesheet" TYPE="text/css" HREF="_Themes/expeditn/GRAPH0.CSS" VI6.0THEME="Expedition"> <link REL="stylesheet" TYPE="text/css" HREF="_Themes/expeditn/COLOR0.CSS" VI6.0THEME="Expedition"> <link REL="stylesheet" TYPE="text/css" HREF="_Themes/expeditn/CUSTOM.CSS" VI6.0THEME="Expedition"></head> <body bgColor=darkseagreen bottomMargin=0 topMargin=0><font face=Arial color=darkblue ><strong> <center><strong><font color=white face=tahoma ><font face=Arial><strong><font color=firebrick>Government of India<br></font><font color=gold><font color=black>Ministry of Communication & Information Technology</font> <br></font> <font color=darkgreen>Department of Information Technology<br></font></strong></font></font></strong></center> <center><strong><font face=tahoma color=black >National Informatics Center</font></strong></center> <center><strong><font face=tahoma color=royalblue>JHARKAND STATE UNIT</font></strong></center> <center><strong><font color=black >JHARKAND</font></strong></center> </strong></font> <hr style="COLOR: black"></body></html> <html> <head> <meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> </head> <body bgColor=LightSteelBlue onload="foc()"> <script language="javascript"> function sub_click(){ document.nlogin.login.value='y' document.nlogin.action='c_nlogged.asp' document.nlogin.method='post' document.nlogin.submit() } function res(){ document.nlogin.districtname.selectedIndex=0 document.nlogin.username.selectedIndex=0 document.nlogin.password1.value='' document.nlogin.districtname.focus() } function foc(){ if (document.nlogin.invalid.value==1){ document.nlogin.districtname.focus() return false } if (document.nlogin.user11.value=='y'){ document.nlogin.username.focus() return false } document.nlogin.districtname.focus() } function user10(){ document.nlogin.user11.value='y' document.nlogin.action='c_login.asp' document.nlogin.method='post' document.nlogin.submit() } </script> <form name="nlogin" method="post" action="c_nlogged.asp"> <input name=invalid type=hidden value=""> <input name=login type=hidden value="y"> <input name=user11 type=hidden> <center> <center><font face=arial color=darkred size=5><b>System Management Group</font> <br><br><br> <center><font face=arial color=darkblue size=4>Logon Screen for NIC Officers - <font color=red>Consumables(Tech)</font><br><br></font> <table border=1 cellspacing=1 bordercolor="darkblue" cellpadding=4 align=center> <tr> <td align=left> <font face=arial color=darkgreen size=3><b>District Name   </font></td></font> <td align=left> <select name=districtname style="HEIGHT: 22px; WIDTH: 185px" onchange="user10()"> <option value="" selected> <option value="01">Bokaro <option value="02">Chatra <option value="03">Deoghar <option value="04">Dhanbad <option value="05">Dumka <option value="06">East Singhbhum <option value="07">Garwah <option value="08">Giridih <option value="09">Godda <option value="10">Gumla <option value="11">Jamtara <option value="99">JHARKAND <option value="12">Koderma <option value="13">Latehar <option value="14">Lohardagga <option value="15">Pakur <option value="16">Palamu <option value="18">Ranchi <option value="19">Sahibganj <option value="20">Seraikela <option value="21">Simdega <option value="22">West Singhbhum </select> </td> </tr> <tr> <td align=left> <font face=arial color=darkgreen size=3><strong>User Name   </font></td></font> <td align=left> <select name=username style="HEIGHT: 22px; WIDTH: 185px"> <option value="" selected> </select> </td> </tr> <tr> <td align=left> <font face=arial color=darkgreen size=3><strong> Password    </font></td> <td align=left> <input name=password1 style="HEIGHT: 22px; WIDTH: 185px" type=password > </td> </tr> </table> <p align=center>          <input title="Click to Go" name=subm type=button value=Go style="color:blue" onclick="sub_click()">   <input title="Click to Reset" name=reset1 type=button value=Reset style="color:red" onclick="res()"> <br><br><center><a href=stores.asp title="Back to Main Menu"><font size=5 face=tahoma color=blue><b>Back</b></font></a> </p> </form> </b> </body> </html> " On Tue, 01 Mar 2005 Jonathan Hobbs wrote : >Just to make sure I understand what you are trying to >achieve... >you want >the user to enter some selection criteria, then based on what >the >user >enters you display a second set of selection criteria, which >the >user then >chooses from. You then take combine the user's two choices to >create a >mysql query or update command. > >If this is what you want, then I can think of three possible >solutions (and >I am sure there are more): > >Solution #1 > >- create an html form which presents the first set of selection >options. >Have the form action send the results to a dtml method/python >script >- create a dtml method/python script which parses the users >first >selection >and creates a new form with the second set of selection >criteria. >Include >within the html form a set of 'hidden' form field elements >which >contain the >user's first set of selection criteria. Have this form send >the >results to >a second dtml method/python script >- create a second dtml method/python script which parses the >second >selection form and grabs both the user-entered selection >criteria >(the >second set of selection criteria) and also grabs the 'hidden' >form field >elements which contain the user's selections from the first >form > > >Solution #2 > >- create an html form with hidden 'div's that you can display >based on the >user's first choice from the selection criteria. This will >only >work if: >(i) there is a limited number of options for the second set of >selection >criteria, and (ii) the second set of selection criteria is >'static' > > >Solution #3 > >- create an html form that has a javascript function that gets >invoked when >the user makes a choice from the selection criteria. This >javascript >function takes the user's selection and creates a url with the >user's >selection as parameters. The javascript function then uses the >url to load >a dtml method/python script into a hidden iframe in the >original >html form. >The dtml method/python script receives the parameters (passed >thru the url), >processes them to determine the contents of the second set of >selection >criteria, then creates javascript variables containing the >information for >the second set of selection criteria. These javascript >variables >are then >loaded into the hidden iframe and become accessible to the >original >javascript function which can then create and display the >second >set of >selection criteria. > >This solution is a bit more difficult to implement, but if you >don't want to >reload the page while the user is looking it should do the >trick! > >hth > >Jonathan > > From: "prabuddha ray" <buddha_2001(a)rediffmail.com> > > I'm using mysql database in my zope 2.7. > > While creating a page i needed to get data in one combobox >after > > selecting data from another combobox. for this i need to do >"page > > reload " using something like onChange() of javascript. >Javascript > > won do DTML being a server side lang. I > > How do handle such events in zope in dtml. > > plz give a solution.

1 0