Inventor General

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

Export of Sub Assemblies COG to Excel

426 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: 350
Registered: ‎05-20-2008
Message 2 of 6 (404 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 (386 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: 350
Registered: ‎05-20-2008
Message 4 of 6 (376 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 (288 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: 350
Registered: ‎05-20-2008
Message 6 of 6 (269 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.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube