- Zope - Zope lists

Survey data to SQL - a trouble...
by Alexander Chelnokov 02 Nov '00

02 Nov '00

Hello All, Problem: In a multiform survey values have to be saved into SQL DB after last form is finished. So data have to be passed from a form to next forms. Except this, each form must "know" which survey it belongs to (SID is an unique survey ID) and a reference ID of the next form. If it is last form, the reference is empty. Solution: values of fields of previous forms and service data (SID and a next form ID) are saved to <INPUT TYPE="HIDDEN">. When the last form is completed, from REQUEST.form.items() we need to extract only data fileds, without SIDs and IDs of forms. It is done by filter.py: ========================== def filterList (list): fl = list res = [] for el in fl: if el[0] not in ['sid','form','submit','nform']: res.append(el) return res ========================== The Python method is called from this DTML-method: ========================== <dtml-let fl="filterList(REQUEST.form.items())"> <dtml-call "storeResultsSQL(table_name=id, fields=fl, sid=REQUEST['sid'])"> </dtml-let> ========================== This seems to work. Then this SQL-Method has to save data: ========================== Arguments: table-name, fields, sid UPDATE <dtml-var table_name> SET <dtml-in fields> <dtml-var sequence-key>=<dtml-sqlvar sequence-item type=nb> <dtml-unless sequence-last>, </dtml-unless> </dtml-in> ========================== And after this piece of code an error appears: Error Type: TypeError Error Value: getattr, argument 2: expected string, int found Traceback: File D:\TESTSITE\lib\python\DocumentTemplate\DT_Let.py, line 147, in render (Object: fl="filterList(REQUEST.form.items())") File D:\TESTSITE\lib\python\DocumentTemplate\DT_Util.py, line 337, in eval (Object: storeResultsSQL(table_name=id, fields=fl, sid=REQUEST['sid'])) (Info: fl) File <string>, line 0, in ? File D:\TESTSITE\lib\python\Shared\DC\ZRDB\DA.py, line 443, in __call__ (Object: storeResultsSQL) File D:\TESTSITE\lib\python\DocumentTemplate\DT_String.py, line 528, in __call__ (Object: <string>) File D:\TESTSITE\lib\python\DocumentTemplate\DT_In.py, line 691, in renderwob (Object: fields) File D:\TESTSITE\lib\python\DocumentTemplate\DT_InSV.py, line 395, in __getitem__ File D:\TESTSITE\lib\python\DocumentTemplate\DT_InSV.py, line 194, in last File D:\TESTSITE\lib\python\DocumentTemplate\DT_InSV.py, line 182, in value [...] Any suggestions? THX in advance. -- Best regards, Alexander N. Chelnokov Ural Scientific Institute of Traumatology and Orthopaedics 7, Bankovsky str. Ekaterinburg 620014 Russia ICQ: 25640913

1 0

Re: [Zope] [alpha] Allaire Homesite integration with Zope
by complaw＠hal-pc.org 02 Nov '00

02 Nov '00

> Are you a Homesite 4.5.1 user that wants an integrated Zope editing > environment? While all of this is great if you've paid $$$ for both Windows and Home Site, this doesn't help out the majority of Zope users who don't have either. How about modifying an existing open source editor that is cross platform and use that? At least that way, Allaire wouldn't be able to do something against you because Zope competes with Cold Fusion. Don't get me wrong, I thing that having a separate DTML editor (that also understands HTML) is a very good thing. I want that myself. I just think that you are opening yourself up to a lot of heartache because it is all too easy for Allaire (who owns both Home Site and Cold Fusion) to destroy the project. I would love to have the capability you espouse, but I'm not Sysiphus. I would rather devote my time and effort into something that I know couldn't be taken away from me. Just my $0.02. Ron ./.

1 0

Zope + Java & java Beans ??
by Dario Lopez-K�sten 02 Nov '00

02 Nov '00

