Thanks Dan. >> Because without --startid, the script needs to connect to the database to find a safe starting ID value for new bibs in the biblio.record_entry database.
Ok - that helps explain one of my scenarios (no authentication errors because not connecting!) >> You need the hypens in --used_tcn_file Yes, must have been oversight in my last usage, b/c I know I had it right in my initial testing. So just confirmed with another test and with "--used_tcn_file" I get no console errors and an empty output file. Will explore this further. Thx, George -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Scott Sent: December 14, 2011 21:36 To: Evergreen Development Discussion List Subject: Re: [OPEN-ILS-DEV] marc2bre.pl usage / errors On Wed, Dec 14, 2011 at 03:06:50PM -0500, Duimovich, George wrote: > Hello, > > While using marc2bre.pl for import: > > This command works, except for errors listed [1] below (uninitialized > value, dup TCN) > > perl marc2bre.pl --db_user <myuser> --db_host localhost --db_pw > <my_pw> --db_name evergreen --startid 8227550 > bibliographic-nrcan.004.mrc > import.bre >From the error, it sounds like you have a 010, 020, or 022 field missing a subfield 'a'. The script should protect against those cases. > I use command history to only edit out the "startid" switch above - > then I run the command below and now get "FATAL: password > authentication failed for user" type errors > > perl marc2bre.pl --db_user <myuser> --db_host localhost --db_pw > <my_pw> --db_name evergreen bibliographic-nrcan.004.mrc > import.bre > > Question: why do I get an authentication error when the authentication params are the same as previous statement (only removed "--startid 8227550" Because without --startid, the script needs to connect to the database to find a safe starting ID value for new bibs in the biblio.record_entry database. > Also, if I attempt to deal with my duplicate TCN value errors by using the "used_tcn_file" option: > > perl marc2bre.pl --db_user <myuser> --db_host localhost --db_pw > <my_pw> --db_name evergreen used_tcn_file tcnvalues --startid 8227550 > bibliographic-nrcan.004.mrc > import.bre > > The result is no errors to screen, and import.bre is written out empty. If I take out the startid option then I get back to authentication error. > > Am I goofing up the syntax somewhere? You need the hypens in --used_tcn_file; otherwise I think marc2bre.pl is trying to read from two files, "used_tcn_file" and "tcnvalues". > Errors 1: > Use of uninitialized value $value in substitution (s///) at /home/opensrf/Evergreen-ILS-2.1.1/Open-ILS/src/extras/import/marc2bre.pl line 391. > 150 29.3359108144772 > !!! TCN is already in use, using TCN (s8227698) derived from System ID. > (followed by more TCN already in use errors) >
