Hi,
Is there a way to import a spreadsheet file to assign and/or update assigned expressions on usage links of parts for certain configurable modules/end items?
I know you can export/import part structures in general, which has been quoted here for example. And I think I've read somewhere in the Windchill Help that this can include assigned expressions. However, I think that the basic way can only carry the expressions on items, not usage links. That is, if any at all.
Use case - it's much easier and quicker to analyse and tweak configuration logic in spreadsheets, plus people who do this don't use Windchill at all. In case of thousands of items, which also happen to have different rules based on type of a product they're used in, updating logic for each is unbearable.
I've automated spreadsheet rule generation process but then whenever changes happen I'd have to know which items were affected (easy to do) and go through the list of thousands of items dozens of times (various products) and edit each expression (extremely time consuming and error-prone).
edit: There's a way to export the structure with usage expressions (Export List to XLS Report). But then, is it possible for example to combine it with importable spreadsheet and based off of that update configurable modules?
edit2:
Here is an old post pretty much asking the same question, sadly not answered. @ahogendoorn Did you find a solution, perhaps? 🙂
