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"
.png)
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\
.png)
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 :
{% file src="../../../.gitbook/assets/test-zip.zip" %}
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.
{% hint style="info" %} 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. {% endhint %}
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