Mobile app version of vmapp.org
Login or Join
Fox8124981

: Data import using CSV into DHIS 2 We have a lot of legacy data sitting on our Excel file that we need to import into our new DHIS2 database. How can we upload the data onto the DHIS using

@Fox8124981

Posted in: #Csv #Data #Dhis2 #Import

We have a lot of legacy data sitting on our Excel file that we need to import into our new DHIS2 database. How can we upload the data onto the DHIS using CSV? It is costing us a lot in terms of time and money to employ data entry clerks to manually input the data.

10.02% popularity Vote Up Vote Down


Login to follow query

More posts by @Fox8124981

2 Comments

Sorted by latest first Latest Oldest Best

 

@Hamaas447

You can use the CSV import format which is described in this section of the docs:
docs.dhis2.org/master/en/developer/html/webapi_data_values.html#webapi_data_values_csv
You can either upload the file through the user interface from Apps > Import / Export > Data import, then select CSV as format.

You can also use the Web API to achieve the same, which is documented in this section:
docs.dhis2.org/master/en/developer/html/webapi_data_values.html#webapi_sending_bulks_data_values
Note that when using CSV format you must use the binary data option to preserve the line-breaks in the CSV file:

curl --data-binary @datavalueset .csv "https://play.dhis2.org/demo/24/api/dataValueSets" -H "Content-Type:application/csv" -u admin:district -v

10% popularity Vote Up Vote Down


 

@Reiling115

Why not try the Import Export option?

Under Apps > Import Export

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme