bom_html_grouped_by_value.py 2.51 KB
Newer Older
1 2 3 4 5 6 7
#
# Example python script to generate a BOM from a KiCad generic netlist
#
# Example: Sorted and Grouped HTML BOM
#

# Import the KiCad python helper module and the csv formatter
8
import ky_generic_netlist_reader
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
import sys

# Start with a basic html template
html = """
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    </head>
    <body>
    <h1><!--SOURCE--></h1>
    <p><!--DATE--></p>
    <p><!--TOOL--></p>
    <p><!--COMPCOUNT--></p>
    <table>
    <!--TABLEROW-->
    </table>
    </body>
</html>
    """
30

31 32
# Generate an instance of a generic netlist, and load the netlist tree from
# the command line option. If the file doesn't exist, execution will stop
33
net = ky_generic_netlist_reader.netlist(sys.argv[1])
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49

# Open a file to write to, if the file cannot be opened output to stdout
# instead
try:
    f = open(sys.argv[2], 'w')
except IOError:
    print >> sys.stderr, __file__, ":", e
    f = stdout

# Output a set of rows for a header providing general information
html = html.replace('<!--SOURCE-->', net.getSource())
html = html.replace('<!--DATE-->', net.getDate())
html = html.replace('<!--TOOL-->', net.getTool())
html = html.replace('<!--COMPCOUNT-->', "<b>Component Count:</b>" + \
    str(len(net.components)))

50
row = "<tr><th style='width:640px'>Ref</th>" + "<th>Qnty</th>"
51 52
row += "<th>Value</th>" + "<th>Part</th>" + "<th>Datasheet</th>"
row += "<th>Description</th>" + "<th>Vendor</th></tr>"
53

54 55
html = html.replace('<!--TABLEROW-->', row + "<!--TABLEROW-->")

56 57
# Get all of the components in groups of matching parts + values
# (see ky_generic_netlist_reader.py)
58 59 60 61 62 63
grouped = net.groupComponents()

# Output all of the component information
for group in grouped:
    refs = ""

64
    # Add the reference of every component in the group and keep a reference
65 66 67 68 69
    # to the component so that the other data can be filled in once per group
    for component in group:
        refs += component.getRef() + ", "
        c = component

70 71 72 73
    row = "<tr><td>" + refs +"</td><td>" + str(len(group))
    row += "</td><td>" + c.getValue() + "</td><td>" + c.getLib() + "/"
    row += c.getPart() + "</td><td>" + c.getDatasheet() + "</td><td>"
    row += c.getDescription() + "</td><td>" + c.getField("Vendor")
74
    row += "</td></tr>"
75

76 77 78 79
    html = html.replace('<!--TABLEROW-->', row + "<!--TABLEROW-->")

# Print the formatted html to the file
print >> f, html