|Version 6 (modified by 13 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.
- 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/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