| Version 1 (modified by , 15 years ago) ( diff ) |
|---|
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.
Options:
- CSV Import
- 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
- Example Code - not the cleanest
Note:
See TracWiki
for help on using the wiki.
