Man pages for USAID-OHA-SI/Interesting
Interesting

check_contentValidate output content
check_disaggsValidate disaggs for export
check_distinct_ousCheck OUs listed in operatingunit
check_indsValidate indicators for export
check_mechsValidate Implementing Mechanisms for export
check_metaInspect Meta data
check_numdenomValidate Numerator/Denominator for export
check_operatingunitCheck OU
check_orgunituidsValidate orgunituids
check_output_colsValidate columns for export
check_tabsValidate Submission's tabs for import
cir_archiveArchive submissions files
cir_extract_metaExtract Meta Data Information about Template
cir_folderGet processing folder path
cir_gatherReshape CIR Data frame to long
cir_importImport template sheet(s)
cir_join_metaJoin Meta to Dataset
cir_munge_stringclean up/standardize string text for indicators and disaggs
cir_outputOutput intermediate data for files
cir_processingProcess CIR Submissions
cir_reshapeTransform CIR Data Frame
cir_restrict_colsRestrict CIR data frame columns
cir_setupSetup processing folders
cir_store_metaStore Meta Data Information about Template
cir_template_colsValidate template
cir_template_taExtract Technical Areas
cir_vsheetsGet list of visible excel sheets
count_missingCount missing values
datim_mechsPull Orgunits
datim_orgunitsPull Orgunits
datim_sqlviewsQuery Datim SQLViews
empty_to_chrReturn none if vector/list is empty
flag_extraFlag Extra Variables
flag_missingFlag Missing Variables
get_missingGet rows with missing values
Interesting-packageInteresting: Interesting
is_cirgtabDetermine if there are tabs to import
is_mech4ouValidate mechanism code
is_mech_validValidate mechanism code
is_metatabDetermine whether meta tab exists
is_orgunituid4ouCheck if orgunituid exist in operating unit
is_orgunituid_validCheck if Operating Unit name is valid
is_ou_validCheck if OperatingUnit is valid
match_valueGet rows with values not matching a pattern
na_to_chrNot available if na
null_to_chrNot provided if null
paint_bluePaint console text in blue
paint_greenPaint console text in green
paint_ifemptyPaint if empty
paint_ifnaPaint if na
paint_ifnullPaint if null
paint_iftruePaint if true
paint_redPaint console text in red
paint_yellowPaint console text in yellow
pipePipe operator
pull_mechPull Partner/Mechanism Info from DATIM
template_cols_longColumn names for FY22 CIRG Long Template
update_meta_mechsUpdate USAID Mechanism meta table
validate_importValidation on import
validate_initialInitial Validation on Submitted template
validate_outputValidation Checks
var_existsCheck if all variables exist
var_matchesCheck if any variable matches this pattern
USAID-OHA-SI/Interesting documentation built on Jan. 26, 2023, 5:57 p.m.