Hi Thanks for the information. In my Excel file I do have a column for 952$o and 050$a, but I do not know why the item records where not populated with the call numbers? Also my itemcallnumber in the Cataloguing global preferences is set to 050ab. I am now wondering is there is a script or mysql query that I can run to update the item call numbers. Regards, Admire Mutsikiwa -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@lists.katipo.co.nz Sent: Thursday, February 28, 2013 1:00 AM To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 88, Issue 39 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Call number appearing in Bib record but not in Item (Olugbenga Adara) ---------------------------------------------------------------------- Message: 1 Date: Wed, 27 Feb 2013 12:56:25 -0800 (PST) From: Olugbenga Adara <gbengaadara@yahoo.com> To: amutsikiwa <amutsikiwa@uzlib.uz.ac.zw>, "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Call number appearing in Bib record but not in Item Message-ID: <1361998585.16113.YahooMailNeo@web162006.mail.bf1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Hello Admire,
I have imported a records from an Excel file to Koha. My? major challenge now is that call numbers are appearing on bib records but not on item records. I am aware there is a settings that you have to setup for the item records to pick the call number form bib.? I will appreciate any hint.
If you imported from Excel, then you should have made sure that your call number is mapped to 952$o. Then your call number will appear on item records. if you used Marcedit for translating your Excel file to MARC, this should be easy. However if you were doing copy cataloging and you wanted the call number to show up in items, then you should set the itemcallnumber under the cataloging system preference. For example if you were using LC then you would enter 050ab into the itemcallnumber field. You can check http://manual.koha-community.org/3.10/en/administration.html#catprefs for more info. I am not sure setting the itemcallnumber will work for imported data. Others may be able to confirm. I usually populate the field while converting data using MarcEdit. Hope this helps. Olugbenga Adara ------------------------------ _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 88, Issue 39 ************************************ -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.