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:10' 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 | 1042-S Filing Request | $ProductCd1= |
| 3010 | Needs attention | $StatusCode1= |
| 3010 | Pending | $StatusCode2= |
| 3001 | Compute | $EventType1= |
| ddt:DynamicQuery | WAITFOR DELAY '00:00:10' SELECT A.AcctNo AS PAN,2017 AS TAXYR, LTRIM(RTRIM(DB_Name)) as DB_Name, LTRIM(RTRIM(Server)) as Server FROM BTMDB.dbo.PACKAGE A WHERE AcctNo='{{ACCTNO}}' | |||
| ACCTNO | PAN? | TAXYR? | DB_Name? | Server? |
| 308U | $PAN1= | $TAXYR1= | $BANKDB1= | $SRVNAME1= |
| ddt: SOAPNoNestedXMLClient | http://10.184.7.166:9510/BatchRequest.asmx | SOAP:Action | text/xml | POST | TemplateAcctWIP.xml | |||
| SRVNAME | BANKDB | PAN | TAXYR | PRODUCTCODE | STATUSCODE | PRODOPT | XMLFileName | STATUSCODE? |
| $SRVNAME1 | $BANKDB1 | $PAN1 | $TAXYR1 | $ProductCd1 | $StatusCode1 | 0 | AcctWIPDelete.xml | OK |
| ddt: SOAPNoNestedXMLClient | http://10.184.7.166:9510/BatchRequest.asmx | SOAP:Action | text/xml | POST | TemplateAcctWIPInsert.xml | |||||||
| SRVNAME | BANKDB | PAN | TAXYR | PRODUCTCODE | EVENTTYPE | PRIORITY | LOGIN | STATUSCODE | PRODOPT | PROCESSOPT | XMLFileName | STATUSCODE? |
| $SRVNAME1 | $BANKDB1 | $PAN1 | $TAXYR1 | $ProductCd1 | C | R | TF | $StatusCode2 | 0 | $ACCT=308U$YEAR=2017$FILE=2 A=PRD | AcctWIPInsert.xml | OK |
| ddt: SOAPNoNestedXMLClient | http://10.184.7.166:9510/BatchRequest.asmx | SOAP:Action | text/xml | POST | TemplateQueueProcess.xml | |||||||||
| SRVNAME | BANKDB | PAN | TAXYR | KEYFIELD | PRODUCTCODE | PRODOPT | QUEUENAME | PROCESSCODE | PARAM | LOCATOR | PERMSEQ | MODE | XMLFileName | STATUSCODE? |
| $SRVNAME1 | $BANKDB1 | $PAN1 | $TAXYR1 | 308UZ | $ProductCd1 | 0 | TEZIN-FST | 275 | $ACCT=308U$YEAR=2017$FILE=2 A=PRD | 000000 | 0 | PRD | QueueProcess.xml | OK |
| ddt: SOAPNoNestedXMLClient | http://10.184.7.166:9510/BatchRequest.asmx | SOAP:Action | text/xml | POST | TemplateGetAcctWIP.xml | ||
| SRVNAME | BANKDB | PAN | TAXYR | PRODUCTCODE | YRSPECIFIC | XMLFileName | STATUSCODE? |
| $SRVNAME1 | $BANKDB1 | $PAN1 | $TAXYR1 | $ProductCd1 | true | GetAcctWIP.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