The records I bulk imported had this 942: =942 \\$2lcc$cEBK<file:///\\$2lcc$cEBK> So, if biblioitems.cn_sort was going to be generated by Koha the way items.cnsort is generated it should be populated? Guess I’ll be doing item records, after all. Thanks! From: Joy Nelson [mailto:joy@bywatersolutions.com] Sent: Wednesday, February 10, 2016 6:10 PM To: Shell, Lezlie <Lezlie.Shell@contractor.cengage.com> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] FW: Biblioitems table Lezlie- I generally don't ever populate the biblioitems callnumber fields. I'm wondering also if those fields are holdovers from a previous version of Koha. The itemcallnumber, classification and cn_sort values I work with are all in the items table. If the biblioitems.cn_sort value is to be populated it would also need to know the schema in the 942$2 ddc/loc/etc. Anyone else populating these fields in biblioitems?? joy On Wed, Feb 10, 2016 at 5:58 PM, Shell, Lezlie <Lezlie.Shell@contractor.cengage.com<mailto:Lezlie.Shell@contractor.cengage.com>> wrote: Yet another instance of retroactive clarity. I am looking at the biblioitems table in Administration/Koha to MARC mapping. I did not have a value 942|6 in my 942 import field. If I had populated 942$6 with my 050 tag contents, would Koha have created the sortable version and populated biblioitems.cn_sort? Thanks! -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz<mailto:koha-bounces@lists.katipo.co.nz>] On Behalf Of Shell, Lezlie Sent: Wednesday, February 10, 2016 5:25 PM To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Subject: [Koha] Biblioitems table We just imported our collection into our new Koha installation. It went really smoothly. Based on the schema, though, I was expecting to find a sortable call number in biblioitems.cn_sort. Since we don't circulate any materials, I didn't create any items. Is there something I needed to set or map to populate this field when I redo the import? Or, should I just add item information? Thanks, Lezlie Questia _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha -- Joy Nelson Director of Migrations ByWater Solutions<http://bywatersolutions.com> Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>