- Koha - lists.katipo.co.nz

Holds Queue question
by Sharon Moreland 18 Aug '10

18 Aug '10

Hello Koha and LibLime folks, We demonstrated PTFS Harley 1.1 to our member libraries today and they were anxious about how they will find the correct item to pull for transfer from the holds queue report. A bit of background, we currently use an older version of the holds queue that we maintain by editing our templates (currently on Koha 3.01.00.037, not LEK). It shows the brief title and a specific barcode for each item to be pulled and transferred to fill a hold. In Harley, we are given a brief title and no barcode, just the note "Any available copy." I'm looking for feedback from those of you on a system that uses a holds queue report similar to the one in Harley (we have independent branches OFF). The default holds queue in 3.2 is identical to Harley. How do you use the holds queue report to find the correct item to fill the hold on titles such as Naruto, Go Diego Go or YuYu Hakusho that have the same 245 $a titles, but unique $p (parts) $n (numbers) or $b (subtitles)? I could see problems with TV series on DVD, such as Weeds or True Blood, as well. Just in case there's confusion - our current holds queue looks like this: http://screencast.com/t/NzljNTg2ZjMt and we will be changing to this: http://screencast.com/t/NDUzNjk5Yj Sharon Moreland Technology Consultant Northeast Kansas Library System NExpress Shared Catalog http://catalog.nexpresslibrary.org

2 2

previous trouble bulk loading patrons semi-solved
by Linda Culberson 18 Aug '10

18 Aug '10

I had emailed the list earlier about the problem I was having bulk loading thousands of patrons at a time using the import_borrowers.pl assuming that it was a "time out" issue. However, I discovered that part of the problem was having either unescaped single or double quotes in some of the fields. The next problem I discovered concerns the required branchcode and categorycode fields. If I put in a default, they load. If I load them single quoted as I have for the other fields, they don't. I have also discovered, with our installation, at least, the error on the staff page is always: 'Critical field "categorycode" missing' and 'critical field "branchcode" missing' even if the error is really something unrelated (like an unescaped single or double quote somewhere in another field). The error in the log is :"Use of uninitialized value in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/tools/import_borrowers.pl line 156, <fh00001kohatest.txt> line 12435., referer: http://koha.mdah.state.ms.us:8080/cgi-bin/koha/tools/import_borrowers.pl" We are on Koha version 3.00.05.003 and Perl version 5.008008 The good news is that although the staff's categorycodes have to be manually updated, I have 12430 patrons loaded! -- Linda Culberson lculber(a)mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824

1 0

Wanna share a Wellington hotel room?
by Daniel Grobani 18 Aug '10

18 Aug '10

I'm excited to have the opportunity to attend KohaCon10, but I'm trying to minimize the cost. Anyone else in the same boat who wants to share a hotel room? Thanks, Daniel Grobani Library Technology Specialist John A. Graziano Memorial Library Samuel Merritt University -- View this message in context: http://old.nabble.com/Wanna-share-a-Wellington-hotel-room--tp29449297p29449… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Release 3.2
by Lori Bowen Ayre 18 Aug '10

18 Aug '10

Hi Galen and all, I'm wondering if we could get an update on the status of 3.2 I just saw that Chris suggested it might be stable enough for someone to use in production. Does that mean it will be the official release soon? As I recall, the estimate for release was just 3-4 weeks and that was at ALA (end of June).....so, any ETA? Lori

4 6

Patron Cards & book labels
by Amir Seni 17 Aug '10

17 Aug '10

I personally think that selecting labels in koha takes too long. What I do is use the saved reports to query for barcodes and other fields, export to tab delimited field. Then import using the application "glabel" after having designed the label and selecting the items. I only query for books & not patrons. hope that helps. cheers

1 0

from marc 21 to Unimarc
by Daniel Legoff 17 Aug '10

17 Aug '10

