This will have to be done in two parts as you got it setup. First is to update the items table, then there is a command line script to update the marc and zebra.
First: update db1.items cross join tempdb.items using ( itemnumber ) set db1.items.barcode = tempdb.items.barcode; That should take care of the database update. I haven't tested it though, so wait on others on list to verify it. Second: /usr/local/koha/bin/maintenance/sync_items_in_marc_bib.pl That should update the marc records in the database and the zebra records. Good luck. On Fri, Mar 6, 2009 at 11:25 AM, Roche III, Edward < edward_ro...@solanco.k12.pa.us> wrote: > 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 > >
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
