wiki:UserGuidelines/Importer

Version 2 (modified by Shikhar Kohli, 11 years ago) ( diff )

--

Importer

Spreadsheets

Steps

  • 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.
  • Referenced resources, like pr_person in org_staff, can be imported as well.
  • 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. 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.
  • 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.

Ushahidi

XSLT available to import Ushahidi data into Sahana Eden's Incident Reporting system

See Also


UserGuidelines

Attachments (2)

  • cleanCSV.py (1.1 KB ) - added by Fran Boon 8 years ago. Remvoe line-breaks within text fields from a CSV file
  • splitCSV.py (1.2 KB ) - added by Fran Boon 8 years ago. Spli a large CSV file into multiple files to avoid memory exhaustion when importing

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.