Dear Dhis2 users how can i delete?

Hi all,

Just an update in Vietnam: not yet application for dhis2-mobile, is going to be for dhis2-tracking for Child program.

···

Best regards,
Kim-Anh Vo

On Thu, Sep 15, 2011 at 11:40 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Alvin,

I am not 100% sure, but believe so. I think they are also using the

patient level tracking module there in Viet Nam. Anyone from the

Vietnamese team want to comment?

Regards,

Jason

On Thu, Sep 15, 2011 at 12:40 AM, alvin.marcelo@gmail.com wrote:

Jason,

Is this also the mobile app used in vietnam?

Alvin

Sent from my BlackBerry® wireless handheld

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

From: Muhire Andrew muhireandrew@yahoo.com

Sender: dhis2-users-bounces+alvin.marcelo=gmail.com@lists.launchpad.net

Date: Wed, 14 Sep 2011 11:09:51

To: Jason Pickeringjason.p.pickering@gmail.com

Reply-To: Muhire Andrew muhireandrew@yahoo.com

Cc: dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola Hodne Titlestadolati@ifi.uio.no; dhis2-devs@lists.launchpad.netdhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] [Dhis2-devs] How is it running in other countries?


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


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

···

**Tanks Knut for update.i think we shall adapt it in our country as soon as possible, since it working in others countries.
**
**

De :** Knut Staring knutst@gmail.com
À : Muhire Andrew muhireandrew@yahoo.com
Cc :dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola Hodne Titlestad olati@ifi.uio.no; “dhis2-devs@lists.launchpad.netdhis2-devs@lists.launchpad.net
Envoyé le : Mercredi 14 Septembre 2011 20h16
Objet : Re: [Dhis2-users] Dear Dhis2 users how can i delete?

On Wed, Sep 14, 2011 at 7:02 PM, Muhire Andrew muhireandrew@yahoo.com wrote:

Dear team,
In Dar es salaam workshop some of the countries were doing pilot on using Mobile reporting and Benificiary and programs features in dhis2 [how is it running in the countries that has started using it] ? Tanzania how is it? I think this will be our next step in Rwanda!

How can i link with the team that is working on mobile part?

Hi Andrew,

The existing mobile solutions are based on J2ME clients, and are already
quite useful. The field introduction has so far mostly been SMS based, but we feel that mobile internet (GPRS, 3G) will be a better option in most cases. It is still early days, and I am involved in the planning of
future solutions. We hope to have a first version of a WAP or Opera Mini type solution for simple facility reporting (aggregate date) as part of the 2.5 release in October. Quite a bit more development is planned for the next 6 months, which will also touch on name based solutions (DHIS Tracker).

You should probably await these new developments, becasue they will hopefully be both more stable and flexible than the current solution. Also, before introducing any mobile solutions, it is quite important to implement a solid DHIS2 back bone, and make sure the roll out works well. So I think this should wait until after the switch to DHIS2 as the
new HMIS.

Knut

thanks


Muhire Andrew

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.

To: Muhire Andrew muhireandrew@yahoo.com


From: Ola Hodne Titlestad olati@ifi.uio.noCc: Lars Helge Øverland larshelge@gmail.com; “dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; "dhis2-devs@lists.launchpad.net "
dhis2-devs@lists.launchpad.net
Sent: Monday, September 12, 2011 9:58 PM
Subject: Re: [Dhis2-users] Dear Dhis2 users how can i delete?

Hi,

The only two commands you should run on your database are the two delete statements;

delete from datavalue_audit where dataelementid=;

delete from datavalue where dataelementid=;

“Replace” is not a command, just Lars telling you to change the in the two commands above with the real IDs of your data elements.

Seems all is fine then. You can now try deleting the data elements from the DHIS 2 user interface.

Ola



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

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

2011/9/12 Muhire Andrew muhireandrew@yahoo.com

Thanks for the quick help,

i have successfully used the select and delete steps
(in datavalues and datavalue_audit)

but using replace is not working on my side may be am not using it well? please update me again (only replace syntax). i have deleted data from my data element x and next
step was to use replace but am getting syntax error!

waiting for your help dear team!


  • Muhire
    Andrew*

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.


From: Lars Helge Øverland larshelge@gmail.com

To: Muhire Andrew muhireandrew@yahoo.com
Cc: dhis2-devs@lists.launchpad.net ;
dhis2-users@lists.launchpad.net
Sent: Monday, September 12, 2011 3:51 PM
Subject: Re: Dear Dhis2 users how can i delete?

Hi Andrew,

you need to remove the data with SQL in the database. Run:

delete from datavalue_audit where dataelementid=;
delete from datavalue where dataelementid=;

and replace with the dataelementid of the one you want to remove.

You can then go ahead and delete the data element in the user interface.

Lars


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


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


Knut Staring

Informatics, U. of Oslo

http://hisp.uio.no

+4791880522


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 Alvin,

Currently, we have no plan for using mobile app in Vietnam.

Long

···

On 9/15/2011 11:40 AM, Jason Pickering wrote:

Hi Alvin,

I am not 100% sure, but believe so. I think they are also using the
patient level tracking module there in Viet Nam. Anyone from the
Vietnamese team want to comment?

Regards,
Jason

On Thu, Sep 15, 2011 at 12:40 AM,<alvin.marcelo@gmail.com> wrote:

Jason,

Is this also the mobile app used in vietnam?

Alvin

Sent from my BlackBerry� wireless handheld

-----Original Message-----
From: Muhire Andrew<muhireandrew@yahoo.com>
Sender: dhis2-users-bounces+alvin.marcelo=gmail.com@lists.launchpad.net
Date: Wed, 14 Sep 2011 11:09:51
To: Jason Pickering<jason.p.pickering@gmail.com>
Reply-To: Muhire Andrew<muhireandrew@yahoo.com>
Cc: dhis2-users@lists.launchpad.net<dhis2-users@lists.launchpad.net>; Ola Hodne Titlestad<olati@ifi.uio.no>; dhis2-devs@lists.launchpad.net<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-users] [Dhis2-devs] How is it running in other countries?

