Re: [Koha] Zebra rebuild frequency
Paul, could you confirm that you use Zebra in DOM mode? It seems Zebra isn't configured properly, and so doesn't know where to pick up unique ID for biblio records (biblionumber field). Without an ID to identify biblio records, Zebra can't neither delete nor update a biblio record. Check your Zebra index definition file: biblio-koha-indexdefs.xml. At the beginning of the file, you should have a line like this one: idmarc:datafield[@tag='999']/marc:subfield[@code='c']/id My assumption is that you haven't this. This could happen if the upgrade isn't done properly, for a reason or another. I have a feeling that when zebra says incremental it means just that -- adding new data, but not deleting what has gone from MySQL. It works for the vast majority of the Koha crowd. Zebra is obviously designed to be able to add/edit/delete records. It's a minimum :-) You have to figure out what's wrong with your installation. Kind regards, -- ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report_Circulation (Jameela)
I got the desired results. Thank to one and all who've guided me. I posting the SQL code below. Thanks once again SELECT borrowers.cardnumber,borrowers.surname,items.barcode,items.price,items.booksellerid,items.homebranch,items.itemcallnumber,items.holdingbranch,items.cn_source,biblioitems.pages,biblioitems.notes,biblioitems.publishercode,biblioitems.publicationyear,biblioitems.place,biblioitems.isbn,biblio.title,biblio.author FROM borrowers LEFT JOIN statistics on (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on (biblioitems.biblioitemnumber = items.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra rebuild frequency
Paul's XSLT was using 001 for the id. El sáb, nov 15, 2014 05:39 AM, Frédéric Demians frede...@tamil.fr escribió: Paul, could you confirm that you use Zebra in DOM mode? It seems Zebra isn't configured properly, and so doesn't know where to pick up unique ID for biblio records (biblionumber field). Without an ID to identify biblio records, Zebra can't neither delete nor update a biblio record. Check your Zebra index definition file: biblio-koha-indexdefs.xml. At the beginning of the file, you should have a line like this one: idmarc:datafield[@tag='999']/marc:subfield[@code='c']/id My assumption is that you haven't this. This could happen if the upgrade isn't done properly, for a reason or another. I have a feeling that when zebra says incremental it means just that -- adding new data, but not deleting what has gone from MySQL. It works for the vast majority of the Koha crowd. Zebra is obviously designed to be able to add/edit/delete records. It's a minimum :-) You have to figure out what's wrong with your installation. Kind regards, -- ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha