Importing Organisation Units with groups

Hi all,
I am trying to import hundreds of org units with their groups.

Is there a CSV config sheet format that can be used for this?

Maybe I’d need to use ‘Organisation unit with group option’ on the CSV import page but I need the format of the config sheet. If so, can someone please share the config sheet for doing this?

If not, please share with me info on how I can automate importing org units with groups.

Thanks.

···

Regards,

Leke Seweje

Hi Leke,

You can find the format here:

https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_other_objects

···

On Fri, Apr 27, 2018 at 12:58 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Hi all,
I am trying to import hundreds of org units with their groups.

Is there a CSV config sheet format that can be used for this?

Maybe I’d need to use ‘Organisation unit with group option’ on the CSV import page but I need the format of the config sheet. If so, can someone please share the config sheet for doing this?

If not, please share with me info on how I can automate importing org units with groups.

Thanks.


Regards,

Leke Seweje


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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Thanks Knut,

I have been to this link before too but it does not show how to connect the org units with groups.

For example, an org unit ABC Hospital in org unit D.

I have so many org units and linking them manually to groups will take a lot of effort and time.

I hope you can give me more info on this.

Thanks.

···

On Fri, Apr 27, 2018 at 12:49 PM, Knut Staring knutst@gmail.com wrote:

Hi Leke,

You can find the format here:

https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_other_objects

On Fri, Apr 27, 2018 at 12:58 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Hi all,
I am trying to import hundreds of org units with their groups.

Is there a CSV config sheet format that can be used for this?

Maybe I’d need to use ‘Organisation unit with group option’ on the CSV import page but I need the format of the config sheet. If so, can someone please share the config sheet for doing this?

If not, please share with me info on how I can automate importing org units with groups.

Thanks.


Regards,

Leke Seweje


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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Regards,

Leke Seweje

Hi again,

You are right, sorry. It seems the manual is deficient on this point. My assumption is that the CSV format would be just: GroupUID, OrgUnitUID (or possibly the reverse order).

Unless anyone else knows better, perhaps you could give it a try with just one group and a couple of orgunits?

Knut

···

On Fri, Apr 27, 2018 at 3:43 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Thanks Knut,

I have been to this link before too but it does not show how to connect the org units with groups.

For example, an org unit ABC Hospital in org unit D.

I have so many org units and linking them manually to groups will take a lot of effort and time.

I hope you can give me more info on this.

Thanks.

On Fri, Apr 27, 2018 at 12:49 PM, Knut Staring knutst@gmail.com wrote:

Hi Leke,

You can find the format here:

https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_other_objects

Regards,

Leke Seweje

On Fri, Apr 27, 2018 at 12:58 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Hi all,
I am trying to import hundreds of org units with their groups.

Is there a CSV config sheet format that can be used for this?

Maybe I’d need to use ‘Organisation unit with group option’ on the CSV import page but I need the format of the config sheet. If so, can someone please share the config sheet for doing this?

If not, please share with me info on how I can automate importing org units with groups.

Thanks.


Regards,

Leke Seweje


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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Hello Leke,

I just did it now and my guess was right. As usual, the first row will be ignored, so you should have something like this (assigning 3 orgunits to the same group):

Group,OU

VlEZ3JbCBEp,kw32DaDxwk9

VlEZ3JbCBEp,xEuwGp9HvZg

VlEZ3JbCBEp,VvvUrFGaoL3

(It appears you will have to use UIDs like in my example, I don’t think it will match on Code or Name).

···

On Fri, Apr 27, 2018 at 3:55 PM, Knut Staring knutst@gmail.com wrote:

Hi again,

You are right, sorry. It seems the manual is deficient on this point. My assumption is that the CSV format would be just: GroupUID, OrgUnitUID (or possibly the reverse order).

Unless anyone else knows better, perhaps you could give it a try with just one group and a couple of orgunits?

Knut

On Fri, Apr 27, 2018 at 3:43 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Thanks Knut,

I have been to this link before too but it does not show how to connect the org units with groups.

For example, an org unit ABC Hospital in org unit D.

I have so many org units and linking them manually to groups will take a lot of effort and time.

I hope you can give me more info on this.

Thanks.


Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

On Fri, Apr 27, 2018 at 12:49 PM, Knut Staring knutst@gmail.com wrote:

Hi Leke,

You can find the format here:

https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_other_objects

Regards,

Leke Seweje

