Pages

▼

Bulk marc import using command line

Load environmental variables

sudo su
export PERL5LIB="/usr/share/koha/lib"
export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"

Move marc file to the folder where bulkmarcimport.pl is located.

e.g. Move a marc file from your home folder to following folder,

mv sample.mrc /usr/share/koha/bin/migration_tools

Go to the folder where import script located

cd /usr/share/koha/bin/migration_tools

Execute the following command,

perl bulkmarcimport.pl -file sample.mrc

User can import bibliographic records in a desired MARC Bibliographic Framework (e.g. BKS),

perl bulkmarcimport.pl -framework BKS -file sample.mrc

The following command will delete all existing records and install new batch of marc file.

perl bulkmarcimport.pl -d -file sample.mrc

 Rebuild Zebra after import process finish

sudo koha-rebuild-zebra -v -f library

Information courtesy: Koha Users Group

Reference
https://perldoc.koha-community.org/misc/migration_tools/bulkmarcimport.html

11 comments:

  1. Rajendra Kumar JenaJuly 21, 2016 at 5:04 AM

    Dear Vimal Jee,
    I have installed koha fresh. Is it mandatory run the following command line perl bulkmarcimport.pl -d -file sample.mrc mentioed by you. Beacause when i run this command it creates records having no item.

    Very useful guidance.

    thanks
    RK Jena, SPA Bhopal

    ReplyDelete
    Replies
    1. VimalJuly 21, 2016 at 10:39 PM

      Sir,
      You can import using GUI.
      Tools > Stage MARC Records for Import

      Delete
  2. Subhash SharmaJuly 21, 2016 at 9:33 PM

    Is there any command or build index that make only one catalogue to four same title

    ReplyDelete
  3. VishalSeptember 15, 2016 at 11:02 PM

    Dear Sir,
    Using GUI (Tools > Stage MARC Records for Import) I'm importing marc file with 9 entries(5 same title + 4 same title) with unique barcode for each. But it import 9 records and 63 items in catalogue instead of 9 items.
    Below are the marc file fields that i included in my marc file.

    082$2
    100$a
    100$c
    245$a
    250$a
    260$a
    260$b
    260$a
    300$a
    521$b
    760$b
    942$c
    952$p
    952$2
    952$a
    952$b
    952$d
    952$w
    952$y

    Plz help me. Thanks in advance

    ReplyDelete
    Replies
    1. VimalSeptember 21, 2016 at 9:28 PM

      The problem with MARC conversion.
      Item information in 952 split into various items.

      Delete
  4. Dr. Anuradha SethSeptember 19, 2016 at 12:18 AM

    thanx for sharing such a valuable information. It really helped me in creating a perfect bibliography

    ReplyDelete
  5. JLC, BangaloreDecember 7, 2016 at 2:31 AM

    Dear Mr. Vimal,

    Please confirm me should I export environment variables whenever I do bulkimport.pl.

    Thanks
    Yesan
    Chief Librarian
    SAIACS, Bangalore

    ReplyDelete
    Replies
    1. VimalDecember 7, 2016 at 8:58 AM

      Exporting environment variables is essential.

      Delete
  6. Unaise. E.KDecember 29, 2016 at 12:08 AM

    sir, pls give suitable MARC file field for this (field in my database) AccNo, AccDate, Title, Author1, Author2, Author3, Publisher, Year, ClassNo, BKno, Vol, Series, Page, Price, Edition.

    Pls help me, thanks in advance

    ReplyDelete
    Replies
    1. VimalDecember 30, 2016 at 2:39 AM

      AccNo 952$p
      AccDate 952$d
      Title 245$a
      Author1 100$a
      Author2 700$a
      Author3 700$a
      Publisher 260$b
      Year 260$c
      ClassNo 082$a
      BKno 082$b
      Vol 952$h
      Series 490$a
      Page 300$a
      Price 952$g
      Edition 250$a

      Delete
  7. VimalDecember 30, 2016 at 2:39 AM

    This comment has been removed by the author.

    ReplyDelete