← Back to team overview

dhis2-devs team mailing list archive

Re: Importing Organisation Units with groups

 

Thanks Calle, for helping.

On Fri, Apr 27, 2018 at 4:15 PM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
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@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
>>> <https://maps.google.com/?q=46D+Alma+Road,+7700+Rosebank,+SOUTH+AFRICA&entry=gmail&source=g>
>>>
>>> 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
>> <https://maps.google.com/?q=46D+Alma+Road,+7700+Rosebank,+SOUTH+AFRICA&entry=gmail&source=g>
>>
>> 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
> <https://maps.google.com/?q=46D+Alma+Road,+7700+Rosebank,+SOUTH+AFRICA&entry=gmail&source=g>
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>


-- 
Regards,
Leke Seweje

References