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)
• onvalidation to total male+female in the School Reports

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
  

---

Deployments