- Zope - Zope lists

Advice Needed.
by Goldthwaite, Joe 26 Nov '03

26 Nov '03

Hi, Sorry to bother everyone again. I try to keep my questions to a minimum but there's just too much to Zope and Python and I'm feeling a bit overwhelmed. I also apologize for not being more specific with my questions but just I don't know enough to be more specific. The thing I'm trying to do is conceptually very simple but I can't seem to get all the pieces together. I'm trying to create an Executive Information System that puts my client's financial information online with drill down capability. I'd basically like to be able to have Zope accept a URL something like this; http:\\MyZopeServer\IncomeStatement?rgn=80 and have it generate an Income Statement routine for region 80. They have a hierarchical structure with groups, divisions, regions, areas, sales reps, etc. so the code "rgn" might be "grp" or "area". That sounds pretty simple doesn't it? I can't seem to put the pieces together. I was able to write a python module that takes the organization type and number and writes an Income Statement to a file in HTML. I got the project from The Book of Zope working but all the forms seem to be linked to DTML files. It didn't give me any examples on where to get the URL parameters from or how to just return my finished HTML to Zope. I also went through the Template Attribute Language section of The Zope Book and have kind of an understanding on how TAL templates work but I don't see where they get URL parameters from. Having been a programmer for 20 years, I'm most comfortable with programming languages like Python than with TAL or DTML. Ideally, I'd like the above URL to execute my Income Statement function and pass the org type and number. My module could then return the HTML page. The main problem I see with this approach (other than the fact that I can't figure out how to do it) is that I need to connect to the database every time. Also, the Income Statement module returns data appropriate to the SQL user name so I need to have some way to associate a Zope user with an SQL database user. I work at a Microsoft shop and am getting a log of pressure to go with IIS and .Net. There are a number of people here that have already done some similar work in the sales area. I'm in kind of a race to get something put together so I can demo it. That makes it hard because I tend to jump around a lot just trying to get things working without knowing the best approach to take. I guess that's why I've got so many pieces but no pie. So, what's the best approach to take? Should I try to do it with Page Templates and python scripts? Is that efficient? Is the product approach better? Whichever approach is best, I have a ton of questions. Too many to ask for free. I can pay for a few hours of help if anyone is available. I guess what I'd really like is a product that would translate the above URL into a call to a Python function passing in the user info, the database connection, the organization type and number. It doesn't seem like that would be too hard for someone who knows what they're doing. So far, I haven't had much success. Thanks Joe Goldthwaite

3 2

RE: [Zope] Advice Needed.
by Wilson, Derek 26 Nov '03

26 Nov '03

I'd suggest using ZSQL statements with a MSSQL DA product. You can set the statements to require variables such as region, username, etc, which then can get passed in the SQL. I've had great success converting Seagate Crystal Reports pages to ZSQL and ZPT pages. You just copy the SQL to a ZSQL method, and use the ZPT to handle presentation. Thanks, Derek Wilson -----Original Message----- From: Goldthwaite, Joe [mailto:joe@goldthwaites.com] Sent: Tuesday, November 25, 2003 11:46 PM To: zope(a)zope.org Subject: [Zope] Advice Needed. Hi, Sorry to bother everyone again. I try to keep my questions to a minimum but there's just too much to Zope and Python and I'm feeling a bit overwhelmed. I also apologize for not being more specific with my questions but just I don't know enough to be more specific. The thing I'm trying to do is conceptually very simple but I can't seem to get all the pieces together. I'm trying to create an Executive Information System that puts my client's financial information online with drill down capability. I'd basically like to be able to have Zope accept a URL something like this; http:\\MyZopeServer\IncomeStatement?rgn=80 and have it generate an Income Statement routine for region 80. They have a hierarchical structure with groups, divisions, regions, areas, sales reps, etc. so the code "rgn" might be "grp" or "area". That sounds pretty simple doesn't it? I can't seem to put the pieces together. I was able to write a python module that takes the organization type and number and writes an Income Statement to a file in HTML. I got the project from The Book of Zope working but all the forms seem to be linked to DTML files. It didn't give me any examples on where to get the URL parameters from or how to just return my finished HTML to Zope. I also went through the Template Attribute Language section of The Zope Book and have kind of an understanding on how TAL templates work but I don't see where they get URL parameters from. Having been a programmer for 20 years, I'm most comfortable with programming languages like Python than with TAL or DTML. Ideally, I'd like the above URL to execute my Income Statement function and pass the org type and number. My module could then return the HTML page. The main problem I see with this approach (other than the fact that I can't figure out how to do it) is that I need to connect to the database every time. Also, the Income Statement module returns data appropriate to the SQL user name so I need to have some way to associate a Zope user with an SQL database user. I work at a Microsoft shop and am getting a log of pressure to go with IIS and .Net. There are a number of people here that have already done some similar work in the sales area. I'm in kind of a race to get something put together so I can demo it. That makes it hard because I tend to jump around a lot just trying to get things working without knowing the best approach to take. I guess that's why I've got so many pieces but no pie. So, what's the best approach to take? Should I try to do it with Page Templates and python scripts? Is that efficient? Is the product approach better? Whichever approach is best, I have a ton of questions. Too many to ask for free. I can pay for a few hours of help if anyone is available. I guess what I'd really like is a product that would translate the above URL into a call to a Python function passing in the user info, the database connection, the organization type and number. It doesn't seem like that would be too hard for someone who knows what they're doing. So far, I haven't had much success. Thanks Joe Goldthwaite _______________________________________________ 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 )

1 0

Zope X3 Milestone Release 4 is available for download
by Stephan Richter 26 Nov '03

26 Nov '03

Hello everyone in the Zope community and beyond, We are pleased to announce that Zope X3 MS4 is out of the door. Much work has been done since the last release in June, 2003, including major fundamental refactorings of the Component Architecture, I18n/L10n, filesystem syncing, and new TTW capabilities. Get it now! You can find a source and Windows binary archive at the URL below. URL: http://dev.zope.org/Zope3/Milestone4 Here the release notes: Zope X3 Milestone Release 4 is available for download What is Zope X3? It's Zope 3 "experimental". This is the release that will provide the new features of Zope 3 without any Zope 2 support. Zope 3.0 will provide support for Zope 2 content and products, probably using conversion utilities of some sort. Backward compatibility notes - If you have any add-on prodycts that used the old context-wrapper or "context awareness" APIs, you will need to update these use the new, and much simpler, location API. See zope/app/interfaces/location.py. - If you have add-on products that register views or resources using the view or resource directives from the zope ZCML namespace, you will need to change the value of the 'type' attribute to refer to a request type, rather than a presentation type. - If you have an add-on product that defines new layers, you need to use the zope:layer or browser:layer directive to define the layer before you use it in a skin definition or a view or resource definition: <browser:layer name="rotterdam" /> - If you had a local (through the web) adapter service, you will need to recreate it and reactivate your adapter registrations. - If you had a local (through the web) view service, you will need to create a local presentation service and reactivate your page or view registrations. Features - Changed the way presentation components are managed. o The view, resource, and skin services have been combined into a new presentation service. o Views and resources now adapt requests. They are registered for request types rather than presentation types. - Refactored the way interfaces, declarations and adapters are implemented. We now use a cleaner architecture that no-longer requires a caching mechanism beyond what's provided by the underlying data structures. This has led to a significant speed up for Zope 3. - Refactored the way location-related events are generated and handled. For more details, see: http://dev.zope.org/Zope3/LocationRelatedEvents http://dev.zope.org/Zope3/SimplifyObjectLifecycleAndLocationEvents - Refactored the way object location is modeled. Zope 3 no longer uses context wrappers. Instead, objects have __parent__ attributes that reference their containers. Objects that don't maintain these attributes themselves are warpped in persistent proxy objects that do so. For more details, see: http://dev.zope.org/Zope3/ParentGeddon - Added catalogs. Catalogs can be used in two-ways: o Site-wide utilities A catalog is created in a site-management folder and registered as a named utility. o Local content objects. A catalog is added to a regular content folder. - Added object fields. Object fields provide a simple composite field mechanism. An object field is defined by a schema and, thus, can contain sub-fields. - Added working widgets for list fields. List fields contain a sequence of monogenous values. - Improved forms error reporting. Error messages now appear next to fields where errors occured. - Major fixes to the TAL I18n-Namespace support. Almost all fixes were backported to Zope 2.7 as well. - Templated Pages support for a <disabled script> tag, that allows inline Python code. The <disabled script> tag can be used in other TAL sources as well, but is turned off by default. - Internationalized all Zope 3 (Python, ZCML and Page Templates) user-readable strings. Zope 3 was then localized to German and partially to Spanish, Brazilian Portuguese and French. - Implemented explicit message ids in ZCML - New Persistent/Mutable Schemas allow us to generate Schema-based interfaces through the Web. - New local Menu Service and Content Component Definitions allow you to create simple Content objects TTW. - Major fssync improvements. The commands to use now are "zsync" and "zbundle". New flags include: copy, login (+ new options for checkout), logout, mkdir, resolve, revert. fssync behaves now very similar to SVN. - Introspector uses the Interface service now, instead of the ++module++ namespace. - Refactoring and cleanup of the schema/form code. - Improvements to the OnlineHelp, which has been deactivated for this release since it is broken since the recent geddons. - ZODB 4: Changed serialization logic to support persistent proxies. Added an add() method to Connection and allowed it to run during commit(). - In the future, Zope 3 will use ZODB 3, which will support new-style classes, since the development of ZODB 4 stopped in late summer. - Various improvements to ZConfig Miscellaneous - Progress with the TUV-IT security accredidation - Many maintainance work and bug fixes. Much thanks to everyone who contributed to this release: Jim Fulton, Christian Theune, Marius Gedminas, Tim Peters, Jeremy Hylton, Fred Drake, Sidnei da Silva, Philipp von Weitershausen, Steve Alexander, Guido van Rossum, Barry Warsaw, Albertas Agejevas, Viktorija Zaksiene, Andreas Jung, Anthony Baxter, Phillip Eby, Richard Jones, Tom Cameron, Kevin Littlejohn, Stuart Bishop, Andy Hird, Peter Simmons, Christian Theune, Adam Summers, Stephan Richter, Chris McDonough, Garrett Smith, Godefroid Chapelle, Paul Roe, Kiki Pruvot, Don Baarda, David Fregon, Rob Zaar, Jan Smith, Richard Volpato, Roger Ineichen, Gary Poster, Bjorn Tillenius, Martijn Faassen, Chris Withers, Paul Everitt, Dominik Huber Requirements Zope3 requires Python 2.3.2 or later. You might get a segfault when shutting down the Zope servers. This is due to a bug in weakref and will be fixed in the upcoming Python 2.3.3 release. You can safely ignore the segfault. Downloads - Source release: "ZopeX3-0.0m4.src.tgz", http://dev.zope.org/Zope3/ZopeX3-0.0m4.src.tgz. Follow the instructions for building from source in README.txt. - A windows binary release: "ZopeX3-0.0m4.win32.zip", http://dev.zope.org/Zope3/ZopeX3-0.0m4.win32.zip. This is an "in-place" build. Just unzip it and run it. Use Python 2.3.2 and skip the building part of the instructions. Regards, Stephan and the Zope 3 team

1 0

Error with the MailHost object
by Sébastien Tessier 26 Nov '03

26 Nov '03

Hi, I am trying to send mails with the mailhost object using the 'send' method and, according to whether the SMTP server I use, sometimes it works and sometimes I have the following error : SMTPRecipientsRefused: {'sebastientessier(a)bbs-one.fr': (550, 'RCPT TO:<sebastientessier(a)bbs-one.fr> Relaying not allowed')} I use Zope 2.6.2 with windows 2000. If someone can explain this to me...

1 0

SimpleUserFolder and local roles
by emf 26 Nov '03

26 Nov '03

Hi, all. Having discovered that I can't seem to assign local roles when using a SimpleUserFolder, I'm trying to do whatever it takes for it to work. The problem is that users in the simple user folder don't show up in the list to be assigned roles. It appears to me that the function being called to figure out who can be assigned local roles is get_valid_userids in Roles.py. As far as I can tell this function is applied to every parental folderish object when manage_listLocalRoles is called. This performs two checks; the first is assuming that obj.__allow_groups__ is the acl_user folder, and the second is getting user_names . __allow_groups__ is added by manage_afterAdd in BasicUserFolder (though, in the generic User folder implementation, it's also added in the manage_addUserFolder , so I tried doing the same thing in addSimpleUserFolder to no avail). user_names is defined in BasicUserFolder to be getUserNames , which is defined in SimpleUserFolder. In short, I can't see why I'm getting a truncated list. Can someone help me out here? ~mindlace p.s. i'm not subbed, so please cc: me on replies.

4 4

Re: [Zope] 4 question
by Peter Sabaini 26 Nov '03

26 Nov '03

Please keep it on the list... Kepes Krisztian wrote: > Hello Peter Sabaini ! > > Wednesday, November 26, 2003, 11:57:02 AM, you wrote: > > PS> Kepes Krisztian wrote: > >>>Hi ! >>> >>>I want to create an web application, but I want to get information, >>>how to create that, and what system I use... >>> >>>1.) >>>Can I create persistent db connection under ZOPE ? >>>I don't want to drop the db connection, because the connect to >>>InterBase is very slow... >>> >>>Can I do that, or I must create a my owned connection tcp server, and >>>interface to use this thing (like php ibase_pconnect) ? > > PS> Yes you can. See eg. the Zope book: > PS> http://zope.org/Documentation/Books/ZopeBook/2_6Edition > PS> theres a whole chapter dedicated to RDBMS connectivity > > Ok, I read that, but this thing I cannot see. Possible I miss that, > but I don't see any text what say about this capability. Chap. 18 describes Zope Database Adapters which do what you want. The Zope book doesn't explicitly say so, but Database Adapters usually do keep a persistent connection -- which database do you want to connect to?

