- Koha - lists.katipo.co.nz

SYSTEM UNDER MAINTENANCE NO MATTER WHAT?
by Jack Boulier 28 Mar '18

28 Mar '18

I have installed KOHA from a LIVE-DVD. I have run koha-rebuild-zebra -v -f library. On the server my collection can be queried. But when longing in remotely, using my local network, or an outside connection, I get the message the system is down for maintenance. I am at a loss as to what to do next? Any help would be appreciated. Thanks,Jack.

2 1

Report for holds count by bib record & branch
by Cab Vinton 27 Mar '18

27 Mar '18

Hi, All -- I'm trying to create a report that will give me hold counts broken down by bib record and the patron's branch. I believe what I have is pretty close, but some of the output omits the item type information. This is what I have: SELECT count(borrowers.branchcode) AS Holds, borrowers.branchcode, biblio.title, biblio.biblionumber, biblio.datecreated, items.itype FROM reserves LEFT JOIN borrowers USING (borrowernumber) LEFT JOIN biblio USING (biblionumber) LEFT JOIN items USING (itemnumber) GROUP BY biblio.biblionumber, borrowers.branchcode ORDER BY count(borrowers.branchcode) DESC, biblio.title And some sample output: Holdsbranchcodetitlebiblionumberdatecreateditype 6 KIMBALL Lilac girls : 142069 2016-04-19 BOOK 6 KIMBALL The woman in the window : 158162 2018-01-03 NEWBOOK 6 KIMBALL Victoria. The complete second season / 158595 2018-01-30 NEWMOVIE 4 SANDOWN Accidental heroes : 157156 2017-10-28 4 PLAISTOW Fall from grace : 156095 2017-09-12 4 KIMBALL The great alone / 156089 2017-09-12 3 SANDOWN I've got my eyes on you : 157150 2017-10-28 3 PLAISTOW Lilac girls : 142069 2016-04-19 3 SANDOWN Sweet vengeance / 157152 2017-10-28 NEWBOOK Can anyone provide a fix? Many thanks in advance, Cab Vinton Plaistow Public Library

2 2

Re: [Koha] Stage Marc records for import problem
by Jonathan Druart 26 Mar '18

26 Mar '18

(please answer to the list) Koha 17.11.03 is indeed the latest version. "Koha 4" is not the community version. You should be able to install it, following the wiki page instruction, on top of a debian distribution. https://wiki.koha-community.org/wiki/Koha_on_Debian Regards, Jonathan On Mon, 26 Mar 2018 at 13:31 Matt Rose <library(a)halswaymanor.org.uk> wrote: > Hi Jonathan, > > > Many thanks for responding, I appreciate it. I am using Koha 04.18.06 I > think, accessible through a shortcut named: Koha staff client which I > think came from LibLime-Koha-4.18.06.tar folder that I downloaded. > > > I have just downloaded what I think is the latest version, koha-17.11.03. > I have literally no idea how to install it onto my Oracle VM Virtual > Boc Debian 9.3.0 Base Build. I have printed off the Koha on Debian > instructions from Koha Wiki but am none the wiser! > > > Matt > > www.halswaymanor.org.uk > > Halsway Manor Centre for the Folk Arts > > Somerset > > United Kingdom > > > ------------------------------ > *From:* Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> > *Sent:* 23 March 2018 18:10 > *To:* Matt Rose > *Cc:* koha(a)lists.katipo.co.nz > *Subject:* Re: [Koha] Stage Marc records for import problem > > Hi Matt, > > Which Koha version do you use? How did you install it? > Do you see something in the log files? > > Regards, > Jonathan > > On Fri, 23 Mar 2018 at 14:52 Matt Rose <library(a)halswaymanor.org.uk> > wrote: > > Hi folks, > > > Beginners question. Why does my Marc records import to Koha freeze when I > click 'Stage for Import'. Job Progress stays at 0% See below. many thanks, > Matt library(a)halswaymanor.org.uk > > > Koha/Home/Tools/Stage MARC records for import > > * Select a MARC file to stage in the import reservoir. It will be > parsed, and each valid record staged for later import into the catalog. > * You can enter a name for this import. It may be useful, when > creating a record, to remember where the suggested MARC data comes from! > > Stage records into the reservoir > > 1. > Select the file to stage: > > Upload fileCancel > > Upload progress: 100% > > > 1. Comments about this file: > 2. Record type: > Bibliographic > > Authority > > 3. Character encoding: > UTF-8 (Default) > > MARC 8 > > ISO 5426 > > ISO 6937 > > ISO 8859-1 > > EUC-KR > > 4. Format: > MARC > > MARCXML > > > Look for existing records in catalog? > > 1. Record matching rule: > Do not look for matching records > > ISBN (020$a) > > ISSN (022$a) > > KohaBiblio (999$c) > > 2. Action if matching record found: > Replace existing record with incoming record > > Add incoming record > > Ignore incoming record (its items may still be processed) > > 3. Action if no match is found: > Add incoming record > > Ignore incoming record (its items may still be processed) > > > Check for embedded item record data? > > 1. Yes > 2. No > > 1. How to process items: > Always add items > > Add items only if matching bib was found > > Add items only if no matching bib was found > > Replace items if matching bib was found (only for existing items) > > Ignore items > > > > Job progress: > 0% > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > >

