[Koha-devel] Mass updating a field

[Roche III, Edward]

Happy Sunday All

 

It seems that koha isn't liking the fact that we have a space between
the leading T and the rest of our barcode. I did a test and took the
space out of one of the barcodes and koha recognized the code. Does
anyone know why this is happening or a way to get a round it? This is a
big deal since we have 16000+  titles in out HS library and need this to
work. Any thoughts would be great.

 

Also, I did try changing the itemBarcodeInputFilter with no luck.

 

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: Roche III, Edward 
Sent: Friday, March 06, 2009 10:24 PM
To: Roche III, Edward; Mike Hafen; koha-devel at lists.koha.org
Subject: RE: [Koha-devel] Mass updating a field

 

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/20090308/50910626/attachment-0003.htm>