[Zope-CMF] sum up member properties for specific time period

Norman Khine norman@khine.net
Mon, 2 Jun 2003 21:43:49 +0100


suerly, i must be missing something here or don't understand the whole OO
programming, perhaps you can enlighten me ;^)

but if it is possible to write an external  method to collate this
information and another method to analyse this, is there no way to by-pass
the need for the text file and be able to piece the information from the
ZODB?

perhaps i am thinking more on SQL terms rather then OO!

is this my Achilles heal?

thanks

norman


----- Original Message -----
From: <sean.upton@uniontrib.com>
To: <norman@khine.net>; <dieter@handshake.de>
Cc: <zope-cmf@zope.org>
Sent: Monday, June 02, 2003 9:09 PM
Subject: RE: [Zope-CMF] sum up member properties for specific time period


> Why don't you just use an external method that is run once daily via a
cron
> job that logs the day's stats to a text log file.  Write another external
> method to parse the log and/or provide reporting???
>
> Sean
>
> > -----Original Message-----
> > From: Norman Khine [mailto:norman@khine.net]
> > Sent: Monday, June 02, 2003 11:16 AM
> > To: Dieter Maurer
> > Cc: Zope-CMF
> > Subject: Re: [Zope-CMF] sum up member properties for specific time
> > period
> >
> >
> > hi dieter,
> > thanks for the reply, but i am not sure i understand ;^(
> >
> > you're saying that i should store these data within a
> > database rather than
> > the ZODB? or am i wrong?
> >
> > what i have is that i have setup some additional properties
> > to the Member on
> > the CMF, this includes Join_Date, Office_Location etc, so
> > when a user joins
> > the form registers the Date & Time and also it asks them to
> > select from a
> > drop-down box the Office_Location(this is stored as 1, 2, 3 -
> > where 1 is the
> > Head Office, 2 is Editorial, and 3 is Developmet) - all this
> > is stored on
> > the ZODB and if I use the how-to
> > http://www.zopelabs.com/cookbook/1048010784
> > i can see all the data that I need to analyse, BUT don't have
> > the know-how
> > of how to achieve this ;^(
> >
> > also, looking at the
> > http://www.zopelabs.com/cookbook/1054497272 we can
> > count how many members we have? so isn't there a way to group these by
> > Join_Date property?
> >
> > does this make my query still unworkable, or have i missed
> > something in your
> > reply.
> >
> > thanks
> >
> > norman
> >
> > ----- Original Message -----
> > From: "Dieter Maurer" <dieter@handshake.de>
> > To: "Norman Khine" <norman@khine.net>
> > Cc: "Zope-CMF" <zope-cmf@zope.org>
> > Sent: Monday, June 02, 2003 6:05 PM
> > Subject: Re: [Zope-CMF] sum up member properties for specific
> > time period
> >
> >
> > > Norman Khine wrote at 2003-6-2 08:31 +0100:
> > >  > how can one, sum up the member properties? for example,
> > i would like to
> > be
> > >  > able to sum up all the members that had joined the cmf
> > portal within a
> > >  > specific time period, and get a table like so:
> > >  >
> > >  >
> > >  >   Date  \  Member Type  |   REVIEWER     |     MEMBER   |  TOTAL
> > >
> >  >
> > --------------------------------------------------------------
> > ----------
> > >  > MAR-03                       |      2
> > |           10
> > >  > |  12
> > >  > APR-03                       |        4
> > |            12
> > >  > |   16
> > >  > MAY-03                      |        1                 |
> >            23
> > >  > |     24
> > >  > JUN-03                        |       0                 |
> > 2
> > >  > |      2
> > >
> >  >
> > --------------------------------------------------------------
> > -----------
> > >  > TOTAL                      |             7            |
> > 47
> > >  > |      54
> > >
> > > Zope does not directly maintain this information for you.
> > >
> > > When you are using FileStorage (the default ZODB storage),
> > > then in principle historical information is maintained
> > > up to the last pack time. But it is not easy to access
> > > this information (for ObjectManager like objects).
> > >
> > > The best way is that you store the information yourself.
> > >
> > >
> > > Dieter
> > >
> > > _______________________________________________
> > > Zope-CMF maillist  -  Zope-CMF@zope.org
> > > http://mail.zope.org/mailman/listinfo/zope-cmf
> > >
> > > See http://collector.zope.org/CMF for bug reports and
> > feature requests
> > >
> >
> >
> > _______________________________________________
> > Zope-CMF maillist  -  Zope-CMF@zope.org
> > http://mail.zope.org/mailman/listinfo/zope-cmf
> >
> > See http://collector.zope.org/CMF for bug reports and feature requests
> >
>
> _______________________________________________
> Zope-CMF maillist  -  Zope-CMF@zope.org
> http://mail.zope.org/mailman/listinfo/zope-cmf
>
> See http://collector.zope.org/CMF for bug reports and feature requests
>