[jira] [Created] (FINERACT-28) Convert PPI Scorecards and Lookup Tables to JSON Format

["Dayna Harp (JIRA)" <ji...@apache.org>]

Dayna Harp created FINERACT-28:
----------------------------------

             Summary: Convert PPI Scorecards and Lookup Tables to JSON Format
                 Key: FINERACT-28
                 URL: https://issues.apache.org/jira/browse/FINERACT-28
             Project: Apache Fineract
          Issue Type: New Feature
          Components: Surveys
            Reporter: Dayna Harp
            Assignee: Markus Geiss
            Priority: Minor


https://mifosforge.jira.com/browse/MIFOSX-2407 - see attachment & subtask 

For additional country scorecards to be available in our Surveys/SPM Framework, we need for both the official scorecard and lookup table at http://progressoutofpoverty.org to be converted to JSON format.

We would like to have each country where the PPI is available to be supported as part of the surveys framework in Mifos X. 


We have some of the lookup tables in CSV format (see attached zip) but most will need to be converted from PDF to the proper JSON format. Please see reference examples. Each lookup table and survey is located on the PPI website under Find your PPI (you must be authenticated to download)

Right now the conversion process will have to be done manually. Using the PPI uploader tool, a volunteer can manually create JSON lookup tables and surveys for each country by doing:

# Fork the PPI Uploader tool at https://github.com/mgeiss/ppi-uploader/
# Navigate to the template folder: https://github.com/mgeiss/ppi-uploader/tree/master/src/main/resources/template
# Create a new directory for each country with the two-letter country code (reference here for the list: http://www.worldatlas.com/aatlas/ctycodes.htm) 
# Within that directory create lookuptable.json (https://github.com/mgeiss/ppi-uploader/blob/master/src/main/resources/template/PH/lookuptable.json) following the PH as an example but using the data from the PDF of the lookup table for that country
# Within the same directory create survey.json (https://github.com/mgeiss/ppi-uploader/blob/master/src/main/resources/template/PH/survey.json) following the PH one as an example but using data from the PDF of the survey/scorecard for that country. 
# Update countries.json with the country code at https://github.com/mgeiss/ppi-uploader/blob/master/src/main/resources/template/countries.json

Priority of countries we want added can be found at: https://goo.gl/h7X9Jc



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)