- Zope-Announce - Zope lists

New release of ZDataQueryKit
by Adrian Hungate 18 Aug '02

18 Aug '02

I have just upload the newest release of my visual data query and reporting solution - ZDataQueryKit. This release includes fixes to a number of bugs, and I have finally got the DataCombiner working properly (I hope). Among the changes in this version are: * Fixed ZDataCombiner - It now works, but it does not support OUTER joins yet * ZDataCombiner generates "virtual SQL" to aid debugging (Of ZDataQueryKit and your code!) * Corrected INNER/OUTER testing in all Visual types * Fixed bug where ZDataCombiners lost their datasources * Fixed bug that prevented creation/editing of Visual Queries on Zope < 2.4 * Changed ZRT to allow table width as a property. * Fixed another bug that prevented associating ZRT with a datasource. * Fixed bug that prevented displaying with standard headers if the headers where ZPT objects (CMF/Plone). Get your hands on the latest release here: http://www.zope.org/Members/haqa/ZDataQueryKit The full change log is here: http://www.zope.org/Members/haqa/ZDataQueryKit/changes Adrian... -- Adrian Hungate EMail: adrian(a)haqa.co.uk Web: http://www.haqa.co.uk

1 0

Annouce AixtraTable
by Joachim Schmitz 14 Aug '02

14 Aug '02

Hi, from the README: The AixtraTable product is supposed to be a kind of swissarmy-knife product. Its goal is, to provide all functionallity for working with tabular data, like: - through the WEB column- or attribute-definition - storage of the items (rows) in a Btree - indexing with ZCatalog for selectable fields - listing, creating, editing, deleting of the items - form-input with validation driven by one description. This release is mainly a prove of concept, that it can be done and a request for comment, if the way I implemented it, is correct. I am certain that it can be improved. You can get from: http://www.zope.org/Members/perry/AixtraTable Mit freundlichen Grüßen Joachim Schmitz -------------------------------------------------------------------- AixtraWare Ingenieurbüro für Internetanwendungen Hüsgenstr. 33a, D-52457 Aldenhoven Telefon: +49-2464-8851, FAX: +49-2464-905163 -------------------------------------------------------------------- Key fingerprint = DA10 CC82 62F8 1DBB 39A1 1EDC 725B 3317 A8D7 C3A6 Keyserver: http://www.keyserver.net/en/

1 0

QuickLinks 0.1.3
by Peter Bengtsson 13 Aug '02

13 Aug '02

Hello all, Version 0.1.2 of QuickLinks had an embarrasing bug for all users that don't use the External Editor (which you should anyways :) This version 0.1.3 uses cookies instead of a zope property; suggested by Andy McKay. Go and have a look http://www.zope.org/Members/peterbe/QuickLinks Changes: http://www.zope.org/Members/peterbe/QuickLinks/CHANGES.txt --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.381 / Virus Database: 214 - Release Date: 2002-08-02

1 0

Annouce RDBTools
by kapil thangavelu 10 Aug '02

10 Aug '02

