wiki:SpreadsheetImporter

Version 4 (modified by Fran Boon, 13 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
    • Problems with the file format (e.g. MS Excel chews)
    • Hard work to get reference fields lined up
  • Google Spreadsheets API
  • xlrd
  • Resolver One

Haiti

Note: See TracWiki for help on using the wiki.