In-year spending data
Last updated
Last updated
The in-year spending data is quarterly updates of monthly spend actuals. You can find the details of the format of the file that should be uploaded below. Also see the dataset guide for details of fields and what's expected.
The feature is disabled upon release, to be enabled when the data is all uploaded and ready for presentation.
Once ready for use, enable presentation of the data in charts using the IN_YEAR_SPENDING_ENABLED Constance Config option
To upload IYM data using the CMS, click the "Add" button next to "Iym file uploads"
In the upload page select the financial year, latest quarter and the file to be uploaded. Selected file must be a zip file containing the data csv
Csv file needs to contain these columns
Vote No#
Department
Programme No#
Programme
Subprogramme No#
Subprogramme econClass_L1
econClass_L2
econClass_L3
econClass_L4
econClass_L5
IYM_econLowestLevel
Item_Lowest_Level
Assets_Level_1
Assets_Level_2
Assets_Level_3
Assets_Level_4
Assets_Level_5
Assets_Level_6
Assets_Lowest_Level
Project_Level_1
Project_Level_2
Project_Level_3
Project_Level_4
Project_Level_5
Project_Level_6
Project_Level_7
Project_Level_8
Project_Level_9
Project_Level_10
Project_Level_11
Project_Lowest_Level
Responsibility_Level_2
Responsibility_Level_3
Responsibility_Level_4
Responsibility_Level_5
Responsibility_Level_6
Responsibility_Level_7
Responsibility_Level_8
Responsibility_Level_9
Responsibility_Level_10
Responsibility_Level_11
Responsibility_Level_12
Responsibility_Level_13
Responsibility_Level_14
Responsibility_Level_15
Responsibility_Lowest_Level
Fund_Level_1
Fund_Level_2
Fund_Level_3
Fund_Level_4
Fund_Level_5
Fund_Level_6
Fund_Level_7
Fund_Level_8
Fund_Lowest_Level
Infrastructure_Level_1
Infrastructure_Level_2
Infrastructure_Level_3
Infrastructure_Level_4
Infrastructure_Level_5
Infrastructure_Level_6
Infrastructure_Lowest_Level
Item_Level_1
Item_Level_2
Item_Level_3
Item_Level_4
Item_Level_5
Item_Level_6
Item_Level_7
Item_Level_8
Regional_ID_Level_1
Regional_ID_Level_2
Regional_ID_Level_3
Regional_ID_Level_4
Regional_ID_Level_5
Regional_ID_Level_6
Regional_ID_Level_7
Regional_ID_Level_8
Regional_ID_Lowest_Level
Budget
AdjustmentBudget
April
May
June
July
August
September
October
November
December
January
February
March
Q1
Q2
Q3
Q4
Financial_Year
Here is an example zip file containing a csv :
Once you select the financial year, latest quarter and the file to be uploaded clicking "Save" button will start the upload process. The file will be uploaded to Openspending.
A dataset will be created in the CKAN and the url of the file will be added as a resource to the CKAN dataset. Subsequent uploads for the same financial year will replace the data in OpenSpending and update latest_quarter property of the dataset.
Upload the quarterly zip file and Excel PowerPivot to the dataset in CKAN for people who want to download the whole file. Name the file and resource according to the sphere and latest financial year and quarter included - e.g. National in-year spending 2019-20 Quarter 2
This can happen when an expected column is not found. That can occur when the file is formatted incorrectly, e.g. when semicolons are used as the field separator instead of comma. See the CSV Formatting guidelines https://maintenance.vulekamali.gov.za/design/data-formats
