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:mdha...@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@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_ro...@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-boun...@lists.koha.org on behalf of Roche III, Edward > > Sent: Fri 3/6/2009 4:30 PM > > To: Mike Hafen; koha-devel@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:mdha...@tech.washk12.org] > > Sent: Friday, March 06, 2009 4:07 PM > > To: Roche III, Edward; koha-devel@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_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 > > > > > > > > > > -- 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 _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
