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 >>> 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:
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/
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 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@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
On Thu, Apr 30, 2009 at 7:31 AM, <rafael.antonio@sapo.pt> wrote: 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