Included page: .FrontPage.QA.BalanceDue.2022.QA.SetUp (edit)
import |
TBOT.Generic.Database |
ddt: SetUp | |
key | value |
ConnectionString | Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100; Timeout=30 |
BytesColumn | DataObject |
FileExtension | ZIP |
ExpectedDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue |
DownloadPath | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue\Actuals |
SourceDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue\Actuals |
TargetDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\OTTDataQA\TrustElf\acks\EFTPS\incoming |
CompareResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue |
ExpectedDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue |
ActualDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue\Actuals |
ResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue |
Debug | TRUE |
ignorePathValidations | false |
DeleteFile | true |
> Execute BTM Package
ddt: KeywordFixture | SELECT LTRIM(RTRIM(DB_NAME)) as DBNAME , LTRIM(RTRIM(Server)) as Server, AcctNo,'{{TaxYear}}' AS Tax_Year, '{{SeqNumber}}' as Seq_Number from BTMDB..Package where AcctNo='{{PAN}}' | ||||||||
Comments# | PAN | TaxYear | SeqNumber | WorkingDayStartCount | DBNAME? | Server? | AcctNo? | Tax_Year? | Seq_Number? |
Test0001 | 5010 | 2022 | 1 | 2 | $DBName1= | $Server1= | $AcctNo1= | $Tax_Year1= | $Seq_Number1= |
> Filing status Validations
ddt:DynamicQuery | WAITFOR DELAY '00:00:10';EXEC {{DataBaseName}}.BANKDB_P.spGetBalDueFilingData '{{PAN}}', {{YEAR}},{{SeqNumber}} | Filing = 'Federal and State Tax History Back-End file' | ||||
Comments# | PAN | YEAR | SeqNumber | DataBaseName | FilingType | FiledStatus? |
Test0001 | 5010 | 2022 | $Seq_Number1 | $DBName1 | Federal and State Tax History Back-End file | Complete |
Download and Validate XML
DDT:KeywordFixture | select DataObject from {{DataBaseName}}..bankdata where acctno='{{AcctNo}}'and year='{{TaxYear}}' and product_cd='{{ProdCd}}' | ||||||||||
AcctNo | TaxYear | ProdCd | DataBaseName | XMLExpectedFilename | EfileFileExtn | FileName | replaceNode | DOWNLOAD? | UNZIP? | GETEFILEXML? | COMPAREXML? |
5010 | 2022 | X | $DBName1 | FEDAndStateIncludeEstimatePayments.xml | tmp | FEDAndStateIncludeEstimatePayments.zip | /BackEnd/FileCreateDate;/BackEnd/ProgVer | 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