Store external spreadheet-like data in DHIS2

Dear Community,

I would like to use DHIS2, in addition to its classic uses (data capture, data analysis and reporting,…), to store a tabular data that is sourced from MS Excel spreadsheet (or probably from another database) without any link to organization unit, period or dataset. Would it be possible to integrate this tabular data directly into a dashboard? Or should I still prepare all the data elements to receive the spreadsheet cells values? Or what would be the best way to use the DHIS2 database to store the spreadsheet-like data? I plan to make this spreadsheet to be available in DHIS2 for the users to visualize or to download.

Your suggestions are welcome.

Ragards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

Hi Tantely,

Please have a look here http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s12.html

for how DHIS2 can be used to store file resources.

Data stored there however will not be available for visualization or other analytics.

Regards,
Jason

···

On Mon, Jul 25, 2016 at 4:43 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear Community,

I would like to use DHIS2, in addition to its classic uses (data capture, data analysis and reporting,…), to store a tabular data that is sourced from MS Excel spreadsheet (or probably from another database) without any link to organization unit, period or dataset. Would it be possible to integrate this tabular data directly into a dashboard? Or should I still prepare all the data elements to receive the spreadsheet cells values? Or what would be the best way to use the DHIS2 database to store the spreadsheet-like data? I plan to make this spreadsheet to be available in DHIS2 for the users to visualize or to download.

Your suggestions are welcome.

Ragards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Hi Jason,

Thank you for your suggestions. This is helpful.

Regards

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

···

Le 25 juil. 2016 18:34, “Jason Pickering” jason.p.pickering@gmail.com a écrit :

Hi Tantely,

Please have a look here http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s12.html

for how DHIS2 can be used to store file resources.

Data stored there however will not be available for visualization or other analytics.

Regards,
Jason

On Mon, Jul 25, 2016 at 4:43 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear Community,

I would like to use DHIS2, in addition to its classic uses (data capture, data analysis and reporting,…), to store a tabular data that is sourced from MS Excel spreadsheet (or probably from another database) without any link to organization unit, period or dataset. Would it be possible to integrate this tabular data directly into a dashboard? Or should I still prepare all the data elements to receive the spreadsheet cells values? Or what would be the best way to use the DHIS2 database to store the spreadsheet-like data? I plan to make this spreadsheet to be available in DHIS2 for the users to visualize or to download.

Your suggestions are welcome.

Ragards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

If however you want to use the analytical output and visualization in DHIS2, there is now an app available that allows you to map the spreadsheet to data elements, periods and orgunits in DHIS2 - in other words, there is a way to import from Excel provided it the structure is relatively straightforward and mappable. But you will first have to make sure all the metadata is in DHIS2 or if not, create them.

Knut

···

On Mon, Jul 25, 2016 at 10:23 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hi Jason,

Thank you for your suggestions. This is helpful.

Regards

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Le 25 juil. 2016 18:34, “Jason Pickering” jason.p.pickering@gmail.com a écrit :

Hi Tantely,

Please have a look here http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s12.html

for how DHIS2 can be used to store file resources.

Data stored there however will not be available for visualization or other analytics.

Regards,
Jason

On Mon, Jul 25, 2016 at 4:43 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear Community,

I would like to use DHIS2, in addition to its classic uses (data capture, data analysis and reporting,…), to store a tabular data that is sourced from MS Excel spreadsheet (or probably from another database) without any link to organization unit, period or dataset. Would it be possible to integrate this tabular data directly into a dashboard? Or should I still prepare all the data elements to receive the spreadsheet cells values? Or what would be the best way to use the DHIS2 database to store the spreadsheet-like data? I plan to make this spreadsheet to be available in DHIS2 for the users to visualize or to download.

Your suggestions are welcome.

Ragards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Hi Knut,

Is this app available on the playstore?

···

On Tue, Jul 26, 2016 at 11:26 AM, Knut Staring knutst@gmail.com wrote:

If however you want to use the analytical output and visualization in DHIS2, there is now an app available that allows you to map the spreadsheet to data elements, periods and orgunits in DHIS2 - in other words, there is a way to import from Excel provided it the structure is relatively straightforward and mappable. But you will first have to make sure all the metadata is in DHIS2 or if not, create them.

Knut


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 Mon, Jul 25, 2016 at 10:23 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hi Jason,

Thank you for your suggestions. This is helpful.

Regards

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Le 25 juil. 2016 18:34, “Jason Pickering” jason.p.pickering@gmail.com a écrit :

