| 35 |
|
else: |
| 36 |
|
KPMGStatus = line.split(",")[2] |
| 37 |
|
MWEStatus = line.split(",")[3] |
| 38 |
< |
if KPMGStatus == '"Resolved"': |
| 39 |
< |
if MWEStatus == '"Resolved"': |
| 38 |
> |
if KPMGStatus in ['"Resolved"', '"Sent to MWE"','"Closed"','"Transmit to Counsel"'] : |
| 39 |
> |
if MWEStatus in ['"Resolved"','"Closed"']: |
| 40 |
|
closedList.append(line) |
| 41 |
|
else: |
| 42 |
|
openMWEList.append(line) |
| 74 |
|
outputFile.write("</table></center>\n") |
| 75 |
|
|
| 76 |
|
if __name__ == '__main__': |
| 77 |
< |
exportFile = "/Users/ninoborges/Dropbox/Misc/export_20140106_191259.csv" |
| 78 |
< |
htmlFile = "/Users/ninoborges/Documents/ITO_Report.html" |
| 77 |
> |
#exportFile = "/Users/ninoborges/Dropbox/Misc/export_20140106_191259.csv" |
| 78 |
> |
#htmlFile = "/Users/ninoborges/Documents/ITO_Report.html" |
| 79 |
> |
exportFile = "T:\honeywell\export_20140106_191259.csv" |
| 80 |
> |
htmlFile = "T:\honeywell\ITO_Report\ITO_Report.html" |
| 81 |
|
openMWEList,openKPMGList, closedList = SplitIntoPlates(exportFile) |
| 82 |
|
print "mwe list %s"%len(openMWEList) |
| 83 |
|
print "kpmg list %s"%len(openKPMGList) |