When downloading results from a pivot table to a Table Layout format, we noticed that short names of the data elements and Indicators are displayed, despite the long names appearing on the Pivot Table display prior to Download. (Note: user settings are set to display NAME as the Property to display in analysis modules). Furthermore, it appears that some characters are omitted from the short name when downloading Pivot table results to an Excel Table Layout (HTML layout is a bit better.)
Example:
Indicator (long) name:
QualityCheck_MOH711_Female 0-14 yrs NOT Testing among Counselled InPatient
Indicator Short name:
% NotTested among Counselled F 0-14yrs Inpatient
Excel Table Layout result:
nottested among counselled f 0-14yrs inpatient
HTML Table Layout result:
% NotTested among Counselled F 0-14yrs Inpatient
Is this forced display of short names by design? Our users are asking that long names be displayed in the Pivot Table downloads. We have a work around but it is not perfect.
Thank you…
···
Laura E. Lincks
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132
When downloading results from a pivot table to a Table Layout format, we noticed that short names of the data elements and Indicators are displayed, despite the long names appearing on the Pivot Table display prior to Download. (Note: user settings are set to display NAME as the Property to display in analysis modules). Furthermore, it appears that some characters are omitted from the short name when downloading Pivot table results to an Excel Table Layout (HTML layout is a bit better.)
Example:
Indicator (long) name:
QualityCheck_MOH711_Female 0-14 yrs NOT Testing among Counselled InPatient
Indicator Short name:
% NotTested among Counselled F 0-14yrs Inpatient
Excel Table Layout result:
nottested among counselled f 0-14yrs inpatient
HTML Table Layout result:
% NotTested among Counselled F 0-14yrs Inpatient
Is this forced display of short names by design? Our users are asking that long names be displayed in the Pivot Table downloads. We have a work around but it is not perfect.
Thank you…
Laura E. Lincks
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132
Thanks, Lars. We are slowly upgrading our instances and have not done so with this particular one. Knowing that this bug has been fixed, I’ll propose we upgrade soon. Thanks again.
When downloading results from a pivot table to a Table Layout format, we noticed that short names of the data elements and Indicators are displayed, despite the long names appearing on the Pivot Table display prior to Download. (Note: user settings are set to display NAME as the Property to display in analysis modules). Furthermore, it appears that some characters are omitted from the short name when downloading Pivot table results to an Excel Table Layout (HTML layout is a bit better.)
Example:
Indicator (long) name:
QualityCheck_MOH711_Female 0-14 yrs NOT Testing among Counselled InPatient
Indicator Short name:
% NotTested among Counselled F 0-14yrs Inpatient
Excel Table Layout result:
nottested among counselled f 0-14yrs inpatient
HTML Table Layout result:
% NotTested among Counselled F 0-14yrs Inpatient
Is this forced display of short names by design? Our users are asking that long names be displayed in the Pivot Table downloads. We have a work around but it is not perfect.
Thank you…
Laura E. Lincks
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132
Thanks, Lars. We are slowly upgrading our instances and have not done so with this particular one. Knowing that this bug has been fixed, I’ll propose we upgrade soon. Thanks again.
On Mar 15, 2016 6:28 AM, “Lars Helge Øverland” lars@dhis2.org wrote:
Hi Laura,
this bug was already fixed in 2.22. Are you able to upgrade?
When downloading results from a pivot table to a Table Layout format, we noticed that short names of the data elements and Indicators are displayed, despite the long names appearing on the Pivot Table display prior to Download. (Note: user settings are set to display NAME as the Property to display in analysis modules). Furthermore, it appears that some characters are omitted from the short name when downloading Pivot table results to an Excel Table Layout (HTML layout is a bit better.)
Example:
Indicator (long) name:
QualityCheck_MOH711_Female 0-14 yrs NOT Testing among Counselled InPatient
Indicator Short name:
% NotTested among Counselled F 0-14yrs Inpatient
Excel Table Layout result:
nottested among counselled f 0-14yrs inpatient
HTML Table Layout result:
% NotTested among Counselled F 0-14yrs Inpatient
Is this forced display of short names by design? Our users are asking that long names be displayed in the Pivot Table downloads. We have a work around but it is not perfect.
Thank you…
Laura E. Lincks
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132
We have a version of 2.22 that we’ve been testing. I just ran a pivot table in 2.22 to test the download of long indicator and data element names and it’s still not working. The screenshots below show a snapshot of a Pivot table showing long data element names (top) and a snippet of the downloaded Excel sheet in table layout form still showing data element short names (bottom.) What am I missing?
Note: my user settings for Property to display in analysis modules is set to Name
Thanks!
···
On Tue, Mar 15, 2016 at 7:34 AM, Lars Helge Øverland lars@dhis2.org wrote:
Lars
Thanks Laura. The bugfix is also in 2.21 now but 2.20 got more complicated, sorry for that.
Laura E. Lincks
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132
Thanks, Lars. We are slowly upgrading our instances and have not done so with this particular one. Knowing that this bug has been fixed, I’ll propose we upgrade soon. Thanks again.
On Mar 15, 2016 6:28 AM, “Lars Helge Øverland” lars@dhis2.org wrote:
Hi Laura,
this bug was already fixed in 2.22. Are you able to upgrade?
When downloading results from a pivot table to a Table Layout format, we noticed that short names of the data elements and Indicators are displayed, despite the long names appearing on the Pivot Table display prior to Download. (Note: user settings are set to display NAME as the Property to display in analysis modules). Furthermore, it appears that some characters are omitted from the short name when downloading Pivot table results to an Excel Table Layout (HTML layout is a bit better.)
Example:
Indicator (long) name:
QualityCheck_MOH711_Female 0-14 yrs NOT Testing among Counselled InPatient
Indicator Short name:
% NotTested among Counselled F 0-14yrs Inpatient
Excel Table Layout result:
nottested among counselled f 0-14yrs inpatient
HTML Table Layout result:
% NotTested among Counselled F 0-14yrs Inpatient
Is this forced display of short names by design? Our users are asking that long names be displayed in the Pivot Table downloads. We have a work around but it is not perfect.
Thank you…
Laura E. Lincks
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132