1 0

Can't delete line from "circulation and fine rules"
by klas.blomberg＠skovde.se 26 Mar '18

26 Mar '18

Greetings! This is my first posting to this list, so let my introduce myself: I work at Bibliotek Mellansjö (Libraries between the lakes - sounds very weird in English, doesn't it?), a consortium of eight public libraries in Sweden, and we migrated to Koha in the middle of january this year. Before that I have been working as systems librarian in both public and academic libraries for eleven years, most of the time with SirsiDynix Symphony - and I have a wishlist with at least a dozen of features from that system I would like to see introduced in Koha...... But, my problem today is more adjacent: Somehow we made some error when we set up our circulation and fine rules in Koha - so we have some lines in our circulation and fine rules that doesn't contain an item type. Yes, I know, that should not be possible, and I don't know how we made it! There seems to be no way to modify nor remove those unwanted lines from inside the staff "client", so how can I get rid of them? Klas Blomberg IT-bibliotekarie Stadsbiblioteket Skövde Kulturhus Skövde kommun 541 83 Skövde Direkttelefon 0500-49 85 18 Kontaktcenter telefon 0500-49 80 00 www.skovde.se

2 1

package install debian koha 17.11
by Stowasser Rainer 26 Mar '18

26 Mar '18

Hy 2 all I wanted to test the "new" koha release by package install on debian jessie and stumbled on this: The following packages have unmet dependencies: koha-common : Depends: libplack-middleware-reverseproxy-perl but it is not going to be installed Depends: libtest-exception-perl but it is not going to be installed Depends: libtest-mockobject-perl but it is not going to be installed Depends: starman but it is not going to be installed any ideas ? Best regards Hofrat Mag. Rainer Stowasser Head of Library ZAMG

3 3

Still unable to get KOHA 17.11 working
by Jack Boulier 24 Mar '18

24 Mar '18

I have now loaded KOHA on ubuntu 16.04 from the command line. I am loading KOHA 17.11 release following the instruction from Koha on ubuntu - packages - Koha Wiki | | | | | | | | | | | Koha on ubuntu - packages - Koha Wiki | | | | I am working from a windows computer and accessing the server on my local network. The network is located on 192.168.0.6. It responds correctly, and I am performing the setup using Putty from the Windows machine. I am unable to get the lynx to work correctly, when going to 192.168.0.6:80 the screen displays the site is in the maintenance mode. the 192.168.0.6:8080 displays the Apache test screen. I am at a total loss as to the next process that I should try. I have tried to restore my existing library, but have had no luck with that either. I am using Mariadb as the database. I have successfully used KOHA in the past with creating KOHA for the first time using a KOHA Live CD and then did an update keeping my existing data. All help will be appreciated. Thanks Jack

1 0

synchro two instances of Koha
by Giuseppe Angilella 24 Mar '18

24 Mar '18

Hi, is it possible to synchronize two (online) instances of Koha? I mean, two identical installations, updated regularly, residing on two different machines, where patrons and administrators can access and modify entries independently. Would it possible to synchronize their databases (and perhaps some relevant external file), on the basis of the modification timestamp of those entries that have been actually modified? (I am not sure whether my question is simply equivalent to that of synchronizing two mysql databases on different servers, for which there might be an answer, if I google it correctly: your advice is appreciated.) Many thanks, Giuseppe.

6 6

Stage Marc records for import problem
by Matt Rose 23 Mar '18

23 Mar '18

Hi folks, Beginners question. Why does my Marc records import to Koha freeze when I click 'Stage for Import'. Job Progress stays at 0% See below. many thanks, Matt library(a)halswaymanor.org.uk Koha/Home/Tools/Stage MARC records for import * Select a MARC file to stage in the import reservoir. It will be parsed, and each valid record staged for later import into the catalog. * You can enter a name for this import. It may be useful, when creating a record, to remember where the suggested MARC data comes from! Stage records into the reservoir 1. Select the file to stage: Upload fileCancel Upload progress: 100% 1. Comments about this file: 2. Record type: Bibliographic Authority 3. Character encoding: UTF-8 (Default) MARC 8 ISO 5426 ISO 6937 ISO 8859-1 EUC-KR 4. Format: MARC MARCXML Look for existing records in catalog? 1. Record matching rule: Do not look for matching records ISBN (020$a) ISSN (022$a) KohaBiblio (999$c) 2. Action if matching record found: Replace existing record with incoming record Add incoming record Ignore incoming record (its items may still be processed) 3. Action if no match is found: Add incoming record Ignore incoming record (its items may still be processed) Check for embedded item record data? 1. Yes 2. No 1. How to process items: Always add items Add items only if matching bib was found Add items only if no matching bib was found Replace items if matching bib was found (only for existing items) Ignore items Job progress: 0%

2 1

To get listed as a private Koha support provider
by Ramon Figueroa 23 Mar '18

23 Mar '18

Venezuela Bolivarian Republic. Caracas. Mar 22, 2018 Dear. Web master of Koha mailing Hello appreciatedfriends from the koha-community. I am a Koha-Consultan from a Company, which want to be listed on yoursite as a Koha Support provider in our country Venezuela. Company Name:SEK Soluciones Digitales XXI C.A. Contact Person: Lic. Ramón José FigueroaMeza Contact email:rajofigueroa@gmail.com and rajofigueroa(a)yahoo.com Website: http://sek.com.ve/sek/ Telephone:0058-0414-2584528 Thank a lot for your help and congratulations foryou very relevant work. Greetings from Caracas, Venezuela. Lic. Ramon Figueroa E-mails : rajofigueroa(a)gmail.com and rajofigueroa(a)yahoo.com Linkedin: https://ve.linkedin.com/in/ram%C3%B3n-jos%C3%A9-figueroa-meza-11b59299

1 0

RESTORING DATABASE TO NEW INSTALLATION OF KOHA
by Jack Boulier 22 Mar '18

22 Mar '18

I have just installed the Ubuntu Xenia 16.04 with the latest updates and installed Koha 17.11.03, to my system. I did the install of Koha using apt-get install koha-common. did a transfer of my database with mysql -uroot -p < path/koha.sql. My database with all data is installed in my koha_jackslibrary. I am unable to see my library at localhost:80, it displays under maintenance, and 8080 is asking for a username and password. None of the logins work to gain access to the system. My browser is Chromium. I just don't care for Firefox. I am at a lost for the next step. Any ideas would be appreciated. Thanks,Jack

3 2