February 2007 - Zope

Re: Exporting portal member data to csv
by hpinson＠indepthl.com 28 Feb '07

28 Feb '07

I'm having the same problem. Zope 2.9.6 and Plone 2.5.2 Method is describe here: http://zopelabs.com/cookbook/1140753093 The line: password = user._getPassword() ...no longer works. I can remove that one line, and export to CSV works fine. Obtaining a username / password list is actually pretty important in our use case (patron users routinely forget both their username and password and don't like (hate) having their password reset). I miss being able to get the password info. I know it is not good security practive to allow this. I was told by a more knowlegable Plone developer that obtaining the passwords to csv is no longer possible for this security concern. I don't know if that is true or not. -- Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Phone: 505 994-2135 Fax: 505 994-3603

2 1

Re: [Zope] Re: Exporting portal member data to csv
by Win Myint Aung 28 Feb '07

28 Feb '07

Here is error log. Time2007/02/28 10:41:23.080 GMT+7 User Name (User Id)admin (admin) Request URLhttp://localhost:8080/export Exception TypeAttributeError Exception Valueportal_memberdata Traceback (innermost last): Module ZPublisher.Publish, line 115, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 41, in call_object Module Products.ExternalMethod.ExternalMethod, line 225, in __call__ __traceback_info__: ((<Application at >,), {}, None) Module C:\Program Files\Plone 2\Data\Extensions\export.py, line 15, in createcsv AttributeError: portal_memberdata ----- Original Message ---- From: Paul Williams <pwilliams(a)diamonddata.com> To: zope(a)zope.org Cc: zope-db(a)zope.org Sent: Tuesday, February 27, 2007 8:22:36 PM Subject: [Zope] Re: Exporting portal member data to csv What does your log say? Win Myint Aung wrote: > When i run the external method in plone site, it shows errors. > > The error shows. > > > > Site Error > > An error was encountered while publishing this resource. > > *Error Type: AttributeError* > *Error Value: portal_memberdata* > > > > The following is the codings used in external methon. > > # make heading row > row = makeRow() > row[0] = 'member_id' > row[1] = 'password' > writer.writerow(row) > > for member in self.portal_membership.listMembers(): > > # make row for each member full of blank values > row = makeRow() > member_id = member.getId() > user = acl_users.getUser(name=member_id) > password = user._getPassword() > row[0] = member_id > row[1] = password > writer.writerow(row) > > request.RESPONSE.setHeader('Content-Type','application/csv') > request.RESPONSE.setHeader('Content-Length',len(text.getvalue())) > > request.RESPONSE.setHeader('Content-Disposition','inline;filename=%smembers.csv' > % > > time.strftime("%Y%m%d-%H%M%S-",time.localtime())) > return text.getvalue() > > > > > ------------------------------------------------------------------------ > TV dinner still cooling? > Check out "Tonight's Picks" > <http://us.rd.yahoo.com/evt=49979/*http://tv.yahoo.com/> on Yahoo! TV. > > > ------------------------------------------------------------------------ > > _______________________________________________ > Zope-DB mailing list > Zope-DB(a)zope.org > http://mail.zope.org/mailman/listinfo/zope-db _______________________________________________ Zope maillist - Zope(a)zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ____________________________________________________________________________________ It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. http://tools.search.yahoo.com/toolbar/features/mail/

2 1

zope unresponsive
by Paul Williams 27 Feb '07

27 Feb '07

