Hi Jason,
Here is some bit of my post data.
{"organisationUnits":[{"name":"Wikithuki
Dispensary","uid":"Bc371uxfYD5","code":"16925","parent":"vpiZlB5cdK7","shortname":"Wikithuki
Dispensary","description":"","comment":"","featuretype":"POINT","coordinates":"[37.95263,-0.77819]","url":""},{"name":"Gemifa
Medical
Clinic","uid":"Z7Lf1n3Fcpi","code":"22907","parent":"mEZBjj4fLBT","shortname":"Gemifa","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.391914,0.059575]","url":""},{"name":"Olympus
Medical
Clinic","uid":"NAbQdHuaJFK","code":"22906","parent":"PeEcMfBchbr","shortname":"Olympus","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.3994,0.059575]","url":""},{"name":"Masaba
Community Health
Unit","uid":"tYwHeLSnHyb","code":"600616","parent":"QR2K4k8VKF1","shortname":"Masaba
CHU","description":"Community
Unit","comment":"","featuretype":"NONE","coordinates":"[34.46411,0.19358]","url":""},{"name":"Gatunga
Health Centre","uid":"cmay4WXRmhA","code":"12034","parent":
After changing the "uid" to "id", still it doesn't work.
Thank you
On Thu, Feb 15, 2018 at 12:14 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:
> Hi Isaiah,
>
> Post a bit of your JSON here from toJSON(list(organisationUnits=new_org),
> auto_unbox = TRUE)
>
> One other problem I noticed as well is this
>
> [{"name":"Wikithuki Dispensary","uid":"Bc371uxfYD5"
>
>
> It should be
>
> [{"name":"Wikithuki Dispensary","id":"Bc371uxfYD5"
>
>
> Regards,
> Jason
>
>
> On Thu, Feb 15, 2018 at 10:01 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
> wrote:
>
>> Hi Jason,
>>
>> I get an internal server error code: 500, after trying that. Here is the
>> response;
>>
>> httr::content(r, "text")[1] "{\"httpStatus\":\"Internal Server
>> Error\",\"httpStatusCode\":500,\"status\":\"ERROR\",\"message\":\"Can not
>> instantiate value of type [simple type, class
>> org.hisp.dhis.organisationunit.OrganisationUnit] from String value
>> ('It7fWcKbcZX'); no single-String constructor/factory method\\n at [Source:
>> org.apache.catalina.connector.CoyoteInputStream@1efec811; line: 1, column:
>> 73] (through reference chain:
>> org.hisp.dhis.organisationunit.OrganisationUnit[\\\"parent\\\"])\"}"
>>
>>
>> Thank you.
>>
>> On Thu, Feb 15, 2018 at 10:36 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Isiah,
>>>
>>> The reason for it not working (at least at first glance) is that you are
>>> posing to the /api/metadata endpoint. Thus, you need to tell the server
>>> what you are trying to import. In this case, its organisation units.
>>>
>>> I think changing this to
>>>
>>> r <- POST(url, authenticate(dest.user, dest.pass),
>>> body = toJSON(list(organisationUnits=new_org), auto_unbox =
>>> TRUE),
>>> content_type_json())
>>>
>>> should work.
>>>
>>> The example works because the file
>>> <https://raw.githubusercontent.com/jason-p-pickering/dhis2-data-munging/master/ous/ous.json>
>>> looks like this:
>>>
>>>
>>> {"created":"2016-08-10","organisationUnits":[{"id":"u6yjgvIMzKn",...
>>>
>>>
>>> Hope this helps and best regards,
>>>
>>> Jason
>>>
>>>
>>>
>>>
>>>
>>> On Thu, Feb 15, 2018 at 6:34 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com
>>> > wrote:
>>>
>>>>
>>>> Dear Jason and Dhis2 Community,
>>>>
>>>> I am following your guide on bootstrapping
>>>> <https://github.com/jason-p-pickering/dhis2-data-munging/blob/master/bootstrap/bootstrap.Rmd>
>>>> dhis2 with R while trying to import metadata using the API.
>>>>
>>>> I do not understand why my metadata is not imported. Here are my steps,
>>>> any help will be appreciated.
>>>>
>>>>
>>>> head(org) name uid code parent
>>>> shortname
>>>> 1 Wikithuki Dispensary Bc371uxfYD5 16925 vpiZlB5cdK7 Wikithuki
>>>> Dispensary
>>>> 2 Gemifa Medical Clinic Z7Lf1n3Fcpi 22907 mEZBjj4fLBT
>>>> Gemifa
>>>> 3 Olympus Medical Clinic NAbQdHuaJFK 22906 PeEcMfBchbr
>>>> Olympus
>>>> 4 Masaba Community Health Unit tYwHeLSnHyb 600616 QR2K4k8VKF1
>>>> Masaba CHU
>>>> 5 Gatunga Health Centre cmay4WXRmhA 12034 IcAegRcGuV6 Gatunga
>>>> Health Centre
>>>> 6 Cfw Kimangaru Clinic E52UsoBxJVS 11966 vEAFtHnPDrX CFW
>>>> Kimangaru Clinic
>>>> description openingdate closedate comment featuretype
>>>> coordinates url
>>>> 1 NA NA POINT
>>>> [37.95263,-0.77819]
>>>> 2 Clinic NA NA NONE
>>>> [34.391914,0.059575]
>>>> 3 Clinic NA NA NONE
>>>> [34.3994,0.059575]
>>>> 4 Community Unit NA NA NONE
>>>> [34.46411,0.19358]
>>>> 5 NA NA POINT
>>>> [37.9423,-0.29656]
>>>> 6 NA NA POINT
>>>> [37.53009,-0.54506]
>>>> contactperson address email phonenumber
>>>> 1 NA NA NA NA
>>>> 2 NA NA NA NA
>>>> 3 NA NA NA NA
>>>> 4 NA NA NA NA
>>>> 5 NA NA NA NA
>>>> 6 NA NA NA NA
>>>>
>>>>
>>>> I followed the following steps to prepare my df for import.
>>>> 1. Removed all the NAs and columns with entire NAs.
>>>>
>>>> head(new_org) name uid code parent
>>>> shortname
>>>> 1 Wikithuki Dispensary Bc371uxfYD5 16925 vpiZlB5cdK7 Wikithuki
>>>> Dispensary
>>>> 2 Gemifa Medical Clinic Z7Lf1n3Fcpi 22907 mEZBjj4fLBT
>>>> Gemifa
>>>> 3 Olympus Medical Clinic NAbQdHuaJFK 22906 PeEcMfBchbr
>>>> Olympus
>>>> 4 Masaba Community Health Unit tYwHeLSnHyb 600616 QR2K4k8VKF1
>>>> Masaba CHU
>>>> 5 Gatunga Health Centre cmay4WXRmhA 12034 IcAegRcGuV6 Gatunga
>>>> Health Centre
>>>> 6 Cfw Kimangaru Clinic E52UsoBxJVS 11966 vEAFtHnPDrX CFW
>>>> Kimangaru Clinic
>>>> description comment featuretype coordinates url
>>>> 1 POINT [37.95263,-0.77819]
>>>> 2 Clinic NONE [34.391914,0.059575]
>>>> 3 Clinic NONE [34.3994,0.059575]
>>>> 4 Community Unit NONE [34.46411,0.19358]
>>>> 5 POINT [37.9423,-0.29656]
>>>> 6 POINT [37.53009,-0.54506]
>>>>
>>>>
>>>> 3. Then post the data as follows.
>>>>
>>>> dest.url <- "http://localhost/dhis/";
>>>> url <- paste0(dest.url, "api/metadata?importStrategy=C
>>>> REATE&atomicMode=NONE")
>>>> r <- POST(url, authenticate(dest.user, dest.pass),
>>>> body = toJSON(new_org, auto_unbox = TRUE),
>>>> content_type_json())
>>>> assertthat::assert_that(r$status_code==200)
>>>>
>>>> 4. The body looks like.
>>>>
>>>> jsonlite::toJSON(me, auto_unbox = TRUE)[{"name":"Wikithuki
>>>> Dispensary","uid":"Bc371uxfYD5","code":"16925","parent":"vpiZlB5cdK7","shortname":"Wikithuki
>>>>
>>>> Dispensary","description":"","comment":"","featuretype":"POINT","coordinates":"[37.95263,-0.77819]","url":""},{"name":"Gemifa
>>>> Medical
>>>> Clinic","uid":"Z7Lf1n3Fcpi","code":"22907","parent":"mEZBjj4fLBT","shortname":"Gemifa","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.391914,0.059575]","url":""},{"name":"Olympus
>>>> Medical
>>>> Clinic","uid":"NAbQdHuaJFK","code":"22906","parent":"PeEcMfBchbr","shortname":"Olympus","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.3994,0.059575]","url":""},{"name":"Masaba
>>>> Community Health
>>>> Unit","uid":"tYwHeLSnHyb","code":"600616","parent":"QR2K4k8VKF1","shortname":"Masaba
>>>> CHU","description":"Community
>>>> Unit","comment":"","featuretype":"NONE","coordinates":"[34.46411,0.19358]","url":""},{"name":"Gatunga
>>>> Health
>>>> Centre","uid":"cmay4WXRmhA","code":"12034","parent":"IcAegRcGuV6","shortname":"Gatunga
>>>> Health
>>>> Centre","description":"","comment":"","featuretype":"POINT","coordinates":"[37.9423,-0.29656]","url":""},{"name":"Cfw
>>>> Kimangaru
>>>> Clinic","uid":"E52UsoBxJVS","code":"11966","parent":"vEAFtHnPDrX","shortname":"CFW
>>>> Kimangaru
>>>> Clinic","description":"","comment":"","featuretype":"POINT","coordinates":"[37.53009,-0.54506]","url":""}]
>>>>
>>>>
>>>> What could be the problem there? I get status 200 and still it doesn't
>>>> import.
>>>>
>>>>
>>>> Thank you
>>>>
>>>>
>>>> --
>>>> ------------------------------------------------------------
>>>> --------------------
>>>> Isaiah Nyabuto
>>>> +254 729 572 616
>>>> Bsc. Health Records Management & Informatics, JKUAT.
>>>>
>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.picker...@gmail.com
>>> tel:+46764147049 <076-414%2070%2049>
>>>
>>
>>
>>
>> --
>> ------------------------------------------------------------
>> --------------------
>> Isaiah Nyabuto
>> +254 729 572 616
>> Bsc. Health Records Management & Informatics, JKUAT.
>>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
--
--------------------------------------------------------------------------------
Isaiah Nyabuto
+254 729 572 616
Bsc. Health Records Management & Informatics, JKUAT.
_______________________________________________
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
