Inventor General Discussion

Inventor General Discussion

Reply
Distinguished Contributor
Raider_007
Posts: 484
Registered: ‎08-22-2006
Message 1 of 53 (2,075 Views)

BOM Thumbnail Export to Excel

2075 Views, 52 Replies
09-26-2011 02:01 PM

Hi guys I have created a quick tool to export the contents of Inventors Structured BOM to Excel including the Thumbnail. One of our customers requested it and I could not find another way of doing this so I created a little app for it. Let me know what you think.

 

Download: http://filegooi.co.za/get2/047d021461b6ef4bb9fab9f3d4aeec35/Inv+BOM+Exp.rar

 

Pieter

*Expert Elite*
blair
Posts: 4,157
Registered: ‎11-13-2006
Message 2 of 53 (2,036 Views)

Re: BOM Thumbnail Export to Excel

09-26-2011 10:47 PM in reply to: Raider_007

Nice, any way the end user can select which fields they want?

Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.

IV2015 SP1 PDSU / Sim Mech 2015 r1 /
Win7-64
EVGA X79 - Classified, iCore7 3930k 32Gb Quad-Channel
950Gb (2 x 500Gb Sata III SSD RAID0 Adaptec 6805E Controller)
Nvidia GTX-690 Classified - 340.52
SpacePilot Pro 3.17.7, 6.17., 4.11
Distinguished Contributor
Raider_007
Posts: 484
Registered: ‎08-22-2006
Message 3 of 53 (2,034 Views)

Re: BOM Thumbnail Export to Excel

09-26-2011 11:14 PM in reply to: blair

Hi, Yes it can be done but will take quite a bit more coding. Which fields do you need?

Distinguished Contributor
guyh
Posts: 372
Registered: ‎12-11-2007
Message 4 of 53 (2,030 Views)

Re: BOM Thumbnail Export to Excel

09-27-2011 12:45 AM in reply to: Raider_007

This will be a really nice add in.  does it work with 2011?

AutoCADM 2011 SP2
Inventor Pro 2011 SP2
Distinguished Contributor
Raider_007
Posts: 484
Registered: ‎08-22-2006
Message 5 of 53 (2,022 Views)

Re: BOM Thumbnail Export to Excel

09-27-2011 01:27 AM in reply to: guyh

Yes with both 2011 and 2012. But give it a try and let me know.

Distinguished Contributor
guyh
Posts: 372
Registered: ‎12-11-2007
Message 6 of 53 (2,018 Views)

Re: BOM Thumbnail Export to Excel

09-27-2011 01:35 AM in reply to: Raider_007

Great.  Does it work on 64 and 32 bit?  What is the procedure\where is the tool found?  Does it work in the assembly environment or in the drawing environment.  I have installed in on Win7 64 bit Inv 2011 and can not see the function.

 

Thanks again,

Guy

AutoCADM 2011 SP2
Inventor Pro 2011 SP2
Product Support
Henry.Huang
Posts: 10
Registered: ‎09-15-2008
Message 7 of 53 (2,011 Views)

Re: BOM Thumbnail Export to Excel

09-27-2011 02:27 AM in reply to: Raider_007

Seems not woking on a Chinese 64bit Win7 OS.

 

Can i ask a question about picture in cell.

Excel do not support insert a piture into a cell.  What's your approach about thumbnail in Excel cell?




Henry Huang
Technical Support Specialist
Customer Service & Support
Autodesk, Inc.

Distinguished Contributor
guyh
Posts: 372
Registered: ‎12-11-2007
Message 8 of 53 (2,007 Views)

Re: BOM Thumbnail Export to Excel

09-27-2011 02:56 AM in reply to: Henry.Huang

Doesn't seem to work on UK win7 64bit.

 

Cheers,

Guy

AutoCADM 2011 SP2
Inventor Pro 2011 SP2
Distinguished Contributor
Raider_007
Posts: 484
Registered: ‎08-22-2006
Message 9 of 53 (2,005 Views)

Re: BOM Thumbnail Export to Excel

09-27-2011 03:03 AM in reply to: guyh

Yes it should work on both 32 and 64 bit. Its not an add-in its a standalone application and was compiled for both 32 and 64 bit.

Yes it works once you have opened and Assy file. It will do a check to make sure you have an Assy file open. Then ask you for an excel filename to export to and then export the Structured BOM into the excel file.

 

Just give it a go and let me know what your experience is and I can do a few tweaks where needed.

 

Oh and here is another download location the first one will expire soon:

http://www.mediafire.com/file/qizgs30nc6bls4c/Inv%20BOM%20Exp.rar

 

Distinguished Contributor
Raider_007
Posts: 484
Registered: ‎08-22-2006
Message 10 of 53 (2,005 Views)

Re: BOM Thumbnail Export to Excel

09-27-2011 03:09 AM in reply to: guyh

Ok I will have to test to make sure it works 100% on 2011. Will let you know. For the guys using 2012 let me know if you have any issues. email me direct at pieter(at)mgfx(dot)co(dot)za

 

Pieter

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 or visit the Installation and Licensing Forum to get help installing your software.