I generated several libraries for Altium (or Circuit Studio) using Database Libraries which I then exported to IntLibs.
I realize you can get many of these parts from Altium or other third parties. I wanted to figure out on my own how I could scrape data from Digi-Key and (almost) automatically create part libraries.
There are 6,029 resistors, all are Panasonic ERJ series. The resistors are split up into 6 different IntLibs according to package size: 0201, 0402, 0603, 0805, 1206, 2512. I scraped the data from Digi-Key to create these libraries and thus they contain a significant number of parameters that you can use for your BOM generation.
The capacitor libraries are similar. There are 4,739 capacitors in 6 different libraries split up according to package size: 0201, 0402, 0603, 0805, 1206, 1210. They all contain similar parameters as the resistors. All capacitors are Murata – because it was easier to scrape one manufacturer without getting thousands of duplicate value parts.
I did this mainly for my own education but I thought someone else might find it useful so I'm sharing them. Relatively speaking it was pretty quick making libraries for over 10,000 parts but I learned a few things:
- Microsoft Access sucks for this.
- Altium Designer (v15 at least) can't read .xlsx files properly
- Altium Designer v16 converts DBLIBs to IntLibs at a rate of about 1 part per second (IT TOOK A LONG TIME)
- Altium Designer v15 converts DBLIBs to IntLibs at a rate of about 25 parts per second
- If you want to keep libraries like this up to date you need Altium Designer because Circuit Studio can't handle DBlibs
Here's a link to my blog which has the downloads. [I don't have any ads on my blog so I hope nobody gets angry about me linking to it.]
http://martin.engineer/wp/?p=541