[Koha-devel] Mass updating a field

Mon Mar 9 18:23:11 CET 2009

Yeah, that's a problem.  I guess for now it'll have to be done with SQL.
I will make a bug for this one.

UPDATE systempreferences SET options = 'none|whitespace|T-prefix|cuecat'
where variable = 'itemBarcodeInputFilter';

That should give you the option at least.  Or you could do it directly
with this:

UPDATE systempreferences SET value = '' where variable =
'itemBarcodeInputFilter';

On Mon, 2009-03-09 at 13:08 -0400, Roche III, Edward wrote:
> Thanks Mike, but how do I turn the filter off? Is there a preference to turn filtering off other then the itemBarcodeInputFilter? This field only has 3 options and none of them are an off/no/blank just T-Prefix, Whitespace and Cuecat.
> 
> 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?" 
> 
>                    
> 
> 
> 
> -----Original Message-----
> From: Michael Hafen [mailto:mdhafen at tech.washk12.org] 
> Sent: Monday, March 09, 2009 12:13 PM
> To: Roche III, Edward
> Subject: RE: [Koha-devel] Mass updating a field
> 
> Looking at the source code it seems the T-prefix barcode filter is not
> designed for barcodes with a space after the T.  I would suggest not
> using a filter in this case.  It seems like what is in the database and
> what is encoded in the barcode should be the same at this point.
> 
> Actually you should confirm that first.  My suggestion would be to scan
> a bunch of book barcodes into notepad or some such.  That way you can
> see what is actually encoded in the barcode.  I have seen many cases
> where I work of the text on the barcode label being different from
> what's actually in the barcode image on the label.
> 
> Good luck.
> 
> On Sun, 2009-03-08 at 17:41 -0400, Roche III, Edward wrote:
> > 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
> > 
> > 
> >  
> > 
> > 
-- 
Michael Hafen
Systems Analyst and Programmer
Washington County School District
Utah, USA

for Koha checkout
http://koha-dev.washk12.org
or
git://koha-dev.washk12.org/koha