GitHub

Updating Code Lists

Each year new code lists are published. Updating code lists in MSP is a multi-step process:

Retrieve datasets from DHIS2 and save as CSV
Compile code lists from ZenDesk into CSV (https://datim.zendesk.com/hc/en-us/articles/115002334246-DATIM-Data-Import-and-Exchange-Resources)
Populate empty fields in spreadsheet with DataSet data from DHIS2

Each PEPFAR code list corresponds to a Data Set in DHIS2. DHIS2 Data Sets were retrieved from dev-de.datim.org on 2019-12-05 using the query below. Code Lists were manually tabulated from ZenDisk into a spreadsheet. Code Lists and Data Sets were then matched up using the DataSet ID.

https://dev-de.datim.org/api/dataSets.csv?fields=id,href,shortName,name,code,description,periodType&paging=false

Name		Name	Last commit message	Last commit date
Latest commit History 50 Commits
.idea		.idea
assets		assets
data		data
output		output
.gitignore		.gitignore
MER 2.6 Updates and Changes - 29Sep2021.md		MER 2.6 Updates and Changes - 29Sep2021.md
README.md		README.md
build_ocl_import.py		build_ocl_import.py
export_datim_metadata.py		export_datim_metadata.py
generate_full_codelist_spreadsheet.py		generate_full_codelist_spreadsheet.py
get_ocl_bulk_import_results.py		get_ocl_bulk_import_results.py
msp.py		msp.py
process_bulk_import_results.py		process_bulk_import_results.py
process_csv2json.py		process_csv2json.py
requirements.txt		requirements.txt
run_ocl_import.py		run_ocl_import.py
save_codelists_to_file.py		save_codelists_to_file.py
settings.py		settings.py
settings.py.backup		settings.py.backup
validate_ocl_codelists.py		validate_ocl_codelists.py