×
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

tools spreadsheet <-> partslist

tools spreadsheet <-> partslist

tools spreadsheet <-> partslist

(OP)
Is there a way to use the partslist inside Gasteway Tools Spreadsheets- or is it impossible?
thx in ad

RE: tools spreadsheet <-> partslist

Hi

I don't understand so well,

what you want to mean, with tool spreadsheets,

See you.

RE: tools spreadsheet <-> partslist

If you're talking about adding the data from a Parts List to an NX Spreadsheet, be it Gateway or Modeling, the only approach that you can use without writing an NX Open application would be to select the Parts List note, press MB3, select the Export... option, and when the dialog comes up change the Output Location to 'File' and Format to 'Commas between Columns', browse to where you wish to save the file and hit OK.  Now go to Gateway (or modeling for that matter), and select...

Tools -> Spreadsheet...

...and when the spreadsheet opens go to...

Data -> From Text

...and select the text file you just created and using the spreadsheet's Import Data Wizard, set the loading options to 'Delimited' with 'Commas' as the delimiter, and you should be good to go.

Now if this was NOT what you wanted, you will need to be a bit more clear in your question as well as perhaps provide some example files.

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: tools spreadsheet <-> partslist

(OP)
thx John,
I know these option on the partslist table, that works - ok.
I'm just looking to edit the partlist from the Nx spreadsheets. There are addons available ( NX6 - Office 2007)
from Nx Spreedsheets to extract and refresh attributes ( for what use? ) - My aim is/was it to access attribute from spread for bidrectional editing - as alternative to walk through the parts properties. No way to do it?
thx  

RE: tools spreadsheet <-> partslist

Even if you could directly access with a spreadsheet the Attributes from the components which are referenced by the Assembly Parts List, you couldn't edit them from the Assembly since you'd have to open, edit and save each Component where you wish to edit an Attribute in order to make those changes permanent.  This sort of task would be better addressed with some sort of NX Open application.  

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.
 

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