wiki:Event/2012/GSoC/MessageParsing

Version 8 (modified by Ashwyn, 12 years ago) ( diff )

--

Personal Details

Name: Ashwyn Sharma

Email: ashwyn1092@gmail.com

Freenode IRC Nickname: ashwyn

Skype: ashwyn sharma

Age: 19

Education: Currently pursuing B.E.(Bachelor in Engineering) from N.S.I.T, New Delhi.

Country: India

Timezone: GMT +0530

Project Abstract

The essential requirement for this project is to parse inbound messages, with an initial focus to SMS. The project is specifically aimed at the CERT usecase where they wish to process responses to deployment notifications. Or in other words, to handle replies to deployment requests. Currently the message parsing is done in the core code i.e. modules/s3/s3msg.py, to be particular, in the parse_message() method. The parsing rules will be defined in private/templates which allows for hosting of multiple profile options in the main code. Now, s3parsing.py can import these parsing rules from templates. This also enforces the on-going work in the development of the Profile Layer, in which deployment-specific files are separated from core code.The parsing module utilizes a data model "msg_workflow” to link the source and the workflow to schedule tasks. Processing of OpenGeoSMS encoded messages is also an important area to work on especially for the existing Android Client, for which it will be of real use. Also to provide robustness and extend the existing code, the pyparsing Parser module can be incorporated or any other parsing generator; which will be subjective to the parsing needs.

Project Plan

Project Deliverable: The project aims at parsing inbound messages such as SMS from CERT responders after deployment. It enables the processing of responses to deployment notifications; which is essentially controlled by the module to which the message is routed.

Project Justification: Parsing of inbound messages is a critical utility for a trained volunteer group such as CERT(Community Emergency Response Teams) where communication between various deployments and volunteers play a vital role. As this will be a deployment-specific option, the functionality becomes an important component for Sahana Eden.

Implementation Plan:

  • Keeping the development of Profile Layer in mind and the functionality being a part of deployment-specific options, the rules for parsing are contained in private/templates from where s3parsing.py imports them.

The current parsing rules implement the functionality in the following manner:

  1. The inbound message text is passed as an argument to the parse_message() method in the s3msg.py module.
  2. The text is matched with a predefined list of primary and contact keywords after splitting with whitespace as the delimiter.
  3. A database query is generated to the concerned database according to the matched keywords.
  4. The query retrieves the relevant field values and generates a reply to the inbound message query.
  5. Also these parsing rules have been implemented only for modules – ‘Person’ , ‘Hospital’ and ‘Organisation’.

Extending these rules to other modules can be in scope of the project. *One of the main issues will be identifying the messages that belong to a particular source, so it could have its own processing.Now, that here is handled by the data model which defines a ‘msg_workflow' table in the database which links the Source to the Workflow with any required args.So the essential features of this approach have been listed below:

  1. The Parser workflow table links 'SMS Source X' to 'Workflow Y'.
  2. Now, designing the details of the Workflow Y would be a developer task.
  3. Whereas linking ‘SMS X’ to ‘Workflow Y’ will be a configurable option.
  4. So essentially,the Parser Table links Source to Workflow with any other required args & this acts like a Template for the schduler_task table.
  • Now, a task process_log() is defined in tasks.py , where the objective of process_log() is to scan through all the messages in msg_log; and process those for parsing which are flagged as unparsed (is_parsed=False).The task is scheduled in zzz_1st_run.py where it is chained to the concerned parsing task(this is achieved by the msg_workflow table, the ‘source_task_id’ field in msg_log will help retrieve the respective parsing workflow_task_id from msg_workflow).
  • Also,this allows for chaining of workflows where a source for a workflow could be another workflow instead of an Incoming source.We can have 2nd-pass Parser workflows which don't start from the Source direct but can plugged as output from a 1st-pass one.

Source -> process_log() ->1st pass parser -> detailed Parser ---> Module

  • Here,the 1st pass parser is customized per-deployment;and decides which email source goes to a particular workflow (simple msg_workslow link) or decides based on other factors such as keywords to which main workflow the messages should be passed.
  • The data model is integrated with the templates folders (or a sub-folder say private/templates/parsing) which serves as the initial UI.The post-install UI will consist of a CRUD interface admin panel, a simple s3_rest_controller().However, eventually this is planned to be the part of the WebSetup.
  • We want to be able to direct the message to the appropriate module to handle the data.This could be done either by launching a real REST request or else simulating one via the API.
    resource = s3mgr.define_resource("module", "resourcename")
    
  • Messages which are routed to a specific resource can be subscribed to by the user.For this purpose,we can use the existing Save Search and Subscription functionality where the user can subscribe to new messages for a specific resource using a resource filter.The msg_log can be made a component for the resources.Now,if it's a component, then when someone opens the resource, messages will be there in a tab.Also, if the message has to be tied to multiple resources, then we can use a relationship (link) table.
  • Implementing/extending the utility for other modules especially the IRS module will be of real use, where enabling to log reports through SMS will be vital, which can also use the OpenGeoSMS encoding standards(LatLon generates a google-maps URL) for integration with our Android Client. A dedicated routine to generate OpenGeoSMS URLs already exists in prepare_opengeosms() in s3msg.py itself. So integration with the parsing routine won’t be difficult. Other modules for which this can be implemented are : ‘Request’ and ’Inventory’.
  • Finally the code will be tested on the system and the bugs (if any ;-) ) will be fixed.

Future Options:

  • Though the parsing rules will be generic , a few minor tweaks for other processes such as Email and Twitter will have to be performed to maintain its generic nature.
  • One of the most valuable functionality that can be added here is to make the SMS communication more interactive. e.g. the text body received does not match any of the expected keywords , the API dispatches a reply stating the expected format of the message.
  • Adapting the parsing rules to cover as wide a base of inbound messages as possible. This will involve making a wider collection of keywords to be searched for every concerned module.Linking different labels across the DB to module-specific keywords will be really helpful.Also the list of primary keywords to be matched can also be made a deployment-specific option.

Project Status

First trimester:

SMART Goal Status
The msg_log data model is tweaked. Completed
process_log() is put in place to schedule the parsing of inbound messages.Completed
Parsing Workflow layout is drafted Completed
Link the different inbound sources to workflowsCompleted

Timeline

First Trimester:

Due Date -SMART Goal-Measure
(24th April - 7th May)-
Development of the workflow handling module s3parsing.py starts.
-
1.Community bonding period:
I have been involved with the community for some time now, so won’t take a lot of time :)
2.Decision to outline the template.

(8th May – 21st May)-
The msg_workflow data model is developed.
S3ParsingModel starts to take shape.
-Code committed locally.


Second Trimester:

Due Date- SMART Goal -Measure
28th May -*(won’t be available due to university exams )

4th June-
CERT:Deployment Request SMS Handler development starts ( critical requirement of the project).
Parsing workflow is developed.

  • SMS response processing starts to take shape.



11th June-
CERT:Deployment Request SMS Handler development continues ( critical requirement of the project).
-
1.Code committed locally.
2.Tested on local system.

17th June-
process_log() method is designed.
Tweaks in msg_log implemented.
-Code committed to trunk.


2nd July -
Parsing workflow is chained to process_log().
Sources are linked to respective workflows.
-Code committed to trunk.




8th July -
Clickatell functionality is developed for eden.
Clickatell allows for a more robust testing mechanism.
Commits are altered with mentor feedback and suggested changes.


-
1.Commits so far tested thoroughly.
2.Bug fixing.
3.Code committed to trunk.

[Mid-Term evaluations :-) ]

Third Trimester:
Due Date-SMART Goal-Measure


15th July-
Integration with templates folders.
Development of post-install UI (CRUD interface admin panel).


  • Code committed locally.


22nd July-
Routing mechanism to resources.
Save search and subscription implemented for msg_log.
-Code committed to trunk.

29th July-
OpenGeoSMS (process_opengeosms() ) routine is tweaked and linked with the respective parsing methods.

The existing functionality in the Android Client is tested .
-Code committed to trunk.
5th August-
Integration of the IRS module for incident reporting through SMS.
The functionality is extended to other modules (if needed).
Feedback from mentors.
-Code committed locally.
13th August-
System testing & Bug fixing.
Final changes to the code are applied.

-
1.Project reaches final stage.
2.Bug fixes
3.Final Code committed to trunk.
20th August- PENCILS DOWN! -Project Completed. :-)

Note: See TracWiki for help on using the wiki.