Changes between Version 38 and Version 39 of UserGuidelines/Importer
- Timestamp:
- 01/31/12 08:39:37 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UserGuidelines/Importer
v38 v39 12 12 Can import data from spreadsheets in CSV (Comma Separated Values) format as long as it is formatted properly. 13 13 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" 14 This can be done to [BluePrint/PrePopulate PrePopulate] an instance. 22 15 23 ==== New: S3CSV ==== 24 The best approach is to create a CSV format & matching stylesheet which can be imported using on-the-fly-transformation: 16 After 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 {{{ 18 http://host.domain/module/resource/import 19 }}} 20 21 Files & Stylesheets can be loaded from alternate sources, such as: 25 22 {{{ 26 23 http://host.domain/eden/hrm/person.s3csv/create?fetchurl=http://my.host/HR.csv&transform=/home/web2py/applications/eden/static/formats/s3csv/hrm_import.xsl 27 24 }}} 25 26 Alternately these can be done using CLI scripts: 27 * [wiki:S3/DataImportCLI DataImportCLI] 28 28 29 29 30 ==== Old: Web2Py native ==== … … 174 175 175 176 == See Also == 177 * BluePrintImporter 178 * [BluePrint/PrePopulate PrePopulate] 179 * [wiki:S3/DataImportCLI DataImportCLI] 176 180 * [wiki:S3XRC/S3XML/Transformation On-the-fly Transformation using external Stylesheets] 177 * BluePrintImporter178 181 179 182 ----