• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk Inventor

    Reply
    Distinguished Contributor
    Posts: 425
    Registered: ‎08-22-2006

    BOM Thumbnail Export to Excel

    1528 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

    Please use plain text.
    *Expert Elite*
    blair
    Posts: 2,263
    Registered: ‎11-13-2006

    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.

    IV2014.1 PDSU / Sim Mech 2014 /
    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 - 314.07
    SpacePilot Pro 3.16.1 / 6.16.0 / 4.11
    Please use plain text.
    Distinguished Contributor
    Posts: 425
    Registered: ‎08-22-2006

    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?

    Please use plain text.
    Distinguished Contributor
    Posts: 351
    Registered: ‎12-11-2007

    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
    XP 32-Bit SP3
    Please use plain text.
    Distinguished Contributor
    Posts: 425
    Registered: ‎08-22-2006

    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.

    Please use plain text.
    Distinguished Contributor
    Posts: 351
    Registered: ‎12-11-2007

    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
    XP 32-Bit SP3
    Please use plain text.
    Product Support
    Posts: 10
    Registered: ‎09-15-2008

    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

    Please click "Accept as Solution" if this response answers your question.

    Please use plain text.
    Distinguished Contributor
    Posts: 351
    Registered: ‎12-11-2007

    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
    XP 32-Bit SP3
    Please use plain text.
    Distinguished Contributor
    Posts: 425
    Registered: ‎08-22-2006

    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

     

    Please use plain text.
    Distinguished Contributor
    Posts: 425
    Registered: ‎08-22-2006

    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

    Please use plain text.