Event Import in 2.26

Support - Assistance technique
1

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 !

test_import event.csv (283 Bytes)

···

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

2

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

sample_CSV_eventImport.csv (391 Bytes)

···

On Aug 21 2017, at 9:38 am, Pepe Ken Mvulu pepekento1@gmail.com 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
Skype: pepe.ken.mvulu

_______________________________________________ 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
3

Hi Jesus,
Thank you for your quick reply.

I wanted to know if you have used “Data Import” or “Event Import”?

I try

Regards !

···

2017-08-21 16:32 GMT+01:00 Jesus Solano-Roman asolano@broadinstitute.org:

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@gmail.com            > 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
Skype: pepe.ken.mvulu

_______________________________________________ Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/~dhis2-devs)
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/~dhis2-devs)
More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

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

4

Hi again.

Antonio Solano-Roman

Data Visualization & User Experience Design

Sabeti Lab - Broad Institute

You should use Event Import specifically.

···

On Aug 21 2017, at 12:37 pm, Pepe Ken Mvulu pepekento1@gmail.com wrote:

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@broadinstitute.org:

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@gmail.com            > 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
Skype: pepe.ken.mvulu

_______________________________________________ Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/~dhis2-devs?recipient=dhis2-users%40lists.launchpad.net)
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/~dhis2-devs?recipient=dhis2-users%40lists.launchpad.net)
More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp?recipient=dhis2-users%40lists.launchpad.net)