issues with jlcpcb BOM file uploads

[bsautner]

This is an awesome project! I wanted to share some issued with attempting to get this board manufactured.

Steps to reproduce:

• After uploading the gerber file to jlcpcb.com it processes it correctly.
• Select PCB Assembly (click next and next)
• Add BOM File. I had to convert PicoBerry_V1.0_BOM.xlsx to a .csv because they reject the excel spreadsheet with an error that it has multiple sheets.
• Add P&P File
• Error: The below parts won't be assembled due to data missing. PCB1,MOD100,SCR950,SCR951 designators don't exist in the CPL file.

Q902 shows 20 shortfall J103 shows part not found MECH952,MECH953 shows part not found

I can update this issue if figure out compatible parts jclpcb has or an alternate at digikey but I figured I'd share the issue in case the file just needs updating. Thanks again for making this.

[mfolejewski]

Regarding component sourcing:

• at JLCPCB Assembly there are plenty of components, that you marked as non available/out of stock/shortfall (please see the attachment - screenshot).
• BOM & Pick&Place files are generic. You can edit them for uploading to the specific fab (PCBWay, JLCPCB).
• and yes, some graphical/mechanical components are not mounted, as mounting holes or screws.

[mfolejewski]

As J103 you can use: 1.5mm: DF40C-100DS-0.4V(51) 3.0mm: DF40HC(3.0)-100DS-0.4V