[Zope] Exporting zodb data (Urgent)

Sukhwinder Singh ssruprai@hotmail.com
Sun, 29 Jun 2003 02:20:45 +0530


Thanks for replying.

It is a school application which stored information about employees,
students, trainings etc.
What I know is they have used dtml methods, python scripts and folders to
organize their app. But not custom products. I have checked those objects
using /manage. And most of these are methods and other dtml files. I have
also checked some of the dtml files.and python scripts.

These files get data using something like:

for employee in container.employees
print employee.name

These files/scripts/methods are in their respective folders. For example, a
script which displays employee data is in employees folder and script which
exports student data is in students folder.

But when I try to use this method of using for each * in container.students
or container.employees outside these folders (in the root folder) error is
displayed like container is not defined etc. Is container something built in
or their custom class?

There is one more problem client is on the other part of the globe. My boss
cannot lose this project now. So I must do it.

While I am trying to figure out how to export data they are using the old
system at this time. So they are updating the database. I want to provide
them a way to export complete data by just on click. If that is not possible
then I want to provide them an external method or python script which they
install in root folder and when accessed exports data to mysql database.

If there is no other solution than learning zope then tell me what are the
things I should learn about only to export data. I have downloaded zope
guide and developer guide and admin guide. What other resource I should
check? Time is problem for me.

--Sukhwinder Singh

----- Original Message -----
From: "Paul Winkler" <pw_lists@slinkp.com>
To: "Sukhwinder Singh" <ssruprai@hotmail.com>
Cc: <zope@zope.org>
Sent: Sunday, June 29, 2003 1:22 AM
Subject: Re: [Zope] Exporting zodb data (Urgent)

> On Sun, Jun 29, 2003 at 12:46:31AM +0530, Sukhwinder Singh wrote:
> >
> > >  Their loss, I suppose.
> >
> >  They want to it because zope has become very very slow.
> what makes them think php will be faster?
> zope performs pretty well with most jobs except serving large
> files (at least 10 MB).
> there are ways to speed up zope:
> - various kinds of cacheing to reduce load
> - using a profiler to find hot spots and optimize them
> >  Yes that is what I want, a snapshot. I am working on windows system.
> > is
> >  wget? What does it do? Will it work on Windows.
> it's a downloading & mirroring tool for unix.
> don't know if it runs on windows, there are probably similar GUI
> tools available for windows.
> >  Question is how do I know which objects store data and how many fields
> >  (attributes) are there and their data types etc. in each of those
> >  And then how to extract data?
> there is no general-purpose way to do this for all zope objects.
> You haven't told us anything about what kind of objects they used in
> the zope application to store data. DTML methods or documents? ZPT?
> CMF content types?  some 3rd-party downloaded product?
> Custom python products? Custom zclasses?
> If you don't know any of this, and the customer doesn't either, and you
> have sufficient zope experience to figure it out, then they've
> given you an unreasonable burden. An experienced zope / python developer
> could get this job done pretty quickly with a bit of python scripting.
> --
> Paul Winkler
> http://www.slinkp.com
> Look! Up in the sky! It's MILDLY-AMERICAN SHROOM BAT!
> (random hero from isometric.spaceninja.com)