Changes between Version 13 and Version 14 of TaiwanSettings

Timestamp:

01/22/12 14:46:37 (13 years ago)

Author:

Fran Boon

Comment:

--

TaiwanSettings

@@ -27 +27 @@
 == To Import Admin Names for Taiwan ==
 
-Usually this is the initial and one-time work. Enter the CLI environment to run commands:
-
+Add this to your [BluePrint/PrePopulate Prepopulate] tasks.cfg: 
 {{{
-  $ python web2py.py -S eden -M
+gis,location,TWL1.csv,location.xsl
+gis,location,TWL2.csv,location.xsl
+gis,location,TWL3.csv,location.xsl
 }}}
-
-Make sure `modules/s3gis.py` containing `utf8_csv_reader()`, which is included since [http://bazaar.launchpad.net/~flavour/sahana-eden/trunk/revision/1413 rev1413]. Place `L1.csv, L2.csv, L3.csv` in the top level of `web2py` directory.
-
-{{{
-  >>> tablename = "gis_location"
-  >>> table = db[tablename]
-  # Example to look for a record's id
-  >>> db(table.name == "Taiwan").select().first().id
-  215
-  # L0
-  >>> db(table.name != "Taiwan").delete()
-  # Here will show the number of deletion
-  >>> db.commit()
-  # L1
-  >>> gis.import_csv("L1.csv")
-  >>> db.commit()
-  # L2
-  >>> gis.import_csv("L2.csv")
-  >>> db.commit()
-  # L3
-  >>> gis.import_csv("L3.csv")
-  >>> db.commit()
-  # Example to look for records matching a name
-  >>> db.executesql("SELECT * FROM gis_location WHERE name = '光復里' and level = 'L3'")
-  # Here will show a list of 13 tuples. Use SELECT count(*) in the above statement to verify.
-}}}
-
 == To Enable OpenID Auth ==