Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
I am trying to update Part attributes of BOM, using Excel upload function.
1) By the way, what value should I put in Excel's cell to change the value that has already been entered as a character or number to "Null"?
2) What DB table should I change the Attribute value I defined in "Type and Attribute Management"?
using Windchill 13.0.1
Hi,
For the 1. question:
The null value is controlled through preference. The default setting is to use the last iteration's value even if you empty the cell in Excel and update the part through import.
From preference management: "Empty Values When Importing from Spreadsheet" - Changing this preference to "yes" will clear the data from part, if Excel's cell is empty
-VVII