Page Comparison

...

1. get the updated Word document for the country from the SPM team
2. from OpenOffice Writer open the document and then "saveAs" choosing "Text Encoded" and then "Western Europe (ASCII/US)" and save the file into $PPI_BASE/data/<CountryName>.txt which should replace the existing file
3. update the line for this country in nicknames.csv, increasing the pointsVersion by 1
4. run $PPI_BASE/parseall.sh to regenerate the Mifos PPI files
5. include the updated $PPI_BASE/generated/scoringEtl/<country><year>PPIScore.sql in load_dw_ppi_survey.sql (which loads all scoring sql)
   • cat generated/scoringEtl/*PPIScore.sql > ../JohnWoodlockWorkInProgress/MifosDataWarehouseETL/load_dw_ppi_survey.sql

When changes are made to PPI category likelihood (poverty line) values.

1. Get the updated "Lookup Tables v15.xls" document
2. Open "Lookup Tables v15.xls" in OpenOffice Calc and navigage to the "<country_name> Mifos" tab for the country who's data has changed.
3. Do a "Save As..." in CSV format to the $PPI_BASE/data/percents/<CountryName>.csv file
4. run $PPI_BASE/parseall_percents.sh to regenerate the poverty line files (generated/povertylines/*PovertyLines.sql
5. put all the poverty line sql into a single file that is loaded by the data warehouse
   • mv ../JohnWoodlockWorkInProgress/MifosDataWarehouseETL/load_ppi_poverty_lines.sql /tmp
   • cat generated/povertyLines/*.sql > ../JohnWoodlockWorkInProgress/MifosDataWarehouseETL/load_ppi_poverty_lines.sql

When changes are made to PPI survey question/answer text.

...