[Koha] SQL repository?

[Lenora Oftedahl]

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