| 70 |
|
""") |
| 71 |
|
outputFile.close() |
| 72 |
|
|
| 73 |
+ |
def GetProjectList(mwePlate,kpmgPlate,closedPlate): |
| 74 |
+ |
"""Combines the plates (not lists) into the project list, so that you can populate the project view""" |
| 75 |
+ |
## cycle through the 2 open lists and only pull from the closed list, if the proj exists in the first two. |
| 76 |
+ |
## Everything should already be in a matrix by catagory. |
| 77 |
+ |
projectMatrix = {} |
| 78 |
+ |
for i in mwePlate.keys(): |
| 79 |
+ |
for p in mwePlate[i]: |
| 80 |
+ |
project = p[3] |
| 81 |
+ |
if project in projectMatrix.keys(): |
| 82 |
+ |
projectMatrix[project].append(p) |
| 83 |
+ |
else: |
| 84 |
+ |
projectMatrix[project] = [p] |
| 85 |
+ |
for i in kpmgPlate.keys(): |
| 86 |
+ |
for p in kpmgPlate[i]: |
| 87 |
+ |
project = p[3] |
| 88 |
+ |
if project in projectMatrix.keys(): |
| 89 |
+ |
projectMatrix[project].append(p) |
| 90 |
+ |
else: |
| 91 |
+ |
projectMatrix[project] = [p,] |
| 92 |
+ |
for p in projectMatrix.keys(): |
| 93 |
+ |
print p |
| 94 |
+ |
print str(projectMatrix[p]) |
| 95 |
+ |
print "---------------" |
| 96 |
+ |
|
| 97 |
+ |
|
| 98 |
|
def SplitIntoPlates(exportFile): |
| 99 |
|
openMWEList = [] |
| 100 |
|
openKPMGList = [] |
| 304 |
|
outputFile.close() |
| 305 |
|
|
| 306 |
|
if __name__ == '__main__': |
| 307 |
< |
exportFile = "/Users/ninoborges/Dropbox/Misc/export_20140109_011143.csv" |
| 308 |
< |
indexFile = "/Users/ninoborges/Documents/ITO_Report/index2.html" |
| 309 |
< |
kpmgFile = "/Users/ninoborges/Documents/ITO_Report/KPMGs_Plate.html" |
| 310 |
< |
closedFile = "/Users/ninoborges/Documents/ITO_Report/Closed_Items.html" |
| 311 |
< |
projectViewFile = "/Users/ninoborges/Documents/ITO_Report/Project_View.html" |
| 312 |
< |
#exportFile = "T:\honeywell\export_20140106_191259.csv" |
| 313 |
< |
#indexFile= "T:\honeywell\ITO_Report\index2.html" |
| 314 |
< |
#kpmgFile = "T:\honeywell\ITO_Report\KPMGs_Plate.html" |
| 315 |
< |
#closedFile = "T:\honeywell\ITO_Report\Closed_Items.html" |
| 316 |
< |
#projectViewFile = "T:\honeywell\ITO_Report\Project_View.html" |
| 307 |
> |
#exportFile = "/Users/ninoborges/Dropbox/Misc/export_20140109_011143.csv" |
| 308 |
> |
#indexFile = "/Users/ninoborges/Documents/ITO_Report/index2.html" |
| 309 |
> |
#kpmgFile = "/Users/ninoborges/Documents/ITO_Report/KPMGs_Plate.html" |
| 310 |
> |
#closedFile = "/Users/ninoborges/Documents/ITO_Report/Closed_Items.html" |
| 311 |
> |
#projectViewFile = "/Users/ninoborges/Documents/ITO_Report/Project_View.html" |
| 312 |
> |
exportFile = "T:\honeywell\ITO_Report\Export\export.csv" |
| 313 |
> |
indexFile= "T:\honeywell\ITO_Report\index2.html" |
| 314 |
> |
kpmgFile = "T:\honeywell\ITO_Report\KPMGs_Plate.html" |
| 315 |
> |
closedFile = "T:\honeywell\ITO_Report\Closed_Items.html" |
| 316 |
> |
projectViewFile = "T:\honeywell\ITO_Report\Project_View.html" |
| 317 |
|
openMWEList,openKPMGList, closedList = SplitIntoPlates(exportFile) |
| 318 |
|
print "mwe list %s"%len(openMWEList) |
| 319 |
|
print "kpmg list %s"%len(openKPMGList) |
| 336 |
|
FinishReport(open(indexFile,'a')) |
| 337 |
|
FinishReport(open(kpmgFile,'a')) |
| 338 |
|
FinishReport(open(closedFile,'a')) |
| 339 |
< |
FinishReport(open(projectViewFile,'a')) |
| 339 |
> |
FinishReport(open(projectViewFile,'a')) |
| 340 |
> |
GetProjectList(mwePlate,kpmgPlate,closedPlate) |