1 0

4 question
by Kepes Krisztian 26 Nov '03

26 Nov '03

Hi ! I want to create an web application, but I want to get information, how to create that, and what system I use... 1.) Can I create persistent db connection under ZOPE ? I don't want to drop the db connection, because the connect to InterBase is very slow... Can I do that, or I must create a my owned connection tcp server, and interface to use this thing (like php ibase_pconnect) ? 2.) Can I use non-cookie based session - just like in php (1 session/1 browser) - under Zope ? 3.) mod_python or zope ? What is goodest thing for create web applications ? 4.) Under mod_python can I use persistent db connection; and real (php liked) session ? Thanx for any answers ! KK

2 1

Re: [Zope] Zope loose changed data after restarting
by Stefan H. Holek 26 Nov '03

26 Nov '03

I can't ;-) I must have misread what your actual problem is, sorry. - Don't use versions! - Make sure you do not lock the Data.fs by e.g. gzip-ing it in place. - Make sure you did not hit the 2GB limit (in case it applies to your os). - As Dieter said, watch the Data.fs and its modification time. Stefan --On Mittwoch, 26. November 2003 09:12 +0200 Miguel Lara Alday <miguel.lara(a)uiah.fi> wrote: > But how do you explain that same happened to changed scripts, > method..etc (modified in the ZMI)? -- The time has come to start talking about whether the emperor is as well dressed as we are supposed to think he is. /Pete McBreen/

