NOTE May 2020- I’m making a transition DB to use for this process each year.
Mark the students to be moved in PharmSchool
Export all [mgt = k OR move] as a FMP DB
Use the People table, the directory table and the Grad student table.
Export the photos!!!
In PharmSchool, find mgt = move, and delete these records
Import into the Alumni table
fields to match:
- nameFirst (Person)
- nameMiddle (Person)
- nameLast (Person)
- Advisor (Graduate Student)
- degree entering (Direcory)
- univID (Person)
- awards (Graduate Student)
- publications (Graduate Student)
- presentations (Graduate Student)
- degreeDisplay **
- photoContainer (Directory
- what about clan pharm sci ????
Need to set grad year to current year
Need to set degree display to the degree they are graduating with (Same as Grad Program??)
Need to look up by name and get the dissertation/Thesis links and titles to add these.