Geeks Talk

Prepare for your Next Interview




Upload multiple test cases from Excel

This is a discussion on Upload multiple test cases from Excel within the Test Director forums, part of the Software Testing category; Hi, I m trying to upload multiple test cases from Excel to TD for the first time. I have installed the EXCEL add in and it works. But somehow, though ...


Go Back   Geeks Talk > Software Testing > Test Director

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 10-20-2007
Junior Member
 
Join Date: Oct 2007
Posts: 2
Thanks: 0
Thanked 1 Time in 1 Post
karthikpal is on a distinguished road
Upload multiple test cases from Excel

Hi,

I m trying to upload multiple test cases from Excel to TD for the first time.
I have installed the EXCEL add in and it works. But somehow, though I have multiple test cases in excel, the ADD In only uploads the first test cases, the others are ignored.

Can anybody help to tell me why this happens?
I have created subjects in test plan and this 1 test case is parked in the right Subject.

So why the others are missing?
Reply With Quote
The Following User Says Thank You to karthikpal For This Useful Post:
Sponsored Links
  #2 (permalink)  
Old 10-26-2007
Moderator
 
Join Date: Sep 2007
Location: Chennai, INDIA
Posts: 406
Thanks: 2
Thanked 141 Times in 81 Posts
sridharrganesan will become famous soon enoughsridharrganesan will become famous soon enough
Re: Upload multiple test cases from Excel

The error would have happened due to many reasons. Check whether the following have been correctly
1. The path mentioned in the subject should exists in the Test Director.
2. The Test Name should not contain any special characters
3. The columns should be correctly mapped to the column name in the quality center.
Try uploading after rectifying the above steps it may works!!!
Reply With Quote
  #3 (permalink)  
Old 02-13-2008
Contributing Member
 
Join Date: Feb 2008
Location: Hyderabad
Posts: 33
Thanks: 1
Thanked 0 Times in 0 Posts
deepika.padakandla is on a distinguished road
Re: Upload multiple test cases from Excel

Hi,
The above mentioned points are reasons for getting error while uploading.Even check the fields in excel as well as in QC and even the values in fields should exist in QC like Designer column..the names under this in excel should be same as in QC..else will get error designer doesn't exist.Even same with priority etc
Reply With Quote
  #4 (permalink)  
Old 02-19-2008
Banned
 
Join Date: Oct 2007
Location: Hyderabad
Posts: 176
Thanks: 2
Thanked 10 Times in 10 Posts
quality_quantity is on a distinguished road
Re: Upload multiple test cases from Excel

The next step in the methodology is to turn reusable modules into automated test cases. Here, the automation engineer takes a well-structured manual test case and begins scripting it out, creating reusable modules as he goes. The goal here is to build the reusable modules in a very methodical manner. The action-response pairs from the test case are scripted into reusable modules. These pairs also determine the size or granularity of a reusable module, which generally consist of just one action-response pair. This becomes important later, for determining the scope and cost of the automation project. A single reusable modules generally takes one to three hours to script and carefully unit test. The average automated test case requires around twenty to thirty reusable modules to complete.

Automating test cases in this manner allows the testing system to take on a very predictable structure. One benefit of this predictability is the ability to begin building the automated testing system from the requirements early in the software testing life cycle.
Reply With Quote
  #5 (permalink)  
Old 05-21-2008
Junior Member
 
Join Date: May 2008
Location: Pune
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
sapsb is on a distinguished road
Re: Upload multiple test cases from Excel

Apart from above mentioned reasons , do remember to keep one blank row in between test cases in excel,
also give the correct path name in each test case column name
Reply With Quote
Reply

  Geeks Talk > Software Testing > Test Director


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
I have given 5 test cases in excel sheet Geek_Guest Test Director 3 02-13-2008 05:55 AM
is testdirector a tool or is used to write test cases like as ms excel siyaa Test Director 4 02-13-2008 05:53 AM
Is there any diff. between Designing Test Cases and Test Cases Preparation. vijenjoy2k2 Testing Issues 3 06-01-2007 05:37 AM
Test cases in excel sheet chsrikanth Testing Issues 2 04-14-2007 02:36 AM
100 test cases from TD into an excel sheet Lokesh M Test Director 2 12-23-2006 03:20 AM


All times are GMT -4. The time now is 02:37 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved