cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Removing children from parent in a Product Structure through "Import from Spreadsheet" functionality.

Regular Member

Removing children from parent in a Product Structure through "Import from Spreadsheet" functionality.

All,

Am not getting successful in removing the link between parent and child parts in a Product Structure / BOM through "Import from Spreadsheet" functionality (Product - Details - Action - Import from Spreadsheet). The validation of the excel file is getting succeeded, but on hitting Finish, the structure of the assembly is unchanged. "Delete" is the option that is used in the column Action.

For adding children under a parent assembly, the functionality works all OK (Action is "Add").

We are on 9.1 M060.

A related case 10574758 and PTC article CS38362 details that the functionality of creating a new View version of a part through "Import from Spreadsheet" has got a bug with 9.1 M060 and had been fixed at 9.1 M070. Is there similar issue for importing Product Structure / BOM (especially for Delete/Remove link operation) at 9.1 M060?

Has anybody ever got succeeded in importing / altering Product structure through this functionality?

Thanks in Advance for your help,
Prabhakaran V.

2 REPLIES 2

Re: Removing children from parent in a Product Structure through "Import from Spreadsheet" functionality.

Yes. However, the answers are only from using version 9.0. I am willing to share some information/troubleshooting information that might help you:

1. Are you importing the data in the correct location? If your product structure lives in the Library and you are importing from the Library/Details, then you are in the correct location to update your product structure. The converse is true... if your product structure lives in the Product, then you must import from Product/Details.

2. Are you selecting the correct import action? Select Add and Update to apply delete actions in the import spreadsheet

3. Are you viewing the latest revision of the data? When viewing your results... you must update the product structure view to latest. Either look at the History/Iteration to view the revision you just created with the import or go through the functionality to "view latest." (my team has clocked many annoying minutes working to view the latest iteration of the product structure). Another tip would be to navigate to the Home Overview / Recent Updates table view and select your latest revision.

Re: Removing children from parent in a Product Structure through "Import from Spreadsheet" functionality.

Thanks for the response Jennifer.

Wierd is that when we do the Validate report in the import wizard, we do not get any exception right away. The exception thrown at this stage of validation does not address all the cases of discrepancy of the data in the excel spreadsheet against the data in windchill system. Certain parameters like Life Cycle State, View, etc., are validated for the given Part type, but discrepany in data like improper Product Structure in the spreadsheet is not addressed at this stage. Validate report action would simply not throw any exception and would look like as if the import has passed through.

Though validating report passes successfully, as I said, no changes had happened to the Product Structure (I did investigate all iterations and the operation had indeed failed). There was a valid exception regarding the parts in windchill system, but this is thrown only in the log file in the server. Had to do some data correction in the system and in the spreadsheet to get the import successful for the case of "Delete".

Thanks again anyway for your response and inputs.