Project Description
BOM Imploder is used convert a Bill-Of-Materials .csv file from one line per part to one line per part type. It can also reverse the process.

It is used to move BOM's from OmniGlyph/Circad to Parts&Vendors.


BomImploder.jpg

Example of input:
Type/Value,Modifier,AE2F P/N,Manufacturer,Mfg. P/N,Misc.,Description,Pattern,Qty,Reference IDs
.01µF,,ECC1035XT,,,,,SMC0805,1,C4
.01µF,,ECC1035XT,,,,,SMC0805,1,C10
.01µF,,ECC1035XT,,,,,SMC0805,1,C12
.01µF,,ECC1035XT,,,,,SMC0805,1,C16
.01µF,,ECC1035XT,,,,,SMC0805,1,C17

Example of output:
Item Num,Type/Value,Modifier,AE2F P/N,Manufacturer,Mfg. P/N,Misc.,Description,Pattern,Qty,Reference IDs
2,.01µF,,ECC1035XT,,,,,SMC0805,12,C4 C10 C12 C16 C17 C20 C22 C23 C24 C27 C34 C40
3,.1µF,,ECC1045XT,,,,,SMC0805,24,C1 C2 C5 C6 C7 C9 C11 C13 C15 C18 C21 C25 C26 C29 C30 C31 C33 C35 C36 C37 C39 C41 C43 C45
4,100pf,,ECC1015CT,,,,,SMC0805,1,C14

Last edited Nov 9, 2010 at 10:31 PM by Eugene55, version 5