Detect changes in BOM

[hansibull]

Hi!
I'm working on a project where we need to create a new revision of a board. I've designed the new revision, but the board house wants to know which components are added or removed from the last revision. How can I make Altium output a "BOM changelog"?

[Gribo]

You can use your version control software to do this (diff). As far as I know, AD can't analyze spreadsheets.

[hansibull]

I've not used AD's version control for this project, so I can't automatically find the diff. Does this means my best option is to do find the diff using Excel, by importing the two BOMs?

[Gribo]

SVN has a diff tool and some VB scripts that compare spreadsheets.

[julianhigginson]

I guess you could have saved the ECO report when you went from the modified schematic to update the PCB?

But really.. they need to just take your new BOM and import it into their system properly if that's what you supplied them.

[tszaboo]

The ECO generates way too generalized changelog. I've used SAP to generate these kind of changes, but then again, you need SAP to do it, and the procedures at the company has to include SAP. Not necessarily a good thing.
Probably the best is to get familiar with the VLOOKUP function in excel.