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

[sean.upton@uniontrib.com]

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
>