How to update sandbox-reporting with new PPI ETL Reports or Mifos war

To update the sandbox-reporting server with new PPI and/or ETL:

  1. Make changes to PPI/ETL/Reports and commit to mifos/bi
  2. go to sandbox-reporting:/home/ubuntu/bi and get the latest from git (e.g. git fetch; git rebase origin/master)
    • the latest ETL will now be in the bi directory where it can be run directly (e.g. bi/JohnWoodlockWorkInProgress/MifosDataWarehouseETL/full_reload.sh mifos_sandbox_dw /opt/pentaho/data-integration)
    • the latest reports will be in bi/reports/*
  3. copy the updated reports to the target pentaho bi server (could be /opt/pentaho or /opt/pentaho-3.7.0.RC1) (e.g. cp reports/ppiReports/DataDumpReport.prpt /opt/pentaho-3.7.0.RC1/biserver-ce/pentaho-solutions/PPI/)

To update the Mifos war:

  1. get the latest mifos war on sandbox-reporting
  2. use the standard procedure to update the war in /opt/mifos-sandbox/tomcat6/webapps