[Koha] importing issues into Koha

Gavin McCullagh gmccullagh at gmail.com
Sat Aug 12 23:45:49 NZST 2006


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.



More information about the Koha mailing list