Changes between Version 23 and Version 24 of UserGuidelines/Importer

Timestamp:

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

Author:

Fran Boon

Comment:

--

UserGuidelines/Importer

@@ -9 +9 @@
  * Excel via interactive UI (incomplete)
 
+=== CSV ===
+Can import data from spreadsheets in CSV (Comma Separated Values) format as long as it is formatted properly.
+
+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/create.csv?filename=myvols.csv
+
 === Open Office ===
-Can import data from spreadsheets in .fods format (e.g. created by 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:
 {{{