Koha Software- Data migration- To remove leading zero digit from Barcode/accession number
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
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/0000-0003-4666-7874 Scopus ID: 57223138343 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi* On Fri, Sep 30, 2022 at 12:14 PM Manoj Kumar <manojkerl@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Indranil Das Gupta -
Manoj Kumar -
vinod mishra