Event data import from CSV using Import/Export APP not working while using Event ID scheme code

Dear Altruist,
I am trying to import Event capture program data from CSV using Import/Export App. While I am using Event ID scheme as a code and putting program code as a value in CSV, import failed with a error “Event.program does not point to a valid program : event_code”. But using program UID I could import data successfully. Please help me with information what I am missing?

I am using DHIS2 version 2.32 in ubuntu server environment.

2 Likes

However, I got successful import with WEB API call.
http://myhost/api/events.json?orgUnitIdScheme=NAME&programIdScheme=CODE
{
“program”: “EP_Money_Receipt”,
“orgUnit”: “SHC-Pirgacha”,
“eventDate”: “2019-08-14T00:00:00.000”,
“status”: “COMPLETED”,
“storedBy”: “sohel”,
“coordinate”: {
“latitude”: “23.780612656197615”,
“longitude”: “90.36315”
},
“dataValues”: [
{ “dataElement”: “MF39ricB1da”, “value”: “CH-01” },
{ “dataElement”: “BIktwSpqc34”, “value”: “zinc” },
{ “dataElement”: “fZYulxZX7GM”, “value”: “3” },
{ “dataElement”: “TPBHDnusK7l”, “value”: “4” },
{ “dataElement”: “IimmEXSlg2X”, “value”: “32” },
{ “dataElement”: “TAq9oHdb7iO”, “value”: “2” },
{ “dataElement”: “ejdlMrxhkY3”, “value”: “30” }
]
}

2 Likes

Hello!
At WHO we are using Bulk Load application to upload data from excel which may help you. It generates templates automatically from any data set or even program and you can style them a bit. The import process also detects duplicates and you can configure a time range within which events can be considered duplicates.

The new version of this app was just released: Bulk Load app 3.5.1 now available
GitRepo:
GitHub - EyeSeeTea/Bulk-Load-blessed

Hope this helps!
Lucia

4 Likes