[Koha] SQL repository?

Fri May 1 03:47:58 NZST 2009

Thanks Sharon, Lenora and all.

I added a couple of our more interesting reports to the list and loaded
in several wishes too!  Getting administrative reports that group all
the branches together is a big goal for me.  I can't write and run
separate reports for 90 sites!

Thanks again.

Nora

________________________

Nora Blake
MassCat Manager
P.O. Box 241
South Deerfield, MA 01373-0241
Toll Free in MA: 866-MASSCAT (627-7228)
Local Phone: 413-665-5511
Fax: 413-665-6776
Email: nblake at masscat.org
Website: http://www.masscat.org
AIM: vegancatwoman
Skype: veganlibrarian
Skype: nora.blake 

________________________________

From: Sharon Moreland [mailto:smoreland at nekls.org] 
Sent: Thursday, April 30, 2009 11:40 AM
To: Lenora Oftedahl; nblake at masscat.org
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] SQL repository?

Looks like Nora Blake beat us to that idea!

Nora - here's the statement for total collection size that Nichole wrote
for us last year:  If you don't care about the shelving location, you
can delete "i.location" from the statement.

SELECT count(i.biblionumber) as added, i.itype, i.homebranch,
i.location from items i WHERE i.dateaccessioned < '2009-01-01'  GROUP BY
i.homebranch,i.itype,i.location ORDER BY i.homebranch,i.itype,i.location
asc

Sharon

On Thu, Apr 30, 2009 at 10:12 AM, Lenora Oftedahl <oftl at critfc.org>
wrote:

If you leave the SQL column blank and put in the notes that this is a
wish for the future, I think that would work.

>>> Sharon Moreland <smoreland at nekls.org> 04/30/09 8:15 AM >>>

I was fuzzy on which 'module' the reports I added this morning belong
to, so
I sort of guessed that:

"FROM items" had to do with the Catalog and
"FROM borrowers" sometimes went to Circulation and other times just into
Patrons

On the NExpress

Reports<http://www.nexpresslibrary.org/training/reports-training/>page,

I have the statements grouped by use => Bibliographic/Catalog
maintenance, statistical reports, and patron-related reports

Also, can we include on that SQL library wiki page a 'wish list' of
reports
we'd like to have but don't?  For example, I would love a SQL statement
that
recreates the Circulation Wizard report output, but that combines Issues
and
Renewals into one number.  I really hate running that wizard twice for
each
of our 20+ libraries to get TRUE monthly circ stats.

Sharon

On Thu, Apr 30, 2009 at 7:04 AM, <rafael.antonio at sapo.pt> wrote:

> Nicole,
>
> We could begin adding SQL scripts but later try to organize them by
> modules - catalog, loans, management..
> If they grow in number this could be a better aproach.
>
> Regards,
>
> Rafael Antonio
>
> Citando Nicole Engard <nicole.engard at liblime.com>:
>
> > What do you mean?  All you have to do is register for the wiki to
add
> > your own reports.
> >
> > PS. Remember to click REPLY TO ALL so that everyone gets your
replies :)
> >
> > ---
> >
> > Nicole C. Engard
> > Open Source Evangelist, LibLime
> > (888) Koha ILS (564-2457) ext. 714
> > nce at liblime.com
> > AIM/Y!/Skype: nengard
> >
> > http://liblime.com
> > http://blogs.liblime.com/open-sesame/
> >
> >
> >
> > On Thu, Apr 30, 2009 at 7:31 AM,  <rafael.antonio at sapo.pt> wrote:
> >> Nicole,
> >>
> >> This is a very good help.
> >> May be someone can create a general structure where people can add
SQL
> >> Regards,
> >>
> >> Rafael
> >>
> >> Citando Nicole Engard <nicole.engard at liblime.com>:
> >>
> >>> You guys rock!!!
> >>>
> >>> For those who don't know how to find it - here's the link:
> >>> http://wiki.koha.org/doku.php?id=sql_library
> >>>
> >>> I will add this to the manual !!!!
> >>>
> >>> ---
> >>>
> >>> Nicole C. Engard
> >>> Open Source Evangelist, LibLime
> >>> (888) Koha ILS (564-2457) ext. 714
> >>> nce at liblime.com
> >>> AIM/Y!/Skype: nengard
> >>>
> >>> http://liblime.com
> >>> http://blogs.liblime.com/open-sesame/
> >>>
> >>>
> >>>
> >>> 2009/4/29 Sharon Moreland <smoreland at nekls.org>:
> >>>>
> >>>> Give me a few days, but I will get the NExpress SQL statements
added
> to
> >>>> the
> >>>> wiki.  Good job Lenora!
> >>>>
> >>>> Sharon
> >>>>
> >>>> On Wed, Apr 29, 2009 at 10:55 AM, Lenora Oftedahl
<OFTL at critfc.org>
> >>>> wrote:
> >>>>>
> >>>>> OK. I put my money where my mouth is and created a SQL library
page
> in
> >>>>> the
> >>>>> Koha Wiki as challenged by MJ Ray.  I've even got an example up
for
> >>>>> others
> >>>>> to follow.
> >>>>>
> >>>>> Lenora
> >>>>> StreamNet Regional Librarian
> >>>>> Columbia River Inter-Tribal Fish Commission
> >>>>>
> >>>>> >>> MJ Ray <mjr at phonecoop.coop> 4/29/2009 1:00 AM >>>
> >>>>> "Lenora Oftedahl" <OFTL at critfc.org> wrote:
> >>>>> > Hello all. I haven't seen an announcement, but there was talk
at
> the
> >>>>> > Koha Conference that a SQL repository would be developed so we
> could
> >>>>> > post our most excellent SQL reports and wouldn't all have to
write
> the
> >>>>> > same report request over and over.
> >>>>>
> >>>>> Why not add them to http://wiki.koha.org or
http://contribs.koha.org
> >>>>> depending on if they're simple SQL (wiki) or scripts too
(contribs)?
> >>>>>
> >>>>> Confused,
> >>>>> --
> >>>>> MJ Ray (slef).  LMS developer and supporter for a small,
friendly
> >>>>> worker cooperative http://www.ttllp.co.uk/
http://mjr.towers.org.uk/
> >>>>> (Notice http://mjr.towers.org.uk/email.html)
tel:+44-844-4437-237
> >>>>> _______________________________________________
> >>>>> Koha mailing list
> >>>>> Koha at lists.katipo.co.nz
> >>>>> http://lists.katipo.co.nz/mailman/listinfo/koha
> >>>>>
> >>>>> _______________________________________________
> >>>>> Koha mailing list
> >>>>> Koha at lists.katipo.co.nz
> >>>>> http://lists.katipo.co.nz/mailman/listinfo/koha
> >>>>
> >>>>
> >>>>
> >>>> --
> >>>> Sharon Moreland
> >>>> Technology Consultant
> >>>> Northeast Kansas Library System
> >>>>
> >>>> _______________________________________________
> >>>> Koha mailing list
> >>>> Koha at lists.katipo.co.nz
> >>>> http://lists.katipo.co.nz/mailman/listinfo/koha
> >>>>
> >>>>
> >>> _______________________________________________
> >>> Koha mailing list
> >>> Koha at lists.katipo.co.nz
> >>> http://lists.katipo.co.nz/mailman/listinfo/koha
> >>>
> >>
> >>
> >
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>

--
Sharon Moreland
Technology Consultant
Northeast Kansas Library System

-- 
Sharon Moreland
Technology Consultant
Northeast Kansas Library System

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090430/4e46ab73/attachment-0001.htm 