Changes between Version 12 and Version 13 of UserGuidelines/Importer

Timestamp:

11/29/10 21:29:33 (14 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Importer

@@ -4 +4 @@
 == Spreadsheets ==
 
+2 options available:
+ * Open Office
+ * Excel via interactive UI (incomplete)
+
+=== Open Office ===
 Can import data from spreadsheets in .fods format (e.g. created by Open Office):
  * http://myhost.com/eden/hms/hospital/create.fods?filename=...
@@ -10 +15 @@
 }}}
 
-or
+=== Excel via interactive UI ===
  * [http://wiki.sahanafoundation.org/doku.php/foundation:gsoc_kohli GSoC project] - now merged with Trunk
 
-=== Outline ===
+==== Outline ====
   * Spreadsheet importer, in its current form, can be used to import data in .XLS files to the Sahana Eden database
   * It has a spreadsheet like interface to enable users to edit spreadsheets in the browser itself.
@@ -21 +26 @@
   * The spreadsheet importer uses the Jaro-Winkler metric to determine the similarity of two rows. Similarity between rows is checked two at a time. Similar rows are displayed consecutively in another spreadsheet like interface. The user can choose to edit, delete and then import these rows to the database. Errors in these rows are displayed in the same form as described previously.
 
-=== Steps ===
+==== Steps ====
 [http://www.youtube.com/watch?v=qOFy-xG4Exk Video Demo]
 
@@ -31 +36 @@
      * Keep a single worksheet in the spreadsheet.
      * Keep the number of rows around 100. More rows require more rendering and processing,therefore more time. This could also cause server requests to time out. (Please note, 100 rows is by no means a limitation, it is a simply a safe number of rows to render and import, keeping in mind the strength of internet connection. The number of rows isn't really a problem in an offline client of course)
-
 
 2. Edit spreadsheet