_______________________________________________
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

_______________________________________________
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

Dear team,

i have try to remove data element in the system,because it contain some data,it just refused.i have also used a command to delete those data,but no result.

this is the commad i used. delete from datavalue where dataelementid=1906

when i run this command no problem,but when i back in interface on data entry see the error i get;Data element with id : 1906 does not exist because i removed it.of cause i don’t wont it.but after using command delete it also asked to delete this code in dataelement.i did it.after do it, i also get the same error.and then on dataset when i open form.i get this error:

Sorry! The system failed to execute the operation. Usually, no data is lost and you can continue working by going back to the previous page.
If you wish to report the incident, please save this page by choosing “File → Save (page as)” in your browser and include the saved page in the report. The problem details are listed below.

[+]
    Exception (java.lang.NullPointerException):

null: but i have done a backup no problem. i want your help may be i m making error while using this code.

···

De : Knut Staring knutst@gmail.com
À : Muhire Andrew muhireandrew@yahoo.com
Cc :dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola Hodne Titlestad olati@ifi.uio.no; “dhis2-devs@lists.launchpad.netdhis2-devs@lists.launchpad.net
Envoyé le : Mercredi 14 Septembre 2011 20h16
Objet : Re: [Dhis2-users] Dear Dhis2 users how can i delete?

On Wed, Sep 14, 2011 at 7:02 PM, Muhire Andrew muhireandrew@yahoo.com wrote:

Dear team,
In Dar es salaam workshop some of the countries were doing pilot on using Mobile reporting and Benificiary and programs features in dhis2 [how is it running in the countries that has started using it] ? Tanzania how is it? I think this will be our next step in Rwanda!

How can i link with the team that is working on mobile part?

Hi Andrew,

The existing mobile solutions are based on J2ME clients, and are already
quite useful. The field introduction has so far mostly been SMS based, but we feel that mobile internet (GPRS, 3G) will be a better option in most cases. It is still early days, and I am involved in the planning of
future solutions. We hope to have a first version of a WAP or Opera Mini type solution for simple facility reporting (aggregate date) as part of the 2.5 release in October. Quite a bit more development is planned for the next 6 months, which will also touch on name based solutions (DHIS Tracker).

You should probably await these new developments, becasue they will hopefully be both more stable and flexible than the current solution. Also, before introducing any mobile solutions, it is quite important to implement a solid DHIS2 back bone, and make sure the roll out works well. So I think this should wait until after the switch to DHIS2 as the
new HMIS.

Knut

thanks


Muhire Andrew

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.

To: Muhire Andrew muhireandrew@yahoo.com


From: Ola Hodne Titlestad olati@ifi.uio.noCc: Lars Helge Øverland larshelge@gmail.com; “dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; "dhis2-devs@lists.launchpad.net "
dhis2-devs@lists.launchpad.net
Sent: Monday, September 12, 2011 9:58 PM
Subject: Re: [Dhis2-users] Dear Dhis2 users how can i delete?

Hi,

The only two commands you should run on your database are the two delete statements;

delete from datavalue_audit where dataelementid=;

delete from datavalue where dataelementid=;

“Replace” is not a command, just Lars telling you to change the in the two commands above with the real IDs of your data elements.

Seems all is fine then. You can now try deleting the data elements from the DHIS 2 user interface.

Ola



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

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

2011/9/12 Muhire Andrew muhireandrew@yahoo.com

Thanks for the quick help,

i have successfully used the select and delete steps
(in datavalues and datavalue_audit)

but using replace is not working on my side may be am not using it well? please update me again (only replace syntax). i have deleted data from my data element x and next
step was to use replace but am getting syntax error!

waiting for your help dear team!


  • Muhire
    Andrew*

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.


From: Lars Helge Øverland larshelge@gmail.com

To: Muhire Andrew muhireandrew@yahoo.com
Cc: dhis2-devs@lists.launchpad.net ;
dhis2-users@lists.launchpad.net
Sent: Monday, September 12, 2011 3:51 PM
Subject: Re: Dear Dhis2 users how can i delete?

Hi Andrew,

you need to remove the data with SQL in the database. Run:

delete from datavalue_audit where dataelementid=;
delete from datavalue where dataelementid=;

and replace with the dataelementid of the one you want to remove.

You can then go ahead and delete the data element in the user interface.

Lars


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


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


Knut Staring

Informatics, U. of Oslo

http://hisp.uio.no

+4791880522


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,

most operations are cached at the database layer so when doing manual database operations outside dhis you will need to either restart the application or clear the cache by going to “adminstration” → “cache statistics” and clicking “clear cache”.

Lars

Dear team,

        I can see its possible to link one data element to two or more different dataset, Did this affect anything?  eg one data element exit in both District Hospital and Health Center? can this affect the database? Data entry? is it practical?
···
  • Muhire Andrew*

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.


From: Lars Helge Øverland larshelge@gmail.com
To: nsanzumuhire venuste vensanze@yahoo.fr
Cc: Knut Staring knutst@gmail.com; Muhire Andrew muhireandrew@yahoo.com; “dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola Hodne Titlestad olati@ifi.uio.no; “dhis2-devs@lists.launchpad.netdhis2-devs@lists.launchpad.net
Sent: Thursday, September 15, 2011 9:30 AM
Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?

Hi,

most operations are cached at the database layer so when doing manual database operations outside dhis you will need to either restart the application or clear the cache by going to “adminstration” → “cache statistics” and clicking “clear cache”.

Lars

This is totally possible. You may have the same data element being
collected on two separate aggregation forms. Instead of creating two
data elements to represent the same thing, you just need to place the
same data element in two separate datasets. If you have "Total
attendance" at both the Hospital and Health center level, then you
might have two sepererate datasets (Hospital and PHC), with some data
elements which are different, some which are common.

Best practice is to try and consolidate as many data elements as you
can across the different service levels, as in practice, we have seen
that they may be named differently at different service levels, but
actually represent the same occurrence.

