<HTML dir=ltr><HEAD>
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7000.0"></HEAD>
<BODY>
<DIV dir=ltr id=idOWAReplyText47587>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial>I am sending to both lists in case this needs to be addressed with a program update.</FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial>Every time I update our barcodes in Koha (T0012345 to T 12345) it no longer recognizes the barcodes when trying to </FONT><FONT color=#000000 size=2 face=Arial>check out. I have tried each of the prefix options and we even added a blank option but that still isn't working, I </FONT></DIV>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial>export the itemnumber and barcode, update the barcode and reimport to the DB to a temp table then update the items </FONT><FONT color=#000000 size=2 face=Arial>table with sql expression. The records are updated and then I run the following script:</FONT></DIV>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial>perl </FONT><FONT color=#000000 size=2 face=Arial>/usr/share/koha/bin/maintenance/sync_items_in_marc_bib.pl --run-update</FONT></DIV>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial>It runs for like 6 hours (almost 16k </FONT><FONT color=#000000 size=2 face=Arial>records) it gives following results:</FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=2 face=Arial>Embedded item synchronization report<BR>------------------------------------<BR>Number of bibs checked: 13214<BR>Number of bibs modified: 13167<BR>Number of item fields removed from bibs: 15698<BR>Number of item fields added to bibs: 15698<BR>Number of bibs with errors: 0<BR></FONT></DIV><FONT color=#000000 size=2 face=Arial>
<DIV dir=ltr><BR>I go back into Koha and try to checkout and I get a yellowish box that say barcodes not found. I need to get this </DIV>
<DIV dir=ltr>to work because rebarcoding is out of the question with the number of items we have in our library.</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Thanks in advance!<BR>Ed</FONT></DIV>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial></FONT> </DIV></DIV>
<DIV dir=ltr id=idSignature97728><PRE>Edward Roche
Technology Support/Network Admin
Solanco School District
edward_roche@solanco.k12.pa.us
717.786.2151
The greatest mistake you can make in life is to continually be afraid you will make one.
Elbert Hubbard</PRE></DIV></BODY></HTML>