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

Export Released for Windchill


Overview:
Below is a small program I created to quickly export all released drawings in Windchill that were already converted to PDFs.

How it Works:
  1. Reads Config.xml for settings specific to your environment.
  2. Attempts to connect to Database.
  3. Queries Database for relevant files.
  4. Copies vault file to configured export folder.
  5. Renames exported vault files with appropriate name appending the revision and iteration to each file.

Features:
  • Validated in Windchill 11.0 M020 (Should work all the way back to 10.0)
  • Exports all drawings converted to PDFs stored as secondary or additional files
  • Removes the required prefix in the filename when using additional files publishing

Limitations:
  • Only working for Oracle Databases currently
  • Only basic user configurations
  • Only works on one vault at a time (i.e. will need to run multiple times if using multi-vault environment)
  • No error handling
  • Only exports PDFs
  • Export location must be created manually before running

Requirements:
  • Access to the Windchill Server
  • Either run directly on the Database server or on the Windchill server with Oracle Client installed
  • Database username, password, and service name
  • Known location of the master filevault's root folder
  • .NET 4.5+ Installed.

How to Use:
  1. Download file below and extract to server.
  2. Open Config.xml file in notepad and modify default settings to match your own environment.
  3. Create export folder in chosen location set in the Config.xml.
  4. Run ExportReleased.exe.
  5. Verify chosen folder for exported drawings contains correct files.

License:
  • Product is free for personal use only.
  • Product may not be sold in any way or used for commercial purposes.
  • User assumes all risk.
  • Always test in a separate environment first.

Tips:
  • Set to run as a Windows Task to have it automaticaly run.


exportreleased.zip
File Size: 14 kb
File Type: zip
Download File

Version History:
  • 0.1 - Initial Release, January 2, 2017
SHA512: 
  • 724E4149682D865445F036B2A6AFD3E16AE06532CCC53B3ED90231B0F9AB4532185469BEDB5CC133717DC51D993E4840E4B2509CF06138B5B7693FC2537B0906
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