Re: [Koha] Template toolkin and MARC field/subfields

2021-09-22 Thread Josef Moravec
/koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > -- Josef Moravec josef.mora...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] No such column 'maxissueqty' Issue

2019-03-12 Thread Josef Moravec
No, Koha 18.11 does not have this bug Josef út 12. 3. 2019 v 14:19 odesílatel Andi Sugandi napsal: > On Tue, Mar 12, 2019 at 7:36 PM Josef Moravec > wrote: > > Hello Josef, > > > it is known bug in master: > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?i

Re: [Koha] No such column 'maxissueqty' Issue

2019-03-12 Thread Josef Moravec
Hello Andi, it is known bug in master: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22489 currently being fixed Josef út 12. 3. 2019 v 10:56 odesílatel Andi Sugandi napsal: > Hi all, > > I'm trying to install Koha via Git installation as instructed here[1] > on Ubuntu 18.04. Inst

Re: [Koha] Error restoring Koha-Instance

2019-03-11 Thread Josef Moravec
I should work this way: restore old db ignore zebra errors update database schema rebuild zebra manually Josef pá 22. 2. 2019 v 18:30 odesílatel Alvaro Cornejo napsal: > Hi > > It said there is a Unknown column 'me.damaged_on' ... this usually means > that your DB schema has changed. Probably

Re: [Koha] Adding menu links in navbar

2018-07-16 Thread Josef Moravec
Hi, there is IntranetNav system preference, where you can write in some html to add to navbar. Josef ne 15. 7. 2018 v 15:35 odesílatel drojup napsal: > Hi, > > Is there any way to add links in navbar (next to cart, lists)? > > Thank you > > > > -- > Sent from: http://koha.1045719.n5.nabble.com

Re: [Koha] Item circulation history not seen

2018-06-14 Thread Josef Moravec
Hello, it is known bug, see https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20934 Josef čt 14. 6. 2018 v 8:37 odesílatel Sahadeo Taware napsal: > Dear Sir > > I am upgraded my koha software from 17.12 to 18.05 > > Now the problem is that I am not able to see the circulation history

[Koha] GDPR IRC Meeting vol. 2

2018-04-13 Thread Josef Moravec
Hello community, the second GDPR IRC meeting will be held on wednesday 18. 4. 2018, at: 14:00 UTC The agenda will be here: https://wiki.koha-community.org/wiki/GDPR_IRC_meeting_18_April_2018 regards Josef ___ Koha mailing list http://koha-community.o

Re: [Koha] GDPR IRC meeting vol. 2

2018-04-04 Thread Josef Moravec
ices: > https://dudle.inf.tu-dresden.de/ > https://dudle.lamardebits.org/ > > Or alternatives: > https://framadate.org/ > https://nuages.domainepublic.net/ > > > El 04/04/18 a les 11:06, Josef Moravec ha escrit: > > Hello all interesteed in GDPR, > > > >

[Koha] GDPR IRC meeting vol. 2

2018-04-04 Thread Josef Moravec
Hello all interesteed in GDPR, we would like to have another meeting on this topic, but time and date is not set yet. So please fill this poll if you are interested. Thanks. https://doodle.com/poll/q7s88vqnc5xtf9ev Josef ___ Koha mailing list http://k

Re: [Koha] Can't delete line from "circulation and fine rules"

2018-03-26 Thread Josef Moravec
Hi Klass, first of all: Which version of Koha are you using? Generally speaking: It is definitely possible to define the rule without item type - then it applies to all item types. Also it is possible to change/remove a rule: the buttons for this are at the right side of every row - you just nee

Re: [Koha] Biblios in reservoir

2018-02-20 Thread Josef Moravec
Hi, use cleanup_database.pl script with parameter --import Josef út 20. 2. 2018 v 8:51 odesílatel Ma. Victoria H. Silva-Manuel < mavicsi...@gmail.com> napsal: > Hi. > How do you delete biblios in reservoir? > Thank you. > > -- > Ma. Victoria H. Silva-Manuel > Registered Librarian, 3892 > ___

[Koha] GDPR IRC meeting

2018-02-20 Thread Josef Moravec
Hello all, based on the poll, I have chosen date and time of GDPR meeting to mondey 26. 2. 2018 19:00 UTC The agenda will be here: https://wiki.koha-community.org/wiki/GDPR_IRC_meeting_26_February_2018 Feel free to add your points. Cheers Josef ___ Ko

[Koha] ***UNCHECKED*** GDPR IRC meeting proposal

