BOM In Metric

[Lupe_Stewart]

I have a customer that wants the entire BOM list in metric..... there is 50 line items and I am hoping that there is a way to convert all of it with out having to go inside each one of the 50 parts and change the parameters to MM.

I am also thinking to intagrate this feature to all the existing templates...... so is there a solution to this??

[CGBenner]

@Lupe_Stewart 

What type of information in your BOM needs to be converted?  I'm assuming lengths?

There may be some sort of iLogic solution? 

[Lupe_Stewart]

Pretty much the major parameters.... ID... OD... THICK... LENGTHS... 

[mslosarKES]

The answer is 'it depends' 🙂

If you have columns with just things like Length and Width, you can set the properties of the Parts List to metric output easily enough.

The trick is going to be if you have to do Descriptions as well.  Each Description is different (typically) and it depends on how you have them set up.  For example, for us, a plate has the Description of PL, 1/4" x 6" (length is a separate column).  If you've written that manually, there's not a way to change it very easily.  We do it as an equation =PL, <THK> x <WIDTH>.  Even at that, you'd have to go into the parts in one way or another. But again, it depends on how your Parts List/BOM is set up.

It is also possible to write ilogic or API code to loop through an assembly, find your parameters and change their outputs from imperial units to metric units.  

[Lupe_Stewart]

I have pretty much everthing set up as this:

If PART = "PIPE WITH PLAIN ENDS" = True Then

iProperties.Value("Project", "Description") = "=PIPE: <SIZE> INCH, SCH. <PIPESCH> (<WALL> WALL)<Category> <LENGTH> LONG<SEAMTYPE> WITH PLAIN ENDS"
iProperties.Value("Project", "Project") = "=PIPE SPOOL: <SIZE> INCH."


I try to keep everything as a parameter driven statement all descriptions are the same... just the parameters that are needed will change

[Lupe_Stewart]

everything that is in the library is written thrr rules, same terms, just the parameters change, about 90% of the parts are 3rd party embedded excel sheets ran thru ilogic for the user selection, true false statements for parts that cannot be purchased but can be formed or machined. if that helps any