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

sean.upton@uniontrib.com sean.upton@uniontrib.com
Mon, 02 Jun 2003 14:00:20 -0700


Storing somthing like this in the ZODB requires you to create a data
structure (class) to hold it.  I'm advocating the lazy approach of just
logging your data to a text file (or even a RDB table) to save time and
effort.  External methods would only be required if you want to do file
i/o...

Sean

> -----Original Message-----
> From: Norman Khine [mailto:norman@khine.net]
> Sent: Monday, June 02, 2003 1:44 PM
> To: Dieter Maurer; sean.upton@uniontrib.com
> Cc: Zope-CMF
> Subject: Re: [Zope-CMF] sum up member properties for specific time
> period
> 
> 
> 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
> >
>