Hi, willing to import data collected from a marc 21 repository (The canadian AMICUS) into our koha, wich is set up to import rcords in Unimarc ( which is the French standard and the one used by our usual data furnishers), I posted a message on this list a few days ago, asking about the existence of a Marc21 iso2709 to unimarc iso2709 translator I got a few answers, but they tell me how to convert "somethingMARC" into MARC 21, and not the other way around, or companies offer me to built up such a tool for us ; And I had no chance either asking the UNIMARC task force. I still believe someone somewhere must have developped something, for example using the USEMARCON tool. So I try again ! Daniel -- dlg Daniel Le Goff Bibliothèque francophone multimédia 2 place Aimé-Césaire 87032 Limoges cedex 05 55 45 96 94 dlegoff(a)bm-limoges.fr http://www.bm-limoges.fr Avant d'imprimer, pensez à l'environnement

3 2

DATA MIGRATION REQUEST
by Keah, Humphrey (ICRAF) 17 Aug '10

17 Aug '10

Dear colleagues, I have checked for previous questions on migrating data from INMAGIC to KOHA on the KOHA users forum as we have just installed KOHA at the World Agroforestry Centre Library and are hoping to migrate data from INMAGIC version 9.0 to KOHA. Unfortunately I didn't get a useful answer. Could someone please help. We intend to migrate data from INMAGIC version 9.0 which is not MARC-based, to KOHA. Any help, will be highly be appreciated. Rgds Humphrey

4 4

New Spanish Manual
by Nicole Engard 17 Aug '10

17 Aug '10

Today I received a full Spanish translation of the Koha 3.2 manual! I have committed it to Git: http://git.koha-community.org/gitweb/?p=kohadocs.git;a=commit;h=d8747ccd584… and it will appear on the website shortly. Thank you to all involved in that translation this is a great addition to Koha and will make it so that many more people will benefit from reading the manual! Thanks again, Nicole, Documentation Manager PS. In Docbook there is a way to show credits other than just the author, but when we convert it to HTML on WordPress some of that is lost. Just be aware that in the code the appropriate attributions are made to all of those who have helped grow the manual!

1 0

OPACShelfBrowser + GoogleJackets leading to erroneous display
by Indranil Das Gupta 16 Aug '10

16 Aug '10

Hi all, I am using Koha 3.00.06.010 on Ubuntu 10.04 I tried enabling GoogleJackets pref under Enriched content. It's working, except when I use the Shelf Browser in tandem. Shelf Browser is returning the same cover image (and google books link) for all the books as you can see from the html output (see http://pastebin.ca/1917241) Looks to me its same as this earlier post - http://old.nabble.com/Koha-3.0.5-%2B-%22Browse-Shelf%22-issue-td27693200.ht… Apparently KOHA.Google.GetCoverFromIsbn() is being passed the same ISBN Any clue? -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. To get a free editor supporting ODF, please visit http://www.openoffice.org/

2 1

Re: [Koha] More export/import questions
by Scott Owen 16 Aug '10

16 Aug '10

