= Pre-Populate = 

== Introduction ==
We need to 

== Types of Data ==
 * Item Catalogue
 * Organisation List
 * Assets
 * Warehouse Supplies
 * Human Resources (Staff & Volunteers)

== Methods ==
=== URL Import ===
Data can be imported using URL calls:
{{{
http://127.0.0.1:8000/eden/supply/item/create.s3csv
?filename=/home/web2py/applications/eden/static/formats/s3csv/eric.csv
&transform=/home/web2py/applications/eden/static/formats/s3csv/eric.xsl
}}}

However this mehtod isn't easily automated[[BR]]

Also see: UserGuidelinesImporter
=== Python Script ===
This offers us better options to automate the import of data.
{{{
# Function to handle conflicts
s3mgr.resolve = response.s3.item_deduplicate
resource = s3mgr.define_resource("supply", "item")
resource.import_xml(open("/home/web2py/applications/eden/static/formats/s3csv/eric.csv", "r"),
                    format="csv",
                    stylesheet="/home/web2py/applications/eden/static/formats/s3csv/eric.xls")
}}}
Should we have a wrapper function for this which is easily accessed from the CLI?

== Location for Pre-populate Data ==
=== Proposal ===
/private/
 * transform (ALL xsl files. Any CSV should automatically use the xsl with the same name in the same directory in this folder. If multiple csv files need to use the same xsl transfor give the a "__XXX" double underscore suffix, eg. {{{eric__complete.csv}}}, {{{eric__sample.csv}}} can both use  {{{supply/eric.xls}}} )
  * module 0
  * ...
  * module n
 * prepopulate
  * demo
   * module 0
   * ...
   * module n
  * regression 
   * module 0
   * ...
   * module n
  * user (private prepopulate data - not shared in bzr branch)
   * module 0
   * ...
   * module n
  * drrpp (deployment with data which can be shared)
   * module 0
   * ...
   * module n
 * ... (other deployments with public data)
   * module 0
   * ...
   * module n

/static/prepopulate / 
 * templates (csv files with header row only)
  * module 0
  * ...
  * module n

Rational:
 * Should separate csv from xsl (xsl could very easily confuse semi-technical users)
 * CSV templates should be easily downloaded - prepopulate data should not (always) be
 * All XLS should be in trunk (even if it is for private data) and have a matching CSV Template
 * Then a configuration file can be created where you can just list the CSV file names which you want to be imported when Sahana Eden is initialized. Copies of this files could be saved in the private/prepopulate/<deployment>/ directory then a config setting could select which file to use, to make it easy to set up Sahana Eden to have different types of data in it.