Bug 8393

Summary: No physical item for this record for stage marc imported records with items
Product: Koha Reporter: Eugene Espinoza <eugenegf>
Component: MARC Bibliographic record staging/importAssignee: Galen Charlton <gmcharlt>
Status: CLOSED INVALID QA Contact:
Severity: normal    
Priority: P5 - low CC: katrin.fischer, liz, mtj
Version: master   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 8394    

Description Eugene Espinoza 2012-07-09 14:59:34 UTC
After stage marc record import of a record with item (marc field 952 complete), items are not added even after zebra rebuild
Comment 1 Katrin Fischer 2012-07-09 15:42:45 UTC
Can you perhaps copy the feedback you get about the import? The numbers of biblios and items added after staging and importing.
Comment 2 Eugene Espinoza 2012-07-09 16:08:51 UTC
Only one record with one item was stage for marc record import. I just followed the normal stage marc record process. The default for 'Look for matching records in catalog' was used. Check for embbedded data: Yes. How to process items: always add items. After the import and rebuild of the zebra with -z -b -a, when in normal view, the holdings say 'There is no physical item for this record' And when I click on the item view, there are no items. In the edit items, there is/are no records. So, only the (bibliographic) record was imported. By the way this is the MARC data for your perusal:
=LDR  00767nam  22001817a 4500
=003  OSt
=005  20120416054841.0
=008  110530t\\\\\\\\xxu|||||\||||\00|\0\eng\d
=040  \\$cHOR
=100  \\$aWilkinson, Earl K.$9213
=245  \\$a... Sentenced to death"$bthe truth about Englishman Albert Wilson`s sentence and eventual acquittal in the Philippines
=260  \\$aVerlag, Germany$bBook of Dreams$c2000
=300  \\$a287 p.
=650  \\$a Trials (Rape)--Philippines$9214
=650  \\$aWilson, Albert Ernest--Trials, litigation, etc.$9215
=942  \\$2lcc$cBK
=999  \\$c43161$d43161
=952  \\$w2011-10-24$p033073hp$r2011-10-24$40$00$6F__KPM_00041_W55_W54_2000$915302$bLLS$10$o(F) KPM 41 W55 W54 2000$d2002-12-10$70$cGEN$2lcc$g695.00$yBK$aLLS$iMR_02 1177; MD_$kR_; PO_; PD 00668
Comment 3 Katrin Fischer 2012-07-10 07:21:49 UTC
I am sorry, but I have no idea what is going wrong there :(
Comment 4 Mason James 2012-07-16 04:22:58 UTC
(In reply to comment #2)
> Only one record with one item was stage for marc record import. 

can you please attach the problem marc record?
Comment 5 Eugene Espinoza 2012-07-26 02:35:54 UTC
This problem already solve. What I did was to drop the koha database and then import my previous database (koha 3.6). What I did previously was to just overwrite (?) existing original koha database with mysqldump of my backup database. And when I run zebra rebuilds items were showing up. Is there a way that overwriting of original koha mysql database by previous mysqldump won't affect items not showing up?