August 2002 - Zope - Zope lists

CMFOptions with CMF 1.3?
by abg＠comco-inc.com 07 Aug '02

07 Aug '02

Has anyone gotten CMFOptions 1.2 running on CMF 1.3? Mine's throwing the following error: Traceback (most recent call last): File "C:\PROGRA~1\Zope\lib\python\OFS\Application.py", line 531, in import_product product=__import__(pname, global_dict, global_dict, silly) File "C:\PROGRA~1\Zope\lib\python\Products\CMFOptions\__init__.py", line 88, in ? import CMFExtImage,CMFExtFile,Blark File "C:\PROGRA~1\Zope\lib\python\Products\CMFOptions\Blark.py", line 29, in ? from Products.CMFCore.utils import modifyPermissionMappings ImportError: cannot import name modifyPermissionMappings Here's my config info: Zope Version: (Zope 2.5.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32) Python Version: 2.1.3 System Platform: win32 Thanks, Aaron Gillette abg(a)comco-inc.com

1 0

lists
by D. Rick Anderson 07 Aug '02

07 Aug '02

I have a group of checkboxes on a site that I want to parse into an email. I've been trying to use dtml-in to iterate through the checked boxes, but if they only check one box then it's not a list anymore and dtml-in barfs. Is the only solution to trap an error and render it as a var in the except? like this: <dtml-try> <dtml-in checkbox> <dtml-var sequence-item> </dtml-in> <dtml-except> <dtml-var checkbox> </dtml-try> or is there a more elegant way to do this? TIA Rick

2 2

RE: [Zope] ZDataQueryKit Thank You!
by Derek Basch 07 Aug '02

07 Aug '02

