Month: August 2014

How to get Column Address from column Name in Excel ?

August 30, 2014

Requirement:-To find the Address of given Column in Excel. In the below image we need to find the Address of “Application” column in the excel.Which is “C”. Excel Data Code:- sSheetName = “uftHelp”sColumnName = “Application”sPath = “C:TempTest.xlsx”fnExcelColAddress sSheetName,sColumnName,sPath’*******************************************Function***********************************’Function Name:- fnExcelColAddress’Function Description:- Fetch the Excel Column Address based on User defined Column Name’Input Parameters:- SheetName,ColumnName,Excel Path’Output Parameters:- […]

Read More

How to get Field Names in ALM ?

August 28, 2014

Requirement:-We need the field names which are used in ALM , these are required to utilize the cabablities of OTA in ALM. Test Lab fields Solution:-Approach 1:-A. In ALM , Dashboard — Analysis View ALM Tabs B.Create New Excel Report Excel Report C.Under Configuration tab – – Query Builder Configuration Tab  D. Write the following […]

Read More

Understanding Automatic Runner(ALM) status Error on running UFT scripts.

August 25, 2014

Following is the list of errors we can face while running scripts from ALM . These status error are sometimes confusing.To clarify on their meaning and comprehend them, we have written about most frequent error messages in automatic runner.Please feel free to add errors/solutions, incase you have encountered in your interaction of UFT with ALM.  1.Unable to load […]

Read More

Launching UFT with VAPI-XP from ALM?

August 22, 2014

Let us further enhance our code to launch UFT script from VAPI-XP in ALM. We are already familiar with “Hello World!!” code in VAPI-XP .We are going to run the same line of code but this time we are utilizing UFT to execute it.Requirement:- Launching and running UFT script from VAPI-XP in ALMImplementation:-Step1:- Create a simple […]

Read More

Creating VAPI-XP code in ALM and UFT?

August 22, 2014

Now we know how to create a VAPI-XP in ALM  .Our next target is to utilize this to code and write our first workable piece of code in the form of  “Hello World!!” program :).Implementation:-Step1:- Delete the default generated code in VAPI-XP testing tool. VAPI-XP default code Step2:- Replacing the default code with following lines […]

Read More

Working with VAPI-XP in ALM ?

August 21, 2014

Today we are going to discuss the basics of VAPI-XP and how to create our first VAPI-XP in ALM.Meaning:-VAPI-XP testing tool facilitate us to create new testing scripts using Microsoft VBScript, Microsoft JavaScript (JScript version), PerlScript, and PythonScript. Furthermore we can integrate these scipts into our application management process. Using VAPI-XP test scripts, we can […]

Read More

How to Re-Run Test in ALM on failure?

August 12, 2014

Incase we start our search for any issue on ALM; it is really arduous to find something relevant and meaningful. Furthermore there is a scarcity of website addressing ALM issues or help. So we thought of sharing an article pertaining to “Re-Run of Test case in Test set in ALM in case of failure”. Requirement:-  […]

Read More

ActiveX component can’t create object: ‘Mercury.ObjectRepositoryUtil’

August 11, 2014

Recently we got this error while running our .vbs file, external to UFT.  It is a common error that one can encounter while working with .VBS files. Let us focus on the possible solution for the same. Please feel free to share your experience on the same.As always their are 100 of solutions for a […]

Read More

How to convert Object Repository into XML format?

August 8, 2014

We will be focusing on 2 methodologies to achieve our target. Approach 1:- Using “ObjectRepositoryUtil Object“ ObjectRepositoryUtil(ORU):-By using this object we can work with object Repository files (Local/Shared) from outside of UFT. We need to use “ExportToXML” method of ORU object. ExportToXML Method ‘Creating the ObjectRepositoryUtil to work with ORSet objORU = CreateObject(“Mercury.ObjectRepositoryUtil”)’Exporting the OR into […]

Read More

How to change Settings of Remote Agent ?

August 7, 2014

After launching the Remote Agent successfully. we can play with the settings of Remote Agent in UFT.Approach 1:-The Remote Agent’s icon will appear as a Taskbar Button(Check the far bottom right of the taskbar). Right click on remote agent button and select “Settings” from the context menu. Remote Agent Button on Task Bar Remote Agent […]

Read More