def refreshList(self, path = '/Volumes/fs3/encoding/AssetManagement/nbc_incoming/'): #set default path
workbook = '/Volumes/dam/OPERATOR/AKARAMIAN/armenScripts/python/spreadsheetChecker/NBCU_Features_Series_MASTER-test.xls'
print path
self.incomingFilePath = path
incomingList = sc.getFilenames(path) #get new filenames
print incomingList
xlsDic = si.breakdownXLS(workbook)
listofmatches = sc.findMatches(incomingList, xlsDic) #get duplicates#
############## HALT DUPLICATE DETECTION UNTIL MAIN EXCEL SPREADSHEET IS USED ########################
# for duplicate in listofmatches: #remove duplicates from new file list
# try:
# incomingList.remove(duplicate)
# except ValueError, e:
# print e
tempFilenameOutput = open('/Volumes/dam/_NBCU/EntryScriptOutput/._tempfilenameoutput.txt', 'wb')
for thisFile in incomingList:
tempFilenameOutput.write(thisFile.filename+'\n')
tempFilenameOutput.close()
# root = tk.Toplevel()
# print "root:", root
# cne.ControlNumberEntryWindow(incomingList, xlsDic, workbook, root)
#create c# entry screen/insert into database
self.createListBox(0,0,80,30,"Incoming Files", incomingList) #put list information on gui
def refreshList(self,
path='/Volumes/fs3/encoding/AssetManagement/nbc_incoming/'
): #set default path
workbook = '/Volumes/dam/OPERATOR/AKARAMIAN/armenScripts/python/spreadsheetChecker/NBCU_Features_Series_MASTER-test.xls'
print path
self.incomingFilePath = path
incomingList = sc.getFilenames(path) #get new filenames
print incomingList
xlsDic = si.breakdownXLS(workbook)
listofmatches = sc.findMatches(incomingList, xlsDic) #get duplicates#
############## HALT DUPLICATE DETECTION UNTIL MAIN EXCEL SPREADSHEET IS USED ########################
# for duplicate in listofmatches: #remove duplicates from new file list
# try:
# incomingList.remove(duplicate)
# except ValueError, e:
# print e
tempFilenameOutput = open(
'/Volumes/dam/_NBCU/EntryScriptOutput/._tempfilenameoutput.txt',
'wb')
for thisFile in incomingList:
tempFilenameOutput.write(thisFile.filename + '\n')
tempFilenameOutput.close()
# root = tk.Toplevel()
# print "root:", root
# cne.ControlNumberEntryWindow(incomingList, xlsDic, workbook, root)
#create c# entry screen/insert into database
self.createListBox(0, 0, 80, 30, "Incoming Files",
incomingList) #put list information on gui
def refreshList(self,excelfile='/Volumes/fs3/encoding/AssetManagement/NBCU_Features_Series_MASTER.xls', path='/Volumes/fs3/encoding/AssetManagement/nbc_incoming/'): #set default path try: incomingList = sc.getFilenames(path) #get new filenames workbook = si.breakdownXLS(excelfile) listofmatches = sc.findMatches(incomingList, workbook) #get duplicates for duplicate in listofmatches: #remove duplicates from new file list incomingList.remove(duplicate) incomingList.sort() workbook = si.insertNewRows(incomingList, workbook) #append new files to spreadsheet si.updateWorkbook(workbook) except IndexError, e: print e
def refreshList(self, path = '/Volumes/fs3/encoding/AssetManagement/nbc_incoming/'): #set default path workbook = '/Volumes/dam/OPERATOR/AKARAMIAN/armenScripts/python/spreadsheetChecker/NBCU_Features_Series_MASTER-test.xls' print path self.incomingFilePath = path incomingList = sc.getFilenames(path) #get new filenames xlsDic = si.breakdownXLS(workbook) listofmatches = sc.findMatches(incomingList, xlsDic) #get duplicates for duplicate in listofmatches: #remove duplicates from new file list incomingList.remove(duplicate) si.insertNewRows(incomingList, xlsDic) #append new files to spreadsheet si.updateWorkbook(workbook, xlsDic) self.createListBox(0,0,80,30,"Incoming Files", incomingList) #put list information on gui self.createListBox(0,1,80,20,"Duplicates", listofmatches)
def refreshList(self): workbook = '/Volumes/dam/OPERATOR/AKARAMIAN/armenScripts/python/spreadsheetChecker/NBCU_Features_Series_MASTER.xls' TESTOUTPUT = '/Volumes/dam/OPERATOR/AKARAMIAN/armenScripts/python/spreadsheetChecker/NBCU_Features_Series_MASTER.xls' incomingList = sc.getFilenames(self.incomingFilePath) #get new filenames # print incomingList xlsDic = si.breakdownXLS(workbook) listofmatches = sc.findMatches(incomingList, xlsDic) #get duplicates for duplicate in listofmatches: #remove duplicates from new file list # print duplicate.filename incomingList.remove(duplicate) si.insertNewRows(incomingList, xlsDic) #append new files to spreadsheet si.updateWorkbook(TESTOUTPUT, xlsDic) #update .xls file self.createListBox(0,0,30,"Incoming Files", incomingList) #put list information on gui self.createListBox(0,1,20,"Duplicates",listofmatches)
def refreshList(self,
path='/Volumes/fs3/encoding/AssetManagement/nbc_incoming/'
): #set default path
workbook = '/Volumes/dam/OPERATOR/AKARAMIAN/armenScripts/python/spreadsheetChecker/NBCU_Features_Series_MASTER-test.xls'
print path
self.incomingFilePath = path
incomingList = sc.getFilenames(path) #get new filenames
xlsDic = si.breakdownXLS(workbook)
listofmatches = sc.findMatches(incomingList, xlsDic) #get duplicates
for duplicate in listofmatches: #remove duplicates from new file list
incomingList.remove(duplicate)
si.insertNewRows(incomingList,
xlsDic) #append new files to spreadsheet
si.updateWorkbook(workbook, xlsDic)
self.createListBox(0, 0, 80, 30, "Incoming Files",
incomingList) #put list information on gui
self.createListBox(0, 1, 80, 20, "Duplicates", listofmatches)
