[Koha] MARC - Conversion

[Elaine Bradtke]

On Mon, May 28, 2012 at 1:02 PM, Chief Librarian, SAIACS <library at saiacs.org
> wrote:

> Hello Folks,
>
>
>
> I do not know if my question has been already answered by someone in the
> forum. Apology for my cross postings.
>
>
>
> I want to convert my catalogue records (excel form) into marc format. My
> difficulty is how could I integrate multiple copies of the same book with
> different accession/barcode into one bib record and its copies information
> in marc format. Title, author and all associated fields are in separate
> columns in the xls sheet.
>


The item information such as barcode, specific locations, and other
item-specific information goes into the 952 field. Even when you only have
one copy.  If you have more than one copy, you will have more than one item
record (952) attached to the bibliographic record.

There's a useful table here that explains what goes where, and the related
authorized values, etc.
http://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx)


>
> Please advise me, how to generate one marc record for multiple copies of
> the
> same book with different barcode numbers.
>
> I *think* what we do in our conversion process is generate multiple 952
fields in a given MARC record, one for each copy.  In our pre-conversion
database, all the specific location is tagged with the appropriate barcode
number.
The real work is all down to the digital wizardry of my colleague, I'm the
librarian half of the team.  I can ask him if you need further assistance.
But we're not using a spreadsheet as the source of the original data, so
the actual method may vary in your case.


-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)