Bug 2357

Summary: Tools > Export bibs/holdings doesn't export bib records without items
Product: Koha Reporter: Frédéric Demians <f.demians>
Component: ToolsAssignee: Galen Charlton <gmcharlt>
Status: CLOSED FIXED QA Contact:
Severity: normal    
Priority: P3    
Version: rel_3_0   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17622
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Chris Cormack 2010-05-21 00:50:15 UTC


---- Reported by frederic@tamil.fr 2008-07-16 08:38:14 ----

/tools/export.pl script skips to export biblio records which have no items.

So it isn't possible to use this script to export the entire MARC DB
by leaving blank all options.

The issue come from this SQL statement:

  SELECT DISTINCT biblioitems.biblionumber
  FROM biblioitems,items
  WHERE biblioitems.biblionumber=items.biblionumber

I propose to test script parameters and if all of them are empty to
do this SQL statement :

  SELECT biblioitems.biblionumber FROM biblioitems

I would also modify above branch references. 

Does it make sens? Do I forget something. 
Can someone (Galen?) agree with that?



---- Additional Comments From jmf@liblime.com 2008-07-16 16:33:04 ----

Just pushed this patch, thanks Frederic!



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 00:50 UTC  ---

This bug was previously known as _bug_ 2357 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=2357

Actual time not defined. Setting to 0.0