Bug 2357 - Tools > Export bibs/holdings doesn't export bib records without items
Summary: Tools > Export bibs/holdings doesn't export bib records without items
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Tools (show other bugs)
Version: rel_3_0
Hardware: All All
: P3 normal (vote)
Assignee: Galen Charlton
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-16 08:38 UTC by Frédéric Demians
Modified: 2016-11-14 09:22 UTC (History)
0 users

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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