On Fri, Apr 27, 2018 at 12:58 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Hi all,
I am trying to import hundreds of org units with their groups.

Is there a CSV config sheet format that can be used for this?

Maybe I’d need to use ‘Organisation unit with group option’ on the CSV import page but I need the format of the config sheet. If so, can someone please share the config sheet for doing this?

If not, please share with me info on how I can automate importing org units with groups.

Thanks.


Regards,

Leke Seweje


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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Hi

Firstly, the support for importing group members (orgunits, data elements, indicators) in CSV format was introduced in 2.28 BUT as Knut points out, the related part of the developer manuals (1.16, CSV Meta data import) remains the same as it was in 2.27 and earlier.

Secondly, adding or removing OrgUnits from orgunitgroups using the normal User Interface is now broken in 2.28 and 2.29 (and trunk, presumably). You can open a group and select/unselect Orgunits, but SAVE is just greyed out. I’ve confirmed this local for both 2.28 and 2.29, and using the 2.28 SL demo (2.29 SL demo is not usable - admin/district no longer works). I’m writing a jira bug report for it.

Thirdly, i would presume - as Knut is also hinting at - that the CSV format is simple: Organsiationunit_uid, orgunitgroup_uid

Regards

Calle

···

On 27 April 2018 at 15:55, Knut Staring knutst@gmail.com wrote:

Hi again,

You are right, sorry. It seems the manual is deficient on this point. My assumption is that the CSV format would be just: GroupUID, OrgUnitUID (or possibly the reverse order).

Unless anyone else knows better, perhaps you could give it a try with just one group and a couple of orgunits?

Knut


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

On Fri, Apr 27, 2018 at 3:43 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Thanks Knut,

I have been to this link before too but it does not show how to connect the org units with groups.

For example, an org unit ABC Hospital in org unit D.

I have so many org units and linking them manually to groups will take a lot of effort and time.

I hope you can give me more info on this.

Thanks.


Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

On Fri, Apr 27, 2018 at 12:49 PM, Knut Staring knutst@gmail.com wrote:

Hi Leke,

You can find the format here:

https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_other_objects

Regards,

Leke Seweje

On Fri, Apr 27, 2018 at 12:58 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Hi all,
I am trying to import hundreds of org units with their groups.

Is there a CSV config sheet format that can be used for this?

Maybe I’d need to use ‘Organisation unit with group option’ on the CSV import page but I need the format of the config sheet. If so, can someone please share the config sheet for doing this?

If not, please share with me info on how I can automate importing org units with groups.

Thanks.


Regards,

Leke Seweje


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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


Hi

Re last point - I’ve just tested importing the simple Organsiationunit_uid, orgunitgroup_uid format, and that does NOT work - system seems to just disregard it (0 created, 0 updated, 0 ignored).

I also went back and checked the 2.28 release notes - they just point to the same 1.16 chapter in the manual, so there is no info there.

Anybody who knows what the correct CSV format is for importing orgunitgroupmembers, and ditto for data elements and indicators?

Regards

Calle

···

On 27 April 2018 at 16:52, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi

Firstly, the support for importing group members (orgunits, data elements, indicators) in CSV format was introduced in 2.28 BUT as Knut points out, the related part of the developer manuals (1.16, CSV Meta data import) remains the same as it was in 2.27 and earlier.

Secondly, adding or removing OrgUnits from orgunitgroups using the normal User Interface is now broken in 2.28 and 2.29 (and trunk, presumably). You can open a group and select/unselect Orgunits, but SAVE is just greyed out. I’ve confirmed this local for both 2.28 and 2.29, and using the 2.28 SL demo (2.29 SL demo is not usable - admin/district no longer works). I’m writing a jira bug report for it.

Thirdly, i would presume - as Knut is also hinting at - that the CSV format is simple: Organsiationunit_uid, orgunitgroup_uid

Regards

Calle

On 27 April 2018 at 15:55, Knut Staring knutst@gmail.com wrote:

Hi again,

You are right, sorry. It seems the manual is deficient on this point. My assumption is that the CSV format would be just: GroupUID, OrgUnitUID (or possibly the reverse order).

Unless anyone else knows better, perhaps you could give it a try with just one group and a couple of orgunits?

Knut


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


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Fri, Apr 27, 2018 at 3:43 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Thanks Knut,

I have been to this link before too but it does not show how to connect the org units with groups.

For example, an org unit ABC Hospital in org unit D.