Regards,
Jason

···

On Fri, Sep 16, 2011 at 12:19 PM, Muhire Andrew <muhireandrew@yahoo.com> wrote:

Dear team,
I can see its possible to link one data element to two or more
different dataset, Did this affect anything? eg one data element exit in
both District Hospital and Health Center? can this affect the database? Data
entry? is it practical?

________________________________

Muhire Andrew
HMIS/Ministry of Health
andrew.muhire@moh.gov.rw
God is my provider.

________________________________
From: Lars Helge Øverland <larshelge@gmail.com>
To: nsanzumuhire venuste <vensanze@yahoo.fr>
Cc: Knut Staring <knutst@gmail.com>; Muhire Andrew <muhireandrew@yahoo.com>;
"dhis2-users@lists.launchpad.net" <dhis2-users@lists.launchpad.net>; Ola
Hodne Titlestad <olati@ifi.uio.no>; "dhis2-devs@lists.launchpad.net"
<dhis2-devs@lists.launchpad.net>
Sent: Thursday, September 15, 2011 9:30 AM
Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?

Hi,
most operations are cached at the database layer so when doing manual
database operations outside dhis you will need to either restart the
application or clear the cache by going to "adminstration" -> "cache
statistics" and clicking "clear cache".

Lars

_______________________________________________
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

Thanks Jason for the fantastic explanations.

···

Muhire Andrew

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.


From: Jason Pickering jason.p.pickering@gmail.com
To: Muhire Andrew muhireandrew@yahoo.com
Cc: Lars Helge Øverland larshelge@gmail.com; nsanzumuhire venuste vensanze@yahoo.fr; “dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola Hodne Titlestad olati@ifi.uio.no
Sent: Friday, September 16, 2011 1:22 PM
Subject: Re: [Dhis2-devs] Is it practical for one data element to exit in two dataset?(eg District Hospital and Health center)?

This is totally possible. You may have the same data element being
collected on two separate aggregation forms. Instead of creating two
data elements to represent the same thing, you just need to place the
same data element in two separate datasets. If you have “Total
attendance” at both the Hospital and Health center level, then you
might have two sepererate datasets (Hospital and PHC), with some data
elements which are different, some which are common.

Best practice is to try and consolidate as many data elements as you
can across the different service levels, as in practice, we have seen
that they may be named differently at different service levels, but
actually represent the same occurrence.

Regards,
Jason

On Fri, Sep 16, 2011 at 12:19 PM, Muhire Andrew muhireandrew@yahoo.com wrote:

Dear team,
I can see its possible to link one data element to two or more
different dataset, Did this affect anything? eg one data element exit in
both District Hospital and Health Center? can this affect the database? Data
entry? is it practical?


Muhire Andrew
HMIS/Ministry of Health
andrew.muhire@moh.gov.rw
God is my provider.


From: Lars Helge Øverland larshelge@gmail.com
To: nsanzumuhire venuste vensanze@yahoo.fr
Cc: Knut Staring knutst@gmail.com; Muhire Andrew muhireandrew@yahoo.com;
dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola
Hodne Titlestad olati@ifi.uio.no; “dhis2-devs@lists.launchpad.net
dhis2-devs@lists.launchpad.net
Sent: Thursday, September 15, 2011 9:30 AM
Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?

Hi,
most operations are cached at the database layer so when doing manual
database operations outside dhis you will need to either restart the
application or clear the cache by going to “adminstration” → “cache
statistics” and clicking “clear cache”.

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

Mahundi et al

Can we not apply this to OUR Tanzania data elements, which have different data elements for IPD and OPD , acute and chronic

Working with different data elements with same meaning is driving me MAD

e.g. 70 (or more) examples such as

  • Diabetes Mellitus (ear infection acute, ear infection chronic etc etc etc ) in OPD
  • Diabetes Mellitus in IPD
    Why can we not have the same disease in two separate datasets??

Is it not possible to combine these?

Regards

Arthur

···

On 16 September 2011 14:22, Jason Pickering jason.p.pickering@gmail.com wrote:

This is totally possible. You may have the same data element being

collected on two separate aggregation forms. Instead of creating two

data elements to represent the same thing, you just need to place the

same data element in two separate datasets. If you have "Total

attendance" at both the Hospital and Health center level, then you

might have two sepererate datasets (Hospital and PHC), with some data

elements which are different, some which are common.

Best practice is to try and consolidate as many data elements as you

can across the different service levels, as in practice, we have seen

that they may be named differently at different service levels, but

actually represent the same occurrence.

Regards,

Jason

On Fri, Sep 16, 2011 at 12:19 PM, Muhire Andrew muhireandrew@yahoo.com wrote:

Dear team,

        I can see its possible to link one data element to two or more

different dataset, Did this affect anything? eg one data element exit in

both District Hospital and Health Center? can this affect the database? Data

entry? is it practical?


Muhire Andrew

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.


From: Lars Helge Øverland larshelge@gmail.com

To: nsanzumuhire venuste vensanze@yahoo.fr

Cc: Knut Staring knutst@gmail.com; Muhire Andrew muhireandrew@yahoo.com;

dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola

Hodne Titlestad olati@ifi.uio.no; “dhis2-devs@lists.launchpad.net

dhis2-devs@lists.launchpad.net

Sent: Thursday, September 15, 2011 9:30 AM

Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?

Hi,

most operations are cached at the database layer so when doing manual

database operations outside dhis you will need to either restart the

application or clear the cache by going to “adminstration” → "cache

statistics" and clicking “clear cache”.

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


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


Quality is not an act … It is a Habit (Aristotle)
Skype arthur_heywood_za
Tanzania +255-773-669393
SA +27-769405494

Mahundi et al

Can we not apply this to OUR Tanzania data elements, which have different data elements for IPD and OPD , acute and chronic

Working with different data elements with same meaning is driving me MAD

e.g. 70 (or more) examples such as

  • Diabetes Mellitus (ear infection acute, ear infection chronic etc etc etc ) in OPD
  • Diabetes Mellitus ( etc) in IPD
    Why can we not have the same disease in two separate datasets??