1 0

Fw: [Zope] inelegant repetition of ZPT code
by Andre Meyer 26 Nov '03

26 Nov '03

----- Original Message ----- From: "Andre Meyer" <a.meyer(a)hccnet.nl> To: "Wilson, Derek" <dwilson(a)abrazohealth.com> Sent: Wednesday, November 26, 2003 9:43 AM Subject: Re: [Zope] inelegant repetition of ZPT code > Well, I was trying with ZPT-only and struggled, because you end up with > either malformed html (tr twice) or repetition. The python solution > mentioned below works perfectly well in ZPT, except for the missing > parentheses for odd() ;-) > > ----- Original Message ----- > From: "Wilson, Derek" <dwilson(a)abrazohealth.com> > To: "Allen" <aschmidt(a)fredericksburg.com> > Cc: "Phil Harris" <phil(a)harris-family.info>; "Zope list" <zope(a)zope.org> > Sent: Wednesday, November 26, 2003 3:51 AM > Subject: RE: [Zope] inelegant repetition of ZPT code > > > > well, Allen, Andre was looking for a ZPT code to do it, not python. So... > :-P~~ > > > > -----Original Message----- > > From: Allen [mailto:aschmidt@fredericksburg.com] > > Sent: Tue 11/25/2003 5:45 PM > > To: Wilson, Derek > > Cc: Phil Harris; Zope list > > Subject: Re: [Zope] inelegant repetition of ZPT code > > > > > > > > I don't get it! This answer posted earlier works great.... and my nickname > is DTML-man! > > > > <tr tal:attributes="bgcolor python: test(repeat['item'].odd, 'white', > 'lightgray')" /> > > > > -Allen > > > > > > Wilson, Derek wrote: > > > > > try this... > > > > > > <table tal:repeat="item here/listItems"> > > > > > > <tr bgcolor="white" tal:omit-tag="not:repeat/item/even"> > > > <tr bgcolor="lightgray" tal:omit-tag="not:repeat/item/odd"> > > > > > > <td>...</td> > > > > > > </tr> > > > </tr> > > > > > > </table> > > > -----Original Message----- > > > From: Phil Harris [mailto:phil@harris-family.info] > > > Sent: Tue 11/25/2003 4:23 PM > > > To: Zope list > > > Cc: > > > Subject: Re: [Zope] inelegant repetition of ZPT code > > > That won't work because you have badly formed html in there. > > > > > > The <tr>s are badly nested with the spans, you must have correctly > > > formed html when using TAL. > > > > > > Phil > > > On Tue, 25 Nov 2003 16:15:05 -0700 > > > "Wilson, Derek" <dwilson(a)abrazohealth.com> wrote: > > > > > > dwilson> How about: > > > dwilson> > > > dwilson> <table> > > > dwilson> <span tal:repeat="item here/listItems"> > > > dwilson> <span tal:condition="repeat/item/even"><tr > bgcolor="white"></span> > > > dwilson> <span tal:condition="repeat/item/odd"><tr > bgcolor="lightgray"></span> > > > dwilson> <td>...</td> > > > dwilson> </tr> > > > dwilson> </span> > > > dwilson> </table> > > > dwilson> > > > dwilson> I haven't tested it, but it should work. > > > dwilson> > > > dwilson> -----Original Message----- > > > dwilson> From: Andre Meyer [mailto:a.meyer@hccnet.nl] > > > dwilson> Sent: Tue 11/25/2003 1:52 PM > > > dwilson> To: Zope Mailing List > > > dwilson> Cc: > > > dwilson> Subject: [Zope] inelegant repetition of ZPT code > > > dwilson> > > > dwilson> > > > dwilson> > > > dwilson> Hi Zopers > > > dwilson> > > > dwilson> Another detail that bugs me: how can I translate the > following dtml code > > > dwilson> to zpt. It colours table rows in grey/white alternatively. > Is the zpt > > > dwilson> version below the only way? It is clearly very inelegant > to repeat code. > > > dwilson> > > > dwilson> > > > dwilson> DTML > > > dwilson> > > > dwilson> ... > > > dwilson> <table> > > > dwilson> <dtml-in listItems> > > > dwilson> <tr <dtml-if > sequence-even>bgcolor="lightgray"</dtml-if>> > > > dwilson> <td>...</td> > > > dwilson> </tr> > > > dwilson> </dtml-in> > > > dwilson> </table> > > > dwilson> > > > dwilson> > > > dwilson> ZPT > > > dwilson> > > > dwilson> ... > > > dwilson> <table> > > > dwilson> <span tal:repeat="item here/listItems"> > > > dwilson> <tr bgcolor="white" > tal:condition="repeat/item/even"> > > > dwilson> <td>...</td> > > > dwilson> </tr> > > > dwilson> <tr bgcolor="lightgray" > tal:condition="repeat/item/odd"> > > > dwilson> <td>...</td> > > > dwilson> </tr> > > > dwilson> </span> > > > dwilson> </table> > > > dwilson> > > > dwilson> > > > dwilson> thanks and best wishes > > > dwilson> Andre > > > dwilson> > > > dwilson> > > > dwilson> > > > dwilson> _______________________________________________ > > > dwilson> Zope maillist - Zope(a)zope.org > > > dwilson> http://mail.zope.org/mailman/listinfo/zope > > > dwilson> ** No cross posts or HTML encoding! ** > > > dwilson> (Related lists - > > > dwilson> http://mail.zope.org/mailman/listinfo/zope-announce > > > dwilson> http://mail.zope.org/mailman/listinfo/zope-dev ) > > > dwilson> > > > dwilson> > > > > > > > > > > > > > > -------------------------------------------------------------------------- -- > ---- > > > > _______________________________________________ > > 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 ) > > >

1 0

Re: [Zope] Advice Needed.
by Tim Terlegård 26 Nov '03

26 Nov '03

> I'd basically like to be able to have Zope accept a URL > something like this; http:\\MyZopeServer\IncomeStatement?rgn=80 > and have it generate an Income Statement routine for region 80. Make a Zope Page Template (zpt). It's possible with Python Scripts too, but when you deal with lots of HTML zpt is much better. Make a zpt with id IncomeStatement: <html> ... Region: <span tal:replace="request/rgn" /> ... </html> This results in an HTML page that says "Region: 80" if you append ?rgn=80 to the URL. > That sounds pretty simple doesn't it? I can't seem to put the pieces > together. I was able to write a python module that takes the > organizationtype and number and writes an Income Statement to a > file in HTML. In Python Scripts you build HTML using pure Python. Your page gets the HTML that the script returns: html_code = "<html><body>" + context.REQUEST.get('rgn', None) + "</body></html>" return html_code But zpt is much better for this. > So, what's the best approach to take? Should I try to do it with Page > Templates and python scripts? Is that efficient? Is the product > approachbetter? You can have templates and python scripts in products too. I you make a site that will last for a while you certainly want a product on the filesystem, but you can do that later when you get things going. Tim

1 0