<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks Sharon, Lenora and all.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks again.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Nora<o:p></o:p></span></font></p>
<div>
<p><font size=2 color=navy face="Times New Roman"><span style='font-size:10.0pt;
color:navy'>________________________<br>
<br>
Nora Blake<br>
MassCat Manager<br>
<st1:address w:st="on"><st1:Street w:st="on">P.O. Box</st1:Street> 241</st1:address><br>
South <st1:place w:st="on"><st1:City w:st="on">Deerfield</st1:City>, <st1:State
w:st="on">MA</st1:State> <st1:PostalCode w:st="on">01373-0241</st1:PostalCode></st1:place><br>
Toll Free in MA: 866-MASSCAT (627-7228)<br>
Local Phone: 413-665-5511<br>
Fax: 413-665-6776<br>
Email: nblake@masscat.org<br>
Website: <a href="http://www.masscat.org">http://www.masscat.org</a><br>
AIM: vegancatwoman<br>
Skype: veganlibrarian<br>
Skype: nora.blake</span></font><font color=navy><span style='color:navy'> </span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Sharon Moreland
[mailto:smoreland@nekls.org] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, April 30, 2009
11:40 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Lenora Oftedahl;
nblake@masscat.org<br>
<b><span style='font-weight:bold'>Cc:</span></b> koha@lists.katipo.co.nz<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [Koha] SQL
repository?</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Looks like Nora Blake
beat us to that idea!<br>
<br>
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.<br>
<br>
SELECT count(i.biblionumber) as added, i.itype, i.homebranch,<br>
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<br>
<br>
<st1:City w:st="on"><st1:place w:st="on">Sharon</st1:place></st1:City><o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On Thu, Apr 30, 2009 at 10:12 AM, Lenora Oftedahl <<a
href="mailto:oftl@critfc.org" target="_blank">oftl@critfc.org</a>> wrote:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>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.<br>
<br>
>>> Sharon Moreland <<a href="mailto:smoreland@nekls.org"
target="_blank">smoreland@nekls.org</a>> 04/30/09 8:15 AM >>><o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I was fuzzy on which 'module' the reports I added this morning belong
to, so<br>
I sort of guessed that:<br>
<br>
"FROM items" had to do with the Catalog and<br>
"FROM borrowers" sometimes went to Circulation and other times just
into<br>
Patrons<br>
<br>
On the NExpress<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Reports<<a
href="http://www.nexpresslibrary.org/training/reports-training/" target="_blank">http://www.nexpresslibrary.org/training/reports-training/</a>>page,<o:p></o:p></span></font></p>
<div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>I have the statements
grouped by use => Bibliographic/Catalog<br>
maintenance, statistical reports, and patron-related reports<br>
<br>
Also, can we include on that SQL library wiki page a 'wish list' of reports<br>
we'd like to have but don't? For example, I would love a SQL statement
that<br>
recreates the Circulation Wizard report output, but that combines Issues and<br>
Renewals into one number. I really hate running that wizard twice for
each<br>
of our 20+ libraries to get TRUE monthly circ stats.<br>
<br>
<st1:City w:st="on"><st1:place w:st="on">Sharon</st1:place></st1:City><br>
<br>
On Thu, Apr 30, 2009 at 7:04 AM, <<a href="mailto:rafael.antonio@sapo.pt"
target="_blank">rafael.antonio@sapo.pt</a>> wrote:<br>
<br>
> Nicole,<br>
><br>
> We could begin adding SQL scripts but later try to organize them by<br>
> modules - catalog, loans, management..<br>
> If they grow in number this could be a better aproach.<br>
><br>
> Regards,<br>
><br>
> Rafael Antonio<br>
><br>
> Citando Nicole Engard <<a href="mailto:nicole.engard@liblime.com"
target="_blank">nicole.engard@liblime.com</a>>:<br>
><br>
> > What do you mean? All you have to do is register for the wiki
to add<br>
> > your own reports.<br>
> ><br>
> > PS. Remember to click REPLY TO ALL so that everyone gets your replies
:)<br>
> ><br>
> > ---<br>
> ><br>
> > Nicole C. Engard<br>
> > Open Source Evangelist, LibLime<br>
> > (888) Koha ILS (564-2457) ext. 714<br>
> > <a href="mailto:nce@liblime.com" target="_blank">nce@liblime.com</a><br>
> > AIM/Y!/Skype: nengard<br>
> ><br>
> > <a href="http://liblime.com" target="_blank">http://liblime.com</a><br>
> > <a href="http://blogs.liblime.com/open-sesame/" target="_blank">http://blogs.liblime.com/open-sesame/</a><br>
> ><br>
> ><br>
> ><br>
> > On Thu, Apr 30, 2009 at 7:31 AM, <<a
href="mailto:rafael.antonio@sapo.pt" target="_blank">rafael.antonio@sapo.pt</a>>
wrote:<br>
> >> Nicole,<br>
> >><br>
> >> This is a very good help.<br>
> >> May be someone can create a general structure where people can
add SQL<br>
> >> Regards,<br>
> >><br>
> >> Rafael<br>
> >><br>
> >> Citando Nicole Engard <<a
href="mailto:nicole.engard@liblime.com" target="_blank">nicole.engard@liblime.com</a>>:<br>
> >><br>
> >>> You guys rock!!!<br>
> >>><br>
> >>> For those who don't know how to find it - here's the link:<br>
> >>> <a href="http://wiki.koha.org/doku.php?id=sql_library"
target="_blank">http://wiki.koha.org/doku.php?id=sql_library</a><br>
> >>><br>
> >>> I will add this to the manual !!!!<br>
> >>><br>
> >>> ---<br>
> >>><br>
> >>> Nicole C. Engard<br>
> >>> Open Source Evangelist, LibLime<br>
> >>> (888) Koha ILS (564-2457) ext. 714<br>
> >>> <a href="mailto:nce@liblime.com" target="_blank">nce@liblime.com</a><br>
> >>> AIM/Y!/Skype: nengard<br>
> >>><br>
> >>> <a href="http://liblime.com" target="_blank">http://liblime.com</a><br>
> >>> <a href="http://blogs.liblime.com/open-sesame/"
target="_blank">http://blogs.liblime.com/open-sesame/</a><br>
> >>><br>
> >>><br>
> >>><br>
> >>> 2009/4/29 Sharon Moreland <<a
href="mailto:smoreland@nekls.org" target="_blank">smoreland@nekls.org</a>>:<br>
> >>>><br>
> >>>> Give me a few days, but I will get the NExpress SQL
statements added<br>
> to<br>
> >>>> the<br>
> >>>> wiki. Good job Lenora!<br>
> >>>><br>
> >>>> <st1:City w:st="on"><st1:place w:st="on">Sharon</st1:place></st1:City><br>
> >>>><br>
> >>>> On Wed, Apr 29, 2009 at 10:55 AM, Lenora Oftedahl <<a
href="mailto:OFTL@critfc.org" target="_blank">OFTL@critfc.org</a>><br>
> >>>> wrote:<br>
> >>>>><br>
> >>>>> OK. I put my money where my mouth is and created a
SQL library page<br>
> in<br>
> >>>>> the<br>
> >>>>> Koha Wiki as challenged by MJ Ray. I've even
got an example up for<br>
> >>>>> others<br>
> >>>>> to follow.<br>
> >>>>><br>
> >>>>> Lenora<br>
> >>>>> StreamNet Regional Librarian<br>
> >>>>> <st1:place w:st="on">Columbia River</st1:place>
Inter-Tribal Fish Commission<br>
> >>>>><br>
> >>>>> >>> MJ Ray <<a
href="mailto:mjr@phonecoop.coop" target="_blank">mjr@phonecoop.coop</a>>
4/29/2009 1:00 AM >>><br>
> >>>>> "Lenora Oftedahl" <<a
href="mailto:OFTL@critfc.org" target="_blank">OFTL@critfc.org</a>> wrote:<br>
> >>>>> > Hello all. I haven't seen an announcement, but
there was talk at<br>
> the<br>
> >>>>> > Koha Conference that a SQL repository would be
developed so we<br>
> could<br>
> >>>>> > post our most excellent SQL reports and wouldn't
all have to write<br>
> the<br>
> >>>>> > same report request over and over.<br>
> >>>>><br>
> >>>>> Why not add them to <a href="http://wiki.koha.org"
target="_blank">http://wiki.koha.org</a> or <a href="http://contribs.koha.org"
target="_blank">http://contribs.koha.org</a><br>
> >>>>> depending on if they're simple SQL (wiki) or scripts
too (contribs)?<br>
> >>>>><br>
> >>>>> Confused,<br>
> >>>>> --<br>
> >>>>> MJ Ray (slef). LMS developer and supporter for
a small, friendly<br>
> >>>>> worker cooperative <a href="http://www.ttllp.co.uk/"
target="_blank">http://www.ttllp.co.uk/</a> <a href="http://mjr.towers.org.uk/"
target="_blank">http://mjr.towers.org.uk/</a><br>
> >>>>> (Notice <a href="http://mjr.towers.org.uk/email.html"
target="_blank">http://mjr.towers.org.uk/email.html</a>) tel:+44-844-4437-237<br>
> >>>>> _______________________________________________<br>
> >>>>> Koha mailing list<br>
> >>>>> <a href="mailto:Koha@lists.katipo.co.nz"
target="_blank">Koha@lists.katipo.co.nz</a><br>
> >>>>> <a
href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
> >>>>><br>
> >>>>> _______________________________________________<br>
> >>>>> Koha mailing list<br>
> >>>>> <a href="mailto:Koha@lists.katipo.co.nz"
target="_blank">Koha@lists.katipo.co.nz</a><br>
> >>>>> <a
href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
> >>>><br>
> >>>><br>
> >>>><br>
> >>>> --<br>
> >>>> Sharon Moreland<br>
> >>>> Technology Consultant<br>
> >>>> <st1:place w:st="on">Northeast Kansas</st1:place> Library
System<br>
> >>>><br>
> >>>> _______________________________________________<br>
> >>>> Koha mailing list<br>
> >>>> <a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
> >>>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha"
target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
> >>>><br>
> >>>><br>
> >>> _______________________________________________<br>
> >>> Koha mailing list<br>
> >>> <a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
> >>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha"
target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
> >>><br>
> >><br>
> >><br>
> ><br>
><br>
> _______________________________________________<br>
> Koha mailing list<br>
> <a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
><br>
<br>
<br>
<br>
--<br>
Sharon Moreland<br>
Technology Consultant<br>
<st1:place w:st="on">Northeast Kansas</st1:place> Library System<o:p></o:p></span></font></p>
</div>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br clear=all>
<br>
-- <br>
Sharon Moreland<br>
Technology Consultant<br>
<st1:place w:st="on">Northeast Kansas</st1:place> Library System<o:p></o:p></span></font></p>
</div>
</body>
</html>