Included page: .FrontPage.QA.WebDelivery.SetUp (edit)

Contents:


import
TBOT.Generic.Database


ddt: SetUp
key value
ConnectionString Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100;Timeout=45
BytesColumn DataObject
FileExtension ZIP
ExpectedDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery
DownloadPath \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery
ExpectedDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery
ActualDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery
SourceDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery
TargetDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery
CompareResultDir \ProcessngCompute\Year2020\CompareResult
ResultDir \ProcessngCompute\Year2020\CompareResult
ignorePathValidations false
DeleteFile true
Debug TRUE

import
TBOT.Generic.Database

import
TBOT.Generic

ddt:DynamicQuery SELECT A.AcctNo AS PAN,'{{TaxYear}}' AS TAXYR, LTRIM(RTRIM(DB_Name)) as DB_Name, LTRIM(RTRIM(Server)) as Server FROM BTMDB.dbo.PACKAGE A WHERE AcctNo='{{ACCTNO}}'
ACCTNO TaxYear DB_Name? Server?
311D 2024 $BANKDB1= $SRVNAME1=


Getting Recipient ID


ddt:DynamicQuery select LTRIM(RTRIM(BP.BeneID)) as RecipID from {{DBName}}..BenePerm BP join {{DBName}}..TrustXref TX on BP.TrustKey=Tx.TrustKey where Tx.AcctNo='{{PAN}}' and Tx.TrustNo='{{TrustNumber}}' and BP.BeneNo={{BeneNo}} and BP.ChngType <>3
Comments DBName PAN YEAR TrustNumber BeneNo RecipID?
1041-Federal and state $BANKDB1 311D 2024 000122 1 $RecipID1=
1041-Federal and state $BANKDB1 311D 2024 000122 2 $RecipID2=
1041-Federal and state $BANKDB1 311D 2024 000122 3 $RecipID3=
1041-Federal and state $BANKDB1 311D 2024 000122 4 $RecipID4=
1041-Federal and state $BANKDB1 311D 2024 000122 5 $RecipID5=
1041-Federal and state-Grantor $BANKDB1 311D 2024 0002316910 1 $RecipID6=
1041-Federal and state-Grantor $BANKDB1 311D 2024 0002316910 2 $RecipID7=
1041-Federal and state-Agent $BANKDB1 311D 2024 11007954 1 $RecipID8=
1041-Federal and state-1042s $BANKDB1 311D 2024 115183006 1 $RecipID9=



ddt: SOAPNoNestedXMLClient https://10.153.120.64:9400/RecipList.aspx SOAP:Action text/xml POST TemplateRecipList.xml
Comments CLIENT_ID CLIENT_PWD USER_ID USER_PWD TRUST_ACCOUNT_ID FT_ACCOUNT_ID TAX_YEAR RECIP_TAX_ID XMLFileName STATUSCODE? nodeXpath ASSERTXML?
1041-Federal and state TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 000122 311D 2024 $RecipID1 1041Recip1.xml OK DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY $PackageKey1=
1041-Federal and state TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 000122 311D 2024 $RecipID2 1041Recip2.xml OK DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY $PackageKey2=
1041-Federal and state TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 000122 311D 2024 $RecipID3 1041Recip3.xml OK DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY $PackageKey3=
1041-Federal and state TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 000122 311D 2024 $RecipID4 1041Recip4.xml OK DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY $PackageKey4=
1041-Federal and state TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 000122 311D 2024 $RecipID5 1041Recip5.xml OK DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY $PackageKey5=
1041-Federal and state-Grantor TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 0002316910 311D 2024 $RecipID6 1041Recip6.xml OK DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY $PackageKey6=
1041-Federal and state-Grantor TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 0002316910 311D 2024 $RecipID7 1041Recip7.xml OK DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY $PackageKey7=
1041-Federal and state-Agent TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 11007954 311D 2024 $RecipID8 1041Recip8.xml OK DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY $PackageKey8=
1041-Federal and state-1042s TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 115183006 311D 2024 $RecipID9 1041Recip9.xml OK DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY $PackageKey9=


ddt: SOAPNoNestedXMLClient https://10.153.120.64:9400/RecipDocument.aspx SOAP:Action text/xml POST TemplateRecipDoc.xml
Comments CLIENT_ID CLIENT_PWD USER_ID USER_PWD PACKAGE_KEY XMLFileName STATUSCODE? nodeXpath FileName DOWNLOADFILEFROMXML?
1041-Federal and state TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 $PackageKey1 1041Recipdoc1.xml OK DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF 1041Recipdoc1.pdf True
1041-Federal and state TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 $PackageKey2 1041Recipdoc2.xml OK DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF 1041Recipdoc2.pdf True
1041-Federal and state TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 $PackageKey3 1041Recipdoc3.xml OK DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF 1041Recipdoc3.pdf True
1041-Federal and state TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 $PackageKey4 1041Recipdoc4.xml OK DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF 1041Recipdoc4.pdf True
1041-Federal and state TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 $PackageKey5 1041Recipdoc5.xml OK DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF 1041Recipdoc5.pdf True
1041-Federal and state-Grantor TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 $PackageKey6 1041Recipdoc6.xml OK DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF 1041Recipdoc6.pdf True
1041-Federal and state-Grantor TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 $PackageKey7 1041Recipdoc7.xml OK DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF 1041Recipdoc7.pdf True
1041-Federal and state-Agent TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 $PackageKey8 1041Recipdoc8.xml OK DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF 1041Recipdoc8.pdf True
1041-Federal and state-1042s TESTCLIENT1 WinterTime1 WEBDELUSER WD$12345 $PackageKey9 1041Recipdoc9.xml OK DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF 1041Recipdoc9.pdf True