Included page: .FrontPage.QA.Archive.ServiceAutomation.NRARollUp.SetUp (edit)
| import |
| TBOT.Generic.Database |
!*****> Setup
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.153.120.216,1600;database=AUTOTESTING;User Id=tfathima; password=tfathima*100 |
| BytesColumn | DataObject |
| FileExtension | zip |
| ExpectedDir | \\C605ZPUOTTFS2.tztst.loc\_QATeam\git\data-ott\IntegrationTests\BaselineFiles\Baseline\files\QA\YrSpecSuites\2017\BatchAutomation\NRA |
| ExpectedDirectory | \\C605ZPUOTTFS2.tztst.loc\_QATeam\git\data-ott\IntegrationTests\BaselineFiles\Baseline\files\QA\YrSpecSuites\2017\BatchAutomation\NRA\DataFiles |
| ActualDir | \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\NRA |
| TargetDirectory | \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\NRA\DataFiles |
| ResultDir | \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2017\BatchAutomation\NRA |
| DownloadPath | \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\NRA\DataFiles |
| CompareResultDir | \FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2017\BatchAutomation\NRA |
| ignorePathValidations | false |
| DeleteFile | true |
| NewYearFlag | false |
| skipIgnorePatterns | true |
| import |
| TBOT.Generic.Database |
| import |
| TBOT.Generic |
| ddt:DynamicQuery | WAITFOR DELAY '00:00:20' 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:20' 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? |
| 312G | $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 | AcctWIPDeleteRollUp.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=312G$YEAR=2017$FILE=0 A=PRD | AcctWIPInsertRollUp.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 | 312GZ | $ProductCd1 | 0 | TEZIN-FST | 275 | $ACCT=312G$YEAR=2017$FILE=0 A=PRD | 000000 | 0 | PRD | QueueProcessRollUp.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 | GetAcctWIPRollUp.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