Skip to main content
J
JP_109388934-Participant
4-Participant
April 26, 2024
Question

Issue from using Excel upload function

  • April 26, 2024
  • 1 reply
  • 553 views

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

1 reply

V
VVII10-Marble
10-Marble
April 29, 2024

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

    Terms & ConditionsCookie settingsAccessibility statement