[Koha] Import Authorities Data

Stefano Bargioni bargioni at pusc.it
Tue Nov 22 22:30:20 NZDT 2011

Hi, Tiago:
this was my experience during migration from non-Koha to Koha 3.2.
In Koha, manually add some auth records, at least one for each type of auth you are going to import.
Look at created records in table auth_header. Use each auth_header.marcxml as a model for a (perl) script to tail marcxml records with your data (name;cutter;dates).

A model for PERSO_NAME (replace *...* with your data) could be:

  <leader>00000nz  a2200133n  4500</leader>
  <controlfield tag="003">*YOUR LIBRARY CODE*</controlfield>
  <controlfield tag="005">*CURRENT TIMESTAMP like 20101125120000.0*</controlfield>
  <controlfield tag="008">*YYMMDD*n||a|nnnaabn          || aad    |d</controlfield>
  <datafield tag="040" ind1=" " ind2=" ">
    <subfield code="a">*YOUR LIBRARY CODE*</subfield>
    <subfield code="c">*YOUR LIBRARY CODE*</subfield>
  <datafield tag="100" ind1="0" ind2=" ">
    <subfield code="a">*SURNAME, NAME*</subfield>
  <datafield tag="400" ind1="0" ind2=" ">
    <subfield code="a">*USED FOR/SEE FROM*</subfield>
  <datafield tag="942" ind1=" " ind2=" ">
    <subfield code="a">PERSO_NAME</subfield>

At begin of file insert:

<?xml version="1.0" encoding="UTF-8"?>
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"

and append at end of file


Then import the created xml file using 

bulkmarcimport.pl -a -m marcxml -file your_authorities.xml

and link them to your biblios with


HTH. Stefano

> Hi,
> What is the best pratice to import Authority data?
> I have a list of my older system formated as: name;cutter;dates
> (~60.000 lines). I want format it to Authority database in Koha.  What
> is the best metod?
> I use the version 3.6 of Koha on Ubuntu 11.10.
> Thanks
> -- 
> Tiago Murakami

More information about the Koha mailing list