How to Import back a BOM

[ajarizaleta]

Eagle provides a export for BOM (Bill of Materials).

The BOM contains the attributes of each device on a Schematic and the Board. It is important that every component to have as attributes a part number, brand, name, value and other characteristics. We can export the BOM.

But, how could I export the BOM, edit it and then importing it back to the schematic?

By editing I mean to populate the attributes. In particular, there are many component with the same brand, part number and value but different name, even sheet. Going component by component is a really tedious task. For example I could have about 30 equal value resistors, with different name, or decoupling capacitos, etc.

Thanks in advance, Alfredo

[rachaelATWH4 · Accepted solution]

---

@ajarizaleta wrote:

By editing I mean to populate the attributes. In particular, there are many component with the same brand, part number and value but different name, even sheet. Going component by component is a really tedious task. For example I could have about 30 equal value resistors, with different name, or decoupling capacitors, etc.

---

Hi Alfredo,

There isn't a way to import a BOM back, but in the latest version of EAGLE it's easy to select related parts and update them together so no need to do them one at a time.

Use the Design Manager / Selection filter to select parts to change and the Object Inspector to narrow it down to the specific subset and update groups with identical changes in one go. So for example, say you want to update an MPN attribute for all 27K 0603 resistors. In the schematic using the design manager you can add filters on hasFootprint to narrow the selection to all 0603's (you'll need to know the actual package name in your library) and Name to narrow down to R*. Then in the results there is a dropdown where you can 'Select All'. Now switch to the Object inspector and in the 'Selected objects' section, sort on value. Find the 27K value parts and using Shift to multi-select all the rows. Now in the attributes section you can manipulate the MPN attribute to specify the correct part for these parts and all the parts in the design will be updated at once.

Note: You could also put the value in the Design Manager filter, but this way you can access other groups of values more quickly so if you have more than one value to update leaving the value to be selected in the Object Inspector is preferable in my experience.

Best Regards,

Rachael

[zenworksengineer]

I'm trying to do something like this but my Attributes is just an empty box.

The selection proces works fine.

I am trying to change all the resistor and capacitor packages from 1206 to 0603. There are about 200 parts.