[Koha] SQL repository?

Fri May 1 03:40:14 NZST 2009

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/eec89b5f/attachment.htm 