Considerations for Importing Redline Product Structures or BOMs
When you import product structures for an open redline from Microsoft Excel to Windchill PDMLink, consider the following:
For a REDLINEBOM sheet type, structure changes are permitted only for parts with an open redline.
Parts at Level 0 must have an open redline.
Additions or deletions at Level 1 in a structure must reference existing parts both with and without open redlines.
Add, Replace, or Delete actions at subsequent levels in a structure are only valid under the levels without an open redline.
The changes to the REDLINEBOM sheet type apply only to the redline structures and not to the main branch structure.
It is not necessary to import the entire redline product structure. Each row in the redline product structure is considered a discrete action. For example, if you want to add one part to an existing redline product structure, simply specify the parent assembly and the row with the existing part to be added.
When a component part exists at multiple levels of a redline structure, import from redline spreadsheet must reuse the same child parts for that component part at all levels of the structure. If, in the spreadsheet, the component part does not have the same child parts at all levels, the first occurrence defines the child parts at all levels.
Import from Redline Spreadsheet does not load a sub-component if the parent component is loaded more than one time.
Imported redline structures must reference parts that already exist in Windchill PDMLink. If a part referenced in the spreadsheet does not exist, import fails.
If you import a modified redline product structure, existing product structure links that are not included in the import spreadsheet do not change.
When importing a redline product structure, the quantity, usage unit of measure, and reference designator values must be coordinated for a valid usage. An error may be presented for new or existing usages when invalid combinations are defined.
If you need to modify a quantity within the redline product structure, use the Add action and specify the new quantity. The Delete action removes the part and all its quantities from the product structure, but does not delete the part from Windchill.
When replacing a child part with its substitute, the original child part becomes a substitute for the replacing part. When the preference Part Management > Enable quantity and reference designators for substitute parts is enabled, the attributes from the substitute definition will be used to modify the blank usage attributes in the spreadsheet for quantity and reference designator. Non-blank attributes are considered modifications after the Replace action.
The Replace action results in a change of the child part. The worksheet row with the Replace action represents the attributes and, if applicable, structure of the replacing part.
When importing a redline product structure, you can add reference designators in the spreadsheet under the Reference Designators column. An error occurs if the number of values in the Reference Designators column exceeds the value mentioned in the Quantity column, when the unit of measure is Each.
When importing a modified redline product structure, existing unnamed occurrences are not affected by the import process when the total number of occurrences does not exceed quantity.
An error occurs if you remove a child part with a particular line number and add another child part with same line number. To avoid this error, remove all child parts using one importable spreadsheet and then add the child parts with the desired line number using another importable spreadsheet.
When reusing a line number or reference designator between child parts of the same parent, it is necessary to first either remove the child parts with the original values or clear the values from the existing child parts before:
Modifying the desired line number or reference designator.
Adding the different child parts using an importable spreadsheet.
If you have revised an open redline part within the redline structure to a revision that has no open redline, its correct redline version is added to the structure on import even if the Revision column contains a blank value or any of its existing revisions in the imported spreadsheet.
For more information on the redline BOM spreadsheet format, see File Format for Importing Redline Product Structures or BOMs.
Was this helpful?