DHIS sample Sierra Leone data not being fully imported from PostgreSQL into DHIS

Dear DHIS community,

I have installed DHIS2 live on a windows desktop. Ive tried installing the sample Sierra Leone dataset by restoring in PgAdmin and adapting the dhis conf file according to the instructions. When I open dhis, only the dimensions (indicators, time period, org unit etc) seem to be imported but no associated values. Hence I cannot build any charts. I was wondering if anyone else has faced this problem or if it’s a possible bug or if I have missed something out ?

Any help would be greatly appreciated !

Best Wishes

Ryan

1 Like

Hello

The demo database does not include analysed data, hence you need to run analytics before you can view the aggregated data in charts and so forth.

Regards,
Henning Håkonsen
Developer

···

On 21 Mar 2018, at 15:19, Ryan Nazareth <ryan@mantaraymedia.co.uk> wrote:

Dear DHIS community,

I have installed DHIS2 live on a windows desktop. Ive tried installing the sample Sierra Leone dataset by restoring in PgAdmin and adapting the dhis conf file according to the instructions. When I open dhis, only the dimensions (indicators, time period, org unit etc) seem to be imported but no associated values. Hence I cannot build any charts. I was wondering if anyone else has faced this problem or if it’s a possible bug or if I have missed something out ?

Any help would be greatly appreciated !

Best Wishes
Ryan
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

1 Like

Hi Ryan,
Its described in more detail here in our FAQ.

https://docs.dhis2.org/master/en/user/html/ch34.html

Regards,

Jason

···

On Wed, Mar 21, 2018 at 3:22 PM, Henning Håkonsen henning@dhis2.org wrote:

Hello

The demo database does not include analysed data, hence you need to run analytics before you can view the aggregated data in charts and so forth.

Regards,

Henning Håkonsen

Developer

On 21 Mar 2018, at 15:19, Ryan Nazareth ryan@mantaraymedia.co.uk wrote:

Dear DHIS community,

I have installed DHIS2 live on a windows desktop. Ive tried installing the sample Sierra Leone dataset by restoring in PgAdmin and adapting the dhis conf file according to the instructions. When I open dhis, only the dimensions (indicators, time period, org unit etc) seem to be imported but no associated values. Hence I cannot build any charts. I was wondering if anyone else has faced this problem or if it’s a possible bug or if I have missed something out ?

Any help would be greatly appreciated !

Best Wishes

Ryan


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


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

2 Likes

Dear Ryan,

Have run analytics after importing the database? If No, please run analytics

···

Regards,

Gerald

2 Likes

Hi all,

Thanks for the extremely useful tip – it was taking me a long time to work it out and I though it may been due to the way I was importing it into PostgreSQL. Anyway, I have just started running analytics – is there an indication of how long it normally takes - a few hours ?

Best Wishes

Ryan

···

Dear Ryan,

Have run analytics after importing the database? If No, please run analytics

On Wed, 21 Mar 2018 at 14:20, Ryan Nazareth ryan@mantaraymedia.co.uk wrote:

Dear DHIS community,

I have installed DHIS2 live on a windows desktop. Ive tried installing the sample Sierra Leone dataset by restoring in PgAdmin and adapting the dhis conf file according to the instructions. When I open dhis, only the dimensions (indicators, time period, org unit etc) seem to be imported but no associated values. Hence I cannot build any charts. I was wondering if anyone else has faced this problem or if it’s a possible bug or if I have missed something out ?

Any help would be greatly appreciated !

Best Wishes

Ryan


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

Regards,

Gerald

1 Like

Ryan,

There are configuration which should had been done for Postgres to use your RAM. So the process depends on the RAM allocation. The more RAM, the fast the analytics.

···

Regards,

Gerald

1 Like

Thanks !!

···

Ryan,

There are configuration which should had been done for Postgres to use your RAM. So the process depends on the RAM allocation. The more RAM, the fast the analytics.

On Wed, 21 Mar 2018 at 15:00, Ryan Nazareth ryan@mantaraymedia.co.uk wrote:

Hi all,

Thanks for the extremely useful tip – it was taking me a long time to work it out and I though it may been due to the way I was importing it into PostgreSQL. Anyway, I have just started running analytics – is there an indication of how long it normally takes - a few hours ?

Best Wishes

Ryan

From: gerald thomas gerald17006@gmail.com

Sent: 21 March 2018 14:43

To: Ryan Nazareth ryan@mantaraymedia.co.uk

Cc: dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] DHIS sample Sierra Leone data not being fully imported from PostgreSQL into DHIS

Dear Ryan,

Have run analytics after importing the database? If No, please run analytics

On Wed, 21 Mar 2018 at 14:20, Ryan Nazareth ryan@mantaraymedia.co.uk wrote:

Dear DHIS community,

I have installed DHIS2 live on a windows desktop. Ive tried installing the sample Sierra Leone dataset by restoring in PgAdmin and adapting the dhis conf file according to the instructions. When I open dhis, only the dimensions (indicators, time period, org unit etc) seem to be imported but no associated values. Hence I cannot build any charts. I was wondering if anyone else has faced this problem or if it’s a possible bug or if I have missed something out ?

Any help would be greatly appreciated !

Best Wishes

Ryan


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

Regards,

Gerald

Regards,

Gerald

A post was split to a new topic: Run Analytics on DHIS2

Hi All, we ran analytics and still do not see any data:

Any ideas why?
thank you,
Darren

Hi @dcharloff, welcome to the community! :tada:

I suggest to check the Org unit assigned to your user as well as the sharing settings for the metadata!