- Koha - lists.katipo.co.nz

Report Help
by Nicole Engard 23 Apr '13

23 Apr '13

I'm looking to change this report around. It shows patrons with their guarantor information. I want a report that shows me the guarantees for each guarantor instead. SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, p.firstname, p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', g.cardnumber, ')'),'') AS guarantor, p.relationship, ifnull(FORMAT(SUM(a.amountoutstanding),2),'0.00') AS due FROM borrowers p LEFT JOIN accountlines a USING (borrowernumber) LEFT JOIN borrowers g ON (p.guarantorid=g.borrowernumber) WHERE p.dateexpiry < NOW() GROUP BY p.borrowernumber ORDER BY p.dateexpiry ASC Nicole

2 2

koha lost/missing items
by schnydszch 23 Apr '13

23 Apr '13

I have Koha 3.10.4 installed in debian server. Whenever I set status to an item in moredetail.pl as lost it does not reflect that it's lost. And when I try to edit the item in additem.pl in 952$1, it also does not reflect. The framework for the particular book is Fast-add Framework and I check the MARC bibliographic framework, 952$1 is enabled or open. I have authorized values for LOST: Long Overdue (Lost), Lost, Lost and Paid For, Missing, Replaced and Withdrawn. Could I be missing something? And one more thing, can I ask the community how do you deal with replaced items? Thanks and Good day! -- View this message in context: http://koha.1045719.n5.nabble.com/koha-lost-missing-items-tp5751775.html Sent from the Koha-general mailing list archive at Nabble.com.

2 1

Marc framework errors
by rfblanchard 22 Apr '13

22 Apr '13

Using koha 3.10.4 If I run a 'MARC bibliographic framework test' I get this: -------------------------- MARC bibliographic framework test Test Result itemnum The field itemnum MUST be mapped The corresponding subfield MUST be in with -1 (ignore) tab OK All item fields are in the same tag and in item tab OK Only 1 MARC tag mapped to items OK biblioitems.itemtype defined homebranch NOT mapped the items.homebranch field MUST : be mapped to a MARC subfield, the corresponding subfield MUST have authorised value=branches holdingbranch NOT mapped the items.holdingbranch field MUST : be mapped to a MARC subfield, the corresponding subfield MUST have authorised value=branches OK at least 1 item type defined OK at least 1 library defined biblio and biblionumber The biblio.biblionumber and biblioitems.biblioitemnumber fields be mapped to a MARC subfield, OK no NULL value in frameworkcode subfields not in same tabs Not all subfields for the following tags are in the same tab (or marked 'ignored'). Code Description Tag Tabs in use Default framework 999 1,0 NEW new 999 1,0 OK all authority types used in the frameworks are defined TOTAL You have 5 error(s) in your MARC configuration. Please fix them before using Koha ------------------------------- I'm trying to fix the homebranch first. I choose 'koha to marc mapping' -> items -> and see that homebranch is mapped to '952 a Permanent location'. Tried saving it to something else as well. nothing sees to fix the error. same issue with holdingbranch Why am I getting this error in my marc framework and is there anyway to fix it? Any queries I could run on the db as a test? Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Marc-framework-errors-tp5751439.html Sent from the Koha-general mailing list archive at Nabble.com.

2 2

Unexpected report results - returning old data
by Elaine Bradtke 22 Apr '13

22 Apr '13

