How to identify parts and assemblies with the same name in Windchill
I am going to create WTParts for all EPM Documents in Windchill, what I'd like to know is how can I find out what parts and assemblies have the same name?
E.g root.prt and root.asm
Once I create the WTParts they will have the file extension for the number (root.prt) which is fine however I will be removing all extensions but the tool will run in to problems if a part and assembly have the same name.
Does anyone know how to produce a query/search in order to identify duplicate name parts and assemblies? Has anyone had to do this before so that they could integrate WTParts with their ERP/MRP?
Re: How to identify parts and assemblies with the same name in Windchill
Deepen: The following sql will list all epmdocument .asm's and .prt's that have the same base number. This is using the "cadname" field (to find the number) however could be easily changed to use the documentnumber field.