dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Felix,

the reason was that the parent was only supported in latest build and not
in 2.15. I have implemented this in 2.15 now. Please get the latest 2.15
from dhis2.org/downloads in 45 min.

regards,

Lars




On Mon, Jun 30, 2014 at 3:08 PM, Felix Obareh <fobareh@xxxxxxxxxxxxxx>
wrote:

> Hi?
>
> Did anybody figure out why I can't insert parentid into Database using csv
>
> Regards
> On 26 Jun 2014 17:22, "Felix Obareh" <fobareh@xxxxxxxxxxxxxx> wrote:
>
>> Adebusoye,
>>
>> I think the CSV structure has been predefined to affect the name, uid,
>> code,shortname,
>>
>> name,uid,code, parentid
>> "Ky","","","52"
>> "Gt","","","52"
>> "Li","","","52"
>> "Mo","","","52"
>> "Ni","","","52"
>> "Pa","","","52"
>>
>> Irregardless of the what i use as the forth variable the CSV still insert
>> into the  shortname column in the database for the parentid instead of the
>> ParentID column.
>>
>> Please advice
>>
>>
>> On Thu, Jun 26, 2014 at 4:38 PM, Adebusoye Anifalaje <busoye@xxxxxxxx>
>> wrote:
>>
>>> Hi Felix,
>>>
>>> From your CSV, it seems you are using the Parent UID. From my OU
>>> imports, it’s most likely you need the ParentID.
>>>
>>> Let’s know if this helps.
>>>
>>> Busoye
>>>
>>> On 26 Jun 2014, at 14:24, Felix Obareh <fobareh@xxxxxxxxxxxxxx> wrote:
>>>
>>> Lars,
>>>
>>> I have downloaded 2.15 Build Version 15175 i have the same experience as
>>> before;-
>>>
>>> Below is my sample CSV file:-
>>>
>>> name,uid,code,parent
>>> "ST","","","GM1aIUXHSZF"
>>> "UK","","","GM1aIUXHSZF"
>>> "LA","","","GM1aIUXHSZF"
>>> "MU","","","GM1aIUXHSZF"
>>> "NK","","","GM1aIUXHSZF"
>>> "PT","","","GM1aIUXHSZF"
>>>
>>> Please advice
>>>
>>> Regards
>>>
>>>
>>>
>>>
>>> On Thu, Jun 26, 2014 at 1:54 PM, Felix Obareh <fobareh@xxxxxxxxxxxxxx>
>>> wrote:
>>>
>>>> Lars,
>>>>
>>>> Thank you.
>>>>
>>>> Regards
>>>>
>>>>
>>>> On Thu, Jun 26, 2014 at 1:53 PM, Lars Helge Øverland <
>>>> larshelge@xxxxxxxxx> wrote:
>>>>
>>>>> Hi Felix,
>>>>>
>>>>> we actually fixed and back-ported this to 2.15 a few weeks ago. Could
>>>>> you please upgrade your DHIS instance to the latest 2.15 from
>>>>> dhis2.org/downloads?
>>>>>
>>>>> regards,
>>>>>
>>>>> Lars
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Jun 26, 2014 at 12:51 PM, Felix Obareh <fobareh@xxxxxxxxxxxxxx
>>>>> > wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I man trying import OrgUnits using CSV but it does not seem to pick
>>>>>> the parentid,
>>>>>>
>>>>>> I am using the example below from:-
>>>>>>  https://www.dhis2.org/doc/snapshot/en/user/html/ch21.html#d5e3351
>>>>>>
>>>>>> name,uid,code,parent
>>>>>> "West province","","WESTP","ImspTQPwCqd"
>>>>>> "East province","","EASTP","ImspTQPwCqd"
>>>>>>
>>>>>> ==========Result==========
>>>>>>
>>>>>> The problem is that the name, uid and the code insert correctly on my postgres database but the parent is inserted unto the shortname column
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> That happens even with even my test csv file.
>>>>>>
>>>>>> Please advice
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Obare Felix
>>>>>> Business Systems Director
>>>>>> SoftCall Communication |Software Engineering & Development| WHMCS
>>>>>> Automation <http://www.softcall.co.ke/>| Bulk SMS
>>>>>> <http://www.smartsms.co.ke/>| Shortcodes Systems
>>>>>> <http://www.smartsms.co.ke/>|
>>>>>>  General Conference Building Riverside Drive off
>>>>>> Chiromo Road Nxt to Australian High Commission :Tel
>>>>>> 254 20 3520010|Fax: 254 20 4440969  Cell: 254 733 730035 |254 720
>>>>>> 730035
>>>>>> www.softcall.co.ke | fobareh@xxxxxxxxxxxxxx   Yahoo Chat:
>>>>>> felondri@xxxxxxxxx|  Gchat:fobareh@xxxxxxxxxxxxxx| Skype:
>>>>>> softcallcom | Twitter: @smartsms_ke
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Obare Felix
>>>> Business Systems Director
>>>> SoftCall Communication |Software Engineering & Development| WHMCS
>>>> Automation <http://www.softcall.co.ke/>| Bulk SMS
>>>> <http://www.smartsms.co.ke/>| Shortcodes Systems
>>>> <http://www.smartsms.co.ke/>|
>>>>  General Conference Building Riverside Drive off
>>>> Chiromo Road Nxt to Australian High Commission :Tel
>>>> 254 20 3520010|Fax: 254 20 4440969  Cell: 254 733 730035 |254 720 730035
>>>> www.softcall.co.ke | fobareh@xxxxxxxxxxxxxx   Yahoo Chat:
>>>> felondri@xxxxxxxxx|  Gchat:fobareh@xxxxxxxxxxxxxx| Skype: softcallcom
>>>> | Twitter: @smartsms_ke
>>>>
>>>
>>>
>>>
>>> --
>>> Obare Felix
>>> Business Systems Director
>>> SoftCall Communication |Software Engineering & Development| WHMCS
>>> Automation <http://www.softcall.co.ke/>| Bulk SMS
>>> <http://www.smartsms.co.ke/>| Shortcodes Systems
>>> <http://www.smartsms.co.ke/>|
>>>  General Conference Building Riverside Drive off
>>> Chiromo Road Nxt to Australian High Commission :Tel
>>> 254 20 3520010|Fax: 254 20 4440969  Cell: 254 733 730035 |254 720 730035
>>> www.softcall.co.ke | fobareh@xxxxxxxxxxxxxx   Yahoo Chat:
>>> felondri@xxxxxxxxx|  Gchat:fobareh@xxxxxxxxxxxxxx| Skype: softcallcom |
>>> Twitter: @smartsms_ke
>>>  _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>>
>>
>>
>> --
>> Obare Felix
>> Business Systems Director
>> SoftCall Communication |Software Engineering & Development| WHMCS
>> Automation <http://www.softcall.co.ke>| Bulk SMS
>> <http://www.smartsms.co.ke>| Shortcodes Systems
>> <http://www.smartsms.co.ke>|
>>  General Conference Building Riverside Drive off
>> Chiromo Road Nxt to Australian High Commission :Tel
>> 254 20 3520010|Fax: 254 20 4440969  Cell: 254 733 730035 |254 720 730035
>> www.softcall.co.ke | fobareh@xxxxxxxxxxxxxx   Yahoo Chat:
>> felondri@xxxxxxxxx|  Gchat:fobareh@xxxxxxxxxxxxxx| Skype: softcallcom |
>> Twitter: @smartsms_ke
>>
>