November 2000 - Zope

RE: [Zope] Your thoughts about Zope-based database apps
by Eric Walstad 07 Nov '00

07 Nov '00

Hi Alonso, FYI, some of the list members have great difficulty in reading HTML formatted messages. It's best if you set your format to "Plain Text" before submitting to the list. I haven't yet implemented what you are considering, but I am interested in doing so soon. So, I am very interested in what you discover. If you don't mind, if/when you receive any emails that don't get CC'd to the Zope mailing list, please forward them on to me, too. I am an Access programmer and have a bit of experience with MySQL. I've given a lot of thought about how one would handle an Access-like interface with Zope and MySQL over the web. I'm anticipating a lot more development time building the interface, but saving a bunch of time by not having to keep multiple copies of the same DB up to date. If you feel like brainstorming on the "whats" and "hows" of such an application, I'ld love to join in. Thanks, Eric. 2. In particular, what would be the best way to implement the inserting and updating of records along with input data validation? (Retrieving data from a database to show on a web page using Zope is straightforward as you know.) I have a set of java script functions that I use for form field validation. I like this approach because it puts the burden on the client. However, there are Zope products available that handle it on the server side. Search Zope.org for "Smarter Forms" 3. In several cases I'd like to implement a main form/subform, where the subform allows the user to enter several items related to only one record in the main form. Since every item might have many fields (say 20) I'd like to present just the most important fields on a table, and allow the user to view/enter/update all the fields for each item in a different web page. Those of you familiar with Microsoft Access know that in Access it is straightforward to implement this main form/subform interface. I wonder what would be the best way of implementing this using Zope? Using Zope to mimic a form / subform combination means that Zope will have to generate a the input form and subform elements together before they get sent to the user. The user will then update the data sent by Zope. When the form is submitted, Zope will have to update the main form data, then iterate thru the subform elements, modifying the subform data with each iteration. If records are to be added, it will require a client server transaction for each record added (unless something is done with javascript, where the form is generated dynamically. Then, the user could add many records and when the dynamically built form is submitted, Zope will have to figure out how many records the user added). 4. Do you know of any existing Zope-based app similar to this?. Obviously, the back-end doesn't have to be MySQL. I haven't seen any yet, but I'm sure they're out there!

1 0

RE: [Zope] images in directories
by Pete Prodoehl 07 Nov '00

07 Nov '00

I was sort of hoping it would be easier. It would be ideal to have this: <dtml-with images><dtml-var image.gif></dtml-with> boiled down to one simple tag that works when I store images in a subfolder *and* use file extensions. But from what I've read so far, it can't be done... Someone suggested the following: <dtml-var "images.getitem('image.gif',1)"> but that didn't work for some reason, and still seems a little complex for just inserting an image. Pete > ---------- > Subject: Re: [Zope] images in directories > > hi, > > Sure they are. If you ftp a jpg to the server it comes up with an id of > bla.jpg, you can then refrence it in html just like you would on an Apache > server or whaterver <img src="../../bla.jpg"> > >

2 1

uploading to Zope with Mac Browser
by rlanham＠speakeasy.net 07 Nov '00

07 Nov '00

Zope list: This zope method for uploading images to server: <dtml-call expr="manage_addImage( id=title, file=file, title=title)"> ...works great from a PC. But from a Mac (netscape And IE) it does not work. Sometime a file is uploaded, but it is garbage. Apparently the Mac browsers have a totally different way of packaging data from an <input type=file> element. Does anyone on this list know how to deal with this? Is there a Zope product? Thanks in advance for any help with this fundamental problem using Zope. Richard

1 0

RE: [Zope] Cookies & Expiration
by Eric Walstad 07 Nov '00

07 Nov '00

