Included page: .FrontPage.QA.Archive.ServiceAutomation.NRA.2022.SetUp (edit)
| import |
| TBOT.Generic.Database |
!*****> Setup
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100 |
| BytesColumn | DataObject |
| FileExtension | txt |
| ExpectedDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2022\BatchAutomation\NRA-new |
| ExpectedDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2022\BatchAutomation\NRA-new\DataFiles |
| ActualDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\NRA-new |
| ResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2022\BatchAutomation\NRA-new |
| DownloadPath | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\NRA-new\DataFiles |
| CompareResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2022\BatchAutomation\NRA-new |
| ignoreNodes | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRARecipInfo/Filing_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Filing_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Filing_Dt_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueFormID;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueFormID_Fl;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueFormID_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Compute_Dt_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Compute_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAWAInfo/Filing_Dt;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueID;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Error_Cd;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/Error_Cd_Ovr;/Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo/NRAUniqueID_Ovr;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/design/columns/column/columnid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/design/functions/function/functionid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/design/tables/table/tableid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/design/tableproperties/tableproperty/tablepropertyid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/design/orderbys//orderby/orderbyid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/runtime/batchid;/Envelope/Body/ProcessRegister_UntypedResponse/ProcessRegister_UntypedResult/register/runtime/starttime |
| 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? |
| NRA1 | 2022 | $PAN1= | $TAXYR1= | $BANKDB1= | $SRVNAME1= |
| ddt:DynamicQuery | WAITFOR DELAY '00:00:00' Use {{BANKDB}} Select SUBSTRING('{{Yrseq}}',1,4) As YEAR, B.TRUSTNO, convert(varchar(10),TxYrBegin_Dt,101) AS BEGINTAXYR,convert(varchar(10),TxYrEnd_Dt,101)ENDTAXYR,A.TRUSTKEY,A.PERMSEQ from Trust A Join TrustXRef B On A.TrustKey=B.TrustKey Join TrustPerm C On A.TrustKey=C.TrustKey where Yrseq={{Yrseq}} and TrustNo='{{TrustNo}}' | |||||||
| BANKDB | Yrseq | TrustNo | YEAR? | TRUSTNO? | BEGINTAXYR? | ENDTAXYR? | TRUSTKEY? | PERMSEQ? |
| $BANKDB1 | 20220 | NRASINGLEBENE | $Year1= | $TrustNo1= | $BeginDt1= | $EndDt1= | $TrustKey1= | $PermSeq1= |
| $BANKDB1 | 20220 | NRAINCOMECD | $Year2= | $TrustNo2= | $BeginDt2= | $EndDt2= | $TrustKey2= | $PermSeq2= |
| $BANKDB1 | 20220 | NRAMULTIBENE2 | $Year3= | $TrustNo3= | $BeginDt3= | $EndDt3= | $TrustKey3= | $PermSeq3= |
| $BANKDB1 | 20220 | NRAMULTIPLEBENE | $Year4= | $TrustNo4= | $BeginDt4= | $EndDt4= | $TrustKey4= | $PermSeq4= |
| $BANKDB1 | 20220 | NRASUBID100 | $Year5= | $TrustNo5= | $BeginDt5= | $EndDt5= | $TrustKey5= | $PermSeq5= |
| $BANKDB1 | 20220 | NRAWSCASSET | $Year6= | $TrustNo6= | $BeginDt6= | $EndDt6= | $TrustKey6= | $PermSeq6= |
| $BANKDB1 | 20220 | BOABEN | $Year7= | $TrustNo7= | $BeginDt7= | $EndDt7= | $TrustKey7= | $PermSeq7= |
| $BANKDB1 | 20220 | BOAECI | $Year8= | $TrustNo8= | $BeginDt8= | $EndDt8= | $TrustKey8= | $PermSeq8= |
| $BANKDB1 | 20220 | BOAEXP | $Year9= | $TrustNo9= | $BeginDt9= | $EndDt9= | $TrustKey9= | $PermSeq9= |
| $BANKDB1 | 20220 | BOAFWQI | $Year10= | $TrustNo10= | $BeginDt10= | $EndD106= | $TrustKey10= | $PermSeq10= |
| $BANKDB1 | 20220 | BOAQI | $Year11= | $TrustNo11= | $BeginDt11= | $EndDt11= | $TrustKey11= | $PermSeq11= |
| $BANKDB1 | 20220 | NRABOA | $Year12= | $TrustNo12= | $BeginDt12= | $EndDt12= | $TrustKey12= | $PermSeq12= |
| $BANKDB1 | 20220 | NRA2NDCORREC | $Year13= | $TrustNo13= | $BeginDt13= | $EndDt13= | $TrustKey13= | $PermSeq13= |
| $BANKDB1 | 20220 | NRA3RDCORREC | $Year14= | $TrustNo14= | $BeginDt14= | $EndDt14= | $TrustKey14= | $PermSeq14= |
| ddt: SOAPNoNestedXMLClient | http://ott-trusttax-sw-qa-use1-aws.tax.nonprod.int.thomsonreuters.com/ten42sforms.asmx | SOAP:Action | text/xml | POST | Assert1042Template.xml | ||||||||||||
| SRVNAME | BANKDB | PAN | TAXYR | USERID | CHNGINI | TRUSTNO | BEGINTAXYR | ENDTAXYR | TRUSTKEY | TRUSTSEQ | PERMSEQ | NRARECIPNO | XMLExpectedPath | XMLFileName | ignorexmlmulitnodes | hasMultiSchema | COMPAREXML? |
| PSRV1 | $BANKDB1 | NRA1 | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo1 | $BeginDt1 | $EndDt1 | $TrustKey1 | 0 | $PermSeq1 | 1 | SINGLEBENENRA1.xml | SINGLEBENENRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year2 | OFFSHORE-Tasleem Fathima | TF | $TrustNo2 | $BeginDt2 | $EndDt2 | $TrustKey2 | 0 | $PermSeq2 | 1 | INCOMECDNRA1.xml | INCOMECDNRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year3 | OFFSHORE-Tasleem Fathima | TF | $TrustNo3 | $BeginDt3 | $EndDt3 | $TrustKey3 | 0 | $PermSeq3 | 1 | MULTIBENE21NRA1.xml | MULTIBENE21NRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year3 | OFFSHORE-Tasleem Fathima | TF | $TrustNo3 | $BeginDt3 | $EndDt3 | $TrustKey3 | 0 | $PermSeq3 | 2 | MULTIBENE22NRA1.xml | MULTIBENE22NRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year3 | OFFSHORE-Tasleem Fathima | TF | $TrustNo3 | $BeginDt3 | $EndDt3 | $TrustKey3 | 0 | $PermSeq3 | 3 | MULTIBENE23NRA1.xml | MULTIBENE23NRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year4 | OFFSHORE-Tasleem Fathima | TF | $TrustNo4 | $BeginDt4 | $EndDt4 | $TrustKey4 | 0 | $PermSeq4 | 1 | MULTIPLEBENE1NRA1.xml | MULTIPLEBENE1NRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year4 | OFFSHORE-Tasleem Fathima | TF | $TrustNo4 | $BeginDt4 | $EndDt4 | $TrustKey4 | 0 | $PermSeq4 | 2 | MULTIPLEBENE2NRA1.xml | MULTIPLEBENE2NRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 1 | SUBID1001NRA1.xml | SUBID1001NRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 2 | SUBID1002NRA1.xml | SUBID1002NRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year5 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 3 | SUBID1003NRA1.xml | SUBID1003NRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year6 | OFFSHORE-Tasleem Fathima | TF | $TrustNo6 | $BeginDt6 | $EndDt6 | $TrustKey6 | 0 | $PermSeq6 | 1 | WSCASSETNRA1.xml | WSCASSETNRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year7 | OFFSHORE-Tasleem Fathima | TF | $TrustNo7 | $BeginDt7 | $EndDt7 | $TrustKey7 | 0 | $PermSeq7 | 1 | BOABENNRA1.xml | BOABENNRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year8 | OFFSHORE-Tasleem Fathima | TF | $TrustNo8 | $BeginDt8 | $EndDt8 | $TrustKey8 | 0 | $PermSeq8 | 1 | BOAECINRA1.xml | BOAECINRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year9 | OFFSHORE-Tasleem Fathima | TF | $TrustNo9 | $BeginDt9 | $EndDt9 | $TrustKey9 | 0 | $PermSeq9 | 1 | BOAEXPNRA1.xml | BOAEXPNRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year10 | OFFSHORE-Tasleem Fathima | TF | $TrustNo10 | $BeginDt10 | $EndDt10 | $TrustKey10 | 0 | $PermSeq10 | 1 | BOAFWQINRA1.xml | BOAFWQINRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year11 | OFFSHORE-Tasleem Fathima | TF | $TrustNo11 | $BeginDt11 | $EndDt11 | $TrustKey11 | 0 | $PermSeq11 | 1 | BOAQINRA1.xml | BOAQINRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year12 | OFFSHORE-Tasleem Fathima | TF | $TrustNo12 | $BeginDt12 | $EndDt12 | $TrustKey12 | 0 | $PermSeq12 | 1 | NRABOANRA1.xml | NRABOANRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year13 | OFFSHORE-Tasleem Fathima | TF | $TrustNo13 | $BeginDt13 | $EndDt13 | $TrustKey13 | 0 | $PermSeq13 | 1 | NRA2NDCORRECNRA1.xml | NRA2NDCORRECNRA1.xml | true | true | Both XML Files are Equal |
| PSRV1 | $BANKDB1 | NRA1 | $Year14 | OFFSHORE-Tasleem Fathima | TF | $TrustNo14 | $BeginDt14 | $EndDt14 | $TrustKey14 | 0 | $PermSeq14 | 1 | NRA3RDCORRECNRA1.xml | NRA3RDCORRECNRA1.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