Is it not possible to combine these?

Regards

Arthur

···

On 16 September 2011 14:22, Jason Pickering jason.p.pickering@gmail.com wrote:

This is totally possible. You may have the same data element being

collected on two separate aggregation forms. Instead of creating two

data elements to represent the same thing, you just need to place the

same data element in two separate datasets. If you have "Total

attendance" at both the Hospital and Health center level, then you

might have two sepererate datasets (Hospital and PHC), with some data

elements which are different, some which are common.

Best practice is to try and consolidate as many data elements as you

can across the different service levels, as in practice, we have seen

that they may be named differently at different service levels, but

actually represent the same occurrence.

Regards,

Jason

On Fri, Sep 16, 2011 at 12:19 PM, Muhire Andrew muhireandrew@yahoo.com wrote:

Dear team,

        I can see its possible to link one data element to two or more

different dataset, Did this affect anything? eg one data element exit in

both District Hospital and Health Center? can this affect the database? Data

entry? is it practical?


Muhire Andrew

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.


From: Lars Helge Øverland larshelge@gmail.com

To: nsanzumuhire venuste vensanze@yahoo.fr

Cc: Knut Staring knutst@gmail.com; Muhire Andrew muhireandrew@yahoo.com;

dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola

Hodne Titlestad olati@ifi.uio.no; “dhis2-devs@lists.launchpad.net

dhis2-devs@lists.launchpad.net

Sent: Thursday, September 15, 2011 9:30 AM

Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?

Hi,

most operations are cached at the database layer so when doing manual

database operations outside dhis you will need to either restart the

application or clear the cache by going to “adminstration” → "cache

statistics" and clicking “clear cache”.

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


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


Quality is not an act … It is a Habit (Aristotle)
Skype arthur_heywood_za
Tanzania +255-773-669393
SA +27-769405494

Sound good, doc. We can discuss that Monday morning

···

On 16 Sep 2011 15:47, “Arthur Heywood” arthurheywood@gmail.com wrote:

Mahundi et al
Can we not apply this to OUR Tanzania data elements, which have different

data elements for IPD and OPD , acute and chronic

Working with different data elements with same meaning is driving me MAD
e.g. 70 (or more) examples such as

  • Diabetes Mellitus (ear infection acute, ear infection chronic etc etc

etc ) in OPD

  • Diabetes Mellitus ( etc) in IPD

Why can we not have the same disease in two separate datasets??

Is it not possible to combine these?

Regards

Arthur

On 16 September 2011 14:22, Jason Pickering jason.p.pickering@gmail.comwrote:

This is totally possible. You may have the same data element being

collected on two separate aggregation forms. Instead of creating two
data elements to represent the same thing, you just need to place the
same data element in two separate datasets. If you have "Total

attendance" at both the Hospital and Health center level, then you
might have two sepererate datasets (Hospital and PHC), with some data
elements which are different, some which are common.

Best practice is to try and consolidate as many data elements as you
can across the different service levels, as in practice, we have seen
that they may be named differently at different service levels, but

actually represent the same occurrence.

Regards,
Jason

On Fri, Sep 16, 2011 at 12:19 PM, Muhire Andrew muhireandrew@yahoo.com >> wrote:

Dear team,
I can see its possible to link one data element to two or
more
different dataset, Did this affect anything? eg one data element exit in

both District Hospital and Health Center? can this affect the database?
Data
entry? is it practical?


Muhire Andrew
HMIS/Ministry of Health
andrew.muhire@moh.gov.rw
God is my provider.


From: Lars Helge Øverland larshelge@gmail.com
To: nsanzumuhire venuste vensanze@yahoo.fr

Cc: Knut Staring knutst@gmail.com; Muhire Andrew <
muhireandrew@yahoo.com>;
dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola

Hodne Titlestad olati@ifi.uio.no; “dhis2-devs@lists.launchpad.net
dhis2-devs@lists.launchpad.net

Sent: Thursday, September 15, 2011 9:30 AM
Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?

Hi,
most operations are cached at the database layer so when doing manual

database operations outside dhis you will need to either restart the
application or clear the cache by going to “adminstration” → “cache
statistics” and clicking “clear cache”.

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


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


Quality is not an act … It is a Habit (Aristotle)
Skype arthur_heywood_za
Tanzania +255-773-669393
SA +27-769405494


You received this message because you are subscribed to the Google
Groups “UDSM_HMIS_Team” group.
To post to this group, send email to udsm_hmis_team@googlegroups.com

To unsubscribe from this group, send email to
udsm_hmis_team+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/udsm_hmis_team?hl=en

Arthur,
Why not have a single data element for

Diabetes Mellitus

with category option combination

(Inpatient/Outpatient)/(ear infection acute, ear infection chronic etc etc etc)

and only have certain data element/category options in the IP form and
certain data element/category options in the OPD form?

Regards,
Jason

···

On Fri, Sep 16, 2011 at 2:47 PM, Arthur Heywood <arthurheywood@gmail.com> wrote:

Mahundi et al
Can we not apply this to OUR Tanzania data elements, which have different
data elements for IPD and OPD , acute and chronic
Working with different data elements with same meaning is driving me MAD
e.g. 70 (or more) examples such as

Diabetes Mellitus (ear infection acute, ear infection chronic etc etc etc )
in OPD
Diabetes Mellitus ( etc) in IPD

Why can we not have the same disease in two separate datasets??
Is it not possible to combine these?
Regards
Arthur
On 16 September 2011 14:22, Jason Pickering <jason.p.pickering@gmail.com> > wrote:

This is totally possible. You may have the same data element being
collected on two separate aggregation forms. Instead of creating two
data elements to represent the same thing, you just need to place the
same data element in two separate datasets. If you have "Total
attendance" at both the Hospital and Health center level, then you
might have two sepererate datasets (Hospital and PHC), with some data
elements which are different, some which are common.

