Included page: .FrontPage.QA.Archive.ServiceAutomation.NRASAT.SetUp (edit)
| import |
| TBOT.Generic.Database |
!*****> Setup
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.184.25.13,1605;database=AUTOTESTING;User Id=automation; password=automation*100 |
| BytesColumn | DataObject |
| FileExtension | txt |
| ExpectedDir | D:\Installations\FitNesseRoot\files\TrustTax\NRA\Baseline |
| ExpectedDirectory | D:\Installations\FitNesseRoot\files\TrustTax\NRA\Baseline\DataFiles |
| ActualDir | D:\Installations\FitNesseRoot\files\TrustTax\NRA\Actuals |
| ResultDir | D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results |
| DownloadPath | D:\Installations\FitNesseRoot\files\TrustTax\NRA\Actuals\DataFiles |
| CompareResultDir | D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results |
| 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 |
| import |
| TBOT.Generic.Database |
| import |
| TBOT.Generic |
| ddt:DynamicQuery | WAITFOR DELAY '00:00:20' Use BANKDB02 Select 2017 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}}' | ||||||
| Yrseq | TrustNo | YEAR? | TRUSTNO? | BEGINTAXYR? | ENDTAXYR? | TRUSTKEY? | PERMSEQ? |
| 20170 | NRASINGLEBENE | $Year1= | $TrustNo1= | $BeginDt1= | $EndDt1= | $TrustKey1= | $PermSeq1= |
| 20170 | NRAMULTIPLEBENE | $Year1= | $TrustNo2= | $BeginDt2= | $EndDt2= | $TrustKey2= | $PermSeq2= |
| 20170 | NRAINCOMECD | $Year1= | $TrustNo3= | $BeginDt3= | $EndDt3= | $TrustKey3= | $PermSeq3= |
| 20170 | NRASUBID100 | $Year1= | $TrustNo4= | $BeginDt4= | $EndDt4= | $TrustKey4= | $PermSeq4= |
| 20170 | NRAMULTIBENE2 | $Year1= | $TrustNo5= | $BeginDt5= | $EndDt5= | $TrustKey5= | $PermSeq5= |
| 20170 | NRA2NDCORREC | $Year1= | $TrustNo6= | $BeginDt6= | $EndDt6= | $TrustKey6= | $PermSeq6= |
| 20170 | NRA3RDCORREC | $Year1= | $TrustNo7= | $BeginDt7= | $EndDt7= | $TrustKey7= | $PermSeq7= |
| ddt:DynamicQuery | WAITFOR DELAY '00:00:05' Use BANKDB02 Select NRAUniqueFormID,NRAUniqueFormID_Fl from NRAExtract where TrustKey={{TRUSTKEY}} and NRARecipNo={{NRARECIPNO}} and SeqNo={{SEQNO}} | |||
| TRUSTKEY | NRARECIPNO | SEQNO | NRAUniqueFormID? | NRAUniqueFormID_Fl? |
| $TrustKey1 | 1 | 1 | $NRAUniqueFormID1= | $NRAUniqueFormID_Fl1= |
| $TrustKey1 | 1 | 2 | $NRAUniqueFormID2= | $NRAUniqueFormID_Fl2= |
| $TrustKey2 | 1 | 1 | $NRAUniqueFormID3= | $NRAUniqueFormID_Fl3= |
| $TrustKey2 | 1 | 2 | $NRAUniqueFormID4= | $NRAUniqueFormID_Fl4= |
| $TrustKey3 | 1 | 1 | $NRAUniqueFormID5= | $NRAUniqueFormID_Fl5= |
| $TrustKey4 | 1 | 4 | $NRAUniqueFormID6= | $NRAUniqueFormID_Fl6= |
| $TrustKey5 | 1 | 4 | $NRAUniqueFormID7= | $NRAUniqueFormID_Fl7= |
| $TrustKey6 | 1 | 4 | $NRAUniqueFormID8= | $NRAUniqueFormID_Fl8= |
| $TrustKey7 | 1 | 4 | $NRAUniqueFormID9= | $NRAUniqueFormID_Fl9= |
| ddt: SOAPNoNestedXMLClient | http://10.184.7.166:9510/ten42sforms.asmx | SOAP:Action | text/xml | POST | Assert1042Template.xml | ||||||||||||
| SRVNAME | BANKDB | PAN | TAXYR | USERID | CHNGINI | TRUSTNO | BEGINTAXYR | ENDTAXYR | TRUSTKEY | TRUSTSEQ | PERMSEQ | NRARECIPNO | XMLFileName | STATUSCODE? | nodeXpath | hasMultiSchema | assertXML? |
| PSRV1 | BANKDB02 | 308U | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo1 | $BeginDt1 | $EndDt1 | $TrustKey1 | 0 | $PermSeq1 | 1 | NRASINGLEBENECorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/NRAUniqueFormID | true | $NRAUniqueFormID1 |
| PSRV1 | BANKDB02 | 308U | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo1 | $BeginDt1 | $EndDt1 | $TrustKey1 | 0 | $PermSeq1 | 1 | NRASINGLEBENECorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[2]/NRAUniqueFormID_Fl | true | $NRAUniqueFormID_Fl2 |
| PSRV1 | BANKDB02 | 308U | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo2 | $BeginDt2 | $EndDt2 | $TrustKey2 | 0 | $PermSeq2 | 1 | NRAMULTIPLEBENECorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/NRAUniqueFormID_Ovr | true | $NRAUniqueFormID3 |
| PSRV1 | BANKDB02 | 308U | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo2 | $BeginDt2 | $EndDt2 | $TrustKey2 | 0 | $PermSeq2 | 1 | NRAMULTIPLEBENECorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[2]/NRAUniqueFormID | true | $NRAUniqueFormID4 |
| PSRV1 | BANKDB02 | 308U | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo3 | $BeginDt3 | $EndDt3 | $TrustKey3 | 0 | $PermSeq3 | 1 | NRAINCOMECDCorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[1]/NRAUniqueFormID_Ovr | true | $NRAUniqueFormID5 |
| PSRV1 | BANKDB02 | 308U | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo4 | $BeginDt4 | $EndDt4 | $TrustKey4 | 0 | $PermSeq4 | 1 | NRASUBID100Corr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[4]/NRAUniqueFormID | true | $NRAUniqueFormID6 |
| PSRV1 | BANKDB02 | 308U | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo5 | $BeginDt5 | $EndDt5 | $TrustKey5 | 0 | $PermSeq5 | 1 | NRAMULTIBENE2Corr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[4]/NRAUniqueFormID | true | $NRAUniqueFormID7 |
| PSRV1 | BANKDB02 | 308U | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo6 | $BeginDt6 | $EndDt6 | $TrustKey6 | 0 | $PermSeq6 | 1 | NRA2NDCORRECCorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[4]/NRAUniqueFormID_Fl | true | $NRAUniqueFormID_Fl8 |
| PSRV1 | BANKDB02 | 308U | $Year1 | OFFSHORE-Tasleem Fathima | TF | $TrustNo7 | $BeginDt7 | $EndDt7 | $TrustKey7 | 0 | $PermSeq7 | 1 | NRA3RDCORRECCorr.xml | OK | /Envelope/Body/Get1042SFilingInfoResponse/Get1042SFilingInfoResult/diffgram/NewDataSet/NRAIncomeInfo[4]/NRAUniqueFormID_Fl | true | $NRAUniqueFormID_Fl9 |
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