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

Indranil Das Gupta indradg at gmail.com
Fri Sep 30 20:31:13 NZDT 2022

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, <manojkerl at gmail.com> wrote:

> Dear Team Koha,
> How can I remove a leading zero in the barcode entry in the case of a data
> migrated (from another software) environment?
> Can i do it in bulk of around 27000 biblio records
> Expert advice needed
> --
> manoj
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list