- Koha - lists.katipo.co.nz

updating koha 3.00
by Darth_D 13 Mar '14

13 Mar '14

Hi, My current employer is running on koha 3.00 on a linux server and wanted me to update it but I have found conflicting information; the 1st being there are no updates for koha 3.00 and the next being some linux commands i found to update koha 3.00 to 3.80. How should i proceed? Thanks

2 1

SIP2 error
by Mayank Srivastava 12 Mar '14

12 Mar '14

Hi everyone, Do we have a fix for *[Bug 8113] New: Item return fails using SIP2* for older versions of Koha? Any leads would be helpful. Thanks in advace.! -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India

2 1

German Z39.50
by Paul A 12 Mar '14

12 Mar '14

I'm looking for a German Z39.50 server. The Deutsche Nationalbibliothek has dropped Z39.50 in favour of SRU. I can connect to Gemeinsamer Bibliotheksverbund (GBV) server z3950.gbv.de on port 20012 (UTF8), requesting Marc21/USMarc, using database gvk. This will bring me in (at least some) results for ISBN (e.g. 341601331X) but author fails. Title might work e.g, it will find title 'Der Flieger und sein Flugzeug' (no quotes), but not the author 'Sohn' or 'Sohn, E' copy/pasted from the Marc record, and not find title AND author (which is what our cataloguers normally use.) Has anyone got the full details of a working German Z39.50 for Marc21 biblio imports? Many thanks -- Paul

2 1

Provider, update contact info in list
by vishal patil 12 Mar '14

12 Mar '14

Hi all, On behalf of Nucsoft OSS Labs I would like to update contact information in koha paid support provider list. http://koha-community.org/support/paid-support/ Kindly remove previous contact information and add below information. Contact: Vishal Patil/Pranali Uddansinh Work Phone: +91 22 32080161 Work Phone: +91 75 06 327949 Contact Email: support(a)osslabs.biz Contact Email: sales(a)osslabs.biz Address:602A, Times Square, Wing - A, Andheri - Kurla Road, Andheri (East), Mumbai - 400 059. Categories:Asia,India Website:http://www.osslabs.biz/koha -- Regards, Vishal Patil Landline number:02232080161 E-Mail: *vishal_wpatil(a)nucsoft.co.in <vishal_wpatil(a)nucsoft.co.in>* *vishal.patil(a)osslabs.biz <vishal.patil(a)osslabs.biz>.*

1 1

Problem reloading marc records
by Steve Sowder 11 Mar '14

11 Mar '14

I am new to Koha. I am exploring Koha for possible use on future projects. I have Koha running with 52,000+ bib records loaded. No item or patron records. I exported some records and made some edits on them. Now I am trying to reload them and overlay the existing record. The reload gets stuck and eventually times out. I split up the load and have loaded several records but it gets stuck at a certain point. I have narrowed it down to a single record. (But there may be others.) On the stage MARC for import I upload the file with a single record. Enter a comment: blah blah Record type: bibliographic Character encoding: MARC 8 Modify record using template: Do not use Record matching rule: Recnum [the contents of tag 999c] Action if match: Replace existing record with incoming Action if no match: Ignore incoming record Check for embedded item record data: No How to process items: Ignore items I am using Koha version: 3.14.04.000 It loads other records, but on this one (and possibly others) is stops. It will eventually time out. The record that does not load is: =LDR 00702nam a2200241Ii 4500 =001 2828430 =008 770323s1934\\\\lv\a\\\\\\\\\\000\0\lav\d =035 \\$a.b10127641$bcar $c- =040 \\$aEXN$cEXN =041 1\$alaveng =049 \\$aEXNh [326608]$c1 [326608] =090 \\$aBV3640$b.W375 =100 1\$aWatson, Charles Henry,$d1877-1962. =245 10$aPee zilwekehdejeem /$cK. H. Watson. =260 \\$aRigâ :$bLatwijas Rakstu Upgahdiba,$c1934. =300 \\$a68 p. :$bill. ;$c20 cm. =500 \\$aCover title: Pie cilvēkēdejiem. =595 \\$sJWL =595 \\$sSDALIB =650 \0$aMissions$zOceania. =690 \\$aSeventh-day Adventist publications. =740 00$aPie cilvēkēdejiem. =999 \\$c1040$d1040 What am I doing wrong? BTW: It has reloaded on control number before but 40% of my records do not have a control number. It has also reloaded on marc tag 035 but I haven't been able to do that for the past week. Please point me in the right direction. Thanks Steve Sowder Systems Librarian sowder(a)andrews.edu Andrews University

2 3

Still working on sorting problem
by Doug Dearden 11 Mar '14

11 Mar '14

