Page 1 of 1

Pick and place reports on 4.2.0.1

Posted: 07 Jan 2022, 15:01
by Mikejec
The pick and place export is all messed up.
The first pic (Pick and Place selections.jpg) shows the selections I chose to include.
Pick and Place selections.jpg
Pick and Place selections.jpg (76.33 KiB) Viewed 999 times
The second pic (File Created.jpg) Shows the file output.
File Created.jpg
File Created.jpg (251.77 KiB) Viewed 999 times
The export file contains columns that haven't any definition or meaning.
Others are out of order.
I am on widows 11 as of today.

I tried the export on an older version and on a windows 10 machine and the output file is correct on the older version build.
Newer version has some other bugs as well but this is a show stopper for us. I hope the Gerber's, drills, and stencil output are correct still.
It would be nice if the pick and place report would exclude (option to exclude) through hole parts.

Re: Pick and place reports on 4.2.0.1

Posted: 08 Jan 2022, 09:23
by SoundMod
I think it is just a matter the way excel as parsed the csv data.
Check common Excel issue with csv. IMHO excel sucks at many things.

https://www.ablebits.com/office-addins- ... el-issues/

Re: Pick and place reports on 4.2.0.1

Posted: 09 Jan 2022, 08:21
by Mikejec
I ran an older version of dip trace that has not been updated (my office computer) yet and it worked perfect.

Re: Pick and place reports on 4.2.0.1

Posted: 10 Jan 2022, 02:21
by Serg
In Pick and Place, check the following:
- "Decimal Separator",
- "Column Divider",
- "Quotation Marcs for Values".
PP1.png
PP1.png (21.74 KiB) Viewed 978 times
PP2.png
PP2.png (2.7 KiB) Viewed 978 times


After that, insert csv data into Exel considering these settings.

Re: Pick and place reports on 4.2.0.1

Posted: 10 Jan 2022, 13:36
by Mikejec
That fixed the problem. I thought it was a bug. I'm glad it was on my end here. Thank you Serg.