Importing placements for board not showing up in job

Jim Young

unread,

Jul 9, 2023, 7:32:05 PM7/9/23

to OpenPnP

I create a new board.
Import the placements for the board using the Reference CSV format.
Create a job and add the board to the job.

The board lists the placements.

None of the placements are listed in the job for the board.

I have tried various sequences of steps and nothing seems to work to get the job to show the board placements. I tried saving the job, removing the board from the job and adding it back. Nothing seems to work.

If there some secret handshake I'm missing here?

Also how can I get the Comments field in the placement to populate? I have tried Value and Comment as the file header and nothing is showing up.

tonyl...@gmail.com

unread,

Jul 9, 2023, 10:20:43 PM7/9/23

to OpenPnP

>The board lists the placements.

Do you mean on the Boards tab you can see all the placements?

>None of the placements are listed in the job for the board.

Make sure you select the board in the Job table (just click on it). You also need to set the side of the board in the Job table, i.e., if the placements are all on the opposite side that is set, none of them will show in the Job Placements table.

>Also how can I get the Comments field in the placement to populate? I have tried Value and Comment as the file header and nothing is showing up.

Try making the column header "ADDCOMMENT". I suspect some CAD packages export the part's value in a column with the heading of "COMMENT" so you can't use that for actual comments.

If you are still having problems, please post your *.board.xml and *.job.xml files.

Tony

Jim Young

unread,

Jul 9, 2023, 10:52:13 PM7/9/23

to OpenPnP

Okay, the missing placements in the job view was a mismatch of sides. This board has all it's placements on the bottom. Once I matched up the sides everything showed up. But, I have had no luck getting the Value column to import. I have tried every valid column header text with no luck. I need this data so that I can match up the parts to the placements.

Board and placement csv attached.

Thanks, for your help.

EG-2-Top-PCB-PnP.csv

EG-2-Top-PCB.board.xml

EG-2-Top-PCB-Top.job.xml

Jan

unread,

Jul 10, 2023, 6:18:28 AM7/10/23

to ope...@googlegroups.com