Hi Tantely,

Please have a look here http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s12.html

for how DHIS2 can be used to store file resources.

Data stored there however will not be available for visualization or other analytics.

Regards,
Jason

On Mon, Jul 25, 2016 at 4:43 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear Community,

I would like to use DHIS2, in addition to its classic uses (data capture, data analysis and reporting,…), to store a tabular data that is sourced from MS Excel spreadsheet (or probably from another database) without any link to organization unit, period or dataset. Would it be possible to integrate this tabular data directly into a dashboard? Or should I still prepare all the data elements to receive the spreadsheet cells values? Or what would be the best way to use the DHIS2 database to store the spreadsheet-like data? I plan to make this spreadsheet to be available in DHIS2 for the users to visualize or to download.

Your suggestions are welcome.

Ragards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Hi Jerome,

not yet, I think. I will check the status of it and get back to you.

Knut

···

On Tue, Jul 26, 2016 at 12:59 PM, Jerome Shaguy jeromeshaguy@gmail.com wrote:

Hi Knut,

Is this app available on the playstore?

On Tue, Jul 26, 2016 at 11:26 AM, Knut Staring knutst@gmail.com wrote:

If however you want to use the analytical output and visualization in DHIS2, there is now an app available that allows you to map the spreadsheet to data elements, periods and orgunits in DHIS2 - in other words, there is a way to import from Excel provided it the structure is relatively straightforward and mappable. But you will first have to make sure all the metadata is in DHIS2 or if not, create them.

Knut


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 Mon, Jul 25, 2016 at 10:23 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hi Jason,

Thank you for your suggestions. This is helpful.

Regards

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Le 25 juil. 2016 18:34, “Jason Pickering” jason.p.pickering@gmail.com a écrit :

Hi Tantely,

Please have a look here http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s12.html

for how DHIS2 can be used to store file resources.

Data stored there however will not be available for visualization or other analytics.

Regards,
Jason

On Mon, Jul 25, 2016 at 4:43 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear Community,

I would like to use DHIS2, in addition to its classic uses (data capture, data analysis and reporting,…), to store a tabular data that is sourced from MS Excel spreadsheet (or probably from another database) without any link to organization unit, period or dataset. Would it be possible to integrate this tabular data directly into a dashboard? Or should I still prepare all the data elements to receive the spreadsheet cells values? Or what would be the best way to use the DHIS2 database to store the spreadsheet-like data? I plan to make this spreadsheet to be available in DHIS2 for the users to visualize or to download.

Your suggestions are welcome.

Ragards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Hi Knut,

We are really interested in that app.

Regards,

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

···

On Tue, Jul 26, 2016 at 9:31 AM, Knut Staring knutst@gmail.com wrote:

Hi Jerome,

Knut

not yet, I think. I will check the status of it and get back to you.

On Tue, Jul 26, 2016 at 12:59 PM, Jerome Shaguy jeromeshaguy@gmail.com wrote:

Hi Knut,

Is this app available on the playstore?


Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

On Tue, Jul 26, 2016 at 11:26 AM, Knut Staring knutst@gmail.com wrote:

If however you want to use the analytical output and visualization in DHIS2, there is now an app available that allows you to map the spreadsheet to data elements, periods and orgunits in DHIS2 - in other words, there is a way to import from Excel provided it the structure is relatively straightforward and mappable. But you will first have to make sure all the metadata is in DHIS2 or if not, create them.

Knut


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 Mon, Jul 25, 2016 at 10:23 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hi Jason,

Thank you for your suggestions. This is helpful.

Regards

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Le 25 juil. 2016 18:34, “Jason Pickering” jason.p.pickering@gmail.com a écrit :

Hi Tantely,

Please have a look here http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s12.html

for how DHIS2 can be used to store file resources.

Data stored there however will not be available for visualization or other analytics.

Regards,
Jason

On Mon, Jul 25, 2016 at 4:43 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear Community,

I would like to use DHIS2, in addition to its classic uses (data capture, data analysis and reporting,…), to store a tabular data that is sourced from MS Excel spreadsheet (or probably from another database) without any link to organization unit, period or dataset. Would it be possible to integrate this tabular data directly into a dashboard? Or should I still prepare all the data elements to receive the spreadsheet cells values? Or what would be the best way to use the DHIS2 database to store the spreadsheet-like data? I plan to make this spreadsheet to be available in DHIS2 for the users to visualize or to download.

Your suggestions are welcome.

Ragards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049