Re: [Koha] Koha Software- Data migration- To remove leading zero digit from Barcode/accession number

Hello From which format do you want to remove? Excel/MARC etc. With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 URL: http://vinod.itshelp.co.in/ ORCID ID: http://orcid.org/-0003-4666-

Re: [Koha] Koha Software- Data migration- To remove leading zero digit from Barcode/accession number

Hi Manoj, If you have already imported the data into Koha, then: UPDATE items SET barcode = TRIM(LEADING '0' FROM barcode) Followed by memcached restart and a Zebra reindex hope this helps Indranil Das Gupta L2C2 Technologies On Fri, 30 Sep, 2022, 12:14 pm Manoj Kumar, wrote: > Dear Team K

Re: [Koha] [Koha-devel] Critical error on Koha website

Hi friends, This was related to an update to Wordpress and the theme we use. Have sorted out those issues and things are seeming better now, if you'd please test! Cheers, Liz On Thu, Sep 29, 2022 at 2:51 PM Michael Kuhn wrote: > Hi > > When I'm trying to preview or release the current Koha new

Re: [Koha] [Koha-devel] Critical error on Koha website

Hi Liz You wrote: > This was related to an update to Wordpress and the theme we use. Have > sorted out those issues and things are seeming better now, if you'd > please test! I noticed two things: 1. For example in https://koha-community.org/koha-community-newsletter-september-2022/ I am usi

[Koha] Excess fields in Koha 22.05 file "patron_import.csv"

Hi When unloading the field names of Koha 22.05 table "borrowers" I get 79 field names (plus "borrowernumber"). But when in Koha 22.05 menu "Tools > Import patrons" I click the link "Starter CSV file" the unloaded file "patron_import.csv" does include 82 fields. When comparing the two outp

Re: [Koha] [Koha-devel] Excess fields in Koha 22.05 file "patron_import.csv"

Hi Michael, Their mapping as follows For patron_attributes - https://schema.koha-community.org/22_05/tables/borrower_attributes.html For "guarantor_relationship" and "guarantor_id" - https://schema.koha-community.org/22_05/tables/borrower_relationships.html hope this helps Indranil Das Gupta L

Re: [Koha] Fines Not calculating (Koha v22.05)

Is the finesmode system preference set to Calculate and charge? Katrin On 29.09.22 22:55, Evan Mungai Njoroge wrote: Thank you for your suggestion. Tried running fine.pl  with a -v switch Gives me the output, see screenshot [https://drive.google.com/file/d/13uexHXv_jdkqZkzlg2O

Re: [Koha] Fines Not calculating (Koha v22.05)

Yes, it is. On Fri, Sep 30, 2022, 21:34 Katrin Fischer wrote: > Is the finesmode system preference set to Calculate and charge? > > Katrin > On 29.09.22 22:55, Evan Mungai Njoroge wrote: > > Thank you for your suggestion. Tried running fine.pl with a -v switch > > Gives me the output, see screen