Changes between Version 38 and Version 39 of UserGuidelines/Importer


Ignore:
Timestamp:
01/31/12 08:39:37 (10 years ago)
Author:
Fran Boon
Comment:

Rework CSV section

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Importer

    v38 v39  
    1212Can import data from spreadsheets in CSV (Comma Separated Values) format as long as it is formatted properly.
    1313
    14 ==== Import Tool ====
    15 ''Administrators Only''
    16  1. Menu: Administrator > Import
    17  1. Click: Import New File
    18  1. Select {{{Type}}}
    19   * Once you've selected the {{{Type}}}, you can {{{Download Template}}} to get a CSV template which can be filled out them imported
    20  1. Choose a file to import (either the template which has been filled out, or another file)
    21  1. Click "Import"
     14This can be done to [BluePrint/PrePopulate PrePopulate] an instance.
    2215
    23 ==== New: S3CSV ====
    24 The best approach is to create a CSV format & matching stylesheet which can be imported using on-the-fly-transformation:
     16After 1st run, there are menu links for many resources, but any REST controller can have the 'import' method invoked if there is a suitable .xsl file as {{{static/formats/s3csv/module/resource.xsl}}}:
     17{{{
     18http://host.domain/module/resource/import
     19}}}
     20
     21Files & Stylesheets can be loaded from alternate sources, such as:
    2522{{{
    2623http://host.domain/eden/hrm/person.s3csv/create?fetchurl=http://my.host/HR.csv&transform=/home/web2py/applications/eden/static/formats/s3csv/hrm_import.xsl
    2724}}}
     25
     26Alternately these can be done using CLI scripts:
     27* [wiki:S3/DataImportCLI DataImportCLI]
     28
    2829
    2930==== Old: Web2Py native ====
     
    174175
    175176== See Also ==
     177 * BluePrintImporter
     178 * [BluePrint/PrePopulate PrePopulate]
     179 * [wiki:S3/DataImportCLI DataImportCLI]
    176180 * [wiki:S3XRC/S3XML/Transformation On-the-fly Transformation using external Stylesheets]
    177  * BluePrintImporter
    178181
    179182----