Hello! <newbie alert> Can I use Java with Zope? Can I call Java methods, beans from Zope/Python? </newbie alert> Many thanks, /dario - -------------------------------------------------------------------- Dario Lopez-Kästen Systems Developer Chalmers Univ. of Technology dario(a)ita.chalmers.se ICQ will yield no hits IT Systems & Services

1 0

ZSql Strange Error
by Cesar A. K. Grossmann 02 Nov '00

02 Nov '00

Hi! I'm trying to emulate an outter join in a Z SQL, but Zope crashes every time I try the query. The query is defined as: -*-*- parameters: username query definition: select codigo, nome, 'T' as select from cad_exportacao where codigo in ( select codigo from user_codigo where username = <dtml-sqlvar username type=string> and tipo = 'E' ) union all select codigo, nome, 'F' as select from cad_exportacao where codigo not in ( select codigo from user_codigo where username = <dtml-sqlvar username type=string> and tipo = 'E' ) -*-*- The log messages says there's not a 'cad_exportacao' relation (that is not true, the relation exists). Zope 2.2, Linux 2.2, PostgreSQL 7.0, ZyGreSQLDA 0.03 (from the README). What is wrong? What I can do to get the job done (I need to fill an multiselect with 'codigo', 'nome' from 'cad_exportacao', and if exists any 'codigo' for 'username' in 'user_codigo', the option must be selected - I tryed the "Filling MULTIPLE SELECT ... HOWTO', but it doesn't works for me, and I don't know why)? TIA -- César A. K. Grossmann http://members.xoom.com/ckant/

1 0

[alpha] Allaire Homesite integration with Zope
by Ben Schochet 02 Nov '00

02 Nov '00

Are you a Homesite 4.5.1 user that wants an integrated Zope editing environment? Please try out my very preliminary attempt at integrating these two great products http://www.zope.org/Members/bens/homesite_editor_for_zope. This is a very early attempt at making a full-fledged dtml editor. This will allow you to edit Zope files through FTP with dtml color highlighting, dtml validation, dtml wizards, attribute inspectors and more. I think you will find that even in this early stage this will help your Zope productivity. I have a huge list of To-Do items for these extensions that will make Homesite as good an editor for Zope as it is for Cold Fusion. Need for easy Zope editor While the ability to edit dtml document through the web is great, I have found the lack of ability to create dtml files in my favorite html editor disappointing. Homesite is the undisputed editor of choice for most client side web developers (on windows). It has great support for html, css, js, and a bunch of flavors of xml. I started this project enthusiastically with the goal of making dtml a first class citizen on Homesite. Community project: Because of the demands on my time and the large list of features that need to be added to this project I�m hoping for a lot of help from the community. As a user I want this project complete as soon as possible. Which is why I am releasing this less than half finished project very prematurely so we can all spin some Open Source magic together. Please send me your thoughts at bens(a)killersite.com. Everyone can contribute: This project needs help with graphic design, html production, JavaScript and css, and of course Zope programming. Also putting together documentation and help screens from the vast body of Zope literature. I have big plans for this and could use all the help you can give. Benefit to the Zope community: A better Zope development environment might draw the �Site Builders� of the world to Zope. Currently most are creating sites with inferior technologies like Cold Fusion and ASP because of their good developer tools and familiarity of the development interface. I think the majority of web developers are afraid of seemingly complicated technologies like Zope. Our effort could create the tool that allows people with limited development experience to give Zope a try. Please try it out and send me feedback, comments, and suggestions. Thanks. -Ben Schochet. http://www.zope.org/Members/bens/homesite_editor_for_zope  ___________________________________________________________________________ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot.

1 0

Zope and Python 2.0
by Xavier Defrang 02 Nov '00

02 Nov '00

Hi folks, I've just downloaded Zope source code to rebuild it on a FreeBSD-4.1 box. Is Zope-2.2.2 so tightly coupled to Python-1.5.2 that It doesn't run with Python 2.0... I've got a system-wide installation of Python 2.0 and the ./start scripts fails. I made a local installtion of Python 1.5.2 just to run Zope. I changed the path the Python interpreter in the start shell script but it looks like Medusa's asyncore.py can't find tjhe FCNTL module... What the hell is going wrong? I also had to comment out a nasty #include "mymath.h" in 'lib/Components/cPickle/cPickle.c' to get it built properly... - Xavier

3 2

RE: ÄZopeÅ Mapping tools and Zope - SIG? Fishbowl? Fishbowl?
by Petteri.Soikkonen＠tietoenator.com 02 Nov '00

02 Nov '00

I think Fishbowl process could be an good option, where it could be possible to review how existing Open Source tools could be used, and define the requirements for the product. Petteri > -----Original Message----- > From: twiens [mailto:twiens@compusmart.ab.ca] > Sent: Thursday, November 02, 2000 12:37 AM > To: Zope > Subject: ÄZopeÅ Mapping tools and Zope - SIG? Fishbowl? > > > I'm writing to all who responded to my query regarding > mapping tools for > Zope or others interested in this issue. In one of the responses, was > the suggestion to start a SIG or Fishbowl. > > At this point in time, I'm in a research phase for a project where a > mapping interface will be needed in Zope based web application. We are > starting to move into the design phase and so some technical decisions > will start to be made in the next two months at which point we will > begin building something. > > I've received a number of other interesting replies about GIS and Zope > and possible solutions. These have ranged from "I know about > this" to "I > use this" to "We should build something". I think there might be > sufficient interest in at least starting a SIG or Fishbowl or separate > list about the problem. Is there?? > > I'm personally a bit hesitant to even consider building yet > another GIS > product. There are many of them out their (see > www.freegis.org) for web > display, cartography, spatial analysis, etc. Obviously our > interest here > is web interfaces, but these other products are testimony to the > ubiquitous nature of the problem; a good suite of comprehensive GIS > software solutions just doesn't exist, either for free or commercially > (IMHO). The approach my team will likely take on our project > will be to > examine existing open source products and determine if there > is one that > is sufficient to meet our needs and simply use it. If we can > build some > tools around this product to facilitate it's future use with Zope by > others, we will open source those. > > I would welcome the discussion of this issue, since it is > important and > it is one of the up and coming needs for web applications. I would > welcome feedback from others who undoubtedly have significant > experience > and knowledge to bring to this problem. > > T > -- > Trevor Wiens > twiens(a)compusmart.ab.ca > > The significant problems that we face cannot be solved at the > same level > of thinking we were at when we created them. (Albert Einstein) > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) >

