Is it possible to import excel data into dhis2

Support - Assistance technique
,
1

Hello,

I need help to import stage data from excel to dhis2. I tried data import wizard but stages data is not uploading.

Please give the steps and Excel format. (My program type - tracker)

2

Hello @Sudarshan

Please use make sure the columns in your excel sheet are the same as the template in CSV-Events-payload-template and save the sheet as a CSV file. After that you can use the Import/Export app to import the file using Events Import.

Thanks!

2 Likes
3

Hi @Gassim,
Thanks for reply!

I have imported below data from “event import”, but data is not inserted into respective tables. No error coming while importing.

image
image1267Ă—150 7.28 KB

image
image1070Ă—588 37.4 KB

4

Hey what version of dhis2 are you using? And which app?

Thank you!

1 Like
5

Hi @Gassim,

Version :-2.37
App :- Import/Export ->Event Import

1 Like
6

Thanks! I see the same issue, and it just freezes without any response in the page, but when we check the console and the Network tab, the following appears:

image
image1498Ă—900 123 KB

Thank you for reporting this. I will check with the team, and post back to the community.

7

2 posts were split to a new topic: Updated Entities in Data Import Wizard app not working

8

Hi @Gassim,

I have trying to upload event data from import/export app on my local environment, But it not working.

Sample database name 2.38.2 - dhis2-db-sierra-leone

Version - dhis2-stable-2.38.2.1.war

Is below file format is correct?
events.xlsx (9.5 KB)

Thanks!