- Koha - lists.katipo.co.nz

Software error: ~~Duplicate entry '320' for key 'PRIMARY' at~~~
by Scott Owen 16 Nov '17

16 Nov '17

Another error....is this one also related to the bug 18003 ? seems very similar. >From one of my staff... ________________________________________________ I put a book that is checked out on hold. When it is returned, the system tells me who is waiting. I confirm the hold When I check the book out to the patron, I get this message: Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '320' for key 'PRIMARY' at /usr/share/koha/lib/Koha/Object.pm line 121 ____________________________________________________ Any fix for this one ?? -S

1 0

DBMS auto increment fix
by Scott Owen 16 Nov '17

16 Nov '17

Hi all, I have the following errors when my staff try and check in items: "The item has not been checked in due to a configuration issue in your system. You must ask an administrator to take a look at the about page and search for the "data problems" section" I have followed the solution as described https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#The_solution and I continue to get the error, and staff are unable to check in items. Is there a fix / workaround that my staff can do ?? -S

2 6

opac search
by Erlanda Simonyan 16 Nov '17

16 Nov '17

Dear Katrin , We have some problems in opac search in koha 17.05. When we search for a keyword and from the result page and the column of "refine your search" we clikck on any author's name that contains a hyphen, for example: I make links http://tert.nla.am/opac-tmpl/bootstrap/images/koha1%20(1).JPG http://tert.nla.am/opac-tmpl/bootstrap/images/koha2%20(1).JPG Thanks a lot, Erlanda

2 1

Statistics on Z39.50
by Hugo Agud 16 Nov '17

16 Nov '17

Good morning I wish to know how much Z39 is used in Koha, but I have no idea where to get info from z39.50 usage... any body could help us on this. how to retreive z39.50 server statistics in koha? Kindest regards -- *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.

2 1

Forcing to add and not update a subfield with the marc modification template tool
by Francois Charbonnier 15 Nov '17

15 Nov '17

Hello, I try to add subfield (repeatable subfield) within a field but I can't make it work. It updates the first subfield found. For exemple, I have : 040 $a SDM $b fre $d SQTD My rule is "Update field 040$d with value /CaQE"/ but I don't want to update the 040$d value, I want to add a new 040$d to get this : 040 $a SDM $b fre $d SQTD $d CaQE The problem is that I can only choose the "Add/Update" option when I set a new template. Does anyone know a trick to force the "Add" option when choosing the action "Add/Update" ? // Thank you! François/ / -- François Charbonnier, Bibl. prof. / Chef de produits Tél. : (888) 604-2627 francois.charbonnier(a)inLibro.com <mailto:francois.charbonnier@inLibro.com> inLibro | Spécialistes en technologies documentaires | www.inLibro.com <http://www.inLibro.com>

1 0

Re: [Koha] Koha Digest, Vol 145, Issue 14
by Yop S. Gyang 15 Nov '17

15 Nov '17

