Downloading Long Indicator/Data Element names from Pivot Tables

​​Version: 2.20

Build revision: 20001

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

Hi Laura,

this bug was already fixed in 2.22. Are you able to upgrade?

regards,

Lars

···

On Mon, Mar 14, 2016 at 10:51 PM, Laura E. Lincks laura.lincks@icap.columbia.edu wrote:

​​Version: 2.20

Build revision: 20001

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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

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 Mon, Mar 14, 2016 at 10:51 PM, Laura E. Lincks laura.lincks@icap.columbia.edu wrote:

​​Version: 2.20

Build revision: 20001

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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Thanks Laura. The bugfix is also in 2.21 now but 2.20 got more complicated, sorry for that.

Lars

···

On Tue, Mar 15, 2016 at 12:16 PM, Laura E. Lincks laura.lincks@icap.columbia.edu wrote:

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?

regards,

Lars

On Mon, Mar 14, 2016 at 10:51 PM, Laura E. Lincks laura.lincks@icap.columbia.edu wrote:

​​Version: 2.20

Build revision: 20001

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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Version: 2.22

Build revision: 21868

Hello Lars, et al,

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!

image

image

···

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

On Tue, Mar 15, 2016 at 12:16 PM, Laura E. Lincks laura.lincks@icap.columbia.edu wrote:

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?

regards,

Lars


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Mon, Mar 14, 2016 at 10:51 PM, Laura E. Lincks laura.lincks@icap.columbia.edu wrote:

​​Version: 2.20

Build revision: 20001

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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org