- Koha - lists.katipo.co.nz

moremember.pl shows high CPU usage after upgrade to 3.14
by Jason Sherman 08 Jan '14

08 Jan '14

Hi all, After upgrading our system to 3.14, things are generally great, with the exception of this one issue. Loading the moremember.pl page for patrons with overdues takes upwards of 20 seconds, and top shows that the script is completely hogging the CPU. Patrons without overdues load just fine. My first thought was that it was doing some kind of crazy db query, but mysqld doesn't seem to be using any more resouces than usual while this is happening. Has anybody else experienced this? Any suggestions? -- Jason Sherman Systems Librarian University of Science and Arts of Oklahoma 405.574.1340

3 2

January 2014 general IRC monthly meeting - minutes and log
by David Nind 08 Jan '14

08 Jan '14

Hi everyone. The minutes and log from the 8th January 2014 general IRC monthly meeting are available here: Minutes: http://meetings.koha-community.org/2014/general_irc_meeting_8_january_2014.… Minutes (text): http://meetings.koha-community.org/2014/general_irc_meeting_8_january_2014.… Log: http://meetings.koha-community.org/2014/general_irc_meeting_8_january_2014.… All Koha community members are invited (and encouraged) to attend the next meeting. This is scheduled for 5th February 2014 at 02:00 UTC. You can see what time the meeting is for your location and add any agenda items at http://wiki.koha-community.org/wiki/General_IRC_meeting_5_February_2014 Regards. David Nind | david.nind(a)gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098

1 0

Koha 3.14 bootstrap OPAC display question
by Elaine Bradtke 07 Jan '14

07 Jan '14

Greetings and happy new year We're experimenting with 3.14.1 and a new colour scheme for the OPAC in our test site. The colour scheme seems to have applied just fine. The problem is with bootstrap. With the bootstrap theme enabled we end up with unsightly grey blocks with white text for tags such as Source: Publisher: Availability: , etc. Here's a link to an example of what it looks like https://drive.google.com/a/efdss.org/?usp=chrome_app#folders/0B0ag4Jlx4aGmM… When you go to the record there are similar blocks around the tags for Publisher: Description: Subject(s): In: Summary: etc. Even when I remove our colour scheme, the grey blocks are still there. I would like to have these tags appear in bold text in the same colour as the rest of the text rather than highlighted in grey. Can anyone tell me how to change this? Or point us in the right direction? Thanks -- 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)

2 5

Re: [Koha] [Koha-devel] drop-down menu
by Owen Leonard 06 Jan '14

06 Jan '14

On Mon, Jan 6, 2014 at 9:49 AM, Uğur Bulgan <ugurbulgan(a)sdu.edu.tr> wrote: > Problem solved > Since we made upgrade, a new authorized value named "SAGLAMA" was defined. Then I checked frameworks. Subfield "e" is mapped to "SAGLAMA"authorized value in BOOKS framework bu not in DEFAULT framework. I mapped authorized value in Default framework. And problem solved. Thank you for your help. > > Ugur BULGAN Glad to hear it! -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

Fwd: ERROR ON KOHA SEARCH
by Yvonne Wambui 06 Jan '14

06 Jan '14

Good morning, I hope all is well. I writing to you on an issue we have noticed on the catalog searches. There are some words when searched for give and error; the terms include: development and history. Please see the attached image on exactly what I mean. Hope to hear from you.

2 2

Koha & rfid
by Remark 04 Jan '14

04 Jan '14

