[Koha] bulkmarcimport.pl

Ata ur Rehman ata.rehman at gmail.com
Thu Sep 4 16:35:52 NZST 2008 

C:\usr\koha228\scripts\misc\migration_tools>perl bulkmarcimport.pl -file
filename.mrc

where filename.mrc is the filename of your data file in marc format

Ata
LISolutions.org



On Thu, Sep 4, 2008 at 9:26 AM, thandu venkat narayana <
thandu_venkat at yahoo.com> wrote:

> Dear All,
>
> I am using koha 2.2.8 on windows,
> How to use bulkmarcimport.pl to add library records.
>
> Regards
>
> *T.Venkat Narayana*
> M.A.,M.L.I.Sc.;PGDLAN,
> Assistant Librarian,
> Sri Venkateswara Engineering College,
> SURYAPET - A.P.
> INDIA
>
>
> --- On *Wed, 3/9/08, koha-request at lists.katipo.co..nz <
> koha-request at lists.katipo.co.nz>* wrote:
>
> From: koha-request at lists.katipo.co.nz <koha-request at lists.katipo.co.nz>
> Subject: Koha Digest, Vol 35, Issue 8
> To: koha at lists.katipo.co.nz
> Date: Wednesday, 3 September, 2008, 6:47 PM
>
> Send Koha mailing list submissions to
> 	koha at lists.katipo.co.nz
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://lists.katipo.co.nz/mailman/listinfo/koha
> or, via email, send a message with subject or body 'help' to
> 	koha-request at lists.katipo.co.nz
>
> You can reach the person managing the list at
> 	koha-owner at lists.katipo.co.nz
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Koha digest..."
>
>
> Today's Topics:
>
>    1. migrating winisis data into koha (Zahir Husain Mohamed Ismail)
>    2. Quesitons about make_spellcheck_suggest.pl (Brendan Gallagher)
>    3. Re: Quesitons about make_spellcheck_suggest.pl (Jesse Weaver)
>    4. Re: Quesitons about make_spellcheck_suggest.pl (Brendan Gallagher)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 3 Sep 2008 10:11:46 +0530
> From: "Zahir Husain Mohamed Ismail" <shammyac at gmail.com>
> Subject: [Koha] migrating winisis data into koha
> To: koha at lists.katipo.co.nz
> Cc: venkat_222002 at yahoo.co.in
> Message-ID:
> 	<ec9076c00809022141j7d73da5anf94290dc79c830e9 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Dear friends
>
> I received ur mail thanks a lot
>
> Rehamn i have been find ur solution i mean
>
> C:\usr\koha228\scripts\misc\migration_tools>perl
> bulkmarcimport.pl -
>
> but how to import my *finaldata.mrc* in to this folder
>
> its i can't understand please help me step by step its grate help for me
> and
> my institution
>
> i have been import my (*finaldata.mrc*)  Koha Reservior through the web
> interface.
>
> but its not import by this way and i received following massage
>
> *Import results :*
>
>    *300 imported records*
>
>    *0 not imported because already in DB*
>
>    *0 not imported because already in farm*
>
>    *0 not imported because they seems not to be MARC format (or ISBN/ISSN
>    missing) !*
>
>    *300 records parsed*
>
>    *Back* <http://intranet/cgi-bin/koha/admin-home.pl>* *
>
>    *therefore please help me how to import tis file *
>
> please reply me
>
>
> --
> <><><><><><><><><><><><><><><><><><><><><><><><>
> "Trust in God. Always !"
> (?`?.???) Always
> `?.?(?`?.???) Keep
> (?`?.???)?.?? Smiling!
> `?.?.??
>
> M.I.Zahir Hussain
> Library Assiatant
> Science Library
> Faculty of Applied Sciences
> South Eastern University of Sri Lanka
> University Park
> Sammanthurai # 32200
> T.P. Office : 067 2260717
> Home        : 067 2261283
> Mobile       : 077 3305920
> e-mail        : shammyac at gmail.com
>                  : shammyac at seu.ac.lk
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:http://lists.katipo.co.nz/pipermail/koha/attachments/20080903/c585f589/attachment-0001.htm
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 3 Sep 2008 14:25:59 -0400
> From: Brendan Gallagher <gallabr at biblio.org>
> Subject: [Koha] Quesitons about make_spellcheck_suggest.pl
> To: Koha Mailing List <koha at lists.katipo.co.nz>
> Cc: Amy Terlaga <terlaga at biblio.org>
> Message-ID: <F4D6FA5C-1309-4462-A0D9-C60C018D0111 at biblio.org>
> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
>
> Hi All -
>
> I've been snooping around in the make_spellcheck_suggest.pl perl
> script and I've developed a few questions.
>
> Looks like the script was originally written for Koha 2.4 CVS and
> hasn't quite been updated yet.
> I've been working my way through updating the script (I'm on perl 5.10
>
> and koha 3.1).
>
> Ok, my question is (or if someone has a better recommendation of a
> different path I should be chasing or working towards developing)
>
> Could someone lead me to the new mysql database tables for marc_word
> (or another equivalent) and correct me if I am wrong but I am equating
> "marc_subfield_table" with the newer mysql table
> marc_subfield_structure (plus i need to change subfieldvalue to either
> tagfield or tagsubfield).  Below is the current part of the script
> that I am referencing,
> "
> my $query_words = "SELECT DISTINCT word, COUNT(word) FROM marc_word";
> my $query_marc_subfields = "SELECT DISTINCT subfieldvalue,
> COUNT(subfieldvalue) FROM marc_subfield_table";
> my $query_titles = "SELECT DISTINCT title, COUNT(title) FROM biblio
> GROUP BY title";
> my $query_authors = "SELECT DISTINCT author, COUNT(author) FROM biblio
> GROUP BY author";
> "
>
> I do have the fuzzy searching set for my opac --> but I am just
> looking a little bit more (and some of my searches dealing with these
> "spellcheck" suggestions are working - you can see that I have got it
>
> to populate some information in mysql database).
>
> Here is a copy of the message I get when executing this script.  and I
> want to get ride of the "excute failed" -parts.
>
> Step 1 of 5: Checking to make sure suggest tables exist
> Use of uninitialized value $_ in pattern match (m//) at
> make_spellcheck_suggest.pl line 99.
> All tables present ... moving along
> Step 2 of 5: Deleting old data
> Step 3 of 5: Creating non-distinct table from various Koha tables
> Finished building marc_word list
> Adding marc_word entries with the following tagsubfields:020a, 100a,
> 110a, 130a, 240a, 245a, 245b, 245c, 245p, 246a, 246b, 440a, 440p,
> 505t, 511a, 534a, 600a, 610a, 611a, 630a, 650a, 651a, 700a, 710a,
> 730a, 740a, 800a, 830a,
> DBD::mysql::st execute failed: Unknown column 'tagsubfield' in
> 'where
> clause' at make_spellcheck_suggest.pl line 173.
> DBD::mysql::st fetchrow_array failed: fetch() without execute() at
> make_spellcheck_suggest.pl line 179.
> 0 more records added...
> Finished building marc_subfield_table list
> Adding marc_subfield_table entries with the following tags and
> subfields:020, a, 100, a, 110, a, 130, a, 240, a, 245, a, 245, b, 245,
> c, 245, p, 246, a, 246, b, 440, a, 440, p, 505, t, 511, a, 534, a,
> 600, a, 610, a, 611, a, 630, a, 650, a, 651, a, 700, a, 710, a, 730,
> a, 740, a, 800, a, 830, a,
> DBD::mysql::st execute failed: Table 'koha.marc_subfield_table'
> doesn't exist at make_spellcheck_suggest.pl line 173.
> DBD::mysql::st fetchrow_array failed: fetch() without execute() at
> make_spellcheck_suggest.pl line 179.
> 0 more records added...
> 57708 more records added...
> 83598 more records added...
> Step 4 of 5: Deleting old distinct entries
> Step 5 of 5: Creating distinct spellcheck table out of non-distinct
> table
> Finished: total distinct items added to spellcheck: 81520
>
>
> Thanks,
>
> +++++++++++++++++++++++++++++++++++++++++++
> Brendan A. Gallagher
> Software Services Coordinator
> Bibliomation, INC.
> Middlebury, CT 06516http://www.biblio.org
> (203)577-4070 x119
> +++++++++++++++++++++++++++++++++++++++++++
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 3 Sep 2008 12:44:27 -0600
> From: "Jesse Weaver" <jesse.weaver at liblime.com>
> Subject: Re: [Koha] Quesitons about make_spellcheck_suggest.pl
> To: "Brendan Gallagher" <gallabr at biblio.org>
> Cc: Koha Mailing List <koha at lists.katipo.co.nz>,	Amy Terlaga
> 	<terlaga at biblio.org>
> Message-ID:
> 	<6bd6de210809031144t68efd2a2mfc20b1edbfa14468 at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Wed, Sep 3, 2008 at 12:25 PM, Brendan Gallagher
> <gallabr at biblio.org>wrote:
>
> > Hi All -
> >
> > I've been snooping around in the make_spellcheck_suggest.pl perl
> > script and I've developed a few questions.
> >
> > Looks like the script was originally written for Koha 2.4 CVS and
> > hasn't quite been updated yet.
> > I've been working my way through updating the script (I'm on perl
> 5.10
> > and koha 3.1).
> >
> > Ok, my question is (or if someone has a better recommendation of a
> > different path I should be chasing or working towards developing)
> >
> > Could someone lead me to the new mysql database tables for marc_word
> > (or another equivalent) and correct me if I am wrong but I am equating
> > "marc_subfield_table" with the newer mysql table
> > marc_subfield_structure (plus i need to change subfieldvalue to either
> > tagfield or tagsubfield).  Below is the current part of the script
> > that I am referencing,
>
>
> marc_subfield_structure is present in both versions, and is different from
> _table. It holds framework information (description of MARC subfields, and
> what they mean, like the title or author), rather than the values of those
> fields for any given record.
>
>
> >
> > "
> > my $query_words = "SELECT DISTINCT word, COUNT(word) FROM
> marc_word";
> > my $query_marc_subfields = "SELECT DISTINCT subfieldvalue,
> > COUNT(subfieldvalue) FROM marc_subfield_table";
> > my $query_titles = "SELECT DISTINCT title, COUNT(title) FROM biblio
> > GROUP BY title";
> > my $query_authors = "SELECT DISTINCT author, COUNT(author) FROM
> biblio
> > GROUP BY author";
> > "
> >
> > I do have the fuzzy searching set for my opac --> but I am just
> > looking a little bit more (and some of my searches dealing with these
> > "spellcheck" suggestions are working - you can see that I have
> got it
> > to populate some information in mysql database).
> >
> > Here is a copy of the message I get when executing this script.  and I
> > want to get ride of the "excute failed" -parts.
> >
> > Step 1 of 5: Checking to make sure suggest tables exist
> > Use of uninitialized value $_ in pattern match (m//) at
> > make_spellcheck_suggest.pl line 99.
> > All tables present ... moving along
> > Step 2 of 5: Deleting old data
> > Step 3 of 5: Creating non-distinct table from various Koha tables
> > Finished building marc_word list
> > Adding marc_word entries with the following tagsubfields:020a, 100a,
> > 110a, 130a, 240a, 245a, 245b, 245c, 245p, 246a, 246b, 440a, 440p,
> > 505t, 511a, 534a, 600a, 610a, 611a, 630a, 650a, 651a, 700a, 710a,
> > 730a, 740a, 800a, 830a,
> > DBD::mysql::st execute failed: Unknown column 'tagsubfield' in
> 'where
> > clause' at make_spellcheck_suggest.pl line 173.
> > DBD::mysql::st fetchrow_array failed: fetch() without execute() at
> > make_spellcheck_suggest.pl line 179.
> > 0 more records added...
> > Finished building marc_subfield_table list
> > Adding marc_subfield_table entries with the following tags and
> > subfields:020, a, 100, a, 110, a, 130, a, 240, a, 245, a, 245, b, 245,
> > c, 245, p, 246, a, 246, b, 440, a, 440, p, 505, t, 511, a, 534, a,
> > 600, a, 610, a, 611, a, 630, a, 650, a, 651, a, 700, a, 710, a, 730,
> > a, 740, a, 800, a, 830, a,
> > DBD::mysql::st execute failed: Table 'koha.marc_subfield_table'
> > doesn't exist at make_spellcheck_suggest.pl line 173.
> > DBD::mysql::st fetchrow_array failed: fetch() without execute() at
> > make_spellcheck_suggest.pl line 179.
> > 0 more records added...
> > 57708 more records added...
> > 83598 more records added...
> > Step 4 of 5: Deleting old distinct entries
> > Step 5 of 5: Creating distinct spellcheck table out of non-distinct
> > table
> > Finished: total distinct items added to spellcheck: 81520
> >
>
> Koha 3.0's new database schema does make this a bit harder; the script
> would
> have to parse the record from the biblioitems.marcxml or biblioitems.marc
> column, then find the words within that to add to the relevant tables.
>
>
> >
> >
> > Thanks,
> >
> > +++++++++++++++++++++++++++++++++++++++++++
> > Brendan A. Gallagher
> > Software Services Coordinator
> > Bibliomation, INC.
> > Middlebury, CT 06516
> > http://www.biblio.org
> > (203)577-4070 x119
> > +++++++++++++++++++++++++++++++++++++++++++
> >
> >
> --
> Jesse Weaver
> Software Developer, LibLime
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:http://lists.katipo.co.nz/pipermail/koha/attachments/20080903/9b394fdf/attachment-0001.htm
>
>
> ------------------------------
>
> Message: 4
> Date: Wed, 3 Sep 2008 14:47:34 -0400
> From: Brendan Gallagher <gallabr at biblio.org>
> Subject: Re: [Koha] Quesitons about make_spellcheck_suggest.pl
> To: "Jesse Weaver" <jesse.weaver at liblime.com>
> Cc: Koha Mailing List <koha at lists.katipo.co.nz>,	Amy Terlaga
> 	<terlaga at biblio.org>
> Message-ID: <B9F89948-FD35-4FB4-8C78-4D63ED69B130 at biblio.org>
> Content-Type: text/plain; charset="us-ascii"
>
> Thanks for the lead Jesse --
>
> I'll continue to mess around with these and see what I can develop.
>
> -Brendan
>
> On Sep 3, 2008, at 2:44 PM, Jesse Weaver wrote:
>
> > On Wed, Sep 3, 2008 at 12:25 PM, Brendan Gallagher
> > <gallabr at biblio.org> wrote:
> > Hi All -
> >
> > I've been snooping around in the make_spellcheck_suggest.pl perl
> > script and I've developed a few questions.
> >
> > Looks like the script was originally written for Koha 2.4 CVS and
> > hasn't quite been updated yet.
> > I've been working my way through updating the script (I'm on perl
> 5.10
> > and koha 3.1).
> >
> > Ok, my question is (or if someone has a better recommendation of a
> > different path I should be chasing or working towards developing)
> >
> > Could someone lead me to the new mysql database tables for marc_word
> > (or another equivalent) and correct me if I am wrong but I am equating
> > "marc_subfield_table" with the newer mysql table
> > marc_subfield_structure (plus i need to change subfieldvalue to either
> > tagfield or tagsubfield).  Below is the current part of the script
> > that I am referencing,
> >
> > marc_subfield_structure is present in both versions, and is
> > different from _table. It holds framework information (description
> > of MARC subfields, and what they mean, like the title or author),
> > rather than the values of those fields for any given record.
> >
> >
> > "
> > my $query_words = "SELECT DISTINCT word, COUNT(word) FROM
> marc_word";
> > my $query_marc_subfields = "SELECT DISTINCT subfieldvalue,
> > COUNT(subfieldvalue) FROM marc_subfield_table";
> > my $query_titles = "SELECT DISTINCT title, COUNT(title) FROM biblio
> > GROUP BY title";
> > my $query_authors = "SELECT DISTINCT author, COUNT(author) FROM
> biblio
> > GROUP BY author";
> > "
> >
> > I do have the fuzzy searching set for my opac --> but I am just
> > looking a little bit more (and some of my searches dealing with these
> > "spellcheck" suggestions are working - you can see that I have
> got it
> > to populate some information in mysql database).
> >
> > Here is a copy of the message I get when executing this script.  and I
> > want to get ride of the "excute failed" -parts.
> >
> > Step 1 of 5: Checking to make sure suggest tables exist
> > Use of uninitialized value $_ in pattern match (m//) at
> > make_spellcheck_suggest.pl line 99.
> > All tables present ... moving along
> > Step 2 of 5: Deleting old data
> > Step 3 of 5: Creating non-distinct table from various Koha tables
> > Finished building marc_word list
> > Adding marc_word entries with the following tagsubfields:020a, 100a,
> > 110a, 130a, 240a, 245a, 245b, 245c, 245p, 246a, 246b, 440a, 440p,
> > 505t, 511a, 534a, 600a, 610a, 611a, 630a, 650a, 651a, 700a, 710a,
> > 730a, 740a, 800a, 830a,
> > DBD::mysql::st execute failed: Unknown column 'tagsubfield' in
> 'where
> > clause' at make_spellcheck_suggest.pl line 173.
> > DBD::mysql::st fetchrow_array failed: fetch() without execute() at
> > make_spellcheck_suggest.pl line 179.
> > 0 more records added...
> > Finished building marc_subfield_table list
> > Adding marc_subfield_table entries with the following tags and
> > subfields:020, a, 100, a, 110, a, 130, a, 240, a, 245, a, 245, b, 245,
> > c, 245, p, 246, a, 246, b, 440, a, 440, p, 505, t, 511, a, 534, a,
> > 600, a, 610, a, 611, a, 630, a, 650, a, 651, a, 700, a, 710, a, 730,
> > a, 740, a, 800, a, 830, a,
> > DBD::mysql::st execute failed: Table 'koha.marc_subfield_table'
> > doesn't exist at make_spellcheck_suggest.pl line 173.
> > DBD::mysql::st fetchrow_array failed: fetch() without execute() at
> > make_spellcheck_suggest.pl line 179.
> > 0 more records added...
> > 57708 more records added...
> > 83598 more records added...
> > Step 4 of 5: Deleting old distinct entries
> > Step 5 of 5: Creating distinct spellcheck table out of non-distinct
> > table
> > Finished: total distinct items added to spellcheck: 81520
> >
> > Koha 3.0's new database schema does make this a bit harder; the
> > script would have to parse the record from the biblioitems.marcxml
> > or biblioitems.marc column, then find the words within that to add
> > to the relevant tables.
> >
> >
> >
> > Thanks,
> >
> > +++++++++++++++++++++++++++++++++++++++++++
> > Brendan A. Gallagher
> > Software Services Coordinator
> > Bibliomation, INC.
> > Middlebury, CT 06516
> > http://www.biblio.org
> > (203)577-4070 x119
> > +++++++++++++++++++++++++++++++++++++++++++
> >
> >
> > --
> > Jesse Weaver
> > Software Developer, LibLime
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:http://lists.katipo.co.nz/pipermail/koha/attachments/20080903/47dca8fd/attachment.htm
>
>
> ------------------------------
>
> _______________________________________________
> Koha mailing listKoha at lists.katipo.co.nzhttp://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> End of Koha Digest, Vol 35, Issue 8
> ***********************************
>
>
> ------------------------------
> Connect with friends all over the world. Get Yahoo! India Messenger.<http://in.rd.yahoo.com/tagline_messenger_1/*http://in.messenger.yahoo.com/?wm=n/>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20080904/0108701c/attachment-0001.htm

More information about the Koha mailing list