[Koha] FW: Biblioitems table

[Joy Nelson]

Glad to hear that!

joy

On Thu, Feb 11, 2016 at 2:28 PM, Shell, Lezlie <
Lezlie.Shell at 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:joy at bywatersolutions.com]
> *Sent:* Thursday, February 11, 2016 9:46 AM
> *To:* Shell, Lezlie <Lezlie.Shell at contractor.cengage.com>
> *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/>
>



-- 
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/>