- Koha - lists.katipo.co.nz

Re: [Koha] Request for help
by Larisa Snabi 05 Oct '18

05 Oct '18

On Thu 4 Oct, 2018, 1:19 PM Larisa Snabi, <larisasnabi(a)gmail.com> wrote: > Dear Nancy, > > We are using the following: > OS - Ubuntu 16.04 LTS, > Old Koha Version - 3.x > The steps we followed were - > 1. Installed Ubuntu > 2. Installed Koha common which when checked was version 18.05 > *3. Restoration of old Koha database to new one* > Remove existing database in new installation > > *sudo su* > *mysql -uroot -p * > > [Enter the MySQL Root password] > > *drop database koha_library;* > *create database koha_library;* > *quit;* > > Copy your database backup from your pen drive to home folder. > Extract the backup file, the extension will be .sql > Then restore the old backup to new installation. > > Database Restoration command, > > *mysql -uroot -p koha_library < koha_library.sql *[ > > > *4. Upgrade Database Schema* > > > *sudo sukoha-upgrade-schema library* > > On reaching step 4 the db does not get updated and we get the following > error line > > > > *DBD : :mysql: :db do failed: Table 'koha_cpgslibrary.systempreferences' > does not exist [for statement "Select " FROM systempreferences WHERE 1=0" ] > at usr/share/koha/lib/koha/Database.pm line 110. * > Thank you and Regards > Larisa > >

1 0

Koha 17.05.14 release
by Fridolin SOMERS 05 Oct '18

05 Oct '18

The Koha community is proud to announce the release of Koha 17.05.14. This is a maintenance release. Packages will be available in a few days. The full release notes are available at https://koha-community.org/koha-17-05-14-release/ Important /!\ This should be the last 17.05.x release. Please consider upgrading to 17.11.x, it will be maintained for at least the next 6 months. I have proposed to continue managing 17.11.x during next release cycle. Regards, -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

1 0

REPORT 100 AND 700 MARC TAG
by Hans Manrique 04 Oct '18

04 Oct '18

Hello everyone, I would like to have a report of only fields 100 and 700 in a single column. I'm a student and I do not understand much about sql, but I've managed to get a 100 report through ExtractValue syntax queries (marcxml, xpath). But I do not know how to get one of the fields 100, 700 in a single report and in a column. Is that possible? Hans Manrique

3 2

KohaCon19 in Dublin
by Charles Quain 04 Oct '18

04 Oct '18

Dear Koha Community On behalf of Dublin Business School, Interleaf Technology and PTFS-Europe I would like to thank everyone for their votes to bring KohaCon19 to Dublin. We are very grateful for your support and look forward to welcoming you all to Dublin next year. We will shortly confirm on which of the 3 weeks proposed the event will take place and start building the Conference website. Charles Charles S Quain Managing Director Interleaf Technology

1 0

Re: [Koha] Koha - display of Periodicals(serials) search result in Koha
by Kerrie Stevens 04 Oct '18

04 Oct '18

Hi Krishna, We have the same issue. To get around it, once you get to the journal page we use Ctrl F then type the keyword again and it is highlighted on the page and shows which specific issue it is in. Not perfect, but workable. If there is a better way, I'd love to use it too. Kerrie Stevens AALIA(CP), MAppSci(LibMgt), BBus(Info&LibMgt) Melbourne Campus - Librarian Alphacrucis College kerrie.stevens(a)ac.edu.au | ac.edu.au P +61 3 8799 1155 | F +61 3 8799 1199 1 Keith Campbell Court, Scoresby VIC 3179 Australia Message: 8 Date: Wed, 3 Oct 2018 18:31:14 +0530 From: Krishna K <krishna.moorthy94(a)gmail.com> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Cc: Api <aparna.swamy(a)gmail.com>, Naveen Chitram <naveencr(a)gmail.com> Subject: [Koha] Koha - display of Periodicals(serials) search result in Koha Message-ID: <CACKin8d8ooptTMkqOth4SFns9hm_2iswNm_K8rj2sCC+vwW0iQ(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hi all, We are using Koha 17.11.05 and we recently went live with entry of periodical/serial subscriptions and recorded receipts of magazine issues. However, when we do an OPAC search, the search result shows only the subscription information and not the specific issue that has the searched keyword in it. Let me explain with an example - 1. We have recorded subscription of National Geographic Magazine 2. We received 10 issues of the above magazine. At the time of receipt, in the item Public Note we enter information on what that particular issue contains for example - 1. July Issue public note has Dolphins, Cave Mammals, Fossils 2. Aug issue with National Parks, Ice Age 3. May issue with Leopards, Dophins 3. When we search for Dolphins, National Geographic appears in search result. When we click on this and see the holdings, it shows all the 3 issues of this magazine and not just the May and July issue. 4. When the number of magazine issues is very large, this search result is not useful. Could anyone guide us in terms of how to show the relevant *items* with the searched terms in the public note, in the search result ? Alternately, how to enable a better search experience for OPAC users for periodicals/serials ? -- Regards, Krishna <p> Scanned by the Alphacrucis Netbox from <a href="http://cyberhound.com/">CyberHound</a>

1 0

Check out restriction to category / branch for School Libraries
by anjoze 03 Oct '18

03 Oct '18

Hi again. I have the fallowing scenario: 1 Koha instance 1 Public Library 20 Public Schools I want to restrict holds between the Public Library and School Libraries but I don't want to restrict holds between School Libraries. With independentbraches doesn't work because it will restrict everything. I've tried to limit Patron categories to respectively libraries but didn't worked. Any help appreciated ----- Koha version: 16.05.05 - - José Anjos -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

5 9

Koha - display of Periodicals(serials) search result in Koha
by Krishna K 03 Oct '18

03 Oct '18

Hi all, We are using Koha 17.11.05 and we recently went live with entry of periodical/serial subscriptions and recorded receipts of magazine issues. However, when we do an OPAC search, the search result shows only the subscription information and not the specific issue that has the searched keyword in it. Let me explain with an example - 1. We have recorded subscription of National Geographic Magazine 2. We received 10 issues of the above magazine. At the time of receipt, in the item Public Note we enter information on what that particular issue contains for example - 1. July Issue public note has Dolphins, Cave Mammals, Fossils 2. Aug issue with National Parks, Ice Age 3. May issue with Leopards, Dophins 3. When we search for Dolphins, National Geographic appears in search result. When we click on this and see the holdings, it shows all the 3 issues of this magazine and not just the May and July issue. 4. When the number of magazine issues is very large, this search result is not useful. Could anyone guide us in terms of how to show the relevant *items* with the searched terms in the public note, in the search result ? Alternately, how to enable a better search experience for OPAC users for periodicals/serials ? -- Regards, Krishna

1 0

Getting data from VTLS Virtua
by Job 03 Oct '18

03 Oct '18

Dear all, I am looking to get all important data (MARC,Loans, Funds, Patrons, Users, etc) from VTLS Virtua, using ssh connection, at now I found only how to get MARC records, where I use write2709.exe program. I found also some old koha scripts to deal with MARC records. But all other data I don't know how to extract. I would like to know if someone with experience in getting data with VTLS Virtua, could help me ? Best Regards Job -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

1 0

Request for help
by Larisa Snabi 03 Oct '18

03 Oct '18

Dear Community, I have been trying to restore my old koha db to the latest koha 18.5 but I am getting error when invoking the upgrade schema library command. The error line is system preferences doesn't exist at database line 110. Request for help. Thank you Larisa

2 1

help
by rodrigo aleman 03 Oct '18

03 Oct '18

Hi everyone, In the Marc template I have the registry set up, but when I'm going to register that item it won't let me, and I can't see the item's information, how can I solve this? Regards, Rodrigo Alemán

2 1