Re: [Koha] Retirement Village Library

2017-08-03 Thread Bob Birchall
Hi Eleanor, Koha will meet your requirements plus some. There are Koha users with quite small collections. Koha will scale from very small to the largest collections. Underneath the hood is a powerful engine offering far more than you need, but doing no harm if under utilised. The main cons

Re: [Koha] Retirement Village Library

2017-08-03 Thread Balaji Ravichandran
Hi, Thank you for considering Koha into the option. My opinion is that in terms of Villages, The Catalogue is more important for User experiences. I would prefer Koha setup for that library and import the records from Excel into Koha. This would help and requires less effort as you are not into *Ci

Re: [Koha] Retirement Village Library

2017-08-03 Thread vikram zadgaonkar
Hi Eleanor, I can help you in setting up koha as you are working for community library. Please mail your requirement in detail. On Aug 4, 2017 10:14 AM, "Eleanor Bensemann" wrote: > Hi everyone. I have been a librarian most of my life, and am still working > in a casual on-call capacity. > > I h

[Koha] Retirement Village Library

2017-08-03 Thread Eleanor Bensemann
Hi everyone. I have been a librarian most of my life, and am still working in a casual on-call capacity. I have recently taken over the management of this small library and am running it with a team of helpers. There is a catalogue system of sorts on Excel sheets but it is far from user friendly.

Re: [Koha] Slow OPAC search

2017-08-03 Thread Jonathan Druart
Restart memcached and plack (if running) to take into account the changes. On Thu, 3 Aug 2017 at 21:01 Manoj Kummini wrote: > Thank you for your reply. > > On Thu 03 Aug 2017 14:02:53 +, jonathan.dru...@bugs.koha-community.org > wrote: > > > Koha 3.22.02 is a lot of versions behind the last

Re: [Koha] Slow OPAC search

