Good Morning All

I am writing to both groups because I am not sure which one would be the best option for this problem.

I have to do a mass update of our barcode field to match up what our barcodes actually are as opposed to what Follett spits out in its export. Before I do the field update I can check out books with no problem with the current barcode format. After I do the update, when I enter the barcode to checkout for the student  and hit Checkout then it automatically sends me back to the Circulation – Checkout page and never assigns the book to the patron. Here are the steps I do when updating the field:

· Export data to a tab delimited file (itemnumber and barcode)

· Open file in Excel and fix the barcode field (From T0012345 to T 12345)

· Save as file again as Tab Delimited

· Go to WebMin in the browser and create a temp table to hold the updated info

· Import the data to the temp table with no issues

· Run the following SQL expression to update the barcode field in the items table with the data that is in the temp table linked by itemnumber

o update items a
inner join temp b on a.itemnumber = b.itemnumber
set a.barcode = b.barcode

· Everything copies over, I spot check a couple records to make sure no issues.

· I run the following script from terminal

o perl /usr/share/koha/bin/maintenance/sync_items_in_marc_bib.pl --run-update

· Then run:

o perl /usr/share/koha/bin/migration_tools/rebuild_nozebra.pl

· I go into Koha and test the checkout function (see Checkout Image Attachment) and I get the Circulation – Checkout page (see Circulation-Checkout Attachment)

Should I be doing this update a different way????

Thanks

Ed

Edward J. Roche

Network Administrator

Solanco School District

717.786.2151 x2437

"At the End of the Day, Did You Play to Win or Not to Lose?"