DHIS v2.8 database design

Dear All,

I am designing a new database on DHIS v2.8 and I need help with the organization unit structure. The database am building is for an organization (NGO) with offices in 2 provinces but they have projects spread across several provinces and districts.

Will it be okay to represent only the two offices in the organization unit and then create a data element group/category for the other locations where they have projects OR should I have all the locations in the organization unit even though the NGO does not have physical offices at those places. Please advice.

Thanks,

Ese

···

On Sun, Jun 17, 2012 at 11:48 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Thanks all of your mail.

Yes Jason, I want to create installer for both Offline dhis2 for UBUNTU and also for a server update DHIS2.

Thanks BOB, I am trying to follow your documents and using BirtRock.

Thanks

Best Regards

Fatema Uddin

On Fri, Jun 15, 2012 at 12:28 AM, Bob Jolliffe bobjolliffe@gmail.com wrote:

Yes i made a deb some time ago … it is still there in trunk under

resources, tools or something. Works ok but I think now it is

actually the wrong approach. As is the bitrock one probably, assuming

you are doing a server install.

For a server deb I think you need something really small and simple,

modelled after the tomcat7-user deb, which has in addition:

  1. simple guided setup script resulting in correct server.xml and

hibernate.properties file

  1. some simple wget/curl based scripts for downloading latest war files

  2. some basic pg and/or mysql backup scripts

  3. possibly some templates for apache2 and/or nginx proxying

  4. any other useful odds and ends that we find ourselves doing over

and over (eg. sql script data integrity checks)

On 14 June 2012 19:03, Knut Staring knutst@gmail.com wrote:

There has also been some experimentation on making a .deb, but I’m not sure

of the status.

Sent from my mobile

On Jun 14, 2012 7:36 PM, “Jason Pickering” jason.p.pickering@gmail.com > > > > > wrote:

There is an experimental installer using BitRock, which is in trunk. In

theory it is cross platform, but I am not sure it has ever been tested on

Ubuntu. Because of the multiple different ways of installing DHIS2, we have

never really managed to get a single one-click installer built, although you

might consider using/modifying for your particular circumstances.

There are however detailed installation instructions for Ubuntu in the

documentation.

Are you performing offline installs of DHIS2 on Ubuntu or is this for a

server?

Best regards,

Jason

Sent from my mobile

On Jun 14, 2012 1:51 PM, “Uddin Fatema” fatemacse@gmail.com wrote:

Hi All,

We need a DHIS2 installer for UBUNTU 11.04 OS. Is anybody there who

already create it?

It will be really helpful for us.

Advance Thanks to all.

Best Regards

Fatema Uddin


Computer Programmer HMIS

Support to the Sector Programme Health (HNPSP)

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

Office location:

Monitoring & Evaluation Unit

Ministry of Health and Family Welfare

Janashankha Bhaban (2nd Floor), Azimpur

Dhaka 1205, Bangladesh

Phone: +880 2 966 53 13

Fax: +880 2 966 53 14


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


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


Fatema Uddin ----------------------------------------

Computer Programmer HMIS

Support to the Sector Programme Health (HNPSP)

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

Office location:

Monitoring & Evaluation Unit

Ministry of Health and Family Welfare

Janashankha Bhaban (2nd Floor), Azimpur

Dhaka 1205, Bangladesh

Phone: +880 2 966 53 13

Fax: +880 2 966 53 14


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

If am not wrong, since data will be analysed or needed based on the location where we find the projects, i would suggest to have the whole heirachy that we find the projects and am sure that each office supervise a certain catchment area which can be assigned to it. And someone at those 2 offices can select org. unit where the data comes from(project).(The decision can come from the way you will do your analysis , if it will be on the project level or office level with aggregated data from catchment area).

Thanks!

···

Muhire Andrew

HMIS/Ministry of Health

First say to yourself what you would be; and then do what you have to do..


From: Ese Egerega ese@cis.com.ng
To: dhis2-users@lists.launchpad.net
Sent: Sunday, June 17, 2012 10:09 PM
Subject: [Dhis2-users] DHIS v2.8 database design

Dear All,

I am designing a new database on DHIS v2.8 and I need help with the organization unit structure. The database am building is for an organization (NGO) with offices in 2 provinces but they have projects spread across several provinces and districts.

Will it be okay to represent only the two offices in the organization unit and then create a data element group/category for the other locations where they have projects OR should I have all the locations in the organization unit even though the NGO does not have physical offices at those places. Please advice.

Thanks,

Ese

On Sun, Jun 17, 2012 at 11:48 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

Thanks all of your mail.

Yes Jason, I want to create installer for both Offline dhis2 for
UBUNTU and also for a server update DHIS2.

Thanks BOB, I am trying to follow your documents and using
BirtRock.

Thanks

Best Regards

Fatema Uddin

On Fri, Jun 15, 2012 at 12:28 AM, Bob Jolliffe bobjolliffe@gmail.com wrote:

Yes i made a deb some time ago … it is still there in trunk under

resources, tools or something. Works ok but I think now it is

actually the wrong approach. As is the bitrock one probably, assuming

you are doing a server install.

For a server deb I think you need something really small and simple,

modelled after the tomcat7-user deb, which has in addition:

  1. simple guided setup script resulting in correct server.xml and

hibernate.properties file

  1. some simple wget/curl based scripts for downloading latest war files

  2. some basic pg and/or mysql backup scripts

  3. possibly some templates for apache2 and/or nginx proxying

  4. any other useful odds and ends that we find ourselves doing over

and over (eg. sql script data integrity checks)

On 14 June 2012 19:03, Knut Staring knutst@gmail.com wrote:

There has also been some experimentation on making a .deb, but I’m not sure

of the status.

Sent from my mobile

On Jun 14, 2012 7:36 PM, “Jason Pickering” jason.p.pickering@gmail.com > > > > > wrote:

There is an experimental installer using BitRock, which is in trunk. In

theory it is cross platform, but I am not sure it has ever been tested on

Ubuntu. Because of the multiple different ways of installing DHIS2, we have

never really managed to get a single one-click installer built, although you

might consider using/modifying for your particular circumstances.

There are however detailed installation instructions for Ubuntu in the

documentation.

Are you performing offline installs of DHIS2 on Ubuntu or is this for a

server?

Best regards,

Jason

Sent from my mobile

On Jun 14, 2012 1:51 PM, “Uddin Fatema” fatemacse@gmail.com wrote:

Hi All,

We need a DHIS2 installer for UBUNTU 11.04 OS. Is anybody there who

already create it?

It will be really helpful for us.

Advance Thanks to all.

Best Regards

Fatema Uddin


Computer Programmer HMIS

Support to the Sector Programme Health (HNPSP)

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

Office location:

Monitoring & Evaluation Unit

Ministry of Health and Family Welfare

Janashankha Bhaban (2nd Floor), Azimpur

Dhaka 1205, Bangladesh

Phone: +880 2 966 53 13

Fax: +880 2 966 53 14


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


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


Fatema Uddin ----------------------------------------

Computer Programmer HMIS

Support to the Sector Programme Health (HNPSP)

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

Office
location:

Monitoring & Evaluation Unit

Ministry of Health and Family Welfare

Janashankha Bhaban (2nd Floor), Azimpur

Dhaka 1205, Bangladesh

Phone:
+880
2 966 53 13

Fax: +880
2 966 53 14


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

Hi Ese, it is hard to say for sure but based on your description of of
the context I support Andrew's recommendation - sounds like defining
everything as organisation units would be most feasible.

Lars