Cannot generate panel BOM and Pick-Place

[renno-bih]

Hi,
thanks for Youtube tutorial, it is very helpful. But I'm stuck on generating BOM and Pick and Place csv files for panel.
When executing command I get "Panel" directory but it is empty.

Pick and Place file:

"Designator","Footprint","Mid X","Mid Y","Ref X","Ref Y","Pad X","Pad Y","Layer","Rotation","Comment"
""
"C1","NA","25.10","20.30","0.00","0.00","0.00","0.00","Top","180.00","NA"
"C2","NA","7.60","20.10","0.00","0.00","0.00","0.00","Top","90.00","NA"
"C3","NA","14.20","18.00","0.00","0.00","0.00","0.00","Top","90.00","NA"
"C4","NA","16.30","21.10","0.00","0.00","0.00","0.00","Top","90.00","NA"
"C5","NA","14.20","21.10","0.00","0.00","0.00","0.00","Top","90.00","NA"
"C6","NA","33.43","9.37","0.00","0.00","0.00","0.00","Top","270.00","NA"
"C7","NA","33.44","12.49","0.00","0.00","0.00","0.00","Top","90.00","NA"
"C8","NA","21.00","18.40","0.00","0.00","0.00","0.00","Top","0.00","NA"
"C9","NA","17.00","7.80","0.00","0.00","0.00","0.00","Top","90.00","NA"
"C10","NA","26.02","5.04","0.00","0.00","0.00","0.00","Top","180.00","NA"
"C11","NA","29.86","6.54","0.00","0.00","0.00","0.00","Top","270.00","NA"
"C12","NA","14.95","7.80","0.00","0.00","0.00","0.00","Top","90.00","NA"
"C13","NA","30.30","13.60","0.00","0.00","0.00","0.00","Top","270.00","NA"
"IC1","NA","10.90","19.60","0.00","0.00","0.00","0.00","Top","0.00","NA"
"POWER","NA","51.13","11.02","0.00","0.00","0.00","0.00","Top","90.00","NA"
"R1","NA","21.01","20.88","0.00","0.00","0.00","0.00","Top","180.00","NA"
"R2","NA","25.69","1.78","0.00","0.00","0.00","0.00","Top","180.00","NA"
"R3","NA","25.10","22.40","0.00","0.00","0.00","0.00","Top","180.00","NA"
"R4","NA","14.24","13.11","0.00","0.00","0.00","0.00","Top","270.00","NA"
"R5","NA","54.92","11.16","0.00","0.00","0.00","0.00","Top","0.00","NA"
"RN1","NA","49.80","15.50","0.00","0.00","0.00","0.00","Top","0.00","NA"
"RN2","NA","45.30","15.50","0.00","0.00","0.00","0.00","Top","0.00","NA"
"U$5","NA","36.80","11.20","0.00","0.00","0.00","0.00","Top","270.00","NA"
"U1","NA","23.50","11.70","0.00","0.00","0.00","0.00","Top","180.00","NA"

BOM file:

Comment,Designator,Footprint,LCSC Part #
1.5K,R4,0603_R,C22843
100nF,"C1, C5, C8, C9, C10, C11, C13",0603_C,C14663
10K Array x4,"RN1, RN2",0603_x4_R,C29718
10K,"R1, R2, R3",0603_R,C25804
10uF,C12,0603_C,C19702
RED LED,POWER,0603_LED,C72044
1K,R5,0603_R,C21190
1uF,"C2, C4",0603_C,C15849
22nF,C3,0603_C,C21122
8pF,"C6, C7",0402_C,C26408
RT9193-33GB,IC1,SOT-23-5,C15651
STM32F103C8T6,U1,LQFP-48_7x7x05P,C8734
XVBCCLNANF-8M,U$5,SMD-5032_4P,C117890

Panel info file:

DesignatorBase,Offset X,Offset Y
100, 0, 9
200, 74, 9
300, 148, 9
400, 0, 38.7
500, 74, 38.7
600, 148, 38.7
700, 0, 68.4
800, 74, 68.4
900, 148, 68.4
1000, 0, 98.1
1100, 74, 98.1
1200, 148, 98.1

