How to generate BOM in Excel format through Windchill API's

[mprasad]

Through Windchill code I would Like to retrieve all child Item of a given Part/Assembly and later put it into excel file and save it to a particular location. Please guide me how to do this

[BhushanNehe]

Hi Manish,

One of the ways to generate the BOM is using Info*Engine Query-Tree Webject. You can then parse the output and create the Excel file.

Regards,

Bhushan

[ddemay]

Follow the action(s) for viewing BoM and, export to Excel / CSV / whatever using the action model, follow those classes by debugging, logging verbosity, and can decompile those classes keepingin mind to not duplicate any code as it is seen.  It should direct you to the unsupported but core service classes that fetch the data via a complex query statement and returns the data from database.

Info*Engine easiest way to do this given it's the backbone of the Business Intelligence reports.  No need to use JSP, can invoke Info*Engine from Java class.