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/
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
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
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
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
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.
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
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
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
The voting has now commenced for the first annual community Zope awards.
Vote for your favourite Products, Books, Web Sites and so on. Voting is open
till the end of Thursday 8th Aug, results on Friday 9th Aug.
To vote: http://www.zopezen.org/Awards
--
Andy McKay
agmweb Consulting
http://www.agmweb.ca