I have so many org units and linking them manually to groups will take a lot of effort and time.

I hope you can give me more info on this.

Thanks.


Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

On Fri, Apr 27, 2018 at 12:49 PM, Knut Staring knutst@gmail.com wrote:

Hi Leke,

You can find the format here:

https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_other_objects

Regards,

Leke Seweje

On Fri, Apr 27, 2018 at 12:58 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Hi all,
I am trying to import hundreds of org units with their groups.

Is there a CSV config sheet format that can be used for this?

Maybe I’d need to use ‘Organisation unit with group option’ on the CSV import page but I need the format of the config sheet. If so, can someone please share the config sheet for doing this?

If not, please share with me info on how I can automate importing org units with groups.

Thanks.


Regards,

Leke Seweje


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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


Knut,

Seems our emails crossed - and are correct. The sequence is group then orgunit, not orgunit then group.

It’s noteworthy that swapping them around just fails silently - no error message in the option summary, not ignored, and the tomcat log messages are more or less identical…

There’s no support for using code or name

Regards

Calle

···

On 27 April 2018 at 17:03, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi

Re last point - I’ve just tested importing the simple Organsiationunit_uid, orgunitgroup_uid format, and that does NOT work - system seems to just disregard it (0 created, 0 updated, 0 ignored).

I also went back and checked the 2.28 release notes - they just point to the same 1.16 chapter in the manual, so there is no info there.

Anybody who knows what the correct CSV format is for importing orgunitgroupmembers, and ditto for data elements and indicators?

Regards

Calle

On 27 April 2018 at 16:52, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi

Firstly, the support for importing group members (orgunits, data elements, indicators) in CSV format was introduced in 2.28 BUT as Knut points out, the related part of the developer manuals (1.16, CSV Meta data import) remains the same as it was in 2.27 and earlier.

Secondly, adding or removing OrgUnits from orgunitgroups using the normal User Interface is now broken in 2.28 and 2.29 (and trunk, presumably). You can open a group and select/unselect Orgunits, but SAVE is just greyed out. I’ve confirmed this local for both 2.28 and 2.29, and using the 2.28 SL demo (2.29 SL demo is not usable - admin/district no longer works). I’m writing a jira bug report for it.

Thirdly, i would presume - as Knut is also hinting at - that the CSV format is simple: Organsiationunit_uid, orgunitgroup_uid

Regards

Calle


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On 27 April 2018 at 15:55, Knut Staring knutst@gmail.com wrote:

Hi again,

You are right, sorry. It seems the manual is deficient on this point. My assumption is that the CSV format would be just: GroupUID, OrgUnitUID (or possibly the reverse order).

Unless anyone else knows better, perhaps you could give it a try with just one group and a couple of orgunits?

Knut


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


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Fri, Apr 27, 2018 at 3:43 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Thanks Knut,

I have been to this link before too but it does not show how to connect the org units with groups.

For example, an org unit ABC Hospital in org unit D.

I have so many org units and linking them manually to groups will take a lot of effort and time.

I hope you can give me more info on this.

Thanks.


Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

On Fri, Apr 27, 2018 at 12:49 PM, Knut Staring knutst@gmail.com wrote:

Hi Leke,

You can find the format here:

https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_other_objects

Regards,

Leke Seweje

On Fri, Apr 27, 2018 at 12:58 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Hi all,
I am trying to import hundreds of org units with their groups.

Is there a CSV config sheet format that can be used for this?

Maybe I’d need to use ‘Organisation unit with group option’ on the CSV import page but I need the format of the config sheet. If so, can someone please share the config sheet for doing this?

If not, please share with me info on how I can automate importing org units with groups.

Thanks.


Regards,

Leke Seweje


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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


Thanks Knut, this works for me too.
Much appreciated.

···

On Fri, Apr 27, 2018 at 3:17 PM, Knut Staring knutst@gmail.com wrote:

Hello Leke,

I just did it now and my guess was right. As usual, the first row will be ignored, so you should have something like this (assigning 3 orgunits to the same group):

Group,OU

VlEZ3JbCBEp,kw32DaDxwk9

VlEZ3JbCBEp,xEuwGp9HvZg

VlEZ3JbCBEp,VvvUrFGaoL3

(It appears you will have to use UIDs like in my example, I don’t think it will match on Code or Name).

On Fri, Apr 27, 2018 at 3:55 PM, Knut Staring knutst@gmail.com wrote:

Hi again,

