Importing MARC records with items
I have records that I have exported from SirsiDynix Symphony that I'm trying to import into a new instance of Koha. The bib records load, but the items are not added. MARC staging results : - Processing bibliographic records - 1 records in file - 0 records not staged because of MARC error - 1 records staged - Did not check for matches with existing records in catalog - 8 item records found and staged Manage staged records Matching rule applied: Do not look for matching records ... Item processing: Always add items Framework: default record: GAAP handbook 2010 / (0409105732) 000 00912cam a22002654a 4500 001 ocn501780795 003 OCoLC 005 20100125072801.0 008 100125s2009 sa 001 0 eng d 020 *_a*9780409105735 (pbk.) 020 *_a*0409105732 (pbk.) 035 *_a*(Sirsi) 325630 035 *_a*325630 040 *_a*T2N *_c*T2N 082 0 4 *_a*657 *_2*22 245 0 0 *_a*GAAP handbook 2010 / *_c*Denice Pretorius ... [et al.]. 246 3 3 *_a*Generally Accepted Accounting Practice handbook 260 *_a*Durban [South Africa] : *_b*LexisNexis, *_c*c2009. 300 *_a*2 v. ; *_c*24 cm. 500 *_a*"Financial Accounting and Reporting Practice, Including Illustrative GAAP"--Cover. 500 *_a*Covers accounting statements and interpretations issued by the APB up to 31 October 2009 - Pref. 596 *_a*3 7 650 0 *_a*Financial statements *_z*South Africa. 650 0 *_a*Accounting *_z*South Africa. 700 1 *_a*Pretorius, Denice. 952 *_a*657 GAA V.1 *_w*DEWEY *_c*1 *_i*DUT2009-5813 *_d*2/3/2012 *_e*2/3/2012 *_f*14/7/2015 *_g*120 *_k*DISCARD *_l*DISCARD13 *_m*MLSULTAN *_n*15 *_p*R765.32 *_r*M *_s*Y *_t*BOOKSTLN *_u*25/1/2010 *_x*BOOKS 952 *_a*657 GAA V.1 *_w*DEWEY *_c*2 *_i*DUT2009-5843 *_d*21/2/2012 *_e*21/2/2012 *_f*14/7/2015 *_g*157 *_k*DISCARD *_l*DISCARD13 *_m*MLSULTAN *_n*13 *_p*R765.32 *_r*M *_s*Y *_t*BOOKSTLN *_u*25/1/2010 *_x*BOOKS 952 *_a*657 GAA V.1 *_w*DEWEY *_c*3 *_i*DUT2009-5845 *_d*2/3/2012 *_e*2/3/2012 *_f*14/7/2015 *_g*116 *_k*DISCARD *_l*DISCARD13 *_m*MLSULTAN *_n*18 *_p*R765.32 *_r*M *_s*Y *_t*BOOKSTLN *_u*25/1/2010 *_x*BOOKS 952 *_a*657 GAA V.2 *_w*DEWEY *_c*1 *_i*DUT2009-5842 *_d*13/3/2012 *_e*13/3/2012 *_f*14/7/2015 *_g*111 *_k*DISCARD *_l*DISCARD13 *_m*MLSULTAN *_n*5 *_p*R765.32 *_r*M *_s*Y *_t*BOOKSTLN *_u*25/1/2010 *_x*BOOKS 952 *_a*657 GAA V.2 *_w*DEWEY *_c*2 *_i*DUT2009-5844 *_d*27/2/2012 *_e*27/2/2012 *_f*14/7/2015 *_g*111 *_k*DISCARD *_l*DISCARD13 *_m*MLSULTAN *_n*3 *_p*R765.32 *_r*M *_s*Y *_t*BOOKSTLN *_u*25/1/2010 *_x*BOOKS 952 *_a*657 GAA V.2 *_w*DEWEY *_c*3 *_i*DUT2009-5846 *_d*21/2/2012 *_e*21/2/2012 *_f*14/7/2015 *_g*111 *_k*DISCARD *_l*DISCARD13 *_m*MLSULTAN *_n*7 *_p*R765.32 *_r*M *_s*Y *_t*BOOKSTLN *_u*25/1/2010 *_x*BOOKS 952 *_a*657 GAA V.1 *_w*DEWEY *_c*1 *_i*DUT2009-6180 *_d*13/5/2014 *_e*30/5/2012 *_f*29/8/2013 *_g*74 *_l*DISCARD13 *_m*RIVERSIDE *_n*12 *_p*R796.85 *_r*Y *_s*Y *_t*BOOKOVLN *_u*26/1/2010 *_x*BOOKS 952 *_a*657 GAA V.2 *_w*DEWEY *_c*1 *_i*DUT2009-6181 *_d*30/5/2012 *_e*30/5/2012 *_f*14/7/2015 *_g*111 *_k*DISCARD *_l*DISCARD13 *_m*RIVERSIDE *_n*2 *_p*R796.85 *_r*M *_s*Y *_t*BOOKOVLN *_u*26/1/2010 *_x*BOOKS Import this batch into the catalog File name: 325630.mrc Comments: (none) Type: Bibliographic records Staged: 2018-04-18 10:14:46 Status: Imported Matching rule applied No matching rule in effect Action if matching record found: Add incoming record Action if no match found: Add incoming record Item processing: Always add items Number of records added 1 Number of records updated 0 Number of records ignored 0 Number of items added 0 Number of items replaced 0 Number of items ignored because of duplicate barcode 0 I thought this might be because I didn't have matching libraries and locations for the item records, but I have created those, and still get no items added. I can manually create items, but looks like the Symphony concept of a home location (l) and current location (k) is treated differently in Koha. In the edit item screen, my permanent and current locations display a list of libraries. Is that where things are going wrong in the import? Do I need to set up some kind of mapping? I'm not seeing anything in the Koha logs. This is the original record, as exported from Symphony: FORM=MONOGRAPH .000. |aam4a .001. |aocn501780795 .003. |aOCoLC .005. |a20100125072801.0 .008. |a100125s2009 sa 001 0 eng d .020. |a9780409105735 (pbk.) .020. |a0409105732 (pbk.) .035. |a(Sirsi) 325630 .035. |a325630 .040. |aT2N|cT2N .082. 04|a657|222 .245. 00|aGAAP handbook 2010 /|cDenice Pretorius ... [et al.]. .246. 33|aGenerally Accepted Accounting Practice handbook .260. |aDurban [South Africa] :|bLexisNexis,|cc2009. .300. |a2 v. ;|c24 cm. .500. |a"Financial Accounting and Reporting Practice, Including Illustrative GAAP"--Cover. .500. |aCovers accounting statements and interpretations issued by the APB up to 31 October 2009 - Pref. .596. |a3 7 .650. 0|aFinancial statements|zSouth Africa. .650. 0|aAccounting|zSouth Africa. .700. 1 |aPretorius, Denice. .952. |a657 GAA V.1|wDEWEY|c1|iDUT2009-5813|d2/3/2012|e2/3/2012|f14/7/2015 |g120|kDISCARD|lDISCARD13|mMLSULTAN|n15|pR765.32|rM|sY|tBOOKSTLN|u25/1/2010 |xBOOKS .952. |a657 GAA V.1|wDEWEY|c2|iDUT2009-5843|d21/2/2012|e21/2/2012|f14/7/2015 |g157|kDISCARD|lDISCARD13|mMLSULTAN|n13|pR765.32|rM|sY|tBOOKSTLN|u25/1/2010 |xBOOKS .952. |a657 GAA V.1|wDEWEY|c3|iDUT2009-5845|d2/3/2012|e2/3/2012|f14/7/2015 |g116|kDISCARD|lDISCARD13|mMLSULTAN|n18|pR765.32|rM|sY|tBOOKSTLN|u25/1/2010 |xBOOKS .952. |a657 GAA V.2|wDEWEY|c1|iDUT2009-5842|d13/3/2012|e13/3/2012|f14/7/2015 |g111|kDISCARD|lDISCARD13|mMLSULTAN|n5|pR765.32|rM|sY|tBOOKSTLN|u25/1/2010 |xBOOKS .952. |a657 GAA V.2|wDEWEY|c2|iDUT2009-5844|d27/2/2012|e27/2/2012|f14/7/2015 |g111|kDISCARD|lDISCARD13|mMLSULTAN|n3|pR765.32|rM|sY|tBOOKSTLN|u25/1/2010 |xBOOKS .952. |a657 GAA V.2|wDEWEY|c3|iDUT2009-5846|d21/2/2012|e21/2/2012|f14/7/2015 |g111|kDISCARD|lDISCARD13|mMLSULTAN|n7|pR765.32|rM|sY|tBOOKSTLN|u25/1/2010 |xBOOKS .952. |a657 GAA V.1|wDEWEY|c1|iDUT2009-6180|d13/5/2014|e30/5/2012|f29/8/2013 |g74|lDISCARD13|mRIVERSIDE|n12|pR796.85|rY|sY|tBOOKOVLN|u26/1/2010|xBOOKS .952. |a657 GAA V.2|wDEWEY|c1|iDUT2009-6181|d30/5/2012|e30/5/2012|f14/7/2015 |g111|kDISCARD|lDISCARD13|mRIVERSIDE|n2|pR796.85|rM|sY|tBOOKOVLN|u26/1/2010 |xBOOKS Sean P.S. search.gmane.org seems to be down --
Excerpts from Sean Carte's message of 2018-04-18 10:44:45 +0200:
I have records that I have exported from SirsiDynix Symphony that I'm trying to import into a new instance of Koha. The bib records load, but the items are not added. [...] 952
*_a*657 GAA V.1
This doesn't look quite right to me. According to the holdings table in the wiki: https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) 952$a and 952$b should contain the branch codes for owning library and holding library, respectively. Your 952$a doesn't look like a branch code, and I don't see a 952$b. When I imported our Mandarin catalog to Koha, my script set the following rather minimal holding fields, and that seemed to be enough: 942$c - item type 952$8 - collection code 952$a - owning library 952$b - holding library 952$c - location code 952$d - acquisition date 952$o - call number 952$p - barcode 952$v - price 952$y - item type Note that you need to have previously set up the authorized values for collection codes and location codes for this to work.
The user manual used to have a great table listing all of the 952 fields, which ones were required (with a default installation and with the loading of defaults during the web installer) and which ones were required (for circulation). A quick search and I am unable to find that table in the 17.11 version of the manual found on the website under https://koha-community.org/documentation/. I used it so much during my migration I made a separate copy of just those pages. I don't believe anything has changed here: https://drive.google.com/file/d/0B__rFSyBuUz1bHpZT25Sd1FKMVRlVXNOOFYxZG9uM2w... Migrating from an Innovative server, I used MarcEdit to create 952 fields for my item records and then loaded bibs and items at the same time. This was a few years ago, but I recall the trickiest part for me was combining the call number information, previously in two separate subfields in the bib record, into a single subfield as required by the 952. John On Wed, Apr 18, 2018 at 7:46 AM, Mark Alexander <marka@pobox.com> wrote:
I have records that I have exported from SirsiDynix Symphony that I'm trying to import into a new instance of Koha. The bib records load, but
Excerpts from Sean Carte's message of 2018-04-18 10:44:45 +0200: the
items are not added. [...] 952
*_a*657 GAA V.1
This doesn't look quite right to me. According to the holdings table in the wiki:
https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx)
952$a and 952$b should contain the branch codes for owning library and holding library, respectively. Your 952$a doesn't look like a branch code, and I don't see a 952$b.
When I imported our Mandarin catalog to Koha, my script set the following rather minimal holding fields, and that seemed to be enough:
942$c - item type 952$8 - collection code 952$a - owning library 952$b - holding library 952$c - location code 952$d - acquisition date 952$o - call number 952$p - barcode 952$v - price 952$y - item type
Note that you need to have previously set up the authorized values for collection codes and location codes for this to work. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- -=<*>=- -=<*>=- -=<*>=- -=<*>=- -=<*>=- -=<*>=- -=<*>=- -=<*>=- -=<*>=- John E. Sterbenz, Jr. Senior Associate Librarian Manager, Technical Services, Collections, and Library Automation 700 East University Avenue Kresge Hall, 4th Floor East Suite K4511 Kresge Library Services The University of Michigan Ann Arbor, Michigan, USA 48109-1234 TEL: (734) 764-5746
Thank you, John and Mark, that should be enough to get me started. Sean On 18 April 2018 at 14:07, John Sterbenz <jsterben@umich.edu> wrote:
The user manual used to have a great table listing all of the 952 fields, which ones were required (with a default installation and with the loading of defaults during the web installer) and which ones were required (for circulation). A quick search and I am unable to find that table in the 17.11 version of the manual found on the website under https://koha-community.org/documentation/.
I used it so much during my migration I made a separate copy of just those pages. I don't believe anything has changed here: https://drive.google.com/file/d/0B__rFSyBuUz1bHpZT25Sd1FKMVRlVXNOO FYxZG9uM2w0U2Vj/view?usp=sharing
Migrating from an Innovative server, I used MarcEdit to create 952 fields for my item records and then loaded bibs and items at the same time. This was a few years ago, but I recall the trickiest part for me was combining the call number information, previously in two separate subfields in the bib record, into a single subfield as required by the 952.
John
On Wed, Apr 18, 2018 at 7:46 AM, Mark Alexander <marka@pobox.com> wrote:
I have records that I have exported from SirsiDynix Symphony that I'm trying to import into a new instance of Koha. The bib records load, but
Excerpts from Sean Carte's message of 2018-04-18 10:44:45 +0200: the
items are not added. [...] 952
*_a*657 GAA V.1
This doesn't look quite right to me. According to the holdings table in the wiki:
https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx)
952$a and 952$b should contain the branch codes for owning library and holding library, respectively. Your 952$a doesn't look like a branch code, and I don't see a 952$b.
When I imported our Mandarin catalog to Koha, my script set the following rather minimal holding fields, and that seemed to be enough:
942$c - item type 952$8 - collection code 952$a - owning library 952$b - holding library 952$c - location code 952$d - acquisition date 952$o - call number 952$p - barcode 952$v - price 952$y - item type
Note that you need to have previously set up the authorized values for collection codes and location codes for this to work. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- -=<*>=- -=<*>=- -=<*>=- -=<*>=- -=<*>=- -=<*>=- -=<*>=- -=<*>=- -=<*>=- John E. Sterbenz, Jr. Senior Associate Librarian Manager, Technical Services, Collections, and Library Automation 700 East University Avenue Kresge Hall, 4th Floor East Suite K4511 Kresge Library Services The University of Michigan Ann Arbor, Michigan, USA 48109-1234
TEL: (734) 764-5746 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
--
Hi, Sean-- I had one other thought that might be helpful--your 952 $p fields don't seem to contain unique barcode numbers, and if your UniqueItemFields system preference is set to require that the barcode field be unique, that might be also causing you problem(s) with your importing, item creation, etc. Cheerio, h2 ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032, heather_hernandez@nps.gov Library catalog: http://keys.bywatersolutions.com/
participants (4)
-
Hernandez, Heather -
John Sterbenz -
Mark Alexander -
Sean Carte