search

fritzing / fritzing-app

Fritzing desktop application
http://fritzing.org
Other
3.97k stars 826 forks source link

PNP (Pick-and-Place) file is not a common Format (XLS,XLSX,CSV, etc.) #4056

Closed brdane closed 1 year ago

brdane commented 1 year ago

Problem

PCB manufacturers like JLCPCB cannot accept the .xy file format that Fritzing exports.

Proposed Solution

Implement exporting of the PNP file to XLS, XLSX and CSV... along with the existing .xy format

KjellMorgenstern commented 1 year ago

The xy file is in csv format.

brdane commented 1 year ago

Even if JLCPCB is unable to load it?

KjellMorgenstern commented 1 year ago

Why can't they load our CSV?

brdane commented 1 year ago

I am not sure why. All I know is that I took the .xy file, changed the extension to CSV since that is what they accept, but it still does not upload for some reason.

Unbenannt

KjellMorgenstern commented 1 year ago

From the screenshots, it looks like you tried to upload the bill of materials, not the pick and place file.

brdane commented 1 year ago

The one on the left is indeed the bill of materials but there is another upload on the right for the PNP file, which you see I uploaded too.

KjellMorgenstern commented 1 year ago

From the error message I can see as much information as you. Maybe contact jlcpcb support about it?

brdane commented 1 year ago

Contacted their support and they said that both BOM and PNP files are a different format/layout than what fritzing generates. In the screenshots below I have the BOM/PNP on one side and JLCPCB's example BOM/PNP that they accept. Labels are different, there seems to be a lot of information that they, in-particular, do not need.

bomcompare pnpcompare

brdane commented 1 year ago

For the PNP screenshot, my version of Excel (for some reason) opens its incorrectly, but it does show correctly in LibreOffice Calc. Regardless, JLC can't upload it. Their support member even made modifications to it as well and asked me to upload, but it also did not work.

brdane commented 1 year ago

Would it help your team if I uploaded JLC's example BOM/PNP files as well as other ones?