- Update
pepfar_data_calendar
with the FY25 dates that were released [2024-09-30] - Reconfigure
load_secrets
for local handing of PDAP [2024-07-02] - Improve messages issued with
load_secrets
[2024-07-02] - Fix bug within
pdap_bucket
resulting from a missing parentheses [2024-07-02] - Resolve issue with
datim_user
when no user was stored, which resulting from the wrong object used [2024-05-23] - Update
is_stored
to return TRUE for "pdap" when working from Posit Workbench [2024-04-02] - Setup
return_latest
to provide key to latest file that exists in the MSD folder in PDAP when working from Posit Workbench [2024-04-01] - Have
si_path()
return the path to the MSD folder (Sys.getenv("S3_READ")
) when working from Posit Workbench [2024-04-01] - Upload
load_secrets
andis_stored
to work with PDAP, both locally and in Posit Workbench [2024-04-01] - Add PDAP function,
pdap_access
,pdap_secrets
, andpdap_bucket
, to work out of the PEPFAR Workbench environment with s3 [2024-04-01]
- Update the ability to launch the folder path on any OS (previously just Windows) with
temp_folder
[2024-03-28] - Update
convert_datim_pd
to reflect new date structure output from DATIM [2024-03-21] - Change instructions to install from rOpenSci [2024-01-04]
- Update
pepfar_data_calendar
with FY24 dates [2023-11-15] - Added an option to silence the output of
temp_folder
andreturn_latest
for use within functions [2023-10-11] - New version documtnation style. Patches/very minor changes will be updated as a patch (X.X.X) and updates on this NEWS page will fall under the minor (X.X) version [2023-10-11]
- Add in
gen_ref_id
to be used as a one off outside of a snippet [2023-10-03] - Include the list of 8 + 1 + 1 countries prioritized by PEPFAR in
pepfar_country_list
under the variablepepfar_accel
[2023-08-03] - Resolve duplication occuring when running
si_setup
in.gitignore
[2023-08-02] - Add additional file types specificed in
usethis::git_vaccinate
to ignore [2023-08-02] - Update
return_latest
to filter on the date modifed (mdate
) rather than the date created (cdate
) [2023-08-01] - Add
Data_public
folder to be generated when runningsi_setup
[2023-04-13] - Modified file extensions to be ignored in
setup_gitignore
[2023-04-13]
- Add
set_key
,get_key
andget_keys
for generic account credentials management - Add
get_services
as a lookup function for existing keyring services - Add
get_account
andset_account
to groupget_*
andset_*
into 1 function
- Update
pepfar_country_list
andpepfar_country_xwalk
to reflect FY23 PEPFAR funding countries [2023-02-23] - Print out the file name when using
return_latest
[2023-02-23] - Updates
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] - Add
msd_release
topepfar_data_calendar
and updated Q4 clean release date to match new calendar [2022-08-16] - Fully depricate
my_pwd()
[2022-08-05] - Migrate MSD/FSD related functions to
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] - Migrate API related function (DATIM, Pano, s3) and vignette to
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]
- Update
pepfar_country_list
andpepfar_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) - Add
pano_extract_msds
function to extract latest available MSDs from PEPFAR Panorama to local directory. - Add
curr_date
function for on demand formatting ofSys.Date()
values - Add
open_path
function to help with navigating to directories and viewing with file content
- Add
pluck_totals
function to filter dataframe to just Total Numerator and Denominator (2022-05-27) - Update references to old variable names in
get_outtable
,identify_levels
,get_ouuids
,get_ouuid
,get_levels
,get_ouorglevel
,get_ouorglabel
andresolve_knownissues
as well as with the raw data. The new names went into effect FY22Q2 (2022-04-08) - Add DATIM UIDs to
pepfar_country_list
(2022-04-08)
- Resolve grepel bug with
datim_dim_items
which kept the function from running (2022-04-15) - Create a new period calculation,
convert_fy_qtr_to_pd
, usingfiscal_year
and quarter column to make it easier to create a period variable when not usinggophr::reshape_msd()
. (2022-04-07) - Update both
pepfar_country_list
andpepfar_country_xwalk
to include Benin, now reporting into PEPFAR starting in FY22 (2022-02-22) - Update
source_info
to look for FY20 MSD filename as a default as opposed to FY19 (2022-02-22)
- Resolve bug with
get_outable
which did not use the user defined base url when runningidentify_ouuids
, resulting in a user without a final.datim.org account to not access the table. - Fixed bug with
resolve_issues
that left of a column, breaking the function when run. - Removed paging from
datim_dim_items
to return full set of dimensions - Adjust
source_info
to handle dates for the FSD that are out of sync with the PEPFAR calendar. - Included removal of central supporting from
resolve_knowissues
by default, which can also be run separately usingremove_centralsupport
. - Update
resolve_knownissues
to handle working with financial data as well as MER. - Has
resolve_knownissues
check Rprofile to see if authentication is stored there (fromset_email
) if not loaded in session. - Update
clean_agency
to move State (State/AF, etc.) and USAID (USAID/WCF) subsidiaries under their parent agencies
- Resolve bug with
resolve_knownissues
that resulted from having both targets and results for the same mechanism and indicator that need to be removed. - Add set of functions to store, access, and load Panorama credentials -
set_pano
,pano_user()
,pano_pwd()
,pano_session()
, andload_secrets()
. - Add functions to discover and download output datasets from Panorama:
pano_content()
,pano_elements()
,pano_unpack()
,pano_extract()
,pano_download()
,pano_items()
,pano_extract_msd()
- Update
pepfar_data_calendar
with FY22 dates
- Fixed
source_info()
to allow it to work correctly with FSD (misspelling in the filename). - Allow user to just flag, not remove SCH mechanism in
remove_sch()
. - Resolve bug with new code for
set_path
, causing an error if any path was missing from the .Rprofile - The new
temp_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. - Used
pkgdown
to create a site - If no username/password are provided to
get_outable()
,identify_ouuids()
oridentify_levels()
, defaults to usingdatim_user()
anddatim_pwd()
- Adjust
get_outable()
/identify_levels()
output, changing community to community_lvl and prioritization to psnu_lvl to match other indicators. - Include two new function to convert dates to periods and periods to dates using
convert_date_to_qtr()
andconvert_qtr_to_date()
. - New vigentte for project workflow added,
vignette(package = glamr)
- Update
set_paths()
, allowing forpath_downloads
and improve backend efficiency. - Store email in .Rprofile in addition to keyring using
set_email()
for use withgoogledrive::drive_auth()
andgooglesheets4::gs4_auth()
without having to provide an email. - Add
clean_filename()
function to remove apostrophe and other pesky characters from a filename, especially for use when uploading to Google Drive. - Adjust
load_secrets()
to allow user to specify which accounts to load in a session. - Depricate
mypwd()
which has been superseded bydatim_pwd()
. - Create
source_info
function to extract information from the file to use in the caption/source. - Adjust
setup_gitignore()
andsetup_readme()
to not duplicate text if its already exists - Add a missing append to
setup_gitignore()
to not overwrite existing file. - Add
pepfar_data_calendar
data frame to be used in conjunction with source info. - Add
pepfar_country_list
data frame to have a set of PEPFAR countries and their ISO codes. - Add
pepfar_country_xwalk
data frame as a cross-walk for PEPFAR, UN, CountryCode country names - Add
datim_*
functions for datim queries - Edited
clean_countries()
to account for short version of PEPFAR OU/Countries - Added a
NEWS.md
file to track changes to the package.
- Prior to verion 1.0.0, updates were not captured.