×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Attributes into spreadsheets...

Attributes into spreadsheets...

Attributes into spreadsheets...

(OP)
Anyone know if we can pull NX part attribute values directly into the modeling spreadsheet? I can get exprvals but not about an attribute format if there is one.  

RE: Attributes into spreadsheets...

What would you like to do with them if/when you get them in the spreadsheet?

RE: Attributes into spreadsheets...

(OP)
A couple of uses...we want to use the values in further calulations and alos for output into documentation. Another goal is to keep model up to date with attributes which supplied by customers through teamcenter.

RE: Attributes into spreadsheets...

After you have opened your Modeling Spreadsheet, select the Spreadsheet main menu-bar tab labeled 'Add-Ins' and then with the cell selected where you wish to start the insertion of the attribute names and values, select the menu item labeled 'Extract Attr'.

Once the Attribute names and values have been loaded you will will be able to tell which are Part Attribute (the part name will be included in the attribute name field inside of quotes) and Attributes assigned to Reference Sets (the Reference Set name will also be include in the attribute name field name inside of quotes) and the attribute type will be abbreviated and shown inside of parentheses, such as (str) for string, shown after the attribute name.

Now if you wish to extract an Object Attributes from something inside the part file, you will need to use one of the 'object specific' spreadsheet functions.  To find more material on what these functions are and how to use them, go to your User Documentation and search on "Object-related functions" and you will find a complete listing of these function as well as information on how use them along with some simple examples.

John R. Baker, P.E.
Product 'Evangelist'
Product Design Solutions
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.org/museum/

To an Engineer, the glass is twice as big as it needs to be.
 

RE: Attributes into spreadsheets...

(OP)
Thanks John. I overlooked this help doc...this is the info I have been searching for.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources