How to set up the Scholarship Application each year
Note Spring 2019: The plan is to move to a University managed system (was to be 2019 but more likely 2020) If we use our system again, a process needs to be sorted out for the incoming class data and keeping it up to date in the RxStudent table and the way that impacts the “import” steps below. Idea: Use the emplid upon first import, and then use emplid on subsequent imports, but after the first use “update matching records/add new. This won’t delete any students who have decided not to attend- that will still have to be done nmanually
Delete all applicants
On the Utilities :All layout, export the worksheet to desktop
Add new Utilities record
On layout Applicant: Home, confirm or revise the open and deadline dates
Import a file FROM RxStudent where class year = the 3 years plus the incoming P1 class
Needed in the import file”
- id (id_rxstudent)
- username
- nameF
- nameL
- nameMid
- ClassYear
Update webtech password in the onOpen script
Make screen grab of page6 to update the worksheet.
Update worksheet and store it in the DB- on the Utilities record
Ask TJ to delete members of the AD group, XXXX and import the current committee members.
Enable the student CDS group and the committee group