Jeff, Good Idea. I will post the issue resolution for posterity. Here goes, its a long one :) ------------------------------------------------------ > Hello, Hi there.. I'm not on the Zope list, but someone forwarded this for me. I am the author of ZDataQueryKit, let see if we can sort out what is going wrong here. > I posted the below question before but no one > answered. So I guess I > will now ask, does anyone have anyone have any > experience with > ZDataQueryKit? Can anyone give me a rundown of how to > use the Z > Report Tool? It looks like a great tool but I cant get > it to work > (see below). > Thanks for the help, > Derek Basch > > Hello, > I am trying to learn how to use ZDataQueryKit w/ > Firebird/Interbase and I keep getting a KeyError. I Hmm... never used Interbase, but if it has a straightforward Zope DA then it should work ok. > create a simple ZSQLMethod such as "SELECT * FROM > T_CONTACTS" and name it "testmethod". I then create a What do you get on the test page of the ZSQLMethod? > Z Report Tool with the id and title of "report" and a > Data Source of "testmethod". I press Add and Edit and > I get: > > Zope has encountered an error while publishing this > resource. > > Error Type: KeyError > Error Value: PK_CON_ID Hmmm... can you send me the complete column list for the table (Including data types if possible?) (Just a thought) > I thought it might have something to do with the > primary key column but I tried just selecting a non > key column and it still fails. Rather than mucking > around in code for hours, I thought I would ask if > anyone has an idea what im doing wrong? > Thanks in adavance, > Derek T Basch > If you look in the HTML source of the error page, you will find a Python traceback, could you send at least this to me please (The source for the whole page would probably be even better.) Finally, what versions of Zope, Python and ZDataQueryKit are you using? Adrian... ------------------------------------------------------ Adrian, Thank you for the reply! I am a twit sometimes. I should have emailed you first instead of cluttering up the zope list. I added a bug request to your plone site before I got your email so please disregard it :) Here goes.... ###Components 1) kinterbasDB DA v 1.3 2002/04/29 #It seems to be a "normal" DA as far as I know. I have only ever used this DA. I need to practice some ODBC DA stuff soon. ZSQLMethods functions test ok. I have been having fun with stored procedures and ZSQLMethods. 2) Zope Version (Zope 2.5.1 (binary release, python 2.1, win32-x86)) 3) Python Version 2.1.3 (#35, Apr 8 2002, 17:47:50) [MSC 32 bit (Intel)] 4) ZDataQueryKit 1.1.0 ###Traceback page source http://www.geocities.com/dbasch/report.htm #It looks to my newbie eye that it cant lay out the Document Template. I didnt even know that the tracebacks were in the source! So many things to learn in Zope! ####Database Metadata in Interbase Data Definition Langauge http://www.geocities.com/dbasch/contacts.txt Well, I think that is everything you asked for. Thanks again for helping a newbie, Derek Basch ------------------------------------------------------ Heh, I love the collector!!! I'll try to install interbase here, but I think I can see what has happened and I thought I had already fixed it. I'll look in CVS and see when I made the correction, or if this is a new bug. Hmm... I have just tried this with the most recent version against MySQL and there is no apparent problem. 1) Try re-creating the report object 2) Try creating a report object against a very simple query (select CON_FNAME, CON_LNAME from T_CONTACTS) and see what happens. 3) Try downloading http://cvs.haqa.co.uk/viewcvs/Products/ZDataQueryKit/ZDataQueryKit.tar.gz?ta rball=1 which is the latest version and re-create the report object (Again, sorry) If this still fails I have to see if I can get an Interbase installed and running here, but the licensing is kind of unusual, and I don't want to find I am in breach.... Adrian... ------------------------------------------------------ Woot! It works! (pause for happy dance). Looks like you fixed it with the latest CVS. I can now play with making the reports look nice with CSS. It looks like you were nice enough to automatically assign CSS classes of 'data' and 'heading' to the table cells. This should make layout alot easier. Time to learn how to use ZStyleSheets! I am trying to understand this sentance from 'Column Options': 'If you select just Total you get a grand total, if you select both Group and Total you get sub-totals as well.' I dont see anywhere to select 'Total'? I do see a 'Group' under 'Display/Formula'. What is the 'Subtotals Class' for? I also need to figure out how to make these tables printable. Any suggestions? Sorry for all the silly questions :). Thanks again, Derek Basch ------------------------------------------------------ > Woot! It works! (pause for happy dance). Looks like Woot???? > you fixed it with the latest CVS. I can now play with > making the reports look nice with CSS. It looks like > you were nice enough to automatically assign CSS > classes of 'data' and 'heading' to the table cells. > This should make layout alot easier. Time to learn how > to use ZStyleSheets! Heheh... I'll tell, you, almost like I planned it that way :) :) > I am trying to understand this sentance from 'Column > Options': > 'If you select just Total you get a grand total, if > you select both Group and Total you get sub-totals as > well.' > I dont see anywhere to select 'Total'? I do see a Hmm.. ok... lets take that sentance... throw it in the bin, and replace it with this one:- "The 'Display' options (Not available for calculated columns) allow you to choose how columns should be displayed (or hidden) and sub/grand -totalled. Grouping implies sorting (ascending). Grouping with summary hidden will display the group headline, but no sub/grand totals." > 'Group' under 'Display/Formula'. What is the > 'Subtotals Class' for? The CSS class for the group head/tail lines > I also need to figure out how to make these tables > printable. Any suggestions? Ah, now that is easy. In your standard_html_header put a test like this: <html><..................><body> <dtml-if "REQUEST.has_key('printable')"> All your page headings side-bars etc... </dtml-if> Then in standard_html_footer <dtml-if "REQUEST.has_key('printable')"> All your page headings side-bars etc... </dtml-if> > Sorry for all the silly questions :). > Thanks again, > Derek Basch No problem :) Adrian... ------------------------------------------------------ --- Jeff Sacksteder <jwsacksteder(a)ramprecision.com> wrote: > You're welcome. > > Why don't you post the resolution of your issue to > the list, so that it will > be archived and searchable for anyone else who might > have that problem in > the future? __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com

1 0

What can I do with a Results instance from a mysql query?
by Alec Munro 07 Aug '02

