Man pages for brucemoran/shinySetupPostgreSQL
Read XLSX, RDS and CMD PDF files into a PostgreSQL table using Shiny.

colExtantTest if a column exists
date_as_classTake a tibble with colnames to match pattern and force to...
date_table_colsColumns that are date
grep_choice_selectinFor selectizeInput, grep on set of choices as to what is most...
grep_choice_selectin_vecSet of predetermined named vector for grep_choice_selectin()
grepSpecColumn grep from vector of terms grep spectaculare
import_cmd_pdfParse CMD PDF reports, very hacky
inputDatRead sheets from XLSX
inputDataTests for previous input data, and/or takes input from user...
input_from_xlsxInput XLSX file parsing
input_xlsxInput XLSX file parsing
launchSSPLaunch the app
macroDissectParse macrodissection into correct format ensures that data...
mod_add_columnOpens modal (text-box for input) to ask for name of new...
mod_delete_columnOpens modal to ask for columns to delete (only those without...
mod_disc_db_conDisconnection from Postgresql
mod_load_data_proceedTell user a table they are trying to create exists and will...
mod_map_columnsOpens modal to ask for map from data column to table column
mod_order_columnOpens modal (dropdowns for input) to ask for orders of...
mod_rename_columnOpens modal (dropdowns for input) to ask for column to rename
mod_saving_toOpens modal telling save location
mod_sure_to_saveOpens modal (text-box for input) to ask if save should go...
mod_test_db_conTest if connection to Postgresql can be made
mod_test_db_resultsTest connection to Postgresql, handle success and error
mod_uniq_columnsOpens modal (dropdowns for input) to ask for columns to...
mod_validate_user_condConditionally show advanced connection options for...
mod_validate_user_ntOpens modal (text-box for input) to ask for user credentials
mutationStatusParse mutation status into correct format ensures that data...
new_table_colsColumns for new table
new_table_reqsRequired columns for new table
numeric_table_colsColumns that are numeric
obsev_add_colAdd column into table
obsev_arr_colMethod to reorder columns in table
obsev_col_delMethod to delete column into table
obsev_db_conxnAllow change of connection credentials
obsev_del_colDelete column into table
obsev_disconnexAllow disconnection (useful if too many previous connections...
obsev_extantabledAllow change of connection credentials
obsev_FILENAMESTake filename INPUT and parse
obsev_go_loaddataLoad data into current table
obsev_go_rdsGo saving RDS
obsev_go_saveSave table to db
obsev_ins_colMethod to add column into table
obsev_ord_colMethod to initiate reorder columns in table
obsev_rename_colReordering columns in table
obsev_ren_colMethod to rename columns in table
obsev_save_rdsSave table to RDS
obsev_save_tabSave table
obsev_show_tabShow table
obsev_uni_colUniquify columns in table
obsev_uniq_colColumn data uniquified and output
obsev_userpassTest connection credentials and connect, specify if table is...
obsev_valsdata_newParse Dates and other Data from VALS_DATA$New and binds to...
otherSummaryAllow choice to return 'other' as a value from summary tables
refHospitalParse referring hospital into correct format ensures that...
render_simple_maintableDT:renderDataTable filtering The resulting output should be...
render_unique_maintableDT:renderDataTable
sheet_grep_stringstring to grep XLSX sheets
siteCodeParse site code ensures that data is formatted correctly
siteSourceParse site source into correct format ensures that data is...
tatNAMake TAT
tb_col_delim_splitTake a tibble column and split on delimiter returning index x...
test_codingMake Test_Code from sheet NAME and other Test_Codes
year_shootoutMake Year based on one of the 4 dates included
brucemoran/shinySetupPostgreSQL documentation built on March 18, 2022, 4:34 p.m.