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 11.0 Workflows - Part 2: Writing Your First Workflow Code

7/23/2017

4 Comments

 
Picture
The drag and drop interface is really useful for visualizing your workflows but you can't do everything without writing some code.  In Part 2, we are tasked with modifying the OOTB Promotion Request Approval Process workflow to require approvals based on the file types attached to the Promotion Request.

Read More
4 Comments

Windchill 11.0 Workflows - Part 1: Using the Drag and Drop Workflow Editor

7/19/2017

10 Comments

 
Picture
Windchill Admins and Customizers,

It is finally your turn to learn how to work with Windchill Workflows!  This series will shed light on the mysterious ways that workflows work and how you can manipulate them to do just about anything you want with the Windchill API and a little Java grease.  I know trying to learn this stuff has always been a big pain to many people but don't worry!  I will make it so easy that you will be impressing your boss in no time!

In Part 1, we will go over the basics of what a workflow is and do some high level manipulation via the Workflow Administration GUI.  You don't need to know how to write code....yet...

Read More
10 Comments

Windchill Quick View - Update 1: Conversion to .NET Core with MVC

2/12/2017

2 Comments

 
Picture
Hi Blog Watchers!

​     I have been working really hard to get up to speed with the new .NET Core.  I managed to convert my old ASP.NET only version of Windchill Quick View to .NET Core with MVC views.  It's nice to be at the front lines of a soon-to-be-released framework.  I had to make some CSS changes to entice me into sticking with it.  Doesn't that color scheme look familiar?

Now that I seem to be getting the hang of this new framework, I will be creating tutorials on how I made parts of this happen based on how I understand it.  Also, in case you have been keeping an eye on all the other Windchill related things and such that I have been doing, this is where they all start to come together.  Exciting things on the horizon!

​Keep checking back for more updates soon.
2 Comments

New Project: Windchill Quick View

1/14/2017

0 Comments

 
Picture
Windchill Quick View is an external viewer meant to gives non Windchill users access to Windchill content. 

This is a new and active project that I am working on so please keep checking the main Windchill Quick View page for updates.
0 Comments

Initial Release: Export Released for Windchill

1/2/2017

0 Comments

 
Export Released for Windchill has been released!

If you don't know what that is, it is a program designed to quickly export released PDF drawings from a Windchill system.  I will be working on adding more features in the near future but please let me know how it works for you (if it does). 

Check it out: Export Released
0 Comments

Programming Journal

8/12/2016

0 Comments

 
Due to the nature of the Windchill Business Analytics program I have been working on, I have decided it is best to have a programming journal showing the code, process, and progress.

My hope is that this will help some of you out there learn from what I have learned and apply it to your own projects in a more efficient way.

The program will include things like SQL, C#, JavaScript, HTML, AJAX, Deffered/Promise, Google Charts, etc.

​Keeping checking HERE for all updates.

I will first work on getting it up to the point where it is now and then keep it up to date as new progress is made.
0 Comments

Windchill Business Analytics

7/9/2016

0 Comments

 
Picture

Hello everyone!  After a long pause in posting, I have decided to tease a new project I am working on called Windchill Business Analytics.

Read More
0 Comments

WindchillDoc2PDF Now Available

6/16/2016

0 Comments

 
My custom Windchill Document Worker is now available on my GitHub.  Feel free to try it out and start enjoying those PDFs!  Download link below.

https://escottj.github.io/WindchillDoc2PDF/
0 Comments

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 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
<<Previous

    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