Oops, forgot to send this one to the list... -----Original Message----- From: Eric Walstad [mailto:Eric@Walstads.net] Sent: Friday, November 03, 2000 3:40 PM To: Steve Drees Subject: RE: [Zope] Cookies & Expiration <Newbie_Alert> Hi Steve, Your solution is very cool! I'm going to use it in the following form... (maybe a bit more flexible?, change the default days to suit your needs) ID: expireInNDays Parameter List: self, days=1.0 _____________BODY__________ t = self.ZopeTime() + days # user defined duration t = t.toZone('GMT') return t.strftime("%A, %d-%b-%Y %H:%M:%S GMT") ___________________________ On the page you want to set the cookie put: <dtml-call "RESPONSE.setCookie('cookiename','cookievalue', path='/', expires=expireInNDays(this(), 7.0))"> or, to use the default of 1 day: <dtml-call "RESPONSE.setCookie('cookiename','cookievalue', path='/', expires=expireInNDays())"> Thanks -Eric. </Newbie_Alert> // -----Original Message----- // From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Steve // Drees // Sent: Friday, November 03, 2000 2:02 PM // To: Kit O'Connell; zope(a)zope.org // Subject: RE: [Zope] Cookies & Expiration // // // > However, I'd like to have this cookie set to expire one week // from the date // > of the current visit. i.e., if its 12:30 on 11/3 when a surfer // visits my // > site, I want Zope to set their lastVisited cookie to expire on 12:30 on // > 11/10. // // Have a pythonmethod // // ID expireIn1Week // Parameter List self // _____________BODY__________ // t = self.ZopeTime() + 7.0 # 1 week in the future // t = t.toZone('GMT') // // return t.strftime("%A, %d-%b-%Y %H:%M:%S GMT") // ___________________________ // // // On the page you want to set the cookie put // <dtml-call "RESPONSE.setCookie('cookiename','cookievalue', path='/', // expires=expireIn1Week())"> // // // // // _______________________________________________ // 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

Re: [Zope] catalog DTML Document
by Dieter Maurer 07 Nov '00

07 Nov '00

Wolfgang Strobl writes: > "Finding"a bunch of DTML Documents into a Zcatalog is easy. > But how to do that programmatically? I haven't even found a way > of doing that for a single DMTL Document. You call the catalog with your search terms as keyword paramters: <dtml-in "catalog(principia_search_source='cool and new')"> .... </dtml-in> Have a look at the two ZCatalog tutorials on zope.org. Dieter

4 3

Folderish object -API
by Petr Knapek 07 Nov '00

07 Nov '00

