[Koha] synchro two instances of Koha

2018-03-03 Thread Giuseppe Angilella
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 per

[Koha] adding existing items to acquisitions

2018-03-03 Thread Giuseppe Angilella
Hi, how can I add existing items to existing acquisitions? The normal procedure would be to first "order" an item within an acquisition's basket, and then have it "received". But I am trying to reconstruct past acquisitions (for the sake of my library's records), that had been dealt with outs

Re: [Koha] (no subject)

2018-03-03 Thread Bob Birchall
The MARC metadata are no longer in the biblioitems table (since 17.05). The new table is biblio_metatdata. HTH, Bob Birchall Calyx On 03/03/18 19:27, Javed Sahil wrote: Hi all, I am using koha 17.11, Can anybody help me correcting the syntax? ExtractValue( marcxml , ''//datafield[@tag="650"]/s

[Koha] In and Out Library Management System

2018-03-03 Thread Igbudu Tersoo
Dear Mr Omkar, I must commend you for job well done. And to inform you that your innovation will be of great assistant to us as we were already thinking of an access control system for our library. Using that from KOHA will be more interesting. I wish to further request two things

[Koha] (no subject)

2018-03-03 Thread Javed Sahil
Hi all, I am using koha 17.11, Can anybody help me correcting the syntax? ExtractValue( marcxml , ''//datafield[@tag="650"]/subfield[@code="a"]'') AS lcsh FROM biblioitems) The full code of report is following: SELECT CONCAT('',biblionumber,'') AS bibnumber, lcsh FROM (SELECT biblionumber, Extra