SilkTest - How to give path of the Excel file in the DataDriven test cases with out using the absolute path?

GeekInterview.com > Tech FAQs > SilkTest

Go To First | Previous Question | Next Question

SilkTest | Question 20 of 28

How to give path of the Excel file in the DataDriven test cases with out using the absolute path?

While data driving the test cases , the excel sheet path will be given by selecting the browsing option which will be absolute, but I want to give relative path such that where ever we copy the test case folder which includes script folder, excel sheet folder, data driven folder within which the corresponding files are placed, the path of the excel sheet should be accessed and the data should be assigned.

We have the option {CurrentPath} in order to use relative path but it is working only for including frame files in script files and data driven files but in the excel path
EG:
[ ] use "{CurrentPath}..FrameFilesOperatorconsole.inc"
[ ] use "{CurrentPath}..FunctionFilesOperatorConsoleFunctions.inc"
[ ] use "{CurrentPath}..ScriptFilesAboutAMSecurityManager.t"

is working fine but

STRING gsDSNConnect = "DSN=Segue DDA Excel;DBQ={CurrentPath}..Excel SheetOC_AUTOMATION_DDT.xls;UID=;PWD=;"

is not working. It will work if you access the sheet once if we complete the data drive but if you close and reopen the data driven testcase file and try to execute the "The Data not Found" error is coming. Could any one of you help in doing this?

Total Answers and Comments: 0

Last Update: February 06, 2008 Asked by: Rajalakshmi Rangaraj

No answers are posted for this question yet.
Be the first to answer it!

ERP Success cases

ERP Success cases You have probably heard a lot about ERP systems especially about their implementation and its advantages and disadvantages Here you will find that there are no unachievable targets and that every effort brings benefits These are the stories of people who found success through ERP i

Using XML with Microsoft Excel

Using XML with Microsoft Excel One of the most useful features for a programmer would be Microsoft Excel s capability to support XML schemas which are user defined Though it is not a very prominent feature which can be obviously noted it still exists and is very functional tool In simple English it

What is Data File

In a logical data model, the conceptual data model which is based on the business semantic is being defined. Thus, entities and relationships and corresponding table and column design, object oriented classes, and XML tags, among other things are being laid regardless of the database will be physica

What is Access Path

In relational database management system (RDBMS) terminology, Access Path refers to the path chosen by the system to retrieve data after a structured query language (SQL) request is executed. A query may request at least one variable to be filled up with one value or more. A query may look like th

PHP Tutorials - File manipulation (Part-2)

File manipulation Part 2 In this PHP Tutorial you will learn the 2nd Part of File Manipulation Reading lines from a file Reading arbitrary amounts of data from a file Writing to a file Creating directories Removing a directory and Opening a directory for reading mosgoogle Reading lines from a file T

PHP Tutorials – File manipulation (Part 1)

PHP Tutorials File manipulation Part 1 In the PHP Tutorial You will learn about File manipulation Part 1 Checking file existence A file or directory Determining file size Creating and deleting files and Opening a file for writing reading or appending mosgoogle Checking file existence You can test

C Programming - File management in C

C Programming File management in C In this tutorial you will learn about C Programming File management in C File operation functions in C Defining and opening a file Closing a file The getw and putw functions The fprintf fscanf functions Random access to files and fseek function mosgoogle C suppor

Test Cases, Test Scenarios Interview Questions

Test Cases Test Director and Test Scenarios Interview Questions This article provides Software Testing Interview Questions covering Test Cases Test Scenarious and Test Director questions For more Interview Questions Answers related to testing click on links provided at the end of each question set m

The File Types Editor

The File Types Editor The File Types Editor can be used to create the required registry to establish a file association for the application being installed A file association is simply a link between a particular file extension and a particular application For example the file extension xls is norma

Working with File System in .NET

In this tutorial you will learn about Access and Manipulate Data Working with Disk Files Browsing for Files Streams and Backing Stores Using the FileStream Class Using the StreamReader and StreamWriter Classes Using the BinaryReader and BinaryWriter Classes Access and Manipulate Data Working with Di

SilkTest FAQs Related

—

No answers are posted for this question yet.Be the first to answer it!