- Koha - lists.katipo.co.nz

Report Help
by Nicole Engard 11 Apr '13

11 Apr '13

I'm trying to get a report to show patrons with overdues and if there is a guarantor I want that to show too. But what's happening is the Guarantees are showing as the Guarantors and the Guarantor is showing 2 times cause he has 2 Guarantees - can someone help me with my SQL: 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, FORMAT(SUM(a.amountoutstanding),2) as due FROM borrowers p LEFT JOIN accountlines a USING (borrowernumber) left join borrowers g on (g.guarantorid=p.borrowernumber) WHERE p.dateexpiry < NOW() and p.surname = 'Meave' group by p.borrowernumber, g.borrowernumber ORDER BY p.dateexpiry asc ; +--------------+-------------+------------+---------+---------------+------------+---------------------------------+--------------+--------+ | categorycode | dateofbirth | cardnumber | surname | firstname | dateexpiry | guarantor | relationship | due | +--------------+-------------+------------+---------+---------------+------------+---------------------------------+--------------+--------+ | TRES | 1996-08-24 | P0012129 | Meave | Melina-Maria | 2008-12-04 | | parent | 5.90 | | TRES | 2000-08-30 | P0012128 | Meave | Phoenix-Jonas | 2008-12-04 | | parent | 2.30 | | STRICT | 1956-09-23 | P0012127 | Meave | Jose | 2008-12-04 | Meave, Melina-Maria (P0012129) | | 351.53 | | STRICT | 1956-09-23 | P0012127 | Meave | Jose | 2008-12-04 | Meave, Phoenix-Jonas (P0012128) | | 351.53 | +--------------+-------------+------------+---------+---------------+------------+---------------------------------+--------------+--------+

2 3

Question about Active Directory integration
by Coehoorn, Joel 11 Apr '13

11 Apr '13

We're a small college library in the process of migrating to Koha from an old Winnebago Spectrum system. The plan is that students should be able to use their Active Directory credentials when access Koha. I have the connection working, but there are some things I'm not clear on. For many students, their first and only account interaction with Koha will be when they bring an item to the circulation desk. At this point, if the attendant scans their card and they have never logged in, my understanding is that Koha will have no idea who they are and will reject the transaction, because it doesn't create the account until someone tries to authenticate. Is there any way to have Koha pro-actively pull this information? I'd rather avoid the extra step of batching users into Koha each term. Also, for anyone else using Active Directory, are you storing the Card Number in Active Directory? If so, what field are you using? Joel Coehoorn Director of Information Technology York College, Nebraska 402.363.5603 jcoehoorn(a)york.edu *The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society*

2 1

Fwd: incorrect labeling in serials
by Hugo Agud 11 Apr '13

11 Apr '13