I'm running Koha 3.10.02 We have a report that looks for 6XX fields that are not linked to authorities and spits out a list of the unauthorized headings. It was very useful a few months ago in helping us find and correct an error with some imported data. We're about to import another big batch of data, and I ran the report again, just to check for anything that needed to be looked at first. But it's returning all the headings that were fixed the last time. Could it possibly searching cached data somewhere? I spot checked the headings and they are indeed properly linked. It's like I've discovered a time machine that takes us back to our old problems! We have re-indexed, and tried it again with the same results. Here's the SQL for the report: SELECT DISTINCT heading FROM ( SELECT ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(marcxml, '//datafield[@tag="610"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="610"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml, '//datafield[@tag="110"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(marcxml, '//datafield[@tag="600"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="600"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml, '//datafield[@tag="600"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(marcxml, '//datafield[@tag="130"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="611"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml, '//datafield[@tag="611"]/subfield[@code="9"]')) = 0 ) AS heads ORDER BY heading -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

1 0

Translation manager for v3.14
by D Ruth Bavousett 22 Apr '13

22 Apr '13

To my friends around the world in the Koha community: When the election cycle for v3.14 was ramping up, I had just recently left ByWater and moved to Houston for a new job. My hope was that enough of my time would be freed up for me to spend more time on translation-related developments when things had settled down some. That has, unfortunately, not been the case, and I'm just barely able to keep things afloat with keeping the Pootle server happy! Frustrations with that have persisted, and I so appreciate the patience of all the translators, the RM, and the RMaint as I've struggled to keep things afloat during this stressful period. I also want to thank Katrin for loads of help with the role that she has freely given while I've been in and out. Given my situation, and after discussing the matter with Galen, I've decided that my term as Translation Manager should end after the release of 3.12 next month. I'll be happy to help hand off matters, and will update the wiki page to reflect current processes, in order to make for a smooth transition, once someone is elected. I'll still be around some; several of the people that I am closest to are Koha people, and that doesn't change. I just need some uncommitted time to get my home and life in a little better order. With sincerest regards, D Ruth Bavousett Translation Manager, Koha v3.12

4 3

Re: [Koha] Problem with patrons import
by Sonia P. 22 Apr '13

22 Apr '13

Hello Thanks all for your help. I use a Mac too, but I don't know that Numbers application (I am not good with Mac, but somehow it is the only thing I am allowed to use here... >.<). Maybe this is a Mac problem? I will have to reinstall a spreadsheet application on my PC to try again. It worked very well the previous times I tried to import patrons, but then I was on my PC... Anyway, back on that Mac, I opened my .csv file and it reads: borrowernumber,cardnumber,surname,firstname,title,address,address2,city,state,zipcode,email,phone,fax,branchcode,categorycode,gonenoaddressT1,T1,TARTAMPION,Philip,Mr & Mrs,Po BOX xxx,,Birdcity,,2608,email(a)email.com.au,6123 4567,6987 6543,CANB,A,T2,T2,MACHINTRUC,Bidule,"Ms",Pink House,,City,,2600,,,,CANB,A,13,13,PATATRUC,Philip,Mr,Po Box xxx,,Fishcity,,2604,email(a)email.com.au,0412 1234 5678,02 6123 4567,CANB,A, ETC ETC Aman, thanks for your help, but it has been done as mentioned again and again... :) Cheers, Sonia. Date: Wed, 17 Apr 2013 14:38:18 +1200 Subject: Re: [Koha] Problem with patrons import From: amurphy(a)katikaticollege.school.nz To: sossolapro(a)hotmail.com Hi Sonia I too had this problem. I have a work around; it's not pretty but it works.I open the .csv file in Excel, cut/copy the patrons and paste them into a template spreadsheet with the correct headings. I work out the information for attributes, library code and patron categories then save and close. I open the file in Numbers (I use a Mac — I'm not sure of the PC equivalent) then export (in the file menu) the file using .csv and text encoding Unicode (UTF-8). Then I delete the .csv from the file_name (the message asks if I am sure I want to do this — yes). It then uploads just fine. I don't know why this works but it does. Every now and then I try the direct way, but so far no go. Good Luck -- Ann Murphy Librarian Katikati College Beach Road, Katikati, 3129 New Zealand 0064 7 5492647 amurphy(a)katikaticollege.school.nz

1 1

(no subject)
by Abdullah Al-Modabber 21 Apr '13

21 Apr '13

http://avicolafarms.com/wp-content/plugins/akismet/serviceg/mall/media

1 0

Re: [Koha] search problem in koha 3.10.4
by Peter Zhao 20 Apr '13

20 Apr '13

Hi, Greetings. sudo gedit /etc/cron.d/koha # The cronjobs -- $KOHA_PATH is defined in /etc/environment, and gets set when this process runs as a user (koha). */5 * * * * koha $KOHA_PATH/bin/migration_tools/rebuild_zebra.pl -b -a -z &> /dev/null This file needs put "koha" (user) in it. Try it. And change KOHA_PATH with your actual directory would be better. Peter Zhao At 2013-04-18 08:00:02,koha-request@lists.katipo.co.nz wrote: >Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > >To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha >or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > >You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > >When replying, please edit your Subject line so it is more specific >than "Re: Contents of Koha digest..." > > >Today's Topics: > > 1. Re: search problem in koha 3.10.4 (Mark Tompsett) > 2. Re: search problem in koha 3.10.4 (Bernardo Gonzalez Kriegel) > 3. Help With Preferences & Manual (Nicole Engard) > 4. Re: search problem in koha 3.10.4 (Paul) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Wed, 17 Apr 2013 07:42:21 -0400 >From: "Mark Tompsett" <mtompset(a)hotmail.com> >To: "Mohamed Megahed" <mr_megahed(a)hotmail.com> >Cc: koha(a)lists.katipo.co.nz >Subject: Re: [Koha] search problem in koha 3.10.4 >Message-ID: <BLU172-DS24BCBDC6636BFD919F02FCC6CE0(a)phx.gbl> >Content-Type: text/plain; format=flowed; charset="iso-8859-1"; > reply-type=original > >Greetings, > >This is clearly a development install, otherwise you wouldn't have touched >the cron jobs at all. >I am assuming you followed >http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_git >which is not intended for a production system, but rather a development >system. > >So my first suggestion is to follow >http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages >instead. It does a good job of hiding complexities from the user. Including >a whole set of nice commands: >http://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages > >However, I could be wrong and you actually are trying to join the bug patch >submitting side of things. >In which case: > >--- BEGIN Your example --- ># The cronjobs -- $KOHA_PATH is defined in /etc/environment, and gets set >when $ >*/1 * * * * $KOHA_PATH/misc/migration_tools/rebuild_zebra.pl -b -a -z &> >/d$ >--- END Your example --- > >--- BEGIN actual --- ># The cronjobs -- $KOHA_PATH is defined in /etc/environment, and gets set >when this process runs. >*/5 * * * * $KOHA_PATH/misc/migration_tools/rebuild_zebra.pl -b -a -z &> >/dev/null >--- END actual --- > >I think you may have a problem using "/d$". Also, after your install did you >run a full reindex? > /home/{user name}/{koha >directory}/misc/migration_tools/rebuild_zebra.pl -b -a -r -v >Where {user name} and {koha directory} are your user name and most likely >"kohaclone"? > >And to finish off, the most likely cause of everything: > $ sudo service koha-zebra-daemon start >It doesn't start automatically on reboot for me, so this may be your problem >too. I've been meaning to improve the instructions that way. You can confirm >it is running with: > $ ps aux | grep zebra >You should see more than just your grep line. > >GPML, >Mark Tompsett > > > >------------------------------ > >Message: 2 >Date: Wed, 17 Apr 2013 12:23:01 -0300 >From: Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> >To: Mark Tompsett <mtompset(a)hotmail.com> >Cc: koha <koha(a)lists.katipo.co.nz>, Mohamed Megahed > <mr_megahed(a)hotmail.com> >Subject: Re: [Koha] search problem in koha 3.10.4 >Message-ID: > <CADF4kvR-tVkghK2pjf=pd8FOhkESg8XWr1Cca43-3G2oH_Qn4A(a)mail.gmail.com> >Content-Type: text/plain; charset=UTF-8 > >On Wed, Apr 17, 2013 at 8:42 AM, Mark Tompsett <mtompset(a)hotmail.com> wrote: > >> Greetings, >> >> This is clearly a development install, otherwise you wouldn't have touched >> the cron jobs at all. >> > >Mark, >why you always suppose that everybody do packages installs? > >In my opinion most of current installs were done using tar.gz > >So the question of how to correctly setup cron jobs is a valid one. > >Regards, >Bernardo > > >------------------------------ > >Message: 3 >Date: Wed, 17 Apr 2013 15:26:25 -0400 >From: Nicole Engard <nengard(a)gmail.com> >To: Koha <Koha(a)lists.katipo.co.nz> >Subject: [Koha] Help With Preferences & Manual >Message-ID: > <CAC0K6VEqgK-mOJkDMB95YDxLn+Y0iUHUYgBkKt_VSN_=DpMxDA(a)mail.gmail.com> >Content-Type: text/plain; charset=UTF-8 > >Hi all, > >I got this question today and I realized that the manual is not clear and >now I am second guessing myself - can someone help me out with updating the >manual and answering this question? > >----- > > >What we want to have happen is that if an item is returned to the checkout >library (which is not the owning library for the item) then we want the >checkout library to be able to fill a hold on that item by a patron of the >checkout library without having to send the item back to the owning >library, have the owning library ship it back and then check it out to the >patron with the hold. That seems to be what the description in Section >1.1.5.2.11 of the manual ( >http://manual.koha-community.org/3.10/en/administration.html#HomeOrHoldingB…) >is describing. However the manual states that this setting "Asks: Use the >checkout and fine rules of_____" and That does not seem to make sense in >relation to the description. > >Since there is such a caution against changing this setting after the >initial setup, we want to get it right. > >Also, I believe that we concluded during training that we would have the >IndependentBranches preferences set to prevent so this setting would apply. >However I am now confused about the IndependentBranches settings which I >thought only applied to what staff can do. When I get to the part of the >description in section .1.2.3.2 of the manual ( >http://manual.koha-community.org/3.10/en/administration.html#IndependantBra…) >that says Prevent will, "preventing users from other branch locations from >placing holds or checking out materials from library branches other than >their own" I am left wondering if this will stop all holds by patrons of >one library from placing holds on items for other libraries. Or is it just >that staff of one library cannot place a hold on another libraries items.... > > >------------------------------ > >Message: 4 >Date: Wed, 17 Apr 2013 10:02:41 -0400 >From: Paul <paul.(a)aandc.org> >To: Karam Qubsi <karamqubsi(a)gmail.com>, Mohamed Megahed > <mr_megahed(a)hotmail.com> >Cc: koha staff <koha(a)lists.katipo.co.nz> >Subject: Re: [Koha] search problem in koha 3.10.4 >Message-ID: <5.2.1.1.2.20130417094506.058c7678@localhost> >Content-Type: text/plain; charset="us-ascii"; format=flowed > >At 04:25 PM 4/17/2013 +0300, Karam Qubsi wrote: >>Hi Mohamed , >>try to rebuild your zebra index manually . >>cd $KOHA_PATH/misc/migration_tools/ >>then : >>perl rebuild_zebra.pl -b -a -z > >Unless 3.10 has changed radically from 3.8, an incremental -z might not be >sufficient. > >As user koha (or whichever user has the rights): > >koha:/$ cd /usr/share/koha >koha:/usr/share/koha$ ./bin/migration_tools/rebuild_zebra.pl -b -r -v -x >koha:/usr/share/koha$ ./bin/migration_tools/rebuild_zebra.pl -a -r -v > >Maybe the path has changed from /usr/share/koha/bin to ?/?/?/misc? Please >adjust accordingly. > >We run this every 15 minutes while our cataloguers are working, otherwise >duplicate/unwanted biblios creep in and can get very confusing for non-techies. > >Best - Paul > > > > > > >>On Wed, Apr 17, 2013 at 10:36 AM, Mohamed Megahed >><mr_megahed(a)hotmail.com>wrote: >> >> > Hi all >> > I have installed koha 3.10.4 on ubuntu 12.04 and all ok. but i have faced >> > problem search record, after cataloging record, try to search it ... no >> > result i use zebra indexing and cronjob. >> > in crontab i had add this lines >> > >> > # The cronjobs -- $KOHA_PATH is defined in /etc/environment, and gets set >> > when $ >> > */1 * * * * $KOHA_PATH/misc/migration_tools/rebuild_zebra.pl -b -a -z >> > &> /d$ >> > >> > after that no result in search both biblio and authority. >> > >> > any sugg. >> > thnks >> > >> > >> > MOHAMED MEGAHED Chief Library at Ahram Canadian University >> > Tel : +2 0100 22 97 96 2 >> > Tel : +2 011 23 502 505 >> > >> > >> > >> > >> > _______________________________________________ >> > Koha mailing list http://koha-community.org >> > Koha(a)lists.katipo.co.nz >> > http://lists.katipo.co.nz/mailman/listinfo/koha >> > >> >> >> >>-- >>*Karam Qubsi* >>_______________________________________________ >>Koha mailing list http://koha-community.org >>Koha(a)lists.katipo.co.nz >>http://lists.katipo.co.nz/mailman/listinfo/koha > >--- >Maritime heritage and history, preservation and conservation, >research and education through the written word and the arts. ><http://NavalMarineArchive.com> and <http://UltraMarine.ca> > > > >------------------------------ > >_______________________________________________ >Koha mailing list >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha > > >End of Koha Digest, Vol 90, Issue 25 >************************************

2 1

Making a list from Reading History
by Marie Wardall 19 Apr '13

19 Apr '13

Just wondering if you can make a saved Public or Private list from your Reading history easily. I have a few teachers who have checked out a number of books over the year and would like to use their reading history to create saved lists to use next year. We are using Koha version 3.6 TIA Marie Marie J. Wardall Library Media Specialist Weston Elementary School 5200 Camp Phillips Rd. Schofield, WI 54476 mwardall(a)dce.k12.wi.us Phone: 715-359-4181 ext. 5624 Change Today, Change Tomorrow, Keep Changing

2 1

Need some SQL help
by Doug Dearden 19 Apr '13

19 Apr '13

Hello all, I find myself once again confounded by an SQL problem. I am trying to extract the value from field 245, ind2 . I have used a variety of select statements without success, i.e. SELECT EXTRACTVALUE(marcxml,'//datafield[@tag="245"][ind2]') as "SkipArticle" or SELECT EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="ind2"]') as "SkipArticle" Those are two of the variations I have tried. There are probably another 20 along the way. When I look at the marcxml field I see that ind1 and ind2 are on the same line as the 245 identifier, and not in a subfield line. For instance: <datafield tag="245" ind1="1" ind2="0"> <subfield code="a">Biology unmoored :</subfield> <subfield code="b">Melanesian reflections on life and biotechnology /</subfield> A number of my attempts have not returned a syntax error, they just never return a value. So what would the SQL/Xpath syntax be to get the info out of ind2 ? Thanks in advance for your help, Doug Dearden Director, IT School for Advanced Research (505)954-7220 sarweb.org

2 2