<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</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=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Hi everyone-<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>We’re a hosted Koha library using whatever the most
recent release of the product is. I’ve been asked if I can generate a
report through Koha that would tell us all the duplicate items in the
collection. Try as I might, I can’t seem to figure out a simple way of
doing this without pulling a report of every single item, sorting by call
number, and sifting through the tens of thousands of items. Has anyone
generated a report like this? It wouldn’t be enough to pull titles that have
more than one record because then we’ll get multi-volume sets too. And
there isn’t a single identifying entry in the call number (e.g. pt. or
c.) because there hasn’t been any consistency with our tracking of
duplicate items. If anyone has ideas, please let me know. I’ll only be
able to copy/paste generated SQL into the Report Wizard. We have no access to
the backend of the system.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thank you!<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>~Joy<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Joy M. Banks<o:p></o:p></p>
<p class=MsoNormal>Catalog Librarian<o:p></o:p></p>
<p class=MsoNormal>Roux Library<o:p></o:p></p>
<p class=MsoNormal>Florida Southern College<o:p></o:p></p>
<p class=MsoNormal>111 Lake Hollingsworth Dr.<o:p></o:p></p>
<p class=MsoNormal>Lakeland, FL 33801<o:p></o:p></p>
<p class=MsoNormal>(863)680-4736<o:p></o:p></p>
<p class=MsoNormal>jbanks@flsouthern.edu<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>