Inventor General Discussion

Inventor General Discussion

Reply
Active Member
bogdan.noreq
Posts: 10
Registered: ‎01-26-2012
Message 1 of 6 (454 Views)

Export of Sub Assemblies COG to Excel

454 Views, 5 Replies
02-27-2012 01:56 AM

Hi!

 

I have  assembly with over 100 sub assemblies. I need to export the COG for each sub assembly to excel. The COG must be in relation to the parent assembly's origin point.

 

I can get coordinates manualy (right click on sub assembly - iProperties-Phisical), but it is take a lots of time. Any idea how to make it easy!

 

Thanks for your time

 

 


Autodesk Inventor Professional 2013
Windows 7 64-bit
Employee
Yijiang.Cai
Posts: 359
Registered: ‎05-20-2008
Message 2 of 6 (432 Views)

Re: Export of Sub Assemblies COG to Excel

02-28-2012 08:43 PM in reply to: bogdan.noreq

Please try the attached rule, and create one excel file and reset the location of excel in code before running the code.

 

Hope it helpful for you!

 

Thanks,
River

Thanks,
River Cai

Inventor Quality Assurance Team
Autodesk, Inc.
Active Member
bogdan.noreq
Posts: 10
Registered: ‎01-26-2012
Message 3 of 6 (414 Views)

Re: Export of Sub Assemblies COG to Excel

03-01-2012 01:51 AM in reply to: Yijiang.Cai

Thanks a lot for your reply! I am not so good in programing, but all the time I get an error massage -

 

"Uspesifisert feil (Exception from HRESULT: 0x80004005 (E_FAIL))"

 

And what I have to say - that in excel file after I run the rule saved columns names.


Autodesk Inventor Professional 2013
Windows 7 64-bit
Employee
Yijiang.Cai
Posts: 359
Registered: ‎05-20-2008
Message 4 of 6 (404 Views)

Re: Export of Sub Assemblies COG to Excel

03-01-2012 06:38 PM in reply to: bogdan.noreq

It really works fine for me! Could you send me the dataset @ river-yijiang.cai@autodesk.com? That I could use the dataset to investigate this issue.

 

Thanks,
River

 

Thanks,
River Cai

Inventor Quality Assurance Team
Autodesk, Inc.
New Member
mwouters
Posts: 1
Registered: ‎08-22-2012
Message 5 of 6 (316 Views)

Re: Export of Sub Assemblies COG to Excel

08-22-2012 02:39 AM in reply to: Yijiang.Cai
Hi yiiang, I have almost the same problem. This time I'm not interested in the COG's of the subasseblies, but of the parts which are in an assembly. The COG must be in relation to the parent assembly's origin point. I've tried to modify your added rule. But I'm really not into the programming. Could you please help me!. Thank you in advance.
Employee
Yijiang.Cai
Posts: 359
Registered: ‎05-20-2008
Message 6 of 6 (297 Views)

Re: Export of Sub Assemblies COG to Excel

08-22-2012 08:05 PM in reply to: bogdan.noreq

Before adding the attached rule in iLogic, please create one excel file for COG like "D:\bb.xlsx".

 

Copy and paste the attached rule in iLogic, and please update the location of excel file in code line.

 

Run the rule, and it should work fine.

 

Thanks,
River Cai

Inventor Quality Assurance Team
Autodesk, Inc.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.