Hello everyone Please i have been trying to save my catalogued records and i get this error message Tag "" is not a valid tag. at /usr/share/koha/lib/C4/Biblio.pm line 2535 Please can anyone help with this? Warm regards ________________________________ From: Koha <koha-bounces(a)lists.katipo.co.nz> on behalf of koha-request(a)lists.katipo.co.nz <koha-request(a)lists.katipo.co.nz> Sent: Tuesday, November 14, 2017 10:49:13 PM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 145, Issue 14 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit https://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: Book reading (Tomas Cohen Arazi) 2. Re: Book reading (vikram zadgaonkar) 3. Call for News: November 2017 Newsletter (kohanews) 4. Statistics on Z39.50 (Hugo Agud) 5. Koha General Meeting Reminder - Roles for 18.05 (Nick Clemens) 6. Regarding the author entered in 700$a tag (Sahadeo Taware) 7. Re: Regarding the author entered in 700$a tag (vikram zadgaonkar) 8. KohaCon18 - Portland Oregon USA - "Together Towards Tomorrow" (Brendan Gallagher) ---------------------------------------------------------------------- Message: 1 Date: Tue, 14 Nov 2017 02:09:24 +0000 From: Tomas Cohen Arazi <tomascohen(a)gmail.com> To: Luis Moises Rojas <lmoisesrojas(a)gmail.com> Cc: Comunidad Koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Book reading Message-ID: <CABZfb=U3hXtqq27DxXp=AOz=tJsDNFyvz5irk6jFiewAXonKUw(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" You mean borrowed? El lun., 13 de nov. de 2017 11:39 a. m., Luis Moises Rojas < lmoisesrojas(a)gmail.com> escribió: > Hello everybody, > > How can we know how many times a book has been read? > > Thanks > > -- > *Luis Moisés Rojas P.* > > > < > https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai… > > > Libre > de virus. www.avast.com<http://www.avast.com> > < > https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai… > > > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F ------------------------------ Message: 2 Date: Tue, 14 Nov 2017 07:46:53 +0530 From: vikram zadgaonkar <vikramczadgaonkar(a)gmail.com> To: Luis Moises Rojas <lmoisesrojas(a)gmail.com> Cc: koha list <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Book reading Message-ID: <CAGACC3XaS+3BjdBu5OwEr1ceAq6QKEqimgotfXpS9hejy6R1jA(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hi, If it is borrowed,you can check in circulation history. If this is not the case, please explain in detail. On Nov 13, 2017 8:09 PM, "Luis Moises Rojas" <lmoisesrojas(a)gmail.com> wrote: > Hello everybody, > > How can we know how many times a book has been read? > > Thanks > > -- > *Luis Moisés Rojas P.* > > > <https://www.avast.com/sig-email?utm_medium=email&utm_ > source=link&utm_campaign=sig-email&utm_content=webmail> > Libre > de virus. www.avast.com<http://www.avast.com> > <https://www.avast.com/sig-email?utm_medium=email&utm_ > source=link&utm_campaign=sig-email&utm_content=webmail> > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 3 Date: Mon, 13 Nov 2017 19:06:52 -0800 From: kohanews <kohanews(a)gmail.com> To: koha-devel(a)lists.koha-community.org, koha(a)lists.katipo.co.nz Subject: [Koha] Call for News: November 2017 Newsletter Message-ID: <b87ef062-32c2-561b-1154-e6e9175c52fb(a)gmail.com> Content-Type: text/plain; charset=utf-8; format=flowed I'm collecting news for the November newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter ------------------------------ Message: 4 Date: Tue, 14 Nov 2017 09:55:08 +0100 From: Hugo Agud <hagud(a)orex.es> To: Koha list <koha(a)lists.katipo.co.nz> Subject: [Koha] Statistics on Z39.50 Message-ID: <CADT_QRQVOFCfTmVAf6PvgXRe_MZQhiw7D8WO7as7OWsHvREF8w(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Good morning I wish to know how much Z39 is used in Koha, but I have no idea where to get info from z39.50 usage... any body could help us on this. how to retreive z39.50 server statistics in koha? Kindest regards -- *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>] <http://www.orex.es/koha> [image: www.orex.es/vufind<http://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. ------------------------------ Message: 5 Date: Tue, 14 Nov 2017 11:28:23 +0000 From: Nick Clemens <nick(a)bywatersolutions.com> To: Koha <koha(a)lists.katipo.co.nz>, Koha Devel <koha-devel(a)lists.koha-community.org> Subject: [Koha] Koha General Meeting Reminder - Roles for 18.05 Message-ID: <CAA_eX3OEea6W8E4+vHoszn_cB8hkUKS0_sD892r+LGXMe=iSXw(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hello All, Just a reminder that we have a meeting scheduled tomorrow, 15 November 2017, 14:00 UTC This meeting will be held to vote on roles for 18.05 The agenda is here: https://wiki.koha-community.org/wiki/General_IRC_meeting_15_November_2017#A… You can see candidates (or add your name) here: https://wiki.koha-community.org/wiki/Roles_for_18.05 Anyone interested in "Calendar Manager" will get as much help from me as they want :-b You can add the calendar here to get updates on all scheduled meetings: https://koha-community.org/calendar/ Hope to see you all there. -Nick (kidclamp) ------------------------------ Message: 6 Date: Tue, 14 Nov 2017 22:01:36 +0530 From: Sahadeo Taware <sahadeo.taware(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] Regarding the author entered in 700$a tag Message-ID: <CAO3W30DYZa3Fton5Op_OuKnFZQwzo_ouKaQOSLixbP118c0=qA(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Dear Friends I want a simple report in which I want Acc. No., Title, Author, Publisher and Co-Authors I entered the co-authors in 700$a tag but there is no koha mapping in this field, How can I extract value from 700$a tag Can u please send me the sql query for the same - Sahadeo D. Taware Librarian, M.L.I.Sc., NET Thakur College of Science and Commerce Thakur Village, Kandivli(E), Mumbai 400101 Mob. No 9324912816 ------------------------------ Message: 7 Date: Tue, 14 Nov 2017 22:03:16 +0530 From: vikram zadgaonkar <vikramczadgaonkar(a)gmail.com> To: Sahadeo Taware <sahadeo.taware(a)gmail.com> Cc: koha list <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Regarding the author entered in 700$a tag Message-ID: <CAGACC3WN6tym5ahnpBr7o+WvjgChnUhbKT3S-a8YrBg1GY8Rxw(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hi, You can use extract function for this. On Nov 14, 2017 10:02 PM, "Sahadeo Taware" <sahadeo.taware(a)gmail.com> wrote: > Dear Friends > > I want a simple report in which I want Acc. No., Title, Author, Publisher > and Co-Authors > I entered the co-authors in 700$a tag but there is no koha mapping in this > field, How can I extract value from 700$a tag > > Can u please send me the sql query for the same > - > Sahadeo D. Taware > Librarian, M.L.I.Sc., NET > Thakur College of Science and Commerce > Thakur Village, Kandivli(E), Mumbai 400101 > Mob. No 9324912816 > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 8 Date: Tue, 14 Nov 2017 13:49:08 -0800 From: Brendan Gallagher <info(a)bywatersolutions.com> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz>, Koha Devel <koha-devel(a)lists.koha-community.org> Subject: [Koha] KohaCon18 - Portland Oregon USA - "Together Towards Tomorrow" Message-ID: <CANGWTFQz5vtLjHtjrZ4C6yAspo6TnSmD3GsStXeG9RGMMdtwmw(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hello All - It has been decided that the next KohaCon will be in Portland, OR USA from September 10th (Monday) to September 12th (Wednesday) in 2018 - followed by a local cultural day and a 3 day hackfest over the weekend. The theme for KohaCon18 will be "Together Towards Tomorrow". A majority of the focus will be on community building, community engagement, and building Koha for the future. We've started planning and starting at the beginning of next year you should plan on seeing a bunch of information and marketing about the conference (website, etc.). We are extremely excited to be hosting and this conference will be tons of fun! If you have a chance to mark your calendars please do! Koha is awesome! (Much more to follow) Cheers, Brendan -- --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Office: Portland, OR - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com info(a)bywatersolutions.com ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 145, Issue 14 *************************************

