University Experts http experts sjsu edu Higher Ed

University Experts http: //experts. sjsu. edu Higher. Ed. Web. Dev 2006 October 22 -25, 2006 Rochester, New York Track: TPR 9 Harish V. Chakravarthy Interim Lead & Web Applications Developer Web Services Unit harishvc@sjsu. edu

Session Layout v Background v About us v IT infrastructure v Relaunch of Univ. Experts v Lessons learned v Objectives v Solutions v Architecture v Roll out v Usage status v Future road map v Q&A

Before we get started: v First time at High. Ed. Web. Dev Conference v First time to Rochester I am thrilled to be here! v Feel free to ask me any questions during the presentation v Feel free to let me know, if you can’t understand what I am talking about v Slides will be available online!

Background: About us

Background: About us http: //www. sjsu. edu/webservices v Formed in Fall 2002 v Web site redesign project v ORG chart v Office of the President v Office of the Provost v Academic Technology v Web Services Unit v Services we provide v Maintain University main Web site (www. sjsu. edu) v Maintain content for top level pages v Maintain the Content Management System v Create subsites for Site Masters v Maintain and configure search engine v Develop & Maintain web applications for University needs v News, Events, Form Handler, Syndication Feed, web survey and more… v Web space v and more … We are responsible for the overall web presence of San Jose State University

Background: About us v Staff v University Web Master v v Web Applications Developer (me) Content Editor/Programmer v Position open since Mar/2006 http: //www. sjsu. edu/webservices v New position v Staff hired in May/2006 v Web Infrastructure v Servers v Set up v 4 Sun Solaris, 1 Windows v Production v Stage v Development v Web Servers v Database v Apache, Tomcat v My. SQL v Languages v Version Control v JSP, Perl, XML, XSLT v CVS We are work with numerous open source applications

Background: About us v We serve v v http: //www. sjsu. edu/webservices Academic Units and Departments Faculty Staff Students v Current v Prospective v Alumni We serve the entire campus v Units we work very closely with v University Computing & Telecommunications (UCATS) v Servers in a cold room v Ensure 24 X 7 uptime (power supply) v Monitor network v CMS Team (my. sjsu. edu) v University Communications & Marketing v Query tables for information v Approve content for top level pages v University Logo and Seal usage guidelines v Web Oversight Committee (Formed in Spring 2006) v v v 16 member team University wide representation University Web Policy (Ist project) v Currently debated in the Academic Senate

Background: IT Infrastructure (related to this session)

Background: IT Infrastructure v Campus IT Infrastructure v Decentralized v Numerous authoritative sources of information We have more than one login and password to access various services offered.

Background: IT Infrastructure Faculty & Staff Directory http: //www. sjsu. edu/directory/ v. Authoritative Source v Phone number v Email address v FAX number v Location v. Building v. Floor v. Extended Zip v Department

Background: IT Infrastructure Faculty Affairs http: //fa. sjsu. edu/ v Authoritative Source for faculty v Education: Terminal Degree v Licenses & Certificates v Job Classification

Background: IT Infrastructure Bursar’s Office http: //www. sjsu. edu/bursar/ Authoritative Source v Tower ID Photo

Background: IT Infrastructure Human Resources http: //www. sjsu. edu/hr/ v Authoritative Source v Name v. First v. Preferred first name v. Middle v. Last v. Prefix v. Suffix v Working Title v Employed faculty & staff v Not Phone Directory!

Background: University Experts (Version 1. 0)

Background: University Experts v v v Maintained by Univ. Marketing and Communications Information was manually updated by staff Static pages with no search and proper navigation Primary key was not Tower ID Sometime information was out of date v There was no easy way to know! There was a need for a better system!

Background: University Experts v One earlier attempt v v v Developed some time before 2003 A standalone web application One more login and password Not user friendly to input or view Not a committee approach Unsuccessful in achieving its objective

Relaunch of University Experts (Version 2. 0)

Project Objectives: Lessons Learned v Put a committee together v Automate as much as possible v Pull data from authoritative sources v Empower experts v To update their “own” information v Ability to opt-in and opt-out

Initiative Project Team Launched: v Rhea Williamson, Associate Dean, Graduate Studies and Research Mary Jo Gorney-Moreno, AVP, Academic Technology Fall 2004 v v Jeff Gordon, Director, Business Development, SJSU Foundation v v v Joan Merdinger and Angee Mc. Ghee, Faculty Affairs Nancy Stake, Media Relations Officer, University Advancement Paul Nozicka, University Webmaster Harish Chakravarthy, Web App. Developer, Web Services Rigo Vargas, Enrollment/Academic Services-IT Danielle Moon, MLK, Jr. Library Special Projects Sara Willis, Sponsored Programs Office, SJSU Foundation Beth Lemke, Content Editor, Univ. Marketing & Communications Bethany Shifflet, Faculty, Kinesiology Andrew Wood & Christina Sabee, Faculty, Communications Studies Carrie Medders, CMS Project Support 16 member team!