I tried to use samples to generate these files and it is working properly. I really don't know what I missed in my files and it will be great if you can notice issue. I'm using metric system any maybe this is issue?

[renno-bih]

I managed to fix this issue.
There were two Designator names that were causing issue. First is POWER. It doesn't contain number at the end.
Second designator that was causing problem is U$5. Looks like "$" character is confusing this script.

After renaming "POWER" to "LED1" and "U$5" to "U5" everything is working perfectly.
I hope this can help other people with similar problem.

[kawalkQCWski]

If I use the batch file from latest version i get error
Error: Unable to access jarfile E:\GEBER\Bomtool\bom-panelizer.jar -b BOM1.csv -c CPL5.csv -o results -p panel.csv
But if I remove the first quote all works expect the pick and place panel is not generated correctly. Bom is fine
Pick and place gets a bunch of quotes :
ÿþ"" D e s i g n a t o r """,""" F o o t p r i n t """,""" M i d X """,""" M i d Y """,""" R e f X """,""" R e f Y """,""" P a d X """,""" P a d Y """,""" L a y e r """,""" R o t a t i o n """,""" C o m m e n t """
" "" P 1 "" "," "" H D R - T H _ 1 P - P 2 . 5 4 - V - M "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" T "" "," "" 0 "" "," "" G N D "" "
" "" P 1 "" "," "" H D R - T H _ 1 P - P 2 . 5 4 - V - M "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" T "" "," "" 0 "" "," "" G N D "" "
" "" P 1 "" "," "" H D R - T H _ 1 P - P 2 . 5 4 - V - M "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" T "" "," "" 0 "" "," "" G N D "" "
" "" P 1 "" "," "" H D R - T H _ 1 P - P 2 . 5 4 - V - M "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" T "" "," "" 0 "" "," "" G N D "" "
" "" P 1 "" "," "" H D R - T H _ 1 P - P 2 . 5 4 - V - M "" "," "" 6 0 m i l "" "," "" 2 1 5 m i l "" "," "" 6 0 m i l

My Bom after generator is perfect

Comment,Designator,Footprint,LCSC Part #
3.3K,"R1006, R1003, R1004, R1005, R2006, R2003, R2004, R2005, R3006, R3003, R3004, R3005, R4006, R4003, R4004, R4005, R5006, R5003, R5004, R5005, R6006, R6003, R6004, R6005, R7006, R7003, R7004, R7005, R8006, R8003, R8004, R8005, R9006, R9003, R9004, R9005, R10006, R10003, R10004, R10005, R11006, R11003, R11004, R11005, R12006, R12003, R12004, R12005, R13006, R13003, R13004, R13005, R14006, R14003, R14004, R14005, R15006, R15003, R15004, R15005, R16006, R16003, R16004, R16005, R17006, R17003, R17004, R17005, R18006, R18003, R18004, R18005, R19006, R19003, R19004, R19005, R20006, R20003, R20004, R20005",0402',C137874
MAX14757,"U1001, U2001, U3001, U4001, U5001, U6001, U7001, U8001, U9001, U10001, U11001, U12001, U13001, U14001, U15001, U16001, U17001, U18001, U19001, U20001",TSSOP-16,MAX14757EUE+
680,"R1002, R2002, R3002, R4002, R5002, R6002, R7002, R8002, R9002, R10002, R11002, R12002, R13002, R14002, R15002, R16002, R17002, R18002, R19002, R20002",1206,C137124
GND,"P1001, P2001, P3001, P4001, P5001, P6001, P7001, P8001, P9001, P10001, P11001, P12001, P13001, P14001, P15001, P16001, P17001, P18001, P19001, P20001",HDR-TH_1P-P2.54-V-M,C81276
BZT52C3V9,"D1005, D2005, D3005, D4005, D5005, D6005, D7005, D8005, D9005, D10005, D11005, D12005, D13005, D14005, D15005, D16005, D17005, D18005, D19005, D20005",SOD-123FL_L2.7-W1.8-LS3.8-RD,C181195
10K,"R1013, R1012, R1011, R1010, R2013, R2012, R2011, R2010, R3013, R3012, R3011, R3010, R4013, R4012, R4011, R4010, R5013, R5012, R5011, R5010, R6013, R6012, R6011, R6010, R7013, R7012, R7011, R7010, R8013, R8012, R8011, R8010, R9013, R9012, R9011, R9010, R10013, R10012, R10011, R10010, R11013, R11012, R11011, R11010, R12013, R12012, R12011, R12010, R13013, R13012, R13011, R13010, R14013, R14012, R14011, R14010, R15013, R15012, R15011, R15010, R16013, R16012, R16011, R16010, R17013, R17012, R17011, R17010, R18013, R18012, R18011, R18010, R19013, R19012, R19011, R19010, R20013, R20012, R20011, R20010",0402',C60489
DIP14,"U1002, U2002, U3002, U4002, U5002, U6002, U7002, U8002, U9002, U10002, U11002, U12002, U13002, U14002, U15002, U16002, U17002, U18002, U19002, U20002",DIP-14_300MIL,C72114
2.2uF,"C1005, C1002, C1003, C2005, C2002, C2003, C3005, C3002, C3003, C4005, C4002, C4003, C5005, C5002, C5003, C6005, C6002, C6003, C7005, C7002, C7003, C8005, C8002, C8003, C9005, C9002, C9003, C10005, C10002, C10003, C11005, C11002, C11003, C12005, C12002, C12003, C13005, C13002, C13003, C14005, C14002, C14003, C15005, C15002, C15003, C16005, C16002, C16003, C17005, C17002, C17003, C18005, C18002, C18003, C19005, C19002, C19003, C20005, C20002, C20003",0402',C159814
47nF,"C1004, C1001, C1008, C2004, C2001, C2008, C3004, C3001, C3008, C4004, C4001, C4008, C5004, C5001, C5008, C6004, C6001, C6008, C7004, C7001, C7008, C8004, C8001, C8008, C9004, C9001, C9008, C10004, C10001, C10008, C11004, C11001, C11008, C12004, C12001, C12008, C13004, C13001, C13008, C14004, C14001, C14008, C15004, C15001, C15008, C16004, C16001, C16008, C17004, C17001, C17008, C18004, C18001, C18008, C19004, C19001, C19008, C20004, C20001, C20008",0402',C107020
1N4448WT,"D1009, D1002, D1003, D1004, D1006, D1007, D1008, D1001, D2009, D2002, D2003, D2004, D2006, D2007, D2008, D2001, D3009, D3002, D3003, D3004, D3006, D3007, D3008, D3001, D4009, D4002, D4003, D4004, D4006, D4007, D4008, D4001, D5009, D5002, D5003, D5004, D5006, D5007, D5008, D5001, D6009, D6002, D6003, D6004, D6006, D6007, D6008, D6001, D7009, D7002, D7003, D7004, D7006, D7007, D7008, D7001, D8009, D8002, D8003, D8004, D8006, D8007, D8008, D8001, D9009, D9002, D9003, D9004, D9006, D9007, D9008, D9001, D10009, D10002, D10003, D10004, D10006, D10007, D10008, D10001, D11009, D11002, D11003, D11004, D11006, D11007, D11008, D11001, D12009, D12002, D12003, D12004, D12006, D12007, D12008, D12001, D13009, D13002, D13003, D13004, D13006, D13007, D13008, D13001, D14009, D14002, D14003, D14004, D14006, D14007, D14008, D14001, D15009, D15002, D15003, D15004, D15006, D15007, D15008, D15001, D16009, D16002, D16003, D16004, D16006, D16007, D16008, D16001, D17009, D17002, D17003, D17004, D17006, D17007, D17008, D17001, D18009, D18002, D18003, D18004, D18006, D18007, D18008, D18001, D19009, D19002, D19003, D19004, D19006, D19007, D19008, D19001, D20009, D20002, D20003, D20004, D20006, D20007, D20008, D20001",SOD-523_L1.2-W0.8-LS1.6-RD,C61075