Hello all, I am still working on this sorting problem, and have looked a bit deeper into it. I find the sorting routine in /usr/share/koha/lib/C4/ClassSortRoutine.pm , and it looks to me like it is driven by the variables $sort_routine, $cn_class and $cn_item . This took me back to the system preferences, where I turned on the Classification source "z Other/Generic Classification Scheme" and turned off all others. I then went to Koha to MARC mapping - biblioitems and set cn_class to point to 099a - which removed the mapping from items - itemcallnumber. I am suspicious that my problem may be that these records do not have a cn_source field, though my reading of ClassSortRoutine makes me think it would fall back to a default routine that should work. Or is there a perl program that needs to be run to update the records with the new system preferences? My previous question is pasted below. Any help is appreciated. I have a database that has no item records, only biblios. We are using it to catalog some archival folders, and pointing to pdfs with scanned images using the 856u field. We are using the 099a field as the call number field. In Administration - System Preferences - Cataloging - Record Structure - itemcallnumber we have 099a filled in. I just changed the Koha to MARC mapping so that items - itemcallnumber maps to 099a . After doing a search the results page is sorted in Relevance order. Changing the sort order to Call Number order, either Z-A or A-Z does not produce any change. Changing the sort order to Title or Author works. How do I get the sort working using the Call Number in the 099a field? Thanks, Doug Dearden Director, IT School for Advanced Research (505)954-7220 sarweb.org

1 0

advance to request SIP ERROR
by Humberto Blanco Castillo 11 Mar '14

11 Mar '14

hi, any advance for the http://lists.katipo.co.nz/public/koha/2012-March/032336.html thread? i now have the same problem. mi service up well but if i want test with telnet, the server close the connection and do not show login message like shows here http://saturn.ffzg.hr:8080/koha/index.cgi?sip2? Really apreciate your help Cordialmente, Humberto Blanco Administrador repositorio EdocUR Universidad del Rosario Este mensaje y cualquier archivo anexo son confidenciales y para uso exclusivo del destinatario, ya que puede contener informaci?n confidencial o susceptible de protecci?n especial de conformidad con la normatividad sobre propiedad intelectual. Si Usted no es el destinatario interesado, mediante el presente aviso se le notifica formalmente que cualquier uso, copia o distribuci?n de este correo electr?nico, en todo o en parte, se encuentra estrictamente prohibido, y se le solicita notificar de manera inmediata al remitente, mediante el re-env?o del mensaje. El presente correo electr?nico no representa la opini?n, filosof?a, fines o el consentimiento oficial de la Universidad Colegio Mayor de Nuestra Se?ora del Rosario. En cumplimiento de lo establecido en la Ley Estatutaria 1581 de 2012 y del Decreto Reglamentario 1377 de 2013 (protecci?n de datos personales) y las dem?s normas que los modifiquen, complementen y/o adicionen, la Universidad Colegio Mayor de Nuestra Se?ora del Rosario informa que el tratamiento de la informaci?n que ella realice se limitar? a lo se?alado en la pol?tica de tratamiento de protecci?n de datos personales de la Universidad, guard?ndose la debida reserva, mediante la adopci?n de las medidas t?cnicas y administrativas adecuadas y suficientes que permitan el cuidado y conservaci?n de sus datos personales. ___

1 0

Circulation and Fine Rules
by manoj382093 11 Mar '14

11 Mar '14

Dear Friends, I am testing latest version of koha for my library, I have set five item types for different courses and five different patron categories of these courses. I have set same course patron category with item type so that patrons cannot get books of other courses. but it is not working and patrons are getting issued all item types. Please help! Manoj Kumar Misra -- View this message in context: http://koha.1045719.n5.nabble.com/Circulation-and-Fine-Rules-tp5789921.html Sent from the Koha-general mailing list archive at Nabble.com.

3 3

Docbook to HTML/PDF Question
by Nicole Engard 11 Mar '14

11 Mar '14

Hi all, I'm not sure who manages the Docbook to HTML script (I do know that Bernardo does the PDF one) but I'd love to see the 'authors' broken down by role. For example: http://manual.koha-community.org/3.12/en/oclcappendix.html The sectioninfo is: 45887 <sectioninfo> 45888 <author> 45889 <firstname>D. Ruth</firstname> 45890 45891 <surname>Bavousett</surname> 45892 </author> 45893 45894 <affiliation> 45895 <orgname>ByWater Solutions.com</orgname> 45896 </affiliation> 45897 45898 <othercredit role="copyeditor"> 45899 <firstname>Nicole C.</firstname> 45900 45901 <surname>Engard</surname> 45902 45903 <contrib>Changed content where necessary.</contrib> 45904 </othercredit> 45905 45906 <pubdate>2012</pubdate> 45907 </sectioninfo> It'd be nice if the 'copyeditor' or 'other credit' info shows so that it was clear who was the author and who was the editor in some of these chapters/appendices. Anyone up for the challenge? Thanks Nicole

1 1

Help with report on percentage of Circ
by Nicole Engard 11 Mar '14

11 Mar '14

I got this request today and I have to admit it's a bit over my head in terms of the math involved. Can someone help me with this report? ------------- May we have a report that will give us the total circulation for a specific time frame and what percentage was attributed to a specific JUR Code? I ran this report and for example it gave me 128% as the percentage of total circ for JUR Code M814. SELECT x.attribute as 'Attribute', x.issues as 'Circ for this attribute', (x.issues * 100)/( SELECT COUNT(s.datetime) as 'total' FROM statistics s WHERE type = 'issue' AND s.datetime BETWEEN <<Date BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> ) as 'Percentage of total circ' FROM (SELECT ba.attribute as 'attribute', COUNT(s.datetime) as 'issues' FROM statistics s JOIN borrower_attributes ba ON s.borrowernumber = ba.borrowernumber WHERE ba.code = 'JUR' AND s.datetime BETWEEN <<Enter the same dates again BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> GROUP BY attribute) x

2 1