I believe there's a couple of issues with your csv. I realize this is confusing because the CSV you obtain when you export the data has a format that -is not the same- as the one you need to import the data to DHIS2 (I was very confused by this as well).
If you're using the UI to import a CSV, you may keep the header row, but you have to select the option to skip the first row. If you're using cURL upload, you need to remove the header row. Try the following fixes:
FIRST FIX:
storedBy and providedElsewhere should be left empty
Also I think latitude and longitude should be 0 if you don't have those values.
Try by making those changes, if that still fails try
SECOND FIX:
The second problem you might have is your dates. I've never used that format to upload dates, as I think that is the value we humans see of a date element. The date format is:
2014-05-25T00:00:00.000
YYYY-MM-DDT00:00:00.000
I'm attaching a CSV with a format that has worked for me, you can use it to check your columns and also to check the date format in case the first fix doesn't work.
Hope this helps,
Best.
Antonio Solano-Roman
Data Visualization & User Experience Design
Sabeti Lab - Broad Institute
On Aug 21 2017, at 9:38 am, Pepe Ken Mvulu <pepeken...@gmail.com> wrote:
Hi all,I use the Tracker capture, I need to import the event data values in csv formatThe format I use returns this error and yet it is the same format I exported in the "Import / Export" App.Please, is there an import format compatible with csv?Kind Regard !Pepe Ken Mvulu
Responsable M&E
Programme Village Assaini
Direction de l'Hygiène
Ministère de la Santé Publique/RDC
Tél: +243 811515878
Skype: pepe.ken.mvulu_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
sample_CSV_eventImport.csv
Description: Binary data
_______________________________________________ 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
