- Koha - lists.katipo.co.nz

Help needed with SQL report
by Elaine Bradtke 09 Oct '17

09 Oct '17

I need a report that gives bib number, title and 260$c from a set of records within a range of biblio numbers. This is what the wizard gives me: SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.biblionumber >= '17920' AND items.biblionumber <= '17959' ORDER BY biblio.copyrightdate asc But it's only giving the year (presumably from the 008?) I need the actual text of the 260$c field. Any help would be greatly appreciated. Thanks! I looked for a way I could configure the csv output from a list to give me that information, but didn't find it . 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)

4 6

Who created records
by Ma. Victoria H. Silva-Manuel 09 Oct '17

09 Oct '17

Hi. How to know or to show who created records in cataloging module? There are records that I need to find out who created them. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

3 2

Help Me
by Rajesh Shelar 09 Oct '17

09 Oct '17

Dears Friends, I am using the Koha Open Source library software ,so Please send me the Details of Library Catalog add in koha cloud base . i humbly request please help me . My Koha Ip Address Is. http://192.168.1.82:8080/ -- ***Thanks & Regards* *Mr. Rajesh R.Shelar* *Sadhu Vaswani Institute Of Management Studies For Girl's ( MBA )* *Koregaon Road,Pune* *Mob.No.8380941380* *Save Water......Conserve Life.............*

6 6

Re: [Koha] Koha und GND
by Stowasser Rainer 09 Oct '17

09 Oct '17

