dhis2-users team mailing list archive

[Pepe Ken Mvulu <pepekento1@xxxxxxxxx>]

Hi Jesus,
Thank you for your quick reply.
I wanted to know if you have used "Data Import" or "Event Import"?
I try
Regards !

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

2017-08-21 16:32 GMT+01:00 Jesus Solano-Roman <asolano@xxxxxxxxxxxxxxxxxx>:

> Hi Pepe.
>
> 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 <pepekento1@xxxxxxxxx> wrote:
>
>> Hi all,
>> I use the Tracker capture, I need to import the event data values in csv
>> format
>> The 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 <0811%20515%20878>
>> Skype: pepe.ken.mvulu
>>
>> _______________________________________________
>> 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
>>
>>