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@masscat.org Website: http://www.masscat.org AIM: vegancatwoman Skype: veganlibrarian Skype: nora.blake ________________________________ From: Sharon Moreland [mailto:smoreland@nekls.org] Sent: Thursday, April 30, 2009 11:40 AM To: Lenora Oftedahl; nblake@masscat.org Cc: koha@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@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@nekls.org> 04/30/09 8:15 AM >>>
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@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@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@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@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@liblime.com AIM/Y!/Skype: nengard
http://liblime.com http://blogs.liblime.com/open-sesame/
2009/4/29 Sharon Moreland <smoreland@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@critfc.org> wrote:
OK. I put my money where my mouth is and created a SQL library
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@sapo.pt> wrote: page
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@phonecoop.coop> 4/29/2009 1:00 AM >>> "Lenora Oftedahl" <OFTL@critfc.org> wrote: > Hello all. I haven't seen an announcement, but there was talk at
> 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
in the 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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Sharon Moreland Technology Consultant Northeast Kansas Library System
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@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