[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
> >
>