NEWS.md
pepfar_data_calendar with the FY25 dates that were released [2024-09-30]load_secrets for local handing of PDAP [2024-07-02]load_secrets [2024-07-02]pdap_bucket resulting from a missing parentheses [2024-07-02]datim_user when no user was stored, which resulting from the wrong object used [2024-05-23]is_stored to return TRUE for “pdap” when working from Posit Workbench [2024-04-02]return_latest to provide key to latest file that exists in the MSD folder in PDAP when working from Posit Workbench [2024-04-01]si_path() return the path to the MSD folder (Sys.getenv("S3_READ")) when working from Posit Workbench [2024-04-01]load_secrets and is_stored to work with PDAP, both locally and in Posit Workbench [2024-04-01]pdap_access, pdap_secrets, and pdap_bucket, to work out of the PEPFAR Workbench environment with s3 [2024-04-01]temp_folder [2024-03-28]convert_datim_pd to reflect new date structure output from DATIM [2024-03-21]pepfar_data_calendar with FY24 dates [2023-11-15]temp_folder and return_latest for use within functions [2023-10-11]gen_ref_id to be used as a one off outside of a snippet [2023-10-03]pepfar_country_list under the variable pepfar_accel [2023-08-03]si_setup in .gitignore [2023-08-02]usethis::git_vaccinate to ignore [2023-08-02]return_latest to filter on the date modifed (mdate) rather than the date created (cdate) [2023-08-01]Data_public folder to be generated when running si_setup [2023-04-13]setup_gitignore [2023-04-13]set_key, get_key and get_keys for generic account credentials managementget_services as a lookup function for existing keyring servicesget_account and set_account to group get_* and set_* into 1 functionpepfar_country_list and pepfar_country_xwalk to reflect FY23 PEPFAR funding countries [2023-02-23]return_latest [2023-02-23]pepfar_data_calendar to reflect (1) Q4i close on 10 Nov [MER late close on 14 Nov] and (2) new FY23 PEPFAR calendar (removes FY21) [2022-11-28]msd_release to pepfar_data_calendar and updated Q4 clean release date to match new calendar [2022-08-16]my_pwd() [2022-08-05]gophr: apply_partner_type, browse_knownissues, clean_agency, clean_column, clean_indicator, clean_psnu, pluck_totals, remove_centralsupport, remove_mo, remove_sch, resolve_knownissues, source_info [2022-08-05]grabr: datim_dim_item, datim_dim_items, datim_dim_url, datim_dimension, datim_dimensions, datim_execute_query, datim_pops, datim_process_query, datim_query, get_levels, get_orguids, get_ouorglabel, get_ouorglevel, get_ouorgs, get_ouorguids, get_outable, get_ouuid, get_ouuids, identify_levels, identify_ouuids, lazy_secrets, package_check, pano_content, pano_download, pano_elements, pano_extract, pano_extract_msd, pano_extract_msds, pano_items, pano_session, s3_buckets, s3_download, s3_excel_sheets, s3_object_type, s3_objects, s3_read_object, s3_remove, s3_unpack_keys, s3_upload [2022-08-05]pepfar_country_list and pepfar_country_xwalk to reflect countries that receive any PEPFAR funding (budgets for the current FY) instead of just those that report MER indicators (2022-08-02)pano_extract_msds function to extract latest available MSDs from PEPFAR Panorama to local directory.curr_date function for on demand formatting of Sys.Date() valuesopen_path function to help with navigating to directories and viewing with file contentpluck_totals function to filter dataframe to just Total Numerator and Denominator (2022-05-27)get_outtable, identify_levels, get_ouuids, get_ouuid, get_levels, get_ouorglevel, get_ouorglabel and resolve_knownissues as well as with the raw data. The new names went into effect FY22Q2 (2022-04-08)pepfar_country_list (2022-04-08)datim_dim_items which kept the function from running (2022-04-15)convert_fy_qtr_to_pd, using fiscal_year and quarter column to make it easier to create a period variable when not using gophr::reshape_msd(). (2022-04-07)pepfar_country_list and pepfar_country_xwalk to include Benin, now reporting into PEPFAR starting in FY22 (2022-02-22)source_info to look for FY20 MSD filename as a default as opposed to FY19 (2022-02-22)get_outable which did not use the user defined base url when running identify_ouuids, resulting in a user without a final.datim.org account to not access the table.resolve_issues that left of a column, breaking the function when run.datim_dim_items to return full set of dimensionssource_info to handle dates for the FSD that are out of sync with the PEPFAR calendar.resolve_knowissues by default, which can also be run separately using remove_centralsupport.resolve_knownissues to handle working with financial data as well as MER.resolve_knownissues check Rprofile to see if authentication is stored there (from set_email) if not loaded in session.clean_agency to move State (State/AF, etc.) and USAID (USAID/WCF) subsidiaries under their parent agenciesresolve_knownissues that resulted from having both targets and results for the same mechanism and indicator that need to be removed.set_pano, pano_user(), pano_pwd(), pano_session(), and load_secrets().pano_content(), pano_elements(), pano_unpack(), pano_extract(), pano_download(), pano_items(), pano_extract_msd()
pepfar_data_calendar with FY22 datessource_info() to allow it to work correctly with FSD (misspelling in the filename).remove_sch().set_path, causing an error if any path was missing from the .Rprofiletemp_folder() creates and stores a folder in your Global Envir to use, which will be automatically be deleted on the end of your RStudio session.pkgdown to create a siteget_outable(), identify_ouuids() or identify_levels(), defaults to using datim_user() and datim_pwd()
get_outable()/identify_levels() output, changing community to community_lvl and prioritization to psnu_lvl to match other indicators.convert_date_to_qtr() and convert_qtr_to_date().vignette(package = glamr)
set_paths(), allowing for path_downloads and improve backend efficiency.set_email() for use with googledrive::drive_auth() and googlesheets4::gs4_auth() without having to provide an email.clean_filename() function to remove apostrophe and other pesky characters from a filename, especially for use when uploading to Google Drive.load_secrets() to allow user to specify which accounts to load in a session.mypwd() which has been superseded by datim_pwd().source_info function to extract information from the file to use in the caption/source.setup_gitignore() and setup_readme() to not duplicate text if its already existssetup_gitignore() to not overwrite existing file.pepfar_data_calendar data frame to be used in conjunction with source info.pepfar_country_list data frame to have a set of PEPFAR countries and their ISO codes.pepfar_country_xwalk data frame as a cross-walk for PEPFAR, UN, CountryCode country namesdatim_* functions for datim queriesclean_countries() to account for short version of PEPFAR OU/CountriesNEWS.md file to track changes to the package.