Problem selecting a parent org. unit for a unit

Hi,

On DHIS2, I have set up an organisational structure with 5 levels. The admin user is assigned to ROOT Organisation Unit.

Later, I assigned the admin to Level 4 Org. Unit and unselected the Root Org. Unit.

The admin can now only see or access, the Org. Unit assigned and the ones nested below.

How can I re-assign the user to Root Organisation Unit ??

I am using DHIS version 2.22

Any suggestions??

Thanks & Regards,

···

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

I think you will have to do that directly in the database.

···

On Thu, Jan 21, 2016 at 2:01 PM, Archana Chillala archanac@thoughtworks.com wrote:

Hi,

On DHIS2, I have set up an organisational structure with 5 levels. The admin user is assigned to ROOT Organisation Unit.

Later, I assigned the admin to Level 4 Org. Unit and unselected the Root Org. Unit.

The admin can now only see or access, the Org. Unit assigned and the ones nested below.

How can I re-assign the user to Root Organisation Unit ??

I am using DHIS version 2.22

Any suggestions??

Thanks & Regards,

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks


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

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Hi Archana,

You can try patching the database with something like the following, then either restart DHIS 2 (restart Tomcat), or go to Apps → Data Administration → Cache Statistics → Clear cache

insert into usermembership (organisationunitid, userinfoid) values (

(select organisationunitid from organisationunit where parentid is null),

(select userid from users where username = ‘admin’) );

This should result in admin being assigned to both the root and the Level 4 org unit. You can then go in and unassign the level 4 org unit if you like.

Cheers,

Jim

···

On Thu, Jan 21, 2016 at 8:16 AM, Knut Staring knutst@gmail.com wrote:

I think you will have to do that directly in the database.


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

On Thu, Jan 21, 2016 at 2:01 PM, Archana Chillala archanac@thoughtworks.com wrote:

Hi,

On DHIS2, I have set up an organisational structure with 5 levels. The admin user is assigned to ROOT Organisation Unit.

Later, I assigned the admin to Level 4 Org. Unit and unselected the Root Org. Unit.

The admin can now only see or access, the Org. Unit assigned and the ones nested below.

How can I re-assign the user to Root Organisation Unit ??

I am using DHIS version 2.22

Any suggestions??

Thanks & Regards,

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks


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

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Hi Achana,

Have you tried going to Users, then users by Users by Org Unit then click the admin user and select edit. Then select the org root OU.

Regards,

BlackBerry: 3114F90C Phone: 08028851441, 08035560463 emails: deemoyes@yahoo.com, addyraph@yahoo.com Yahoo IM: deemoyes Facebook: pharael twitter:pharaell

···

On Thursday, January 21, 2016 2:01 PM, Archana Chillala archanac@thoughtworks.com wrote:

Hi,

On DHIS2, I have set up an organisational structure with 5 levels. The admin user is assigned to ROOT Organisation Unit.

Later, I assigned the admin to Level 4 Org. Unit and unselected the Root Org. Unit.

The admin can now only see or access, the Org. Unit assigned and the ones nested below.

How can I re-assign the user to Root Organisation Unit ??

I am using DHIS version 2.22

Any suggestions??

Thanks & Regards,

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks


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

Thanks everyone for your responses. I tried the sql command suggested by Jim, and it worked!

Cheers

···

On Thu, Jan 21, 2016 at 7:04 PM, Dayo Adeyomoye deemoyes@yahoo.com wrote:

Hi Achana,

Have you tried going to Users, then users by Users by Org Unit then click the admin user and select edit. Then select the org root OU.

Regards,

BlackBerry: 3114F90C Phone: 08028851441, 08035560463 emails: deemoyes@yahoo.com, addyraph@yahoo.com Yahoo IM: deemoyes Facebook: pharael twitter:pharaell

On Thursday, January 21, 2016 2:01 PM, Archana Chillala archanac@thoughtworks.com wrote:

Hi,

On DHIS2, I have set up an organisational structure with 5 levels. The admin user is assigned to ROOT Organisation Unit.

Later, I assigned the admin to Level 4 Org. Unit and unselected the Root Org. Unit.

The admin can now only see or access, the Org. Unit assigned and the ones nested below.

How can I re-assign the user to Root Organisation Unit ??

I am using DHIS version 2.22

Any suggestions??

Thanks & Regards,

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks


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

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks