Showing results for 
Search instead for 
Do you mean 
Reply

Import part from Excel

Hi,

someone has a Journal that import parts reading from Excel ?

The scope is to create an assembly reading the BOM structure from an Excel file avoiding the 'Add Component' each time.

This is my desire workflow :

Have the assembly open, click the button 'Create assembly structure', select an Excel file with the first column part number and NX add component from my load options setting.

 

Thank you for everything.

Thank you...

Using NX 11 / RuleDesigner PDM

10 REPLIES

Re: Import part from Excel

Assuming that you can add the parts based on the Excel column - how do you envision placing the parts in the assembly - relative to each other;  Contraints, absolute origin, etc.?

SteveA
DRT Mfg. Co. Inc.
www.drtusa.com
Win7x64 NX8.5.3.3

Re: Import part from Excel

[ Edited ]

Add constraints relation is my succesive works.

Add components manually is a time consuming, but with this tool I can save time.

Thank you...

Using NX 11 / RuleDesigner PDM

Re: Import part from Excel

[ Edited ]

Please remind me I will create one for you. it should be easy one. I will appreciate if you give step by step exact requirements.

Re: Import part from Excel

Cubalibre00,

 

An alternative could be to use the existing utilty "%ugii_base_dir%\ugii\ug_assy_build.exe".

 

HTH,

 

Joe

Re: Import part from Excel

Hi Joe,

interesting tool.

Thank you...

Using NX 11 / RuleDesigner PDM

Re: Import part from Excel

Hi !

 

The UG_assy_Build is a great tool but as far as I Know it does not creat any constraints ?

is ther a way  to build a assambly with constraints between the build in parts ? e.g Load in  acouple of parts->poition coord. sys 1 from part 1 on coord. sys 2 of part 2 ... and so on ?

 

Best whishes everyone

Re: Import part from Excel

Hi programmers,
I've this journal but doesn't works.
Attached the journal and the excel that I will use.

Thank you...

Using NX 11 / RuleDesigner PDM

Re: Import part from Excel

Using excel files can be a hedache so to simplify things could you use a csv file?

You can still edit the csv file in excel or export your excel sheet as a csv file if you prefer.

This can then be opened as a streamreader like in the example below.

 

dim sr as new system.io.streamreader (file_loc & "car_area_maps.csv")
dim temp as string = sr.readline() 

do until temp = ""

'either add parts to the assy as you go or add them to an array and process later

temp = sr.readline()

loop

 Then all you need to do is open each file and then add them to the assy file.

 

Re: Import part from Excel

Hi Mark,
use a csv file is not a problem.
The problem is that I'm not a programmer, I'm a designer that look for journal in the net to quick some my task using NX.
The journal was found in the net.
If you have time and patience to edit this journal...
Thank you...

Using NX 11 / RuleDesigner PDM