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 Exporter


Overview:
The Windchill Document Exporter is an external program that can export all versions of all documents from Windchill PDMLink, ProjectLink, and Pro/INTRALINK.

How it works:
The user is first asked to provide 3 basic pieces of information.
  1. The current location of the master vault root folder
  2. The location where the exported files will go
  3. The database connection string (user/password/service name)
The program then reads the database for documents and copies the files from the vault to the export location before renaming the copied files with the version appended to the file name.  i.e.  SOP_A.3.docx

Requirements:
The following requirements must be met in order for the program to work:
  1. Must have Windchill 11 or 10.2.
  2. Must be using Oracle 12.
  3. Program has only been tested on Windows systems.
​
How to use:
  1. ​Extract the zip file on the database server
  2. Run the wind_doc_export.exe file.
  3. Follow the prompts (Network paths are supported i.e. \\WindchillServer\e$\ptc\Windchill\Filevault)

Limitations:
I have placed limitations on the program which include:
  1. Exporting of only the first 100 documents.
  2. No folder structure export.
  3. There is no network authorization function so if the database is on a second server, the filevault must be accessible through normal network paths without requiring a login.

Error Resolution:
There is only 1 form of error resolution built in and that is to rename duplicate files by appending the Windchill Number to the filename.  This is needed because Windchill does not have a requirement that filenames must be unique.

windchill_document_exporter.zip
File Size: 6385 kb
File Type: zip
Download File

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