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

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

Issue from using Excel upload function

JP_10938893
4-Participant

Issue from using Excel upload function

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 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

Announcements


Top Tags