Bug 3308 - Exporting statistics reports yields ZZempty field values
Summary: Exporting statistics reports yields ZZempty field values
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: rel_3_0
Hardware: PC All
: P5 - low normal (vote)
Assignee: Galen Charlton
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-06-08 05:10 UTC by Chris Cormack
Modified: 2013-12-05 20:05 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 01:08:57 UTC


---- Reported by maria.laude@liblime.com 2009-06-08 17:10:59 ----

When exporting reports using Statistics Wizards, exporting to .csv displays "ZZempty".  Only appears when exporting, does not appear when displaying report to Koha.

Reports shouldn't print  "ZZemptyint.csv"



---- Additional Comments From rch@liblime.com 2009-06-08 17:27:32 ----



Specifically, csv parsing fails on authorised value-controlled fields  with null values.

Symptom:  the string 'zzEMPTY' appears as row heading in csv output.

To reproduce:
Add or edit an item so that it has a null ccode or shelving location.
circulate it.
Run issues_stats.pl, selecting 
COLUMN: itemtype
ROW:  ccode  ( or shelving location )

csv will have zzEMPTY as row heading instead of NULL.
( bug does not appear if ccode or location is chosen as the COLUMN ).




--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 01:08 UTC  ---

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

Actual time not defined. Setting to 0.0
The original reporter of this bug does not have
   an account here. Reassigning to the person who moved
   it here: chris@bigballofwax.co.nz.
   Previous reporter was maria.laude@liblime.com.
CC member maria.laude@liblime.com does not have an account here

Comment 1 Owen Leonard 2013-01-09 13:52:12 UTC
Tested in master, bug doesn't seem to exist anymore.