Test Cases For Excel Import Functionality - Bulk Upload Test Cases

.

 Test Cases For Import Functionality - Test Cases for Upload Data From Excel Sheet

How to Upload Bulk Data From Excel Sheets?

Here!!! Important Test Cases for import functionality are given...
  • First Download the excel Format (Download the sample excel sheet to upload bulk data)
  • Now verify whether the column names are as per requirement or not.
  • Verify the excel sheet name as per requirement or not.
  • Verify that when excel sheet is password protected.
  • Check that user is able to type for all columns or not.
  • Verify that when the user enters valid data in all the fields and tries to upload the excel sheet.
  • Check that data are properly showing in all the field (on the webpage) or not.
  • Check that when the user edits the data uploaded from the excel sheet are properly bound or display or not (text boxes, Dropdowns, Checkboxes, etc).
  • Check that when the user enters data only in the mandatory column and uploads excel. 
  • Check that when the user enters data only in the non-mandatory field and tries to upload excel. 
  • Verify that the alert message showing or not when the user enters data only in the non-mandatory field and tried to upload excel
  • Verify whether the alert message showing as per requirement or not. 
  • Check that when the user entered data for one user and uploads.
  • Check that when the user entered data in mass and uploads the excel sheet. 
  • Check that when trying to upload an excel sheet without entering any data. 
  • Check that when the user tried to upload the excel sheet by changing the file name. 
  • Check that when the user tried to upload the excel sheet by changing the file name with a special character. 
  • Check that when the user tried to upload an excel sheet by entering the invalid data in all columns. 
  • Verify that when users do not select any value from the dropdown column and try to upload. 
  • Check that when the user entered the numeric value in the column that accepts only the alphabet through the webpage. 
  • Check that when copying values and pasting in an excel sheet and trying to upload. 
  • Check the combination-paste value in one field and manually enter the other and tried to upload. 
  • Check that if preview options are working or not(if applicable) 
  • Check that the cont showing or not. 
  • Check if the row has any wrong value or user entered any wrong value when the user uploads showing in red color or not. (If applicable) . 
  • Verify whether the confirmation message showing or not when a user successfully uploads the bulk data from the excel sheet. 
  • Check that the confirmation message is as per the requirement met or not. 
  • Verify the control when the user successfully uploads the data. 
  • Check whether the data uploaded from the excel sheet shows on grids or not. 
  • Verify the alert message when the user entered any wrong value in any column and user tried to upload. 
  • Verify that the user is able to understand the mistake in the excel sheet by getting an alert. 
  • Verify when the user selects an invalid extension file.
  • Verify the Size limit of the excel sheet.
  • Check whether the alert message showing or not when the user selects an invalid extension file.
  • Check whether the alert message showing or not when the user selects a file more than the defined size.
Hope !!! The above Test cases for import functionality are helpful for you...

Team,
QA acharya

Tags: Test cases for import, Excel upload test cases, Bulk upload test cases, Excel upload Test cases, 

Test Cases For Bulk upload Functionality 








.

Post a Comment

0 Comments