2017-08-03 Thread Manoj Kummini
Thank you for your reply. On Thu 03 Aug 2017 14:02:53 +, jonathan.dru...@bugs.koha-community.org wrote: > Koha 3.22.02 is a lot of versions behind the last 3.22.x version > (3.22.21). > > Take a look at the value of use_zebra_facets in your koha-conf.xml file. > If enabled, disable it (see

Re: [Koha] Report error (SQL )

2017-08-03 Thread Luis Moises Rojas
Yes , i AM using 17.05 Thanks El 3 ago. 2017 5:25 PM, "John Sterbenz" escribió: > Hello Luis, > > There was a big change in the way MARC data is handled in 17.05. marcxml > is no longer in the biblioitems table--it is now biblio_metadata.metadata > > If you're running 17.05, this would be a gre

Re: [Koha] Report error (SQL )

2017-08-03 Thread John Sterbenz
Hello Luis, There was a big change in the way MARC data is handled in 17.05. marcxml is no longer in the biblioitems table--it is now biblio_metadata.metadata If you're running 17.05, this would be a great place to start looking to update your query. If you're not on 17.05, I'm afraid I don't h

Re: [Koha] Report error (SQL )

2017-08-03 Thread Katrin
Hi Luis, where does it say the field is obsolete? Katrin On 03.08.2017 22:16, Luis Moises Rojas wrote: Hello everybody. We have an sql senteces to extract SUBTITLE (ExtractValue(biblioitems.marcxml, '//datafield[@tag="245"]/subfield[@code="b"]') AS "Subtitulo) but now it say this field is ob

Re: [Koha] How are authority records connected with biblio records ?

2017-08-03 Thread Chris Cormack
* David Holoshka (david.holos...@ub.lu.se) wrote: Hi, I am migrating several million records from an existing vtls system to koha. We are using mariadb, koha 17.05 (have pulled from master yesterday ), elastic search 5.4 and plack on debian systems. As I wanted to preserve all the authority

[Koha] Report error (SQL )

2017-08-03 Thread Luis Moises Rojas
Hello everybody. We have an sql senteces to extract SUBTITLE (ExtractValue(biblioitems.marcxml, '//datafield[@tag="245"]/subfield[@code="b"]') AS "Subtitulo) but now it say this field is obsolete. Where is the subttile? Thanks -- *Luis Moisés Rojas P.*

[Koha] Having sevaral errors

2017-08-03 Thread Luis Moises Rojas
Hello everybody, We are having many error: 1. When in catalogin when you search a title and click the TITLE to edit, it say: Export bib-23322.dublin...xml and Says: MARK VIEW and nothing happen 2. In report , option USE SAVE REPORT (utilizar salvados), say: UPDATING SQL. Why? 3. When try to e

Re: [Koha] How to remove unwanted characters when importing MARC data? [SOLVED]

2017-08-03 Thread Michael Kuhn
Hi Just for the record. On 22 June 2017 I wrote: Yesterday I wrote: Our library receives MARC data from EKZ (a German cataloging data provider) which includes two unwanted characters: * a beginning "non-sorting character" * an ending "non-sorting character" These characters can't be seen i

Re: [Koha] [Important] Update your MySQL|MariaDB configuration to avoid data loss

2017-08-03 Thread Bortel, Gary
I tried implementing multiple init-file= statements(...one for each instance of Koha hosted on our machine...) in our my.cnf file along with multiple init-file_kohaxxx.sql files. Looking at the mysql error.log, it appears only the last init-file= statement was read and executed upon restart. I'v

Re: [Koha] Possibilities and Help in Translation

2017-08-03 Thread Jonathan Druart
Hi Balaji, Welcome! :) This language already exists on our translation server ( http://translate.koha-community.org/ta/). You should take a look at https://wiki.koha-community.org/wiki/Translating_Koha to know how to translate Koha. I am not a translator so I cannot help you more. The language is

[Koha] How are authority records connected with biblio records ?

2017-08-03 Thread David Holoshka
Hi, I am migrating several million records from an existing vtls system to koha. We are using mariadb, koha 17.05 (have pulled from master yesterday ), elastic search 5.4 and plack on debian systems. As I wanted to preserve all the authority to biblio record links I wrote my own migration

Re: [Koha] Slow OPAC search

2017-08-03 Thread Jonathan Druart
Hello Manoj, Koha 3.22.02 is a lot of versions behind the last 3.22.x version (3.22.21). Take a look at the value of use_zebra_facets in your koha-conf.xml file. If enabled, disable it (see bug 13665). If you are not using Plack, take a look at this wiki page https://wiki.koha-community.org/wiki

Re: [Koha] Koha capacity planning advice?

2017-08-03 Thread Jonathan Druart
Hi Chris, I have opened a new card on our kanban tool and asked some of the guys to list configurations. Hopefully we will get more answers and will be able to create an example list. https://tree.taiga.io/project/joubu-koha-rm-1711/us/132 Regards, Jonathan On Sat, 22 Jul 2017 at 05:00 Chris Br

Re: [Koha] [Important] Update your MySQL|MariaDB configuration to avoid data loss

2017-08-03 Thread Jonathan Druart
Vinod, Yes you should create the file to make sure the situation will not appear again for other rows. For the corrupted records (the ones returned by the SQL queries), please follow bug 19016. Regards, Jonathan On Thu, 3 Aug 2017 at 05:00 vinod mishra wrote: > Dear All, > > I am using Koha 16

Re: [Koha] Koha Acquisition Module - problems when modifying the price, conversion rate and currency while receving the order

2017-08-03 Thread Tajoli Zeno
Hi Paul and all, I confirm that there is a bug about this topic. I create a bug in bugzilla here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19030 I can't write the code to fix it. I suggest to ask for a quote to fix it to many dirm that work on Koha, https://koha-community.org/

[Koha] Possibilities and Help in Translation

2017-08-03 Thread Balaji Ravichandran
Hi, I am new to Koha Community. I have done 4 Koha Setup across TamilNadu, India. Our Koha Community here has decided to translate Koha into our native language. - Action - Translation - Language - தமிழ் (Tamil) Is Translation possible in Koha? If so, suggest some methods or getting started

Re: [Koha] Search for "see also" records shows NO RESULTS FOUND

2017-08-03 Thread Michael Kuhn
Hi Tomas Did the EmbedSeeFromInSearches syspref get changed? No system preferences were changed after the update. The Koha system preference "IncludeSeeFromInSearches" was set to "Include" in Koha 3.20 and is still set like this in Koha 17.05. Best wishes: Michael -- Geschäftsführer · Dipl

[Koha] Slow OPAC search

2017-08-03 Thread Manoj Kummini
Hello everyone, I am new on this list, and have just begun, with a colleague, managing the KOHA installation in our library that has about 1 books and some journals. Our OPAC had become terribly slow and on exploring we noticed that a mysqldump would result in a file of over 5GB. This large s

Re: [Koha] Search for "see also" records shows NO RESULTS FOUND

2017-08-03 Thread Tomas Cohen Arazi
Did the EmbedSeeFromInSearches syspref get changed? El jue., 3 de ago. de 2017 1:21 AM, Michael Kuhn escribió: > Hi > > After an update from Koha 3.20.4 we work on a new host with Debian > GNU/Linux 8 and Koha 17.05.1. > > Our catalog contains authority records with "see also" records. For > exa