1 0

How small a box can zope run on?
by Alexander Limi 02 Nov '00

02 Nov '00

Hi, Just a quick question: We are building some device controller software and to control those we have a normal 486 with 24MB RAM running linux. Has anybody tried running zope on such a modest setup? There is only going to be one or two users connected to Zope at once, so we don't need much performance in terms of page views per second :) Cheers, Alexander.

6 7

Products : dependencies (or who's on first?)
by Aaron Straup Cope 02 Nov '00

02 Nov '00

Okay, here goes : I installed the PTK product some time ago, decided that it wasn't where I needed to be right now and moved on to something else. Today I finally decided to delete it from my Products folder. Shortly afterwards, I noticed that both my existing FlexFAQ and ZDiscussion objects were "broken" (with the little broken icons in the manager view.) and Zope was spewing errors to STDOUT complaining that it "Could not load oid" (I'm sorry, I don't have the traceback...doh!) I could add new FF/ZD objects but I couldn't access the old ones. I deleted ZDbase and ZDiscussion and restarted Zope. I couldn't import a fresh copy of ZDiscussions.zexp (see error below) but suddenly my old set up is working again. Except I can't create new ZD* objects since the Product isn't installed. ( I can create new FF objects.) In the meantime, when I restart Zope it prints errors about not being able to install the "Wizard" product or the "Demo Portal" Products (see below.) In the meantime, the "PTKDemo" and "PTKBase" Products keep showing up the Products table even though I keep trying to delete them. Can someone please help me understand what on earth is going on? Is the ZODB corrupted? Have I inadvertently set up some level of dependency across Products? I have done Google searches and seen that this has cropped up on the mailing list before, but I can't seem to figure out how to address the problem or insure that doesn't happen again. I am still pretty new to all of this and I am having a hard time understanding the relationship between alot of seemingly abritrary errors. Any help would be very much appreciated. Thanks....eep! a) Starting Zope 2000-11-01T20:01:04 ERROR(200) Zope Couldn't install Wizard Traceback (innermost last): File /usr/local/zope.old/lib/python/OFS/Application.py, line 477, in install_products (Object: ApplicationDefaultPermissions) (Info: Wizard) File /usr/local/zope.old/lib/python/App/Product.py, line 447, in initializeProduct (Object: Products.Wizard) File /usr/local/zope.old/lib/python/OFS/ObjectManager.py, line 264, in _setObject (Object: Traversable) File /usr/local/zope.old/lib/python/OFS/ObjectManager.py, line 272, in manage_afterAdd (Object: Traversable) File /usr/local/zope.old/lib/python/ZClasses/ZClass.py, line 421, in manage_afterAdd (Object: Wizard) File /usr/local/zope.old/lib/python/ZClasses/ZClass.py, line 375, in _register (Object: Wizard) Duplicate Class Ids b) Importing ZDiscussions.zexp Traceback (innermost last): File /usr/local/zope.old/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/zope.old/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope.old/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /usr/local/zope.old/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/zope.old/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_importObject) File /usr/local/zope.old/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_importObject) File /usr/local/zope.old/lib/python/OFS/ObjectManager.py, line 509, in manage_importObject (Object: Traversable) File /usr/local/zope.old/lib/python/OFS/ObjectManager.py, line 264, in _setObject (Object: Traversable) File /usr/local/zope.old/lib/python/OFS/ObjectManager.py, line 272, in manage_afterAdd (Object: Traversable) File /usr/local/zope.old/lib/python/ZClasses/ZClass.py, line 421, in manage_afterAdd (Object: ZDTopic) File /usr/local/zope.old/lib/python/ZClasses/ZClass.py, line 375, in _register (Object: ZDTopic) Duplicate Class Ids: (see above)

