Changes between Version 23 and Version 24 of UserGuidelines/Importer
- Timestamp:
- 12/04/10 20:20:14 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UserGuidelines/Importer
v23 v24 9 9 * Excel via interactive UI (incomplete) 10 10 11 === CSV === 12 Can import data from spreadsheets in CSV (Comma Separated Values) format as long as it is formatted properly. 13 14 This is 1 sheet per-table, not per-resource & foreign keys need to be as numeric IDs, so there is a fair amount of setup. 15 16 Can do this via CLI (put file 'volunteers.csv' into private/import): 17 {{{ 18 import_file = os.path.join(request.folder, "private", "import", "volunteers.csv") 19 table.import_from_csv_file(open(import_file, "r")) 20 }}} 21 22 or Web UI (''to be checked''): 23 * http://myhost.com/eden/vol/person/create.csv?filename=myvols.csv 24 11 25 === Open Office === 12 Can import data from spreadsheets in .fods format (e.g. created by Open Office): 26 Can import data from spreadsheets in .fods format (e.g. created by Open Office). 27 28 This is best as it handles complex resources best. 29 30 via web: 13 31 * http://myhost.com/eden/hms/hospital/create.fods?filename=myhospitals.fods 32 14 33 or from Web2Py CLI: 15 34 {{{