dhis2-devs team mailing list archive

[noreply@xxxxxxxxxxxxx]

------------------------------------------------------------
revno: 507
committer: Lars Helge Overland <larshelge@xxxxxxxxx>
branch nick: dhis2-docbook-docs
timestamp: Thu 2012-04-26 13:19:20 +0200
message:
  Added section on CSV import
modified:
  src/docbkx/en/dhis2_user_man_import_export.xml


--
lp:~dhis2-documenters/dhis2/dhis2-docbook-docs
https://code.launchpad.net/~dhis2-documenters/dhis2/dhis2-docbook-docs

Your team DHIS 2 developers is subscribed to branch lp:~dhis2-documenters/dhis2/dhis2-docbook-docs.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-documenters/dhis2/dhis2-docbook-docs/+edit-subscription

=== 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 @@
-<?xml version='1.0' encoding='UTF-8'?>
+<?xml version='1.0' encoding='UTF-8'?>
 <!-- This document was created with Syntext Serna Free. --><!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.4//EN" "docbookV4.4/docbookx.dtd" []>
 <chapter>
   <title>Import and export</title>
@@ -201,4 +201,72 @@
       </section>
     </section>
   </section>
+  <section>
+    <title>Importing CSV data</title>
+    <para>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.</para>
+    <para>To import a CSV data exchange file navigate to the <emphasis role="italic">CSV Data Import </emphasis>item in the left-side menu.</para>
+    <para>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.</para>
+    <para><table>
+        <title>CSV format of DHIS 2</title>
+        <tgroup cols="3">
+          <tbody>
+            <row>
+              <entry>Column</entry>
+              <entry>Required</entry>
+              <entry>Notes</entry>
+            </row>
+            <row>
+              <entry>Data element</entry>
+              <entry>Yes</entry>
+              <entry>Refers to uid by default, can also be name and code based on selected id scheme</entry>
+            </row>
+            <row>
+              <entry>Period</entry>
+              <entry>Yes</entry>
+              <entry>In ISO format</entry>
+            </row>
+            <row>
+              <entry>Org unit</entry>
+              <entry>Yes</entry>
+              <entry>Refers to uid by default, can also be name and code based on selected id scheme</entry>
+            </row>
+            <row>
+              <entry>Category option combo</entry>
+              <entry>No</entry>
+              <entry>Refers to uid</entry>
+            </row>
+            <row>
+              <entry>Value</entry>
+              <entry>No</entry>
+              <entry>Data value</entry>
+            </row>
+            <row>
+              <entry>Stored by</entry>
+              <entry>No</entry>
+              <entry>Refers to username of user who entered the value</entry>
+            </row>
+            <row>
+              <entry>Timestamp</entry>
+              <entry>No</entry>
+              <entry>Date in ISO format</entry>
+            </row>
+            <row>
+              <entry>Comment</entry>
+              <entry>No</entry>
+              <entry>Free text comment</entry>
+            </row>
+            <row>
+              <entry>Follow up</entry>
+              <entry>No</entry>
+              <entry>true or false</entry>
+            </row>
+          </tbody>
+        </tgroup>
+      </table></para>
+    <para>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.</para>
+    <screen>&quot;dataelelement&quot;,&quot;period&quot;,&quot;orgunit&quot;,&quot;categoryoptioncombo&quot;,&quot;value&quot;,&quot;storedby&quot;,&quot;timestamp&quot;,&quot;comment&quot;,&quot;followup&quot;
+&quot;DUSpd8Jq3M7&quot;,&quot;201202&quot;,&quot;gP6hn503KUX&quot;,&quot;Prlt0C1RF0s&quot;,&quot;7&quot;,&quot;bombali&quot;,&quot;2010-04-17&quot;,,&quot;false&quot;
+&quot;DUSpd8Jq3M7&quot;,&quot;201202&quot;,&quot;gP6hn503KUX&quot;,&quot;V6L425pT3A0&quot;,&quot;10&quot;,&quot;bombali&quot;,&quot;2010-04-17&quot;,,&quot;false&quot;
+&quot;DUSpd8Jq3M7&quot;,&quot;201202&quot;,&quot;OjTS752GbZE&quot;,&quot;V6L425pT3A0&quot;,&quot;9&quot;,&quot;bombali&quot;,&quot;2010-04-06&quot;,,&quot;false&quot;</screen>
+  </section>
 </chapter>