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 DE | 311D | 2641002513 | 2020 | Tax return | State Only | True | $Server1= | $BANKDB1= | $TrustKey1= | $YrSeq1= | $ComputeDate1= |
| Test 002 DE | 311D | DE2007 | 2020 | Tax return | State Only | True | $Server2= | $BANKDB2= | $TrustKey2= | $YrSeq2= | $ComputeDate2= |
| Test 003 DE | 311D | 42266007 | 2020 | Tax return | State Only | True | $Server3= | $BANKDB3= | $TrustKey3= | $YrSeq3= | $ComputeDate3= |
| Test 004 DE | 311D | 56011042 | 2020 | Tax return | State Only | True | $Server4= | $BANKDB4= | $TrustKey4= | $YrSeq4= | $ComputeDate4= |
| Test 005 DE | 311D | DE400V1 | 2020 | Tax return | State Only | True | $Server5= | $BANKDB5= | $TrustKey5= | $YrSeq5= | $ComputeDate5= |
| Test 006 DE | 311D | DEFINAL1 | 2020 | Tax return | State Only | True | $Server6= | $BANKDB6= | $TrustKey6= | $YrSeq6= | $ComputeDate6= |
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 | DE | 2641002513.xde | 2641002513.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail | True | True | True | Both XML Files are Equal |
| $Server2 | $BANKDB2 | $TrustKey2 | $YrSeq2 | $ComputeDate2 | DE | DE2007.xde | DE2007.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail | True | True | True | Both XML Files are Equal |
| $Server3 | $BANKDB3 | $TrustKey3 | $YrSeq3 | $ComputeDate3 | DE | 42266007.xde | 42266007.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail | True | True | True | Both XML Files are Equal |
| $Server4 | $BANKDB4 | $TrustKey4 | $YrSeq4 | $ComputeDate4 | DE | 56011042.xde | 56011042.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail | True | True | True | Both XML Files are Equal |
| $Server5 | $BANKDB5 | $TrustKey5 | $YrSeq5 | $ComputeDate5 | DE | DE400V1.xde | DE400V1.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail | True | True | True | Both XML Files are Equal |
| $Server6 | $BANKDB6 | $TrustKey6 | $YrSeq6 | $ComputeDate6 | DE | DEFINAL1.xde | DEFINAL1.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