Importable Spreadsheet Export limitation

[Søren_Johannsen]

Version: Windchill 12.1

Use Case: An local insourcing strategy has required that part previously purchased externally (Linetype=Item), is now converted to internal manufacturing (Linetype=Production). The change on top level part is easy via importable spreadsheet "Part", and then change the Linetype, and Import "Update Only", But on the corresponding BOM´s the Linetype (Item) is also needed to be changed (Added upon migration)

Description:

Is it somehow possible to limit the extract on "Export Importable Spreadsheet" on "BOM" to only extract level 0 and level 1. I get all level extracted, but only want to do changes to level 1?
Or is there an excel rule to delete all other levels on multiple spreadsheets?

We also have experienced that a total BOM "Delete" is needed first, and then an Import without Linetype set on BOM Sheet, in order to get the Linetype removed from the BOM.

But it is a massive workload to delete all level 2-7 parts, on all BOMSheets, before the Import.

[avillanueva · Accepted solution]

I did a search and came up with nothing. Someone asked about changing columns and it was not part of functionality: https://www.ptc.com/en/support/article/CS316010?source=search

You might want to try writing an excel VBA macro to cleanup the export data for you. 

[vnamboodheri]

Hello @Søren_Johannsen,

It looks like you have a response from our community champion. If it helped in answering your question please mark the reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.