Update Public Entities Expenditure

To update the data used at https://sandbox.vulekamali.gov.za/latest/public-entities follow these steps:

1. Prepare a CSV with the following columns:

   Name,
   Vote,
   Department,
   EntityName,
   ConsolIndi,
   PFMA,
   Type,
   EconomicClassification1,
   EconomicClassification2,
   EconomicClassification3,
   EconomicClassification4,
   EconomicClassification5,
   EconomicClassification6,
   FunctionGroup1,
   FunctionGroup2,
   FinancialYear,
   BudgetPhase,
   Amount (R-Thou,
   Amount

2KB

example_public_entities_expenditure.csv

Example CSV

1. Copy the CSV file to the server running the budgetportal app e.g. for https://sandbox.vulekamali.gov.za/ scp example_public_entities_expenditure.csv treasury6.vulekemali.gov.za

2. ssh to the server running the budgetportal app e.g. for https://sandbox.vulekamali.gov.za/ ssh treasury6.vulekemali.gov.za

3. Find the docker container ID for the budgetportal web app using docker ps e.g. for https://sandbox.vulekamali.gov.za/ docker ps returns

   
4. Now copy the CSV file into the /app directory of the running container e.g. docker cp example_public_entities_expenditure.csv 6bee9495a55a:/app

5. Now run the import using: dokku run vulekamali-budgetportal-sandbox python manage.py shell < import_plublic_entities_expenditure.py