Data Migration- Excel or CSV to MARC

Data Migration from CDS-ISIS or CSV to MARC i. ii. iii. iv. v. vi. vii. viii. ix.

Install Marc Edit & CDS/ISIS Prepare Tab Delimited File using Excel Make ISO using ISIS Convert Text File to Delimited Format Convert .mrk to .mrc Add/Delete Fields in Marc Edit Import Marc File using bulkmarcimport.pl Import Marc File using KOHA GUl Rebuild KOHA authorites and biblios

1. Install Marc Edit and CDS/ISIS Download MARC Edit from http://oregonstate.edu/ %7Ereeset/marcedit/html/index.php

Download .NET Framework here http://www.microsoft.com/downloads/en/default.aspx

Download CDS-ISIS from http://portal.unesco.org/ci/en/ev.phpURL_ID=5330&URL_DO=DO_TOPIC&URL_SECTION=201.html Open Marc Editor

Trusted by over 1 million members

Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.











2. Prepare Tab Delimited File using Excel Open the ".xls" file having the data in Excel. It shall look like this:































3. Make ISO using ISIS If you are converting data from CDS-ISIS then you need to follow this step to export your data to ISO format. Launch Win ISIS

































4. Convert Text File to Delimited Format Launch the "Delimited Text Translator" add-in.











Specify the input the output files.











Map columns in text file to Marc tags, something like this: Excel Title Author Place of publication

Marc Tag 245$a 100$a 260$a































































• • •

Go to Tools > Add/Delete Fields In the fields box, enter the field number you want to delete Click in Delete Field

II. Add a 942 item field • • •

In the field box enter 942 In the field data box enter \\$c[ITEM_TYPE] eg. \\$cBK Click in Add Field

III. Replace the 852 field with 952 field • • • •

Go to Edit > Replace In the Find box enter "=852 "=852"" In the Replace box enter "=952 "=952"" Click on Replace All

IV. Edit a subfield













7. Import Marc File using bulkmarcimport.pl bulkmarcimport.pl In your terminal type: # /usr/share/koha/bin/migration_tools/bulkmarcimport.pl -d -file -n 100

You can view the switches to use in bulkmarcimport by typing

# /usr/share/koha/bin/migration_tools/bulkmarcimport.pl































7. Import Marc File using KOHA GUl Go to Staff Client --> Tools --> Stage MARC Records for Import:

































Stage marc records for import:











View Staged Records











Import records into catalog:











8. Rebuild KOHA authorities and bilbois

Data Migration- Excel or CSV to MARC

Recommend Documents