;Hi Kazım, This Koha wiki page provides the detailed mapping between 952 marc field and koha's items table - https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) If your barcodes are already in place in the Koha database's items table you can update the field 952$g (items.price) individually as follows: UPDATE items SET items.price = 16.45 WHERE items.barcode = '302594'; NOTE: this will require you to run a separate SQL UPDATE query for each barcode. Since this is directly working on the database backend, please take a full database backup before you do this. Once you are done with the update statements, be sure to restart memcached service and also rebuild the zebra index. Hope this helps. -- Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 WWW : http://www.l2c2.co.in Blog : http://blog.l2c2.co.in IRC : indradg on irc://irc.freenode.net Twitter : indradg On Thu, Aug 1, 2024 at 5:06 PM Kazım ŞENTÜRK <ksenturk@uludag.edu.tr> wrote:
Hello,
The barcodes below (952$p) field of 952$g - Cost, normal purchase price are not recorded:
302594 305835 314329
I have an Excel file that includes barcode numbers and their price fields like below:
952$p - 952$g 302594 - 16.45 305835 - 10.80 314329 - 9.60
Could we match the barcode numbers registered in KOHA with the barcode numbers in our Excel file to import the price value into 952$g?
Best regards
Kazım ŞENTÜRK Kütüphane Müdür V. Bursa Uludağ Üniversitesi Kütüphane ve Dokümantasyon Daire Başkanlığı Prof. Dr. Fuat Sezgin Merkez Kütüphanesi Görükle Yerleşkesi Nilüfer / Bursa
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha