def fPrint_FlatFee(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print FlatFee") # name report file: ex: ARAgedBal-03 reportName = myTools.buildRepName("FlatFee",pRepExt) logging.debug('Print_FlatFee: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("r",KeyModifier.ALT) type("c") time.sleep(1) type("f") time.sleep(1) # move to Print To and choose CSV myTools.pressSHIFTTAB(2) time.sleep(1) type("c") # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_FeeAllocPer(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print FeeAllocPer") # name report file: ex: PreBill-03 reportName = myTools.buildRepName("FeeAllocPer",pRepExt) logging.debug('Print_FeeAllocPer: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open FeeAllocPer') type("r",KeyModifier.ALT) type("t") time.sleep(1) myTools.pressDOWN(3) time.sleep(1) # choose csv myTools.pressSHIFTTAB(2) type("c") time.sleep(1) myTools.enterCurrentMonthOnList(pReportMonth) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_ARwRunBal(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print ARwRunBal") # name report file: ex: UDSlip1-03 reportName = myTools.buildRepName("ARwRunBal",pRepExt) logging.debug('fPrint_ARwRunBal: ' + reportName) myTools.getFocus() logging.debug('- open report list') type("r",KeyModifier.ALT) type("a") time.sleep(1) logging.debug('- choose report') myTools.pressDOWN(2) time.sleep(1) # choose txt myTools.pressSHIFTTAB(2) time.sleep(1) type("t") time.sleep(1) myTools.enterCurrentMonthOnList(pReportMonth) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_InvoiceListing(pReportMonth, pRepExt): # ---------------------------------------------------# myTools.sectionStartTimeStamp("print invoicelist") # name report file: ex: UDSlip1-03 reportName = myTools.buildRepName("InvList", pRepExt) logging.debug("Print_InvoiceList: " + reportName) myTools.getFocus() logging.debug("- open report list") type("r", KeyModifier.ALT) type("a") time.sleep(1) logging.debug("- choose report") type("i") time.sleep(1) # choose txt myTools.pressSHIFTTAB(2) time.sleep(1) type("t") time.sleep(1) myTools.enterYearToDateOnList(pReportMonth) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_SlipFields(pReportMonth,pRepExt): #---------------------------------------------------# # this does not include applied fields, since we fixed some stuff in ts2016 myTools.sectionStartTimeStamp("print slipfields") # name report file: ex: UDSlip1-03 reportName = myTools.buildRepName("UDSlip2",pRepExt) logging.debug('Print_UDSlip2: ' + reportName) myTools.getFocus() logging.debug('- open report list') type("r",KeyModifier.ALT) type("s") time.sleep(1) logging.debug('- choose report') type("UDS SlipFields") time.sleep(1) # fSort_SlipReportFields() fChoose_CSV_Print(reportName) myTools.waitForReport() reports_Compare.Compare_OneReport(reportName) # close the report type(Key.F4,KeyModifier.CTRL) time.sleep(1) type("n") type(Key.F4,KeyModifier.CTRL) myTools.sectionEndTimeStamp()
def fPrint_SlipListCalc(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print slipcalcs") # name report file: ex: UDSlip1-03 reportName = myTools.buildRepName("UDSCalc",pRepExt) logging.debug('Print_UDSCalc: ' + reportName) myTools.getFocus() logging.debug('- open report list') type("r",KeyModifier.ALT) type("s") time.sleep(1) logging.debug('- choose report') type("uds c") time.sleep(1) # fSort_SlipReportFields() fChoose_CSV_Print(reportName) myTools.waitForReport() reports_Compare.Compare_OneReport(reportName) # close the report type(Key.F4,KeyModifier.CTRL) time.sleep(1) type("n") type(Key.F4,KeyModifier.CTRL) myTools.sectionEndTimeStamp()
def Print_TkCC(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print tkcc") # name report file: ex: TkCC-03 reportName = myTools.buildRepName("TkCC",pRepExt) logging.debug('Print_TkCC: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("r",KeyModifier.ALT) type("t") time.sleep(2) type("timekeeper cont") time.sleep(1) myTools.pressDOWN(1) time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) logging.debug('- default options') # options button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # default button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # show client breakdown myTools.pressTAB(4) type(Key.SPACE) time.sleep(1) # close dialog type(Key.ENTER) time.sleep(1) logging.debug('- print report') # move to Print To and choose CSV myTools.pressTAB(2) type("c") time.sleep(1) if pReportMonth != 13: Filter_SplitClients() # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def Print_GLXfer(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print glxfer") # name report file: ex: TkCC-03 reportName = myTools.buildRepName("GLXfer",pRepExt) logging.debug('Print_GLXfer: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("a",KeyModifier.ALT) type("g") time.sleep(1) logging.debug('- default options') # options button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # default button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # trans types myTools.pressTAB(4) type(Key.ENTER) time.sleep(1) # remove transfer since they were wrong before ts2016 type("t") time.sleep(1) type(Key.SPACE) time.sleep(1) type(Key.ENTER) # close dialog myTools.pressSHIFTTAB(3) type(Key.ENTER) time.sleep(1) logging.debug('- print report') # move to Print To and choose CSV myTools.pressTAB(2) type("c") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_AgedClient(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print AgedClient") # name report file: ex: PreBill-03 reportName = myTools.buildRepName("AgedClient",pRepExt) logging.debug('Print_AgedClient: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open PayPerf') type("r",KeyModifier.ALT) type("c") time.sleep(1) myTools.pressDOWN(1) time.sleep(1) logging.debug('- set up report') type("o",KeyModifier.CTRL) # Options myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Default myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Show hours myTools.pressTAB(10) type(Key.SPACE) time.sleep(1) # Show Adjustment columns myTools.pressTAB(1) type(Key.SPACE) time.sleep(1) # OK type(Key.ENTER) time.sleep(1) # choose csv myTools.pressTAB(2) type("c") time.sleep(1) myTools.enterSlipFilter(pReportMonth,"yy") # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def Print_SlipTotalsWeekly(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("slip totals") # name report file: ex: PayDistr-03 reportName = myTools.buildRepName("SlipTot",pRepExt) logging.debug('Print_SlipTotalsWeekly: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("r",KeyModifier.ALT) type("s") time.sleep(2) type("w") time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) logging.debug('- default options') # switch to CSV myTools.pressSHIFTTAB(2) time.sleep(1) type("c") # options button myTools.pressSHIFTTAB(2) type(Key.ENTER) time.sleep(1) # default button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # Include totals myTools.pressTAB(8) time.sleep(1) type(Key.SPACE) # OK type(Key.ENTER) time.sleep(1) myTools.enterSlipFilter(pReportMonth,"y") logging.debug('- print report') type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_ClientListValues(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print clientvalues") # name report file: ex: UDSlip1-03 reportName = myTools.buildRepName("UDClient2",pRepExt) logging.debug('Print_UDClient2: ' + reportName) myTools.getFocus() logging.debug('- open report list') type("r",KeyModifier.ALT) type("c") time.sleep(1) logging.debug('- choose report') type("ud") time.sleep(1) myTools.pressDOWN(1) time.sleep(1) # choose CSV myTools.pressSHIFTTAB(2) time.sleep(1) type("c") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) # fill in path and name type(Settings.repFolder + "\\" + reportName) time.sleep(1) # export column titles myTools.pressTAB(2) time.sleep(1) type(Key.SPACE) time.sleep(1) # press ENTER to print type(Key.ENTER) # wait for report to complete myTools.waitForReport() # compare the report with baseline reports_Compare.Compare_OneReport(reportName) # close the report type(Key.F4,KeyModifier.CTRL) myTools.sectionEndTimeStamp()
def print_SlipSummary(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print SlipSummary") # name report file: ex: SlipSumm-03 reportName = myTools.buildRepName("SlipSumm",pRepExt) logging.debug('Print_SlipSumm: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report list') type("r",KeyModifier.ALT) type("s") time.sleep(1) logging.debug('- set up report') type("slip s") time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) # Options myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Default myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # exclude analysis info myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # OK myTools.pressTAB(5) type(Key.SPACE) time.sleep(1) # choose CSV myTools.pressTAB(2) type("c") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def Print_FeeAlloc(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print fee alloc") # name report file: ex: FeeAlloc-03 reportName = myTools.buildRepName("FeeAlloc",pRepExt) logging.debug('Print_FeeAlloc: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("r",KeyModifier.ALT) type("t") time.sleep(2) type("fee") time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) logging.debug('- default options') # options button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # default button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # close dialog myTools.pressTAB(1) type(Key.ENTER) time.sleep(1) logging.debug('- print report') # move to Print To and choose CSV myTools.pressTAB(2) type("c") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_AgedInv(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print AgedInv") # name report file: ex: PreBill-03 reportName = myTools.buildRepName("AgedInv",pRepExt) logging.debug('Print_AgedInv: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open AgedInv') type("r",KeyModifier.ALT) type("c") time.sleep(1) myTools.pressDOWN(2) time.sleep(1) logging.debug('- set up report') type("o",KeyModifier.CTRL) # Options myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Default myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Due values myTools.pressSHIFTTAB(4) type("d") time.sleep(1) # OK type(Key.ENTER) time.sleep(1) # choose csv myTools.pressTAB(2) type("c") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_PreBill_1(pReportMonth,pRepExt): #---------------------------------------------------# """ print pre-bill 1 - use myTools.enterSlipFilter for slip filter thru current month - default sorts - default options """ myTools.sectionStartTimeStamp("print PreBill 1") # name report file: ex: PreBill-03 reportName = myTools.buildRepName("PreBill",pRepExt) logging.debug('Print_PreBill: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open worksheet') type("b",KeyModifier.ALT) type("p") time.sleep(1) logging.debug('- set up worksheet') # Options myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Default myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # OK myTools.pressTAB(1) type(Key.SPACE) time.sleep(1) # choose text myTools.pressTAB(2) type("t") time.sleep(1) myTools.enterSlipFilter(pReportMonth,"n") # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_FirmAssTot(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print FirmAssTot") # name report file: ex: PreBill-03 reportName = myTools.buildRepName("FirmAssTot",pRepExt) logging.debug('Print_FirmAssTot: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open FirmAssTot') type("r",KeyModifier.ALT) type("b") time.sleep(1) type("f") myTools.pressDOWN(1) time.sleep(1) logging.debug('- set up report') type("o",KeyModifier.CTRL) # Options myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Default myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # OK myTools.pressTAB(1) type(Key.SPACE) time.sleep(1) # choose text myTools.pressTAB(2) type("t") time.sleep(1) myTools.enterSlipFilter(pReportMonth,"n") # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def print_DaysToPay(pReportMonth, pRepExt): # ---------------------------------------------------# myTools.sectionStartTimeStamp("print daystopay") # name report file: ex: DaysToPay-03 reportName = myTools.buildRepName("DaysToPay", pRepExt) logging.debug("Print_DaysToPay: " + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug("- open report") type("r", KeyModifier.ALT) type("a") time.sleep(2) type("d") time.sleep(1) type("o", KeyModifier.CTRL) time.sleep(1) logging.debug("- default options") # options button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # default button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # close dialog myTools.pressTAB(1) type(Key.ENTER) time.sleep(1) logging.debug("- print report") # move to Print To and choose CSV myTools.pressTAB(2) type("c") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def print_ProdPeriod(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print ProdPer") # name report file: ex: ProdPer-03 reportName = myTools.buildRepName("ProdPer",pRepExt) logging.debug('Print_ProdPeriod: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report list') type("r",KeyModifier.ALT) type("s") time.sleep(1) logging.debug('- set up report') type("prod") time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) # Options myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Default myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # OK myTools.pressTAB(1) type(Key.SPACE) time.sleep(1) # choose CSV myTools.pressTAB(2) type("c") time.sleep(1) myTools.enterSlipFilter(pReportMonth,"y") # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def Print_Taxes(pReportMonth, pRepExt): # ---------------------------------------------------# myTools.sectionStartTimeStamp("print taxes") # name report file: ex: Hold-03 reportName = myTools.buildRepName("Taxes", pRepExt) logging.debug("Print_Taxes: " + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug("- open report list") type("r", KeyModifier.ALT) type("x") time.sleep(1) logging.debug("- set up taxes collection report") type("tax c") time.sleep(1) type("o", KeyModifier.CTRL) time.sleep(1) # Options myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Default myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # OK myTools.pressTAB(1) type(Key.SPACE) time.sleep(1) # choose CSV myTools.pressTAB(2) type("c") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_FundsBal(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print fundsbal") # name report file: ex: TkCC-03 reportName = myTools.buildRepName("FundsBal",pRepExt) logging.debug('fPrint_FundsBal: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report list') type("r",KeyModifier.ALT) type("f") time.sleep(1) logging.debug('- set up funds account listing') type("funds") time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) # Options myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Default myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # OK myTools.pressTAB(1) type(Key.SPACE) time.sleep(1) # choose CSV myTools.pressTAB(2) type("c") type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fPrint_Statement(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print statements") # name report file: ex: Statement-03 reportName = myTools.buildRepName("Statement",pRepExt) logging.debug('Print_Statement: ' + reportName) myTools.getFocus() logging.debug('- open report list') type("b",KeyModifier.ALT) type("s") time.sleep(1) # text file myTools.pressSHIFTTAB(2) time.sleep(1) type("t") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) # fill in path and name type(Settings.repFolder + "\\" + reportName) time.sleep(1) # press ENTER to print type(Key.ENTER) # wait for report to complete myTools.waitForStatement() # compare the report with baseline reports_Compare.Compare_OneReport(reportName) # close the report type(Key.F4,KeyModifier.CTRL) time.sleep(1) type("n") myTools.sectionEndTimeStamp()
def fPrint_PreBill_2(pReportMonth,pRepExt,pAorB): #---------------------------------------------------# """ print pre-bill 2 - uses setupCustomFilter for filters - uses setupCustomSort for sorts - setupCustomOptions for options - restore if prior to TS2016 """ myTools.sectionStartTimeStamp("print PreBill 2") # name report file: ex: PreBill-03 reportName = myTools.buildRepName("PreBill2",pRepExt) logging.debug('Print_PreBill: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open worksheet') type("b",KeyModifier.ALT) type("p") time.sleep(1) setupCustomOptions() setupCustomFilter() setupCustomSort() # choose text myTools.pressSHIFTTAB(3) type("t") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName) # RESTORE if version is prior to TS2016 (defect regarding recurring slips) if int(Settings.tsVersion) < 2016: buName = Settings.tsVersion + "-bill-" + str(myTools.padZero(pReportMonth)) + pAorB backup_Data.fRestore_Backup(buName)
def fPrint_FundsList(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print FundsList") # name report file: ex: ARAgedBal-03 reportName = myTools.buildRepName("FundsList",pRepExt) logging.debug('fPrint_FundsList: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("r",KeyModifier.ALT) type("f") time.sleep(1) type("funds t") time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) type(Key.F6) time.sleep(1) # move to Print To and choose CSV myTools.pressSHIFTTAB(2) time.sleep(1) type("c") time.sleep(1) # move to sort list, choose ID myTools.pressTAB(5) time.sleep(1) type(Key.SPACE) time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def printFirmBudget(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print firm budget") reportName = myTools.buildRepName("FirmBud",pRepExt) logging.debug('Print_FirmBudget: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("r",KeyModifier.ALT) type("h") time.sleep(2) type("firm") time.sleep(1) setupReport() myTools.finishReport(reportName)
def fPrint_MissingTime(pReportMonth,pRepExt,pAorB): #---------------------------------------------------# myTools.sectionStartTimeStamp("print MissingTime") # name report file: ex: PreBill-03 reportName = myTools.buildRepName("MissingTime",pRepExt) logging.debug('Print_MissingTime: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open MissingTime') type("r",KeyModifier.ALT) type("t") time.sleep(1) type("m") time.sleep(1) # choose csv myTools.pressSHIFTTAB(2) type("c") time.sleep(1) # period myTools.pressSHIFTTAB(2) if pAorB == "a": perDate = str(pReportMonth) + "/01/13" else: perDate = str(pReportMonth) + "/15/13" type(perDate) # tab to print button to get around AV myTools.pressTAB(3) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def Print_TkContribution(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print tkcontribution") # name report file: ex: TkCC-03 reportName = myTools.buildRepName("TkContrib",pRepExt) logging.debug('Print_TkContrib: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("r",KeyModifier.ALT) type("t") time.sleep(2) type("timekeeper con") time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) logging.debug('- default options') # options button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # default button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # ITD myTools.pressSHIFTTAB(3) time.sleep(1) type("i") time.sleep(1) # close dialog type(Key.ENTER) time.sleep(1) logging.debug('- print report') # move to Print To and choose CSV myTools.pressTAB(2) type("c") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) # fill in path and name; press ENTER type(Settings.repFolder + "\\" + reportName) time.sleep(1) type(Key.ENTER) # wait for report to complete myTools.waitForReport() # compare the report with baseline reports_Compare.Compare_OneReport(reportName) # close the report type(Key.F4,KeyModifier.CTRL) time.sleep(1) type("n") type(Key.F4,KeyModifier.CTRL) myTools.sectionEndTimeStamp()
def fPrint_PayPerf(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print PayPerf") # name report file: ex: PreBill-03 reportName = myTools.buildRepName("PayPerf",pRepExt) logging.debug('Print_PayPerf: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open PayPerf') type("r",KeyModifier.ALT) type("a") time.sleep(1) type("p") time.sleep(1) myTools.pressDOWN(1) time.sleep(1) logging.debug('- set up report') type("o",KeyModifier.CTRL) # Options myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Default myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Quarterly myTools.pressSHIFTTAB(2) type("q") time.sleep(1) # totals myTools.pressSHIFTTAB(8) type(Key.SPACE) time.sleep(1) # costs myTools.pressSHIFTTAB(1) type(Key.SPACE) time.sleep(1) # OK type(Key.ENTER) time.sleep(1) # choose csv myTools.pressTAB(2) type("c") time.sleep(1) myTools.enterSlipFilter(pReportMonth,"y") # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def Print_TkHistory(pReportMonth, pRepExt): # ---------------------------------------------------# myTools.sectionStartTimeStamp("print tk history") # name report file: ex: TkHistory-03 reportName = myTools.buildRepName("TkHistory", pRepExt) logging.debug("Print_TkHistory: " + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug("- open report") type("r", KeyModifier.ALT) type("t") time.sleep(1) type("timekeeper history") time.sleep(1) type("o", KeyModifier.CTRL) time.sleep(1) # remove all filters myTools.pressTAB(4) type(Key.ENTER) logging.debug("- default options") # options button myTools.pressTAB(3) type(Key.ENTER) time.sleep(1) # default button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # period = quarterly myTools.pressSHIFTTAB(2) type("q") # unmark "show analysis" myTools.pressSHIFTTAB(8) type(Key.SPACE) # close dialog type(Key.ENTER) time.sleep(1) logging.debug("- print report") # move to Print To and choose CSV myTools.pressTAB(2) type("c") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def Print_ClientsNotBilled(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print ClientsNotBilled") # name report file: ex: Worksheet-03 reportName = myTools.buildRepName("CliNotBilled",pRepExt) logging.debug('Print_CliNotBilled: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report list') type("r",KeyModifier.ALT) type("b") time.sleep(1) logging.debug('- set up report') type("c") time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) # Options myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # Default myTools.pressSHIFTTAB(4) type(Key.SPACE) time.sleep(1) # include auto pay myTools.pressSHIFTTAB(5) type(Key.SPACE) time.sleep(1) # include zero myTools.pressTAB(1) type(Key.SPACE) time.sleep(1) # OK type(Key.ENTER) time.sleep(1) # choose CSV myTools.pressTAB(2) type("c") time.sleep(1) # remove filters myTools.pressTAB(7) type(Key.ENTER) time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def Print_PayDistr(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print pay dist") # name report file: ex: PayDistr-03 reportName = myTools.buildRepName("PayDistr",pRepExt) logging.debug('Print_PayDistr: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("r",KeyModifier.ALT) type("a") time.sleep(2) type("pay") time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) logging.debug('- default options') # options button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # default button myTools.pressSHIFTTAB(4) type(Key.ENTER) time.sleep(1) # pay dist = with tax myTools.pressSHIFTTAB(3) type("w") # OK type(Key.ENTER) time.sleep(1) # on Selection page, clear any existing filters if exists("remove_all.png"): click("remove_all.png") time.sleep(1) # Sort page type(Key.F6) time.sleep(1) # clear any existing sorts if exists("remove_all.png"): click("remove_all.png") time.sleep(1) # sort by tran id type(Key.DOWN) time.sleep(1) click("add_filter.png") time.sleep(1) logging.debug('- print report') # move to Print To and choose CSV myTools.pressSHIFTTAB(3) type("c") time.sleep(1) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)