Bulk loading documents into windchill
Download
1 / 8

Bulk Loading Documents* into Windchill - PowerPoint PPT Presentation


  • 386 Views
  • Uploaded on

Bulk Loading Documents* into Windchill. Note: All for WTDocument Type (includes MS Word, Autocad, pdf, etc.). (Screen captures from Windchill 10.1 M040). This applies for Documents and Parts Lifecycle . Fill in required information in RED as shown below

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Bulk Loading Documents* into Windchill' - meg


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Bulk loading documents into windchill

Bulk Loading Documents* into Windchill

Note: All for WTDocument Type (includes MS Word, Autocad, pdf, etc.)

(Screen captures from Windchill 10.1 M040)


This applies for Documents and Parts Lifecycle

  • Fill in required information in RED as shown below

  • Two files to be Bulk Loaded are shown below (any quantity can be handled)

  • Enter Version at which the document is to be loaded (e.g. P1, P2, A, B, etc.)

  • If Version is “Px” (where x is some number), lifecycle state is RES

  • If Version is A or higher, lifecycle state is ESMOD

Note: Other columns are required but are hidden – see next slide.


Note: If there is only one file, need to put values in XML file only

else If there are more than one file, need to put values in CSV file

Some Names need to have commas.  But – Commas interfere with the CSV to XML conversion.  If any Names have commas, do this:

  • Temporarily replace , in the CSV file with !!!

  • After converting, replace !!! in the xml file with ,

Note: .csv file shown in Excel and in WordPad


Save the .csv file in in as shown.D:\ptc\Windchill_10.1\Windchill\src\loadfiles

Note: Create loadfiles folder under src if it does not exist

Save the file(s) that will be bulk loaded inD:\ptc\Windchill_10.1\Windchill\loadfiles\content

Note: All done in Windchill server


From a windchill shell on the src loadfiles folder run the command shown
From a Windchill shell on the \src\loadfiles folder, run the command shown.

  • cd src\loadfiles

  • windchill wt.load.util.CSV2XML –input TestBulkUpload.csv

  • Result: Output .xml file with converted info from Input .csv file in the same folder

Note: We can change this file name: TestBulkUpload.csv to any file name.


Mapping input csv to output xml
Mapping – Input .csv to Output .xml command shown.

.csv

.xml


Load the .xml file using same Shell, using command shown. command shown. Change <YOUR_LIBRARY> to a specific LibraryLoad file to Library specifiedEnter admin username and password

  • windchill wt.load.LoadFromFile -d D:\ptc\Windchill_10.1\Windchill\src\loadfiles\TestBulkUpload.xml -CONT_PATH \"/wt.inf.container.OrgContainer=Alcon/wt.inf.library.WTLibrary=TestLib1\"


Successful results
Successful Results command shown.


ad