search

Combinatix / JLCPCB-Basic-Parts

JLC PCB Basic Parts Eagle Library with LCSC Part Numbers
23 stars 1 forks source link

Share extraction program ? #5

Open sylvaneau opened 1 year ago

sylvaneau commented 1 year ago

Hi,

Could you share the extraction program you wrote to build this library ?

I would like to add some other components from their catalog.

Thx

Combinatix commented 1 year ago

Hi, I use MS Access to import, organize and extract data from LCSC to the library. The program is using VBA macros and it's quite complicated. For example, you have to modify SQL queries every half of a year to fix the changes they make in the dataset (I had to learn the meaning of the Chinese symbols to make an efficient search and replace functions).

So yes, I can publish it, but I rather not to, because it is a bit messy program and I'm not sure if anyone would understand how to use it.

The program needs a "pattern library" which contains every part, like resistors, diodes, opamps etc. Then it just injects the part numbers into the correct places.

So the real problem is that the pattern library contains only a few parts. What would help me is creating more parts in the pattern library.

Which parts do you want to add?

Combinatix commented 1 year ago

I have just looked at current data and I found that the JLC changed a lots of parts from BASIC to EXTENDED. For example, there are no basic transistors anymore :(

sylvaneau commented 1 year ago

You know, OpenSource is more about sharing knowledge than sharing code ;-)

It doesn't really matter if your code is crappy or whatever, what is worthy is all your work to understand the way it works :-)

Maybe nobody will use it, but who knows ? ;-)

To answer your question, I wanted to make your extraction kinda automatic to let anyone choose which component he wants and then generate a library to extract it ^^