Changes between Version 12 and Version 13 of UserGuidelines/Importer


Ignore:
Timestamp:
11/29/10 21:29:33 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Importer

    v12 v13  
    44== Spreadsheets ==
    55
     62 options available:
     7 * Open Office
     8 * Excel via interactive UI (incomplete)
     9
     10=== Open Office ===
    611Can import data from spreadsheets in .fods format (e.g. created by Open Office):
    712 * http://myhost.com/eden/hms/hospital/create.fods?filename=...
     
    1015}}}
    1116
    12 or
     17=== Excel via interactive UI ===
    1318 * [http://wiki.sahanafoundation.org/doku.php/foundation:gsoc_kohli GSoC project] - now merged with Trunk
    1419
    15 === Outline ===
     20==== Outline ====
    1621  * Spreadsheet importer, in its current form, can be used to import data in .XLS files to the Sahana Eden database
    1722  * It has a spreadsheet like interface to enable users to edit spreadsheets in the browser itself.
     
    2126  * 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.
    2227
    23 === Steps ===
     28==== Steps ====
    2429[http://www.youtube.com/watch?v=qOFy-xG4Exk Video Demo]
    2530
     
    3136     * Keep a single worksheet in the spreadsheet.
    3237     * 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)
    33 
    3438
    35392. Edit spreadsheet