2 1

Mapping tools and Zope - SIG? Fishbowl?
by twiens 02 Nov '00

02 Nov '00

I'm writing to all who responded to my query regarding mapping tools for Zope or others interested in this issue. In one of the responses, was the suggestion to start a SIG or Fishbowl. At this point in time, I'm in a research phase for a project where a mapping interface will be needed in Zope based web application. We are starting to move into the design phase and so some technical decisions will start to be made in the next two months at which point we will begin building something. I've received a number of other interesting replies about GIS and Zope and possible solutions. These have ranged from "I know about this" to "I use this" to "We should build something". I think there might be sufficient interest in at least starting a SIG or Fishbowl or separate list about the problem. Is there?? I'm personally a bit hesitant to even consider building yet another GIS product. There are many of them out their (see www.freegis.org) for web display, cartography, spatial analysis, etc. Obviously our interest here is web interfaces, but these other products are testimony to the ubiquitous nature of the problem; a good suite of comprehensive GIS software solutions just doesn't exist, either for free or commercially (IMHO). The approach my team will likely take on our project will be to examine existing open source products and determine if there is one that is sufficient to meet our needs and simply use it. If we can build some tools around this product to facilitate it's future use with Zope by others, we will open source those. I would welcome the discussion of this issue, since it is important and it is one of the up and coming needs for web applications. I would welcome feedback from others who undoubtedly have significant experience and knowledge to bring to this problem. T -- Trevor Wiens twiens(a)compusmart.ab.ca The significant problems that we face cannot be solved at the same level of thinking we were at when we created them. (Albert Einstein)

2 1