[Koha] Post Import of field update issue

Roche III, Edward edward_roche at solanco.k12.pa.us
Wed Mar 25 02:27:39 NZDT 2009


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

 

   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090324/93798dc3/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Circulation-Checkout.jpg
Type: image/jpeg
Size: 10042 bytes
Desc: Circulation-Checkout.jpg
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20090324/93798dc3/attachment-0002.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: checkout_screen.jpg
Type: image/jpeg
Size: 22192 bytes
Desc: checkout_screen.jpg
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20090324/93798dc3/attachment-0003.jpg 


More information about the Koha mailing list