Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Assign Attributes From Excel

Status
Not open for further replies.

mbrown1000

Mechanical
Jan 24, 2020
2
I apologize if this has already been covered but I have been searching for a while and can't find anything.

I'm looking for something like the AssignAttributesForTooltips journal in the sample NX Open apps that come with the installation, except I want to assign attributes for each part in an assembly (and the assembly part itself).

Let's say I have an assembly named 123 which contains parts AAA, BBB, and CCC, and an Excel sheet that lists the part name in column A and another separate attribute for each part name in column B (like cell A1 contains 123 and cell B1 contains 456, cell A2 contains AAA and cell B2 contains ZZZ, and so on). I want to cycle through each part, look up the appropriate cell in the sheet based on the part name attribute, and then create a new attribute with the value in the corresponding cell in column B.

I think I could eventually figure out how to do this, but I thought I would check and see if maybe it had already been done first.
 
Replies continue below

Recommended for you

Hi mbrown1000
i have seen journal to feel attributes at assembly level and part level.
Do you get the something for assigning attributes from Excel?
tHANKS.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor