=== modified file 'src/docbkx/en/dhis2_user_man_import_export.xml' --- src/docbkx/en/dhis2_user_man_import_export.xml 2011-04-28 19:13:18 +0000 +++ src/docbkx/en/dhis2_user_man_import_export.xml 2012-04-26 11:19:20 +0000 @@ -1,4 +1,4 @@ - + Import and export @@ -201,4 +201,72 @@ +
+ Importing CSV data + DHIS 2 supports import of data in the CSV format. This can be used to import exchange file produced by DHIS 2 itself. It also comes in handy when you want to import data from a third-party system as CSV is widely supported in applications and is easy to produce manually. + To import a CSV data exchange file navigate to the CSV Data Import item in the left-side menu. + The following section describes the CSV format used in DHIS 2. The first row is assumed to be a header row and will be ignored during import. + + CSV format of DHIS 2 + + + + Column + Required + Notes + + + Data element + Yes + Refers to uid by default, can also be name and code based on selected id scheme + + + Period + Yes + In ISO format + + + Org unit + Yes + Refers to uid by default, can also be name and code based on selected id scheme + + + Category option combo + No + Refers to uid + + + Value + No + Data value + + + Stored by + No + Refers to username of user who entered the value + + + Timestamp + No + Date in ISO format + + + Comment + No + Free text comment + + + Follow up + No + true or false + + + +
+ The following is an example CSV file which can be imported into DHIS 2. It can be imported both as plain text file or as compressed ZIP file archive. + "dataelelement","period","orgunit","categoryoptioncombo","value","storedby","timestamp","comment","followup" +"DUSpd8Jq3M7","201202","gP6hn503KUX","Prlt0C1RF0s","7","bombali","2010-04-17",,"false" +"DUSpd8Jq3M7","201202","gP6hn503KUX","V6L425pT3A0","10","bombali","2010-04-17",,"false" +"DUSpd8Jq3M7","201202","OjTS752GbZE","V6L425pT3A0","9","bombali","2010-04-06",,"false" +