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
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] 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
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> 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] 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/>
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/>
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@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@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> 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] 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/>
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@lists.katipo.co.nz] On Behalf Of Joy Nelson Sent: Thursday, February 11, 2016 7:46 AM To: Shell, Lezlie 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.Shell@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@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> 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] 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/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
2016-02-11 15:48 GMT-03:00 Hillyard, Cecil <CHillyard@washoecounty.us>:
What is the matching rules search index for the 999?
Local-Number ? -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
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@bywatersolutions.com] Sent: Thursday, February 11, 2016 9:46 AM To: Shell, Lezlie <Lezlie.Shell@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.Shell@contractor.cengage.com<mailto:Lezlie.Shell@contractor.cengage.com>> wrote: 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<mailto:joy@bywatersolutions.com>] Sent: Wednesday, February 10, 2016 6:10 PM To: Shell, Lezlie <Lezlie.Shell@contractor.cengage.com<mailto:Lezlie.Shell@contractor.cengage.com>> Cc: koha@lists.katipo.co.nz<mailto: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/> -- 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/>
Glad to hear that! joy On Thu, Feb 11, 2016 at 2:28 PM, Shell, Lezlie < Lezlie.Shell@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@bywatersolutions.com] *Sent:* Thursday, February 11, 2016 9:46 AM *To:* Shell, Lezlie <Lezlie.Shell@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.Shell@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@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> 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] 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/>
participants (4)
-
Hillyard, Cecil -
Joy Nelson -
Shell, Lezlie -
Tomas Cohen Arazi