ViewVC Help

View File | Revision Log | Show Annotations | View Changeset | Root Listing

root/ns_dev/Python/NinoCode/Active_prgs/Redgrave/EndoIGChgReqSysToServer.py

Comparing Python/NinoCode/Active_prgs/Redgrave/EndoIGChgReqSysToServer.py (file contents):
Revision 782 by nino.borges, Fri Aug 5 02:20:05 2022 UTC vs.
Revision 783 by nino.borges, Mon Aug 15 21:24:32 2022 UTC

#	Line 17 | Line 17 | if __name__ == '__main__':
17		outputFileName = r"C:\Test_Dir\serverToExcel.txt"
18
19		xlSpreadSheetFileName = r"C:\Users\eborges\Documents\Cases\Endo\20220715 - IG Projects\4 - Develop Identification Process to Inventory NCDS stored in Endo IT\_fromEndo\_otherInformation\ServiceNow Change Requests Jan 30 2020 to July 28 2022 - Copy.xlsx"
20	<	#win2kServersFile = r"C:\Users\eborges\Documents\Cases\Endo\20220715 - IG Projects\4 - Develop Identification Process to Inventory NCDS stored in Endo IT\_fromEndo\_csv\Win8Servers_NOFilter.csv"
21	<	win2kServersFile = r"C:\Users\eborges\Documents\Cases\Endo\20220715 - IG Projects\4 - Develop Identification Process to Inventory NCDS stored in Endo IT\_fromEndo\_csv\Test.csv"
20	>	win2kServersFile = r"C:\Users\eborges\Documents\Cases\Endo\20220715 - IG Projects\4 - Develop Identification Process to Inventory NCDS stored in Endo IT\_fromEndo\_csv\Win8Servers_NOFilter.csv"
21	>	#win2kServersFile = r"C:\Users\eborges\Documents\Cases\Endo\20220715 - IG Projects\4 - Develop Identification Process to Inventory NCDS stored in Endo IT\_fromEndo\_csv\Test.csv"
22
23		serverNamesMatrix = {}
24		contents = open(win2kServersFile).readlines()
#	Line 36 | Line 36 | if __name__ == '__main__':
36		sht = xlBook.Worksheets(1)
37		for serverName in list(serverNamesMatrix.keys()):
38		print("Now processing %s..."% serverName)
39	+	#outputFile.write(serverName + "|")
40		findAllResultsList = []
41		foundLoc = sht.UsedRange.Cells.Find(serverName)
42	<	while (foundLoc.Row,foundLoc.Column) not in findAllResultsList:
43	<	findAllResultsList.append((foundLoc.Row,foundLoc.Column))
44	<	foundLoc = sht.UsedRange.Cells.FindNext(foundLoc)
45	<	outputFile.write(serverName + "|")
46	<	for rowNumb, colNumb in findAllResultsList:
47	<	outputFile.write("%s|%s"%(sht.Cells(rowNumb,1).value, sht.Cells(rowNumb,2).value))
48	<	outputFile.write("\n")
42	>	if foundLoc:
43	>	while (foundLoc.Row,foundLoc.Column) not in findAllResultsList:
44	>	findAllResultsList.append((foundLoc.Row,foundLoc.Column))
45	>	foundLoc = sht.UsedRange.Cells.FindNext(foundLoc)
46	>	uniqueRows = set()
47	>	for rowNumb, colNumb in findAllResultsList:
48	>	uniqueRows.add(rowNumb)
49	>	uniqueRows = list(uniqueRows)
50	>	uniqueRows.sort()
51	>	for uniqueRowNumb in uniqueRows:
52	>	outputFile.write("%s|%s|%s|%s|%s|%s\n"%(serverName,sht.Cells(uniqueRowNumb,1).value, sht.Cells(uniqueRowNumb,2).value, sht.Cells(uniqueRowNumb,12).value, sht.Cells(uniqueRowNumb,36).value, sht.Cells(uniqueRowNumb,114).value))
53	>	else:
54	>	outputFile.write(serverName + "||||\n")
55	>	#outputFile.write("\n")
56		outputFile.close()
57		xlBook.Close()
58

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines (old)
>	Changed lines (new)