07 Aug '02

Hi all, Getting better at this Zope thing, but I still have problems. I want to retrieve data from a mysql database, store it in the session, and then return a page template that makes use of that data. This is all from within a python script. The problem I'm having is it doesn't like storing an entire results instance into the session. I don't want to create a dictionary and go through the fields one by one, but is there an equivalent of keys() for the Results object? Thanks very much, Alec Munro

2 2

oops
by Jacob Behm 07 Aug '02

07 Aug '02

Sorry about the double post. - jacob

1 0

cookie problem in IE
by Jacob Behm 07 Aug '02

07 Aug '02

Here's another issue I've been having. In my companies intranet, there are a lot of links to other resources outside of our system. I'd like to link to these resources in a frame (<iframe> actually). That way the user is still in my system and can access other resources. However, many of the external systems require login. The problem is this: In IE and only in IE, the cookie is not sent. If I set up the same page on an apache server I can log into a system and proceed as usual. But in Zserver and IE, I can log in but I'm immediately logged out when I try to do something and I get an expired cookie error. Has anyone else experienced this? Thanks, Jacob

1 0

cookie problem in IE
by Jacob Behm 07 Aug '02

07 Aug '02

Here's another issue I've been having. In my companies intranet, there are a lot of links to other resources outside of our system. I'd like to link to these resources in a frame (<iframe> actually). That way the user is still in my system and can access other resources. However, many of the external systems require login. The problem is this: In IE and only in IE, the cookie is not sent. If I set up the same page on an apache server I can log into a system and proceed as usual. But in Zserver and IE, I can log in but I'm immediately logged out when I try to do something and I get an expired cookie error. Has anyone else experienced this? Thanks, Jacob

1 0

python script returning DTMLMethod problem
by Tom Germaine 07 Aug '02

07 Aug '02

Hello All: My earlier question (form/script problem) regarding passing variables from a form to a python script was successfully solved with the suggestion by Malik Jablonski to include this in the script: request = container.REQUEST myfile=request.myfile fname=request.fname Thanks Malik. But I have a further issue in that I wish the python script to return a DTMLMethod that calls dtml-tree to display the contents of a folder. I cannot find any references to python scripts returning DTMLMethods or Documents and the suggestions following do not work, I think because of namespace problem. >>must pass the >> "positional" parameters. >> you coded: > >>>return context.avc.showFiles() > >should be something like this: > >return context.avc.showFiles(None,context.REQUEST) and >I've had some success with equivalents of >return context.avc.showFiles(context) >- then your DTML Method will have a context >and can find 'avc' in it. The form, script and DTMLMethod are all in the same folder object and 'avc' is the container object (folder) for that folder but the error I get is Error Type: KeyError Error Value: avc Even if I have a single line script calling this DTMLMethod (take the form out of the loop) I get the same error. Does acquistion work with python scripts? And can anyone offer a way for a python script to return DTML methods or documents? Even if the script: return context.showUploadRequests() calling a simple DTML method: <dtml-var standard_html_header> <dtml-var REQUEST> <dtml-var standard_html_footer> fails with error: Error Type: KeyError Error Value: standard_html_header Tom Germaine

4 5

Meta types icon (URGENT)
by Peter Bengtsson 07 Aug '02

07 Aug '02

From an object you can get its icon by doing print someobject.icon What if I only know a meta type (as string), say "DTML Method" and what I want is "/misc_/OFSP/dtmlmethod.gif" I looked at the filtered_meta_types() method but it does not provide this information. Cheers --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.380 / Virus Database: 213 - Release Date: 2002-07-24

2 1

Re: [Zope] Enquires
by Maik Jablonski 07 Aug '02

07 Aug '02

