Good Afternoon All
I posted on the Koha users list as well but figured I would try here as
to.
I am in need of a SQL statement to update my barcode field in the items
table. When we exported our catalog from Follett it removed a space that
was in out barcodes so now when we try to scan an item it is not being
found because the barcode field in Koha is missing the space. What I
have done so far:
1) Export from the items table: itemnumber and barcode
2) Added the space back into the barcode field
3) Created a temp table in the koha db
4) Imported the data into the temp table
I now need to move the data from the temp table over to the items table
to update the barcode field.
Any thoughts?
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?"
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha.org
http://lists.koha.org/mailman/listinfo/koha-devel
