[Koha-devel] Mass updating a field

[Roche III, Edward]

ran the sync items and it told me to re-index the db when done. I did that and then I tried setting the -prefix setting in the preferences. I can search the catalog by barcode and it is found and it tells me there is a copy available but when I try to checkout the book it says barcode is not found. I am using the internal db option instead of zebra and Koha 3.00 on Ubuntu 8.10 with LAMP.
 
Edward Roche
Technology Support/Network Admin
Solanco School District
edward_roche at solanco.k12.pa.us
717.786.2151

The greatest mistake you can make in life is to continually be afraid you will make one.
Elbert Hubbard

________________________________

From: koha-devel-bounces at lists.koha.org on behalf of Roche III, Edward
Sent: Fri 3/6/2009 4:30 PM
To: Mike Hafen; koha-devel at lists.koha.org
Subject: Re: [Koha-devel] Mass updating a field



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/4a513daa/attachment-0003.htm>