Included page: .FrontPage.QA.Archive.1041.2020.Step4E-Filing.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 DataFile
FileExtension zip
ExpectedDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2020\BatchAutomation\1041Filing
DownloadPath \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\1041Filing
CompareResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2020\BatchAutomation\Compute\Results
ignoreXMLnodes /ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt




Check Compute Status

DDT: KeywordFixture SELECT A.ComputeFlag,A.TFDocFlag,TFDocJobId as JobID, LTRIM(RTRIM(DBName)) as BANKDB, Server,A.TrustKey,YrSeq, ComputeDate FROM AUTOTESTING.dbo.ComputeStats A WHERE A.AcctNo='{{AcctNo}}' AND A.TrustNo='{{TrustNo}}' AND A.YrSeq like'{{YrSeq}}%' AND A.ProductCode='{{ProductCode}}' AND A.ProductOption='{{ProductOption}}'
Comment AcctNo TrustNo YrSeq ProductCode ProductOption ComputeFlag? Server? BANKDB? TrustKey? YrSeq? ComputeDate?
Test 001 CT 311D QACT2 2020 Tax return State Only True $Server1= $BANKDB1= $TrustKey1= $YrSeq1= $ComputeDate1=
Test 002 CT 311D QACT1 2020 Tax return State Only True $Server2= $BANKDB2= $TrustKey2= $YrSeq2= $ComputeDate2=
Test 003 CT 311D QACT3 2020 Tax return State Only True $Server3= $BANKDB3= $TrustKey3= $YrSeq3= $ComputeDate3=
Test 004 CT 311D QACT4 2020 Tax return State Only True $Server4= $BANKDB4= $TrustKey4= $YrSeq4= $ComputeDate4=
Test 005 CT 311D QACT5 2020 Tax return State Only True $Server5= $BANKDB5= $TrustKey5= $YrSeq5= $ComputeDate5=








Download and Validate EfileXML

DDT:KeywordFixture SELECT B.DataFile from {{BANKDB}}.dbo.ElecFile A JOIN {{BANKDB}}.dbo.ElecFileData B ON A.TrustKey=B.TrustKey AND A.YrSeq=B.YrSeq AND A.FedIndSt=B.FedIndSt and A.Fed_Status_Flg='2' where A.TrustKey='{{TrustKey}}' and B.YrSeq='{{YrSeq}}' and A.FedIndSt='{{FedIndSt}}' and B.Compute_Dt_Tm>'{{ComputeDate}}'
Server BANKDB TrustKey YrSeq ComputeDate FedIndSt XMLExpectedFilename FileName replaceNode DOWNLOAD? UNZIP? GETEFILEXML? COMPAREXML?
$Server1 $BANKDB1 $TrustKey1 $YrSeq1 $ComputeDate1 CT QACT2.xct QACT2.zip /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail True True True Both XML Files are Equal
$Server2 $BANKDB2 $TrustKey2 $YrSeq2 $ComputeDate2 CT QACT1.xct QACT1.zip /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail True True True Both XML Files are Equal
$Server3 $BANKDB3 $TrustKey3 $YrSeq3 $ComputeDate3 CT QACT3.xct QACT3.zip /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail True True True Both XML Files are Equal
$Server4 $BANKDB4 $TrustKey4 $YrSeq4 $ComputeDate4 CT QACT4.xct QACT4.zip /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail True True True Both XML Files are Equal
$Server5 $BANKDB5 $TrustKey5 $YrSeq5 $ComputeDate5 CT QACT5.xct QACT5.zip /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail True 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
Close