kicad-jlcpcb-tools: JLCPCB part cannot be selected in the plugin although it is available

Hi, I just orderered a board and I had to modify my BOM in the order process because I could not enter this part with the help of this (otherwise amazing) plugin: C2937625

I have noticed this with some other parts as well. The plugins lists all kinds of headers from the manufacturer ZHOURI, but this 1*3 header is not there although it is clearly available and in stock in JLCPCBs order flow. It is not being found no matter what I search for.

I can hardly imagine it is really not there, so what could be the culprit here?

KiCad Version

Application: KiCad PCB Editor x64 on x64

Version: 7.0.1, release build

Libraries:
	wxWidgets 3.2.2
	FreeType 2.12.1
	HarfBuzz 5.0.1
	FontConfig 2.14.1
	libcurl/7.83.1-DEV Schannel zlib/1.2.13

Platform: Windows 11 (build 22621), 64-bit edition, 64 bit, Little endian, wxMSW

Build Info:
	Date: Mar 11 2023 03:41:46
	wxWidgets: 3.2.2 (wchar_t,wx containers)
	Boost: 1.80.0
	OCC: 7.6.2
	Curl: 7.83.1-DEV
	ngspice: 39
	Compiler: Visual C++ 1934 without C++ ABI

Build settings:
	KICAD_SPICE=ON

About this issue

Original URL
State: closed
Created a year ago
Comments: 33 (27 by maintainers)

Most upvoted comments

It’s an SQLite DB with the following tables: https://github.com/yaqwsx/jlcparts/blob/1a07e1ff42fef2d35419cfb9ba47df090037cc7b/jlcparts/partLib.py#L48-L117. And an example on how to fetch it: https://github.com/yaqwsx/jlcparts/blob/1a07e1ff42fef2d35419cfb9ba47df090037cc7b/.github/workflows/update_components.yaml#L45-L50

yaqwsx on Apr 29, 2023

I’ll look into it on Monday, I’ve no computer where I’m right now

Bouni on May 6, 2023

I figured that one out already. Stock needs to be stored as string as the in stock check is a string comparison, which is fine, but does not work if stock is in integer.

So that one is fixed in my PR already, database works flawlessly.

I also have the split logic in already and tried reassembling just in pure python, works a treat.

pipeline next. (I have a checklist in the PR)

markusdd on May 1, 2023

That’s totally feasible but takes some time which very scares at the moment 😕

Bouni on Apr 29, 2023