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: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help
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: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help
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 ofbeds 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: 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
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 periodIt 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,
JasonOn 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