brickopore python script

XML_TEMPLATE = '''
    <ITEM>
        <ITEMTYPE>P</ITEMTYPE>
        <ITEMID>{ITEMID}</ITEMID>
        <COLOR>{COLOR}</COLOR>
        <MINQTY>{MINQTY}</MINQTY>
        <REMARKS>{REMARKS}</REMARKS>
        <NOTIFY>N</NOTIFY>
    </ITEM>
'''[1:]

XML = '<INVENTORY>\n'

with open('brickopore_mk2_parts.csv') as f:
    header = f.readline().rstrip().split('\t')

    for line in f:
        line = line.rstrip().split('\t')
        if len(line) != 10:
            break

        BLItemNo, ElementId, LdrawId, PartName, BLColorId, LDrawColorId, ColorName, ColorCategory, Qty, Weight = line
        XML += XML_TEMPLATE.format(
            ITEMID=BLItemNo,
            COLOR=BLColorId,
            MINQTY=Qty,
            REMARKS=f'{PartName} ({ColorName})',
        )

XML += '</INVENTORY>'

with open('bricklink.xml', 'w') as f:
    f.write(XML)