...
- Get the updated "Lookup Tables v15.xls" document
- Open "Lookup Tables v15.xls" in OpenOffice Calc and navigage to the "<country_name> Mifos" tab for the country who's data has changed.
- Do a "Save As..." in CSV format to the $PPI_BASE/data/percents/<CountryName>.csv file
- run $PPI_BASE/parseall_percents.sh to regenerate the poverty line files (generated/povertylines/*PovertyLines.sql
- 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
...