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? |
| Test001 AL | 311D | ALELF1 | 2020 | Tax return | State Only | True | $Server1= | $BANKDB1= | $TrustKey1= | $YrSeq1= | $ComputeDate1= |
| Test 002 AL | 311D | ALELF3 | 2020 | Tax return | State Only | True | $Server2= | $BANKDB2= | $TrustKey2= | $YrSeq2= | $ComputeDate2= |
| Test 003 AL | 311D | ALELF5 | 2020 | Tax return | State Only | True | $Server3= | $BANKDB3= | $TrustKey3= | $YrSeq3= | $ComputeDate3= |
| Test 004 AL | 311D | ALELF7 | 2020 | Tax return | State Only | True | $Server4= | $BANKDB4= | $TrustKey4= | $YrSeq4= | $ComputeDate4= |
| Test 005 AL | 311D | ALELF8 | 2020 | Tax return | State Only | True | $Server5= | $BANKDB5= | $TrustKey5= | $YrSeq5= | $ComputeDate5= |
| Test 006 AL | 311D | ALELF9 | 2020 | Tax return | State Only | True | $Server6= | $BANKDB6= | $TrustKey6= | $YrSeq6= | $ComputeDate6= |
| Test 007 AL | 311D | ALELF11 | 2020 | Tax return | State Only | True | $Server7= | $BANKDB7= | $TrustKey7= | $YrSeq7= | $ComputeDate7= |
| Test 008 AL | 311D | ALELF2 | 2020 | Tax return | State Only | True | $Server8= | $BANKDB8= | $TrustKey8= | $YrSeq8= | $ComputeDate8= |
| Test 009 AL | 311D | ALELF4 | 2020 | Tax return | State Only | True | $Server9= | $BANKDB9= | $TrustKey9= | $YrSeq9= | $ComputeDate9= |
| Test 010 AL | 311D | ALELF6 | 2020 | Tax return | State Only | True | $Server10= | $BANKDB10= | $TrustKey10= | $YrSeq10= | $ComputeDate10= |
| Test 011 AL | 311D | ALELF14 | 2020 | Tax return | State Only | True | $Server11= | $BANKDB11= | $TrustKey11= | $YrSeq11= | $ComputeDate11= |
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 | AL | ALELF1.xal | ALELF1.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt;/ReturnState/ReturnDataState/Form41/Header/DateEntityCreated;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server2 | $BANKDB2 | $TrustKey2 | $YrSeq2 | $ComputeDate2 | AL | ALELF3.xal | ALELF3.zip | /ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/ReturnHeaderState/ReturnTs;/ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt | True | True | True | Both XML Files are Equal |
| $Server3 | $BANKDB3 | $TrustKey3 | $YrSeq3 | $ComputeDate3 | AL | ALELF5.xal | ALELF5.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt;/ReturnState/ReturnDataState/Form41/Header/DateEntityCreated;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server4 | $BANKDB4 | $TrustKey4 | $YrSeq4 | $ComputeDate4 | AL | ALELF7.xal | ALELF7.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt;/ReturnState/ReturnDataState/Form41/Header/DateEntityCreated;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server5 | $BANKDB5 | $TrustKey5 | $YrSeq5 | $ComputeDate5 | AL | ALELF8.xal | ALELF8.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt;/ReturnState/ReturnDataState/Form41/Header/DateEntityCreated;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server6 | $BANKDB6 | $TrustKey6 | $YrSeq6 | $ComputeDate6 | AL | ALELF9.xal | ALELF9.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt;/ReturnState/ReturnDataState/Form41/Header/DateEntityCreated;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server7 | $BANKDB7 | $TrustKey7 | $YrSeq7 | $ComputeDate7 | AL | ALELF11.xal | ALELF11.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt;/ReturnState/ReturnDataState/Form41/Header/DateEntityCreated;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server8 | $BANKDB8 | $TrustKey8 | $YrSeq8 | $ComputeDate8 | AL | ALELF2.xal | ALELF2.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt;/ReturnState/ReturnDataState/Form41/Header/DateEntityCreated;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server9 | $BANKDB9 | $TrustKey9 | $YrSeq9 | $ComputeDate9 | AL | ALELF4.xal | ALELF4.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt;/ReturnState/ReturnDataState/Form41/Header/DateEntityCreated;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server10 | $BANKDB10 | $TrustKey10 | $YrSeq10 | $ComputeDate10 | AL | ALELF6.xal | ALELF6.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt;/ReturnState/ReturnDataState/Form41/Header/DateEntityCreated;/ReturnState/ReturnHeaderState/ReturnTs | True | True | True | Both XML Files are Equal |
| $Server11 | $BANKDB11 | $TrustKey11 | $YrSeq11 | $ComputeDate11 | AL | ALELF14.xal | ALELF14.zip | /ReturnState/ReturnHeaderState/PaidPreparerInformationGrp/SignatureDt;/ReturnState/AuthenticationHeader/TransmissionDetail;/ReturnState/AuthenticationHeader/FilingHistory/FederalOriginalSubmissionIdDt;/ReturnState/ReturnDataState/Form41/Header/DateEntityCreated;/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