← Back to team overview

dhis2-devs team mailing list archive

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

 

Hi there

I'm not sure about this issue, but there have been some fixes to CSV import
lately, would you mind getting the latest 227 and retry? if it's still
present, could you write up a JIRA issue for? and we will have a look

jira.dhis2.org

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

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

> *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@4700501
>>> 2 <470%2005%20012>; 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.
>>>
>>
>>
>
> _______________________________________________
> 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
>
>

Follow ups

References