Hi Jim!
I've just checked your .csv find and can't find any issues. It imports
without any complains for me using the Reference CSV importer. (I've
used the test branch version "SHA-1:
5869401d093eab8e779a1b9336e872d227fe1179" from May 3rd.)
The value column is a required column. If it can not be imported,
you'll get an error message pointing you to the Wiki
(https://github.com/openpnp/openpnp/wiki/Importing-Centroid-Data). I
just verified, that if I rename the value header from "Comp_Value" to
"Comp_Valu" I do get this error message.
Your .csv file does not contain comments. If you'd like to import them,
please add a column with the header "ADDCOMMENT" (case in sensitive as
all other heads).
If you're still facing issues, please post the log. Thank You!

Jan

> * I create a new board.
> * Import the placements for the board using the Reference CSV
> format.
> * Create a job and add the board to the job.

>
> The board lists the placements.
> None of the placements are listed in the job for the board.
>
> I have tried various sequences of steps and nothing seems to
> work to get the job to show the board placements. I tried saving
> the job, removing the board from the job and adding it back.
> Nothing seems to work.
>
> If there some secret handshake I'm missing here?
>
> Also how can I get the Comments field in the placement to
> populate? I have tried Value and Comment as the file header and
> nothing is showing up.
>

> --
> You received this message because you are subscribed to the Google
> Groups "OpenPnP" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to openpnp+u...@googlegroups.com
> <mailto:openpnp+u...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com?utm_medium=email&utm_source=footer>.

Jim Young

unread,

Jul 10, 2023, 11:33:25 AM7/10/23

to OpenPnP

I tried re-importing, still no luck getting anything into the Comment column. Here's the log:

2023-07-10 08:26:23.488 Main INFO: Bienvenue, Bienvenido, Willkommen, Hello, Namaskar, Welkom, Bonjour to OpenPnP version 2023-07-06_21-53-39.95fc334.
2023-07-10 08:26:23.489 Scripting TRACE: Scripting.on Startup
2023-07-10 08:26:24.530 AbstractBroadcastingCamera TRACE: Camera Top thread 66 started.
2023-07-10 08:26:25.975 AbstractBroadcastingCamera TRACE: Camera UpCam thread 68 started.
2023-07-10 08:26:32.980 Configuration TRACE: Dump of the jobRootPanelLocation
2023-07-10 08:26:32.980 PanelLocation TRACE: (null) PanelLocation:@5c2a8732 defined by @5c2a8732 child of @00000000, null, location=(0.000000, 0.000000, 0.000000, 0.000000 mm) , globalLocation=(0.000000, 0.000000, 0.000000, 0.000000 mm) side=Top (Panel @68157a58 defined by @68157a58: file C:\Users\jim\Documents\OpenPnP\Jobs\EG-2\EG-2-Top-PCB-Top.job.xml, dims: 0.000mmx0.000mm, fiducial count: 0, children: 1)
2023-07-10 08:26:32.981 BoardLocation TRACE: +-- (Eg-2-Top) BoardLocation:@1ae2116c defined by @1ae2116c child of @5c2a8732, C:\Users\jim\Documents\OpenPnP\Jobs\EG-2\EG-2-Top-PCB.board.xml, location=(61.165000, 156.766000, 0.000000, 0.000000 mm) globalLocation=(61.165000, 156.766000, 0.000000, 0.000000 mm), side=Bottom (Board @4365d139 defined by @6a5df7a7: file C:\Users\jim\Documents\OpenPnP\Jobs\EG-2\EG-2-Top-PCB.board.xml, dims: 28.000mmx109.000mm, placements: 23 @20f6d2f2 (@aac0abdf))
2023-07-10 08:28:43.785 PanelLocation TRACE: (null) PanelLocation:@5c2a8732 defined by @5c2a8732 child of @00000000, null, location=(0.000000, 0.000000, 0.000000, 0.000000 mm) , globalLocation=(0.000000, 0.000000, 0.000000, 0.000000 mm) side=Top (Panel @68157a58 defined by @68157a58: file C:\Users\jim\Documents\OpenPnP\Jobs\EG-2\EG-2-Top-PCB-Top.job.xml, dims: 0.000mmx0.000mm, fiducial count: 0, children: 0)
2023-07-10 08:30:27.390 CsvImporter$Dlg$SwingAction_2 DEBUG: Parsing \\uhs\InfiniteMachinery\Product\IM EG-2\PnP\EG-2-Top-PCB-PnP.csv CSV FIle
2023-07-10 08:30:27.391 CsvImporter TRACE: checkLine: RefDes,Pattern,X,Y,Side,Rotation,Comp_Value
2023-07-10 08:30:27.404 CsvImporter TRACE: checkCSV: REFDES = 0
2023-07-10 08:30:27.404 CsvImporter TRACE: checkCSV: COMP_VALUE = 6
2023-07-10 08:30:27.405 CsvImporter TRACE: checkCSV: PATTERN = 1
2023-07-10 08:30:27.405 CsvImporter TRACE: checkCSV: X = 2
2023-07-10 08:30:27.405 CsvImporter TRACE: checkCSV: Y = 3
2023-07-10 08:30:27.405 CsvImporter TRACE: checkCSV: ROTATION = 5
2023-07-10 08:30:27.405 CsvImporter TRACE: checkCSV: SIDE = 4
2023-07-10 08:30:27.405 CsvImporter TRACE: checkCSV: Len = 6
2023-07-10 08:30:27.414 PanelLocation TRACE: (null) PanelLocation:@5c2a8732 defined by @5c2a8732 child of @00000000, null, location=(0.000000, 0.000000, 0.000000, 0.000000 mm) , globalLocation=(0.000000, 0.000000, 0.000000, 0.000000 mm) side=Top (Panel @68157a58 defined by @68157a58: file C:\Users\jim\Documents\OpenPnP\Jobs\EG-2\EG-2-Top-PCB-Top.job.xml, dims: 0.000mmx0.000mm, fiducial count: 0, children: 0)

If Value is a required data element, why is there no Value column in the UI?

tonyl...@gmail.com

unread,

Jul 10, 2023, 11:47:21 AM7/10/23

to OpenPnP

I just tried it and it worked for me. Do you have the Create Missing Parts checkbox checked when you do the import? If not, and the part doesn't already exist in OpenPnP, no part will be assigned to the placement. The part Id that gets created is a combination of the package (Pattern in your csv) and the value (Comp_Value in your csv).

Tony

Message has been deleted

Jim Young

unread,

Jul 10, 2023, 5:25:32 PM7/10/23

to OpenPnP

Okay, this issue is basically resolved. And, as usual for me, it's self induced.

A while back I was setting up a new board using a placement file that was exported from Eagle using PCB project that was exported from Diptrace (long story and I don't want to go down that rabbit hole). Anyway, when Diptrace exported the board file into the Eagle format, it decorated the part names with the footprint name. When I imported that placement file into OpenPnP and enabled part creation I ended up with this horrendous list of parts with mangled names with the footprint specified twice. So, this time around I was reluctant to enable part creation. Now I realized I really don't have a choice. Now I understand that there's a part naming convention in OpenPnP that one has no choice but to use as-is. That's okay, as long as I export my placements with reasonable and proper values.

Jan

unread,

Jul 10, 2023, 5:50:01 PM7/10/23

to ope...@googlegroups.com

Hi Jim!
I've check the code of the importer again and found possible unintended
behaviour: if the "Create Missing Parts" checkbox is not checked, no
part is ever assigned to the placement. This leeds to placements with
empty Part columns regardelss wether the part exists or not. I checked
back that this behaviour is in place since the beginning.
Now the master question: is this intended behaviour or a bug?
As the value of the Part column references the ID of the Parts tab,
it's likely not possible to have a "Part" on the board, not none in the
Parts tab. If I change the behaviour, parts that exist get correctly
assigned, parts that do not yet exist, stay empty...
So, Jim, the quick fix is Tonys suggestions, check "Create Missing Parts".
Concerning the comment question: the header elements are parsed and the
result is later used to extract the content and assign it to the
placement. According to your log, I'd say that you .csv does not contain
a comment column. If you still can't get the importer to import
comments, please provide me with the .csv file and I'll debug and fix it.

Jan

> <https://github.com/openpnp/openpnp/wiki/Importing-Centroid-Data>). I

> https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com> <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com?utm_medium=email&utm_source=footer>>.

>
> --
> You received this message because you are subscribed to the Google
> Groups "OpenPnP" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to openpnp+u...@googlegroups.com
> <mailto:openpnp+u...@googlegroups.com>.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com?utm_medium=email&utm_source=footer>.

tonyl...@gmail.com

unread,

Jul 10, 2023, 6:13:05 PM7/10/23

to OpenPnP

> if the "Create Missing Parts" checkbox is not checked, no
part is ever assigned to the placement. This leeds to placements with
empty Part columns regardelss wether the part exists or not.

I guess I've only ever used it with the "Create Missing Parts" checkbox checked (actually I've never used the csv importer - only the KiCad and Eagle importers but I assume they work the same). It does seem like if it's not checked and a part already exists, it should assign the existing part to the placement rather than leaving it unassigned. So, if the checkbox is checked, and the part already exists, does it create a new part with the same Id as the existing part or does it just assign the existing part to the placement?

Tony

Jan

unread,

Jul 10, 2023, 6:27:02 PM7/10/23

to ope...@googlegroups.com

Hi Tony!
The ReferenceCSVImporter and the AltiumCSVImport now share the same
parser. IIRC all other importers are completely unrelated. However, I've
separated the parser from its configuration data so its very easy now to
build new CSV imports for other formats.
The code skips all part assignments at present if "Check Missing Parts"
is unchecked. If its checked, it first searches for an existing part and
uses that. If no part is found, it creates and uses it. One could move
the reference to "Check Missing Parts" into the /if part does not exist/
path, however placements with no parts, still have an empty Part column
which makes them pretty useless...

Jan

> https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com> <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com>> <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com?utm_medium=email&utm_source=footer> <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/c6d702e3-a367-496f-82c4-b508ac6bf7f4n%40googlegroups.com?utm_medium=email&utm_source=footer>>>.

> >
> > --
> > You received this message because you are subscribed to the Google
> > Groups "OpenPnP" group.
> > To unsubscribe from this group and stop receiving emails from it,
> send
> > an email to openpnp+u...@googlegroups.com
> > <mailto:openpnp+u...@googlegroups.com>.
> > To view this discussion on the web visit
> >

> https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com> <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com?utm_medium=email&utm_source=footer>>.

>
> --
> You received this message because you are subscribed to the Google
> Groups "OpenPnP" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to openpnp+u...@googlegroups.com
> <mailto:openpnp+u...@googlegroups.com>.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com?utm_medium=email&utm_source=footer>.

Jim Young

unread,

Jul 10, 2023, 10:20:59 PM7/10/23

to OpenPnP

Jan, that would be great if the importer was fixed to assign parts that it could match from the current parts lists, regardless of the state of the "Create missing parts" checkbox.

I tried adding another column to the data for comments and I got this error. It appears that the ReferenceCSV import only allows a max of 7 columns?

2023-07-10 08:58:36.184 CsvImporter$Dlg$SwingAction_2 DEBUG: Parsing \\uhs\InfiniteMachinery\Product\IM EG-2\PnP\EG-2-Top-PCB-PnP.csv CSV FIle
2023-07-10 08:58:36.185 CsvImporter TRACE: checkLine: RefDes,Pattern,X,Y,Side,Rotation,Comp_Value,ADDCOMMENT
2023-07-10 08:58:36.186 CsvImporter TRACE: checkCSV: REFDES = 0
2023-07-10 08:58:36.186 CsvImporter TRACE: checkCSV: COMP_VALUE = 6
2023-07-10 08:58:36.186 CsvImporter TRACE: checkCSV: PATTERN = 1
2023-07-10 08:58:36.186 CsvImporter TRACE: checkCSV: X = 2
2023-07-10 08:58:36.186 CsvImporter TRACE: checkCSV: Y = 3
2023-07-10 08:58:36.187 CsvImporter TRACE: checkCSV: ROTATION = 5
2023-07-10 08:58:36.187 CsvImporter TRACE: checkCSV: SIDE = 4
2023-07-10 08:58:36.187 CsvImporter TRACE: checkCSV: ADDCOMMENT = 7
2023-07-10 08:58:36.187 CsvImporter TRACE: checkCSV: Len = 6
2023-07-10 08:58:36.191 MessageBoxes DEBUG: Import Error: java.lang.ArrayIndexOutOfBoundsException: Index 7 out of bounds for length 7
2023-07-10 08:58:45.157 PanelLocation TRACE:  (null) PanelLocation:@5c2a8732 defined by @5c2a8732 child of @00000000, null, location=(0.000000, 0.000000, 0.000000, 0.000000 mm) , globalLocation=(0.000000, 0.000000, 0.000000, 0.000000 mm) side=Top (Panel @68157a58 defined by @68157a58: file C:\Users\jim\Documents\OpenPnP\Jobs\EG-2\EG-2-Top-PCB-Top.job.xml, dims: 0.000mmx0.000mm, fiducial count: 0, children: 0)
2023-07-10 13:03:01.619 CsvImporter$Dlg$SwingAction_2 DEBUG: Parsing \\uhs\InfiniteMachinery\Product\IM EG-2\PnP\EG-2-Top-PCB-PnP.csv CSV FIle

Jan

unread,

Jul 11, 2023, 3:37:55 AM7/11/23

to ope...@googlegroups.com

Hi Jim!
Many thanks! I can now see, that the line length is correctly
calculated if a comment is found. I'll fix that. As workaround you can
make the comment colume not the last. Then the import shall be find.
I'll also provide a fix for the Create Missing Part unchecked problem.
IMHO it might be the best to skip placements without parts then.
I'll also add an improvement to make placments starting with "FID"
followed by a digit a Fiducial type.

Jan

> > >
> > > --
> > > You received this message because you are subscribed to the Google
> > > Groups "OpenPnP" group.
> > > To unsubscribe from this group and stop receiving emails from it,
> > send
> > > an email to openpnp+u...@googlegroups.com
> > > <mailto:openpnp+u...@googlegroups.com>.
> > > To view this discussion on the web visit
> > >
> >

> https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com> <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com>> <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com?utm_medium=email&utm_source=footer> <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/5fbe5d88-bd23-4d71-b541-a4f5af1cdab1n%40googlegroups.com?utm_medium=email&utm_source=footer>>>.

> >
> > --
> > You received this message because you are subscribed to the Google
> > Groups "OpenPnP" group.
> > To unsubscribe from this group and stop receiving emails from it,
> send
> > an email to openpnp+u...@googlegroups.com
> > <mailto:openpnp+u...@googlegroups.com>.
> > To view this discussion on the web visit
> >

> https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com> <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com?utm_medium=email&utm_source=footer>>.

>
> --
> You received this message because you are subscribed to the Google
> Groups "OpenPnP" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to openpnp+u...@googlegroups.com
> <mailto:openpnp+u...@googlegroups.com>.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com?utm_medium=email&utm_source=footer>.

Jan

unread,

Jul 11, 2023, 4:03:13 AM7/11/23

to ope...@googlegroups.com

I've now submitted PR #1572 (https://github.com/openpnp/openpnp/pull/1572)

Jan

Jan

unread,

Jul 12, 2023, 6:21:58 AM7/12/23

to ope...@googlegroups.com

Hi Jim!
The PR has been merged. Would you please test and report if it solves
the issues you had? Thank You!

Jan

Wayne Black

unread,

Jul 12, 2023, 11:13:23 AM7/12/23

to ope...@googlegroups.com

Hey Jan,

Ive had troubles with the general csv parser when using Easyeda. The Easyeda csv file is UTF-16 LE encoding and chokes the openpnp parser. The work around is to resave the file to ANSI or UTF-8.

To unsubscribe from this group and stop receiving emails from it, send an email to openpnp+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openpnp/2e991d4d-ef9d-8ab0-5bd8-0d55f2d1efa4%40googlemail.com.

--

Wayne Black

Owner

Black Box Embedded, LLC

black...@blackboxembedded.com

1.831.682.4964

Jan

unread,

Jul 12, 2023, 3:53:22 PM7/12/23

to ope...@googlegroups.com

Hi Wayne!
You may wont to send me a sample so that I can have a look...

Jan

On 12.07.2023 17:13, Wayne Black wrote:
> Hey Jan,
> Ive had troubles with the general csv parser when using Easyeda. The
> Easyeda csv file is UTF-16 LE encoding and chokes the openpnp parser.
> The work around is to resave the file to ANSI or UTF-8.
>
> On Wed, Jul 12, 2023 at 3:21 AM 'Jan' via OpenPnP
> <ope...@googlegroups.com <mailto:ope...@googlegroups.com>> wrote:
>
> Hi Jim!
> The PR has been merged. Would you please test and report if
> it solves
> the issues you had? Thank You!
>
> Jan
>
> On 11.07.2023 10:03, 'Jan' via OpenPnP wrote:
> > I've now submitted PR #1572
> (https://github.com/openpnp/openpnp/pull/1572

> <https://github.com/openpnp/openpnp/pull/1572>)

> >>> tonyl...@gmail.com <mailto:tonyl...@gmail.com>

> >>> infinite...@gmail.com <mailto:infinite...@gmail.com>

> <mailto:openpnp%2Bu...@googlegroups.com>
> >>> > > > <mailto:openpnp+u...@googlegroups.com
> <mailto:openpnp%2Bu...@googlegroups.com>>.

> >>>      > > > To view this discussion on the web visit
> >>>      > > >
> >>>      > >
> >>>      >
> >>>

> >>>      > >
> >>>      > > --
> >>>      > > You received this message because you are subscribed
> to the
> >>> Google
> >>>      > > Groups "OpenPnP" group.
> >>>      > > To unsubscribe from this group and stop receiving emails
> >>> from it,
> >>>      > send
> >>>      > > an email to openpnp+u...@googlegroups.com

> <mailto:openpnp%2Bu...@googlegroups.com>
> >>> > > <mailto:openpnp+u...@googlegroups.com
> <mailto:openpnp%2Bu...@googlegroups.com>>.

> >>>      > > To view this discussion on the web visit
> >>>      > >
> >>>      >
> >>>

> >>>      >
> >>>      > --
> >>>      > You received this message because you are subscribed to the
> >>> Google
> >>>      > Groups "OpenPnP" group.
> >>>      > To unsubscribe from this group and stop receiving emails
> from it,
> >>>     send
> >>>      > an email to openpnp+u...@googlegroups.com

> <mailto:openpnp%2Bu...@googlegroups.com>
> >>> > <mailto:openpnp+u...@googlegroups.com
> <mailto:openpnp%2Bu...@googlegroups.com>>.

> >>> > To view this discussion on the web visit
> >>> >
> >>>

> https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com> <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com>> <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com?utm_medium=email&utm_source=footer> <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/d9b907b3-a67c-44ac-b315-9ba647a5b127n%40googlegroups.com?utm_medium=email&utm_source=footer>>>.

> >>>
> >>> --
> >>> You received this message because you are subscribed to the Google
> >>> Groups "OpenPnP" group.
> >>> To unsubscribe from this group and stop receiving emails from it,
> >>> send an email to openpnp+u...@googlegroups.com

> <mailto:openpnp%2Bunsu...@googlegroups.com>
> >>> <mailto:openpnp+u...@googlegroups.com
> <mailto:openpnp%2Bunsu...@googlegroups.com>>.

> >>> To view this discussion on the web visit
> >>>

> https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com> <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com?utm_medium=email&utm_source=footer>>.

> >>
> >
>
> --
> You received this message because you are subscribed to the Google
> Groups "OpenPnP" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to openpnp+u...@googlegroups.com

> <mailto:openpnp%2Bunsu...@googlegroups.com>.

> To view this discussion on the web visit

> https://groups.google.com/d/msgid/openpnp/2e991d4d-ef9d-8ab0-5bd8-0d55f2d1efa4%40googlemail.com <https://groups.google.com/d/msgid/openpnp/2e991d4d-ef9d-8ab0-5bd8-0d55f2d1efa4%40googlemail.com>.

>
>
>
> --
> Wayne Black
> Owner
> Black Box Embedded, LLC

> black...@blackboxembedded.com <mailto:black...@blackboxembedded.com>
> 1.831.682.4964

>
> --
> You received this message because you are subscribed to the Google
> Groups "OpenPnP" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to openpnp+u...@googlegroups.com
> <mailto:openpnp+u...@googlegroups.com>.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/openpnp/CABUTZN_keCuh78rbgtmUk0%3DxncWm9eXPrimRYeEbgscNyyPshA%40mail.gmail.com <https://groups.google.com/d/msgid/openpnp/CABUTZN_keCuh78rbgtmUk0%3DxncWm9eXPrimRYeEbgscNyyPshA%40mail.gmail.com?utm_medium=email&utm_source=footer>.

Wayne Black

unread,

Jul 12, 2023, 10:35:39 PM7/12/23

to OpenPnP

Hey Jan

For starters im using openpnp V2023-06-04_21-02-22.6875194 and Easyeda std edition V6.5.29

My workflow;

-export pnp file .csv format

-reset the delimiters from [Tab] to [,]

-save .csv as ANSI/UTF-8 (changed from UTF-16 LF)

-import the new .csv into google sheets to tie into my BOM

-import the placements into Openpnp

Openpnp seems quite able to parse the .csv with either [tab] or [,] delimiters, but cannot parse the native UTF-16 LF encoding. Ive attached the sample pnp files

Easyeda_pnp parse test_encoder_only_edited.csv

Easyeda_pnp parse test_delim_encoder_edited.csv

Easyeda_pnp parse test_delim_only_edited.csv

Easyeda_pnp parse test_raw _export.csv

Jan

unread,

Jul 13, 2023, 4:58:42 AM7/13/23

to ope...@googlegroups.com

Hi Wayne!
Many thanks for the .csv files. I've just created PR #1573
(https://github.com/openpnp/openpnp/pull/1573) which adds native support
for UTF-16 encoded .csv files.
The required modifications are rather simple because a) your .csv-files
contain a Byte Order Mark
(https://en.wikipedia.org/wiki/Byte_order_mark) that allows to safely
detect the character set requried to read it and d) the Java
InputStreamReader() used to read the files can handle different
character sets.

Jan

On 13.07.2023 04:35, Wayne Black wrote:
> Hey Jan
> For starters im using openpnp V2023-06-04_21-02-22.6875194 and Easyeda
> std edition V6.5.29
>
> My workflow;
> -export pnp file .csv format
> -reset the delimiters from [Tab] to [,]
> -save .csv as ANSI/UTF-8 (changed from UTF-16 LF)
> -import the new .csv into google sheets to tie into my BOM
> -import the placements into Openpnp
>
> Openpnp seems quite able to parse the .csv with either [tab] or [,]
> delimiters, but cannot parse the native UTF-16 LF encoding. Ive attached
> the sample pnp files

> > >>>      > >
> > >>>      > > --
> > >>>      > > You received this message because you are subscribed
> > to the
> > >>> Google
> > >>>      > > Groups "OpenPnP" group.
> > >>>      > > To unsubscribe from this group and stop receiving
> emails
> > >>> from it,
> > >>>      > send
> > >>>      > > an email to openpnp+u...@googlegroups.com
> > <mailto:openpnp%2Bu...@googlegroups.com>
> > >>>      > > <mailto:openpnp+u...@googlegroups.com
> > <mailto:openpnp%2Bu...@googlegroups.com>>.
> > >>>      > > To view this discussion on the web visit
> > >>>      > >
> > >>>      >
> > >>>
> >

> > >>>      >
> > >>>      > --
> > >>>      > You received this message because you are subscribed
> to the
> > >>> Google
> > >>>      > Groups "OpenPnP" group.
> > >>>      > To unsubscribe from this group and stop receiving emails
> > from it,
> > >>>     send
> > >>>      > an email to openpnp+u...@googlegroups.com
> > <mailto:openpnp%2Bu...@googlegroups.com>
> > >>>      > <mailto:openpnp+u...@googlegroups.com
> > <mailto:openpnp%2Bu...@googlegroups.com>>.
> > >>>      > To view this discussion on the web visit
> > >>>      >
> > >>>
> >

> > >>>
> > >>> --
> > >>> You received this message because you are subscribed to the
> Google
> > >>> Groups "OpenPnP" group.
> > >>> To unsubscribe from this group and stop receiving emails from
> it,
> > >>> send an email to openpnp+u...@googlegroups.com
> > <mailto:openpnp%2Bunsu...@googlegroups.com>
> > >>> <mailto:openpnp+u...@googlegroups.com
> > <mailto:openpnp%2Bunsu...@googlegroups.com>>.
> > >>> To view this discussion on the web visit
> > >>>
> >

> https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com> <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com>> <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com?utm_medium=email&utm_source=footer> <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/13ed09f8-876a-4adb-97ef-6f27d0db881an%40googlegroups.com?utm_medium=email&utm_source=footer>>>.

> > >>
> > >
> >
> > --
> > You received this message because you are subscribed to the Google
> > Groups "OpenPnP" group.
> > To unsubscribe from this group and stop receiving emails from it,
> > send an email to openpnp+u...@googlegroups.com
> > <mailto:openpnp%2Bunsu...@googlegroups.com>.
> > To view this discussion on the web visit
> >

> https://groups.google.com/d/msgid/openpnp/2e991d4d-ef9d-8ab0-5bd8-0d55f2d1efa4%40googlemail.com <https://groups.google.com/d/msgid/openpnp/2e991d4d-ef9d-8ab0-5bd8-0d55f2d1efa4%40googlemail.com> <https://groups.google.com/d/msgid/openpnp/2e991d4d-ef9d-8ab0-5bd8-0d55f2d1efa4%40googlemail.com <https://groups.google.com/d/msgid/openpnp/2e991d4d-ef9d-8ab0-5bd8-0d55f2d1efa4%40googlemail.com>>.

> >
> >
> >
> > --
> > Wayne Black
> > Owner
> > Black Box Embedded, LLC
> > black...@blackboxembedded.com <mailto:black...@blackboxembedded.com>

> > 1.831.682.4964 <tel:(831)%20682-4964>

> >
> > --
> > You received this message because you are subscribed to the Google
> > Groups "OpenPnP" group.
> > To unsubscribe from this group and stop receiving emails from it,
> send
> > an email to openpnp+u...@googlegroups.com
> > <mailto:openpnp+u...@googlegroups.com>.
> > To view this discussion on the web visit
> >

> https://groups.google.com/d/msgid/openpnp/CABUTZN_keCuh78rbgtmUk0%3DxncWm9eXPrimRYeEbgscNyyPshA%40mail.gmail.com <https://groups.google.com/d/msgid/openpnp/CABUTZN_keCuh78rbgtmUk0%3DxncWm9eXPrimRYeEbgscNyyPshA%40mail.gmail.com> <https://groups.google.com/d/msgid/openpnp/CABUTZN_keCuh78rbgtmUk0%3DxncWm9eXPrimRYeEbgscNyyPshA%40mail.gmail.com?utm_medium=email&utm_source=footer <https://groups.google.com/d/msgid/openpnp/CABUTZN_keCuh78rbgtmUk0%3DxncWm9eXPrimRYeEbgscNyyPshA%40mail.gmail.com?utm_medium=email&utm_source=footer>>.

>
> --
> You received this message because you are subscribed to the Google
> Groups "OpenPnP" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to openpnp+u...@googlegroups.com

> <mailto:openpnp+u...@googlegroups.com>.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/openpnp/03bbb96b-9ca2-433a-9c4c-9017460d01c8n%40googlegroups.com <https://groups.google.com/d/msgid/openpnp/03bbb96b-9ca2-433a-9c4c-9017460d01c8n%40googlegroups.com?utm_medium=email&utm_source=footer>.

Jan

unread,

Jul 13, 2023, 8:34:04 AM7/13/23

to ope...@googlegroups.com

FYI: the PR has been merged. Please give it a try and report. Thank You!

Wayne Black

unread,

Jul 13, 2023, 11:08:11 AM7/13/23

to ope...@googlegroups.com

Great thanks Jan!

Ill give it a try tonight and let you know how it works. This will be really helpful because there are no user modifiable settings for the .csv exporter in Easyeda standard.

To unsubscribe from this group and stop receiving emails from it, send an email to openpnp+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openpnp/e7c4105b-3a46-458e-39f4-f4b382a295e4%40googlemail.com.

--

Wayne Black

Owner

Black Box Embedded, LLC

black...@blackboxembedded.com

1.831.682.4964

Wayne Black

unread,

Jul 13, 2023, 8:22:47 PM7/13/23

to ope...@googlegroups.com

Works great, thanks Jan

Reply all

Reply to author

Forward