[Koha] Patrons report errors

[John Fawcett]

Solomon

for Koha the categories in the borrowers table need to be defined in the
categories table. In particular the report wants to read the description
of the category from the categories table to use it as a column heading.
Koha enforces this for records added or deleted through the GUI.

As a work around you can add the missing categories (if they are
correct) via the administration menu.

As a long term solution, it depends on whether you want to be able to
define new categories in the ERP or not.

If not, then the solution can be to implement an integration from Koha
to ERP to export the allowed categories and validate new borrower data
to ensure they have a valid category.  Potentially you oculd add a check
to the ERP-Koha borrower integration to ensure that borrowers without
valid categories are rejected.

If instead you want to be able to define new categories in the ERP
system, the solution could be to capture the relevant data (including
description) of the category in the ERP and pass it via a new
integration to Koha prior to importing the borrowers.

Hope that helps

John


On 07/10/2020 10:09, Solomon Mutai wrote:
> Yes, it does. From our ERP
>
> On Wed, Oct 7, 2020 at 1:46 AM John Fawcett <john at voipsupport.it
> <mailto:john at voipsupport.it>> wrote:
>
>     On 06/10/2020 14:10, Solomon Mutai wrote:
>     > Hi,
>     >
>     > I am new to Koha and was trying to check on patrons reports. We
>     seem to
>     > have no problems with catalging reports though. We have
>     installed Koha
>     > 20.05 on Ubuntu lts 20.04.
>     >
>     > The error we get is:
>     > Software error:
>     >
>     > Can't call method "description" on an undefined value at
>     > /usr/share/koha/intranet/cgi-bin/reports/borrowers_stats.pl
>     <http://borrowers_stats.pl> line 323.
>     > _______________________________________________
>     >
>     > Koha mailing list  http://koha-community.org
>     > Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>     > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
>     Hi Solomon
>
>     could be a data issue. Does your borrowers table contain a
>     category code
>     which isn't defined in the categories table?
>
>     John
>