Changes between Version 8 and Version 9 of UserGuidelines/Importer


Ignore:
Timestamp:
08/18/10 15:30:33 (14 years ago)
Author:
Shikhar Kohli
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Importer

    v8 v9  
    99  * Referenced resources, like pr_person in org_staff, can be imported as well.
    1010  * Records, which could not be validated, are not inserted into the database. These records are displayed to the users in a spreadsheet interface. Records have at least one field in red.
    11    This is the field with in incorrect value. The format in which errors are displayed is :  ''' <field-name>: <error> . You entered <value entered by user> '''. Records can then be corrected and re-imported.
     11   This is the field with an incorrect value. The format in which errors are displayed is :  ''' <field-name>: <error> . You entered <value entered by user> '''. Records can then be corrected and re-imported.
    1212  * 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.
    1313
     
    2121   * Tips:
    2222     * Keep a single worksheet in the spreadsheet.
    23      * 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.
     23     * 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)
    2424
    2525
     
    6464  * Operations that can be performed in this step are identical to step 5.
    6565
     66Limitation:
     67  * You cannot import the same spreadsheet again. Causes duplicacy and outright rejection of some records from the database.
     68  * Bugs, listed below
     69
     70Some bugs and improvements:
     71  * Need to remove console.log in the JS code. These are very helpful when debugging, so I'll remove them when the project is merged. Also, redirection is currently commented out, will be removed when importer is merged.
     72  * Mapping to organisation_id --> org_organisation --> comments works in some cases and does not work in others.
     73  * Better representation of nested resources.
     74  * The UI of the stages in the wizard may be modified suitably.
     75
    6676== Ushahidi ==
    6777XSLT available to import Ushahidi data into Sahana Eden's Incident Reporting system