RDBTools (http://www.zope.org/Members/k_vertigo/Products/RDBTools Provides for pythonscript accessible functions to perform set operations on zsql method results. Operations provided - union_results - join_results - difference_results The algorithms are based off Aaron Watters kjbuckets package and his early 1995 news posting to comp.lang.python. Example Use Case You have correlatable data in multiple dbs. Lets say employee contact info is in postgres, and payment info is in oracle. You want to aggregate this info into a single result set for a report display. a contrived example but a useful illustration. contact table: create table corp_employee_contacts ( employee_id integer unique not null, email varchar(255), first_name varchar(30), last_name varchar(30), middle_name varchar(30) ); payment table: create table corp_employee_accounts ( employee_id integer unique not null, payment_period integer not null, payment_amount numeric default 0 not null ) zsql method: getEmployeeContacts: select * from corp_employee_contacts zsql method: getEmployeeAccounts: select employee_id, sum(payment_amount) as total_pay from corp_employee_accounts group by employee_id python script getEmployeeTotalPay: from Product.RDBTools import join_results contacts = context.getEmployeeContacts() accounts = context.getEmployeeAccounts() return join_results(accounts, contacts) the resultant result set contains properly merged information from both results Advanced Usage Note Acquisition Contexts ZSQL Results sets are bound to a context, the set operations exposed here preserve the context of the first result set argument. Brains brains are not preserved. Speed additional speed can be had by using installing the kjbuckets extension module, if its not installed the python implementation found in zope will be used. Cross Products if no common columns are found a cross product is returned. Author kapil thangavelu License X11, see LICENSE.txt for more details

1 0

Zope BackTalk v0-3 released
by Chris McDonough 09 Aug '02

09 Aug '02

Hi Folks, I have released v0-3 of Zope BackTalk. It is available for dowload from http://sourceforge.net/projects/backtalk/ . Zope BackTalk is a document editing, annotation, and production system for book-like content. Zope BackTalk powers the online versions of the Zope Book (http://www.zope.org/Documentation/ZopeBook) and the Zope Developer's Guide (http://www.zope.org/Documentation/ZDG) New to this release: - PDF generation - Obtain content and images from existing structured text pages - External Editor integration - Better management features (ability to turn commenting on and off based on a Book property). - Online help. - Various bugfixes. It has been tested under Zope versions 2.4, 2.5, and 2.6, and Python versions 1.5.2 and 2.1. Enjoy! - C

1 0

Zope Corporation will hold its next public training
by Zope Training 09 Aug '02

09 Aug '02

Zope Corporation will hold its next public training session this October 21-24, 2002 at its headquarters in Fredericksburg, VA. This four day course will familiarize participants with Zope software from rudimentary through advanced topics. You will gain an appreciation for the flexibility and effectiveness of Zope as an Open Source web development and content management environment. You will also learn Zope architecture as well as experience hands-on exercises using Zope to develop and manage a robust web site. There will be several opportunities to meet with Zope's engineering teams as well as share ideas over lunch with Jim Fulton (CTO) and Guido van Rossum (Director of PythonLabs). Course Objectives: After completing this course students will understand: - Zope's use of objects, methods, etc. - Zope's Management Interface. - Zope's server-side scripting language (DTML). - Page Templates. - Web site content creation and management. - Web site security through user privileges and roles. - Using Zope to integrate web sites with existing + relational databases. - Downloading/installing a Zope Product. - Introduction to CMF. The course is intended for anyone interested in using a full-featured open source environment to develop and manage a robust corporate internet or intranet web site. This includes web site designers, content creators, content managers and web developers. Participants should be familiar with HTML and basic web architecture (e.g., how a web server and web browser work together). Knowledge of object-oriented concepts and SQL is recommended. For more detailed information about the course, including pricing, travel and accommodations, please go to our website www.zope.com

1 0

FormulatorLayout 0.1.1 released
by Peter Jentsch 06 Aug '02

06 Aug '02

FormulatorLayout aimes at providing layout and automated rendering to Formulator forms. It provides a new object to zope, "Form Folder", which can contain Formulator forms and FormulatorLayout objects. Each FormulatorLayout object is associated with one form and contains layout objects slightly similar to those found in GUI libraries (well, very slightly :-) Right now, the product is in an early development stage, but I'd very much appreciate any feedback on it. More details and a demo application can be found on zope.org at http://www.zope.org/Members/pjentsch/FormulatorLayout FormulatorLayout depends on (surprisingly) Formulator and OrderedFolder (which in turn depends on ZBabel, though I'd like to either a) somehow remove that dependency or b) babelize FormulatorLayout itself). It was developed on Zope 2.5.1, and propably won't work on earlier versions of Zope. Later versions of FormulatorLayout will use the SessionAPI, so they will definitely require Zope 2.5.0 or later. Note: unfortunately, the initially uploaded version, FormulatorLayout_0_1, was broken :-( If you downloaded FormulatorLayout_0_1, please upgrade to FormulatorLayout_0_1_1.

1 0

CMF 1.3 released
by Tres Seaver 06 Aug '02

06 Aug '02