Project Objectives v v v Increase Awareness of SJSU Experts Foster Collaborative Opportunities Leverage Investments/Resources Capture information in a standard format Identify top categories v External Speaker v Contact for news media v Collaborative researcher v v v Provide accurate information Retain the SJSU look and feel Keyword searchable Easy to navigate Standards compliant “One stop shop” to find experts

Possible v Write a new web app. from scratch Solutions: Pros: Plan A v Develop inhouse v We already have the infrastructure v Save time v Less coordination with rest of campus Cons: v One more login and password! v One more standalone application!

Possible v Solutions: Plan B Use My. SJSU, People. Soft Portal (my. sjsu. edu) Pros: v Currently in use v University has vested interest v In built modules available to capture similar information v No need for additional login and password Cons: v In built modules will require customization v May require approval from Chancellor’s Office v Will require coordination with the CMS team & other teams on campus v Long process

Possible Solutions: Plan A or Plan B We decided on Plan B! (A road less traveled)

Using v My. SJSU: Customize modules Identify modules to capture information v v v Education-Degrees Courses-Teaching Experience Research-Scholarly Activity Professional-Service Activity Licenses-Certificates Publications-Presentations v Customize v Text changes v Remove fields v Add fields v Easy to Copy & Paste v Accept Home page URL v Accept to existing URL’s v Courses v Publication

Using My. SJSU: New module v Faculty Info v Display Tower Image v Yes v No (Default) v Select 3 categories v External Speaker v News Media Contact v Collaborative Researcher v Expertise Summary v Keyword field for search v Experts should select any one of the 3 categories to be found inside university experts v Provide a way to out-out if desired We went through 13 iterations! (Fall 2004 - Summer 2005)

Using My. SJSU: Architecture v v v Identify Authoritative Sources Query for a list active experts Pull information for active experts from various authoritative sources v Various databases across campus Map information gathered using Tower ID as the primary key v Map Tower ID to unique random key (public display) v Generate SQL inserts v Update local database v DBTrainman (a command line driven program written in JAVA)

Putting all this together & making it work …

Active Experts vis CMS Education (Terminal Degree from Faculty Affairs) CMS DB my. sjsu. edu Towercard Photo from Bursar’s Office Faculty Initiated pages • Courses • Research • Publications Graduate Studies & Research/Foundation Office of Public Affairs Funding alerts and Keywords database News Media Contact database … DBTrainman (The BRAIN) Experts DB UCATS DB www. sjsu. edu/directory http: //experts. sjsu. edu

Univ. Experts: Roll out v Step I (early Fall 2005) v Identify beta testers v Request feedback & make required changes v Step II (Beta Launch, November 2005) v v v Communicate via campus mail and email Request experts to check accuracy of information Raise awareness Request experts to fill out their information Step III (Full Service Public Launch, January 2006) v SJSU Press Release v Point all references to Univ. Experts

http: //experts. sjsu. edu

Univ. Experts: Project Update # Experts v v Contact for News Media Collaborative Researcher External Speaker Tower Images Feb/01/2006 329 38 47 19 Oct/20/2006 362 76 91 45 change 10% 100% 94% 137% # Records v v v v Active Experts Education Licenses & Certificates Research & Scholarly Activities Courses & Teaching Expertise Professional & Service Activity Publications & Presentations 2016 2120 19 363 196 258 264 1743 2366 21 386 375 305 334 -14% 12% 1. 6% 6. 3% 91. 32% 18. 21% 26. 5%

Univ. Experts: Future Roadmap v Increase awareness v v v Offer hands-on lab session Memo from Office of the Provost Meet with Department Chairs and College Deans Visibility on website and other forms of communication Students newspaper Technical Improvements v UI Improvements v Import publication from University Library v Integrate data with other web applications

http: //experts. sjsu. edu/ Beta Site Demo www. sjsu. edu/cats/2003/showcase/

Additional Slides

DBTrainman: Code: Output Generating a Vector of active IDs. . . Generated a Vector of existing Mapping ID Checking for complete ID Mapping. . . Insert into sjsu_id_map values (531281767, "55 AESWE 34"); Generating ID Map. . . Generating Dept. ID Map. . . Generating sjsu_experts_contact header. . . Generating sjsu_experts_contact sql. . . rows processed: 1748 Generating sjsu_experts_info header. . . Generating sjsu_experts_info sql. . . rows processed: 479 (392) CR/ES/NM: 76 91 362 Generating sjsu_experts_education header. . . Generating sjsu_experts_education sql. . . rows processed: 6568 (2366) … Generating Images. . . rows processed: 45 Generating sjsu_experts_contact_from_ucats header. . . Generating sjsu_experts_contact_from ucats sql. . . rows processed: 6160 (1770) … Statistics for today. . . Oct/23/2006 1748 392 2366 21 386 375 305 334 45 76 91 362

DBTrainman: Code: Images

DBTrainman: Code: Query Phonebook

Service Oriented Architecture