All Projects → alaserm → VisualTAF

alaserm / VisualTAF

Licence: other
ExlJS - Super easy to use, Excel and JS driven tool, encapsulating best practices in test automation development.

Programming Languages

java
68154 projects - #9 most used programming language

Projects that are alternatives of or similar to VisualTAF

Test files
📚 SheetJS Test Files (XLS/XLSX/XLSB and other spreadsheet formats)
Stars: ✭ 150 (+614.29%)
Mutual labels:  test, excel
API-Testing-Automation-Framework
It is Data-Driven and Keyword-Driven framework to test REST/SOAP webservices automatically
Stars: ✭ 24 (+14.29%)
Mutual labels:  keyword-driven-testing, data-driven-tests
alexa-skill-test-framework
Framework for easy offline black-box testing of Alexa skills.
Stars: ✭ 64 (+204.76%)
Mutual labels:  test
fastapi-csv
🏗️ Create APIs from CSV files within seconds, using fastapi
Stars: ✭ 46 (+119.05%)
Mutual labels:  excel
DBC2Excel
Convert DBC to Excel by VBA
Stars: ✭ 33 (+57.14%)
Mutual labels:  excel
cypress-upload-file-post-form
Solution for two Cypress testing use-cases I came across with: perform a direct http FORM request to the server containing a file and other parameters and upload a file into a form before submission
Stars: ✭ 59 (+180.95%)
Mutual labels:  excel
SchemaMapper
A .NET class library that allows you to import data from different sources into a unified destination
Stars: ✭ 41 (+95.24%)
Mutual labels:  excel
ExcelExport
Classes to generate Excel/CSV Report in ASP.NET Core
Stars: ✭ 39 (+85.71%)
Mutual labels:  excel
bingexcel
处理excel与java之间转换的ORM框架
Stars: ✭ 23 (+9.52%)
Mutual labels:  excel
OpenSpreadsheet
OpenSpreadsheet provides an easy-to-use wrapper around the OpenXML spreadsheet SAX API. It specializes in efficiently reading and writing between strongly typed collections and worksheets.
Stars: ✭ 24 (+14.29%)
Mutual labels:  excel
angular-cli-skeleton
angular-cli skeleton to quickly start a new project with advanced features and best practices. All features are described in README.md.
Stars: ✭ 32 (+52.38%)
Mutual labels:  test
clipboard-parser
剪贴板解析器,支持解析@RequestParam/@ApiModelProperty接口定义代码、Word、Excel以及其他表格类数据
Stars: ✭ 15 (-28.57%)
Mutual labels:  excel
cap-table-tool
Cap Table and Exit Waterfall Tool, https://foresight.is/cap-table
Stars: ✭ 22 (+4.76%)
Mutual labels:  excel
Orion-Stress-Tester
A simple, efficient and accurate stress tester, support HTTP, WebSocket and TCP
Stars: ✭ 32 (+52.38%)
Mutual labels:  test
laika
Log, test, intercept and modify Apollo Client's operations
Stars: ✭ 99 (+371.43%)
Mutual labels:  test
ToolGood.Algorithm
Support four arithmetic operations, Excel formulas, and support custom parameters. 支持四则运算、Excel公式语法,并支持自定义参数。
Stars: ✭ 77 (+266.67%)
Mutual labels:  excel
botium-cli
Botium CLI - The Selenium for Chatbots
Stars: ✭ 27 (+28.57%)
Mutual labels:  test
python-pytest-harvest
Store data created during your `pytest` tests execution, and retrieve it at the end of the session, e.g. for applicative benchmarking purposes.
Stars: ✭ 44 (+109.52%)
Mutual labels:  test
jest-serializer-html-string
A better Jest snapshot serializer for plain html strings
Stars: ✭ 17 (-19.05%)
Mutual labels:  test
emacs-python-pytest
run pytest inside emacs
Stars: ✭ 105 (+400%)
Mutual labels:  test

Installation

  1. Download ExlJS.zip file from this link
  2. Extract content of zip file to some folder
  3. Go to that folder and run ExlJS.exe
  4. There are demo tests included in ExlJS (expand "Test Sets" node in ExlJS GUI to see them), you can run them and learn from them.
  5. Sometimes macros in excel are not enabled by default, so enable them for magic hotkey to work!!

ExlJS (the tool that does most of the work for you in data-driven test automation)

