Wrong order wehen sorting public list by copyright year
Hi We are working with Koha 18.11.05 on Debian GNU/Linux 8. In our library we found in the OPAC it is not possible to sort public lists correctly by copyright date. As far as I know sorting by copyright date would follow the content of MARC 008 position 7-10. But looking at an actual sorting we see the sorting is as follows 2018 2017 2016 2015 2015 2014 2014 2013 2011 2017 <-- here it starts getting wrong 2019 2018 2016 2018 2016 ... Alle these records have correct content in MARC 008 and MARC 264$c. Strangely we found if a record has content in MARC 260$c and 264$c it changes the sort order - even if only MARC 008 should be relevant for the sort order. How can we achieve the correct sort order? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
Hi Michael, while the list result list for lists looks a lot like the catalog search results, it's not working quite the same. Instead of using Zebra, it's build with SQL. That means that the sorting does work differently as well. My guess would be it's using biblio.copyrightdate. I would check the contents of the columns and your Koha-to-MARC mappings for it. In 18.11 it's possible to map both 260$c and 264$c, but it's not done by default. Hope that helps, Katrin On 08.07.20 11:20, Michael Kuhn wrote:
Hi
We are working with Koha 18.11.05 on Debian GNU/Linux 8.
In our library we found in the OPAC it is not possible to sort public lists correctly by copyright date.
As far as I know sorting by copyright date would follow the content of MARC 008 position 7-10. But looking at an actual sorting we see the sorting is as follows
2018 2017 2016 2015 2015 2014 2014 2013 2011 2017 <-- here it starts getting wrong 2019 2018 2016 2018 2016 ...
Alle these records have correct content in MARC 008 and MARC 264$c.
Strangely we found if a record has content in MARC 260$c and 264$c it changes the sort order - even if only MARC 008 should be relevant for the sort order.
How can we achieve the correct sort order?
Best wishes: Michael
Hi Katrin
while the list result list for lists looks a lot like the catalog search results, it's not working quite the same. Instead of using Zebra, it's build with SQL. That means that the sorting does work differently as well.
Koha is a grab bag - there are always new things inside that I didn't know about...
My guess would be it's using biblio.copyrightdate. I would check the contents of the columns and your Koha-to-MARC mappings for it. In 18.11 it's possible to map both 260$c and 264$c, but it's not done by default.
In Koha menu "Administration > Koha-zu-MARC-Mapping" I have found only the following mapping: Koha-Feld Tag Unterfeld Bib biblio.copyrightdate 260 c Erscheinungsjahr, Vertriebsjahr etc. I have now added: biblio.copyrightdate 264 c Datum der Herstellung, der Veröffentlichung, des Vertriebs oder des But still the list shows the same wrong sort order... Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
Hi Michael Have you reindexed your DB after the change? Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le dim. 12 juil. 2020 à 08:15, Michael Kuhn <mik@adminkuhn.ch> a écrit :
Hi Katrin
while the list result list for lists looks a lot like the catalog search results, it's not working quite the same. Instead of using Zebra, it's build with SQL. That means that the sorting does work differently as well.
Koha is a grab bag - there are always new things inside that I didn't know about...
My guess would be it's using biblio.copyrightdate. I would check the contents of the columns and your Koha-to-MARC mappings for it. In 18.11 it's possible to map both 260$c and 264$c, but it's not done by default.
In Koha menu "Administration > Koha-zu-MARC-Mapping" I have found only the following mapping:
Koha-Feld Tag Unterfeld Bib
biblio.copyrightdate 260 c Erscheinungsjahr, Vertriebsjahr etc.
I have now added:
biblio.copyrightdate 264 c Datum der Herstellung, der Veröffentlichung, des Vertriebs oder des
But still the list shows the same wrong sort order...
Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Michael, the change of the mapping will immediately apply for adding new records or when editing existing records, but not immediately for all of your records without touching them again. I believe that the maintenance job batchRebuildBiblioTables.pl can help with that. Katrin On 12.07.20 15:14, Michael Kuhn wrote:
Hi Katrin
while the list result list for lists looks a lot like the catalog search results, it's not working quite the same. Instead of using Zebra, it's build with SQL. That means that the sorting does work differently as well.
Koha is a grab bag - there are always new things inside that I didn't know about...
My guess would be it's using biblio.copyrightdate. I would check the contents of the columns and your Koha-to-MARC mappings for it. In 18.11 it's possible to map both 260$c and 264$c, but it's not done by default.
In Koha menu "Administration > Koha-zu-MARC-Mapping" I have found only the following mapping:
Koha-Feld Tag Unterfeld Bib
biblio.copyrightdate 260 c Erscheinungsjahr, Vertriebsjahr etc.
I have now added:
biblio.copyrightdate 264 c Datum der Herstellung, der Veröffentlichung, des Vertriebs oder des
But still the list shows the same wrong sort order...
Best wishes: Michael
Hi Katrin
the change of the mapping will immediately apply for adding new records or when editing existing records, but not immediately for all of your records without touching them again. I believe that the maintenance job batchRebuildBiblioTables.pl can help with that.
Yes, this helped! After changing the Koha-to-MARC-mapping I ran the maintenance job "batchRebuildBiblioTables.pl". Now the sort order of the public lists in the OPAC works as desired. Many thanks & best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
Yes, this helped! After changing the Koha-to-MARC-mapping I ran the maintenance job "batchRebuildBiblioTables.pl". Now the sort order of the public lists in the OPAC works as desired.
Is that job typically scheduled to run automatically, or would libraries have to run this manually every time the mapping table is changed? Something we would need to check w/ our support vendor on? All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH
Hi Cab Am 16.07.20 um 15:42 schrieb Cab Vinton:
Yes, this helped! After changing the Koha-to-MARC-mapping I ran the maintenance job "batchRebuildBiblioTables.pl". Now the sort order of the public lists in the OPAC works as desired.
Is that job typically scheduled to run automatically, or would libraries have to run this manually every time the mapping table is changed? Something we would need to check w/ our support vendor on?
This job is typically NOT scheduled to run automatically so you best run it manually every time you need to resp. tell your support vendor to do so. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
participants (4)
-
Alvaro Cornejo -
Cab Vinton -
Katrin Fischer -
Michael Kuhn