Any members here have experienced using uhf rfid with koha ? If any pls share some important tips. I ask this becouse one user here (malaysia) to implement rfid uhf. Refards Esmael Sent from my iPhone > On 04/01/2014, at 7:00, koha-request(a)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: Importing Koha Database to a new install (Robin Sheat) > 2. Re: SQL report 650 a (Holger Meissner) > 3. Re: How to print checked out items and news from the quick > (magmatic) > 4. Status of item = Checked out ...and waiting? (Chad Roseburg) > 5. Re: SQL report 650 a (Bob Birchall) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 03 Jan 2014 13:43:16 +1300 > From: Robin Sheat <robin(a)catalyst.net.nz> > To: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Importing Koha Database to a new install > Message-ID: <1388709796.12800.38.camel@zarathud> > Content-Type: text/plain; charset="UTF-8" > > Please reply to the list, so that other people with the same problem in > the future can see information on it. > > Phillip Ponchot schreef op do 02-01-2014 om 15:48 [-0800]: >> After I install Koha and do everything mentioned before importing my >> database, do I log into the staff koha web interface and setup the >> database like set language to en, choose marc21 records etc. > > No, I always start from a clean database and import my database directly > into there. > >> all one line: >> (I assume this is clearing the database) >> mysql -u koha_library -p xxxxxxxxxxxxxx -Nse 'show tables' >> koha_library | while read table; do mysql -u koha_library >> -p xxxxxxxxxxxxxxxxxxxx -e "drop table $table" koha_library ; done > > That will go some way to clearing the database, but I would expect you > get a lot of errors about foreign relationships, if so, run it multiple > times until you get no errors. Best just start from an empty database > though. > >> (the data imports just fine) >> 5. sudo koha-mysql library < backedup.sql > > This will abort if there is any error, so that it doesn't is a good > sign. > > However, you say that it imports just fine. How do you know? That there > are no errors isn't good enough. Did you look in the tables and count > the records to make sure the right number are there? Did you have a look > in backedup.sql to make sure that it's got the right data in it? Did you > compare some things between them. I think that there is something going > wrong around here. > >> (seems to work but does this extremely fast, I figured it would take >> longer) >> 6. sudo koha-upgrade-schema library > > It should _definitely_ take some time. I think the fact that it's not is > the primary symptom of the issue. Is there any output at all? There > should be heaps of it, stuff like "Upgrade to version 3.12.34 done (Add > widget to foobar)" type things. > > At this point, what I think is happening is that you are adding sample > data into the database, and when you think you are importing your real > data over the top of it, you actually aren't. > > I don't know where it's going, your steps look correct, but I suspect > that the reason that it's going fast is because it's looking at the > database and saying "oh, already at the latest version, let's do > nothing" because you have your sample data still there rather than real > data. > >> (if I run this I get a complaint that ean and agerestriction is not in >> biblioitems. If I create these tables in biblioitems, it takes about >> an hour so upgrade all 37400 records. >> 7. sudo koha-upgrade-to-3.4 library > > Yeah, it'll be expecting a more modern schema. For 37,400 records, I > would consider an hour to be roughly right. It's been a long while since > I've had to run that though. > > ean and agerestriction came in in 3.09, so that they're not there > suggests that something before this step is definitely wrong. > >> (during the upgrade zebra rebuild is run, but I've run it just in case >> since it is in the instructions) >> 8. ran zebra rebuild - koha-rebuild-zebra -v -f library > > My rule of thumb is to run this after anything significant has happened. > It doesn't hurt, and is the first port of call when something weird is > happening. > >> I try to login to the web interface as the old staff user (in the >> database) but it does not work. > > Don't say "doesn't work." What actually happens? What I would expect, > given the apparent failure of step 6, is that it redirects you do the > web installer and says "upgrading to version 3.12.whatever" or something > along those lines. If it says that, what does it actually say? If it > doesn't say that, what does it actually say? Details are vital here. > > I would fully expect that login to not work in this case though, you > should be using the database username/password for the schema upgrade. > >> I log into the web interface with the koha_library account and I can >> get into Koha but there is just mylibrary and several other samples. > > So, are these the samples you created when you installed it the first > time? > >> After I install Koha, do I immediate login as Koha_library with the >> supplied password do the setup (set english, set marc21) etc. > > No. > >> After I import data, fix the schema, upgrade to 3.4 and rebuild zebra, >> how to I setup the web interface to see the my library's data. > > You don't, it just works. > > Provide the result of doing all this with the "script" command, there > may be clues in there. > > -- > Robin Sheat > Catalyst IT Ltd. > ? +64 4 803 2204 > GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF > > > > ------------------------------ > > Message: 2 > Date: Fri, 3 Jan 2014 12:31:21 +0000 > From: Holger Meissner <Holger.Meissner(a)hs-gesundheit.de> > To: Koha-List <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] SQL report 650 a > Message-ID: <2C614FEEE2356A428DC65441E30302E06F6EDC@nero> > Content-Type: text/plain; charset="us-ascii" > > yoonus para wrote: >> Dear all, >> >> How to create a SQL report using field 650 a with barcode and title,Please help me to create this report. >> >> Thanks >> Yoonus > > Did you find a solution? I thought it might be interesting, but I also can't figure it out. > > When I run > SELECT * FROM marc_subfield_structure WHERE tagfield = 650 AND tagsubfield = 'a' > > it tells me the "kohafield" is bibliosubject.subject, yet it seems that I don't have a table called bibliosubject. Is that normal? > > > ------------------------------ > > Message: 3 > Date: Fri, 3 Jan 2014 11:39:12 -0800 (PST) > From: magmatic <magmatic(a)timkoop.com> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] How to print checked out items and news from the > quick > Message-ID: <1388777952692-5782744.post(a)n5.nabble.com> > Content-Type: text/plain; charset=us-ascii > > I just got it working the way I wanted it to work. I want to print Slips > instead of Quick Slips when enter is pressed. This is how: > > Edit the file: > /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/circ/circulation.tt > > On line 79 or so, replace > printx_window('qslip'); > with > printx_window('slip'); > > That should do it. > > -- > Tim > > > > -- > View this message in context: http://koha.1045719.n5.nabble.com/Re-How-to-print-checked-out-items-and-new… > Sent from the Koha-general mailing list archive at Nabble.com. > > > ------------------------------ > > Message: 4 > Date: Fri, 3 Jan 2014 12:54:10 -0800 > From: Chad Roseburg <croseburg(a)ncrl.org> > To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: [Koha] Status of item = Checked out ...and waiting? > Message-ID: > <CAEboqJP2=fg0rK96AwKieX-jAZjDNMg4-dZ-jfzodT3okyHhEA(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Wondering what scenario would result in the following: > > * Patron places hold on item > * Item arrives at branch ...placed on holds shelf > * Patron arrives at branch and checks out item > > Item status for the last week appears as follows in the staff interface: > > "Checked out to JOE D PATRON : due 01/04/2014 23:59 > Waiting for JOE D PATRON at RANDOM COMMUNITY LIBRARY since 12/18/2013" > > It also shows on the branch's expired holds list. > > Ideas? > > Thank you ~ > > -- > Chad Roseburg > Automation Dept. > North Central Regional Library > > > ------------------------------ > > Message: 5 > Date: Sat, 04 Jan 2014 07:57:19 +1100 > From: Bob Birchall <bob(a)calyx.net.au> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] SQL report 650 a > Message-ID: <52C7242F.7020407(a)calyx.net.au> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > >> On 03/01/14 23:31, Holger Meissner wrote: >> yoonus para wrote: >>> Dear all, >>> >>> How to create a SQL report using field 650 a with barcode and title,Please help me to create this report. >>> >>> Thanks >>> Yoonus >> Did you find a solution? I thought it might be interesting, but I also can't figure it out. >> >> When I run >> SELECT * FROM marc_subfield_structure WHERE tagfield = 650 AND tagsubfield = 'a' >> >> it tells me the "kohafield" is bibliosubject.subject, yet it seems that I don't have a table called bibliosubject. Is that normal? > Yes that is normal. 'Subject' is not separately defined in the data > base. Subject data are stored as part of biblioitems.marcxml. You can > report on the data using the 'extract value' command in SQL. There > should be examples in the library: > http://wiki.koha-community.org/wiki/SQL_Reports_Library > > Best wishes, > Bob Birchall > Calyx > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 99, Issue 4 > ***********************************

1 0

Report for Fine collection in date ranges
by Prajeesh 04 Jan '14

04 Jan '14

Hi What is the problem with this Report for getting the fine collection in between date ranges. The result is showing minus amounts. Eg: -6, -5 etc. SELECT borrowers.cardnumber,borrowers.surname,accountlines.date,accountlines.amount FROM borrowers LEFT JOIN accountlines on (borrowers.borrowernumber=accountlines.borrowernumber) WHERE DATE(timestamp) BETWEEN <<Added BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> AND (accounttype='PAY') Please help -- With Regards Prajeesh Bhaskaran Mahatma Gandhi University Library Kottayam, Kerala- 686 560 http://kerala-lis.blogspot.com/.

1 0

Add order to basket by uploading from an excel file in Acquisition.
by Prajeesh 04 Jan '14

04 Jan '14

Anyone know any facility available in koha to upload excel file in "add order to basket " (Acquisition) . Now the following options are available. >From an existing record >From a suggestion >From a subscription >From a new (empty) record >From an external source >From a staged file We are using koha 3.12.06.000. We are getting suggestions from different departments in excel file. Is it possible to upload the same to koha after editing the essential details. Please help us -- With Regards Prajeesh Bhaskaran Mahatma Gandhi University Library Kottayam, Kerala- 686 560 http://kerala-lis.blogspot.com/.

1 0

SQL report 650 a
by yoonus para 04 Jan '14

04 Jan '14

Dear all, How to create a SQL report using field 650 a with barcode and title,Please help me to create this report. Thanks Yoonus

4 3

Koha 3.8.21 released
by Kyle Hall 03 Jan '14

03 Jan '14

The Koha community is proud to announce the release of 3.8.21. This is a maintenance release and contains several bugfixes. IMPORTANT: we encourage people on the 3.8 version to upgrade to this release. As always you can download the release from http://download.koha-community.org For the full release notes and changelog visit: http://koha-community.org/koha-3-12-8-released/ http://www.kylehall.info ByWater Solutions ( http://bywatersolutions.com ) Meadville Public Library ( http://www.meadvillelibrary.org ) Crawford County Federated Library System ( http://www.ccfls.org ) Mill Run Technology Solutions ( http://millruntech.com )

1 1