Best practice is to try and consolidate as many data elements as you
can across the different service levels, as in practice, we have seen
that they may be named differently at different service levels, but
actually represent the same occurrence.

Regards,
Jason

On Fri, Sep 16, 2011 at 12:19 PM, Muhire Andrew <muhireandrew@yahoo.com> >> wrote:
> Dear team,
> I can see its possible to link one data element to two or
> more
> different dataset, Did this affect anything? eg one data element exit
> in
> both District Hospital and Health Center? can this affect the database?
> Data
> entry? is it practical?
>
>
>
> ________________________________
>
> Muhire Andrew
> HMIS/Ministry of Health
> andrew.muhire@moh.gov.rw
> God is my provider.
>
> ________________________________
> From: Lars Helge Øverland <larshelge@gmail.com>
> To: nsanzumuhire venuste <vensanze@yahoo.fr>
> Cc: Knut Staring <knutst@gmail.com>; Muhire Andrew
> <muhireandrew@yahoo.com>;
> "dhis2-users@lists.launchpad.net" <dhis2-users@lists.launchpad.net>; Ola
> Hodne Titlestad <olati@ifi.uio.no>; "dhis2-devs@lists.launchpad.net"
> <dhis2-devs@lists.launchpad.net>
> Sent: Thursday, September 15, 2011 9:30 AM
> Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?
>
> Hi,
> most operations are cached at the database layer so when doing manual
> database operations outside dhis you will need to either restart the
> application or clear the cache by going to "adminstration" -> "cache
> statistics" and clicking "clear cache".
>
> Lars
>
>
> _______________________________________________
> 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
>
>

_______________________________________________
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

--
Quality is not an act .... It is a Habit (Aristotle)
Skype arthur_heywood_za
Tanzania +255-773-669393
SA +27-769405494

Dear Arther, i think you have to consider data element category since you are talking of OPD and IPD.This can differ depending on their categories. (Make sure they all have same category eg Age is the same,Gender the same). Because most of the data element are the same but differ when you see their categories.

···

Muhire Andrew

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.


From: Masoud Mahundi mmahundi97@gmail.com
To: udsm_hmis_team@googlegroups.com
Cc:dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Muhire Andrew muhireandrew@yahoo.com; Ola Hodne Titlestad olati@ifi.uio.no; Jason Pickering jason.p.pickering@gmail.com
Sent: Friday, September 16, 2011 2:50 PM
Subject: Re: [udsm_hmis_team] Re: [Dhis2-users] [Dhis2-devs] Is it practical for one data element to exit in two dataset?(eg District Hospital and Health center)?

Sound good, doc. We can discuss that Monday morning

On 16 Sep 2011 15:47, “Arthur Heywood” arthurheywood@gmail.com wrote:

Mahundi et al
Can we not apply this to OUR Tanzania data elements, which have different

data elements for IPD and OPD , acute and chronic

Working with different data elements with same meaning is driving me MAD
e.g. 70 (or more) examples such as

  • Diabetes Mellitus (ear infection acute, ear infection chronic etc etc

etc ) in OPD

  • Diabetes Mellitus ( etc) in IPD

Why can we not have the same disease in two separate datasets??

Is it not possible to combine these?

Regards

Arthur

On 16 September 2011 14:22, Jason Pickering jason.p.pickering@gmail.comwrote:

This is totally possible. You may have the same data element being

collected on two separate aggregation forms. Instead of creating two
data elements to represent the same thing, you just need to place the
same data element in two separate datasets. If you have "Total

attendance" at both the Hospital and Health center level, then you
might have two sepererate datasets (Hospital and PHC), with some data
elements which are different, some which are common.

Best practice is to try and consolidate as many data elements as you
can across the different service levels, as in practice, we have seen
that they may be named differently at different service levels, but

actually represent the same occurrence.

Regards,
Jason

On Fri, Sep 16, 2011 at 12:19 PM, Muhire Andrew muhireandrew@yahoo.com >> wrote:

Dear team,
I can see its possible to link one data element to two or
more
different dataset, Did this affect anything? eg one data element exit in

both District Hospital and Health Center? can this affect the database?
Data
entry? is it practical?


Muhire Andrew
HMIS/Ministry of Health
andrew.muhire@moh.gov.rw
God is my provider.


From: Lars Helge Øverland larshelge@gmail.com
To: nsanzumuhire venuste vensanze@yahoo.fr

Cc: Knut Staring knutst@gmail.com; Muhire Andrew <
muhireandrew@yahoo.com>;
dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola

Hodne Titlestad olati@ifi.uio.no; “dhis2-devs@lists.launchpad.net
dhis2-devs@lists.launchpad.net

Sent: Thursday, September 15, 2011 9:30 AM
Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?

Hi,
most operations are cached at the database layer so when doing manual

database operations outside dhis you will need to either restart the
application or clear the cache by going to “adminstration” → “cache
statistics” and clicking “clear cache”.

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


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


Quality is not an act … It is a Habit (Aristotle)
Skype arthur_heywood_za
Tanzania +255-773-669393
SA +27-769405494


You received this message because you are subscribed to the Google
Groups “UDSM_HMIS_Team” group.
To post to this group, send email to udsm_hmis_team@googlegroups.com

To unsubscribe from this group, send email to
udsm_hmis_team+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/udsm_hmis_team?hl=en

Dear Arther, i think you have to consider data element category since you are talking about OPD and IPD.This can differ depending on their categories. (Make sure they all have same category eg Age is the same,Gender the same). Because most of the data element are the same but
differ when you see their categories.

···

Muhire Andrew

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.


From: Jason Pickering jason.p.pickering@gmail.com
To: arthur@hisp.org
Cc: udsm_hmis_team udsm_hmis_team@googlegroups.com; Muhire Andrew muhireandrew@yahoo.com; “dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola Hodne Titlestad olati@ifi.uio.no
Sent: Friday, September 16, 2011 2:53 PM
Subject: Re: [Dhis2-users] [Dhis2-devs] Is it practical for one data element to exit in two dataset?(eg District Hospital and Health center)?

