Included page: .FrontPage.QA.Archive.ServiceAutomation.NRAOrForm1042s.SetUp (edit)

import
TBOT.Generic.Database

!*****> Setup
ddt: SetUp
key value
ConnectionString Server=10.184.25.4,1601;database=AUTOTESTING;User Id=tfathima; password=tfathima*100
BytesColumn DataObject
FileExtension txt
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
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 \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2017\BatchAutomation\NRA
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 WAITFOR DELAY '00:00:00' 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:00' 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/document.asmx SOAP:Action text/xml POST TemplateMakeBankDataBill.xml MakeBankDataBill
CLIENTID PAN USERINI SRVNAME BANKDB TAXYR PRODUCTCODE PRODOPT DOCSEQNO OBJECTCD UNITS ACTIONCD WRITEBILL XMLFileName STATUSCODE?
OFFSHORE-Tasleem Fathima $PAN1 TF $SRVNAME1 $BANKDB1 $TAXYR1 $ProductCd1 0 1 0 0 1 true FileDtStamp.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
Close