Hi again! Just an update for future reference regarding our problems with bulkmarc import. MJ Ray kindly suggested us to try the following: "I now think the parameter to -match needs an index name in front of it, with a comma. It then tries to match the tag against it. So http://manual.koha-community.org/3.6/en/kohasearchindexes.html makes me think you actually want -match barcode,999c" Sadly, it did not make any difference, same long error message. See beginning of the message below. (Testdatabase version still 3.6.2 on Debian squeeze). Possible bug?? -------------------------------------------------------------------------- As the koha user: koha@kohatest:~$ export PERL5LIB=/usr/share/koha/lib/ koha@kohatest:~$ export KOHA_CONF=/etc/koha/koha-conf.xml koha@kohatest:~$ koha@kohatest:~$ cd /usr/share/koha/bin/migration_tools koha@kohatest:/usr/share/koha/bin/migration_tools$ perl ./bulkmarcimport.pl -d -match=barcode,999c -commit 1000 -v -file /tmp/newer40_77000.mrc deleting biblios DBD::mysql: b do failed: Cannot delete or update a parent row: a foreign key constraint fails (`koha`.`issues`, CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE) at ./bulkmarcimport.pl line 96. DBD::mysql: b do failed: Cannot delete or update a parent row: a foreign key constraint fails (`koha`.`issues`, CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE) at ./bulkmarcimport.pl line 97. DBD::mysql: b do failed: Cannot delete or update a parent row: a foreign key constraint fails (`koha`.`issues`, CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE) at ./bulkmarcimport.pl line 98. .DBD::mysql::st execute failed: Duplicate entry 'A27112' for key 'itembarcodeidx' at /usr/share/koha/lib/C4/Items.pm line 2105. ERROR in _koha_new_item INSERT INTO items SET -------------------------------------------------------------------------- I also tried out the "Stage marc records for import" under "Tools" to see if that might be a way, but while it was swiftly done to upload the file , when it was asked to "Stage" the records (matched on 952$p) it quickly jumped to 1% and then nothing happened for 20 minutes. And when trying to abort I got a software error message, see below - luckily still on a test database. Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 693. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 33. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 33. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. I think we're going to have to pay someone to take closer look at this - Magnus, beware :) Cheers, //Magdalena ----- Original Message ----- From: "MJ Ray" <mjr@phonecoop.coop> To: koha@lists.katipo.co.nz Sent: Wednesday, 22 February, 2012 8:14:48 PM Subject: Re: [Koha] bulkmarcimport-problems! Magdalena Söderqvist <soderqvist@sipri.org>
koha@kohatest:/usr/share/koha/bin/migration_tools$ perl ./bulkmarcimport.pl -d -match 999c -commit 1000 -v -v -file /root/40_77000_2.mrc deleting biblios DBD::mysql: b do failed: Cannot delete or update a parent row: a foreign key constraint fails (`koha`.`issues`, CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE) at ./bulkmarcimport.pl line 96.
Well, -d deletes the old biblios before importing the file, but the database is refusing because some of them have issued items.
.Use of uninitialized value $recorddata in pattern match (m//) at ./bulkmarcimport.pl line 392, <GEN16> line 1. unable to search the database for duplicates : No query entered at ./bulkmarcimport.pl line 217, <GEN16> line 1.
I got similar errors when trying to use -match earlier today. I thought it was just my mistake, but maybe it's not. Does anyone have an insight into this? I think I'll next get chance to investigate it next Wednesday, which is quite a wait. Hope that informs, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Magdalena Söderqvist Librarian SIPRI Library and Documentation Department STOCKHOLM INTERNATIONAL PEACE RESEARCH INSTITUTE Signalistgatan 9 SE-169 70 Solna, Sweden Telephone: +46 8 655 97 78 Fax: +46 8 655 97 33 Email: soderqvist@sipri.org Internet: www.sipri.org