hi, keep the discussion on the list... maybe others will be interested too. The official supported Python for Zope is Python 2.1.3. Running Zope with Python 2.2 is not recommended for any production environment at all. As far as I know Zope 2.6 needs Python 2.1.3 too. cheers, maik WONG,KAI-WEE (Non-HP-Singapore,ex5) wrote: > Hi Maik, > > Is there anyway I can get a Zope installed with python 2.2 with it for > Windows??? > Only python2.2 can support >2GB files. > > May I know also whether 2.6.1 will support python2.2 for Windows?? > > Thank you. > > Cheers, > Wong Kai Wee > > -----Original Message----- > From: Maik Jablonski [mailto:maik.jablonski@uni-bielefeld.de] > Sent: Tuesday, July 30, 2002 5:45 PM > To: WONG,KAI-WEE (Non-HP-Singapore,ex5); zope(a)zope.org > Subject: Re: [Zope] Enquires > > > hi, > > keep the discussion on the list, so others could profit or contribute...;-) > > sorry, but I have no idea how to built python with large-file-support on > windows! the RPMs won't work because they are compiled for linux. > > -mj > > WONG,KAI-WEE (Non-HP-Singapore,ex5) wrote: > >>hi Maik, >> >>Will this work for Windows?? >>Am I supposed to recomplie Zope with the RPMs for python 2.1 ?? >> >>Sorry for asking so many questions. >>I am a newbie in Zope. >> >>Thank you. >> >>Cheers, >>Wong Kai Wee >> >>-----Original Message----- >>From: Maik Jablonski [mailto:maik.jablonski@uni-bielefeld.de] >>Sent: Tuesday, July 30, 2002 5:39 PM >>To: WONG,KAI-WEE (Non-HP-Singapore,ex5); zope(a)zope.org >>Subject: Re: [Zope] Enquires >> >> >>hi, >> >>the linux-binary-zope-distro does not have the large-file-support built >>in the python-interpreter [hit me if I'm wrong]. you should use the RPMs >>for python2.1 from python.org and a Zope-Source-Installation. This >>should work. >> >>greetings again, maik >> >>WONG,KAI-WEE (Non-HP-Singapore,ex5) wrote: >> >> >>>Hi Maik, >>> >>>Thanks for the reply and it is a pleasure to know you. >>>Actually, I am packing the ZODB every week. >>> >>>If I install Zope 2.5.1 in Linux, will it automatically install >>>the correct python-interpreter that support large file ?? >>> >>>Anyway, can I say that there is no way to solve this 2GB problem in >> >>Windows. >> >> >>>Please reply. >>>Thank you. >>> >>>Cheers, >>>Wong Kai Wee >>> >>> >>>-----Original Message----- >>>From: Maik Jablonski [mailto:maik.jablonski@uni-bielefeld.de] >>>Sent: Tuesday, July 30, 2002 5:24 PM >>>To: WONG,KAI-WEE (Non-HP-Singapore,ex5); zope(a)zope.org >>>Subject: Re: [Zope] Enquires >>> >>> >>>hi, >>> >>>you should pack your database first. Enter the "Control_Panel/Database" >>>and click on "Pack". This will remove old transactions/histories/undos >>>out of your ZODB. >>> >>>Linux supports more than 2GB ZODBs if you use a correct >>>[with-large-file-support] compiled python-interpreter. >>> >>>greetings, maik >>> >>>WONG,KAI-WEE (Non-HP-Singapore,ex5) wrote: >>> >>>>Hi, >>>> >>>>My name is Kai wee from Singapore. Currently, my company is using Zope >>>>installed in Win200 >>>>as a content mangement tools. >>>> >>>>However, the ZODB is growing and it is going to hit 2GB soon. >>>> >>>>Is there any alternative ways to counter this problem ?? >>>>If I move the Zope to Linux in Window2000, will it support ZODB more >>> >>them >> >> >>>>2GB ?? >>>> >>>>Please reply. >>>>Your help is greatly appreciated. >>>> >>>>Cheers, >>>>Wong Kai Wee >>> >> >> > > -- Maik Jablonski __o www.zfl.uni-bielefeld.de _ \<_ Deutsche Zope User Group Bielefeld, Germany (_)/(_) www.dzug.org

3 2