Excel reports documentation?

I see this is still under very active development, but I was hoping to
try this module out a bit. However, it is not clear to me what to do
exactly. It looks like I need a template, but no idea what one should
look like. Is there any, ahem, documentation somewhere? Give me
whatever you have and I will try and clean it up a bit and place it in
the documentation section.

Best regards,
Jason

Hi Jason,
I’m working on it. I hope will finish in this weekend. Yes I will need you take a look and correct. If you like I can give you the first version of my document about Excel Report, which is not much clear because I wrote so short without introduction, reasons, and comprehensive…

However, Excel report module hasn’t completed committing yet. Tri, Tran and Hieu are working on the source code of this module.

···

On Wed, Sep 23, 2009 at 12:26 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

I see this is still under very active development, but I was hoping to

try this module out a bit. However, it is not clear to me what to do

exactly. It looks like I need a template, but no idea what one should

look like. Is there any, ahem, documentation somewhere? Give me

whatever you have and I will try and clean it up a bit and place it in

the documentation section.

Best regards,

Jason


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

Thuy
HISP Vietnam
+84902079126

OK. Let me know when the docs are ready, and I can have a look at them.

Any idea when the code will be ready? I have had a request for this
particular type of functionality, and would like to see if the Excel
reports fit our requirements here in Zambia as well.

Best regards,
Jason

···

On Wed, Sep 23, 2009 at 7:31 AM, Thuy Nguyen <thuy.hispvietnam@gmail.com> wrote:

Hi Jason,
I'm working on it. I hope will finish in this weekend. Yes I will need you
take a look and correct. If you like I can give you the first version of my
document about Excel Report, which is not much clear because I wrote so
short without introduction, reasons, and comprehensive...
However, Excel report module hasn't completed committing yet. Tri, Tran and
Hieu are working on the source code of this module.

On Wed, Sep 23, 2009 at 12:26 PM, Jason Pickering > <jason.p.pickering@gmail.com> wrote:

I see this is still under very active development, but I was hoping to
try this module out a bit. However, it is not clear to me what to do
exactly. It looks like I need a template, but no idea what one should
look like. Is there any, ahem, documentation somewhere? Give me
whatever you have and I will try and clean it up a bit and place it in
the documentation section.

Best regards,
Jason

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

--
--
Thuy
HISP Vietnam
+84902079126

Jason, would as always be good to get your feedback on this. If this is close to fitting your needs we can spend some time to accommodate it.

Thuy, can you find out how many days you are from having this module in a “working” state?

Lars

···

On Wed, Sep 23, 2009 at 8:09 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

OK. Let me know when the docs are ready, and I can have a look at them.

Any idea when the code will be ready? I have had a request for this

particular type of functionality, and would like to see if the Excel

reports fit our requirements here in Zambia as well.

Well, as soon as I can get it working, I would be happy to provide feedback. :slight_smile:

There have been some development here in Zambia that make this type of
functionality more important for the potential deployment of DHIS2
country-wide here, but I need to be able to give some semi-intelligent
answers about whether DHIS2 can output to Excel. Currently, we have
gone through BIRT for some simple Excel sheets, but being able to go
directly from the application would be a big plus.

Just let me know when you are finished, or at least at a state when it
is semi-usable.

Best regards,
jason

···

2009/9/23 Lars Helge Øverland <larshelge@gmail.com>:

On Wed, Sep 23, 2009 at 8:09 AM, Jason Pickering > <jason.p.pickering@gmail.com> wrote:

OK. Let me know when the docs are ready, and I can have a look at them.

Any idea when the code will be ready? I have had a request for this
particular type of functionality, and would like to see if the Excel
reports fit our requirements here in Zambia as well.

Jason, would as always be good to get your feedback on this. If this is
close to fitting your needs we can spend some time to accommodate it.

Thuy, can you find out how many days you are from having this module in a
"working" state?

Lars

Hi Jason,

Could you tell us a bit more about the Zambian Excel reporting requirements?

There are a lot of talk about the use of Excel from different implementation sites at the moment and it seems a bit of collaboration and consolidation would be useful.

I would also be interested in knowing more about the use of excel reporting in Vietnam. What are the main use cases?

There is a blueprint (actually two) on the use of Excel for remote lightweight data entry (import) here:

https://blueprints.launchpad.net/dhis2/+spec/import-data-from-excel
https://blueprints.launchpad.net/dhis2/+spec/spreadsheet-dataentry

I guess the use of Xforms (which Bob reported that is now working quite well in OpenMRS) could be a better alternative for remote data entry?

I know India is already using Excel import, and I assume also some kind of reporting to excel.

The DHIS report tables can be exported to excel as well, and if you use the Display functionality in report tables the view can be edited (hide/show columns etc). A bit more styling there and you have an Excel report I guess…

Another related and very important Excel issue with DHIS is export to Pivot Tables. There is a need for a much easier generation and update process here, basically what we want is a one click process from within DHIS 2 to an Excel Pivot table file. Bob and I had a chat about this last week and he had some ideas on how generate pivot tables by writing directly to Excel’s XML format. An important related issue here (that I guess deserves a blueprint) is the use of local Excel files when having a central server installation (no local databases). Basically my key querstion is how to keep local Excel pivot tables updated against a remote server without having to download all the data on every refresh. The refresh operation empties the pivot table and loads all data again from source. This is not what we want, as it could be years of data needed to be downloaded from the server. In stead some kind of local mirror of the data source (ideally without having to install a database server) and a monthly append process is what we need, but not sure how…

So lots of activity around Excel… and scope for collaboration and sharing of code and ideas I guess…

Ola Hodne Titlestad |Technical Officer|
Health Metrics Network (HMN) | World Health Organization
Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: titlestado@who.int|Tel: +41 788216897

Website: www.healthmetricsnetwork.org

Better Information. Better Decisions. Better Health.

···

2009/9/23 Jason Pickering jason.p.pickering@gmail.com

Well, as soon as I can get it working, I would be happy to provide feedback. :slight_smile:

There have been some development here in Zambia that make this type of

functionality more important for the potential deployment of DHIS2

country-wide here, but I need to be able to give some semi-intelligent

answers about whether DHIS2 can output to Excel. Currently, we have

gone through BIRT for some simple Excel sheets, but being able to go

directly from the application would be a big plus.

Just let me know when you are finished, or at least at a state when it

is semi-usable.

Best regards,

jason

2009/9/23 Lars Helge Øverland larshelge@gmail.com:

On Wed, Sep 23, 2009 at 8:09 AM, Jason Pickering > > > jason.p.pickering@gmail.com wrote:

OK. Let me know when the docs are ready, and I can have a look at them.

Any idea when the code will be ready? I have had a request for this

particular type of functionality, and would like to see if the Excel

reports fit our requirements here in Zambia as well.

Jason, would as always be good to get your feedback on this. If this is

close to fitting your needs we can spend some time to accommodate it.

Thuy, can you find out how many days you are from having this module in a

“working” state?

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