*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 < asol...@broadinstitute.org> 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 < > asol...@broadinstitute.org> 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. >> > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