Arthur,
Why not have a single data element for

Diabetes Mellitus

with category option combination

(Inpatient/Outpatient)/(ear infection acute, ear infection chronic etc etc etc)

and only have certain data element/category options in the IP form and
certain data element/category options in the OPD form?

Regards,
Jason

On Fri, Sep 16, 2011 at 2:47 PM, Arthur Heywood arthurheywood@gmail.com wrote:

Mahundi et al
Can we not apply this to OUR Tanzania data elements, which have different
data elements for IPD and OPD , acute and chronic
Working with different data elements with same meaning is driving me MAD
e.g. 70 (or more) examples such as

Diabetes Mellitus (ear infection acute, ear infection chronic etc etc etc )
in OPD
Diabetes Mellitus ( etc) in IPD

Why can we not have the same disease in two separate datasets??
Is it not possible to combine these?
Regards
Arthur
On 16 September 2011 14:22, Jason Pickering jason.p.pickering@gmail.com > wrote:

This is totally possible. You may have the same data element being
collected on two separate aggregation forms. Instead of creating two
data elements to represent the same thing, you just need to place the
same data element in two separate datasets. If you have “Total
attendance” at both the Hospital and Health center level, then you
might have two sepererate datasets (Hospital and PHC), with some data
elements which are different, some which are common.

Best practice is to try and consolidate as many data elements as you
can across the different service levels, as in practice, we have seen
that they may be named differently at different service levels, but
actually represent the same occurrence.

Regards,
Jason

On Fri, Sep 16, 2011 at 12:19 PM, Muhire Andrew muhireandrew@yahoo.com >> wrote:

Dear team,
I can see its possible to link one data element to two or
more
different dataset, Did this affect anything? eg one data element exit
in
both District Hospital and Health Center? can this affect the database?
Data
entry? is it practical?


Muhire Andrew
HMIS/Ministry of Health
andrew.muhire@moh.gov.rw
God is my provider.


From: Lars Helge Øverland larshelge@gmail.com
To: nsanzumuhire venuste vensanze@yahoo.fr
Cc: Knut Staring knutst@gmail.com; Muhire Andrew
muhireandrew@yahoo.com;
dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola
Hodne Titlestad olati@ifi.uio.no; “dhis2-devs@lists.launchpad.net
dhis2-devs@lists.launchpad.net
Sent: Thursday, September 15, 2011 9:30 AM
Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?

Hi,
most operations are cached at the database layer so when doing manual
database operations outside dhis you will need to either restart the
application or clear the cache by going to “adminstration” → “cache
statistics” and clicking “clear cache”.

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


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


Quality is not an act … It is a Habit (Aristotle)
Skype arthur_heywood_za
Tanzania +255-773-669393
SA +27-769405494

Hi Jason and Andrew

Your advice is the right and logical one BUT … for some reason best known to the Tanzania HMIS … we have DIFFERENT age groups for inpatients and outpatients …

We database developers have allowed ourselves to be talked into different age categories for IPD and OPD “in order to please everybody” “so they will all use our database” … and have landed up with a proper camel ( horse designed by a committee) with everyones bits and pieces tagged on

By accepting that we are stuck with this confusion for the lifetime of our database … and that is what we need to find a solution to!

Regards

Arthur

···

On 16 September 2011 15:59, Muhire Andrew muhireandrew@yahoo.com wrote:

Dear Arther, i think you have to consider data element category since you are talking of OPD and IPD.This can differ depending on their categories. (Make sure they all have same category eg Age is the same,Gender the same). Because most of the data element are the same but differ when you see their categories.


*Muhire Andrew
*

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.


From: Masoud Mahundi mmahundi97@gmail.com

To: udsm_hmis_team@googlegroups.com
Cc:dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Muhire Andrew muhireandrew@yahoo.com; Ola Hodne Titlestad olati@ifi.uio.no; Jason Pickering jason.p.pickering@gmail.com

Sent: Friday, September 16, 2011 2:50 PM
Subject: Re: [udsm_hmis_team] Re: [Dhis2-users] [Dhis2-devs] Is it practical for one data element to exit in two dataset?(eg District Hospital and Health center)?

Sound good, doc. We can discuss that Monday morning

On 16 Sep 2011 15:47, “Arthur Heywood” arthurheywood@gmail.com wrote:

Mahundi et al
Can we not apply this to OUR Tanzania data elements, which have different

data elements for IPD and OPD , acute and chronic

Working with different data elements with same meaning is driving me MAD
e.g. 70 (or more) examples such as

  • Diabetes Mellitus (ear infection acute, ear infection chronic etc etc

etc ) in OPD

  • Diabetes Mellitus ( etc) in IPD

Why can we not have the same disease in two separate datasets??

Is it not possible to combine these?

Regards

Arthur

On 16 September 2011 14:22, Jason Pickering jason.p.pickering@gmail.comwrote:

This is totally possible. You may have the same data element being

collected on two separate aggregation forms. Instead of creating two
data elements to represent the same thing, you just need to place the
same data element in two separate datasets. If you have "Total

attendance" at both the Hospital and Health center level, then you
might have two sepererate datasets (Hospital and PHC), with some data
elements which are different, some which are common.

Best practice is to try and consolidate as many data elements as you
can across the different service levels, as in practice, we have seen
that they may be named differently at different service levels, but

actually represent the same occurrence.

Regards,
Jason

On Fri, Sep 16, 2011 at 12:19 PM, Muhire Andrew muhireandrew@yahoo.com > > > >> wrote:

Dear team,
I can see its possible to link one data element to two or
more
different dataset, Did this affect anything? eg one data element exit in

both District Hospital and Health Center? can this affect the database?
Data
entry? is it practical?


Muhire Andrew
HMIS/Ministry of Health
andrew.muhire@moh.gov.rw
God is my provider.


From: Lars Helge Øverland larshelge@gmail.com
To: nsanzumuhire venuste vensanze@yahoo.fr

Cc: Knut Staring knutst@gmail.com; Muhire Andrew <
muhireandrew@yahoo.com>;

dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; Ola

Hodne Titlestad olati@ifi.uio.no; “dhis2-devs@lists.launchpad.net

dhis2-devs@lists.launchpad.net

Sent: Thursday, September 15, 2011 9:30 AM
Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?

Hi,
most operations are cached at the database layer so when doing manual

database operations outside dhis you will need to either restart the
application or clear the cache by going to “adminstration” → “cache
statistics” and clicking “clear cache”.

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


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


Quality is not an act … It is a Habit (Aristotle)
Skype arthur_heywood_za
Tanzania +255-773-669393

SA +27-769405494


You received this message because you are subscribed to the Google
Groups “UDSM_HMIS_Team” group.
To post to this group, send email to udsm_hmis_team@googlegroups.com

To unsubscribe from this group, send email to
udsm_hmis_team+unsubscribe@googlegroups.com
For more options, visit this group at

http://groups.google.com/group/udsm_hmis_team?hl=en


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


Quality is not an act … It is a Habit (Aristotle)
Skype arthur_heywood_za
Tanzania +255-773-669393
SA +27-769405494

Hi Arthur,

If you have seen some of my mails over the past few months (years
actually), I have been a big critic of the implementation of data
element categories. It has been raised before that the disaggregation
is not an intrinsic property of the data element. There could be a
valid reason why the same data element is disaggregated differently in
some situations than others, and we should not have to tell the M&E
folks they cannot do it, simply because DHIS has a slightly different
(and I think incorrect) model. And of course, we all know that the
disaggregations can change over time. We know the M&E folks love to
create different disaggregations, so it is not really up to us to tell
them whether they are right or not, but rather try and model what is
actually happening.

In your case, I think you can create two separate data elements "IPD"
and "OPD" and apply two separate category combinations, and then
follow this up with an indicator which would combine the two data
elements to get the total.

The other possibility would be to create a single element and
disaggregate by all possible combinations of categories, and then use
the "Grey field management" or "Custom forms" to determine which of
the data element/category options actually get displayed to the user.
The problem arises however in the category model, that each of the
categories must add up to a total. So, if you have age groups which
intersect, say 0-1 and 0-5, and data is entered in both of them (which
should not be your case, as you would either enter IPD or OPD age
disaggregations for a single facility), the totals are going to get
messed up. We have used this approach in Zambia to deal with when
category options change over time, but in a very specific situation.
Previously we have 0-5 and 5+, but this was changed to Under 1, 1-5,
and 5+. However (as you well know) there was a switch at a certain
point in time when the disaggregations changed, and therefore, there
should never be any overlapping data. In our situation, we know we
should never have data for the same period and facility with both 0-1
and 0-5, so application of the category model (whereby it assumes that
each of the category options add up to a total), will work, but it is
risky.

The current category implementation works in many situations, but the
association between data element, instead of dataset, is probably one
which needs to be revisited.

Regards,
jason

···

On Sat, Sep 17, 2011 at 7:34 PM, Arthur Heywood <arthurheywood@gmail.com> wrote:

Hi Jason and Andrew
Your advice is the right and logical one BUT .... for some reason best known
to the Tanzania HMIS ... we have DIFFERENT age groups for inpatients and
outpatients ......
We database developers have allowed ourselves to be talked into different
age categories for IPD and OPD "in order to please everybody" "so they will
all use our database" ... and have landed up with a proper camel ( horse
designed by a committee) with everyones bits and pieces tagged on
By accepting that we are stuck with this confusion for the lifetime of our
database ..... and that is what we need to find a solution to!
Regards
Arthur

On 16 September 2011 15:59, Muhire Andrew <muhireandrew@yahoo.com> wrote:

Dear Arther, i think you have to consider data element category since you
are talking of OPD and IPD.This can differ depending on their categories.
(Make sure they all have same category eg Age is the same,Gender the same).
Because most of the data element are the same but differ when you see their
categories.

________________________________

Muhire Andrew
HMIS/Ministry of Health
andrew.muhire@moh.gov.rw
God is my provider.

________________________________
From: Masoud Mahundi <mmahundi97@gmail.com>
To: udsm_hmis_team@googlegroups.com
Cc: "dhis2-users@lists.launchpad.net" <dhis2-users@lists.launchpad.net>;
Muhire Andrew <muhireandrew@yahoo.com>; Ola Hodne Titlestad
<olati@ifi.uio.no>; Jason Pickering <jason.p.pickering@gmail.com>
Sent: Friday, September 16, 2011 2:50 PM
Subject: Re: [udsm_hmis_team] Re: [Dhis2-users] [Dhis2-devs] Is it
practical for one data element to exit in two dataset?(eg District Hospital
and Health center)?

