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

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

Issue from using Excel upload function

JP_10938893
3-Visitor

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

Top Tags