I have posted this several times, but have not until now been able to get DeadlockDebugger installed. I see several people have had this problem, but no-one has posted a solution. zope 2.9.5 + zeo pythonm2.4.3 Red Hat RHEL 4 Plone 2.5.1 Our zeo clients hang intermittently. We have no way of reproducing the problem, but it occurs daily. The client hangs and a restart seems to fix the problem. In the event log with tracing on we get Trace zeo.zrpc.Connection(C) wait(16697) {server:8100} pending, async=0 There are hundreds to thousands of these until the server is restarted. In the zeo log we get Error caught in asyncor asyncore.py error:(110,'Connection timed out') We have been trying to track this down and have had no luck. Does anyone have any suggestions? Below is our deadlock debugger output Threads traceback dump at 2007-02-23 15:26:50 Thread -1269564496 (GET /VirtualHostBase/https/soawds:443/VirtualHostRoot/Content///training): File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZServer/PubC ore/ZServerPublisher.py", line 23, in __init__ File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 395, in publish_module File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 196, in publish_module_standard File "/apps1/zope2.9.5/navo_instance/Products/PlacelessTranslationService/Pat chStringIO.py", line 34, in new_publish x = Publish.old_publish(request, module_name, after_list, debug) File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 115, in publish File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/m apply.py", line 88, in mapply File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 41, in call_object File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/Shared/DC/Sc ripts/Bindings.py", line 311, in __call__ File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/Shared/DC/Sc ripts/Bindings.py", line 348, in _bindAndExec File "/apps1/zope2.9.5/navo_instance/Products/CMFCore/FSPageTemplate.py", line 195, in _exec result = self.pt_render(extra_context=bound_names) File "/apps1/zope2.9.5/navo_instance/Products/CacheSetup/patch_cmf.py", line 38, in FSPT_pt_render result = FSPageTemplate.inheritedAttribute('pt_render')( File "/apps1/zope2.9.5/navo_instance/Products/CacheSetup/patch_cmf.py", line 92, in PT_pt_render tal=not source, strictinsert=0)() File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 238, in __call__ File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 281, in interpret File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 749, in do_useMacro File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 281, in interpret File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 457, in do_optTag_tal File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 442, in do_optTag File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 437, in no_tag File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 281, in interpret File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 749, in do_useMacro File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 281, in interpret File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/TAL/TALInter preter.py", line 507, in do_setLocal_tal File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/Products/Pag eTemplates/TALES.py", line 221, in evaluate File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/Products/Pag eTemplates/Expressions.py", line 185, in __call__ File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/Products/Pag eTemplates/Expressions.py", line 180, in _eval File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/Products/Pag eTemplates/Expressions.py", line 85, in render File "/apps1/zope2.9.5/navo_instance/Products/CMFPlone/browser/plone.py", line 66, in globalize self._initializeData(options=options) File "/apps1/zope2.9.5/navo_instance/Products/CMFPlone/browser/plone.py", line 147, in _initializeData self._data['language'] = self.request.get('language', None) or \ File "/apps1/zope2.9.5/navo_instance/Products/Archetypes/ClassGen.py", line 58, in generatedAccessor return schema[name].get(self, **kw) File "/apps1/zope2.9.5/navo_instance/Products/Archetypes/Field.py", line 802, in get value = ObjectField.get(self, instance, **kwargs) File "/apps1/zope2.9.5/navo_instance/Products/Archetypes/Field.py", line 671, in get return self.getStorage(instance).get(self.getName(), instance, **kwargs) File "/apps1/zope2.9.5/navo_instance/Products/Archetypes/Storage/__init__.py" , line 175, in get value = base._md[name] File "/var/tmp/python2.4-2.4.3-root/apps1/python/lib/python2.4/UserDict.py", line 17, in __getitem__ def __getitem__(self, key): return self.data[key] File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 732, in setstate File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 786, in _setstate File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 604, in setGhostState File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 597, in getState File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 471, in _persistent_load File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 537, in load_oid File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 201, in get File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/ClientSt orage.py", line 746, in load File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/ClientSt orage.py", line 760, in loadEx Thread -1290544208 (GET /VirtualHostBase/https/soawds:443/VirtualHostRoot/Content//nav): File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZServer/PubC ore/ZServerPublisher.py", line 23, in __init__ File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 395, in publish_module File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 196, in publish_module_standard File "/apps1/zope2.9.5/navo_instance/Products/PlacelessTranslationService/Pat chStringIO.py", line 34, in new_publish x = Publish.old_publish(request, module_name, after_list, debug) File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 106, in publish File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/B aseRequest.py", line 366, in traverse File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 732, in setstate File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 786, in _setstate File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 604, in setGhostState File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 597, in getState File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 471, in _persistent_load File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 537, in load_oid File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 201, in get File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/ClientSt orage.py", line 746, in load File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/ClientSt orage.py", line 760, in loadEx Thread -1246884944 (GET /VirtualHostBase/https/soawds:443/VirtualHostRoot/Content/carrier.jpg): File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZServer/PubC ore/ZServerPublisher.py", line 23, in __init__ File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 395, in publish_module File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 196, in publish_module_standard File "/apps1/zope2.9.5/navo_instance/Products/PlacelessTranslationService/Pat chStringIO.py", line 34, in new_publish x = Publish.old_publish(request, module_name, after_list, debug) File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 115, in publish File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/m apply.py", line 88, in mapply File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 41, in call_object File "/apps1/zope2.9.5/navo_instance/Products/ATContentTypes/content/base.py" , line 414, in index_html if data: File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 732, in setstate File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 786, in _setstate File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 604, in setGhostState File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 597, in getState File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 471, in _persistent_load File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 537, in load_oid File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 201, in get File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/ClientSt orage.py", line 746, in load File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/ClientSt orage.py", line 769, in loadEx File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/ServerSt ub.py", line 192, in loadEx File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/zrpc/con nection.py", line 531, in call File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/zrpc/con nection.py", line 638, in wait File "/var/tmp/python2.4-2.4.3-root/apps1/python/lib/python2.4/asyncore.py", line 122, in poll r, w, e = select.select(r, w, e, timeout) Thread -1280054352 (GET /VirtualHostBase/https/soawds:443/VirtualHostRoot/Content/): File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZServer/PubC ore/ZServerPublisher.py", line 23, in __init__ File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 395, in publish_module File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 196, in publish_module_standard File "/apps1/zope2.9.5/navo_instance/Products/PlacelessTranslationService/Pat chStringIO.py", line 34, in new_publish x = Publish.old_publish(request, module_name, after_list, debug) File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/P ublish.py", line 106, in publish File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZPublisher/B aseRequest.py", line 366, in traverse File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 732, in setstate File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 786, in _setstate File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 604, in setGhostState File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 597, in getState File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 471, in _persistent_load File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/seriali ze.py", line 537, in load_oid File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZODB/Connect ion.py", line 201, in get File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/ClientSt orage.py", line 746, in load File "/var/tmp/Zope-2.9.5-1-buildroot/apps1/zope2.9.5/lib/python/ZEO/ClientSt orage.py", line 760, in loadEx End of dump Thank you, Paul Williams

4 7

Re: [Zope3-Users] Cannot view the instances after I refresh the product in ZMI
by David Johnson 27 Feb '07

27 Feb '07

Paste the code here. :) On Feb 27, 2007, at 6:16 AM, Alex Cheng wrote: > Hello, > > I have modified my product code and click refresh in ZMI to update > the product. Unfortunately when I view its instance in zope. The > error message is follows: > > Error Type: TypeError > Error Value: 'NoneType' object is not callable > > Could you help me? > > Thanks. > -- > powered by python > _______________________________________________ > Zope3-users mailing list > Zope3-users(a)zope.org > http://mail.zope.org/mailman/listinfo/zope3-users

2 1

Exporting portal member data to csv
by Win Myint Aung 27 Feb '07

27 Feb '07

When i run the external method in plone site, it shows errors. The error shows. Site Error An error was encountered while publishing this resource. Error Type: AttributeError Error Value: portal_memberdata The following is the codings used in external methon. # make heading row row = makeRow() row[0] = 'member_id' row[1] = 'password' writer.writerow(row) for member in self.portal_membership.listMembers(): # make row for each member full of blank values row = makeRow() member_id = member.getId() user = acl_users.getUser(name=member_id) password = user._getPassword() row[0] = member_id row[1] = password writer.writerow(row) request.RESPONSE.setHeader('Content-Type','application/csv') request.RESPONSE.setHeader('Content-Length',len(text.getvalue())) request.RESPONSE.setHeader('Content-Disposition','inline;filename=%smembers.csv' % time.strftime("%Y%m%d-%H%M%S-",time.localtime())) return text.getvalue() ____________________________________________________________________________________ No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started. http://mobile.yahoo.com/mail

3 2

How to get REST friendly urls from sql database
by Gaute Amundsen 27 Feb '07

27 Feb '07

Hi. Normally a url to an article in our CMS system would look roughly like this: http://www.dom.tld/aritcles/25245 Where 25245 would be an object of some metatype, say 'article'. Now what if I wanted to get the data for that page from an sql server instead, I would expect to end up with a url like this: http://www.dom.tld/aritcles/index_html?id=25245 Now, having recently read the Roy Fielding paper, and expecting to do some caching, I would much prefer to have it the first way, even when I have to get the data out of a DB. Anybody have any ideas on how this might be done? Regards Gaute Amundsen

5 8

from php to zop
by Adrian-Bogdan Andreias 27 Feb '07

27 Feb '07

