timetable.data.update: Query and update current timetable data for a term

In UW-L-S-Academic-Information-Management/UWdataUTIL: UW R Admit Data Utils

Query and update current timetable data for a term

Description

Returns a data frame and saves to a file of current timetable data for UW-Madison from UW.STDNT_TIMETABLE_MULTITERM.

Usage

  timetable.data.update(TERMS, INFOACCESScon, FILE)

Arguments

TERM	Char SIS term
INFOACCESScon	DBI connection to UW-Madison InfoAccess
FILE	csv file path with an existing data to be updated. Defaults to timetable.csv in the current working directory. If no file exists it creates one.

Details

This function queries the timetable information for a specified term for UW-Madison. It will update an existing data file with past timetable information to create a time-stamped enrollment file. It also returns the data frame that is output to the csv file.

Examples

  INFOACCESScon <- DBI::dbConnect(odbc::odbc(), "INFOACCESS", uid="usr", pwd="password")
  timetable.data.update("1232", INFOACCESScon)
  timetable.data.update("1232", INFOACCESScon, "C:\R_Projects\Enrollment_Tracking\Timetable1232.csv")
  timetable <- timetable.data.update("1232", INFOACCESScon, "C:\R_Projects\Enrollment_Tracking\Timetable1232.csv")

UW-L-S-Academic-Information-Management/UWdataUTIL documentation built on April 25, 2022, 1:11 a.m.