Unable to do the Data Importing through TEI import, the import says success with 1 CREATED but doesnt shows up in the Data statistics table in the Data Administration app

Support - Assistance technique
1

I’m currently working with DHIS2 version 2.36.13.2 and encountering issues with Data Importing using TEI import. Despite the import indicating success with 1 creation, the data is not reflected in the Data Statistics table within the Data Administration app. After multiple attempts and a Tomcat restart, I noticed some TEIs were created but without any data values. My data import process involves JSON payload for a dataset related to Wound Visits, and I am adhering to the following payload structure :

{
    "trackedEntityType": "nEenWmSyUEp",
    "orgUnit": "DiszpKrYNg8",
    "attributes": [
      {
        "attribute": "w75KJ2mc4zz",
        "value": "Joe"
      },
      {
        "attribute": "zDhUuAYrxNC",
        "value": "Rufus"
      },
      {
         "attribute":"cejWyOfXge6",
         "value":"Male"
      }
    ],
    "enrollments":[
      {
         "orgUnit":"DiszpKrYNg8",
         "program":"ur1Edk5Oe2n",
         "enrollmentDate":"2017-09-15",
         "incidentDate":"2017-09-15",
         "events":[
            {
               "program":"ur1Edk5Oe2n",
               "orgUnit":"DiszpKrYNg8",
               "eventDate":"2017-10-17",
               "status":"COMPLETED",
               "storedBy":"admin",
               "programStage":"EPEcjy3FWmI",
               "coordinate":{
                  "latitude":"59.8",
                  "longitude":"10.9"
               },
               "dataValues":[
                  {
                     "dataElement":"qrur9Dvnyt5",
                     "value":"22"
                  },
                  {
                     "dataElement":"oZg33kd9taw",
                     "value":"Male"
                  }
               ]
            }

Any help on how to successfully import the data values would be appreciated.
Thanks

2

Have you run Analytics tables regeneration?

3

Thank you for the reply. I did the Analytics table regeneration but it didn’t change anything. I’m trying the data import using the TEI import through the Import/Export app and I have the TEI JSON payload but no Data values are getting imported.

Screenshot 2024-01-05 181253
Screenshot 2024-01-05 1812531068×1158 43.9 KB

4

Hi @Shikhar_Shukla

How did you get your TEI data? Does is consist only enrollments, events or both of them?
The instance where are you trying to copy the TEI data have the same OU structure and related metadata?

I never used that export\import app and usually use following API point to export my data:
your_domain_name/api/trackedEntityInstances.json?program=program_UID&ou=ROOT_OU_UID&ouMode=ALL&fields=*&skipPaging=true&programStartDate=Period_start&programEndDate=Period_end

Then if the destination instance and OU the same I use postman to POST the TEI’s. Otherwise change OU or anything else and import.

Good luck