Included page: .FrontPage.QA.OSMI-OutOfStateMunicipalIncome.2022.SetUp (edit)

import
TBOT.Generic.Database


ddt: SetUp
key value
ConnectionString Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100;Timeout=45
BytesColumn DataObject
FileExtension ZIP
ExpectedDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
DownloadPath \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
ExpectedDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
ActualDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
SourceDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
ResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
CompareResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
skipIgnorePatterns true
ignorePathValidations false
DeleteFile true
Debug TRUE
ignoreNodes /Envelope/Body/GetOSMIBEBankRecipResponse/GetOSMIBEBankRecipResult/diffgram/NewDataSet/OSMIBEBankRecip/RecipNo;/Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/RecipNo;/Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/RecipNo;/Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt;/Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt;/Envelope/Body/GetOSMIMutualFundCorrectedResponse/GetOSMIMutualFundCorrectedResult/diffgram/NewDataSet/OSMIMutualFundCorrected/Filing_Dt;/Envelope/Body/GetOSMIMutualFundCorrectedResponse/GetOSMIMutualFundCorrectedResult/diffgram/NewDataSet/OSMIMutualFundCorrected/RecipNo;/Envelope/Body/GetOSMIBondsCorrectedResponse/GetOSMIBondsCorrectedResult/diffgram/NewDataSet/OSMIBondsCorrected/Filing_Dt;/Envelope/Body/GetOSMIBondsCorrectedResponse/GetOSMIBondsCorrectedResult/diffgram/NewDataSet/OSMIBondsCorrected/RecipNo


ddt:DynamicQuery Select convert(varchar(10),getdate(),101) As TodayDate
TodayDate?
$TodayDate=


import
TBOT.Generic.Database

import
TBOT.Generic


ddt: DynamicQuery Select AcctNo As PAN,LTRIM(RTRIM(Server)) As Server,LTRIM(RTRIM(DB_NAME)) As DBName from BTMDB..Package where AcctNo='{{PAN}}'
PAN Server? DBName?
673R $Server1= $DBName1=


ddt:DynamicQuery Select A.ValueText As ProductCd from BANKCONST..Translate A Join BANKCONST..Translate B On A.TranslateCode=B.TranslateCode and A.Seq=B.Seq and A.ValueID = 1 and B.ValueID=2 where A.Translatecode={{TransCode}} and B.ValueText='{{Value}}'
TransCode Value ProductCd?
3002 OSMI Report $ProductCd1=


1 Submit Prepare OSMI Request and Verify AcctWIP Record for all states


ddt: SOAPNoNestedXMLClient http://ott-trusttax-sw-qa-use1-aws.tax.nonprod.int.thomsonreuters.com/PrepareOSMI.asmx SOAP:Action text/xml POST SubmitOSMIRequestTemplate.xml
SRVNAME BANKDB PAN TAXYR Initials STATES STATUSCODE XMLFileName STATUSCODE?
$Server1 $DBName1 673R 2023 SA1 RI $StatusCode1 SubmitOSMIRequestRI.xml OK

ddt: SOAPNoNestedXMLClient http://ott-trusttax-sw-qa-use1-aws.tax.nonprod.int.thomsonreuters.com/BatchRequest.asmx SOAP:Action text/xml POST GetAcctWIPRecordTemplate.xml
SRVNAME BANKDB PAN TAXYR PRODUCTCODE YRSPECIFIC XMLFileName STATUSCODE?
$Server1 $DBName1 673R 2023 $ProductCd1 true GetAcctWIPRI.xml OK




DDT:PollingFixture select * from OPERATIONSDB..Status where Product_Cd='{{ProductCd}}' and Key_Field Like '{{ACCTNO}}{{ProductCd}}%' AND YrSeq='{{TaxYear}}' and DB_Name='{{DBNAME}}'
ACCTNO TaxYear DBNAME ProductCd PollInterval MaxInterval WAITFORDBDELETE?
673R 2023 $DBName1 $ProductCd1 2 120 True


Export Datafiles from BankData[?]


ddt: SOAPNoNestedXMLClient http://ott-trusttax-sw-qa-use1-aws.tax.nonprod.int.thomsonreuters.com/document.asmx SOAP:Action text/xml POST TemplateMakeBankDataBill.xml MakeBankDataBill
CLIENTID PAN USERINI SRVNAME BANKDB TAXYR PRODUCTCODE PRODOPT DOCSEQNO OBJECTCD UNITS STATE ACTIONCD WRITEBILL XMLFileName STATUSCODE?
DEVELOPMENT-SERVICEACCOUNT1 673R SA1 $Server1 $DBName1 2023 $ProductCd1 1 0 1 0 RI 1 true FileDtStampRI1.xml OK

Keyboard Shortcuts ?

  • General

  • t Test page or suite
  • e Edit page
  • v View page (after test)
  • a Add new page

  • Go To

  • g u User Guide
  • g q Quick Reference Guide
  • g f Full Reference Guide
  • g c Recent Changes

  • Edit Mode

  • CTRL+s Save page
  • ESC Cancel edit

  • Tools

  • p Properties
  • w Where used?
  • AK+v Versions
  • AK+h Page History
  • / Focus on search bar
  • s Open search page
Close