I have made our catalog of MARC records available for anyone who wants them for testing. The file contains about 22,000 records containing about 53,000 items. It has the holdings in field 856. The records are pretty clean but it is the actual catalog of our collection, so it is not perfect. I just finished doing some clean-up on the catalog. Using MarcEdit and MARC RTP I was able to spot incorrect or obsolete fields and subfields and change them. I've replaced the file in our FTP site with the cleaned-up version. There are readme files there that explain the file in greater detail. For anyone interested the URL is: ftp://www.lpi.usra.edu/pub/outgoing/bigwood Sincerely, David Bigwood bigwood@lpi.usra.edu Lunar & Planetary Institute http://www.lpi.usra.edu/library/whats_new.shtml Cataloging News http://www.catalogablog.blogspot.com
Bigwood, David wrote:
I have made our catalog of MARC records available for anyone who wants them for testing. The file contains about 22,000 records containing about 53,000 items.
Thanks for that. I used MarcEdit to dump to a text file and can see each fields and what it contains very easily now. I have also used the web based import tool to import your lpi.mrc into the "Breeding Farm". It took a while. I can now see that there are lots of records in the marc_breeding table. I now have the same problem as when I imported the single record that Steven Baljkas sent me which I imported; it's in the breeding farm but how to move them all to the catalog? I can do it for a single entry if I go to "Add biblio" and enter an ISBN number e.g. Here is what I have learned: This line in Davids marc records is an ISBN =020 \\$a0821204505 If I search for this in 'Add biblio' up comes the book on 'The scanning electron microscope' in the breeding farm. I can add it and it shows the marc fields, which I can edit, before adding it to the catalog. But how do I get the thousands of entries from the breeding farm into the catalog? Mike -- Michael Lake Chemistry, Materials & Forensic Science, UTS Ph: 9514 1725 Fx: 9514 1460 -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.
On Fri, Nov 05, 2004 at 02:30:07PM +1100, Michael Lake said:
If I search for this in 'Add biblio' up comes the book on 'The scanning electron microscope' in the breeding farm. I can add it and it shows the marc fields, which I can edit, before adding it to the catalog.
But how do I get the thousands of entries from the breeding farm into the catalog?
Hi ya The short answer is you dont :) The breeding farm (which is soon to be renamed though I forget to what) is a place that stores catalog records for you to use when cataloguing. It sounds to me like you want to do a bulk population of your catalogue, to do this, the bulkmarcimport.pl script should be used. It lives in the misc/ directory. The idea with the breeding farm is you can populate it with marc data and as you acquisition new items, you can use the data in the breeding farm as a starting point. Its not a way to quickly populate a catalogue. I hope this is some help Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Chris Cormack wrote:
It sounds to me like you want to do a bulk population of your catalogue, to do this, the bulkmarcimport.pl script should be used. It lives in the misc/ directory.
Okies. perl -I /home/rsnsw/koha/intranet/modules bulkmarcimport.pl -file lpi.mrc -v 1 I get access errors like my previous posts. If KOHA_CONF is not set in the bash shell env I get this: DBD::mysql::db Access denied for user koha_admin@localhost to database koha at Biblio.pm line 289 If I set KOHA_CONF using 'export KOHA_CONF=/etc' I get this: DBI Connect (':', '') failed. Access denied for user mike@localhost (using password NO) at Contex.pm line 368. mike is my login name on the shell koha_admin is the admin user when I setup Koha. It's similar to the problem I get when I tried the marc export from command line. Authentication with mysql. Mike -- Michael Lake Chemistry, Materials & Forensic Science, UTS Ph: 9514 1725 Fx: 9514 1460 -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.
On 2004-11-05 04:24:06 +0000 Michael Lake <Mike.Lake@uts.edu.au> wrote:
If I set KOHA_CONF using 'export KOHA_CONF=/etc' I get this:
You definitely need to set KOHA_CONF to the location of the koha.conf file, not just the directory. This error is closer to working:
DBD::mysql:b Access denied for user koha_admin@localhost to database koha at Biblio.pm line 289
Can you connect with a mysql client as the koha_admin user? (Previously, you wrote that you can access it as mikel.) If not, do the mysql.user and mysql.db entries for that user look correct to you? -- MJR/slef My Opinion Only and not of any group I know Creative copyleft computing - http://www.ttllp.co.uk/ Unsolicited attachments to the pipex address deleted Will HLF fund tree-killings? http://www.thewalks.co.uk/
Dear all, I am trying as well to import the data kindly offered by David Bigwood. I would like to keep on evaluating koha before migrating my data from CDS/ISIS. Unfortunately I have the following message: [root@koha misc]# pwd /usr/local/koha/intranet/scripts/misc [root@koha misc]# ./bulkmarcimport.pl -file /root/lpi.mrc -n 1 Can't locate C4/Context.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at ./bulkmarcimport.pl line 10. BEGIN failed--compilation aborted at ./bulkmarcimport.pl line 10. I am new to PERL, so it's certainly a very basic trouble. I guess I miss a couple of libraries because the INC variable is not properly defined. But the question is: how can I define it properly? Thanks for any advice. Pierre __________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com
Hi Pierre, Try running: [root@koha misc]# perl -I /path/to/modules bulkmarcimport.pl -file ...etc where /path/to/modules is the path to your Koha modules directory--probably /usr/local/koha/intranet/modules (the directory with the C4 directory in it). Let us know if it doesn't work. Good luck! Joshua On Fri, Nov 05, 2004 at 10:02:13AM -0800, pierre pierre wrote:
Dear all,
I am trying as well to import the data kindly offered by David Bigwood. I would like to keep on evaluating koha before migrating my data from CDS/ISIS.
Unfortunately I have the following message:
[root@koha misc]# pwd /usr/local/koha/intranet/scripts/misc [root@koha misc]# ./bulkmarcimport.pl -file /root/lpi.mrc -n 1 Can't locate C4/Context.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at ./bulkmarcimport.pl line 10. BEGIN failed--compilation aborted at ./bulkmarcimport.pl line 10.
I am new to PERL, so it's certainly a very basic trouble. I guess I miss a couple of libraries because the INC variable is not properly defined. But the question is: how can I define it properly?
Thanks for any advice.
Pierre
__________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Dear Joshua, Thanks for your help. Indeed after a little perl -MCPAN -e 'install "Time::HiRes"' (to avoid the �Can't locate Time/HiRes.pm in @INC� message) the sript starts its process. But then I have a similar error message to the one Mike has: DBD::mysql::db do failed: Access denied for user 'kohaadmin'@'localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 330. With MySQL Query Browser I do not have any problem to connect with the kohaadmin user using the password I defined during the installation of Koha. Well, I'll try to have a look at the script to understand what it does. Thanks again, Pierre --- Joshua Ferraro <jmf@kados.org> wrote:
Hi Pierre,
Try running: [root@koha misc]# perl -I /path/to/modules bulkmarcimport.pl -file ...etc
where /path/to/modules is the path to your Koha modules directory--probably /usr/local/koha/intranet/modules (the directory with the C4 directory in it).
Let us know if it doesn't work. Good luck!
Joshua
On Fri, Nov 05, 2004 at 10:02:13AM -0800, pierre pierre wrote:
Dear all,
I am trying as well to import the data kindly offered by David Bigwood. I would like to keep on evaluating koha before migrating my data from CDS/ISIS.
Unfortunately I have the following message:
[root@koha misc]# pwd /usr/local/koha/intranet/scripts/misc [root@koha misc]# ./bulkmarcimport.pl -file /root/lpi.mrc -n 1 Can't locate C4/Context.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at ./bulkmarcimport.pl line 10. BEGIN failed--compilation aborted at ./bulkmarcimport.pl line 10.
I am new to PERL, so it's certainly a very basic trouble. I guess I miss a couple of libraries because the INC variable is not properly defined. But the question is: how can I define it properly?
Thanks for any advice.
Pierre
__________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
__________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com
Hi Pierre, What version of Koha are you running? That error looks to me (at first glance) like a potential bug in the module's method for building the user@host string. Let me know what version of the Biblio.pm module you're running and I'll check it out. Anyone else have any other ideas? Joshua On Fri, Nov 05, 2004 at 11:43:02AM -0800, pierre pierre wrote:
Dear Joshua,
Thanks for your help. Indeed after a little perl -MCPAN -e 'install "Time::HiRes"' (to avoid the ?Can't locate Time/HiRes.pm in @INC? message) the sript starts its process.
But then I have a similar error message to the one Mike has: DBD::mysql::db do failed: Access denied for user 'kohaadmin'@'localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 330.
With MySQL Query Browser I do not have any problem to connect with the kohaadmin user using the password I defined during the installation of Koha.
Well, I'll try to have a look at the script to understand what it does.
Thanks again,
Pierre
--- Joshua Ferraro <jmf@kados.org> wrote:
Hi Pierre,
Try running: [root@koha misc]# perl -I /path/to/modules bulkmarcimport.pl -file ...etc
where /path/to/modules is the path to your Koha modules directory--probably /usr/local/koha/intranet/modules (the directory with the C4 directory in it).
Let us know if it doesn't work. Good luck!
Joshua
On Fri, Nov 05, 2004 at 10:02:13AM -0800, pierre pierre wrote:
Dear all,
I am trying as well to import the data kindly offered by David Bigwood. I would like to keep on evaluating koha before migrating my data from CDS/ISIS.
Unfortunately I have the following message:
[root@koha misc]# pwd /usr/local/koha/intranet/scripts/misc [root@koha misc]# ./bulkmarcimport.pl -file /root/lpi.mrc -n 1 Can't locate C4/Context.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at ./bulkmarcimport.pl line 10. BEGIN failed--compilation aborted at ./bulkmarcimport.pl line 10.
I am new to PERL, so it's certainly a very basic trouble. I guess I miss a couple of libraries because the INC variable is not properly defined. But the question is: how can I define it properly?
Thanks for any advice.
Pierre
__________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
__________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi all This is a follow up on errors in bulkmarcimport. Im still getting errors with the DBI connect. As a test i'm using the marc file supplied by Steven Baljkas, emcs2.mrc Command line is this: misc$ perl -I /home/rsnsw/koha/intranet/modules bulkmarcimport.pl -file emcs2.mrc Output is this: DBD::mysql::db do failed: Access denied for user: 'koha_admin@localhost' to database 'koha' at /home/rsnsw/koha/intranet/modules/C4/Biblio.pm line 289. DBD::mysql::db do failed: Access denied for user: 'koha_admin@localhost' to database 'koha' at /home/rsnsw/koha/intranet/modules/C4/Biblio.pm line 371. DBD::mysql::db do failed: Access denied for user: 'koha_admin@localhost' to database 'koha' at /home/rsnsw/koha/intranet/modules/C4/Biblio.pm line 371. 1 MARC record done in 0.469326972961426 secondsmisc$ Note that there are 3 error messages for this 1 record. Using David Bigwoods data there are lots of the same above errors. I have exported KOHA_CONF=/etc/koha.conf and koha.conf is readable by ugo so bulkmarcimport can read it OK. The user 'koha_admin' is in koha.conf and the password, lets say its 'secret'. I can access the mysql koha database like this OK mysql -u koha_admin -psecret koha mysql> and in the mysql user table there is the entry user=koha_admin and Host=localhost so bulkmarcimport should have no problems connecting to the koha database ! There is no version number in the bulkmarcimport script to report. Im using the one from the koha 2.0.1 tarball. Mike Joshua Ferraro wrote:
Hi Pierre, What version of Koha are you running? That error looks to me (at first glance) like a potential bug in the module's method for building the user@host string. Let me know what version of the Biblio.pm module you're running and I'll check it out. Anyone else have any other ideas?
On Fri, Nov 05, 2004 at 11:43:02AM -0800, pierre pierre wrote:
Dear Joshua,
Thanks for your help. Indeed after a little perl -MCPAN -e 'install "Time::HiRes"' (to avoid the ?Can't locate Time/HiRes.pm in @INC? message) the sript starts its process.
But then I have a similar error message to the one Mike has: DBD::mysql::db do failed: Access denied for user 'kohaadmin'@'localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 330.
With MySQL Query Browser I do not have any problem to connect with the kohaadmin user using the password I defined during the installation of Koha.
-- Michael Lake Chemistry, Materials & Forensic Science, UTS Ph: 9514 1725 Fx: 9514 1460 -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.
participants (7)
-
Bigwood, David -
Chris Cormack -
Joshua Ferraro -
Joshua Ferraro -
Michael Lake -
MJ Ray -
pierre pierre