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?"
