Bug 7425 - Export Bibliographic Holdings fails if no item records attached
Summary: Export Bibliographic Holdings fails if no item records attached
Status: CLOSED WORKSFORME
Alias: None
Product: Koha
Classification: Unclassified
Component: Tools (show other bugs)
Version: 3.14
Hardware: All All
: P3 normal
Assignee: Galen Charlton
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-01-09 17:45 UTC by Elaine Bradtke
Modified: 2018-12-03 20:04 UTC (History)
4 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Elaine Bradtke 2012-01-09 17:45:14 UTC

    
Comment 1 Elaine Bradtke 2012-01-09 18:01:48 UTC
This also happens in 3.4
Attempted to export a group of biblios in order to batch edit them. Entered a range of biblio numbers.  Selected item type component (components do not have item records attached).
It produces an empty file (no error message).  If I select all item types, it
only exports biblios with item records attached, skipping over the biblios that do not have items attached.

Cannot export MARC records that do not have item records attached, even if the range of biblio numbers is only criteria.

Would it be possible to change the item type criteria so that it looks at  942$c for the item type?

Should it provide an error message if it fails to match anything rather than producing an empty file?
Comment 2 Elaine Bradtke 2014-03-24 17:40:51 UTC
Koha 3.14.03
Further experiences with this problem.
Exporting a subset of the catalog selected by item type produces 0 records (these are item types that do not have item records attached).
Exporting the whole catalogue as MARC, with items attached fails, the resulting file appears to only contain biblios with items.  None of the biblios without items were exported.
If I export the whole catalogue without items attached, then it will export all the records.

Testing the export as XML:
Exporting a subset of records selected by item type still produces 0 records (these are item types that do not have item records attached.

Exporting the whole catalog, with items attached produces the expected number of records.
Comment 3 Elaine Bradtke 2014-03-26 16:40:20 UTC
The value of syspref item-level_itypes is what governs this.  It appears to default to specific item - which then gives the above results.


(Admin > System preferences > Cataloguing)
Comment 4 Elaine Bradtke 2014-03-26 16:41:14 UTC
The value of syspref item-level_itypes is what governs this.  It appears to default to specific item - which then gives the above results.


(Admin > System preferences > Cataloguing)
Comment 5 Hugo Agud 2017-06-22 07:02:23 UTC
Testing on Debian 8 Koha 16.11.08 it doesn't matter the value on item-level_itypes, it nevers export a biblio record if there is not an item attached
Comment 6 Hugo Agud 2017-06-22 08:24:25 UTC
Ok, I have figured out that it doesn't export bibliographic because it looks for 942, but 942 it is a koha field and If your catalogue has imported recordss via z39.50 for example and you do not attach itmems.. koha will never export it..
Comment 7 Hugh Rundle 2017-12-27 06:46:23 UTC
Um, so what is the solution? We need to export records that we are about to delete, and by definition they won't have items attached, so this is a big problem for us. 

Is the only current workaround to ensure all bibs have an item type in the 942?
Comment 8 Katrin Fischer 2017-12-27 06:53:44 UTC
Maybe generating a list of biblionumbers with a report and using this as your base for exporting could work for you? Make sure all branches are unchecked. Using a biblionumber range with branches unchecked also seems to work for me. 

There have been fixes to the export tool since this bug was filed, maybe one of it improved behaviour.
Comment 9 Hugh Rundle 2017-12-27 21:15:13 UTC
Thanks Katrin! This is the key:

"Make sure all branches are unchecked."

Perfectly logical, but I hadn't thought to try it.
Comment 10 Katrin Fischer 2017-12-27 21:16:55 UTC
Glad I could help!

Closing, please reopen if still needed.