Hallo Katrin danke für die Antwort. Die Titeldaten funktionieren perfekt (hier eine Anleitung wie der Zugang funktioniert http://abunchofthings.net/blog/freie-metadaten-von-der-dnb-per-sru/ ) Bin gerade dabei Kostenabschätzungen einzuholen um die Implementierung eines SRU für Normdaten in Koha abschätzen zu können (und bei mir für 2018 zu budgetieren ;-) LG Hofrat Mag. Rainer Stowasser Head of Library ZAMG ________________________________________ Von: Katrin Fischer [katrin.fischer.83(a)web.de] Gesendet: Montag, 09. Oktober 2017 08:10 An: Stowasser Rainer Betreff: Re: Koha und GND Hallo Rainer, Koha kann im Moment meines Wissens Normdaten leider nur über Z39.50 übernehmen. Ich habe dazu einmal ein enhancement aufgenommen, da wir auch immer wieder über dieses Problem stolpern: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19436 Das BSZ bietet einen Z39.50-Zugang zur OGND an, der frei genutzt werden kann: z3950n.bsz-bw.de:20210 Datenbank: swb104 kein Passwort UTF-8 Einige weitere Informationen findest du hier: https://wiki.bsz-bw.de/doku.php?id=v-team:daten:z39.50neu Allerdings haben wir einige Probleme mit der Suche festgestellt, da die Suchattribute bei uns anders als von Koha erwartet oder nicht implementiert sind. Dies kann aktuell leider auch nicht geändert werden. Generell Fragen immer lieber auf eine der Mailinglisten. Auf der deutschen Mailingliste ist zwar nicht viel los, aber in der Regel kommt auf eine Frage schnell eine Antwort: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-de Viele Grüße, Katrin Fischer On 04.10.2017 14:20, Stowasser Rainer wrote: > Hallo Kathrin > > wir haben uns beim Koha Vortrag Bibliothekarstag Linz gesehen > und soweit ich das verstanden habe bist Du die "Koha Deutsch Spezialistin". > > Deshalb technische Frage (geht sowas eigentlich auch über die Koha Liste ?) > > Habe mir einen Zugang zu den Titeldaten und der GND der DNB organisiert. > > Die Einrichtung des SRU für die Titeldaten ist kein Problem und funktioniert super. > > Bei den Normdaten will Koha aber einen z39.50 Server ...? > > Habe keine Möglichkeit gefunden die > > <recordSchema>MARC21-xml</recordSchema><recordPacking>xml</recordPacking><recordData><record type="Authority"> > > einzurichten da dies ja bei der DNB ja auch ein sru/gnd ist > > Kann man die GND direkt in Koha verwenden ? > > Gibts da einen Trick ? > > (Dr Google hat hier nicht weitergeholfen ;-) > > Vielen Dank. > > LG > Hofrat Mag. Rainer Stowasser > Head of Library ZAMG

1 0

Bug 19116
by Joel Sasse 08 Oct '17

08 Oct '17

Has the patch for bug # 19116 "Holds not set to waiting when "Confirm" is used" been pushed to 16.11 or 17.05? If not, will it be? I see it has been pushed to 17.11 Thanks, Joel Sasse Network Systems Administrator Plum Creek Library System 290 S Lake St Worthington, MN 56187 Office: 507-376-5803 Mobile: 507-360-8961 Fax: 507-376-9244 O

2 1

Software error: Koha Web Installer-MARC21
by bwengu 07 Oct '17

07 Oct '17

Hello, I am installing Koha on Ubuntu 16 and I have managed to go through everything until on *stage 3* where after selecting *mandatory* and *optional options* I get a *software error*. The error am getting is; DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect integer value: '' for column 'suggestible' at row 1 at /usr/share/koha/lib/Koha/SearchField.pm line 38 or DBIx::Class::Storage::DBI::_dbh_execute(): Data truncated for column 'type' at row 1 at /usr/share/koha/lib/Koha/Objects.pm line 101 Please hep me because am stack -- View this message in context: http://koha.1045719.n5.nabble.com/Software-error-Koha-Web-Installer-MARC21-… Sent from the Koha-general mailing list archive at Nabble.com.

7 7

Nature of Contents
by Ma. Victoria H. Silva-Manuel 06 Oct '17

06 Oct '17

Hi. How to make "Nature of Contents" field in 008 mandatory? Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 2

Slow report for periodicals ranked by circ
by Cab Vinton 05 Oct '17

05 Oct '17

Hi, All -- The following report takes several minutes to run, which leads to me the sad probability that my SQL skillz are ... weak: SELECT b.title, count(s.datetime) AS circs FROM statistics s JOIN ( SELECT itemnumber, biblionumber, homebranch, itype FROM deleteditems UNION SELECT itemnumber, biblionumber, homebranch, itype FROM items ) AS all_items USING (itemnumber) LEFT JOIN biblio b ON (b.biblionumber=all_items.biblionumber) WHERE all_items.itype = 'MAGAZINE' AND all_items.homebranch = <<Owning Library|branches>> AND s.itemnumber IS NOT NULL AND s.type IN ('issue') AND s.datetime BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> GROUP BY b.biblionumber ORDER BY circs DESC The report did run much quicker when I eliminated the UNION statement & used just one of the Items tables. Would be grateful to know if there's a better way of writing this report. Many thanks, Cab Vinton Plaistow Public Library Plaistow, NH

1 0

issues with late orders mail
by Hugo Agud 05 Oct '17

05 Oct '17

Good morning We are facing a problem sending mails to late orders Koha 3.22 .7 Postfix working fine for all other mail services (circulation, basket...etc) The issue is that when we try to claim to a vendor for late orders, we get a success message from koha 'email has been sent' , but no message has been sent in fact The claims counter remains at 0 the letter log remains blank the mail.log from server remains withoutchange no logs from plack-error, intranet-error... etc any idea on this? Thanks in advace -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind> <http://www.orex.es/omeka> Director Calle Sant Joaquin,117, 2º-3ª · 08922 Santa Coloma de Gramanet - Tel: 933 856 138 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.

1 0

Translating string at Koha manual 16.11
by Anthony Mao 04 Oct '17

04 Oct '17

Hi all, I am translator of Chinese (Taiwan). During the translation I found an issue: Koha manual 16.11 / 04_patrons.po String 21354473 Staff members can access their own check out screen by clicking their username in the top right of the staff client and choosing 'My checkouts'My checkouts Question: Take a close look at the last four words. <'My checkouts'My checkouts>. Whta it means? Shoud have a space or | between "checkouts'My"? Should I translate them word by word? -- Anthony Mao Fu Jen Catholic University, Taiwan Skype: maolins +886 2 29052334 (voice)

6 11