Changes between Version 24 and Version 25 of UserGuidelines/Importer

Timestamp:

12/04/10 20:27:50 (14 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Importer

@@ -5 +5 @@
 
 3 options available:
+ * Open Office (preferred)
  * CSV
- * Open Office
  * Excel via interactive UI (incomplete)
+
+=== Open Office ===
+Can import data from spreadsheets in .fods format (e.g. created by Open Office).
+
+This is best as it handles complex resources.
+
+via web:
+ * http://myhost.com/eden/hms/hospital/create.fods?filename=myhospitals.fods
+
+or from Web2Py CLI:
+{{{
+resource = s3xrc.resource("hms", "hospital")
+template = os.path.join(request.folder, resource.XSLT_PATH, "fods", "import.xsl")
+resource.import_xml("myhospitals.fods", template=template)
+}}}
+
+Structure of the file should be as follows:
+ * Sheet name = resource name
+ * First row = attribute/field names
+ * Other rows = attribute/field values
+
+==== References ====
+ 1. Insert another sheet with the entries of the referenced table, this sheet must have the same name as the referenced table and a column "uuid"
+ 2. Insert a column in the main sheet with a column title like:
+{{{
+reference:<fieldname>:<referenced_table>
+}}}
+e.g. "reference:organisation_id:org_organisation"
+ 3. fill in this column with the UUIDs of the respective entries
+   in the referenced table
+
+==== Components: ====
+ 1. Insert another sheet with the entries of the component table, this sheet must have a name like:
+{{{
+<main-table-name>+<component-table-name>
+}}}
+e.g. "hms_hospital+hms_hactivity"
+ 2. Insert a column into the component sheet with a name like:
+{{{
+<main-table-name>.<key-field>
+}}}
+e.g. "hms_hospital.gov_uuid"[[BR]]
+=> the key field must be present in the main table[[BR]]
+=> the key field must be unique (primary key) in the main table[[BR]]
+ 3. Fill in this column with the respective values of the key field in the parent entry of the main table
+
 
 === CSV ===
@@ -22 +68 @@
 or Web UI (''to be checked''):
  * http://myhost.com/eden/vol/person/create.csv?filename=myvols.csv
-
-=== Open Office ===
-Can import data from spreadsheets in .fods format (e.g. created by Open Office).
-
-This is best as it handles complex resources best.
-
-via web:
- * http://myhost.com/eden/hms/hospital/create.fods?filename=myhospitals.fods
-
-or from Web2Py CLI:
-{{{
-resource = s3xrc.resource("hms", "hospital")
-template = os.path.join(request.folder, resource.XSLT_PATH, "fods", "import.xsl")
-resource.import_xml("myhospitals.fods", template=template)
-}}}
 
 === Excel via interactive UI ===