def oseAsyFile(): print('Start OSEAssembly upload') findfile = glob.glob( 'C:\\PB1\\3rdPartyFiles\\*OSE*WIP*Report*{0}*'.format(osedate)) if findfile != []: loc = findfile[0] file_name = loc file_create = 'OSE WIP Report - EVERSPIN.xls' start_upload = SharepointThirdParty() start_upload.main(file_create, file_name, folderurl + '/' + folderdate) print('Success of file upload')
def promisFile(): print('Start Promise upload') findfile = glob.glob( 'C:\\PB1\\3rdPartyFiles\\Promis*EWS*WIP*{0}*'.format(yestdaydate)) if findfile != []: loc = findfile[0] file_name = loc file_create = 'Promis_EWS_WIP.xls' start_upload = SharepointThirdParty() start_upload.main(file_create, file_name, folderurl + '/' + folderdate) print('Success of file upload')
def amkorFile(): print('Start amkor upload') findfile = glob.glob( 'C:\\PB1\\3rdPartyFiles\\Amkor*WIP_Report_*{0}*'.format(yestdaydate)) if findfile != []: loc = findfile[0] file_name = loc file_create = 'Amkor_WIP_Report.xls' start_upload = SharepointThirdParty() start_upload.main(file_create, file_name, folderurl + '/' + folderdate) print('Success of file upload')
def chmAsyFile(): print('Start CHPMosAssembly upload') findfile = glob.glob( 'C:\\PB1\\3rdPartyFiles\\*wpsp006a*ASSY*{0}*'.format(yestdaydate)) if findfile != []: loc = findfile[0] file_name = loc file_create = 'wpsp006a_Everspin_ASSY.xls' start_upload = SharepointThirdParty() start_upload.main(file_create, file_name, folderurl + '/' + folderdate) print('Success of file upload')
def chmAsyInvFile(): print('Start CHMosAssembly Inventory upload') findfile = glob.glob( 'C:\\PB1\\3rdPartyFiles\\*inventory_report*{0}*'.format(yestdaydate)) if findfile != []: loc = findfile[0] file_name = loc file_create = 'inventory_report.xls' start_upload = SharepointThirdParty() start_upload.main(file_create, file_name, folderurl + '/' + folderdate) print('Success of file upload')
def udgAsyFile(): print('Start UDGAssembly upload') findfile = glob.glob( 'C:\\PB1\\3rdPartyFiles\\*DAILY_WIP_DG*{0}*'.format(yestdaydate)) if findfile != []: loc = findfile[0] file_name = loc file_create = 'DAILY_WIP_DG.xls' start_upload = SharepointThirdParty() start_upload.main(file_create, file_name, folderurl + '/' + folderdate) print('Success of file upload')
def utlAsyFile(): print('Start UTLAssembly upload') findfile = glob.glob( 'C:\\PB1\\3rdPartyFiles\\MSIN*_{0}*'.format(yestdaydate)) if findfile != []: loc = findfile[0] file_name = loc file_create = 'MSINV076.xls' start_upload = SharepointThirdParty() start_upload.main(file_create, file_name, folderurl + '/' + folderdate) print('Success of file upload')
def utcAsyFile(): print('Start UTCAssembly upload') findfile = glob.glob( 'C:\\PB1\\3rdPartyFiles\\*Everspin*AssyWIP*{0}*'.format(yestdaydate)) if findfile != []: loc = findfile[0] file_name = loc file_create = 'EVERSPIN_AssyWIP.xls' start_upload = SharepointThirdParty() start_upload.main(file_create, file_name, folderurl + '/' + folderdate) print('Success of file upload')
def utcFile(): print('Start UTC upload') findfile = glob.glob( 'C:\\PB1\\3rdPartyFiles\\*UTC_Everspin*WIP*Report*{0}*'.format( yestdaydate)) if findfile != []: loc = findfile[0] file_name = loc file_create = 'UTC_EVERSPIN_WIP_REPORT.xls' start_upload = SharepointThirdParty() start_upload.main(file_create, file_name, folderurl + '/' + folderdate) print('Success of file upload')
def subledgerReport(): print('Start Subledger upload') sapsqlcon = pypyodbc.connect( DRIVER='{SQL Server}', Server='10.0.0.6\SAPB1_SQL', Database='Everspintech', uid='{0}'.format(cred.uid), pwd='{0}'.format(cred.pwd)) ## Create Connection to SQL Server cursor = sapsqlcon.cursor() ## Create Cursor Object subrep = [('ItemCode', 'Family', 'Stage', 'Whse', 'AbsEntry', 'OnHand Lot', 'OnHand ParentLot', 'BatchAtt2', 'Lot AddmissionDate', 'Age of Lot (Days)', 'OnHand/WIP Qty', 'WO#', 'PerUnitLotCost', 'TotalLotCost', 'GLAccount', 'Selection Date', 'AsOfDate')] query = ( "Select * from EverspinTech.dbo.vw_Subledger_report Order by Case When Stage = 'FAB' then 1 when Stage = 'EWS' then 2 when Stage = 'ASSEM' then 3 when Stage = 'FT' then 4 when Stage = 'FG' then 5 end ASC, Family, ItemCode" ) cursor.execute(query) result = cursor.fetchone() while result: subrep.append(result) result = cursor.fetchone() book = xlwt.Workbook() ## Create New Workbook sheet1 = book.add_sheet("Subledger") ## Create New sheet in workbook for r, row in enumerate(subrep): ## iterate through .csv file rows for c, col in enumerate(row): ## iterate through .csv file columns sheet1.write(r, c, col) ## write data to new file book.save("C:\\PB1\\Subledger\\Subledger.xls") cursor.close() sapsqlcon.close() findfile = glob.glob('C:\\PB1\\Subledger\\Subledger.xls') if findfile != []: loc = findfile[0] file_name = loc file_create = 'Subleger.xls' start_upload = SharepointThirdParty() start_upload.main(file_create, file_name, folderurl + '/' + folderdate) print('Success of file upload')
'%Y%m%d' ) ## Assigns the yyyymmdd format to the current date for noting the day of upload yestday = currentday - datetime.timedelta( days=1) ## sets variable to yesterday's date oseyestdate = currentday - datetime.timedelta(days=1) yestdaydate = yestday.strftime('%Y%m%d') osedate = oseyestdate.strftime('%m%d%y') folderdate = currentday.strftime('%d%m%Y') folderurl = '/CP/Shared Documents/Automation/Subledger Automation/Input' ## -- Create folder for the day -- ## print('Start Folder Creation') start_make_folder = SharepointThirdParty() start_make_folder.folderCreate(folderurl) print('Folder Created') ## -- upload amkor file --## def amkorFile(): print('Start amkor upload') findfile = glob.glob( 'C:\\PB1\\3rdPartyFiles\\Amkor*WIP_Report_*{0}*'.format(yestdaydate)) if findfile != []: loc = findfile[0] file_name = loc file_create = 'Amkor_WIP_Report.xls'