Zope Corporation is proud to announce the release of version 1.3 of the Zope Content Management Framework, available at: http://cmf.zope.org/download/CMF-1.3 >From the README What is the CMF? The Zope Content Management Framework provides a set of services and content objects useful for building highly dynamic, content-oriented portal sites. As packaged, the CMF generates a site much like the Zope.org site. The CMF is intended to be easily customizable, in terms of both the types of content used and the policies and services it provides. Resources * The CMF "dogbowl" site, http://cmf.zope.org. * The mailing list, zope-cmf(a)zope.org. List information and online signup are available at: http://lists.zope.org/mailman/listinfo/zope-cmf. Archives of the list are at: http://lists.zope.org/pipermail/zope-cmf. Known Issues * Please search the "CMF Collector", http://collector.zope.org/CMF for issues which are open against the CMF. You can also report issues there (please look for similar ones first!) Installation Please see "Installing CMF", http://cmf.zope.org/download/CMF-1.3/INSTALL.txt. "Installing CMF from CVS", http://cmf.zope.org/download/INSTALL_CVS.txt covers installing the CMF from a CVS checkout. New Features since version 1.2 - HTML content is now "scrubbed" when edited to remove tags which might allow cross-site scripting. - PortalFolders can now be workflowed and discussed (neither is enabled by default). - Tools which provide "actions" now allow editing of those actions via the ZMI. - The DublinCore modification date is now stored as an explicit attribute of content, rather than being inferred from the underlying ZODB value. - New PathIndex, 'path', is a standard part of the catalog. - New calendar display is now a standard part of the ZPT skins. - Filesystem-based skin methods can now have custom role-permission mappings, stored in separate '.security' files. - New CachingPolicyManager tool governs HTTP caching headers for FSPageTemplates. More Information - "Release Notes", http://cmf.zope.org/download/CMF-1.3/README.txt - "Recent changes", http://cmf.zope.org/download/CMF-1.3/CHANGES.txt - "Historical changes", http://cmf.zope.org/download/CMF-1.3/HISTORY.txt - "Installing CMF", http://cmf.zope.org/download/CMF-1.3/INSTALL.txt - "Installing CMF from CVS", http://cmf.zope.org/download/INSTALL_CVS.txt -- =============================================================== Tres Seaver tseaver(a)zope.com Zope Corporation "Zope Dealers" http://www.zope.com

1 0

Call for support - Making installing CMF products easier
by Adrian Hungate 04 Aug '02

04 Aug '02

I am working on a product that is intended to make installing CMF products into existing portals as easy as possible. To do this, I have created an API which allows CMF products to register "Toolsets" that is, groups of classes, skin-folders etc, to be added to a portal. The site manager can then choose which Toolsets to install by clicking on Install buttons next to the toolset name. The intention is also to allow the easy removal of Toolsets that are no longer needed. What I would like is to get some CMF authors to try out CMFInstallerTechnology, and give me some feedback so that I can make this something everyone wants to use. Drop me a line, and/or check it out from my CVS - :pserver:anoncvs@cvs.haqa.co.uk:/usr/cvsroot/Products/CMFInstallerTechnology There are still a few glitches to workout (Don't use the refresh tab on the product unless you really have to - It sometimes stops the installer working at the moment) but this is only about 8 hours old, so I guess I'm allowed a few bugs! :) Adrian... -- Adrian Hungate EMail: adrian(a)haqa.co.uk Web: http://www.haqa.co.uk

1 0

zyp (zyp yellow pages) initial release
by Jens Wolk 03 Aug '02

03 Aug '02

Dear Zope community, I am proud to announce the initial release of zyp (zyp yellow pages). - Purpose: create a yellow pages site based on CMF / Zope. - Tested against: CMF-1.2 / Zope-2.5.1 - Project's home page including tarballs, CVS repository and Mailing Lists: http://www.sourceforge.org/projects/zyp - Test site: http://zyp.dyndns.org:8080/zyp (most of the test data is in German - don't hesitate to add content in your favorite language) - License: GPL - Status: Development The idea behind zyp is that a Manager designs a structure of "CMF zyp Category" (folderish) objects. In addition, he/she can define "CMF zyp Category Link" objects which point from a "CMF zyp Category" object to another "CMF zyp Category" object. Members of a CMF site can than add "CMF zyp Entry" and "CMF zyp Address" objects in their Member folder. For each "CMF zyp Entry" object a Member defines links to "CMF zyp Category" objects in which the entry will be listed. A possibly interesting feature is that the above mentioned links won't break if the linked object is moved within the CMF site. This is done by introducing a universal zid which identifies an object independently of its location in the site. (Thanks for the code snippets to alex.khan, see http://www.zope.org/Members/alex.khan/GlobalSystemId?pp=1 ... if anybody knows how I can contact him, please let me know, because I am unsure, if I am allowed to use his code ...) Planned: - Ranking of the most visited entries / categories - Banners - Contacts (analogous to Addresses) - Articles on a per category base - invoicing for entries and banners based on click-throughs and/or page impressions Any comments, hints, critizim and encouragement are very welcome. You may contact me at zyp(a)jenswolk.de Yours, Jens Wolk

1 0