Cascade CMS Server
Corrections
Catalog Data Repository
Undergraduate Course Data Undergraduate Non-Course Data
Plain XHTML Files for Visual Text Content Review & Proofing
Course Data Dump Non-Course Data Dump
University of Richmond Simplified View of Cascade Catalog Processing
epalmer@richmond.edu
Adobe inDesign CS3
Iterative Publish to inDesign
inDesign Import File
Import
Manual Adjustment of Styles, Layout and Proofing Corrections
inDesign Print Format Print
Publishing House to Print
PDF
Catalog XSLT Program Repository (XML XSLT files)
Course Dump NonCourse Dump Render Catalog to XHTML Render Catalog to inDesign Built-In XSLT Processing Engine
Correction of content during proofing cycle and embedded Tag adjustments at 50%, 75%, 80% and 100% Completion
Stored on CD Rom as “Legal Archive
Production Load Balanced Web Server Environment
Undergraduate Catalog
Multiple Publish Jobs
Complete Catalog (same as print) plus a few static pages Oracle/PHP based Basic and Advanced Searching
Publish Catalog and Academic Web Sites
Production Batch Utility Server
RedHat Linux/Apache Production Web Server(s)
English Chemistry
XML file For Oracle Text Load
Includes Embedded inDesign Style tags Built into Cascade. Uses xslt to process xml to desired output format
CourseDataDump.XML
Load Course Data into Oracle Text
Store & index text content
Production Database Server
Oracle Database
Re-Index Oracle Text Tables Store and index text content and link to the URL
Academic Sites have courses and selected Major Minor Concentration content interspered with other content such as notes about guest Faculty, Special Presenters….
Web Site Definitions and Content
Undergraduate Catalog
nonCourseChapterURLS.XML
~60 Academic Sites
English Chemistry
Load one time config file with non-Course Content URLs for indexing
Load nonCourse Data into Oracle Text
Read the non-course content from the page Parse the XHTML
Notes: Non-Course Content sections are text chapters except the couses. They Include: Major Minor Concentration Information Academic Policy Other Content (e.g., “Student Life, About the University
Cascade UG Catalog
UR Undergraduate Catalog Data Loading and online Searching
Dump UG Courses
Course_dump.xml
loadCatalogCourses.php
Load catalog DB with courses For one catalog type (e.g., undergraduate)
Oracle Catalog DB
Delete catalog courses Open course_dump.xml Parse course_dump.xml Insert courses into catalog db Remove duplicates Reindex table (oracle text indexes)
Publish UG Catalog
UG Catalog Online
Read Content From default Location In Online Site
loadCatalogSections.php Load catalog with non-course sections For one catalog type (e.g., undergraduate)
Delete catalog non-courses sections Open URLs for each section Parse HTML Grab Section from Default Region Insert Into Oracle Reindex Table (oracle text indexes) Query catalog for courses and non-course sections Extract course descriptions Extract non-course sections Update search_history table
Search forms (basic and advanced)
Form refresh and output results queryCatalog.php
Need to add Indexes information Test database information
Search Results
Etc