There are a handful of items from the Annual Review process that get outputted for the Annual Report.
Some preliminary notes:
Make a copy of PharmSchool after the Annual Review process is all done. Rename this copy to be AnnualReport_the years. This copy can then be edited and info deleted without interfering with the actual data.
Two sets of output happen- a set of Grad Student data that goes to Maggie Folan, and the Annual Report data that goes t Sherri Peterson and Karen Wagner. The materials for Maggie are all exported as XLSX files. To do these go to these layout, search for Grad student, and then export as xlsx.
The rest of the info is about faculty data and gets sent to Karen and Sherri.
Publications
Find any publications which are book chapters or books edited. Export those as a FMP file for access later if needed. Then delete from the database.
Delete any that are listed as Graduate Student. Annual Report data is faculty only.
Find any publications that were “submitted” a well as any marked as “no” for peer reviewed. Delete these. You only need the accepted and published. for.
Find any where the PMID starts with a “9”. This is a fake PMID. Take the title, and go and look it up on PubMed. if you find a match, copy the PMID, then use the Annual Review “form” for that faculty member to add the publication manually with PMID. This will add it to their list. Then delete the one with the “9” Do this for all ones with a fake PMID. You may not find all of them.
Review the script “Bold No Adjuncts” open the list of faculty and compare it to a list of all faculty. Anyone who has joined the school in the previous 12 months may need to be added, and anyone who left can be removed if they were gone more than the year. Manually add names if needed.
Then with the publications table open, run the script to bold the names. Then sort by authors ascending, export as a Filemaker DB, exporting all fields in the Publications table. This puts them in alpha order.
Now delete all of the publications in the main publications table. Then import the ones you just exported. This will bring them back in alpha order and make the list be in the correct order.
Then do to the layout ” “. This will provide the full list in alpha order. Select all and copy it, then open a Word file and paste it into Word. Send this to Karen and Sherri.