Erick's Blog
  • Home
  • Blog
  • Apps
    • Mortgage Calculator
  • PowerShell
    • Blog & Examples
    • Excel Reference
  • Windchill
    • Document Exporter
    • Document Worker
    • E.P.L.E.S.
    • Export Released
    • Property Checker
    • Windchill Business Analytics >
      • Part 01 - Program Logic
      • Part 02 - Getting Data with SQL Queries
      • Part 03 - Automating SQL Queries
      • Part 04 - Converting SQL Results to XML
      • Part 05 - Data Processing and Manipulation
      • Part 06 - Displaying XML in HTML
      • Part 07 - Auto Updating Displayed Data
      • Part 08 - Hosting Webpage with an Existing Apache Installation
      • Part 09 - Running Multiple Queries In Sequence
      • Part 10 - Calculating Data Trends
      • Part 11 - Making It Modular
    • Windchill Quick View
  • Reviews
  • Music
  • Contact

Windchill Business Analytics


Picture

Project Summary

The main goal of this project is to provide a simplified interface that displays useful business metrics from a Windchill server.  It utilizes HTML5's AJAX technology to update graphs and tables automatically without the need for a complete page refresh.  A program runs on the server to generate XML data from the database which JavaScript reads into the webpage.

As with everything else you see on my site, I am doing this completely on my own time because I've always had a passion to design and create.  Please enjoy!

Programming Journal

Main Loop

Part 01: Program Logic
Part 02: Getting Data with SQL Queries
Part 03: Automating SQL Queries
Part 04: Converting SQL REsults to XML
Part 05: Data Processing and Manipulation
Part 06: Displaying XML in HTML
Part 07: Auto Updating Displayed Data
Updates:
  • September 18, 2016 - Part11 Creation
  • September 2, 2016 - Part10 Creation
  • August 31, 2016 - Part 09 Creation
  • August 22, 2016 - Part 08 Creation
  • August 21, 2016 - Part 07 Creation
  • August 19, 2016 - Part 03 Additions
  • August 17, 2016 - Part 06 Creation
  • ​August 14, 2016 - Reformatting
  • August 12, 2016 - Initial Creation
Part 08: Hosting webpage with an existing apache Installation

Additional

Part09: Running Multiple Queries in Sequence
Part10: Calculating Data Trends
Part11: Making It Modular

Project in progress.  Keep checking this page for updates.
Copyright © 2018 Erick Johnson
  • Home
  • Blog
  • Apps
    • Mortgage Calculator
  • PowerShell
    • Blog & Examples
    • Excel Reference
  • Windchill
    • Document Exporter
    • Document Worker
    • E.P.L.E.S.
    • Export Released
    • Property Checker
    • Windchill Business Analytics >
      • Part 01 - Program Logic
      • Part 02 - Getting Data with SQL Queries
      • Part 03 - Automating SQL Queries
      • Part 04 - Converting SQL Results to XML
      • Part 05 - Data Processing and Manipulation
      • Part 06 - Displaying XML in HTML
      • Part 07 - Auto Updating Displayed Data
      • Part 08 - Hosting Webpage with an Existing Apache Installation
      • Part 09 - Running Multiple Queries In Sequence
      • Part 10 - Calculating Data Trends
      • Part 11 - Making It Modular
    • Windchill Quick View
  • Reviews
  • Music
  • Contact