Is it possible to import excel data into dhis2

[Sudarshan]

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)

[Gassim (AL-Gassim Sharaf Addin)]

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!

[Sudarshan]

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.

[Gassim (AL-Gassim Sharaf Addin)]

@Sudarshan

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

Thank you!

[Sudarshan]

Hi @Gassim,

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

[Gassim (AL-Gassim Sharaf Addin)]

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:

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

[Sudarshan]

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!