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 only | $BANKDB1 | 311D | 2024 | 001444 | 2 | $RecipID10= |
| 1041-Federal only-Grantor | $BANKDB1 | 311D | 2024 | 038987004 | 1 | $RecipID11= |
| 1041-Federal only-Agent | $BANKDB1 | 311D | 2024 | 101000078540 | 1 | $RecipID12= |
| 1041-Federal only-1042s | $BANKDB1 | 311D | 2024 | 000006007 | 1 | $RecipID13= |
| 1041-Federal only-1042s | $BANKDB1 | 311D | 2024 | 000006007 | 2 | $RecipID14= |
| 1041-Federal only-1042s | $BANKDB1 | 311D | 2024 | 000006007 | 3 | $RecipID15= |
| 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 only | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 001444 | 311D | 2024 | $RecipID10 | 1041Recip10.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey10= |
| 1041-Federal only-Grantor | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 038987004 | 311D | 2024 | $RecipID11 | 1041Recip11.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey11= |
| 1041-Federal only-Agent | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 101000078540 | 311D | 2024 | $RecipID12 | 1041Recip12.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey12= |
| 1041-Federal only-1042s | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 000006007 | 311D | 2024 | $RecipID13 | 1041Recip13.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey13= |
| 1041-Federal only-1042s | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 000006007 | 311D | 2024 | $RecipID14 | 1041Recip14.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey14= |
| 1041-Federal only-1042s | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | 000006007 | 311D | 2024 | $RecipID15 | 1041Recip15.xml | OK | DOCUMENT_LIST_RESPONSE/DOCUMENT_LIST/FIDUCIARY/DOCUMENT/RECIP_PACKAGE/PACKAGE_KEY | $PackageKey15= |
| 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 only | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey10 | 1041Recipdoc10.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1041Recipdoc10.pdf | True |
| 1041-Federal only-Grantor | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey11 | 1041Recipdoc11.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1041Recipdoc11.pdf | True |
| 1041-Federal only-Agent | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey12 | 1041Recipdoc12.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1041Recipdoc12.pdf | True |
| 1041-Federal only-1042s | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey13 | 1041Recipdoc13.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1041Recipdoc13.pdf | True |
| 1041-Federal only-1042s | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey14 | 1041Recipdoc14.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1041Recipdoc14.pdf | True |
| 1041-Federal only-1042s | TESTCLIENT1 | WinterTime1 | WEBDELUSER | WD$12345 | $PackageKey15 | 1041Recipdoc15.xml | OK | DOCUMENT_RESPONSE/PACKAGE_PDF_RESPONSE/PDF | 1041Recipdoc15.pdf | True |
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