Changes between Version 34 and Version 35 of UserGuidelines/Importer


Ignore:
Timestamp:
05/27/11 20:36:26 (10 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Importer

    v34 v35  
    55
    663 options available:
    7  * Open Office (preferred)
    8  * CSV
     7 * CSV (preferred)
     8 * Open Office
    99 * Excel via interactive UI (incomplete)
     10
     11=== CSV ===
     12Can import data from spreadsheets in CSV (Comma Separated Values) format as long as it is formatted properly.
     13
     14==== New: S3CSV ====
     15{{{
     16http://host.domain/eden/hrm/person.s3csv/create?filename=c:\HR.csv&transform=/home/web2py/applications/eden/static/formats/s3csv/hrm_import.xsl
     17}}}
     18
     19==== Old: Web2Py native ====
     20This is 1 sheet per-table, not per-resource & foreign keys need to be as numeric IDs, so there is a fair amount of setup.
     21
     22Can do this via CLI (put file 'volunteers.csv' into private/import):
     23{{{
     24import_file = os.path.join(request.folder, "private", "import", "volunteers.csv")
     25table.import_from_csv_file(open(import_file, "r"))
     26}}}
     27
     28or Web UI (''to be checked''):
     29 * http://myhost.com/eden/vol/person.csv/create?filename=myvols.csv
    1030
    1131=== Open Office ===
     
    5777
    5878
    59 === CSV ===
    60 Can import data from spreadsheets in CSV (Comma Separated Values) format as long as it is formatted properly.
    61 
    62 ==== New: S3CSV ====
    63 {{{
    64 http://host.domain/eden/hrm/person.s3csv/create?filename=c:\HR.csv&transform=/home/web2py/applications/eden/static/formats/s3csv/hrm_import.xsl
    65 }}}
    66 
    67 ==== Old: Web2Py native ====
    68 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.
    69 
    70 Can do this via CLI (put file 'volunteers.csv' into private/import):
    71 {{{
    72 import_file = os.path.join(request.folder, "private", "import", "volunteers.csv")
    73 table.import_from_csv_file(open(import_file, "r"))
    74 }}}
    75 
    76 or Web UI (''to be checked''):
    77  * http://myhost.com/eden/vol/person.csv/create?filename=myvols.csv
    78 
    7979=== Excel via interactive UI ===
    80  * [http://wiki.sahanafoundation.org/doku.php/foundation:gsoc_kohli GSoC project] - now merged with Trunk
     80 * [http://wiki.sahanafoundation.org/doku.php/foundation:gsoc_kohli GSoC project] - merged with Trunk, but disabled by default as not fully working
    8181
    8282==== Outline ====