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

2021-09-22 Thread Josef Moravec
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.

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.

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:

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

[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

Re: [Koha] GDPR IRC meeting vol. 2

2018-04-04 Thread Josef Moravec
s of open source services: > 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 G

[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

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

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 ___

[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

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

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(" ",

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

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

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

2017-08-01 Thread Josef Moravec
t; Location fields are 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" <josef.mora...@gmail.com>: > > Hello, &

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

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: >

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

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, > >

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

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

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

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

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

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

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

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

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 indr...@gmail.com napsal: Hi all, On the Check In page, it is possible to

Re: [Koha] Koha on ubuntu - git

2015-07-01 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 christer.s...@kouvola.fi 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

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

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

2015-05-27 Thread Josef Moravec
: 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

Re: [Koha] Barcode generator

2015-05-26 Thread Josef Moravec
-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
-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@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] XML configuration file

2015-01-13 Thread Josef Moravec
Hello Lal, you can resolve this issue in your koha-conf (/etc/koha/sites/your instance/koha-conf.xml) just insert this line: use_zebra_facets1/use_zebra_facets before this line: /config at the end of that config file best regards Josef Moravec On Wed, Jan 14, 2015 at 6:48 AM, Lal S lal

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

2014-12-15 Thread Josef Moravec
@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] 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
is not displayed). Using koha 3.12 Thanks ___ 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

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:13 AM, Quoc Uy nguyenquocuy_1

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 josef.mora...@gmail.comwrote: I didn't make any changes, if I remember. You can see