Senior Design Projects

ECS193 A/B Winter & Spring 2020

Global Connections Database

Email kbeardsley@ucdavis.edu
Name Dr. Karen Beardsley
Affiliation Global Professional Programs, Global Affairs

Project's details

Project title Global Connections Database
Background Our new UC Davis Global Connections Database (https://ucdavis.moveonca.com/publisher/1/eng) brings together institutional partnerships and faculty global connections, and will soon incorporate visiting delegation information and other global connections information. This database is an important tool in showcasing the breadth of global linkages and partnerships and the expertise of the UC Davis community, while also enabling searches for future collaborations. Moving forward, Global Affairs wishes to incorporate data from other campus units, such as the Office of Research, using an API. The software platform is a third-party solution called MoveON, by the company QS Unisolution.
Description This proposed project will involve developing programs and a web interface for securely querying the QS Unisolution MoveON API using PHP to extract data and preprocess it for input into other system. The program must securely establish credentials, securely request or send data to the API, and preprocess the response for input into other systems. The program must include methods that limit and filter data to prevent querying sensitive data. Tasks will include evaluating the API provided by QS Unisolution for security.
Deliverable Full web interface allowing secure authentication, transmission of credentials, and secure queries of the API returning JSON data. The interface must be developed to filter and prevent transmission of sensitive data and must meet the IS-3 guidelines. The interface will include methods for preprocessing and transforming the returned data. It will need to be well-documented, including how to extend the code, and all code must be provided to Global Affairs.
Skill set desirable · Secure programming practices and familiarity with the University of California, Office of the President’s (UCOP’s) IS-3 policy.

· Experienced in PHP programming.

· Working knowledge with querying, transforming, and manipulating JSON and XML data from an API.

· Knowledge of HTML, CSS, and JavaScript.
Phone number N/A
Client time availability 30-60 min weekly or more
IP requirement Client wishes to keep IP of the project
Attachment Click here