[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).

Steps for bibliographic record import and metarecord map generation  
went fine (as far as I can see).

Step for MFHD records (in this case: 2) has a problem:
- 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]

Where did we go wrong ?

Thanks, Repke, IISG

[1] http://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/tests/ 
datasets/README

[2]
rdv at devevergreen:~/SerialsImport$ psql -d evergreen1 -h localhost -U  
evergreen -h localhost -f GramsciMfhd21.sql
Password for user evergreen:
SET
BEGIN
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
rdv at devevergreen:~/SerialsImport$

-------------- next part --------------
A non-text attachment was scrubbed...
Name: GramsciBibPart.mrc
Type: application/octet-stream
Size: 472 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20100223/83358443/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GramsciMFHDPart.mrc
Type: application/octet-stream
Size: 661 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20100223/83358443/attachment-0001.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GramsciMfhd21.sql
Type: application/octet-stream
Size: 2827 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20100223/83358443/attachment-0002.obj