Glad to hear that! joy
On Thu, Feb 11, 2016 at 2:28 PM, Shell, Lezlie < lezlie.sh...@contractor.cengage.com> wrote: > It worked! > > > > I added the $hCALL NUMBER to my 942 tag in MarcEdit and when it updated, > biblioitems.cn_sort was populated. > > > > Thanks for your help. > > > > Also, thanks Cecil and Thomas for your interest and willingness to help. > > > > Lezlie > > > > *From:* Joy Nelson [mailto:j...@bywatersolutions.com] > *Sent:* Thursday, February 11, 2016 9:46 AM > *To:* Shell, Lezlie <lezlie.sh...@contractor.cengage.com> > *Cc:* koha@lists.katipo.co.nz > *Subject:* Re: [Koha] FW: Biblioitems table > > > > Lezlie- > > You could try exporting the marc records from Koha and then moving the 050 > data to the 942 callnumber field (h and m?) using your favorite marc > editor. Then reimport the records matching and overlaying on the > biblionumber 999c. The cn_sort in items is autogenerated by the value in > itemcallnumber. I would expect the same behavior in biblioitems. But, > again, it is not something I have direct knowledge of. > > Or, yes, you can create item records that contain the classification > source and callnumber. Koha will generate the cn_sort for you. > > Good luck! > > joy > > > > On Thu, Feb 11, 2016 at 8:34 AM, Shell, Lezlie < > lezlie.sh...@contractor.cengage.com> wrote: > > The records I bulk imported had this 942: =942 \\$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:j...@bywatersolutions.com] > *Sent:* Wednesday, February 10, 2016 6:10 PM > *To:* Shell, Lezlie <lezlie.sh...@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.sh...@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-boun...@lists.katipo.co.nz] On Behalf Of Shell, > Lezlie > Sent: Wednesday, February 10, 2016 5:25 PM > To: 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 > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > Koha mailing list http://koha-community.org > 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/> > > > > > -- > > 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/> > -- 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/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha