
Has anyone here managed to properly convert CSV BOM and pick+place files from DipTrace to use by JLCPCB's board population service, and could say how their files really nead to be constructed? Then I could write myself a converter script DipTrace -> JLCPCB and be done with it for future projects. I don't feel further conversation will be fruitful, more like frustrating and wasting time. Excel files and CSV files are not the same byte streams. when I asked about things like needed column separator character and other things. CSV which DipTrace exports (and I can modify to obey a certain rule set they require). They were very nice and all, but the person I had some back and forth conversation with clearly has no idea how computer files work and that Excel files are in fact not the same as CSV files even though they look the same on her screen after importing a CSV file that's correctly formatted into Excel. I asked JLCPCB directly via their support mail. After the support person claimed "there are no separators, only space", I also tried space to no avail.

I tried as well as tabs for separating columns. The upload site complains about the files having errors, though - alas not which of them and what is wrong. So I export that, too, from diptrace, and, for a test, change the whole thing in an editor by hand to what I can gather from their descriptions. Now "CSV" is a vague concept and almost no one using such a format actually seperates things by comma.

I found Excel table examples on their site for pick+place and BOM files, and mentioning that CSV is also supported. This time I want to try their board population service. In fact in the past I had a couple small projects made, but hand-populated by me.

The DipTrace- exported gerber and drill files seem to be eaten with no problems by the JLCPCB upload site.
