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 AR | 311D | ARELF1 | 2020 | Tax return | State Only | True | $Server1= | $BANKDB1= | $TrustKey1= | $YrSeq1= | $ComputeDate1= |
| Test 002 AR | 311D | ARELF2 | 2020 | Tax return | State Only | True | $Server2= | $BANKDB2= | $TrustKey2= | $YrSeq2= | $ComputeDate2= |
| Test 003 AR | 311D | ARELF3 | 2020 | Tax return | State Only | True | $Server3= | $BANKDB3= | $TrustKey3= | $YrSeq3= | $ComputeDate3= |
| Test 004 AR | 311D | ARELF4 | 2020 | Tax return | State Only | True | $Server4= | $BANKDB4= | $TrustKey4= | $YrSeq4= | $ComputeDate4= |
| Test 005 AR | 311D | ARELF5 | 2020 | Tax return | State Only | True | $Server5= | $BANKDB5= | $TrustKey5= | $YrSeq5= | $ComputeDate5= |
| Test 006 AR | 311D | ARELF6 | 2020 | Tax return | State Only | True | $Server6= | $BANKDB6= | $TrustKey6= | $YrSeq6= | $ComputeDate6= |
| Test 007 AR | 311D | ARELF939 | 2020 | Tax return | State Only | True | $Server7= | $BANKDB7= | $TrustKey7= | $YrSeq7= | $ComputeDate7= |
| Test 008 AR | 311D | ARELFNR1 | 2020 | Tax return | State Only | True | $Server8= | $BANKDB8= | $TrustKey8= | $YrSeq8= | $ComputeDate8= |
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 | AR | ARELF1.xar | ARELF1.zip | /ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server2 | $BANKDB2 | $TrustKey2 | $YrSeq2 | $ComputeDate2 | AR | ARELF2.xar | ARELF2.zip | /ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server3 | $BANKDB3 | $TrustKey3 | $YrSeq3 | $ComputeDate3 | AR | ARELF3.xar | ARELF3.zip | /ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server4 | $BANKDB4 | $TrustKey4 | $YrSeq4 | $ComputeDate4 | AR | ARELF4.xar | ARELF4.zip | /ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server5 | $BANKDB5 | $TrustKey5 | $YrSeq5 | $ComputeDate5 | AR | ARELF5.xar | ARELF5.zip | /ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server6 | $BANKDB6 | $TrustKey6 | $YrSeq6 | $ComputeDate6 | AR | ARELF6.xar | ARELF6.zip | /ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server7 | $BANKDB7 | $TrustKey7 | $YrSeq7 | $ComputeDate7 | AR | ARELF939.xar | ARELF939.zip | /ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server8 | $BANKDB8 | $TrustKey8 | $YrSeq8 | $ComputeDate8 | AR | ARELFNR1.xar | ARELFNR1.zip | /ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/ReturnHeaderState/ReturnTs | 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