← Back to team overview

dhis2-devs team mailing list archive

Re: Importing Organisation Units with groups

 

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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx
>>> > 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@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Hi Leke,
>>>>>
>>>>> You can find the format here:
>>>>>
>>>>> https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_met
>>>>> adata_import.html#webapi_csv_other_objects
>>>>>
>>>>> On Fri, Apr 27, 2018 at 12:58 PM, Olaleke Seweje <
>>>>> sewejeolaleke@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>>>>> 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
>>>>
>>>
>>>
>>>
>>> --
>>> 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
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> 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@xxxxxxxxx
>>
>> Skype: calle_hedberg
>>
>> *******************************************
>>
>>
>
>
> --
>
> *******************************************
>
> 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@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>


-- 

*******************************************

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@xxxxxxxxx

Skype: calle_hedberg

*******************************************

Follow ups

References