| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

FrontPage

Page history last edited by Vimal Kumar 14 years, 4 months ago

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

 

l

 

 

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

 

 

Comments (0)

You don't have permission to comment on this page.