BMS_MLVDS_register_map_to_token.py

Go to the documentation of this file.

# BMS_MLVDS_register_map_to_token.py
# First row of the csv file must be header!
import sys, getopt
import csv

def main(argv):
    csvFile = 'BMS_MLVDS_register_map_oct28.csv'
    xmlFile = 'BmsTokens.xml'
    try:
        opts, args = getopt.getopt(argv, "hi:o:",["input=", "output="])
    except getopt.GetoptError:
        print("BMS_MLVDS_register_map_to_token.py -i <inputfile> -o <outputfile>")
        sys.exit(2)
    for opt, arg in opts:
        if opt == '-h':
            print 'BMS_MLVDS_register_map_to_token.py -i <inputfile>'
            sys.exit()
        elif opt in ("-i", "--input"):
            csvFile = arg
        elif opt in ("-o", "--output"):
            xmlFile = arg

    print("Opening " + csvFile)
    data = csv.reader(open(csvFile))

    print("Writing to " + xmlFile)
    xmlData = open(xmlFile, 'w')

    xmlData.write('<?xml version="1.0" encoding="ISO-8859-1"?>' + "\n")
    xmlData.write('<TokenData>' + "\n")
    xmlData.write('    <Properties>' + "\n")
    xmlData.write('        <Node>BMS</Node>' + "\n")
    xmlData.write('        <Version>BatPack</Version>' + "\n")
    xmlData.write('    </Properties>' + "\n")
    xmlData.write('    <Tokens>' + "\n")
    rowNum = 0
    for row in data:
        if rowNum == 0:
            tags = row
            # replace spaces w/ underscores in tag names
            for i in range(len(tags)):
                tags[i] = tags[i].strip().replace(' ', '_')
            if("addr_(hex)" in tags):
                iHex = tags.index("addr_(hex)")
                print("index of hex value: " + str(iHex))
            else:
                break
            if("name" in tags):
                iName = tags.index("name")
                print("index of name: " + str(iName))
            else:
                break            
        else:
            if(row[iName].strip().replace(' ', '_')):
                xmlData.write('        <Token {0:50} {1:15} /> \n'.format('id="' + str(row[iName].strip().replace(' ', '_')) + '"', 'value="0x' + str(row[iHex]) + '"'))
        rowNum +=1
    xmlData.write('    </Tokens>' + "\n")
    xmlData.write('</TokenData>')

    xmlData.close()

if __name__ == "__main__":
   main(sys.argv[1:])