Changes between Version 23 and Version 24 of UserGuidelines/Importer


Ignore:
Timestamp:
12/04/10 20:20:14 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Importer

    v23 v24  
    99 * Excel via interactive UI (incomplete)
    1010
     11=== CSV ===
     12Can import data from spreadsheets in CSV (Comma Separated Values) format as long as it is formatted properly.
     13
     14This 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
     16Can do this via CLI (put file 'volunteers.csv' into private/import):
     17{{{
     18import_file = os.path.join(request.folder, "private", "import", "volunteers.csv")
     19table.import_from_csv_file(open(import_file, "r"))
     20}}}
     21
     22or Web UI (''to be checked''):
     23 * http://myhost.com/eden/vol/person/create.csv?filename=myvols.csv
     24
    1125=== Open Office ===
    12 Can import data from spreadsheets in .fods format (e.g. created by Open Office):
     26Can import data from spreadsheets in .fods format (e.g. created by Open Office).
     27
     28This is best as it handles complex resources best.
     29
     30via web:
    1331 * http://myhost.com/eden/hms/hospital/create.fods?filename=myhospitals.fods
     32
    1433or from Web2Py CLI:
    1534{{{