[Koha] FW: Biblioitems table

[Hillyard, Cecil]

What is the matching rules search index for the 999?

__________________
Cecil Hillyard
Washoe County Library
Technical Services
775-327-8338

-----Original Message-----
From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Joy Nelson
Sent: Thursday, February 11, 2016 7:46 AM
To: Shell, Lezlie
Cc: koha at 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.Shell at 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:joy at bywatersolutions.com]
> *Sent:* Wednesday, February 10, 2016 6:10 PM
> *To:* Shell, Lezlie <Lezlie.Shell at contractor.cengage.com>
> *Cc:* koha at 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 at 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 at lists.katipo.co.nz] On Behalf Of 
> Shell, Lezlie
> Sent: Wednesday, February 10, 2016 5:25 PM
> To: koha at 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 at lists.katipo.co.nz 
> https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list  http://koha-community.org Koha at 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/>
_______________________________________________
Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha