Version 6 (modified by Fran Boon, 14 years ago) ( diff )



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


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


  • Setting a Parent to a GIS Location causes an error on MySQL/Python25 (sqlite on Python26 fine)
    Traceback (most recent call last):
      File "gluon/", line 186, in restricted
        exec ccode in environment
      File "/home/web2py/applications/eden/controllers/", line 1672, in <module>
      File "gluon/", line 96, in <lambda>
        self._caller = lambda f: f()
      File "/home/web2py/applications/eden/controllers/", line 491, in location
        output = shn_rest_controller(module, resource)
      File "/home/web2py/applications/eden/models/", line 1891, in shn_rest_controller
        res, req = s3xrc.parse_request(module, resource, session, request, response)
      File "applications/eden/modules/", line 2798, in parse_request
      File "applications/eden/modules/", line 2780, in request
      File "applications/eden/modules/", line 1755, in __init__
      File "applications/eden/modules/", line 600, in load
        self.__set = self.__db(self.__query).select(self.table.ALL, limitby=limitby)
      File "gluon/", line 3214, in select
        rows = response(query)
      File "gluon/", line 3209, in response
      File "gluon/", line 978, in <lambda>
        self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
      File "/var/lib/python-support/python2.5/MySQLdb/", line 166, in execute
        self.errorhandler(self, exc, value)
      File "/var/lib/python-support/python2.5/MySQLdb/", 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


Note: See TracWiki for help on using the wiki.