Hi Zopists, I try to create ISNGFolder class which is subclassed from Zope Folder class. During instantiation of this ISNGFolder class I also try to set permissions ['View', 'Access contents information'] for role 'Content' by calling manage_role('Content', ['View', 'Access contents information']) function of this object. But some error occurs and I don't know python API very well for folderish objects. Can somebody help me, please?? I use Zope 2.1.6 on Linux Debian Below you can see part of my python product for folderish object and error output of Zope. Begin of code: manage_addISNGFolderForm=HTMLFile('addFolder', globals()) def manage_addISNGFolder(self, cz_id, title='', key_words=[], header='', footer='', createPublic=0, createUserF=0, REQUEST=None): """Add a new 'ISNG Folder' object with id *id*.""" author = repr(REQUEST.AUTHENTICATED_USER) id = cz_id2id(cz_id) ob=ISNGFolder() ob.id = id ob.cz_id = cz_id ob.title = title ob.creation = DateTime.DateTime(time.time()) ob.author = author ob.modifier = author ob.key_words = key_words ob.header = header ob.footer = footer self._setObject(id, ob) ob.manage_role('Content', ['Access contents information', 'View']) if REQUEST is not None: return MessageDialog( title = 'Add ISNGFolder', message = 'New ISNGFolder %s was added.' % ob.getProperty('cz_id'), action = './addFolder' ) class ISNGFolder(Folder): """ISNGFolder class. Is created by inheritance from Folder Zope object.""" meta_type = 'ISNG Folder' __ac_permissions__ = ( ('View', ('manage_infoISNGForm',)), ) _properties = ( {'id':'title', 'type':'string', 'mode':'w'}, {'id':'cz_id', 'type':'string', 'mode':'w'}, {'id':'author', 'type':'string', 'mode':'w'}, {'id':'modifier', 'type':'string', 'mode':'w'}, {'id':'key_words', 'type':'lines', 'mode':'w'}, {'id':'header', 'type':'text', 'mode':'w'}, {'id':'footer', 'type':'text', 'mode':'w'} ) _ManageOptions = ( {'label':'Edit ISNG', 'action':'manage_editISNGForm'}, {'label':'Info ISNG', 'action':'manage_infoISNGForm'}, {'label':'Header ISNG', 'action':'manage_editHeaderISNGForm'}, {'label':'Footer ISNG', 'action':'manage_editFooterISNGForm'}, {'label':'Permissions ISNG', 'action':'manage_permissionsFrameISNGForm'}, ) Error output of Zope: Zope Error Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: aq_acquire Troubleshooting Suggestions The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Traceback (innermost last): File /usr/local/www/Zope-2.1.6/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/www/Zope-2.1.6/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/www/Zope-2.1.6/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook File /usr/local/www/Zope-2.1.6/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/www/Zope-2.1.6/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addISNGFolder) File /usr/local/www/Zope-2.1.6/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_addISNGFolder) File /usr/local/www/Zope-2.1.6/lib/python/Products/ISNG/ISNG.py, line 810, in manage_addISNGFolder File /usr/local/www/Zope-2.1.6/lib/python/AccessControl/Role.py, line 179, in manage_role (Object: ElementWithAttributes) File /usr/local/www/Zope-2.1.6/lib/python/AccessControl/Role.py, line 137, in ac_inherited_permissions (Object: ElementWithAttributes) File /usr/local/www/Zope-2.1.6/lib/python/OFS/ObjectManager.py, line 173, in _subobject_permissions (Object: ElementWithAttributes) AttributeError: (see above) -- Petr Knápek NEXTRA Czech Republic, s.r.o., Hlinky 114, 603 00 Brno, Czech Republic e-mail: mailto:petr.knapek@nextra.cz tel:+420-5-43 554 150 FAX:+420-5-43 554 214 "Perl is worse than Python because people wanted it worse." Larry Wall, 14 Oct 1998

3 2

Cloning a ZClass-Instance
by brocken22＠gmx.de 07 Nov '00

07 Nov '00

Hallo, 'news'is a zclass and when I'm using a hardcoded value for x it's working. that's the cloning-method: ------------------------------ <dtml-in "objectValues(['news'])"> <dtml-let x=sequence-item> <dtml-if "now.isCurrentDay()"> <dtml- call "manage_clone(_.getitem('x',0),'firstclone', [REQUEST])"> Copied! <dtml-else> Not needed to clone!! </dtml-if> </dtml-let> </dtml-in> ------------------------------ And the traceback: --------------- The object one does not support this operation --------------- Thanks for your help! -- Sent through GMX FreeMail - http://www.gmx.net

1 0

ISPs that host zope
by Keith Alperin 07 Nov '00

07 Nov '00

Greetings. I am a complete zope newbie but am enthralled by the technology. I am about to begin working on a personal web project and would like to build it in/with zope. Can anyone recommend a good ISP that will: -host and support zope -give me access to an RDBMS (MySQL or any other system would more than suffice) -give me a reasonable amount of space (>50MB) -not break my budget (<$30.00 per month.) Does such an animal exist? Please let me know what your experiences are with zope-friendly ISPs regardless of whether they meet my aforementioned criteria. Thank you so much. Keith R. Alperin Sr. Web Developer Ignite Sports Media kalperin(a)ignitemedia.com <mailto:kalperin@ignitemedia.com>

2 1

RE: [Zope] Asked a million times already... Im sure
by Max Møller Rasmussen 07 Nov '00

07 Nov '00

