Skip to content
SPEC INDIA

SPEC INDIA

Request a Quote
Menu
  • Services
      • Custom Software Development
      • Enterprise Mobility
      • Technology Consulting
      • Business Intelligence & Analytics
      • On-Demand Team
      • Product Engineering
      • Legacy App Migration
      • Software Testing & QA
      • SLA Driven 24/7 Support
  • Technology
      • .NET core
      • ASP.NET
      • Java
      • Power BI
      • Tableau
      • Pentaho
      • DevOps
      • IoT
      • Beacons
      • Fullstack
      • MEAN Stack
      • React
      • AngularJS
      • NodeJS
      • VueJS
      • Kotlin
      • Swift
      • React Native
      • Flutter
      • Python
      • ML
      • Big Data
      • Salesforce
      • R
      • AI
      • Azure
      • AWS
    • Our Innovation

      Hire highly-skilled on-demand teams to build sustainable, secure, and strategic digital solutions.

      Let's Connect
  • Industries
      • Retail & FMCG
      • Healthcare
      • Supply Chain & Logistics
      • Education
      • Manufacturing
      • Advertising
      • Travel & Hospitality
      • Media & Entertainment
      • Energy & Utilities
      • BFSI
  • Business Solutions
      • Custom Mobile ERP
      • Mobile Sales Force Automation (SFA)
      • Enterprise CRM
      • Warehouse Management System
      • Enterprise Service & Maintenance Solution
      • Vehicle Tracking System
      • Help Desk Management System
      • Self Service BI Plugin
      • Spot Billing System
  • Our Work
    • Case Study
      Live BI Visualization
      Portfolio
  • Company
      • Overview
      • Quality Policy
      • GDPR
      • Testimonials
      • Life @ SPEC
      • CSR
      • Events & News
      • Engagement Models
      • Project Execution Models
      • Contact Us
      • Career
      • Blog
CLOSE

Automation Testing for Plug-In

SPEC INDIA/Case Study/Automation Testing for Plug-In

About the BI Plug-In

Industry: Business Intelligence

BI Plugin is a plugin which basically converts SQL queries into different charts/table format. The plugin converts SQL query results into JSON format and shows the values on screen as columns/rows. It also gives the facility to download those charts/tables in the desired format.

The requirement was to automate these features using Selenium.

Key Challenges

The requirement was to check whether the values returned by web service are shown correctly on screen or not. Sometimes application downloads corrupted file for one of the features. The challenge was to check whether the downloaded file was corrupted or not through automation script only.

  • The application allowed to access page only after valid login. So the challenge was to retrieve the data from Web Service response through automation script with authentication
  • The response was in JSON format so we need to parse the JSON format
  • Yet another difficult task was to get the latest downloaded file and its location

Our Solution

Proposed solution

We have used Java for writing automation scripts with Selenium. The Java code gets a response from the request provided. It then parses the JSON received according to the requirement and fetches required values.

We get the download preference (the folder where all downloaded files are stored) for the browser on which the script is being executed. From that directory, we get the latest downloaded file and check if it is corrupted or not.

Implementation

  • Get Response: Using Base64 encoding, we get authorization token for a user who has logged in. On passing the token in HttpURLConnection, the response is fetched in JSON format.
  • Parsing JSON: We have used JSONParser for parsing JSON and retrieving values.
  • Checking downloaded file: We get the last downloaded file from download location and then check the extension of the downloaded file. If it does not match with selected/provided list, the script throws an exception as a corrupted file. If the extension matches, we read that file with a different class for different extensions. If there is an exception while reading the file, we consider it as corrupted file and script throws an exception.

Tools & Technologies

Business Benefits

  • Reduce chances of human error and give accurate output
  • Check multiple combinations in less time compared to the manual execution
  • Find bugs at an early stage
  • Ensures cost-savvy, time-savvy automated testing at every step



Automation Testing for Plug-In


    Please prove you are human by selecting the Flag.

    Contact Now

      Please prove you are human by selecting the Plane.

      Safe & Confidential

      INDIA

      “SPEC House”, Parth Complex, Near Swastik Cross Roads, Navarangpura, Ahmedabad 380009, INDIA.

      +91-79-26404031, 32, 33, 34

      [email protected]

      USA

      “SPEC Partner", 350 Grove Street, Bridgewater, NJ 08807, United States.

      +1 908-450-9862

      [email protected]

      Services

      • Custom Software Development
      • Enterprise Mobility
      • Business Intelligence And Analytics
      • Web Application Development
      • Mobile App Development
      • UI / UX Design
      • Technology Consulting
      • Cloud Deployment
      • DevOps

      Quick Links

      • Blog
      • Career
      • News
      • Life @ SPEC
      • Case Study
      • Newsletter
      • Contact Us
      • Sitemap
      • Privacy Policy
      • Terms of Use
      • Tech in 200 Words

      © 2021 SPEC INDIA. All Rights Reserved.

      DMCA.com Protection Status

      Request a Quote

        .doc, .docx, .pdf, .xls, .xlsx, .jpg and .png files with 5MB size allowed.

        Please prove you are human by selecting the Star.

        Safe & Confidential
        We use cookies to enhance your user experience. By continuing to browse, you hereby agree to the use of cookies.
        To know more; visit our Privacy Policy & Cookies PolicyAccept and Close
        Privacy & Cookies Policy

        Privacy Overview

        This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
        Necessary
        Always Enabled

        Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

        Non-necessary

        Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

        Scroll Up