Need Help

Hi All,

When I installed the dhis and it opens I get this message can I get some help?

The database is currently running in-memory. This is useful for
testing purposes but might happen because your database configuration
was not picked up. Please make sure this is intentional. Your data
will be destroyed when the application shuts down.

Thanks

Stephen

Hello Stephen,

That's means the system is running on the default database, check with the DHIS2_HOME and make sure it's points to right path of hibernate.properties,

Cheers

···

Sent from my iPhone

On May 10, 2011, at 17:48, Stephen Gbanyan <mambu9@gmail.com> wrote:

Hi All,

When I installed the dhis and it opens I get this message can I get some help?

The database is currently running in-memory. This is useful for
testing purposes but might happen because your database configuration
was not picked up. Please make sure this is intentional. Your data
will be destroyed when the application shuts down.

Thanks

Stephen

_______________________________________________
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

Hi,

This means that you have not created a database configuration, and as
such DHIS has started an in-memory database which will work for
testing, but nothing you do on DHIS will be saved after the session is
finished.

If you want to setup a database to work with DHIS, more information
can be found here:
http://dhis2.com/development#databasesetup

···

--
Morten

On Tue, May 10, 2011 at 4:48 PM, Stephen Gbanyan <mambu9@gmail.com> wrote:

Hi All,

When I installed the dhis and it opens I get this message can I get some help?

The database is currently running in-memory. This is useful for
testing purposes but might happen because your database configuration
was not picked up. Please make sure this is intentional. Your data
will be destroyed when the application shuts down.

Thanks

Stephen

_______________________________________________
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

Listers --
    We need to calculate bed occupancy rates. We have the number of
beds per ward and the number of person-days of bed use per month, but we
need the number of days per month. Is that available in some way from
the system or are we going to have to key it?
Thanks, Roger

It would be available through a pretty trivial SQL statement if you
are calculating this on an external report.

SELECT periodid, enddate-startdate as nbr_days FROM period in
Postgresql will give you the number of days in a given period along
with the periodid. you could then join this to the aggregated data
elements you mention with periodid and the aggregateddatavalue table.

I think the easiest way would be through a custom SQL view (which is
now supported) or through a report rather than direct calculation
through the system.

Regards,
Jason

···

On Wed, May 11, 2011 at 10:56 AM, Friedman, Roger (CDC/CGH/DGHA) (CTR) <rdf4@cdc.gov> wrote:

Listers --
We need to calculate bed occupancy rates. We have the number of
beds per ward and the number of person-days of bed use per month, but we
need the number of days per month. Is that available in some way from
the system or are we going to have to key it?
Thanks, Roger

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

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

Hi Roger,

This functionality is on the roadmap for the next release:

https://blueprints.launchpad.net/dhis2/+spec/extended-indicator-engine

We definitely need to support this as part of the indicator functionality and cannot require external or custom calculations for this.

If you know that you will only be using monthly reports a workaround is to use a static value of 30.3 in the indicator formula.

The danger is that the indicator will be made available for other period types in the various report tools, and a quarter will have more days than 30.3 of course…

You could perhaps, while waiting for the next release, create a set of indicators for bed occupancy, one for each period type (e.g. “Bed Occupancy Rate Monthly”, “Bed Occupancy Rate Quarterly”, and “Bed Occupancy Rate Yearly” and adjust the static number in the formula accordingly, and then make sure to use these with the correct period type in report outputs.

Ola

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 11 May 2011 11:01, Jason Pickering jason.p.pickering@gmail.com wrote:

It would be available through a pretty trivial SQL statement if you

are calculating this on an external report.

SELECT periodid, enddate-startdate as nbr_days FROM period in

Postgresql will give you the number of days in a given period along

with the periodid. you could then join this to the aggregated data

elements you mention with periodid and the aggregateddatavalue table.

I think the easiest way would be through a custom SQL view (which is

now supported) or through a report rather than direct calculation

through the system.

Regards,

Jason

On Wed, May 11, 2011 at 10:56 AM, Friedman, Roger (CDC/CGH/DGHA) (CTR) > > rdf4@cdc.gov wrote:

Listers –

We need to calculate bed occupancy rates. We have the number of

beds per ward and the number of person-days of bed use per month, but we

need the number of days per month. Is that available in some way from

the system or are we going to have to key it?

Thanks, Roger


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

Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+260974901293


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

Already on the roadmap for next release for June 10:

https://blueprints.launchpad.net/dhis2/+spec/extended-indicator-engine

···

On Wed, May 11, 2011 at 10:56 AM, Friedman, Roger (CDC/CGH/DGHA) (CTR) rdf4@cdc.gov wrote:

Listers –

We need to calculate bed occupancy rates.  We have the number of

beds per ward and the number of person-days of bed use per month, but we

need the number of days per month. Is that available in some way from

the system or are we going to have to key it?

Thanks, Roger


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

What I hear you saying is that we can get this in a report table but not in an indicator calculation or validation expression.

Also, my recollection is that custom SQL view only allows select statements, so we can't use it to update a hidden data element, right? And we could muck with the Hibernate definition to get a virtual column in the period table but we'd have no way to use it.

···

-----Original Message-----
From: Jason Pickering [mailto:jason.p.pickering@gmail.com]
Sent: Wednesday, May 11, 2011 5:01 AM
To: Friedman, Roger (CDC/CGH/DGHA) (CTR)
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Days per period

It would be available through a pretty trivial SQL statement if you
are calculating this on an external report.

SELECT periodid, enddate-startdate as nbr_days FROM period in
Postgresql will give you the number of days in a given period along
with the periodid. you could then join this to the aggregated data
elements you mention with periodid and the aggregateddatavalue table.

I think the easiest way would be through a custom SQL view (which is
now supported) or through a report rather than direct calculation
through the system.

Regards,
Jason

On Wed, May 11, 2011 at 10:56 AM, Friedman, Roger (CDC/CGH/DGHA) (CTR) <rdf4@cdc.gov> wrote:

Listers --
We need to calculate bed occupancy rates. We have the number of
beds per ward and the number of person-days of bed use per month, but we
need the number of days per month. Is that available in some way from
the system or are we going to have to key it?
Thanks, Roger

_______________________________________________
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

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

PEPELA WANJALAMINISTRY OF HEALTH HEADQUARTERSHEALTH INFORMATION SYSTEMAFYA HOUSE, HIS LG 37P.O BOX 30016, NAIROBI, KENYATEL: +254 (020) 2717077 EXT 45097CELL: +254 (0) 722375633 or 0202033363EMAIL: wanjala2p@yahoo.com hmis@health.go.ke

···

--- On Wed, 5/11/11, Friedman, Roger (CDC/CGH/DGHA) (CTR) <rdf4@cdc.gov> wrote:

I think it will be a lot easier for you to use the normal approach of defining indicators and report tables and not use any custom SQL directly.

Ola

···

On 11 May 2011 11:19, Friedman, Roger (CDC/CGH/DGHA) (CTR) rdf4@cdc.gov wrote:

What I hear you saying is that we can get this in a report table but not in an indicator calculation or validation expression.


Also, my recollection is that custom SQL view only allows select statements, so we can’t use it to update a hidden data element, right? And we could muck with the Hibernate definition to get a virtual column in the period table but we’d have no way to use it.

-----Original Message-----

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]

