= Pakistan =
We have a site up to support the Floods Response in Pakistan.

Site:
 * http://pakistan.sahanafoundation.org

A new !SitRep module has been built to manage:
 * Flood Reports
 * Assessments from WFP
 * School Reports
 
These can be uploaded as files, but we really want volunteers using a Mechanical Turk process to input the data into the structured fields.

We're hoping that the XLS can be imported using our new Spreadsheet Importer, so the focus should initially be on the PDFs.

== Feature Requests ==
 * Would be good to write a custom PDF writer for this format of report so we can consider getting people to enter data into DB directly.
 * When adding a new Location, pass along the appropriate Level (L3 for Assessments, L1 for Schools)

== Bugs ==
 * Setting a Parent to a GIS Location causes an error on MySQL/Python25 (sqlite on Python26 fine)
{{{
Traceback (most recent call last):
  File "gluon/restricted.py", line 186, in restricted
    exec ccode in environment
  File "/home/web2py/applications/eden/controllers/gis.py", line 1672, in <module>
  File "gluon/globals.py", line 96, in <lambda>
    self._caller = lambda f: f()
  File "/home/web2py/applications/eden/controllers/gis.py", line 491, in location
    output = shn_rest_controller(module, resource)
  File "/home/web2py/applications/eden/models/01_crud.py", line 1891, in shn_rest_controller
    res, req = s3xrc.parse_request(module, resource, session, request, response)
  File "applications/eden/modules/s3xrc.py", line 2798, in parse_request
    debug=self.debug)
  File "applications/eden/modules/s3xrc.py", line 2780, in request
    debug=self.debug)
  File "applications/eden/modules/s3xrc.py", line 1755, in __init__
    self.resource.load()
  File "applications/eden/modules/s3xrc.py", line 600, in load
    self.__set = self.__db(self.__query).select(self.table.ALL, limitby=limitby)
  File "gluon/sql.py", line 3214, in select
    rows = response(query)
  File "gluon/sql.py", line 3209, in response
    db._execute(query)
  File "gluon/sql.py", line 978, in <lambda>
    self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
  File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
}}}