Hi Zopistas, I'm planning to migrate our company web development from PHP to Zope. The reason is to increase productivity by using a modern language, a powerful framework with out of the box functionality and take care of enterprise concerns (transactions, OO db, complex auth&auth system etc). There's obviously a learning curve. But the questions are if zope/python/plone will really increase productivity and if Zope is mature enough. I have a strong C++ and other OOP languages background, so using OOP is not an issue even of we're moving from PHP. I have some knowledge of UML and played a bit with Python a few years ago. After watching wetfeet.mov I was very impressed. But then tried to follow the tutorial my self, but got stuck with some error: E:\Program Files\ArchGenXML>ArchGenXML.py E:\projects\zope\tt2.xmi <...stack trace ... > File "E:\Program Files\ArchGenXML\XMIParser.py", line 697, in getAttributeValu e return el.firstChild.nodeValue AttributeError: 'NoneType' object has no attribute 'nodeValue' The big issue, besides the error itself, is that I wasn't able to fix the problem after 2-3 hours of googling and so. There's probably some stupid error in the UML model. I tried to see if there are extra spaces in tags (like "required ") or some extra association/tag that is not linked. But got stuck. I've redone the model from scracth, though this is not an option in real world development. This is not a Zope problem necessarily. But to be productive in Zope one needs good tools that work. Other issues that make me think Zope may not be that mature: - I've read the first 150 pages of The Zope Book by now, and found to much errors (grammatical and logical); some example are not actually working because they missed a letter or so; I have the list of errors if someone that works on the PDF is interested - funny comments in the book from other readers (this and that is not working etc.) - clearly ZMI can not be used for development, but rather for administrative tasks and quick dev fixes; can you post the list of tools you're using for Zope development (e.g. eclipse, argouml, software X for WebDav etc.) Some other questions about Zope: - Zope and Plone are clearly for Enterprise projects, but do you think they are suited as well for other smaller projects like: feeds aggregator web sites (like technorati.com, but not that complex), custom web directories (like DMOZ, but a bit more complex), other small projects - is there some migration guide, that also talks about tools that I've asked about above I found some very interested concepts in Zope architecture, like acquisition, I love the core architecture as far as I read. Zope has great potential for sure, but is it in a state that can offer productivity boost when compared with PHP? These were some random thoughts :). It would help me a lot with the decision of moving to Zope or not. Thanks and sorry for the "speling" -- Adi Andreias adi _at_ elvsoft (dot] com Elvsoft, Cluj-Napoca, Romania Online success http://www.elvsoft.com/ Tel/Fax: +40 0364 103 430 Mobile: +40 0723 450 566

1 0

Re: [Zope] How to export ZWiki contents in ZODB to MYSQL
by Win Myint Aung 27 Feb '07

27 Feb '07

Dear Tino, Thank you for your reply. Another big problem is I don't know how to start the python script. I would like to request any body to help me. Any draft script may be a good start for me. Thanks. ----- Original Message ---- From: Tino Wildenhain <tino(a)wildenhain.de> To: Win Myint Aung <wma108(a)yahoo.com> Cc: zope(a)zope.org Sent: Tuesday, February 27, 2007 1:12:39 PM Subject: Re: [Zope] How to export ZWiki contents in ZODB to MYSQL Win Myint Aung schrieb: > Dear Members, > > I am a newbie in Zope. please do me a favor. I am looking for some > python scripts that can export Zwiki contents from ZODB to MYSQL. Well, the script is easy in principle but you need to know how the result in your MySQL should look like. So its basically just traversing the object tree in zope, lookup the properties and attributes with content and then rewrite them in the form your application needs it. Otoh, its a lot of work - what is the expected gain? Regards T. ____________________________________________________________________________________ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265

1 0

How to export ZWiki contents in ZODB to MYSQL
by Win Myint Aung 27 Feb '07

27 Feb '07

Dear Members, I am a newbie in Zope. please do me a favor. I am looking for some python scripts that can export Zwiki contents from ZODB to MYSQL. Thanks. Aung ____________________________________________________________________________________ Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo! Games. http://games.yahoo.com/games/front

2 1

Dynamic class from python script (?)
by Dimitris Koukis 26 Feb '07

26 Feb '07

Dear Zopistas, i have an old zope application that present data from a database in such a manner <dtml-in "sql_methods.select_user()"> <dtml-var firstname><dtml-var lastname> </dtml-in> I had to change the methods that returned data from the database, and it is no longer possible to return data directly from zsql methods. Instead i read them in a script, perform some processing and return a dictionary with exactly the same mappings. I thought the application would work without any change but it seems this is not the case (variables in dtml-in can not be found, kinda makes sense now, the dictionary values are not properties...). So i created class that dynamically contain all data returned from my script. The class is something like this class foo: dct ={} def fill(self,temp_dct): self.dct = temp_dct def __getattr__(self,val): return self.dct[cal] >From pure python it works fine. Unfortunately i can not use it in a zope python script because of the __getattr__ method, so i put the class definition in an external method and use it in the python script (it returns an instance of the class). But dtml still returns me some strange errors. First, when the instance is created/accessed, some zope-like methods are called on it (for example getId, cant figure out why), and even if i implement them (dummy) it returns me authorization errors. Any idea, or alternative solution would be more than helpful ;) My main objective is not to change the zope application Thank you.... PS sorry for the length of my mail, but it is kinda complicated problem :) -- Dimitris Koukis Software Engineer koukis(a)vtrip.net

2 2