Skip to main content
D
17-Peridot
Dobi17-Peridot
17-Peridot
September 29, 2023
Solved

BOM report for CAD drawings on an EndItem eBOM

  • September 29, 2023
  • 2 replies
  • 2360 views

SQL and reporting is not my forte... so looking for some pointers. 

I want to have a report of all CAD drawings that exist at all levels of an EndItem eBOM (so Design view only). 

Something like this:

Dobi_0-1696001379293.png

 

I do have multiple WTPart subtypes and only need 1 type reported on with it's CAD Drawing associations. The idea is to get a snapshot of total quantity of drawings vs. how many are at a particular state (from week to week perhaps). Added complication is that we have Creo and NX and some of the drawings may not be classified as "CAD Drawing" type but instead may show up as "CAD Assembly" with a xxx_DWG in the name. 

 

For input, is it possible to have only the available End Items be selectable via drop down or something like that? 

Best answer by d_graham

@Dobi , this is very doable with a customization.

I wrote a utility recently that did what you are looking for and more. The utility created a Package and added the PDFs created from the published drawings that were linked to the WTParts in the End Item’s structure (recursively) as well as primary content from WTDocs of a specific subtype that were linked to the WTParts in the structure.

 

In short, in the End item WTPart’s action menu I added an action to run the utility to create the package. If the package already existed the utility updated the package to reflect the current structure (maybe something was added or deleted from the structure since the package was originally created) and then present a page to the user of exactly what the package now contains.

 

All the user has to do is select the action. That’s it. Very user friendly and its bombproof.

 

What you are asking for is quite a bit simpler. It would be no problem to create a tool that would generate that data you’re looking for with one click. 

If you need this, you know how to get in touch with me.

 

David

2 replies

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
September 29, 2023

Have you played with the Part Structure page, specifically the left side product structure and showing documents? 

D
17-Peridot
Dobi17-PeridotAuthor
17-Peridot
September 29, 2023

Yes. 

I can display the entire BOM with it's CAD and spit that out as Excel and then do post processing there... 

That's ok, I guess... Either I do post process scripts in excel based on incoming .csv or get Windchill to report the result without subsequent processing of the .csv. 

 

I won't be the one pulling these reports on a weekly or so basis and I'd rather have it be a "push button, get result" set of steps, if that's possible. 

 

Dobi

 

 

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
September 29, 2023

Its very complicated since it involves recursive queries, Config spec criteria and crossing multiple object types. Its near impossible without the UI helping get this for you. I feel your pain. Proper indented structures are our bane as well.

    D
    18-Opal
    d_graham18-OpalAnswer
    18-Opal
    October 1, 2023

    @Dobi , this is very doable with a customization.

    I wrote a utility recently that did what you are looking for and more. The utility created a Package and added the PDFs created from the published drawings that were linked to the WTParts in the End Item’s structure (recursively) as well as primary content from WTDocs of a specific subtype that were linked to the WTParts in the structure.

     

    In short, in the End item WTPart’s action menu I added an action to run the utility to create the package. If the package already existed the utility updated the package to reflect the current structure (maybe something was added or deleted from the structure since the package was originally created) and then present a page to the user of exactly what the package now contains.

     

    All the user has to do is select the action. That’s it. Very user friendly and its bombproof.

     

    What you are asking for is quite a bit simpler. It would be no problem to create a tool that would generate that data you’re looking for with one click. 

    If you need this, you know how to get in touch with me.

     

    David

      Terms & ConditionsCookie settingsAccessibility statement