You are right, sorry. It seems the manual is deficient on this point. My assumption is that the CSV format would be just: GroupUID, OrgUnitUID (or possibly the reverse order).

Unless anyone else knows better, perhaps you could give it a try with just one group and a couple of orgunits?

Knut


Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

On Fri, Apr 27, 2018 at 3:43 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Thanks Knut,

I have been to this link before too but it does not show how to connect the org units with groups.

For example, an org unit ABC Hospital in org unit D.

I have so many org units and linking them manually to groups will take a lot of effort and time.

I hope you can give me more info on this.

Thanks.


Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

On Fri, Apr 27, 2018 at 12:49 PM, Knut Staring knutst@gmail.com wrote:

Hi Leke,

You can find the format here:

https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_other_objects

Regards,

Leke Seweje

On Fri, Apr 27, 2018 at 12:58 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Hi all,
I am trying to import hundreds of org units with their groups.

Is there a CSV config sheet format that can be used for this?

Maybe I’d need to use ‘Organisation unit with group option’ on the CSV import page but I need the format of the config sheet. If so, can someone please share the config sheet for doing this?

If not, please share with me info on how I can automate importing org units with groups.

Thanks.


Regards,

Leke Seweje


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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Regards,

Leke Seweje

Thanks Calle, for helping.

···

On Fri, Apr 27, 2018 at 4:15 PM, Calle Hedberg calle.hedberg@gmail.com wrote:

Knut,

Seems our emails crossed - and are correct. The sequence is group then orgunit, not orgunit then group.

It’s noteworthy that swapping them around just fails silently - no error message in the option summary, not ignored, and the tomcat log messages are more or less identical…

There’s no support for using code or name

Regards

Calle

On 27 April 2018 at 17:03, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi

Re last point - I’ve just tested importing the simple Organsiationunit_uid, orgunitgroup_uid format, and that does NOT work - system seems to just disregard it (0 created, 0 updated, 0 ignored).

I also went back and checked the 2.28 release notes - they just point to the same 1.16 chapter in the manual, so there is no info there.

Anybody who knows what the correct CSV format is for importing orgunitgroupmembers, and ditto for data elements and indicators?

Regards

Calle


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On 27 April 2018 at 16:52, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi

Firstly, the support for importing group members (orgunits, data elements, indicators) in CSV format was introduced in 2.28 BUT as Knut points out, the related part of the developer manuals (1.16, CSV Meta data import) remains the same as it was in 2.27 and earlier.

Secondly, adding or removing OrgUnits from orgunitgroups using the normal User Interface is now broken in 2.28 and 2.29 (and trunk, presumably). You can open a group and select/unselect Orgunits, but SAVE is just greyed out. I’ve confirmed this local for both 2.28 and 2.29, and using the 2.28 SL demo (2.29 SL demo is not usable - admin/district no longer works). I’m writing a jira bug report for it.

Thirdly, i would presume - as Knut is also hinting at - that the CSV format is simple: Organsiationunit_uid, orgunitgroup_uid

Regards

Calle


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On 27 April 2018 at 15:55, Knut Staring knutst@gmail.com wrote:

Hi again,

You are right, sorry. It seems the manual is deficient on this point. My assumption is that the CSV format would be just: GroupUID, OrgUnitUID (or possibly the reverse order).

Unless anyone else knows better, perhaps you could give it a try with just one group and a couple of orgunits?

Knut


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


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Fri, Apr 27, 2018 at 3:43 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Thanks Knut,

I have been to this link before too but it does not show how to connect the org units with groups.

For example, an org unit ABC Hospital in org unit D.

I have so many org units and linking them manually to groups will take a lot of effort and time.

I hope you can give me more info on this.

Thanks.


Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

On Fri, Apr 27, 2018 at 12:49 PM, Knut Staring knutst@gmail.com wrote:

Hi Leke,

You can find the format here:

https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_other_objects

Regards,

Leke Seweje

On Fri, Apr 27, 2018 at 12:58 PM, Olaleke Seweje sewejeolaleke@gmail.com wrote:

Hi all,
I am trying to import hundreds of org units with their groups.

Is there a CSV config sheet format that can be used for this?

Maybe I’d need to use ‘Organisation unit with group option’ on the CSV import page but I need the format of the config sheet. If so, can someone please share the config sheet for doing this?

If not, please share with me info on how I can automate importing org units with groups.

Thanks.


Regards,

Leke Seweje


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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Regards,

Leke Seweje