EEVblog Electronics Community Forum
A Free & Open Forum For Electronics Enthusiasts & Professionals
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
This topic
This board
Entire forum
Google
Bing
Home
Help
Search
About us
Links
Login
Register
EEVblog Electronics Community Forum
»
Electronics
»
Projects, Designs, and Technical Stuff
»
EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
« previous
next »
Print
Search
Pages: [
1
]
Go Down
Author
Topic: EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly (Read 6249 times)
0 Members and 1 Guest are viewing this topic.
MrD
Contributor
Posts: 22
Country:
EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
«
on:
November 17, 2019, 01:36:58 am »
I've completed the design for my PCB for my Flash-based Mega Drive cartridge I mentioned in another thread. I'm now up to the stage where I need to send it to JLCPCB and get it evaluated and priced.
According to the JLCPCB SMT Assembly website, I need two files:
- BOM file(Bill of Materials) (.xlsx spreadsheet)
- CPL file(Component Placement List / Pick & Place File (PNP) file) (.xlsx spreadsheet)
Can somebody point me to instructions and/or an example on how to export these files from EAGLE in the correct format for JLCPCB's service?
Logged
luiHS
Frequent Contributor
Posts: 609
Country:
Re: EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
«
Reply #1 on:
November 17, 2019, 05:51:29 am »
You can use the CAM of the Eagle. At least in version 9 there are options to generate the BOM and PnP files.
Logged
MrD
Contributor
Posts: 22
Country:
Re: EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
«
Reply #2 on:
November 19, 2019, 12:51:19 am »
Thank you.
In the CAM Processor I can export a CSV for the BOM, and I guess I have to manually swizzle it in Excel to get it to match JLCPCBs expected columns?
There's no option to export a PNP file though? This is in EAGLE 9.4.2.
Logged
luiHS
Frequent Contributor
Posts: 609
Country:
Re: EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
«
Reply #3 on:
November 19, 2019, 03:48:09 am »
JLCPCB accepts files in CSV format.
And to generate the PnP files, you can use a ULP, for example mountsmd.ulp. I use the one that generates files for the Neoden4 because I have my own Pick and Place machine.
«
Last Edit: November 19, 2019, 04:01:41 am by luiHS
»
Logged
MrD
Contributor
Posts: 22
Country:
Re: EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
«
Reply #4 on:
November 19, 2019, 07:30:03 am »
I appreciate you walking me through this, I'll let you know how it goes.
Logged
MagicSmoker
Super Contributor
Posts: 1408
Country:
Re: EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
«
Reply #5 on:
November 19, 2019, 01:52:04 pm »
I still use v7.7.0 of EAGLE - not convinced joining the Borg is worthwhile - and to generate a BOM with that version I use the attached and zipped ULP. Run it while in the schematic and select the list type as values output as CSV and ; for the separator.
And why did I name the ULP 1-...? So it would be at the top of the selection (along with other handy ULPs like "zoom-unrouted").
Logged
MrD
Contributor
Posts: 22
Country:
Re: EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
«
Reply #6 on:
November 22, 2019, 05:52:07 am »
This is the output from JLCPCB's BOM/PNP uploader with my board. I think some manual finessing is in order here!
This is with the rotation values given by moundsmt.ulp
My IC footprints are mostly from
https://eagle.componentsearchengine.com
which I guess don't match up to the orientations of the pieces in JLCs database.
Should I edit my footprints to match JLC's expected device orientations, or just edit the rotation column of my PNP?
K1 and the two pinheaders aren't being assembled by JLC
«
Last Edit: November 22, 2019, 07:24:33 am by MrD
»
Logged
MrD
Contributor
Posts: 22
Country:
Re: EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
«
Reply #7 on:
January 10, 2020, 01:35:35 am »
In the end I went with PCBWAY, and sent them a very specific example image with the pin 1 locations clearly marked. Very pleased with the result.
Logged
donotdespisethesnake
Super Contributor
Posts: 1093
Country:
Embedded stuff
Re: EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
«
Reply #8 on:
January 10, 2020, 01:19:16 pm »
I suspect JLCPCB automation just doesn't work properly, and in fact they don't use it. A human operator goes through every placement to visually verify, which is why they flag issues if they can't see the pads clearly marked.
Logged
Bob
"All you said is just a bunch of opinions."
Print
Search
Pages: [
1
]
Go Up
« previous
next »
Share me
Smf
EEVblog Electronics Community Forum
»
Electronics
»
Projects, Designs, and Technical Stuff
»
EAGLE: Exporting a BOM file and CPL file for JLCPCB SMT Assembly
There was an error while thanking
Thanking...
EEVblog Main Site
EEVblog on Youtube
EEVblog on Twitter
EEVblog on Facebook
EEVblog on Odysee