BOM Output Report with iLogic

[Mark_Fry]

I am new to iLogic and I have been asked to try and come up with a solution to a similar BOM output. My requirements are for example a stairway, to list all the different steal sizes used to create said stairway and be able to total up these sizes to give a total length of steel, for each size, for steel ordering of each size and type and to export this to a file, which can Then be printed out.

My trouble is that I am new to iLogic and don't realy have the knowledge to achieve this output. Can any one help?

Regards,

Mark

[wayne.brill]

Hi Mark,

The code for this will depend on how the size of each steel part can be obtained. If you let me know this I could find some examples and share some ideas on what part of the API could be used.

Thanks,

Wayne

[Mark_Fry]

Hi Wayne,

Thanks for your reply. I expect that each part will be placed by framegenerator and the length would be obtained from a parameter which sets the overall length of each section in the initial sketch. The output from the BOM would then need to total the lengths of all the individual like steel sections and spit out the totals of each type of steel section for ordering, listing steel section type and and length. The final ordering output can be in any printable file format ie. excel, pdf, txt etc. Oh, one final thing it will also need to cope with sections that have an angle cut at possibly both ends. Not sure how I am going to do that, maybe a custom property?

I hope I have explained it so that you can understand.

Regards,

Mark

[wayne.brill]

Hi Mark,

Have you considered using an app available on the App store? Here is one that seems like it could meet your requirement. (There could be others)

"BOM Tools Pro"
https://apps.autodesk.com/INVNTOR/en/Detail/Index?id=appstore.exchange.autodesk.com%3aapp98013803b2b...

This DevBlog post Has a code example of exporting to Excel. (does not export parameters)
http://adndevblog.typepad.com/manufacturing/2016/02/use-excel-api-to-export-partslist-content.html

This DevBlog post has a code example that accesses parameters.
http://adndevblog.typepad.com/manufacturing/2012/08/accessing-inventor-parameters.html

You can use attributes to store data on objects:

http://adndevblog.typepad.com/manufacturing/2012/06/using-attribute-sets-in-c.html

http://adndevblog.typepad.com/manufacturing/2015/07/attributes-of-componentoccurrence-vs-componentoc...

Or maybe iProperties could meet your requirement:

http://adndevblog.typepad.com/manufacturing/2013/03/save-extra-data-in-inventor-file-1.html

Regards,

Wayne

[Mark_Fry]

Hi Wayne,

Thanks for your effort in coming up with a solution, while not completely solving our requirements your suggestions

will go a long way towards completing our requirements.

Once again thanks very much.

Regards,

Mark 

[Chirpyboy2060647]

Well I have a code that lets me export my Custom Parameters to an excell file but also exports my BOM table i made on my dwgs to excell as well. Depends all on if you have parameters made in your files that you can pull. Unless this is not what youre looking for.

[Mark_Fry]

Hi Chirpyboy,

That sounds as though it could be just what I'm looking for. I'll send you a message  with my email address so if your willing you can forward me a copy of the code.

Regards,

Mark