hi everybody.... We have realized a little mess with koha labeling regarding serials The table serials has just two dates field: planneddate and publisheddate, however there are three fields in koha regardind dates and serials: date published, date received and planned date, then something was wrong somewhere We have checked the code of the two files involved and date received and planned date are the same date, both refers to serials.planneddate and it is a little confusing.. If we are right You can check here the code of files and the labeling: /cgi-bin/koha/serials/*subscription-detail.pl*?subscriptionid= and here the other one cgi-bin/koha/serials/*serials-collection.pl*?subscriptionid= Kindest Regards Hugo -- *Hugo Agud - Orex Digital * *www.orex.es* * * Director Mossen Jaume Rafanell, 21 · 08338 Premià de Dalt - Tel: 93 539 40 70 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema. -- *Hugo Agud - Orex Digital * *www.orex.es* * * Director Mossen Jaume Rafanell, 21 · 08338 Premià de Dalt - Tel: 93 539 40 70 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

2 2

Re: [Koha] Please advice how to improve our search issue
by Paul 10 Apr '13

10 Apr '13

At 11:19 AM 4/10/2013 +1200, Robin Sheat wrote: >Paul schreef op di 09-04-2013 om 18:27 [-0400]: > > That looks like a very busy, if not overloaded, server. You need (at > > least) > > to increase the size of your swap to at least double what it is > > currently > > set at (either resize partition or add a swapfile.) > >Not it doesn't, it looks like a very comfortably loaded server. Yeah ... maybe I went too fast, in the original email "column headers" were out of kilt; my apologies. However, the example I gave of the "sandbox" shows very different results which is why I mentioned MemCache. I'm not claiming that this is the only reason, but this list is probably not the right place to discuss other checks (e.g. cat /proc/swaps, vmstat, htop) for memory management. Best - Paul > total used free shared buffers cached >Mem: 1955 1881 73 0 15 1350 >-/+ buffers/cache: 514 1440 >Swap: 2997 2 2995 > >It has 2GB RAM, 3GB swap. 514MB RAM (~25%) is in use, and 2MB swap (more >or less nothing) is in use. So it's got plenty of room to breathe. The >key line is the one that starts with '-/+ buffers/cache' as it's the one >that's ignoring cache, which is what you want to do when looking at >memory usage. > >Looking at one of our servers that's similarly specced and not usually >too busy: > > total used free shared buffers cached >Mem: 2012 1885 127 0 71 1410 >-/+ buffers/cache: 402 1610 >Swap: 2045 0 2045 > >it's really very close. > >So Zoe, your server is totally fine RAM-wise > >-- >Robin Sheat >Catalyst IT Ltd. >â +64 4 803 2204 >GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D > > >_______________________________________________ >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>

1 0

Issues with biblio import into Koha
by Olugbenga Adara 10 Apr '13

10 Apr '13

Hello all, This has got me stumped! I am trying to import some set of bib records into Koha totaling about 5300. About 2900 of these records have two items while the remaining has just one item. Using MarcEdit, I have created two MARC files, the first with the first or only copies of the records, while the 2nd has the records having only the 2nd copy. I created a unique 001 field for each record and then created a record matching rule based on 001 (Local-number). After importing the MARC file of the 1st copy, I rebuild the zebra index before importing the Marc file for the second copy. Now the problem is that is that during the second copies import, it says about 500 of the records were not matched, matching the remainder. I had first tried this with a title match but got a similar result. I checked that the records not matched actually exist in the Koha database with the correct 001 value. I don't understand why some records do not match and some do. The database is fresh with just only one previous bib in it before the imports. Can anyone please point me in the right direction to sort this out? Or a better way to do the import? I am running Koha 3.10.4 on debian squeeze (package install) Thanks Olugbenga Adara Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara

2 3

Varying form of title
by Mayoora 10 Apr '13

10 Apr '13

Dear all I am trying to include the varying form of title (MARC tag 246) for generating the report of books in our library. But I want not able to include the tag in report library. Can any one help me Mayoora -- View this message in context: http://koha.1045719.n5.nabble.com/Varying-form-of-title-tp5750378.html Sent from the Koha-general mailing list archive at Nabble.com.

1 0

KOHa and Dspce Workshop
by librarian 10 Apr '13

10 Apr '13

I am pleased to announce that Government College university Lahore is going to organize two day training workshop on the subject cited above. Regards, Sher Afzal Head, Bahria University Libraries Naval Complex E-8 Islamabad (Ph Off) +92-51-9260271 (Direct) + 051-92-519260002-6 Ext 407-227 __________________________ Life Member of: PLA, PLC, Coordinator Information literacy Association of Pakistan (ILAP) Coordinator Pakistan Library Automation Group (KPK) www.library.bahria.edu<http://www.library.bahria.edu/>. http://www.facebook.com/home.php#!/pages/Bahria-Univeristy-Library/29330244…

1 0

Please advice how to improve our search issue
by zoe 10 Apr '13

10 Apr '13

hello all, Our Koha response time is too slow. We have 217062 biblio records, 289026 items, and with zebra index. When I use keyword to search, it spent almost 30s for the slowest one, the averige is 10s. Is there anyone who has ever met this situation and solved the issue? OS: Ubuntu 12.04 Koha version: 3.06.02.000 Any help. Thought, direction would be greatly appreciated! Thank you. Zoe -- View this message in context: http://koha.1045719.n5.nabble.com/Please-advice-how-to-improve-our-search-i… Sent from the Koha-general mailing list archive at Nabble.com.

7 8

Call for news for the April newsletter
by Daniel Grobani 09 Apr '13

09 Apr '13

Dear Koha kommunitarians, I'm harvesting news for this month's newsletter. Please send me by the 18th anything you think your fellow community members might like to know about. "News" can be as short as a sentence or as long as a paper. I especially encourage you to send me a line or two for the gossip/society column about what you're currently working on. And if you know of a go-live not announced on the list, please be sure to let me know about it. Thanks, Daniel Grobani

2 1

Removing unused icons from Koha
by Owen Leonard 09 Apr '13

09 Apr '13

Koha is distributed with over 1000 small image files which are not used in a default installation. I have submitted a patch to remove these for the sake of simplicity and in order to reduce the overall size of Koha. It has been speculated that some of these icons may be in use by libraries who have customized their installations, so I ask this of my fellow Koha libraries: Are you using any images in the /opac-tmpl/lib/famfamfam/ folder and its subfolders in your customized OPAC? Are there objections to removing these? Thanks, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

3 3