cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Export all data into 1 excel sheet

BWS
9-Granite
9-Granite

Export all data into 1 excel sheet

Hello,

 

I have thousands of Windchill parts saved in multiple folders in Windchill. In these folders I am able to see

columns with weight, thickness, material and other information about these parts.

 

I would like to know if there is an easy way to export every single part of all folders and subfolders into 1 excel sheet, with the same columns as I get in the folders.

 

Thanks in advance!

2 REPLIES 2
Marco_Tosin
21-Topaz I
(To:BWS)

You should use a report to extract all metadata.

 

If you don't know how to build a report, take a look at this document https://community.ptc.com/t5/Windchill-Questions/Resource-for-reporting/td-p/448738

 

In it there are lots of report ready to use for your convenience.

 

Marco
BenLoosli
23-Emerald II
(To:BWS)

If you can get a view that spans all folders, then yes, but I don't think that is possible.

Your best option is to export the information per folder into excel sheets, then cut and paste the rows into a single master spreadsheet. I do the something like this with my family table data.

 

Top Tags