Trying it now.
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?"
From: Mike Hafen [mailto:mdhafen at tech.washk12.org]
Sent: Friday, March 06, 2009 4:07 PM
To: Roche III, Edward; koha-devel at lists.koha.org
Subject: Re: [Koha-devel] Mass updating a field
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_roche at 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 at lists.koha.org
http://lists.koha.org/mailman/listinfo/koha-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20090306/1ace4755/attachment-0003.htm>