wiki:SpreadsheetImporter

Version 7 (modified by Fran Boon, 12 years ago) ( diff )

--

Haiti

Spreadsheet Importer

We have access to a lot of relatively unstructured data in Spreadsheets which we need to import into Sahana. Currently this is done via a laborious Data Entry process.

We really need to be able to do Bulk Imports.

Example Data sources:

Options:

CSV Import

cd /path/to/web2py
python web2py.py -S sahana -M -N
db.import_from_csv_file(open('db.csv','rb'))
db.or_organisation.import_from_csv_file(open('orgs.csv','rb'))
db.commit()
Ctrl+D
  • Limited access through Web at: /admin/import_data (& doesn't seem to work at all?)
  • Problems with the file format (e.g. MS Excel chews, OpenOffice 3.1 ok)
  • Hard work to get reference fields lined up
    • Need to export a dataset first

Google Spreadsheets API

Excel

Other


Haiti

Note: See TracWiki for help on using the wiki.