Uploaded image for project: 'Apache Fineract'
  1. Apache Fineract
  2. FINERACT-28

Convert PPI Scorecards and Lookup Tables to JSON Format



    • New Feature
    • Status: Closed
    • Minor
    • Resolution: Auto Closed
    • None
    • None
    • Surveys


      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:

      1. Fork the PPI Uploader tool at https://github.com/mgeiss/ppi-uploader/
      2. Navigate to the template folder: https://github.com/mgeiss/ppi-uploader/tree/master/src/main/resources/template
      3. 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)
      4. 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
      5. 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.
      6. 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




            Unassigned Unassigned
            dharp@mifos.org Dayna Harp
            0 Vote for this issue
            0 Start watching this issue