1 0

Regarding the author entered in 700$a tag
by Sahadeo Taware 15 Nov '17

15 Nov '17

Dear Friends I want a simple report in which I want Acc. No., Title, Author, Publisher and Co-Authors I entered the co-authors in 700$a tag but there is no koha mapping in this field, How can I extract value from 700$a tag Can u please send me the sql query for the same - Sahadeo D. Taware Librarian, M.L.I.Sc., NET Thakur College of Science and Commerce Thakur Village, Kandivli(E), Mumbai 400101 Mob. No 9324912816

4 3

KohaCon18 - Portland Oregon USA - "Together Towards Tomorrow"
by Brendan Gallagher 14 Nov '17

14 Nov '17

Hello All - It has been decided that the next KohaCon will be in Portland, OR USA from September 10th (Monday) to September 12th (Wednesday) in 2018 - followed by a local cultural day and a 3 day hackfest over the weekend. The theme for KohaCon18 will be "Together Towards Tomorrow". A majority of the focus will be on community building, community engagement, and building Koha for the future. We've started planning and starting at the beginning of next year you should plan on seeing a bunch of information and marketing about the conference (website, etc.). We are extremely excited to be hosting and this conference will be tons of fun! If you have a chance to mark your calendars please do! Koha is awesome! (Much more to follow) Cheers, Brendan -- --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Office: Portland, OR - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com info(a)bywatersolutions.com

1 0

Koha General Meeting Reminder - Roles for 18.05
by Nick Clemens 14 Nov '17

14 Nov '17

Hello All, Just a reminder that we have a meeting scheduled tomorrow, 15 November 2017, 14:00 UTC This meeting will be held to vote on roles for 18.05 The agenda is here: https://wiki.koha-community.org/wiki/General_IRC_meeting_15_November_2017#A… You can see candidates (or add your name) here: https://wiki.koha-community.org/wiki/Roles_for_18.05 Anyone interested in "Calendar Manager" will get as much help from me as they want :-b You can add the calendar here to get updates on all scheduled meetings: https://koha-community.org/calendar/ Hope to see you all there. -Nick (kidclamp)

1 0

Call for News: November 2017 Newsletter
by kohanews 14 Nov '17

14 Nov '17

I'm collecting news for the November newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0