2018-02-15 Thread Josef Moravec
Hello all, it would be nice to have some meeting about the GDPR and data privacy in Koha. With GDPR going to take effect in May, there is not too much of time to adapt our systems and proccesses. The subject of meeting should be disscusion about things documented on Koha wiki [1] and to share our

Re: [Koha] KOCT 0.4.5

2017-12-06 Thread Josef Moravec
Hi Radek, see this mail: http://lists.koha-community.org/pipermail/koha-devel/2017-October/044090.html are you going to make the translation? ;) Josef st 6. 12. 2017 v 22:13 odesílatel Radek Šiman napsal: > Great job, Matthias! > > Is there a way how we can translate the tool into Czech? If y

Re: [Koha] Adding an independent branch

2017-10-09 Thread Josef Moravec
Hi Elaine, maybe a report like this could be useful for you, it searches for candidates to merging and have buttons to merge found records. Candidates are grouped by author, title, part number and volume title: SELECT GROUP_CONCAT(bi.isbn) as isbns, b.author, CONCAT_WS(" ", ExtractValue(bm.metada

Re: [Koha] Unknown column 'metadata' in 'field list'

2017-08-08 Thread Josef Moravec
Hello Vimar, you need to join the table biblio_metadata to your query Best Josef st 9. 8. 2017 v 7:06 odesílatel Vimal Kumar V. napsal: > Dear Friends, > I am trying to generate a book list with keywords from 650$a using the > following SQL query, > > SELECT ExtractValue( metadata, > '//dataf

Re: [Koha] Koha on Debian Stretch?

2017-08-08 Thread Josef Moravec
Hi Chris, I have installed Koha 16.11 on Debian Stretch just few days ago and it have worked as seamlessly as on Jessie. Best Josef út 8. 8. 2017 v 12:22 odesílatel Chris Brown napsal: > Hello, > > Does anyone have any experience (good or bad) of installing Koha on Debian > 9.1 ("Stretch")? A

Re: [Koha] New Bib Records between dates (verbose) : Report is showing Error

2017-08-07 Thread Josef Moravec
Hello Ashok, please see this bug report: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196 marcxml column of biblioitems was moved to new table biblio_metadata, column metadata so you need to update your report according to this. Regards Josef Moravec út 8. 8. 2017 v 6:53

Re: [Koha] After Upgrade no biblio_metadata and mo marcxml

2017-08-01 Thread Josef Moravec
e not there. > > Am I right? If i write a script which will generate the XML from the > existing data , and put in the biblio_metadata database, it will work? > > 01.08.2017, 10:48, "Josef Moravec" : > > Hello, > > just reload db from backup, then set mysql

Re: [Koha] After Upgrade no biblio_metadata and mo marcxml

2017-08-01 Thread Josef Moravec
Hello, just reload db from backup, then set mysql according to this guide: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7 then you can update your database structure and everything should be ok regards Josef út 1. 8. 2017 v 9:08 odesílatel gevos napsa

Re: [Koha] Having two servers for Koha - Database and Application server

2017-02-22 Thread Josef Moravec
Hello Admire, the only difference is in koha-create step: https://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#koha-create use request-db and populate-db parameters regards Josef čt 23. 2. 2017 v 7:52 odesílatel Admire Mutsikiwa napsal: > Hi > > > > I would like to

Re: [Koha] Running batchrebuildItemsTables.pl

2017-02-07 Thread Josef Moravec
Hello Luis, for running cli script you need to set env variables PERL5LIB and KOHA_CONF, did you set them? Josef út 7. 2. 2017 v 19:34 odesílatel Luis Moises Rojas napsal: > How could i execute this file, cos when i try to run using > ./batchrebuildItemsTables.pl i got at lot of error: > Can no

Re: [Koha] Is it possible to reserve available books?

2017-02-02 Thread Josef Moravec
Hello Michael, yes it is possible, we use it in our library, you have to set "On shelf holds allowed" parameter in circulation rules. then librarians could be informed by e-mail (but this send all added reserves not only the available ones) or just few times a day check the pending reserves page

Re: [Koha] Storage engine type pending_offline_operations

2017-01-25 Thread Josef Moravec
Hello Barry, there is only one mention on choosing the MyISAM engine as I know: in kohastructure.sql -- this table is MyISAM, InnoDB tables are growing only and this table is filled/emptied/filled/emptied... -- so MyISAM is better in this case Regards Josef Moravec út 24. 1. 2017 v 14:55

Re: [Koha] SQL help - Retrieve itemnumbers based on local subject keyword

2016-10-21 Thread Josef Moravec
Or without subquery: SELECT i.itemnumber FROM items i JOIN biblioitems bi ON i.biblionumber = bi.biblionumber WHERE ExtractValue(bi.marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]') LIKE <> pá 21. 10. 2016 v 19:26 odesílatel Craig Butosi napsal: > Hi all, > > Call of the dogs. A kind so

Re: [Koha] Staff activity report

2016-10-07 Thread Josef Moravec
Hello, try this report: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Librarians_activity Josef pá 7. 10. 2016 v 4:22 odesílatel Ma. Victoria H. Silva-Manuel < mavicsi...@gmail.com> napsal: > Hi. > I would like to know how to generate a report that includes each staff > activities f

Re: [Koha] NCIP protocal

2016-08-11 Thread Josef Moravec
Hello Vikram, we are using implementation of NCIP based on xcnciptoolkit. Josef čt 11. 8. 2016 v 9:54 odesílatel vikram zadgaonkar < vikramczadgaon...@gmail.com> napsal: > Dear All, > I am looking for help in integration of RFID through NCIP with koha, has > any one did this? > Vikram Zadgaonka

Re: [Koha] How to leave null value in SQL Report

2016-03-07 Thread Josef Moravec
Hello Vimal, add this statement just before ORDER line HAVING AccoMaterial != "" regards Josef út 8. 3. 2016 v 6:37 odesílatel Vimal Kumar V. napsal: > Dear Friends, > Here is a report which list books with accompanying materials (field > 300$e). > How can I leave null values in 300$e and

Re: [Koha] Patron Clearance Maintenance in Koha

2015-12-27 Thread Josef Moravec
Hello Mubasir could "Discharge" funkcionality in Koha work for your? Did you try it? It has to be enabled first in "useDischarge" system preference. Best Josef ne 27. 12. 2015 v 3:06 odesílatel Mubassir Ahsan napsal: > Dear Koha Community, > > I am working in a private university library where

Re: [Koha] Koha 3.12 Installation

2015-12-21 Thread Josef Moravec
Hello Balaji, It's because newer version of Koha prefer virtual host before port based configuration. If you still wan't/need to use ports, you'll have to edit the /etc/koha/koha-sites.conf file and set set INTRAPORT to 8080 Josef po 21. 12. 2015 v 9:38 odesílatel Balaji Ravichandran napsal:

Re: [Koha] Koha Digest, Vol 119, Issue 4

2015-09-11 Thread Josef Moravec
Helo Nihad, it is possible, look at the itemBarcodeFallbackSearch system preference Josef út 8. 9. 2015 v 23:02 odesílatel NIHAD FAISAL napsal: > I am a fresher in Koha and just want to get a solution that, is there any > option to search by title or author while check out a material? I can se

Re: [Koha] Report for titles with all copies checked out

2015-08-23 Thread Josef Moravec
Hello Caitlin, I've just tried to write an SQL which meets your needs and I think something like this should work for you: select b.biblionumber, b.title, b.author, SUM(IF(i.onloan is null, 1, 0)) as available FROM biblio b JOIN items i ON b.biblionumber = i.biblionumber GROUP BY b.biblionumber H

Re: [Koha] VuFind and Koha

2015-08-13 Thread Josef Moravec
Hello Riley, Agnes and all, we are using VuFind with on the top of Koha. Riley: do you have configured the ILS driver in VuFind? Thats the place where statuses are transfered from Koha to VuFind. We don´t use oai to transfer biblio data, we have just simple script which uses Koha export.pl, but w

Re: [Koha] Odd "check in" behaviour, if not checked out items are scanned in.

2015-07-03 Thread Josef Moravec
Hello, the "check in" page is also for "activating" new items which has the "PROC" status and for receiving transfers, so this behavior is feature, not bug I think. Josef pá 3. 7. 2015 v 9:39 odesílatel Indranil Das Gupta napsal: > Hi all, > > On the "Check In" page, it is possible to scan the

Re: [Koha] Koha on ubuntu - git

2015-06-30 Thread Josef Moravec
Yes, thats the right syntax if you want to use 3.16.x. Regards Josef st 1. 7. 2015 v 7:56 odesílatel ubuntu napsal: > Thanks for the quick answer. As I am a Koha newbie I would like to study > Koha > git in a local demo server. As I have little experience with Git there's a > lot to learn.

Re: [Koha] Koha on ubuntu - git

2015-06-30 Thread Josef Moravec
What do you need it for? If you are going to install Koha on production server, you should follow these instructions http://wiki.koha-community.org/wiki/Koha_on_Debian Which guides you to install stable 3.20 or oldstable 3.18 version. It does not make much sense for me to install 3.16 for new prod

Re: [Koha] [Koha-devel] [CROSS-POST] does the language sw[itcher really need that much screen real estate?

2015-05-26 Thread Josef Moravec
mentfoundation.org > > ___ > > Koha-devel mailing list > > koha-de...@lists.koha-community.org > > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > > website : http://www.koha-community.org/ > > git : http://git.koha-community.org/ > > bugs : http://bugs.koha-community.org/ > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Josef Moravec josef.mora...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Barcode generator

2015-05-26 Thread Josef Moravec
__ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Josef Moravec josef.mora...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] need an sql report to count notices

2015-03-14 Thread Josef Moravec
_ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Josef Moravec josef.mora...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] exporting MARC records on mysql conditions

2015-01-31 Thread Josef Moravec
. > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Josef Moravec josef.mora...@gmail.com ___ Koha mailing list

Re: [Koha] XML configuration file

2015-01-13 Thread Josef Moravec
Hello Lal, you can resolve this "issue" in your koha-conf (/etc/koha/sites//koha-conf.xml) just insert this line: 1 before this line: at the end of that config file best regards Josef Moravec On Wed, Jan 14, 2015 at 6:48 AM, Lal S wrote: > We have recently upgraded to 3.

[Koha] Hold fees

2015-01-07 Thread Josef Moravec
Hello to all, we need to charge patrons for holds, we tried to set it up in patron categories (field Hold Fee), but we were unsuccesful. Is anybody using this functionality, or is it possible that we found a bug? Thank you -- Josef Moravec josef.mora...@gmail.com

Re: [Koha] Koha Digest, Vol 110, Issue 29

2014-12-15 Thread Josef Moravec
: Iming Chan > > To: koha@lists.katipo.co.nz > > Subject: Re: [Koha] 3.18 & high CPU utilisation > > Message-ID: <1418535640472-582.p...@n5.nabble.com> > > Content-Type: text/plain; charset=us-ascii > > > > Looks like we have resolved this issue. Our system drive space

Re: [Koha] Koha 3.18 : Search Patrons -- Possible Bug

2014-11-30 Thread Josef Moravec
pt in your staff client which can make this problem?? Josef Moravec On Mon, Dec 1, 2014 at 6:07 AM, Arslan Farooq wrote: > Hi guys, > > My server is Debian 7, and Koha was installed using the packages > (koha-common). > > I upgraded to Koha 3.18, and now searching the patrons

Re: [Koha] AllowOfflineCirculation question

2014-03-03 Thread Josef Moravec
Hello Nicole, as I know, that is for built-in offline circulation client, which can be accessed from link http://your-koha-staff-client/cgi-bin/koha/circ/offline.pl the link is also presented on main page of circulation module Best regards Josef Moravec On Mon, Mar 3, 2014 at 11:36 PM

Re: [Koha] page link problem

2013-10-24 Thread Josef Moravec
eads me back to my main opac page > (page content is not displayed). Using koha 3.12 > > Thanks > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.k

Re: [Koha] Switching from Other Library Software to Koha

2013-10-08 Thread Josef Moravec
Hello, it looks like, there's nobody with experiences with migrating from AccesIt to Koha. So, in general, the main question is: Are you able, to export data in MARC format? Which version of MARC do you use in your library? Regards, Josef Moravec On Tue, Oct 8, 2013 at 4:01 AM, Ben Dou

Re: [Koha] Upgrade koha 3.8

2013-09-11 Thread Josef Moravec
------- > kindly help > > > On Wed, Sep 11, 2013 at 6:07 PM, Josef Moravec wrote: > >> Did you follow these instructions for upgrading git installations? >> >> >> http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_git#Upgrad

Re: [Koha] Upgrade koha 3.8

2013-09-11 Thread Josef Moravec
Hello, what method did you originally use for installing Koha? Did you install from Git? Recomended method is installing from debian packages (for debain based distributions) Josef Moravec On Wed, Sep 11, 2013 at 8:59 AM, rocky bang wrote: > Dear all, > > I want to upgrade my ko

Re: [Koha] Koha themes CCSR and PROG

2013-03-30 Thread Josef Moravec
I didn't make any changes, if I remember. You can see it in action here: http://xmorave2.vserver.cz/ Did you install Koha from Deb packages, or from tarball? On Sat, Mar 30, 2013 at 8:40 AM, Josef Moravec wrote: > > I didn't make any changes, if I remember. You can see i

Re: [Koha] Koha themes CCSR and PROG

2013-03-30 Thread Josef Moravec
Hello Ngueyn, we are runnig Koha 3.10.4 and the CCSR theme in OPAC and both header and footer work fine for us. Just to be sure that we all think about the same thing - we use "opaccredits" and "opacheader" system preferences. Josef Moravec On Sat, Mar 30, 2013 at 5: