<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial; font-size: 12pt; color: #000000'><P>We also have the same problem with many items that have no holdings. I'm not sure what we are doing wrong in our data entry, but we have the same issue and we want to work on this problem too. </P>
<P> </P>
<P>Janet Deavor<BR>----- Original Message -----<BR>From: "Barry Cannon" <bar@interleaf.ie><BR>To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz><BR>Sent: Tuesday, August 17, 2010 4:04:21 AM<BR>Subject: [Koha] Removing items with no barcodes<BR><BR></P>
<STYLE><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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;}
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-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></STYLE>
<DIV class=WordSection1>
<P class=MsoNormal>Hello,</P>
<P class=MsoNormal> We have a large number of items that have no barcodes attached and would like to remove them. I was considering just getting rid of them from mysql but I am concerned that this might have some problems elsewhere. Is there any utility we can use to remove these items and then, when they are gone, remove any bibs that are now item-less?</P>
<P class=MsoNormal> </P>
<P class=MsoNormal>Thanks</P>
<P class=MsoNormal>Barry </P>
<P class=MsoNormal> </P></DIV><BR>
<HR>
<FONT face=Arial color=gray size=1>This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. It is possible for data transmitted by email to be deliberately or accidentally corrupted or intercepted.<BR>For this reason, where the communication is by email, Interleaf Technology does not accept any responsibility for any breach of confidence which may arise through the use of this medium. This footnote also confirms that this email message has been swept for the presence of known computer viruses.<BR></FONT><BR>_______________________________________________<BR>Koha mailing list<BR>Koha@lists.katipo.co.nz<BR>http://lists.katipo.co.nz/mailman/listinfo/koha<BR></div></body></html>