KiCad

  1. Bug #1464805
  2. Comment #3

Comment 3 for bug 1464805

Revision history for this message
Aleksandr Sh (dsa-t) wrote : Re: BOM does not sorting correctly

Here is what I found (I have custom field "Link" on some components):
bom_csv_sorted_by_ref.py sorts properly but does not output custom fields.

bom_csv_grouped_by_value.py sorts properly and outputs custom fields, but does not group.
Example output:
"Item","Qty","Reference(s)","Value","LibPart","Footprint","Datasheet","Link"
"","","C1","10V 100uF","Device:CP","Capacitor_THT:CP_Radial_D8.0mm_P3.50mm","",""
"","","C2","100nF","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C3","100nF","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C4","100nF","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C5","100nF","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C6","100nF","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C7","100nF","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C8","100nF","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C9","15pF","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C10","15pF","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C11","10uF 25V","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C12","10uF 25V","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C13","10uF 25V","Device:C","Capacitor_SMD:C_0603_1608Metric","",""
"","","C14","10uF 25V","Device:C","Capacitor_SMD:C_0603_1608Metric","",""

bom_csv_grouped_by_value_with_fp.py groups but does not sort and does not output custom fields. (And creates unneccessary trailing ", ")
Example output:
"Ref","Qnty","Value","Cmp name","Footprint","Description","Vendor"
"C1, ","1","10V 100uF","CP","Capacitor_THT:CP_Radial_D8.0mm_P3.50mm","Polarised capacitor",""
"C3, C7, C8, C6, C5, C4, C2, ","7","100nF","C","Capacitor_SMD:C_0603_1608Metric","Unpolarized capacitor",""
"C10, C9, ","2","15pF","C","Capacitor_SMD:C_0603_1608Metric","Unpolarized capacitor",""
"C11, C12, C13, C14, ","4","10uF 25V","C","Capacitor_SMD:C_0603_1608Metric","Unpolarized capacitor",""
"C15, C24, ","2","100uF","CP","Capacitor_THT:CP_Radial_D8.0mm_P3.50mm","Polarised capacitor",""
"C19, C18, ","2","0.1uF","C","Capacitor_SMD:C_0603_1608Metric","Unpolarized capacitor",""
"C21, C20, ","2","10uF 10V","C","Capacitor_SMD:C_0603_1608Metric","Unpolarized capacitor",""
"C22, ","1","33pF","C","Capacitor_SMD:C_0603_1608Metric","Unpolarized capacitor",""
"C23, ","1","1.8nF","C","Capacitor_SMD:C_0603_1608Metric","Unpolarized capacitor",""
"C25, C26, C16, C17, ","4","22uF","C","Capacitor_SMD:C_1206_3216Metric","Unpolarized capacitor",""

bom_html_grouped_by_value.py groups and sorts properly but does not output custom fields.
bom_html_with_advanced_grouping.py groups and sorts properly but does not output custom fields.
bom_sorted_by_ref.py sorts properly but does not output custom fields.
bom_with_title_block_2_csv.xsl does not sort and does not output custom fields.
bom2csv.xsl does not sort, but outputs custom fields

bom2grouped_csv.xsl outputs custom fields but sorts like this:
D1 D12 D13 D2 D23 D24 D34 D35 D45 D46 D47 D48 D49 D50 D62 D63 D64 D65 D66 D67 D79 D80 D81 D86 D87 D88
And the header format is incorrect:
Reference, Quantity, Value, Footprint, Datasheet, Link
(The leading whitespaces are unneccessary)