Trigger: Each July 1, request from the Alumni Coordinator a .csv file from the Advance DB. Request a list of all Pharmacy grads for the most recent graduation year.
You need the following fields of data in the .csv file:
- ADV. ID The is the ID for the record in Advance
- FIRST_NAME
- LAST_NAME
- MIDDLE_NAME
- Degree
- PREF_CLASS_YEAR
This file can be uploaded directly into the Alumni DB in the table Alumni_All
Then run the Filemaker script “Set Display Name” on the imported records.