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.Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.