Sound good, doc. We can discuss that Monday morning
On 16 Sep 2011 15:47, "Arthur Heywood" <arthurheywood@gmail.com> wrote:
> Mahundi et al
> Can we not apply this to OUR Tanzania data elements, which have
> different
> data elements for IPD and OPD , acute and chronic
>
> Working with different data elements with same meaning is driving me MAD
> e.g. 70 (or more) examples such as
>
> - Diabetes Mellitus (ear infection acute, ear infection chronic etc etc
> etc ) in OPD
> - Diabetes Mellitus ( etc) in IPD
>
> *Why can we not have the same disease in two separate datasets??*
>
> Is it not possible to combine these?
>
> Regards
> Arthur
>
> On 16 September 2011 14:22, Jason Pickering >> > <jason.p.pickering@gmail.com>wrote:
>
>> This is totally possible. You may have the same data element being
>> collected on two separate aggregation forms. Instead of creating two
>> data elements to represent the same thing, you just need to place the
>> same data element in two separate datasets. If you have "Total
>> attendance" at both the Hospital and Health center level, then you
>> might have two sepererate datasets (Hospital and PHC), with some data
>> elements which are different, some which are common.
>>
>> Best practice is to try and consolidate as many data elements as you
>> can across the different service levels, as in practice, we have seen
>> that they may be named differently at different service levels, but
>> actually represent the same occurrence.
>>
>> Regards,
>> Jason
>>
>>
>> On Fri, Sep 16, 2011 at 12:19 PM, Muhire Andrew >> >> <muhireandrew@yahoo.com> >> >> wrote:
>> > Dear team,
>> > I can see its possible to link one data element to two or
>> more
>> > different dataset, Did this affect anything? eg one data element exit
>> > in
>> > both District Hospital and Health Center? can this affect the
>> > database?
>> Data
>> > entry? is it practical?
>> >
>> >
>> >
>> > ________________________________
>> >
>> > Muhire Andrew
>> > HMIS/Ministry of Health
>> > andrew.muhire@moh.gov.rw
>> > God is my provider.
>> >
>> > ________________________________
>> > From: Lars Helge Øverland <larshelge@gmail.com>
>> > To: nsanzumuhire venuste <vensanze@yahoo.fr>
>> > Cc: Knut Staring <knutst@gmail.com>; Muhire Andrew <
>> muhireandrew@yahoo.com>;
>> > "dhis2-users@lists.launchpad.net" <dhis2-users@lists.launchpad.net>;
>> > Ola
>> > Hodne Titlestad <olati@ifi.uio.no>; "dhis2-devs@lists.launchpad.net"
>> > <dhis2-devs@lists.launchpad.net>
>> > Sent: Thursday, September 15, 2011 9:30 AM
>> > Subject: Re: [Dhis2-users] Re : Dear Dhis2 users how can i delete?
>> >
>> > Hi,
>> > most operations are cached at the database layer so when doing manual
>> > database operations outside dhis you will need to either restart the
>> > application or clear the cache by going to "adminstration" -> "cache
>> > statistics" and clicking "clear cache".
>> >
>> > Lars
>> >
>> >
>> > _______________________________________________
>> > 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
>> >
>> >
>>
>> _______________________________________________
>> 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
>>
>
>
>
> --
> *Quality is not an act .... It is a Habit* (Aristotle)
> Skype arthur_heywood_za
> Tanzania +255-773-669393
> SA +27-769405494
>
> --
> You received this message because you are subscribed to the Google
> Groups "UDSM_HMIS_Team" group.
> To post to this group, send email to udsm_hmis_team@googlegroups.com
> To unsubscribe from this group, send email to
> udsm_hmis_team+unsubscribe@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/udsm_hmis_team?hl=en

_______________________________________________
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

--
Quality is not an act .... It is a Habit (Aristotle)
Skype arthur_heywood_za
Tanzania +255-773-669393
SA +27-769405494

_______________________________________________
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

Dear all,

I 'd like to implement DHIS2-live in a community based program in a health district setting.

For this program i need to use a name based information tool. When i want to data entry into a program stage it appears not possible to enter and save data in any data element of the form; this message appears “operation failed-internal server error java.lang.NullPointerException: the error details are logged”

What can i do know to solve this bugg.

Thanks any one for helping me

Alain

Burkina Faso

Alain KABORE, MPH

*I**H Specialist, *

HIS Specialist

Program Officer

Family Care International

Burkina Faso

Tel/Fax: 50 36 93 58

Mobile: 70 26 70 43

78 39 83 26

Skype: alainkabore

···

De : Muhire Andrew muhireandrew@yahoo.com
À : Knut Staring knutst@gmail.com; Lars Helge Øverland larshelge@gmail.com
Cc :dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net; “dhis2-devs@lists.launchpad.netdhis2-devs@lists.launchpad.net
Envoyé le : Lundi 12 Septembre 2011 13h09
Objet : Re: [Dhis2-users] [Dhis2-devs] Dear Dhis2 users how can i delete?

Thank you all,

Great Knut its rilly good to select first and then delete because it can cause problems in case i delete the needed data.


Muhire Andrew

HMIS/Ministry of Health

andrew.muhire@moh.gov.rw

God is my provider.


From: Knut Staring knutst@gmail.com
To: Lars Helge Øverland larshelge@gmail.com
Cc: Muhire Andrew muhireandrew@yahoo.com; dhis2-users@lists.launchpad.net; dhis2-devs@lists.launchpad.net
Sent: Monday, September 12, 2011 3:56 PM
Subject: Re: [Dhis2-devs] Dear Dhis2 users how can i delete?

As a rule of thumb, it is usually wise to do a SELECT before a DELETE, so that you are 100% sure you are not deleting data you really need.

In this case:

select * from datavalue_audit where dataelementid=;

select * from datavalue where dataelementid=;

Knut

2011/9/12 Lars Helge Øverland larshelge@gmail.com

Hi Andrew,

you need to remove the data with SQL in the database. Run:

delete from datavalue_audit where dataelementid=;

delete from datavalue where dataelementid=;

and replace with the dataelementid of the one you want to remove.

You can then go ahead and delete the data element in the user interface.

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


Knut Staring

Informatics, U. of Oslo

http://hisp.uio.no

+4791880522


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

Dear all,

I 'd like to implement DHIS2-live in a community based program in a health district setting.

For this program i need to use a name based information tool. When i want to data entry into a program stage it appears not possible to enter and save data in any data element of the form; this message appears “operation failed-internal server error java.lang.NullPointerException: the error details are logged”

What can i do know to solve this bugg.

Thanks any one for helping me

Alain

Burkina Faso

Hello Alain,

Please go to Help → About DHIS2 and tell us which version and build revision you are using.

Also, please go into the log folder and send us the latest log.

Knut

···

2011/10/3 alain kabore alainkab2002@yahoo.fr

Dear all,

I 'd like to implement DHIS2-live in a community based program in a health district setting.

For this program i need to use a name based information tool. When i want to data entry into a program stage it appears not possible to enter and save data in any data element of the form; this message appears “operation failed-internal server error java.lang.NullPointerException: the error details are logged”

What can i do know to solve this bugg.

Thanks any one for helping me

Alain

Burkina Faso


Knut Staring

Informatics, U. of Oslo

http://hisp.uio.no

+4791880522