- Koha-devel - lists.koha-community.org

(no subject)
by Edisnel Carrazana Castro 09 Mar '09

09 Mar '09

Greetings, I have been installed koha 3.00.01, using UNIMARC, but during the import of records with bulkmarcimport, I have the fallowing error: <".Use of uninitialized value in length at C4/Biblio.pm line 3130, <GEN10> line 207.">. I did the same with koha3.00 and all good. I will appreciate your answers

1 1

Bulkmarcimport and authorities
by Jason Macki 09 Mar '09

09 Mar '09

Hello, I'm converting data from our old library system into Koha version 3, running on Linux, and I'm having a problem with authorities. First, I did a bulk import, using bulkmarcimport.pl, then I ran rebuild_nozebra.pl. It was my understanding that rebuild_nozebra.pl would build the authorities and make them searchable. When that script runs, it displays a message reading "building authorities index". But when I search for authorities in auth_finder.pl (the window that appears when you click on the ... link after an authority field), it always gives zero results. If I open the record in the Koha interface and save it again, the authorities for the saved record do come up in a search. Is there some other script I should run to build the authorities from the bibliographic information already imported? Alternately, since opening a record for editing and saving it solves my problem, is there a script I can run to reproduce the effect of opening and saving a record through the Koha interface? The idea being that I could write a script (or better yet, use an existing one) to cycle through each record and re-save it. Thanks for your help, Jason

1 0

Re: [Koha-devel] Mass updating a field
by Michael Hafen 09 Mar '09

09 Mar '09

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(a)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(a)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(a)lists.koha.org on behalf of Roche III, Edward > > Sent: Fri 3/6/2009 4:30 PM > > To: Mike Hafen; koha-devel(a)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(a)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(a)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(a)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

1 0

Question about Koha 3.0 Urdu Support!
by Muahmmad Wasim 09 Mar '09

09 Mar '09

Hi, I'm trying to incorporate Urdu language support in Koha. I just want to save a record in "Urdu". But when, in interanet section, I click on "Add MARC Record", and enter my record in urdu, it gives an error " The following fatal error has occurred: Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2133. " Can anyone help me in this regard? Note: We are using UTF-8 encoding scheme. Thanks, Muhammad Wasim

2 1

Koha 3.0 + apache2 problem
by Zico 09 Mar '09

09 Mar '09

I am trying to install Koha 3.0 in Debian 4.0 r0. Everything went well... perl dependencies configuration, cpan configuration, mysql configuration, koha and zebra. But, at last, when i tries to open my server with http://koha:8080/ then nothing comes. Plus, if i tries to restart my apache2 then, this error comes: *debian:~# /etc/init.d/apache2 restart Forcing reload of web server (apache2)...[Mon Mar 09 07:26:12 2009] [error] (EAI 2)Name or service not known: Could not resolve host name __WEBSERVER_IP__:__WEB SERVER_PORT__ -- ignoring! Warning: DocumentRoot [/etc/apache2/__OPAC_WWW_DIR__] does not exist [Mon Mar 09 07:26:13 2009] [error] (EAI 2)Name or service not known: Could not r esolve host name __WEBSERVER_IP__:__WEBSERVER_PORT_LIBRARIAN__ -- ignoring! Warning: DocumentRoot [/etc/apache2/__INTRANET_WWW_DIR__] does not exist Syntax error on line 45 of /etc/apache2/sites-enabled/koha: The port number "__WEBSERVER_HOST__:__WEBSERVER_PORT_LIBRARIAN__" is outside the appropriate range (i.e., 1..65535). failed! * Can you please help me? -- Best, Zico

2 2

Mass updating a field
by Roche III, Edward 08 Mar '09

08 Mar '09

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?"

2 4

items.notforloan and holds
by Owen Leonard 05 Mar '09

05 Mar '09

I've been trying to figure out why my patrons can't place holds on on-order items (items.notforloan = -1) from the OPAC. If found this in opac-reserve.pl (line 138): if (!$itm->{'notforloan'} && !($itm->{'itemnotforloan'} > 0)){ $forloan=1; } Trying to find out what the difference was between $itm->{'notforloan'} and $itm->{'itemnotforloan'} I checked GetItemsInfo() in Items.pm. GetItemsInfo() SELECTs both "items.*" and "items.notforloan as itemnotforloan." So $itm->{'notforloan'} and $itm->{'itemnotforloan'} are the same thing? Changing line 138 of opac-reserve.pl to if ($itm->{'notforloan'} <1){ $forloan=1; } ...would be correct wouldn't it? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 1

Re: [Koha-devel] Coverity - creating OS software maps - (automated defect detection)
by Colin Campbell 05 Mar '09

05 Mar '09

It's a static analysis tool which works on projects in C, C++ and Java. It was originally developed to analyse the linux kernel codebase. As such the Koha code is not a candidate, but many of the projects Koha relies on (Perl, Apache) are already using it Cheers Colin

2 1

Sorting Authority Headings
by Eric Bégin 05 Mar '09

05 Mar '09

Hi, Is there a way to sort the result of the authorities headings and subheadings? Let's say we have the following geographic locations/sublocations Canada » Quebec Canada » Ontario Caanda » British Columbia United States » Maine United States » California United States » New York The location are sorted, but not the sublocations. Any clue how we could make the sort correctly? Thanks, Eric _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel

3 3

Converting to Koha
by Dale Copps 04 Mar '09

04 Mar '09

I am looking into converting my ILS from EOSi GLAS (Cat, Circ, Serials) to Koha and am seeking a consultant with whom I could discuss issues such as data conversion, importation, setup, etc. I have subscribed to this list but have not had the subscription confirmed, so please respond to me off list. Thanks. -Dale ----------------------------------------------- Dale Copps, Library Manager Creare Inc., 16 Great Hollow Road Hanover, NH 03755 603 640-2384 fax: 603 643-4657 dgc(a)creare.com www.creare.com -----------------------------------------------

1 0