Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

OS_PART_NAME in part family template

Status
Not open for further replies.

DanielFlora

Aerospace
Jul 1, 2014
9
I am using NX with Teamcenter to create a part family. In the spreadsheet it automatically creates columns for DB_PART_NO and OS_PART_NAME. What is the significance of OS_PART_NAME? I know it has something to do with Teamcenter, but I am not sure how this column of information is being used. For this reason, I am not sure whether I want to put the part number or the part description in this column.

-Daniel
 
Replies continue below

Recommended for you

Daniel,

Those are the database attributes and must exist. I usually set $B2 = $A2 within the first 2 columns of your part family template so that I dont have to mess with then.

DB_Part_NO is your P/N
DB_Part_Name basically points to the same.
I think truly that these are for the Native PS and the Databsae in the event that you import an assy from native and it cant fint it in the database....

(Since you are using excel)What I usually do is create a series of concatenates(If I family will allow it) so that the Part name is read from the construction of the part

For instance for a family named "123" with 2 other "dashes" I might show it as

Column A Column B Column C Column D
DB_Part_NO DB_Part_Name TitleA TitleB
CONCATENATE("123-"&C2&"-"&D2) =A2 A B = 123-A-B
CONCATENATE("123-"&C2&"-"&D2) =A2 B C = 123-B-C
CONCATENATE("123-"&C2&"-"&D2) =A2 ZZ 1 = 123-ZZ-1

This approach has allowed me to control my expressions to the right of the last column and allow for some ripe automation. the expressions push my model, while the first 2 columns create the items in TC as you have defined.

Regards
Kenny
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor