psu-libraries / etda_workflow

Electronic Theses and Dissertations Application: Admin, Author, and Committee Member workflows.
MIT License
3 stars 1 forks source link

Consolidate program names during solr import #769

Closed ajkiessl closed 1 week ago

ajkiessl commented 1 month ago

Since we started importing program names from LionPATH, we now will have three different programs names for some programs. The three exist because LionPATH differentiates between MS and PHD programs by appending a (MS) or (PHD) to the end of the program name and we still store the old program name which has neither.

For example, if the old program name was "Mechanical Engineering", there are now these three program names in the DB:

This causes problems on the explore side when users are searching. If they filter down the program to just "Mechanical Engineering", they won't be able to see the "Mechanical Engineering (MS)" and "Mechanical Engineering (PHD)" submissions.

We can fix this by stripping the " (MS)" and " (PHD)" off the program names during the solr import. These don't need to be there in explore since users can filter on degree type (MS or PHD).

ajkiessl commented 1 month ago

Original service now issue: https://pennstate.service-now.com/now/nav/ui/classic/params/target/incident.do%3Fsys_id%3D21a0de7f93420694279bb1f97bba1003%26sysparm_stack%3Dincident_list.do%3Fsysparm_query%3Dactive%3Dtrue