Sent: Wednesday, May 11, 2011 5:01 AM

To: Friedman, Roger (CDC/CGH/DGHA) (CTR)

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Days per period

It would be available through a pretty trivial SQL statement if you

are calculating this on an external report.

SELECT periodid, enddate-startdate as nbr_days FROM period in

Postgresql will give you the number of days in a given period along

with the periodid. you could then join this to the aggregated data

elements you mention with periodid and the aggregateddatavalue table.

I think the easiest way would be through a custom SQL view (which is

now supported) or through a report rather than direct calculation

through the system.

Regards,

Jason

On Wed, May 11, 2011 at 10:56 AM, Friedman, Roger (CDC/CGH/DGHA) (CTR) > > rdf4@cdc.gov wrote:

Listers –

We need to calculate bed occupancy rates. We have the number of

beds per ward and the number of person-days of bed use per month, but we

need the number of days per month. Is that available in some way from

the system or are we going to have to key it?

Thanks, Roger


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

Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+260974901293


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

SQL views in DHIS2 only allow SELECT statements, but one can define a
custom Procedural SQL function (Called through a SELECT statement),
which could perform an update statement. Otherwise, you can completely
go outside of DHIS2, and use something like PGAgent to perform these
custom tasks on a scheduled basis.

Again, as you can see from Ola and Lars's response, the "correct" way
would be to have the functionality directly in DHIS2, without having
to resort to custom SQL, which is of course potentially fraught with
its own set of problems, but could also be a potential interim
solution until the native DHIS2 functionality is in place.

Regards,
Jason

···

On Wed, May 11, 2011 at 11:19 AM, Friedman, Roger (CDC/CGH/DGHA) (CTR) <rdf4@cdc.gov> wrote:

What I hear you saying is that we can get this in a report table but not in an indicator calculation or validation expression.

Also, my recollection is that custom SQL view only allows select statements, so we can't use it to update a hidden data element, right? And we could muck with the Hibernate definition to get a virtual column in the period table but we'd have no way to use it.

-----Original Message-----
From: Jason Pickering [mailto:jason.p.pickering@gmail.com]
Sent: Wednesday, May 11, 2011 5:01 AM
To: Friedman, Roger (CDC/CGH/DGHA) (CTR)
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Days per period

It would be available through a pretty trivial SQL statement if you
are calculating this on an external report.

SELECT periodid, enddate-startdate as nbr_days FROM period in
Postgresql will give you the number of days in a given period along
with the periodid. you could then join this to the aggregated data
elements you mention with periodid and the aggregateddatavalue table.

I think the easiest way would be through a custom SQL view (which is
now supported) or through a report rather than direct calculation
through the system.

Regards,
Jason

On Wed, May 11, 2011 at 10:56 AM, Friedman, Roger (CDC/CGH/DGHA) (CTR) > <rdf4@cdc.gov> wrote:

Listers --
We need to calculate bed occupancy rates. We have the number of
beds per ward and the number of person-days of bed use per month, but we
need the number of days per month. Is that available in some way from
the system or are we going to have to key it?
Thanks, Roger

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

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

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