topic Re: How to programatically get BOM for Creo assembly from Windchill with correct quantity in Windchill Customization

How to programatically get BOM for Creo assembly from Windchill with correct quantity

TomazJeras — Fri, 15 Mar 2024 13:30:06 GMT

Hi,

I need to export Creo assembly multilevel BOM from Windchill programmatically. I checked IE task Query-Tree and REST Call PTC.CADDocumentMgmt.GetStructure. Both produce correct multilevel BOM, but the same Creo components in BOM are not merged (per level), so the same Creo components are listed multiple times and all quantities are equal to 1.

On the other hand, running Query-Tree on WTPart does produce correct quantities in multilevel BOM.

In both cases I run an equally structured IE task, the only difference was Type. Do I miss some parameter in IE task to produce quantity for EPM Document or is not possible at all?

Any idea is very welcome.

Thanks.

Re: How to programatically get BOM for Creo assembly from Windchill with correct quantity

avillanueva — Thu, 29 Sep 2022 13:25:32 GMT

I cannot speak for REST api but in UI there the default it to separate uses. There is a action to Merge Uses. There might be something similar in API.

Re: How to programatically get BOM for Creo assembly from Windchill with correct quantity

TomazJeras — Thu, 29 Sep 2022 13:37:28 GMT

I know you can do that in UI, but have no clue, how UI function works. It could also be some JS code, doing it locally in browser.

Re: How to programatically get BOM for Creo assembly from Windchill with correct quantity

rleir — Thu, 29 Sep 2022 17:04:24 GMT

Does your QueryBuilder report show the Uses data correctly? I ask because it is possible to run a QB report programmatically.

Re: How to programatically get BOM for Creo assembly from Windchill with correct quantity

TomazJeras — Fri, 30 Sep 2022 11:52:25 GMT

Report is an interesting idea. I tried to build a report template for it, but I was unable to add EPMMemberLink type to Tables and Joins tab.

So, I was stuck at the beginning.

Re: How to programatically get BOM for Creo assembly from Windchill with correct quantity

Marco_Tosin — Fri, 30 Sep 2022 12:06:40 GMT

Take a look at this article

https://www.ptc.com/en/support/article/CS131357

Are you aware also of these documents?

https://community.ptc.com/t5/Windchill-Tips/Resource-for-reporting/ta-p/817824

https://www.ptc.com/en/support/article/CS328887

Re: How to programatically get BOM for Creo assembly from Windchill with correct quantity

TomazJeras — Fri, 30 Sep 2022 13:07:07 GMT

Thanks for answer. I'm aware of these documents, I checked them before writing the reply here. I didn't find a similar solution there.

BTW, links to "portal.ptcuser.org" are no longer valid.

I managed to add EPMMemberLink to report template (EPMMemberLink is internal name, and it is not shown by default, display name is EPM Documents Uses Link), but I'm not proficient enough in Reports to generate multilevel BOM table. And it is a strong chance that Merge Uses will not be possible at all.

Re: How to programatically get BOM for Creo assembly from Windchill with correct quantity

HelesicPetr — Mon, 03 Oct 2022 06:36:46 GMT

Hi @TomazJeras

I would like to just note that the QueryBuilder can not generates multilevel reports.

If you need multilevel report, you need to write some custom code to run report for multilevel.

In a Help Center is a description how to crate custom report in Product Structure Browser .<Check This>

The HelpC describes how to add custom report for WTPart and it is also applicable for EPMDocuments

Hope this can help.

PetrH

Re: How to programatically get BOM for Creo assembly from Windchill with correct quantity

TomazJeras — Thu, 06 Oct 2022 11:19:57 GMT

Thanks for suggestion.

However, pursuing a custom Report path seems overly complicated.

I will probably develop custom code to merge uses per assembly level from Query-Tree XML.

Re: How to programatically get BOM for Creo assembly from Windchill with correct quantity

HelesicPetr — Thu, 06 Oct 2022 11:22:19 GMT

Hi @TomazJeras

This is also a way.

PetrH