← Back to team overview

dhis2-users team mailing list archive

Re: CSV Event upload failed: "latitude" not a valid Double value


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/
> events" -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/
> 5QmLvJ)
> 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.

Follow ups