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 Document Worker

6/5/2016

0 Comments

 
Picture

After a busy couple weeks of writing, testing, and more testing, my Windchill Document Worker is finally ready to be installed on a customer's system!  It is more of a "free beta test" if you will.  I am eager to see the results.

Read More
0 Comments

Windchill Document Exporter

5/14/2016

0 Comments

 
Although I currently do have a way to export all files from Windchill (CAD and Documents), I am limiting the scope and splitting the projects into two because each set of data has its own needs.

The "Windchill Filevault Decrypter" will now be known as "Windchill Document Exporter".

You can take a look at all the details on the new permanent project page here.
0 Comments

Windchill Filevault Decrypter

5/7/2016

0 Comments

 
Overview:
A new project I am currently working on is a way to export all files from the Windchill filevault.  This could be used to recover files from a database and vault backup without having to restore Windchill to an earlier point in time.

Requirements:
  • Starting with Documents
    • All Documents are exported
    • All Documents must have the correct version added to the filename (Revision and Iteration)
    • Documents must be placed in a folder structure mirroring that of Windchill i.e. Organization -> Project/Product -> Subfolder(s)
    • Export the Documents in a way that can be easily imported into another Windchill system with all history.

Status:
A working prototype has been made that can currently export a test system with 5,700 Documents in under 13 min without the subfolder structure.  Adding the subfolder structure significantly adds time to the export.  I am working on a way to reduce this time by optimizing the code.  The import function is currently being investigated.
0 Comments

Classical Song 01

4/11/2016

0 Comments

 
Another song sample for you to enjoy.  Maybe it's not even technically classical but that is the best temporary name I can give it for now.

Be sure to check back for updates.

Last Updated: 4-16-2016
0 Comments

Windchill Property Checker Tool

4/10/2016

0 Comments

 
Picture
From the 100's of installs of Windchill I have performed, one thing that has always bugged me was constantly browsing to many different property files to check the values of specific properties.  I have created my very own tool to make life much easier.  Introducing the Property Checker!

Read More
0 Comments

Game In A Day: SwipeRun

4/7/2016

0 Comments

 
Picture
After spending many months programming what seems to be a large and complicated game that will never be finished, I decided to take a break and challenge myself.  I want to see if I could make an entire game in one day from concept to playable.  I quickly came up with what I call SwipeRun.

Read More
0 Comments

How to Install pfSense on Windows 10 Pro Hyper-V with 2 Physical NICs - Part 2

3/29/2016

10 Comments

 
Picture
Part 2 of my pfSense series focuses on installing pfSense.

Part 1  |  [ Part 2 ]  |  Part 3

Read More
10 Comments

How to Install pfSense on Windows 10 Pro Hyper-V with 2 Physical NICs - Part 1

3/28/2016

4 Comments

 
Picture
​After using PeerBlock for so many years, I wanted to see about providing a PeerBlock type solution to my entire network.  Before investing money in a physical system, I decided to try pfSense in a virtual environment to see if it would fit my needs.  This "How To" guide walks you through the install and configuration steps along with solutions to any challenges I faced.

[ Part 1 ]  |  Part 2  |  Part 3

Read More
4 Comments

2011 Senior Design Project: Autonomous Underwater Robot

3/24/2016

0 Comments

 
Picture
My senior design project was one of the most exciting and satisfying parts of my life.

Read More
0 Comments

Song 12-03

3/23/2016

0 Comments

 
A song I've been working on.
Last modified: 3-24-2016
Keep checking back for updates.
​Enjoy.
0 Comments
<<Previous
Forward>>

    Author

    PLM engineer while "on the clock", programmer, designer, dreamer all other times.

    Archives

    July 2017
    May 2017
    February 2017
    January 2017
    December 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016

    Categories

    All
    ASP.NET
    Batch Script
    C#
    Career
    Computers
    Creo
    Creo API
    Flash
    GameMaker
    GitHub
    Home Loan
    How To
    HTML5
    Java
    JavaScript
    MAME
    Mortgage
    Music
    .NET Core
    Office
    PC Games
    PfSense
    PowerShell
    Reviews
    Robot
    SQL
    Video Games
    Web App
    Windchill
    Windchill API

    RSS Feed

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