[OPEN-ILS-GENERAL] MFHD import problem with marcsre.pl etc.

[Repke de Vries]

Following Dan Scott's README instructions [1] (hi Dan) we are importing a Bibliographic + corresponding MFHD records example (attached).

Step for MFHD records (in this case: 2) has a problem:




Where did we go wrong ?

Thanks, Repke, IISG

Steps for bibliographic record import and metarecord map generation went fine (as far as I can see). - marc2sre.pl --startid 004 --password open-ils GramsciMFHDPart.mrc separately works OK - piping the marc2sre result to pg_loader.pl -or sre > GramsciMfhd21.sql produces the SQL table; there are two \N for each record and changed the last one into 4 (the numeric ID of our [test] BR1) in both cases; result attached - psql -d evergreen1 -h localhost -U evergreen -h localhost -f GramsciMfhd21.sql has a problem: duplicate key value violates unique constraint "record_entry_pkey" ; full message: [2] [1] http://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/tests/ datasets/README

[2]

Password for user evergreen:
SET
BEGIN

r...@devevergreen:~/SerialsImport$ psql -d evergreen1 -h localhost -U evergreen -h localhost -f GramsciMfhd21.sql psql:GramsciMfhd21.sql:8: ERROR: duplicate key value violates unique constraint "record_entry_pkey" CONTEXT: COPY record_entry, line 1: "t 11081733 now 1 f now 1 4 IMPORT-1266952292.02193 <record xmlns:xsi="http://www.w3.org/2001/XMLS..."; psql:GramsciMfhd21.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block

ROLLBACK
r...@devevergreen:~/SerialsImport$

GramsciBibPart.mrc
Description: Binary data

GramsciMFHDPart.mrc
Description: Binary data

GramsciMfhd21.sql
Description: Binary data