Re: [Koha] Importing MARC records with items

2018-04-18 Thread Sean Carte 
Thank you, John and Mark, that should be enough to get me started.

Sean

On 18 April 2018 at 14:07, John Sterbenz  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  wrote:
>
> > 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.
> > ___
> > 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
>



--
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Importing MARC records with items

2018-04-18 Thread John Sterbenz 
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__rFSyBuUz1bHpZT25Sd1FKMVRlVXNOOFYxZG9uM2w0U2Vj/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  wrote:

> 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.
> ___
> 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

Re: [Koha] Importing MARC records with items

2018-04-18 Thread Mark Alexander 
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.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Importing MARC records with items

2018-04-18 Thread Sean Carte 
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. |a100125s2009sa001 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