Changes between Version 34 and Version 35 of UserGuidelines/Importer

Timestamp:

05/27/11 20:36:26 (15 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Importer

@@ -5 +5 @@
 
 3 options available:
- * Open Office (preferred)
- * CSV
+ * CSV (preferred)
+ * Open Office
  * Excel via interactive UI (incomplete)
+
+=== CSV ===
+Can import data from spreadsheets in CSV (Comma Separated Values) format as long as it is formatted properly.
+
+==== New: S3CSV ====
+{{{
+http://host.domain/eden/hrm/person.s3csv/create?filename=c:\HR.csv&transform=/home/web2py/applications/eden/static/formats/s3csv/hrm_import.xsl
+}}}
+
+==== Old: Web2Py native ====
+This is 1 sheet per-table, not per-resource & foreign keys need to be as numeric IDs, so there is a fair amount of setup.
+
+Can do this via CLI (put file 'volunteers.csv' into private/import):
+{{{
+import_file = os.path.join(request.folder, "private", "import", "volunteers.csv")
+table.import_from_csv_file(open(import_file, "r"))
+}}}
+
+or Web UI (''to be checked''):
+ * http://myhost.com/eden/vol/person.csv/create?filename=myvols.csv
 
 === Open Office ===
@@ -57 +77 @@
 
 
-=== CSV ===
-Can import data from spreadsheets in CSV (Comma Separated Values) format as long as it is formatted properly.
-
-==== New: S3CSV ====
-{{{
-http://host.domain/eden/hrm/person.s3csv/create?filename=c:\HR.csv&transform=/home/web2py/applications/eden/static/formats/s3csv/hrm_import.xsl
-}}}
-
-==== Old: Web2Py native ====
-This is 1 sheet per-table, not per-resource & foreign keys need to be as numeric IDs, so there is a fair amount of setup.
-
-Can do this via CLI (put file 'volunteers.csv' into private/import):
-{{{
-import_file = os.path.join(request.folder, "private", "import", "volunteers.csv")
-table.import_from_csv_file(open(import_file, "r"))
-}}}
-
-or Web UI (''to be checked''):
- * http://myhost.com/eden/vol/person.csv/create?filename=myvols.csv
-
 === Excel via interactive UI ===
- * [http://wiki.sahanafoundation.org/doku.php/foundation:gsoc_kohli GSoC project] - now merged with Trunk
+ * [http://wiki.sahanafoundation.org/doku.php/foundation:gsoc_kohli GSoC project] - merged with Trunk, but disabled by default as not fully working
 
 ==== Outline ====