Messrs. Vahau, Laurent, and Hedges, Thanks again for your assistance with my bulkmarcimport.pl and @INC issue. With your help, I was able to import a bunch of MARC21 records using bulkmarcimport.pl. Unfortunately, I also saw a large number of error messages that make me suspect that a large number of the records were not imported. Most of the error messages read like this: "DBD::mysql::db do failed: Access denied for user: 'myuserid@localhost' to database 'libcat' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 331." A few of the error messages were exactly the same as the one above, except that the Biblio.pm line cited was 426. The last line of bulkmarcimport.pl's screen output was: "1572 MARC record done in 731.838590145111 seconds." When I searched for some of the records using either the OPAC user interface or the librarian interface, a bunch of them clearly had been imported. I read the Biblio.pm code pertaining to the code lines cited, but I'm not yet familiar enough with the Koha code to figure out what went wrong. I also wasn't able to figure out a way to determine how many records there now are in the OPAC. ("*" apparently cannot be used to search for all possible values in a field.) Can you tell me what the error messages cited above were trying to tell me? Does "1572 MARC record done in 731.838590145111 seconds" mean that 1,572 records actually were imported into the OPAC database? Is there a way I can quickly double check how many records there are in the OPAC? Thanks in advance for your assistance. Best regards, Andro P. Gagné P.O. Box 715 Canandaigua, NY 14424
Hi, My guess is that you do not have permission to access the libcat database. Koha uses Mysql so grant the appropriate permission to the libcat database. One way to determine how many records you have in the database is to invoke Mysql in the CLI and use the select statement like so: use libcat; (or whatever the name of the database is) select * from <tablename>; The number of rows reported will be the number of records. Alfred, Andro Gagne wrote:
Messrs. Vahau, Laurent, and Hedges,
Thanks again for your assistance with my bulkmarcimport.pl and @INC issue. With your help, I was able to import a bunch of MARC21 records using bulkmarcimport.pl. Unfortunately, I also saw a large number of error messages that make me suspect that a large number of the records were not imported. Most of the error messages read like this:
"DBD::mysql::db do failed: Access denied for user: 'myuserid@localhost' to database 'libcat' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 331."
A few of the error messages were exactly the same as the one above, except that the Biblio.pm line cited was 426. The last line of bulkmarcimport.pl's screen output was: "1572 MARC record done in 731.838590145111 seconds."
When I searched for some of the records using either the OPAC user interface or the librarian interface, a bunch of them clearly had been imported. I read the Biblio.pm code pertaining to the code lines cited, but I'm not yet familiar enough with the Koha code to figure out what went wrong. I also wasn't able to figure out a way to determine how many records there now are in the OPAC. ("*" apparently cannot be used to search for all possible values in a field.) Can you tell me what the error messages cited above were trying to tell me? Does "1572 MARC record done in 731.838590145111 seconds" mean that 1,572 records actually were imported into the OPAC database? Is there a way I can quickly double check how many records there are in the OPAC?
Thanks in advance for your assistance.
Best regards,
Andro P. Gagné P.O. Box 715 Canandaigua, NY 14424
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Andro, I've forgotten what Koha version you are using. The Biblio.pm line numbers you list don't match my (2.2.4) Biblio.pm. In any case, I would guess that you have some MARC records in the file that have errors. There is another script in the intranet/scripts/misc directory called dumpmarc.pl that will simply list out your MARC file. But with 1500+ records, it wouldn't be much fun looking for stray errors! You could also use this script to find the title of the last record in the file. Do a search on that title and the Biblionumber on the screen should equal the number of records in your catalog -- assuming you haven't yet been doing any deleting of records. Stephen Andro Gagne said:
Messrs. Vahau, Laurent, and Hedges,
Thanks again for your assistance with my bulkmarcimport.pl and @INC issue. With your help, I was able to import a bunch of MARC21 records using bulkmarcimport.pl. Unfortunately, I also saw a large number of error messages that make me suspect that a large number of the records were not imported. Most of the error messages read like this:
"DBD::mysql::db do failed: Access denied for user: 'myuserid@localhost' to database 'libcat' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 331."
A few of the error messages were exactly the same as the one above, except that the Biblio.pm line cited was 426. The last line of bulkmarcimport.pl's screen output was: "1572 MARC record done in 731.838590145111 seconds."
When I searched for some of the records using either the OPAC user interface or the librarian interface, a bunch of them clearly had been imported. I read the Biblio.pm code pertaining to the code lines cited, but I'm not yet familiar enough with the Koha code to figure out what went wrong. I also wasn't able to figure out a way to determine how many records there now are in the OPAC. ("*" apparently cannot be used to search for all possible values in a field.) Can you tell me what the error messages cited above were trying to tell me? Does "1572 MARC record done in 731.838590145111 seconds" mean that 1,572 records actually were imported into the OPAC database? Is there a way I can quickly double check how many records there are in the OPAC?
Thanks in advance for your assistance.
Best regards,
Andro P. Gagné P.O. Box 715 Canandaigua, NY 14424
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
participants (3)
-
Alfred Vahau -
Andro Gagne -
Stephen Hedges