Included page: .FrontPage.QA.OSMI-OutOfStateMunicipalIncome.2023.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 A.AcctNo AS PAN,'{{TaxYear}}' AS TAXYR, LTRIM(RTRIM(DB_Name)) as DB_Name, LTRIM(RTRIM(Server)) as Server FROM BTMDB.dbo.PACKAGE A WHERE AcctNo='{{ACCTNO}}'
ACCTNO TaxYear PAN? TAXYR? DB_Name? Server?
673R 2023 $PAN1= $TAXYR1= $BANKDB1= $SRVNAME1=


ddt:DynamicQuery SELECT PayerNo FROM {{DB_Name}}.dbo.OSMIPayer A WHERE AcctNo='{{ACCTNO}}' and Year={{TaxYear}}
ACCTNO DB_Name TaxYear PayerNo?
673R $BANKDB1 2023 $PayerNo1=


ddt:DynamicQuery WAITFOR DELAY '00:00:00' select distinct(OB.RecipNo) as RecipNo,TX.Trustkey from {{BANKDB}}..OSMIBE OB join {{BANKDB}}..Trustxref TX on TX.Trustkey= OB.Trustkey join {{BANKDB}}..OSMIBEBankRecip OBR on OB.RecipNo=OBR.RecipNo where TX.Trustno='{{TrustNo}}'and OB.YrSeq={{Yrseq}}0 and RecipSt='{{StateCode}}'
BANKDB Yrseq TrustNo StateCode RecipNo? TRUSTKEY?
$BANKDB1 $TAXYR1 OSMIAUTO001 CA $RecipNo10= $Trustkey1=
$BANKDB1 $TAXYR1 OSMIAUTO001 CT $RecipNo11= $Trustkey1=
$BANKDB1 $TAXYR1 OSMIAUTO001 MA $RecipNo12= $Trustkey1=
$BANKDB1 $TAXYR1 OSMIAUTO001 MN $RecipNo13= $Trustkey1=
$BANKDB1 $TAXYR1 OSMIAUTO001 MT $RecipNo14= $Trustkey1=
$BANKDB1 $TAXYR1 OSMIAUTO001 NY $RecipNo15= $Trustkey1=
$BANKDB1 $TAXYR1 OSMIAUTO001 RI $RecipNo16= $Trustkey1=
$BANKDB1 $TAXYR1 OSMIAUTOCA CA $RecipNo20= $Trustkey2=
$BANKDB1 $TAXYR1 OSMIAUTOCT CT $RecipNo30= $Trustkey3=
$BANKDB1 $TAXYR1 OSMIAUTOMA MA $RecipNo40= $Trustkey4=
$BANKDB1 $TAXYR1 OSMIAUTOMN MN $RecipNo50= $Trustkey5=
$BANKDB1 $TAXYR1 OSMIAUTOMT MT $RecipNo60= $Trustkey6=
$BANKDB1 $TAXYR1 OSMIAUTONY NY $RecipNo70= $Trustkey7=
$BANKDB1 $TAXYR1 OSMIAUTORI RI $RecipNo80= $Trustkey8=



Assert Filed OSMI Bonds details