From: Chris Trowbridge [mailto:cctrow@hotmail.com] >I know that many people have probobly already asked this, but how would I do the >equivilant of a server side include? >It seems obvious enough from examples that it is merely... > <dtml-var filename> >but I always end up with either blank content or '[]' If you want to include it from a file on the computer and not an object in Zope then you should probably use the FileSystem product to make it visible to your file. If the file you want to include is in Zope allready the you should make shure that the incl_file is in your out_files' aquisition path. ie. directly beside you document or in a stright line between your document and the root. Or you should adress it directly. / folder1 incl_file output_dtml folder2 folder3 Here output_dtml can se and "include" incl_file / folder1 incl_file folder2 output_dtml folder3 Here it cannot. Except if you adress it like: <dtml-var "folder1.incl_file"> (Think of it as ../folder1/incl_file) Regards Max

1 0

ZSybaseDA not working
by Manuel Amador (Rudd-O) 07 Nov '00

07 Nov '00

Hi to everyone, especially the experts =) The reason for this email is an urgent need for a Sybase ASE database to work properly. Here's the deal. It worked like a charm on windows with ODBC. But now I moved to Linux, compiled ZSybaseDA and installed it. It works for selects and updates, etcetera, both in the test tab and in ZSQL methods. BUT when I try to call a stored procedure, well, lemme paste the traceback. A traceback is worth a million explanations: --------- traceback ---------------------------------------- Zope Error Zope has encountered an error while publishing this resource. Error Type: Error Error Value: Error processing exec sp_gn_regionales '0990006792001' , null , NULL Stored procedure 'sp_gn_regionales' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). Troubleshooting Suggestions The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Cambiada el: 2000/10/30 16:03:22.4513 GMT-5 Website copyright grupo SUPÁN. Diseñado por Manuel Amador (Rudd-O), OpenCorp S.A. Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: index_html) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: index_html) File /usr/local/zope/lib/python/OFS/DTMLDocument.py, line 177, in __call__ (Object: index_html) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: index_html) File /usr/local/zope/lib/python/OFS/DTMLMethod.py, line 168, in __call__ (Object: form) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: form) File /usr/local/zope/lib/python/OFS/DTMLMethod.py, line 168, in __call__ (Object: dw_gn_regionales) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: dw_gn_regionales) File /usr/local/zope/lib/python/DocumentTemplate/DT_In.py, line 633, in renderwob (Object: sp_gn_regionales(cod_empresa=REQUEST.cod_empresa,cod_regional='')) File /usr/local/zope/lib/python/DocumentTemplate/DT_Util.py, line 337, in eval (Object: sp_gn_regionales(cod_empresa=REQUEST.cod_empresa,cod_regional='')) (Info: REQUEST) File <string>, line 0, in ? File /usr/local/zope/lib/python/Shared/DC/ZRDB/DA.py, line 453, in __call__ (Object: sp_gn_regionales) File /usr/local/zope/lib/python/Products/SybaseDAv2/db.py, line 299, in query File /usr/local/zope/lib/python/Products/SybaseDAv2/db.py, line 333, in _error Error: (see above) --------- end traceback -------------------------------------- I'm baffled. I just got too accustomed to Zope so that we committed to the development of reports on the Web instead of with PowerBuilder. If this doesn't work, I will have to sustain several hours of psychological punishment, and I will have to dump Zope in favor of a better solution. These kinds of things make Zope not suitable for enterprise applications, where you can't rely on poorly documented things like ZSybaseDA. I'm even angry at liking Zope now. For the record, I'm using Sybase ASE 11.9.2 with the latest OpenClient RPM from Sybase.com. As you can see, this is a ZSybaseDA problem since everything but the stored procedures return data or alter/update it. I need an answer soon. OR, at least a hint of where could I tap information sources to DigitalCreations directly for commercial support, regarding Sybase support for our needs. I read about the agreement between Sybase and Digital Creations. But I can't find any information regarding Zope support in either Digital Creations' or Sybase's web sites. And I have exactly one week. Any suggestions, fixes, patches, OR alternatives are welcome. Many thanks. PD: Can I authenticate using GUF against the Sybase database security system? If so, how? -- Manuel Amador (Rudd-O)

1 0