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@voipsupport.it <mailto:john@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@lists.katipo.co.nz <mailto:Koha@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