Possible bug? Saving a Dataset Report in Excel or PDF format

Hi David,

there is no easy/reliable way of converting HTML and CSS to Excel (except of course going into the HTML rendering engine business). So in a less ambitious approach, for custom HTML forms, the system look for a well-formed HTML table and parses that into a grid which is subsequently rendered as Excel / PDF.

So the current approach is to use a valid, well-formed HTML table as the basis of your custom forms. You can validate your HTML here:

https://validator.w3.org/#validate_by_input

regards,

Lars

···

On Tue, Apr 12, 2016 at 10:26 AM, janhenrik.overland@gmail.com wrote:

----Forwarded using Multi-Forward Chrome Extension
From: Knut Staring
Date: Mon Apr 11 2016 16:00:35 GMT+0530 (IST)
Subject: Re: [Dhis2-devs] Possible bug? Saving a Dataset Report in Excel or PDF format
To: David Hagan
Cc: dhis2-devs

Hi David,

It seems the issue is with CUSTOM forms - it works well with the standard forms, is hard to realise for arbitrary custom forms. However, it may be possible if the forms are very well defined (however, they may then have to look very much like the generated forms).

Knut

On Tue, Apr 5, 2016 at 5:59 AM, David Hagan david.hagan@sagehagan.com wrote:

Any thoughts on this?

I’ve tested it on https://play.dhis2.org/demo and there is no problem, but we have a major country rolling out this month with the version below and this is one of their outstanding issues.

Cheers.

David

On Fri, Apr 1, 2016 at 9:24 AM David Hagan david.hagan@sagehagan.com wrote:

Hi,

We have a production instance of DHIS2

Version: 2.21

Build revision: 21042

Build date: 2016-03-02 17:01

That exhibits the following symptoms.

For ANY dataset report, downloading the PDF or Excel versions of the report displays the raw HTML. It’s like no conversion stylesheet has been applied.

I’ve attached to downloads for reference. Is this a known issue? (I haven’t gone and checked it on demo … will go there next.

David


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

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

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

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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Thanks Lars,

Yes, I’ve been looking at the HTML and throwing it at validators and ‘HTML Tidy’. There are lot’s of nasty nested SPANs everywhere - would be good (from our perspective) to factor these out as custom style elements … I seem to remember we can load custom style sheets … so need to take a peek at how to load those, and eliminate the errors that were in the forms.

Cheers

David

···

On Tue, Apr 12, 2016 at 10:26 AM, janhenrik.overland@gmail.com wrote:

----Forwarded using Multi-Forward Chrome Extension
From: Knut Staring
Date: Mon Apr 11 2016 16:00:35 GMT+0530 (IST)
Subject: Re: [Dhis2-devs] Possible bug? Saving a Dataset Report in Excel or PDF format
To: David Hagan
Cc: dhis2-devs

Hi David,

It seems the issue is with CUSTOM forms - it works well with the standard forms, is hard to realise for arbitrary custom forms. However, it may be possible if the forms are very well defined (however, they may then have to look very much like the generated forms).

Knut

On Tue, Apr 5, 2016 at 5:59 AM, David Hagan david.hagan@sagehagan.com wrote:

Any thoughts on this?

I’ve tested it on https://play.dhis2.org/demo and there is no problem, but we have a major country rolling out this month with the version below and this is one of their outstanding issues.

Cheers.

David

On Fri, Apr 1, 2016 at 9:24 AM David Hagan david.hagan@sagehagan.com wrote:

Hi,

We have a production instance of DHIS2

Version: 2.21

Build revision: 21042

Build date: 2016-03-02 17:01

That exhibits the following symptoms.

For ANY dataset report, downloading the PDF or Excel versions of the report displays the raw HTML. It’s like no conversion stylesheet has been applied.

I’ve attached to downloads for reference. Is this a known issue? (I haven’t gone and checked it on demo … will go there next.

David


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

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

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

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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Sounds good. Yes I have seen a lot of forms coming out of the great MS Word -> HTML converter - can be an interesting task to clean up.

Lars

···

On Tue, Apr 12, 2016 at 5:59 PM, David Hagan david.hagan@sagehagan.com wrote:

Thanks Lars,

Yes, I’ve been looking at the HTML and throwing it at validators and ‘HTML Tidy’. There are lot’s of nasty nested SPANs everywhere - would be good (from our perspective) to factor these out as custom style elements … I seem to remember we can load custom style sheets … so need to take a peek at how to load those, and eliminate the errors that were in the forms.

Cheers

David

On Tue, Apr 12, 2016 at 5:51 PM Lars Helge Øverland lars@dhis2.org wrote:

Hi David,

there is no easy/reliable way of converting HTML and CSS to Excel (except of course going into the HTML rendering engine business). So in a less ambitious approach, for custom HTML forms, the system look for a well-formed HTML table and parses that into a grid which is subsequently rendered as Excel / PDF.

So the current approach is to use a valid, well-formed HTML table as the basis of your custom forms. You can validate your HTML here:

https://validator.w3.org/#validate_by_input

regards,

Lars


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

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

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

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

On Tue, Apr 12, 2016 at 10:26 AM, janhenrik.overland@gmail.com wrote:

----Forwarded using Multi-Forward Chrome Extension
From: Knut Staring
Date: Mon Apr 11 2016 16:00:35 GMT+0530 (IST)
Subject: Re: [Dhis2-devs] Possible bug? Saving a Dataset Report in Excel or PDF format
To: David Hagan
Cc: dhis2-devs

Hi David,

It seems the issue is with CUSTOM forms - it works well with the standard forms, is hard to realise for arbitrary custom forms. However, it may be possible if the forms are very well defined (however, they may then have to look very much like the generated forms).

Knut

On Tue, Apr 5, 2016 at 5:59 AM, David Hagan david.hagan@sagehagan.com wrote:

Any thoughts on this?

I’ve tested it on https://play.dhis2.org/demo and there is no problem, but we have a major country rolling out this month with the version below and this is one of their outstanding issues.

Cheers.

David

On Fri, Apr 1, 2016 at 9:24 AM David Hagan david.hagan@sagehagan.com wrote:

Hi,

We have a production instance of DHIS2

Version: 2.21

Build revision: 21042

Build date: 2016-03-02 17:01

That exhibits the following symptoms.

For ANY dataset report, downloading the PDF or Excel versions of the report displays the raw HTML. It’s like no conversion stylesheet has been applied.

I’ve attached to downloads for reference. Is this a known issue? (I haven’t gone and checked it on demo … will go there next.

David


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

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

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

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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org


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