- Koha - lists.katipo.co.nz

How to return from version 17.05 to 16.05
by Luis Moises Rojas 09 Aug '17

09 Aug '17

Hello everybody, We upgrade from 16.05 to 17.05. Now we are having at lot of problems. We can not work at all. Is there is a way to get back? Previous version where everything was ok? Thanks -- *Luis Moisés Rojas P.*

3 11

Unknown column 'metadata' in 'field list'
by Vimal Kumar V. 09 Aug '17

09 Aug '17

Dear Friends, I am trying to generate a book list with keywords from 650$a using the following SQL query, SELECT ExtractValue( metadata, '//datafield[@tag="650"]/subfield[@code="a"]' ) AS Keyword, items.barcode, items.dateaccessioned, items.itemcallnumber, biblio.author, biblio.title, biblioitems.pages, biblioitems.publishercode, biblioitems.place, biblio.copyrightdate FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) ORDER BY LPAD(items.barcode,40,' ') ASC After running the report, I got the following error message, The database returned the following error: Unknown column 'metadata' in 'field list' Please check the log for further details. Please review the SQL query and help me to solve the problem. Regards, -- Vimal Kumar V. Librarian School of Indian Legal Thought Mahatma Gandhi University Kottayam, Kerala Web: http://www.vimalkumar.info Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://dspacegeek.blogspot.in http://moovandan.blogspot.in <http://moovandan.blogspot.in> --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

4 3

Possibilities and Help in Translation
by Balaji Ravichandran 09 Aug '17

09 Aug '17

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 docs for it to be useful to the Community here. Also suggest what needs to be taken care of and important measures to be taken. Waiting for feedback from the Community :-) -- Best Regards, Balaji Ravichandran

2 3

How are authority records connected with biblio records ?
by David Holoshka 09 Aug '17

09 Aug '17

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 script based on the relevant koha source. Searching in the koha authorities intra will find the authority record but usually lists the number of biblio records having the auth as zero, but not always. If I check the biblio index in ES the items have the correct auth id in the "an" field. I can find no difference between the biblio records in the ES index that are reported as linked to the auth record to the ones that are not. I connect the biblio recs to the authorities in the marc21 structure by putting the koha auth id in field 100 sub field 9 (if it is a name auth). These marc records are now in the new biblio_metadata table. How does koha find the biblio records connected to a paticular auth record ? Is this done dynamically by searching the ES indexes ? Is this an issue with the zebra database? Is it still required ? I haven't been loading data into it since we switched to ES. Best Regards, Dave

4 6

Patron Club feature
by Krishna K 09 Aug '17

09 Aug '17

Hi all, We recently upgraded to 17.05.01 from 16.11.05. When we try to use the clubs feature by clicking on Tools-> Patron Clubs link, we are getting 404 error. We dont seem to be having the clubs.pl file. What should we do ? Appreciate your inputs. Also, is there any write up or tutorial on the patron club feature ? -- Regards, Krishna

5 4

Confusion over "item type"
by Chris Brown 09 Aug '17

09 Aug '17

Hello, MARC records 942$c and 952$y both appear to specify an "item type". They appear to be mapped to koha fields biblio.itemtype and items.itype respectively. Please could someone explain to me the difference between them? In particular when I define a circulation rule for a specific item type, which one does it use? I am using Koha 17.05 Thanks! Chris Brown (still a newbie, but getting there ...)

2 1

What's on in koha-devel #14
by Jonathan Druart 08 Aug '17

08 Aug '17

Hello librarians and developers, The what's on in koha-devel #14 is available on the Koha website: https://koha-community.org/whats-on-in-koha-devel-14 Regards, Jonathan

1 0

Request to add to List of Koha Service Providers
by Sudhir Gandotra ＠ Kalculate 08 Aug '17

08 Aug '17

Hello, Our request to be added to list of Koha service providers has been pending for quiet some time. This is a repeat request. I understand, that, being a voluntary work, the request got lost somewhere. Perhaps, we can have a form, which the service-provider can fill and the authorized person can verify and confirm, making the task easier and faster. Company Name: BestBook Buddies Technologies Private Limited Contact Person: Sudhir Gandotra / Vivek Kumar Contact email: info(a)bestbookbuddies.com Website: www.bestbookbuddies.com Telephone: +91-97185-26699 / +91-98101-20918 Thanks a lot. *Kind Regards** with Season's Greetings,* *Sudhir Gandotra |* * C. E. O.* *BestBook Buddies Technologies Pvt. Ltd.,* *Corporate Office : F-34/5, Okhla Indl Area, Phase-II, **New Delhi - 110020, INDIA* *Websites:www.bestbookbuddies.com <http://www.bestbookbuddies.com>* | *E-Mail: info(a)openlx.com <info(a)openlx.com> | <http://goog_1154387719>**www.kalculate.com* <http://www.kalculate.com> * <http://openlx.com/> * <http://koha.openlx.com/> [image: http://openlx.com/dspace.html] <http://openlx.com/dspace.html> *Office: +91-11-2638-5034, **+91-11-2638-5035* | *Mobile: +91-98101-20918*

1 0

Koha on Debian Stretch?
by Chris Brown 08 Aug '17

08 Aug '17

Hello, Does anyone have any experience (good or bad) of installing Koha on Debian 9.1 ("Stretch")? Anything I need to watch out for? Thanks! Chris Brown

6 6

New Bib Records between dates (verbose) : Report is showing Error
by Ashok Francis 08 Aug '17

08 Aug '17

Dear Sir, I am so worried because of this report error. New Bib Records between dates (verbose) When I run this report, I am getting the following error. *The following error was encountered:* The database returned the following error: Unknown column 'bi.marcxml' in 'field list' Please check the log for further details. Return to previous page <http://192.168.1.72:8001/cgi-bin/koha/reports/guided_reports.pl?reports=45&…> Can you please guide me what I have to do? Please help me. Thank you. Ashok Francis Librarian, NEw Delhi

2 1