<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 14 (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]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Arial","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:FR-CH;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FR-CH" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Hi Beverley and Nora<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Arial","sans-serif"">Thank you, now have the list I need.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Arial","sans-serif"">Thanks again<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Arial","sans-serif"">Lisa<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:18.0pt;line-height:12.0pt;text-autospace:none">
<span style="font-family:"Arial","sans-serif";color:black"><img width="227" height="51" id="Picture_x0020_1" src="cid:image002.jpg@01CC2144.B13E61D0" alt="Description: Description: Description: CR_logo_POS_COULEUR b"></span><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:18.0pt;line-height:12.0pt;text-autospace:none">
<b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="margin-left:18.0pt;line-height:12.0pt;text-autospace:none">
<b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="margin-left:18.0pt;line-height:12.0pt;text-autospace:none">
<b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">LISA PEEL, PGDip, MA.</span></b><b><span style="color:black"><o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:18.0pt;line-height:12.0pt;text-autospace:none">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">Librarian</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:18.0pt;line-height:12.0pt;text-autospace:none">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">César Ritz Colleges Switzerland<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:18.0pt;line-height:12.0pt;text-autospace:none">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">1897 Le Bouveret - Switzerland<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:18.0pt;line-height:12.0pt;text-autospace:none">
<span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">Tel: +41 24 482 82 82 Fax: +41 24 482 82 80<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:18.0pt;line-height:12.0pt;text-autospace:none">
<span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">E-mail:
<b><a href="mailto:hortense.hofer@ritz.edu">lisa.peel@ritz.edu</a></b><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:18.0pt;line-height:12.0pt;text-autospace:none">
<span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><a href="http://www.ritz.edu/">http://www.ritz.edu</a> -
<a href="http://www.culinaryarts.ch/">http://www.culinaryarts.ch</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Church, Beverly [mailto:bchurch@liblime.com]
<br>
<b>Sent:</b> 02 June 2011 16:24<br>
<b>To:</b> Peel Lisa<br>
<b>Cc:</b> Liz Rea; koha@lists.katipo.co.nz<br>
<b>Subject:</b> Re: [Koha] Help with report - again!<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Hi Lisa,<br>
<br>
Try the "copyrightdate" column in the "biblio" table.<br>
<br>
Bev<br clear="all">
</span><br>
* * * * <br>
Beverly Church <br>
LibLime Project Manager<br>
<br>
phone: 1-301-654-8088 ext. 292<br>
email: <a href="mailto:bchurch@liblime.com" target="_blank">bchurch@liblime.com</a><br>
skype: beverlychurch<br>
<br>
<o:p></o:p></p>
<div>
<p class="MsoNormal">2011/6/2 Peel Lisa <<a href="mailto:lisa.peel@ritz.edu">lisa.peel@ritz.edu</a>><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB">Hi Liz</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB">Thanks for the quick reply but there is still no data in the publication year column – is this something we have done wrong when cataloguing? There is definitely
data in the 260c field in the majority of our records.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB">Regards</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB">Lisa</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-color:-moz-use-text-color -moz-use-text-color">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US" style="font-size:10.0pt">From:</span></b><span lang="EN-US" style="font-size:10.0pt"> Liz Rea [mailto:<a href="mailto:lrea@nekls.org" target="_blank">lrea@nekls.org</a>]
<br>
<b>Sent:</b> 02 June 2011 16:03<br>
<b>To:</b> Peel Lisa<br>
<b>Cc:</b> koha list<br>
<b>Subject:</b> Re: [Koha] Help with report - again!</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Jun 2, 2011, at 8:45 AM, Peel Lisa wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hello<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB">I need to create a list which will give me details of all the items at one library including the year of publication. Have tried adding publication year to the
guided search but no data appears in the column.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB">Apologies for making such a basic request but I have been asked for the report to be done urgently!</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB">Any help appreciated</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB">Regards</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB">Lisa</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> </span><o:p></o:p></p>
</div>
<div style="margin-left:18.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt">
<span style="color:black"><image001.jpg></span><o:p></o:p></p>
</div>
<div style="margin-left:18.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt">
<b><span lang="EN-US" style="font-size:11.0pt;color:black"> </span></b><o:p></o:p></p>
</div>
<div style="margin-left:18.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt">
<b><span lang="EN-US" style="font-size:11.0pt;color:black"> </span></b><o:p></o:p></p>
</div>
<div style="margin-left:18.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt">
<b><span style="font-size:11.0pt;color:black">LISA PEEL, PGDip, MA.</span></b><o:p></o:p></p>
</div>
<div style="margin-left:18.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt">
<span style="font-size:11.0pt;color:black">Librarian</span><o:p></o:p></p>
</div>
<div style="margin-left:18.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt">
<span style="font-size:11.0pt;color:black">César Ritz Colleges Switzerland</span><o:p></o:p></p>
</div>
<div style="margin-left:18.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt">
<span style="font-size:11.0pt;color:black">1897 Le Bouveret - Switzerland</span><o:p></o:p></p>
</div>
<div style="margin-left:18.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt">
<span lang="EN-US" style="font-size:11.0pt;color:black">Tel: +41 24 482 82 82 Fax: +41 24 482 82 80</span><o:p></o:p></p>
</div>
<div style="margin-left:18.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt">
<span lang="EN-US" style="font-size:11.0pt;color:black">E-mail: <b><a href="mailto:hortense.hofer@ritz.edu" target="_blank">lisa.peel@ritz.edu</a></b></span><o:p></o:p></p>
</div>
<div style="margin-left:18.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt">
<span lang="EN-US" style="font-size:11.0pt;color:black"><a href="http://www.ritz.edu/" target="_blank">http://www.ritz.edu</a> - <a href="http://www.culinaryarts.ch/" target="_blank">http://www.culinaryarts.ch</a></span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt"> </span><o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><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><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">SELECT items.itemcallnumber, items.barcode, biblio.author, biblio.title, biblioitems.publicationyear FROM items JOIN biblio USING (biblionumber) join biblioitems USING (biblionumber)
WHERE items.homebranch='yourbranch' limit 150000 ORDER BY items.itemcallnumber asc<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">notes: <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Paste this into the reports "Create from SQL" section, and run from there.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">you'll want to put in your branch code for 'yourbranch'<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Set the limit to something above the maximum number of records you expect.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hope this helps!<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Liz Rea<br>
<a href="mailto:lrea@nekls.org" target="_blank">lrea@nekls.org</a><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><img border="0" width="312" height="80" id="_x0000_i1025" src="cid:image003.jpg@01CC2144.B13E61D0"><o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz">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><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>