ExlJS is a powerful standalone GUI tool for rapid and super easy creation of data-driven test automation scripts. It's data-driven out of the box, no need to write code for fetching test data. ExlJS allows crafting of test cases in EXCEL by copy/pasting reusable instructions and adding reference to test data in another sheet in the same Excel file.
It gives you great organizational structure and visibility for your test cases, built-in shortcuts make test case automation straight forward (top to bottom approach), smooth and fun, you will waste less brain energy on automation and have more energy for yourself and as a result feeling more happy in your life.

This tool is designed to enforce test automation best practices like reusable data-driven instructions, object repository.

  • It's a standalone GUI tool, no need to remember command line parameters :)
  • it uses Javascript, which is much easier to use than Java or C# code, no compilation required.
  • Tons of built-in convenience functions for all types of interactions with web elements, tons of built-in verification points, you don't need to write any extra code.
  • Do your automated test scripts fail because test data already exists in the system from previous automated test runs? With this tool you won't have this problem, it can automatically generate unique test data every time (no coding required).
  • Parallel test script execution in multiple browsers, instead of hours you can finish test runs in minutes.
  • No need to download and install Node.js, Java, Selenium or other dependencies, the tool is self contained, just download this tool and you are all set, it works out of the box.
  • Built-in Object Repository to keep all Web Elements of your tests in one place (test automation best practices for ease of maintenance in case web element selectors change later)
  • It supports parallel test exection on remote machines.
  • It has sophisticated built-in functions to wait for page load in standard and SPA pages to make your test scripts rock stable.
  • Automatically takes screeenshots upon test failure for easy defect reporting.
  • Automatic Enterprise Level Reporting with drill down to step level (no need for you to write any code), you can see exactly what test data was used for each element and what button was clicked. You can mail this test execution report to project stakeholders for visibility, everybody can see what tests have been executed.
  • !!!New!!! Automatic code generation - just fill in test data in datasheet and press Ctrl+Shift+G for the tool to auto generate code for you, this is the MAGIC hotkey, it will create instruction code, repository with web elements and commands to to interact with them. This hotkey will also navigate you from Excel to exact instruction code and from instruction code to exact web element in object repository, so you don't need to strain your eyes and brain searching in code for instruction or web elements.
  • !!!New!!! API testing is now available!!!
  • Save up to 70% on your test automation development and maintenance time.
  • And...It's FREE for personal and educational use. Free training is provided to everybody!

Best practices implemented in this tool in one diagram

Automated test cases in Excel

Video 1: Webinar The simplest method for keyword and data driven test automation, also covers unique test data generation by adding "uniqueN" postfix to test data and verifying data in multi page HTML tables

Video1

Video 2: Watch how I automate data driven test cases in
a matter of minutes using magic hotkey!!!

Video2

You can also see test scripts developed by this tool in this git repo

For technical support and questions contact [email protected]
let me know if you have any questions or want a FREE training session via skype or zoom.

List of frequently used built-in functions

each function has documentation, just type its name in tool editor Automated test cases in Excel

Page Element interaction functions

  • clearText
  • typeText
  • select
  • click
  • clickAtXY
  • moveToXY
  • browserAlertBoxClick

Verification functions, checkpoints

  • assertCurrentPageUrl
  • assertCurrentPageTitle
  • assertObjectPresenceState
  • assertObjectVisibilityState
  • assertObjectEnabledState
  • assertObjectSelectionState
  • assertObjectText
  • assertObjectAttribute
  • assertObjectCss
  • assertListSelection
  • assertListContent
  • assertBrowserAlertBoxText

Wait functions

  • sleep
  • waitForStandardPageLoad
  • waitForAngularJQueryJS
  • waitForObjectToBecomeInvisible
  • waitForObjectToBecomeVisible
  • waitForObjectText

Helper functions

  • navigate
  • findObject
  • findRowInHtmlTable
  • isObjectPresent
  • isObjectVisible
  • isObjectEnabled
  • getText
  • getValue
  • getAttribute
  • getCssValue
  • switchToIframe
  • switchBackToDefaultContent
  • switchToNextTab
  • closeCurrentTab
  • selectorAndDescription
  • objectAndDescription
  • reportStep
  • debug
  • executeJSInBrowser
  • maximizeWindow

Helper instructions/keywords

  • Util.startWebBrowser
  • Util.closeWebBrowser
  • Util.sendAndVerifyApiRequest
  • Util.debug
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].