Skip to main content
B
BWS10-Marble
10-Marble
May 31, 2018
Question

Export all data into 1 excel sheet

  • May 31, 2018
  • 2 replies
  • 1631 views

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

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
May 31, 2018

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
B
BenLoosli23-Emerald III
23-Emerald III
May 31, 2018

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.

 

Terms & ConditionsAccessibility statement