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 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 OSMI Recipient details
| ddt: SOAPNoNestedXMLClient | http://ott-trusttax-sw-qa-use1-aws.tax.nonprod.int.thomsonreuters.com/PrepareOSMI.asmx | SOAP:Action | text/xml | POST | GetOSMIBEBankRecipTemplate.xml | ||||||
| SRVNAME | BANKDB | PAN | TAXYR | TRUSTKEY | TRUSTSEQ | RECIPNO | XMLExpectedPath | XMLFileName | ignorexmlmulitnodes | hasMultiSchema | COMPAREXML? |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey1 | 0 | $RecipNo10 | 673R_OSMIAUTO001updated0.xml | 673R_OSMIAUTO001updated0.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey1 | 0 | $RecipNo11 | 673R_OSMIAUTO001updated1.xml | 673R_OSMIAUTO001updated1.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey1 | 0 | $RecipNo12 | 673R_OSMIAUTO001updated2.xml | 673R_OSMIAUTO001updated2.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey1 | 0 | $RecipNo13 | 673R_OSMIAUTO001updated3.xml | 673R_OSMIAUTO001updated3.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey1 | 0 | $RecipNo14 | 673R_OSMIAUTO001updated4.xml | 673R_OSMIAUTO001updated4.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey1 | 0 | $RecipNo15 | 673R_OSMIAUTO001updated5.xml | 673R_OSMIAUTO001updated5.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey1 | 0 | $RecipNo16 | 673R_OSMIAUTO001updated6.xml | 673R_OSMIAUTO001updated6.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey2 | 0 | $RecipNo20 | 673R_OSMIAUTOCAupdated.xml | 673R_OSMIAUTOCAupdated.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey3 | 0 | $RecipNo30 | 673R_OSMIAUTOCTupdated.xml | 673R_OSMIAUTOCTupdated.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey4 | 0 | $RecipNo40 | 673R_OSMIAUTOMAupdated.xml | 673R_OSMIAUTOMAupdated.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey5 | 0 | $RecipNo50 | 673R_OSMIAUTOMNupdated.xml | 673R_OSMIAUTOMNupdated.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey6 | 0 | $RecipNo60 | 673R_OSMIAUTOMTupdated.xml | 673R_OSMIAUTOMTupdated.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey7 | 0 | $RecipNo70 | 673R_OSMIAUTONYupdated.xml | 673R_OSMIAUTONYupdated.xml | true | true | Both XML Files are Equal |
| $SRVNAME1 | $BANKDB1 | 673R | 2023 | $Trustkey8 | 0 | $RecipNo80 | 673R_OSMIAUTORIupdated.xml | 673R_OSMIAUTORIupdated.xml | true | true | Both XML Files are Equal |
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