BOM/OPL parts help before PCB fab

bomfabricationpcbpcb-assemblypcb-fabrication

I am completing my first official PCB project. I am outsourcing the PCB fab to Seeeed Studio. I was wondering if any of you might be able to shed some light on my issue.
I am using their PCB assembly service with OPL parts. I am using Eagle cad with Seeed Studio's eagle cad OPL parts libraries. Upon uploading the gerbers I was asked to also upload (or fill out their online form) a BOM file for the OPL parts.
My issue is the eagle cad OPL parts libraries do not seem to match up perfectly with there online listings of OPL parts, or at least it is nearly impossible to find any relation among about 50% of the parts.

Has anyone dealt with this before?

Here is the link to their main wiki page regarding this
http://www.seeedstudio.com/wiki/Open_parts_library#Connector
and also their main home web page regarding this
http://www.seeedstudio.com/depot/OPLopen-parts-library-catalog-c-136_138/?ref=side

I am specifically having trouble with figuring out how to fill out there BOM file with the specified parts and values because I cannot relate the parts in the eagle cad libraries with the parts I am finding in there physical listings.

Thanks in advance guys!

Best Answer

I had the same problem. I found a blog post that deprecated the OPL or CPL parts numbers in favor of the more universal Manufacturer Part Number.

I solved it with the following steps:

  • From the schematic view click File > 'Run ULP...'
  • Select bom.ulp

ULP list with BOM.ULP

  • Export a CSV with all values
  • Open it in Excel or import it into Google Sheets
  • Edit it to match the BOM template on SEEED Fusion. This entails deleting most of the columns, as the Seeed BOM format is very simple. SEED BOM Template
  • Note that Seeed only cares about MPN (Manufacturers Part Number) Which might be in a different column on your auto-generated BOM depending on where your library