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@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_roche@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@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:mdhafen@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_roche@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