Not exactly a "fix", but this will help you identify records that may have this issue (more than one 952 field contains the same barcode). In my case it was only 20 records out of 4,000+, all in the very first barcode range. I suspect that they may have originally been imported twice. Cut/paste to a blank file and save as get952.pl read the readme. Not pretty code, but it should work. ##################################StartScript################################ #!/usr/bin/perl ## #### README ##### ## ## Copy this script to the same directory as the "koha.mrk" file. ## run as get952.pl > OutputFileName ## example: perl get952.pl > output.txt ## ## This script reads a Koha MARC file produced from MARCedit (the "koha.mrk" file defined below) ## and prints out the 952 sub field "$p" data (barcode) one line at a time to a temporary file ## (tempfile.txt). ## The tempfile.txt file is then parsed (a backup file "tempfile.txt.bac" is created during the ## process). ## The output file will contain the barcode and the number of times that barcode was found in a 952 field. ## ## Example output: ## p70240 ## = 2 ## p70241 ## = 2 ## p70249 ## = 1 ## p70299 ## = 1 ## ## Both the "tempfile.txt" and "tempfile.txt.bac" are deleted at the end of the script. ## The original "koha.mrk" file is never changed. ## The MARCedit file MUST BE the *.mrk file and NOT a *.mrc file. ## You can change the input file (coded as "koha.mrk" below). ## The "count" portion of this script was copied from perlmonks.org ## ################### ###### $MARCfile = "koha.mrk"; ###### my $tempfile = "tempfile.txt"; open(MARCfile) or die("Could not open file."); open FILE, ">$tempfile" or die "unable to open $tempfilefile $!"; foreach $line (<MARCfile>) { chomp($line); if($line =~ m/^=952/i) #{print "$line"}; {$newline = "$line"; my @values = split(/\$/, $newline); foreach my $val (@values) { if($val =~ m/^p/i){ #print "$val\n"; print FILE "$val\n"; } } } } close FILE >$tempfile; my $tempfile = 'tempfile.txt'; my %seen = (); { local @ARGV = ($tempfile); local $^I = '.bac'; while(<>){ $seen{$_}++; next if $seen{$_} > 1; print; } } foreach my $keys ( sort {$seen{$b} <=> $seen{$a}} keys %seen) { print "$keys = $seen{$keys}\n"; } unlink($tempfile); unlink("tempfile.txt.bac"); ##################################EndScript############################# >>> Joel Harbottle<joel.harbottle(a)hotmail.com.au> 8/12/2010 11:15 AM >>> Hi Scott, As a Cataloguer, I have just noticed another potential problem in your snip from MarcEdit. I have copied and pasted your MarcEdit snip below, and have also put the problem(s) in bold text. ************************************* =942 \\$cBOOK =952 \\$bPINE$dPINE$kF HAN$p74238$r{dollar}11.96$t3$v2010-05-13$u4247 =952 \\$bPINE$r0.00$w2008-08-17$u266$kF HAN$p70265$v2008-08-17 =952 \\$bPINE$r0.00$dPINE$w2010-05-13$u4247$kF HAN$p74238$v2010-05-13 =952 \\$bPINE$dPINE$kF HAN$p70262$r{dollar}13.99$t2$u263 =952 \\$bPINE$dPINE$kF HAN$p70262$r0.00$v2008-08-17$w2008-08-17$u263 =952 \\$bPINE$dPINE$kF HAN$p70265$r{dollar}10.96$t5$u266 =952 \\$bPINE$dPINE$kF HAN$p74255$r{dollar}10.96$t6$u4264 ************************************** So, in your example, you have the same barcode(s) utilised twice in the listing of Items. The only exception to this is the last line of Items, with Barcode '74255'. If you are able to find a fix to this problem, would you be able to either send the fix to me via email, or send to the entire list? Best Wishes Joel Joel Harbottle Library Technician Library Services (Tasmania) Email: Joel.Harbottle(a)hotmail.com.au Date: Thu, 12 Aug 2010 09:03:55 -0400 From: sowen(a)edzone.net To: koha(a)lists.katipo.co.nz Subject: [Koha] More export/import questions Hi all, Thank you all for the responses to my previous questions about exporting/importing biblio data. I think I have a grasp of what need to be done. (seems to be a big bigger job than I was hoping for...) With that said.... I noticed another potential issue (maybe?). ************************************* =942 \\$cBOOK =952 \\$bPINE$dPINE$kF HAN$p74238$r{dollar}11.96$t3$v2010-05-13$u4247 =952 \\$bPINE$r0.00$w2008-08-17$u266$kF HAN$p70265$v2008-08-17 =952 \\$bPINE$r0.00$dPINE$w2010-05-13$u4247$kF HAN$p74238$v2010-05-13 =952 \\$bPINE$dPINE$kF HAN$p70262$r{dollar}13.99$t2$u263 =952 \\$bPINE$dPINE$kF HAN$p70262$r0.00$v2008-08-17$w2008-08-17$u263 =952 \\$bPINE$dPINE$kF HAN$p70265$r{dollar}10.96$t5$u266 =952 \\$bPINE$dPINE$kF HAN$p74255$r{dollar}10.96$t6$u4264 ************************************** In the above snip from MARCedit, the 3rd line and the 7th line both reference the same item ($p70265 -- barcode # 70265). Is this normal? Will the data in line 7 overwrite the data from line 3? ie: if line 3 contains the $v2008-08-17 field data, and line 7 does not, will the result be an empty $v field? Should I be concerned with this, or is this a normal occurrence? Thank you again for any insight. -Scott Owen Alma Public Schools _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0