Conversion of CDS/ISIS records to MARC 21 for Koha using MarcEdit.

 

Software required

CDS/ISIS

MARC Edit (http://oregonstate.edu/~reeset/marcedit/html/index.php)

.NET Framework required for the installation of MarcEdit. You can download from here,

http://msdn.microsoft.com/hi-in/netframework/default.aspx

 

Export CDS/ISIS data in ISO format

 

CDS/ISIS > Database > Export

 

 

 

It will save your ISIS data in ISO format.

Converting ISO file to MARC

 

a). Open MarcEdit and select Add-ins>CDS-ISIS.iso=>MARC Translation

 

 

 

 

b). Locate your iso file and find the place to save the output .mrc file.

c). Check Simple Translation and Click OK button.

This process will convert your ISO file to MARC file with the extension .mrc.

 

 

4). Editing MARC fields.

 

 

MARC Translation feature converted your ISO file into MARC format. But the fields and sub fields numbers are different from MARC-21 format. Here is the tag numbers used in CDS/ISIS for various fields,

 

 

Accession Number	120
Author	300
Title	200
Edition	260
Editor	302
Imprint	400
Call Number	610
Subject	620
General Note	500

 

 

Your CDS/ISIS field numbers may be different.

 

 

We have to change CDS/ISIS field numbers suitable with MARC 21. You can see field numbers used in MARC 21 to represent bibliographic fields,

 

 

Author	100
Title	245
Edition	250
Editor	700
Imprint	260
Call Number	082
Subject	650
General Note	500
Accession Numbe	952

 

To get more understanding about various MARC tags and its use, consult http://www.itsmarc.com/crs/bib1468.htm

or goto Koha > Administration > MARC Bibliographic Framework 

 

 

Accession Number 952 (Koha used 952 field to store item information (e.g. Library branch code, Date Acquired, Price etc).

Important subfields used in 952 MARC tag in Koha are,

 

952 -LOCATION AND ITEM INFORMATION

4 Damaged status

9 Koha itemnumber (autogenerated)

a Permanent location

b Current location

c Shelving location

d Date acquired

g Cost, normal purchase price

o Full call number

p Barcode

 

 

 

1). List out your CDS/ISIS field numbers against MARC field number for the convenience of mapping process.

 

 

Catalogue Fields	CDS/ISIS field number	MARC-21 field number
ISBN	100	020
Author	300	100
Title	200	245
Edition	260	250
Editor	302	700
Imprint	400	260
Call Number	610	082
Subject	620	650
Accession Number	120	952
Extent	460	300

 

 

 2). Open MarcEditor from main window of MarcEdit.

 

 

 

3). Open your .mrc file from File > Open.

 

 

Select “MARC Files (*.mrc)” from “Files of type” option to see .mrc file you generated from ISO file. Click on the MARC file and Open it.

 

 

 

It will display your MARC records in MarcEditor.

 

 

 

4). Changing of field numbers.

 

 

We are going to edit the field numbers compatible with MARC-21 suitable for Koha.

 

Open Edit>Replace

 

 

 

 

We are going to change 300 (author) to 100.

 

 

Input =300 in Find what: text box.

 

 

Input  =100  \\$a in Replace with: text box.

 

 

Press Replace All button

 

 

100 = Author field according to MARC-21

$a   = Sub field for Author Personal name

 

 

This action will change all tag number of title (300) to 100.

 

 

The same way you can try to change ISBN -100 to 020.

 

 

 

See the changes in entries,

 

 

 

 

You can try to change other MARC entries using the same way.

 

 

Editing item information

 

Item information in Koha stores data regarding document barcode (Accession Number), price, date acquired, shelving location etc. Koha use 952 field to store item information. Here, field 120 store Accession Number.  We have to change 120 to 952 with some modifications. Here we are going to add library branch information to 952 field.

 

 

 

Click on Replace All button.

 

 

952 = Item information field,

$a = Home branch, MAIN is library branch code,

$b = Holding Branch, MAIN is holding branch code,

$p = Accession Number.

 

 

Go to Koha Administration > Libraries and Groups to find your library branch code.

 

 

Adding Item Type

 

Item type defines in which category the documents belongs (e.g. book, report, CD-ROM etc).

 

Here, no item type defined. We have to add a new field for the item type.

 

Tools>Add/Delete Field

 

 

 

942 - Added entry elements of Koha

$c   -  Subfield

BK  - Category code for books in Koha.

 

 

Go to Koha Administration > Item Types to find your item type code.

 

Enter 942 in Field input box.

Enter \\$cBK in Field Data box.

Check Insert last

Click on Add Field

Press Close button after changes made.

 

Compile the records, File > Compile File into MARC

Save the file by giving a different name.

 

See the display of records after completing the editing process

 

 

 

 

 

You can use the resulted .mrc file to import into Koha using

Koha Home > Tools > Stage MARC Records for Import.

 

 

 

 

 

Rebuild Zebra Index

 

Run Zebra engine available with Koha to index newly imported records.

 

Open a terminal and run:

 

cd /usr/share/koha/bin/migration_tools

 

./rebuild_zebra.pl -b -r

 

 

 

This document licensed under  

Inform me your comments and suggestions to improve this document

 

Vimal Kumar V., Asst. Librarian, Asian School of Business, Technopark, Trivandrum-695 581.

www.vimalkumar.co.nr