rowdata.append(bt.get('name'))
rowdata.append(bt.find('description').text)
rowdata.append(bt.find('volume').text)
rowdata.append(bt.find('frequency').text)
rowdata.append(bt.find('notes').text)
btSheet.track_column(0, 0)
mappingName = rowdata[0]
btSheet.track_column(0, 2)
btSheet.write_row(row + header_row, rowdata)
for it in bt.findall('it_transaction'):
rowdata = []
btSheet.print_mappings()
busMappingName = mappingName + '#0'
data = itSheet.write_mapping(busMappingName, btSheet)
rowdata.append(data)
rowdata.append(it.get('name'))
rowdata.append(it.find('description').text)
qty = 0
try:
qty = it.find('qty').text
rowdata.append(float(qty))
except:
rowdata.append('')
rowdata.append(1)
busMappingName = mappingName + '#2'
