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?"
On 2009/03/25, at 2:27 AM, Roche III, Edward wrote:
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.
Should I be doing this update a different way????
a strange problem indeed... have you checked your error log ?
participants (2)
-
Mason James -
Roche III, Edward