Included page: .FrontPage.QA.BalanceDue.2024.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\2024\BatchAutomation\BalanceDue |
| DownloadPath | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue\Actuals |
| SourceDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2024\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\2024\BatchAutomation\BalanceDue |
| ExpectedDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue |
| ActualDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue\Actuals |
| ResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2024\BatchAutomation\BalanceDue |
| Debug | TRUE |
| ignorePathValidations | false |
| DeleteFile | true |
| import |
| TBOT.Generic.Database |
> Execute BTM Package
| ddt: KeywordFixture | SELECT DB_NAME , 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 | DB_NAME? | Server? | AcctNo? | Tax_Year? | Seq_Number? | GETNEXTWORKINGDAY? |
| Test0001 | 5010 | 2024 | 1 | 1 | $DBName1= | $Server1= | $AcctNo1= | $Tax_Year1= | $Seq_Number1= | $SetDate1= |
Get Filename
Get Filename
| ddt: DynamicQuery | declare @filename nvarchar(max) set @filename = '{{FileVal}}' select @filename as FileName | |
| Comments# | FileVal | FileName? |
| Test0001 | massachusettsActual.txt | $File1= |
Capturing Action Date
Execute BTMDB..Package
| ddt: DynamicQuery | SELECT LTRIM(RTRIM(Server)) AS Server, LTRIM(RTRIM(DB_NAME)) AS DB_NAME , AcctNo,'{{TaxYear}}' AS Tax_Year, '{{SeqNumber}}' as Seq_Number, CONVERT(varchar(10),getdate(),111) as ActionDate FROM BTMDB.dbo.Package WHERE AcctNo='{{PAN}}' | |||||||
| Comments# | PAN | TaxYear | SeqNumber | DB_NAME? | AcctNo? | Tax_Year? | Seq_Number? | ActionDate? |
| Test0001 | 5010 | 2024 | 1 | $DBName1= | $AcctNo1= | $Tax_Year1= | $Seq_Number1= | $Action_DT1= |
Download File
Download Block
| DDT: KeywordFixture | SELECT DataObject, Action_Cd, CONVERT(varchar(10),Action_DT,111) as Action_DT FROM {{DataBaseName}}.dbo.BankData WHERE AcctNo='{{PAN}}' and Year={{TaxYear}} and State='MA' and ProdOpt=107 and Product_Cd='F' and SeqNo='{{SeqNumber}}' | |||||||||||
| Comment | PAN | TaxYear | SeqNumber | DataBaseName | FileName | Action_Cd? | Action_DT? | DataObject? | DOWNLOAD? | DateInput | DateFormat | FORMATDATE? |
| Test0001 | $AcctNo1 | $Tax_Year1 | $Seq_Number1 | $DBName1 | $File1 | 1 | $Action_DT1 | System.Byte[] | True | $SetDate1 | MMddyyyy | $FormateDate1= |
Validate Filing Status
| ddt:DynamicQuery | EXEC {{DataBaseName}}.BANKDB_P.spGetBalDueFilingData '{{PAN}}', {{YEAR}},{{SeqNumber}} | Filing = 'Massachusetts' | ||||
| Comments# | PAN | YEAR | SeqNumber | DataBaseName | FilingType | IsFiled? |
| Test0001 | 5010 | 2024 | $Seq_Number1 | $DBName1 | Massachusetts | True |
******!
File Compare
!*****> Compare two Files| TBOT.Generic.SFTP | |||||
| Comments | sourceFile | destinationFile | resultFileName | IgnorePattern | compareFiles? |
| Test0001 | massachusettsBase.txt | $File1 | $FormateDate1;02182025 | Both 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