Hi Chris, many thanks for the helpful reply. I mostly now just need to understand the output format of the other program. One small follow-up: On Sun, 06 Aug 2006, Chris Cormack wrote:
Gavin McCullagh wrote:
- If I wanted statistics of how many loans/renewals were given out on a given day some time ago, could I do this? It appears not. Yes indeed, using the statistics table
EG select * from statistics where type='renew' and datetime > '2006-07-20' and datetime <='2006-07-21' limit 3; +---------------------+--------+----------+--------+-------+-------+----------+------------+----------+----------------+ | datetime | branch | proccode | value | type | other | usercode | itemnumber | itemtype | borrowernumber | +---------------------+--------+----------+--------+-------+-------+----------+------------+----------+----------------+ | 2006-07-20 09:34:55 | S | NULL | 0.0000 | renew | | NULL | 121757 | NULL | NULL | | 2006-07-20 09:41:06 | NULL | NULL | 0.0000 | renew | | NULL | 84985 | NULL | NULL | | 2006-07-20 09:41:25 | NULL | NULL | 0.0000 | renew | | NULL | 35666 | NULL | NULL | +---------------------+--------+----------+--------+-------+-------+----------+------------+----------+----------------+ 3 rows in set (0.01 sec)
Is there a reason that borrowernumber is NULL in all of your "renew" examples? Does Koha leave this blank? If so, why? I am in a position to fill this in correctly during my import. Should I or would I be better off behaving as much like Koha as possible? It seems like a partial set of statistics might be confusing?
So on your import you might like to populate the statistics table also.
Great. I will do this. Gavin PS I'll see if I can write this into the wiki.