Re: [Koha] SQL report: Digests in message preferences
Hello Chad, It's stored in the borrower_message_preferences.wants_digest column. So the following query should return what you want: > select distinct borrowernumber from borrower_message_preferences where > wants_digest=1; Regards, Jonathan 2015-04-01 1:11 GMT+02:00 Chad Roseburg : > Does anyone have a report showing barcodes of patrons who do not have the > "Digests only?" option enabled. > > I see the transport types but am not sure how the digest option is stored. > > Thank you! > > -- > Chad Roseburg > Automation Dept. > North Central Regional Library > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] koha-common | mpm-itk on wheezy
Hi, Trying to create a new site on wheezy, koha-common 3.18.05.1: root@data:~# koha-create --create-db --marcflavor unimarc --zebralang en test I get: Koha requires mpm_itk to be enabled within Apache in order to run. Typically this can be enabled with: sudo a2enmod mpm_itk root@data:~# a2enmod mpm_itk ERROR: Module mpm_itk does not exist! root@data:~# apt-get install apache2-mpm-itk Reading package lists... Done Building dependency tree Reading state information... Done apache2-mpm-itk is already the newest version. So, it seems I have apache2-mpm-itk installed, however nothing *itk* is present under /etc/apache2/mods-available, and I cannot enable it. Any ideas? ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] koha-common | mpm-itk on wheezy
Greetings, Did you check for libapache2-mpm-itk? $ sudo apt-get install libapache2-mpm-itk $ sudo a2enmod mpm_itk GPML, Mark Tompsett -Original Message- From: mourik jan heupink Sent: Wednesday, April 01, 2015 7:43 AM To: koha@lists.katipo.co.nz Subject: [Koha] koha-common | mpm-itk on wheezy Hi, Trying to create a new site on wheezy, koha-common 3.18.05.1: root@data:~# koha-create --create-db --marcflavor unimarc --zebralang en test I get: Koha requires mpm_itk to be enabled within Apache in order to run. Typically this can be enabled with: sudo a2enmod mpm_itk root@data:~# a2enmod mpm_itk ERROR: Module mpm_itk does not exist! root@data:~# apt-get install apache2-mpm-itk Reading package lists... Done Building dependency tree Reading state information... Done apache2-mpm-itk is already the newest version. So, it seems I have apache2-mpm-itk installed, however nothing *itk* is present under /etc/apache2/mods-available, and I cannot enable it. Any ideas? ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] koha-common | mpm-itk on wheezy
Hi Mark, root@data:/etc/apache2# apt-get install libapache2-mpm-itk Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package libapache2-mpm-itk root@data:/etc/apache2# I guess ubuntu calls it libapache2-mpm-itk, and debian calls it apache2-mpm-itk. (because that second package IS installed) On 4/1/2015 13:56, Mark Tompsett wrote: Greetings, Did you check for libapache2-mpm-itk? $ sudo apt-get install libapache2-mpm-itk $ sudo a2enmod mpm_itk GPML, Mark Tompsett -Original Message- From: mourik jan heupink Sent: Wednesday, April 01, 2015 7:43 AM To: koha@lists.katipo.co.nz Subject: [Koha] koha-common | mpm-itk on wheezy Hi, Trying to create a new site on wheezy, koha-common 3.18.05.1: root@data:~# koha-create --create-db --marcflavor unimarc --zebralang en test I get: Koha requires mpm_itk to be enabled within Apache in order to run. Typically this can be enabled with: sudo a2enmod mpm_itk root@data:~# a2enmod mpm_itk ERROR: Module mpm_itk does not exist! root@data:~# apt-get install apache2-mpm-itk Reading package lists... Done Building dependency tree Reading state information... Done apache2-mpm-itk is already the newest version. So, it seems I have apache2-mpm-itk installed, however nothing *itk* is present under /etc/apache2/mods-available, and I cannot enable it. Any ideas? ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] koha-common | mpm-itk on wheezy
Indeed, on wheezy the package is called "apache2-mpm-itk" and since Jessie its called "libapache2-mpm-itk" and "apache2-mpm-itk" is a transitional package. Do you have /usr/lib/apache2/mpm-itk ? The itk package just changes the symlink : /usr/sbin/apache2 -> /usr/lib/apache2/mpm-worker/apache2 Regards, Le 01/04/2015 14:03, mourik jan heupink a écrit : Hi Mark, root@data:/etc/apache2# apt-get install libapache2-mpm-itk Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package libapache2-mpm-itk root@data:/etc/apache2# I guess ubuntu calls it libapache2-mpm-itk, and debian calls it apache2-mpm-itk. (because that second package IS installed) On 4/1/2015 13:56, Mark Tompsett wrote: Greetings, Did you check for libapache2-mpm-itk? $ sudo apt-get install libapache2-mpm-itk $ sudo a2enmod mpm_itk GPML, Mark Tompsett -Original Message- From: mourik jan heupink Sent: Wednesday, April 01, 2015 7:43 AM To: koha@lists.katipo.co.nz Subject: [Koha] koha-common | mpm-itk on wheezy Hi, Trying to create a new site on wheezy, koha-common 3.18.05.1: root@data:~# koha-create --create-db --marcflavor unimarc --zebralang en test I get: Koha requires mpm_itk to be enabled within Apache in order to run. Typically this can be enabled with: sudo a2enmod mpm_itk root@data:~# a2enmod mpm_itk ERROR: Module mpm_itk does not exist! root@data:~# apt-get install apache2-mpm-itk Reading package lists... Done Building dependency tree Reading state information... Done apache2-mpm-itk is already the newest version. So, it seems I have apache2-mpm-itk installed, however nothing *itk* is present under /etc/apache2/mods-available, and I cannot enable it. Any ideas? ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Fridolin SOMERS Biblibre - Pôles support et système fridolin.som...@biblibre.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] lost barcode focus and jquery
I try to reproduce. What is your Koha version ? Which the page are you on ? The "search box", you mean the form with "Search the catalog" at the bottom ? Regards, Le 31/03/2015 02:46, Marty Jongepier a écrit : I have an annoying issue with koha, not world shocking, but it would be nice to get a solution. What happens is that if we scan a barcode, either for checking in or checking out, the focus moves from the barcode box to the search box (iceweasel, firefox, chrome...). It is annoying, to say the least, to have to click in the check in box (or check out) after every item scanned. Cleaning the cache, as somebody suggested, does not help either. It used not to be like that. You could scan as many items as you wanted and the focus would stay on the check in box. Some people told me that it was easily solved with jquery, but I am not a programmer. I have tried a few things, but so far no code in jquery I have written has solved this. Could any of you maybe help us out, give us some sample code for this? Running Koha on Debian Wheezy. Thank you! Marty ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Fridolin SOMERS Biblibre - Pôles support et système fridolin.som...@biblibre.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SQL report: Digests in message preferences
Thanks Jonathan! Exactly what I was looking for. On Wed, Apr 1, 2015 at 1:31 AM, Jonathan Druart < jonathan.dru...@biblibre.com> wrote: > Hello Chad, > > It's stored in the borrower_message_preferences.wants_digest column. > So the following query should return what you want: > > select distinct borrowernumber from borrower_message_preferences where > wants_digest=1; > > Regards, > Jonathan > > 2015-04-01 1:11 GMT+02:00 Chad Roseburg : > > Does anyone have a report showing barcodes of patrons who do not have the > > "Digests only?" option enabled. > > > > I see the transport types but am not sure how the digest option is > stored. > > > > Thank you! > > > > -- > > Chad Roseburg > > Automation Dept. > > North Central Regional Library > > ___ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Chad Roseburg Automation Dept. North Central Regional Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Migration ISIS to Koha
Hi guys, i am Sergio from Argentina, we are trying to migrate Isis to Koha and i have a problem. The problem is that in the ISIS database I got the title field repeatable (it is used to store the title´s book in diferents languajes), and in MARC21 the field 245 is not repeatable. When I try to get the file with the marc21 records in those books I got the field title more than one time and the import fails. The PFT code that I use to get the title is this: if p(v020) then |=245 00$a|v020^*,if p(v20^s) then | : $b|v20^s fi/ else if p(v024) then |=245 00$a|v024^*,if p(v24^s) then | : $b|v24^s fi/ else if p(v030) then |=245 00$a|v030^*,if p(v30^s) then | : $b|v30^s fi/ fi fi fi (|=020 $a|v010/)/ ## The problem with this is that if a book got tow times the field 20 in the file I get: =245 $aenglisTitle$benglisSubtitle =245 $arussianTitle$brussianSubtitle Can someone help me with this issue? Thx! (I am sorry if I am violating some rule about the list, I am new at this) __ Información de ESET Endpoint Antivirus, versión de la base de firmas de virus 11411 (20150401) __ ESET Endpoint Antivirus ha comprobado este mensaje. http://www.eset.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Migration ISIS to Koha
Sergio, modifica la salida en tu PFT para que la segunda ocurrencia del titulo tenga otra etiqueta (por ej. 246). Te recomiendo que veas la siguiente informacion de como se codifica en MARC titulos en dos o mas idiomas. Asi te daras una idea de como debe ser tu salida: See here: http://www.loc.gov/marc/bibliographic/bd245.html And then here: http://www.loc.gov/marc/bibliographic/bd246.html You can change the second title occurence tag En MarcEdit podrias tambien hacer los cambios que consideres necesarios. Saludos, Felipe Adalid ortiz Anzaldo Biblioteca Loyola http://www.biblioteca.iberotijuana.edu.mx Ibero Tijuana http://www.iberotijuana.edu.mx This message was sent using IMP, the Internet Messaging Program. -- Este correo electronico puede contener informacion confidencial y privilegiada, por lo que se prohibe el uso, reproduccion, retransmision o divulgacion no autorizada, parcial o total, de su contenido. Si usted no es el destinatario del presente correo, por favor notifiquelo al remitente mediante reenvio a su correo electronico y borrelo de inmediato. Para conocer el aviso de privacidad le pedimos acceder a la siguiente liga: http://www.iberotijuana.edu.mx/?doc=/avisoprivacidad/index.html -- Los acentos han sido removidos intencionalmente para facilitar la lectura del mensaje independiente a la codificacion del mismo. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Migration ISIS to Koha
Hola Felipe! Muchas gracias por responder! Me podrias indicar como hago para hacer que la segunda ocurrencia salga en otro tag? Porque no se como seleccionar dentro del campo las posiciones, ¿Como me puedo mover dentro del "arreglo" de titulos que me da ISIS? ¿Hay algo como v20[0] o algo donde le indico a traves de un índice en que posicion estoy parado? Disculpa si es una pregunta MUY basica pero nunca use ni ISIS ni Marc y estoy aprendiendo de a poco. Saludos Cordiales. -Mensaje original- De: ada...@tij.uia.mx [mailto:ada...@tij.uia.mx] Enviado el: miércoles, 01 de abril de 2015 02:27 p.m. Para: Sergio Scotto CC: koha@lists.katipo.co.nz Asunto: Re: [Koha] Migration ISIS to Koha Sergio, modifica la salida en tu PFT para que la segunda ocurrencia del titulo tenga otra etiqueta (por ej. 246). Te recomiendo que veas la siguiente informacion de como se codifica en MARC titulos en dos o mas idiomas. Asi te daras una idea de como debe ser tu salida: See here: http://www.loc.gov/marc/bibliographic/bd245.html And then here: http://www.loc.gov/marc/bibliographic/bd246.html You can change the second title occurence tag En MarcEdit podrias tambien hacer los cambios que consideres necesarios. Saludos, Felipe Adalid ortiz Anzaldo Biblioteca Loyola http://www.biblioteca.iberotijuana.edu.mx Ibero Tijuana http://www.iberotijuana.edu.mx This message was sent using IMP, the Internet Messaging Program. -- Este correo electronico puede contener informacion confidencial y privilegiada, por lo que se prohibe el uso, reproduccion, retransmision o divulgacion no autorizada, parcial o total, de su contenido. Si usted no es el destinatario del presente correo, por favor notifiquelo al remitente mediante reenvio a su correo electronico y borrelo de inmediato. Para conocer el aviso de privacidad le pedimos acceder a la siguiente liga: http://www.iberotijuana.edu.mx/?doc=/avisoprivacidad/index.html -- Los acentos han sido removidos intencionalmente para facilitar la lectura del mensaje independiente a la codificacion del mismo. __ Información de ESET Endpoint Antivirus, versión de la base de firmas de virus 11411 (20150401) __ ESET Endpoint Antivirus ha comprobado este mensaje. http://www.eset.com __ Información de ESET Endpoint Antivirus, versión de la base de firmas de virus 11411 (20150401) __ ESET Endpoint Antivirus ha comprobado este mensaje. http://www.eset.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Publication date fields in Koha
Hello everyone, I'm trying to clean up some data from the RDA-related changes when we updated our framework a while back and have a few topics/questions regarding the publication fields (particularly the dates): - Can someone explain to me where the publisher, location, and date come from in the OPAC's search results? The reason I ask is that Koha seems to be pulling it from EITHER field 260 OR 264, is that correct? I've run a SQL query that shows I have the publisher information in only one of those fields for every record, but Koha still displays it. - Should I be "worried" that for some records I have the publication data in marcxml field 260 and for others I see it in 264, even for recently-added records within the same framework? Shouldn't the data show up in the same place if using the same framework? - How do the biblio.copyrightdate and biblioitems.publicationyear dates get populated? It doesn't seem like I have anything in 'biblioitems.publicationyear' at all.should I? And I see the biblio.copyrightdate for those records where the 264$c marcxml field is populated, but not the ones that have the publication information in the 260$c marcxml field. In case anyone else cares to look at publication date information in their own environment, here's a SQL query that shows you all of the various copyright date/publication year fields I mention above for ALL your biblios: SELECT items.biblionumber,items.itype,biblio.title,items.barcode,biblio.copyrightda te,biblioitems.publicationyear,biblio.frameworkcode,ExtractValue(marcxml,'// datafield[@tag="260"]/subfield[@code="c"]') AS marc260c, ExtractValue(marcxml,'//datafield[@tag="264"]/subfield[@code="c"]') AS marc264c FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ORDER BY items.biblionumber ASC Hope this makes sense.just trying to figure out where the publication data SHOULD be and why it doesn't seem consistent in my environment. Thanks in advance! Steve ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] MOREnet 2015 Annual Conference
http://tinyurl.com/on6ygfy Call for presentations. Also a good opportunity for vendors. Although sadly I won't be attending a Koha or Evergreen (EG) presentation would be great. Many libraries in Missouri use EG and all have heard of Koha. / //"//MOREnet’s Annual Conference is a professional development opportunity that allows our attendees to pick the learning experience that’s right for you."/ -- Greg Lawson ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SQL report: Digests in message preferences
(General reminder to add things like this to the wiki) Cheers, Liz :) On 02/04/15 05:37, Chad Roseburg wrote: > Thanks Jonathan! Exactly what I was looking for. > > On Wed, Apr 1, 2015 at 1:31 AM, Jonathan Druart < > jonathan.dru...@biblibre.com> wrote: > >> Hello Chad, >> >> It's stored in the borrower_message_preferences.wants_digest column. >> So the following query should return what you want: >>> select distinct borrowernumber from borrower_message_preferences where >> wants_digest=1; >> >> Regards, >> Jonathan >> >> 2015-04-01 1:11 GMT+02:00 Chad Roseburg : >>> Does anyone have a report showing barcodes of patrons who do not have the >>> "Digests only?" option enabled. >>> >>> I see the transport types but am not sure how the digest option is >> stored. >>> Thank you! >>> >>> -- >>> Chad Roseburg >>> Automation Dept. >>> North Central Regional Library >>> ___ >>> Koha mailing list http://koha-community.org >>> Koha@lists.katipo.co.nz >>> http://lists.katipo.co.nz/mailman/listinfo/koha > > -- -- Liz Rea Catalyst.Net Limited Level 6, Catalyst House, 150 Willis Street, Wellington. P.O Box 11053, Manners Street, Wellington 6142 GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] koha-common | mpm-itk on wheezy
mourik jan heupink schreef op wo 01-04-2015 om 13:43 [+0200]: > > Trying to create a new site on wheezy, koha-common 3.18.05.1: > > root@data:~# koha-create --create-db --marcflavor unimarc --zebralang > Koha requires mpm_itk to be enabled within Apache in order to run. > Typically this can be enabled with: Curious. Can you please paste the output of: sudo /usr/sbin/apache2ctl -v and sudo /usr/sbin/apache2ctl -M -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Migration ISIS to Koha
Hola Sergio.. Si estas tratando de migrar una base ISIS a Koha te puede ser muy útil (o tal vez no) el siguiente enlace: http://wiki.koha-community.org/wiki/Migration_from_ISIS_to_Koha_%28Spanish%29 Despues de que tengas la idea general de los pasos a seguir... vas a necesitar recurrir a lo siguiente, para poder obtener una exportación lo más completa posible: http://bvsmodelo.bvsalud.org/download/cisis/CISIS-LinguagemFormato4-es.pdf En el caso particular de los títulos, si podés hacer referencia a una ocurrencia en particular y probar algo como: (if p(v20) then if occ=1 then '=245',v20 else '=246',v20 fi fi/) No te aseguro que ese sea el formato que funcione, porque lo armé de memoria... pero me imagino que es algo muy parecido Saluos y mucha suerte! Que presentaría la primera ocurrencia e El Miércoles 1 Abril 2015 14:51 ART, "Sergio Scotto" Ha escrito: > Hola Felipe! > Muchas gracias por responder! > > Me podrias indicar como hago para hacer que la segunda ocurrencia salga en > otro tag? Porque no se como seleccionar dentro del campo las posiciones, > ¿Como me puedo mover dentro del "arreglo" de titulos que me da ISIS? > > ¿Hay algo como v20[0] o algo donde le indico a traves de un índice en que > posicion estoy parado? > > Disculpa si es una pregunta MUY basica pero nunca use ni ISIS ni Marc y > estoy aprendiendo de a poco. > > Saludos Cordiales. > > > -Mensaje original- > De: ada...@tij.uia.mx [mailto:ada...@tij.uia.mx] > Enviado el: miércoles, 01 de abril de 2015 02:27 p.m. > Para: Sergio Scotto > CC: koha@lists.katipo.co.nz > Asunto: Re: [Koha] Migration ISIS to Koha > > Sergio, modifica la salida en tu PFT para que la segunda ocurrencia del > titulo tenga otra etiqueta (por ej. 246). Te recomiendo que veas la siguiente > informacion de como se codifica en MARC titulos en dos o mas idiomas. Asi te > daras una idea de como debe ser tu salida: > > See here: > > http://www.loc.gov/marc/bibliographic/bd245.html > > And then here: > > http://www.loc.gov/marc/bibliographic/bd246.html > > > You can change the second title occurence tag > > En MarcEdit podrias tambien hacer los cambios que consideres necesarios. > > Saludos, > > Felipe Adalid ortiz Anzaldo > Biblioteca Loyola http://www.biblioteca.iberotijuana.edu.mx > Ibero Tijuana http://www.iberotijuana.edu.mx > > > This message was sent using IMP, the Internet Messaging Program. > > > -- > Este correo electronico puede contener informacion confidencial y > privilegiada, por lo que se prohibe el uso, reproduccion, retransmision o > divulgacion no autorizada, parcial o total, de su contenido. Si usted no es > el destinatario del presente correo, por favor notifiquelo al remitente > mediante reenvio a su correo electronico y borrelo de inmediato. Para > conocer el aviso de privacidad le pedimos acceder a la siguiente liga: > http://www.iberotijuana.edu.mx/?doc=/avisoprivacidad/index.html > -- > Los acentos han sido removidos intencionalmente para facilitar la lectura > del mensaje independiente a la codificacion del mismo. > > __ Información de ESET Endpoint Antivirus, versión de la base de > firmas de virus 11411 (20150401) __ > > ESET Endpoint Antivirus ha comprobado este mensaje. > > http://www.eset.com > > > > > > > __ Información de ESET Endpoint Antivirus, versión de la base de > firmas de virus 11411 (20150401) __ > > ESET Endpoint Antivirus ha comprobado este mensaje. > > http://www.eset.com > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha