Re: [Koha-devel] Mass updating a field

2009-03-06 Thread 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 fou

Re: [Koha-devel] Mass updating a field

2009-03-06 Thread Roche III, Edward
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

Re: [Koha-devel] Mass updating a field

2009-03-06 Thread Mike Hafen
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 c

[Koha-devel] Mass updating a field

2009-03-06 Thread Roche III, Edward
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 i

Re: [Koha-devel] Problem with 007 framework?

2009-03-06 Thread Wagner, Jane
Thanks. We will look at doing a patch, but I'll put it up on bugzilla in the meantime so the problem is out there. Maybe someone has already been working on a solution (she said hopefully). Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Golds

Re: [Koha-devel] Problem with 007 framework?

2009-03-06 Thread Eric Bégin
Jane, The best thing would be you to update the file and submit it as a patch. (to know how to submit a patch, get a look at http://wiki.koha.org/doku.php?id=en:development:git_usage) If you prefer not doing the modification yourself, then yes, you should fill a bug on bugzilla. Thanks, Eri

Re: [Koha-devel] Problem with 007 framework?

2009-03-06 Thread Wagner, Jane
Thanks -- that at least identifies the location of the problem. The book/text values appear to be hardcoded in the marc21_field_007.tmpl file itself, in both versions 3.00.00.107 and 3.01.00.013. So that file should be updated somehow to include all the possible 007 values based on framework s

Re: [Koha-devel] Problem with 007 framework?

2009-03-06 Thread Eric Bégin
Jane, When there is an elipsis after a field, this means that it use a value builder plugin. You can see which value builder is used for a field in the framework. Select your framework Click Subfields of the MARC field you want to modify. Click Edit Subfields. Click Show More Restrictions You

[Koha-devel] Problem with 007 framework?

2009-03-06 Thread Wagner, Jane
I'm not finding anything on bugzilla and I'm not quite sure if this is a bug, or if something's not configured right. Trying to original catalog a DVD, with the DVDs, VHS framework selected (but the same problem exists in all the frameworks). If you click the ellipse after the 007 Physical Descri