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 787 by nino.borges, Mon Aug 15 21:24:32 2022 UTC vs.
Revision 788 by nino.borges, Wed Aug 24 15:31:56 2022 UTC

#	Line 14 | Line 14 | on the main EndoIGServerAnalyzer program
14		from win32com.client import Dispatch
15
16		if __name__ == '__main__':
17	<	outputFileName = r"C:\Test_Dir\serverToExcel.txt"
17	>	outputFileName = r"C:\Test_Dir\serverToExcel-SNOW.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"
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	>	xlSpreadSheetFileName = r"C:\Users\eborges\Documents\Cases\Endo\20220715 - IG Projects\4 - Develop Identification Process to Inventory NCDS stored in Endo IT\_fromEndo\_otherInformation\Legacy SNOW Change Request data dump Dec 2007 to Jan 2020.xlsx"
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\Win8Servers_NOFilter.csv"
22		#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"
23
#	Line 49 | Line 50 | if __name__ == '__main__':
50		uniqueRows = list(uniqueRows)
51		uniqueRows.sort()
52		for uniqueRowNumb in uniqueRows:
53	<	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	>	#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))
54	>	outputFile.write("%s|%s|%s\n"%(serverName,sht.Cells(uniqueRowNumb,2).value, sht.Cells(uniqueRowNumb,3).value))
55		else:
56	<	outputFile.write(serverName + "||||\n")
56	>	#outputFile.write(serverName + "|||||\n")
57	>	outputFile.write(serverName + "||\n")
58		#outputFile.write("\n")
59		outputFile.close()
60		xlBook.Close()

Diff Legend

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