Hi! Folks,
I have some aggregated data in .csv format and I want to import the data using import/export App to relative Data Element in the System. Can anyone guide me to the link of the template to convert the raw data into importable format or how I can I generate the template?
Quick question please, if I understand correctly, you want to import the values for the metadata (data elements) already existent in the system, right?
If my assumption is correct then the best way to get a template is to use the Import/Export app data export. In the Import/Export app, select export data and then export a data for the dataset in CSV format. Edit the CSV file, remove the unnecessary columns (storedby, lastupdated, comment, followup, and deleted).
As a rule of thumb, anything that is required in the configuration form when creating the metadata, must be included in the import of data or even metadata.
I am trying to do this, but when I export the data from DHIS2 in CSV format, its difficult to recognise which data element has what value because of the IDs generated by the DHIS2 system is so confusing. How can I get this easily sorted out? datavalues.xlsx (19.1 KB)
for your reference