Submitted by Gopal Parthasarathy on Mon, 03/02/2015 - 22:37
Forums:
We have set of part numbers details in excel sheet,
we need to extract those parts material in the excel corresponding row.
whenever we extract assembly details in spread sheet, it gives all the parts in excel spreadsheet.
But we don't need all the part details, we need only material name of the part which is assigned to that.
we where looking for that option in NX it self, but Nx users concluded no such option.
So we are looking for to do such process through NX journal
Anyone can help on this.?
Regards
Gopal Parthasarathy
re: material name
I'm not sure I understand the process. Have you created an Excel sheet that lists the desired material that you want to assign to the NX part, or have you exported the existing material to Excel from NX?
I have list of NX part Nos.,
I have list of NX part Nos.,
Say Assembly "XYZ" has 1000 parts, For FEA Analysis I have considered only 100 Structural parts which are responsible for load path. Once I completed FEA Model, by the time there may be change of material of parts
Like I took Part No.YY1234 material which is assigned to that part is Aluminum when I took information from NX, during my preparation of FEA model, design team also work in CAD development. after some time say 2 weeks approximately I have prepared my FEA model, by the time design team changed Part No.YY1234 material to Steel, which I am not aware of that.
Before perform my FEA analysis, I want to check all the material which I assigned respective part nos. are still same or not.
I have list of Part Nos. which I used for my FEA analysis, for that I want to check with NX 7.5 with single shot.
regards,
Gopal Parthasarathy
Gopal Parthasarathy
CERT/FEA Engineer
B/E Aerospace
re: compare files
So essentially, you have two excel files exported from the assembly; one that is current and one from some point in the past, and now you need to know what changed. I think there is an easy way to get that information without writing custom journal code to do it. I'd suggest sorting both excel files with the same criteria and exporting them to a csv file (or other text format), then use a file comparison tool (such as diffmerge) to highlight the differences.
I have part list in excel,
I have part list in excel, simple one shot. It should read Part no from excel, interact with NX assembly and write next to the column material name, in what way to interact from NX to excel. Nx journal code read part no. from excel sheet, query the NX assembly which is currently opened get the information from UG nx and write the material name in next column of Part No.
Gopal Parthasarathy
CERT/FEA Engineer
B/E Aerospace