ddt: SOAPNoNestedXMLClient http://ott-trusttax-sw-qa-use1-aws.tax.nonprod.int.thomsonreuters.com/PrepareOSMI.asmx SOAP:Action text/xml POST GetOSMIBondsFiledTemplate.xml
SRVNAME BANKDB PAN TAXYR TRUSTKEY TRUSTSEQ PAYERNO RECIPNO XMLExpectedPath XMLFileName ignorexmlmulitnodes hasMultiSchema COMPAREXML? actualDate nodeXpath hasMultiSchema assertDateInXML?
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo10 673R_OSMIAUTO001BondsFiled0.xml 673R_OSMIAUTO001BondsFiled0.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo11 673R_OSMIAUTO001BondsFiled1.xml 673R_OSMIAUTO001BondsFiled1.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo12 673R_OSMIAUTO001BondsFiled2.xml 673R_OSMIAUTO001BondsFiled2.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo13 673R_OSMIAUTO001BondsFiled3.xml 673R_OSMIAUTO001BondsFiled3.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo14 673R_OSMIAUTO001BondsFiled4.xml 673R_OSMIAUTO001BondsFiled4.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo15 673R_OSMIAUTO001BondsFiled5.xml 673R_OSMIAUTO001BondsFiled5.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo16 673R_OSMIAUTO001BondsFiled6.xml 673R_OSMIAUTO001BondsFiled6.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey2 0 $PayerNo1 $RecipNo20 673R_OSMIAUTOCABondsFiled.xml 673R_OSMIAUTOCABondsFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey3 0 $PayerNo1 $RecipNo30 673R_OSMIAUTOCTBondsFiled.xml 673R_OSMIAUTOCTBondsFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey4 0 $PayerNo1 $RecipNo40 673R_OSMIAUTOMABondsFiled.xml 673R_OSMIAUTOMABondsFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey5 0 $PayerNo1 $RecipNo50 673R_OSMIAUTOMNBondsFiled.xml 673R_OSMIAUTOMNBondsFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey6 0 $PayerNo1 $RecipNo60 673R_OSMIAUTOMTBondsFiled.xml 673R_OSMIAUTOMTBondsFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey7 0 $PayerNo1 $RecipNo70 673R_OSMIAUTONYBondsFiled.xml 673R_OSMIAUTONYBondsFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey8 0 $PayerNo1 $RecipNo80 673R_OSMIAUTORIBondsFiled.xml 673R_OSMIAUTORIBondsFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt true True




Assert Filed OSMI Mutual Funds details



ddt: SOAPNoNestedXMLClient http://ott-trusttax-sw-qa-use1-aws.tax.nonprod.int.thomsonreuters.com/PrepareOSMI.asmx SOAP:Action text/xml POST GetOSMIMutualFundFiledTemplate.xml
SRVNAME BANKDB PAN TAXYR TRUSTKEY TRUSTSEQ PAYERNO RECIPNO XMLExpectedPath XMLFileName ignorexmlmulitnodes hasMultiSchema COMPAREXML? actualDate nodeXpath hasMultiSchema assertDateInXML?
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo10 673R_OSMIAUTO001MutualFundFiled0.xml 673R_OSMIAUTO001MutualFundFiled0.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo11 673R_OSMIAUTO001MutualFundFiled1.xml 673R_OSMIAUTO001MutualFundFiled1.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo12 673R_OSMIAUTO001MutualFundFiled2.xml 673R_OSMIAUTO001MutualFundFiled2.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo13 673R_OSMIAUTO001MutualFundFiled3.xml 673R_OSMIAUTO001MutualFundFiled3.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo14 673R_OSMIAUTO001MutualFundFiled4.xml 673R_OSMIAUTO001MutualFundFiled4.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo15 673R_OSMIAUTO001MutualFundFiled5.xml 673R_OSMIAUTO001MutualFundFiled5.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey1 0 $PayerNo1 $RecipNo16 673R_OSMIAUTO001MutualFundFiled6.xml 673R_OSMIAUTO001MutualFundFiled6.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey2 0 $PayerNo1 $RecipNo20 673R_OSMIAUTOCAMutualFundFiled.xml 673R_OSMIAUTOCAMutualFundFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey3 0 $PayerNo1 $RecipNo30 673R_OSMIAUTOCTMutualFundFiled.xml 673R_OSMIAUTOCTMutualFundFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey4 0 $PayerNo1 $RecipNo40 673R_OSMIAUTOMAMutualFundFiled.xml 673R_OSMIAUTOMAMutualFundFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey5 0 $PayerNo1 $RecipNo50 673R_OSMIAUTOMNMutualFundFiled.xml 673R_OSMIAUTOMNMutualFundFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey6 0 $PayerNo1 $RecipNo60 673R_OSMIAUTOMTMutualFundFiled.xml 673R_OSMIAUTOMTMutualFundFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey7 0 $PayerNo1 $RecipNo70 673R_OSMIAUTONYMutualFundFiled.xml 673R_OSMIAUTONYMutualFundFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True
$SRVNAME1 $BANKDB1 673R 2023 $Trustkey8 0 $PayerNo1 $RecipNo80 673R_OSMIAUTORIMutualFundFiled.xml 673R_OSMIAUTORIMutualFundFiled.xml true true Both XML Files are Equal $TodayDate /Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt true True

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