dhis2-users team mailing list archive

[Jesus Solano-Roman <asolano@xxxxxxxxxxxxxxxxxx>]

*SECOND UPDATE*: Sorry to keep updating this but I cannot edit the original
post.

I realized that the header had to be removed and also that the last two
columns should be left empty (storedBy, ProvidedElsewhere).

I believe this has fixed the issue. *However, one last question*:


Upload was successful for 8/9 entries the *DE F3ogKBuviRA is a coordinate
data element*, and I've tried using two formats: "[-11.94,8.84]" and
"-11.94,8.84". (not using quotation marks). These both fail on import. What
is wrong with the format of my coordinates? The Documentation says:

Coordinate: *A point coordinate specified as longitude/latitude in decimal
degrees. All coordinate should be specified in the format "-19.23 , 56.42"
with a comma separating the longitude and latitude. (Since v2.21).*

My system is

Version:
2.27
Build revision:
b531614



Thanks again and apologies for the constant updates.



On Fri, Aug 4, 2017 at 3:41 PM, Jesus Solano-Roman <
asolano@xxxxxxxxxxxxxxxxxx> wrote:

> UPDATE: I noticed that the csv file I downloaded from DHIS2 with a sample
> of the Event data does not contain quotations so I did the same on the
> exported file from R
>
>  write.csv(data, file = "data.csv", row.names = F, fileEncoding = 'UTF-8',
> quote = F)
>
>
> But the upload still fails. Also If I upload manually using the import
> function inside DHIS2, the dry run shows the following conflicts:
>
> event Data element not found or not accessible
> tHF7qDZVeoT Data element not found or not accessible
> and all elements are ignored.
>
>
> Thanks again.
>
> On Fri, Aug 4, 2017 at 3:27 PM, Jesus Solano-Roman <
> asolano@xxxxxxxxxxxxxxxxxx> wrote:
>
>> Hello all.
>>
>> I've constructed a csv file to bulk import Events to a local instance of
>> DHIS2 as per guidelines from the documentation
>> <https://docs.dhis2.org/master/en/developer/html/dhis2_developer_manual_full.html#webapi_events_csv_import_export> .
>> My curl command to upload is the following:
>>
>> curl --data-binary @programKenemaTest.csv "http://localhost:8085/api/eve
>> nts" -H "Content-Type:application/csv" -u admin:district -v
>>
>>
>> however, when uploading from terminal I get the following error message:
>>
>> {"httpStatus":"Internal Server Error",
>>
>> "httpStatusCode":500,"status":"ERROR",
>>
>> "message":"*Can not construct instance of java.lang.Double from String
>> value (\"latitude\"): not a valid Double value*\n
>>
>> at [Source: com.fasterxml.jackson.dataformat.csv.impl.UTF8Reader@47005012;
>> line: 1, column: 88] (through reference chain:
>> org.hisp.dhis.dxf2.events.event.csv.CsvEventDataValue[\"latitude\"])"}
>>
>> (Rest of response from server can be seen here: https://codeshare.io/5Qm
>> LvJ)
>>
>> The value for latitude (and longitude) in this particular dataset is 0. I
>> generated this dataset and the CSV file using R. The type of value for
>> those two columns evaluates to "double", and I have exported the CSV using
>> UTF-8 encoding:
>>
>> write.csv(data, file = "data.csv", row.names = F, fileEncoding = 'UTF-8')
>>
>>
>> Any ideas why this file cannot be parsed correctly? Entries created
>> inside DHIS2 using the Event Capture app have latitude and longitude values
>> of 0 without a problem. I've attached the csv file if it's of any help.
>>
>>
>> Thanks for your time,
>>
>>
>> Antonio Solano.
>>
>
>