Excel in MS Excel – Now available in eBook for just $0.99

Buy eBook

MS Excel – a spreadsheet application of Microsoft playing a critical role in management, accounting, business deals, software industry, government agencies, statistics, and more. Excel is one of the most popular program across the globe. Millions of people uses MS Excel in a regular basis. Not many people know about the amazing features of Excel. It is important to know about those features in order to manage your data and perform tasks easily and quickly.

 

Excel in MS Excel enables MS Excel users to work efficiently and effectively by lessening the effort and time spent on data manipulations, data illustrations, modeling data and reports, reviewing reports and by creating add-ins/macros to perform repetitive tasks. Excel in MS Excel explains about the user interface of MS Excel 2013 and illustrate the basic useful functionalities of MS Excel in a simple and effective way with relevant examples and screenshots in place.

 

It provides useful tips and best practices to work-on, learn, and excel in doing tough tasks in easy and quick methods. Features of MS Excel explained using the latest version of MS Office suite i.e. MS Excel 2013.

How to download files using Apache JMeter?

When I started learning performance testing couple of years ago, I was skeptical about how to download files using Apache JMeter or HP LoadRunner. Downloading files is pure client side activity. When you click on the file name or Download button, pop-up would generate from the OS. Once you click on Open or Save button, the file will get stored in your local disk.

E.g. In below snapshot, when you click on the attachment, you would get a Save As dialog box.

Attachment
Attachment
Save As
Save As

To download attachment using Apache JMeter, add a HTTP Request Sampler as shown below.

HTTP Request
HTTP Request

When you execute the test plan, in View Results Tree, you can see below response data from the server.

Response Data
Response Data

This will not download the desired file to your local disk. We will see how to download files using Apache JMeter.

To download files, you need to add Save Responses to a file sampler to your test plan. Below are my settings in my test plan.

Save Responses to a file
Save Responses to a file

Now execute the test plan and go to your JMETER_FOLDER\bin\. You could see the attachment which got downloaded as shown below.

Download Attachment
Download Attachment

Above approach is pretty simple, because we have the direct URL to download the file. What if the application has javascript doPostBack links? You cannot see or track the actual URLs when you click on the URLs. Actual links will look like javascript:__doPostBack(‘Page1′,’2′)

What is javascript__doPostBack function?

Javascript__doPostBack function has two arguments EVENTTARGET and EVENTARGUMENT. Those two arguments will automatically declared. The value of the two arguments will store in a hidden fields. You can get the values from the source code.

EVENTTARGET has which control triggered the action. E.g. when you click on Link 1, the id of the control Link 1 will get passed in the __doPostBack function.

EVENTARGUMENT has additional data associated with the control i.e. in this case, it will trigger the download process.

If you see in this http://stackoverflow.com/questions/12501510/how-to-download-and-store-a-txt-file-behind-a-javascript-link , if you mouse hover on the download link, you could see javascript:__doPostBack(‘ctl00$ContentPlaceHolder1$hlPreReleaseAll’, ”)

In this case, you will not have direct link to download the files from the website. When you click on the link, doPostBack function triggers with the control and the argument. It is not the GET call, it is POST call. In the JMeter test plan, you need to add HTTP Request Sampler for POST call and pass at least two arguments as shown below.

  1. __EVENTTARGET
  2. __EVENTARGUMENT

Usually I use Fiddler tool to identify what value is being passed. In some instances, you may need to pass following arguments: __VIEWSTATE, __VIEWSTATEGENERATOR, and __EVENTVALIDATION.

POST Request
POST Request

If you execute the script, you can see the file which you want to download will get stored in the bin folder. To download the script, please create a pull request at https://github.com/QAInsights/JMeter-Script

NOTE: The above script has been created only for educational purpose, do not use in the production application/site/URL. Use at your risk, we are not responsible for any consequences.

Performance Testing is Dead; Long Live Performance Engineering

Here is the excellent presentation on performance testing by Matthew Brady from EMEA HP Software.

The drive to agile development, faster delivery and DevOps has resulted in a major reduction in the scope and frequency of performance testing, primarily due to the need to reduce cycle times, and the difficulty of executing large scale tests earlier in the process. This has also led to a proliferation of test technologies selected by individual projects to cover only their specific needs, causing reduced test case reuse and inconsistency in results.

Reduced delivery times, instant and ubiquitous user feedback and reduced testing is a potentially toxic combination for organizations.

Performance Engineering is the new discipline of smarter, more flexible testing executed earlier in the process, delivering actionable and repeatable results including accurate performance data enabling issues to be addressed faster and at lower cost. Performance Engineering is not about a specific technology or product, but it is about reducing rework, maximizing automation and increasing feedback.

Join this webinar to learn more about Performance Engineering and how HP’s Performance Engineering solutions can help you on the path towards continuous business feedback and improvement, built-in and automated performance, optimized applications for business and customer value, and collaborative and interactive teams focused on quality.

OpenSSL 1.0.1j upgrade for LoadRunner

To fix the latest security vulnerabilities of OpenSSL in HP LoadRunner, follow the below steps:

Step 1

Backup all the DLL files, especially ssleay*.dll and libeay*.dll in the following folders:

  • LR folder\bin
  • LR folder\launch_service
  • LR folder\al_agent

Step 2

Download the updated DLL files from below links for the respective LoadRunner version

The OpenSSL fix has been already implemented in LoadRunner 11.52 Patch 4 and LoadRunner 12.02, so you can ignore the fix if you are using LoadRunner 11.52 Patch 4 and LoadRunner 12.02 version.

Detailed security advisory available at https://www.openssl.org/news/secadv_20141015.txt

What is OpenSSL?

OpenSSL is an open source library kit which implements Security Socket Layer (SSL v2 / v3) and Transport Layer Security (TLS) and full-strength general purpose cryptography library.

Common Errors you encounter in SOAP over JMS protocol

In this post, we will see about the common errors you encounter in SOAP over JMS protocol in HP LoadRunner or JMeter.

Sanity checks:

Ensure that you have associated all the latest JARs in HP LoadRunner/Apache JMeter. You can get the relevant JARs from the development team or you can download it from http://www.findjar.com/index.x

To associate JARs in HP LoadRunner, go to Replay > Runtime Settings or press F4 key, and then click on Advanced tab under JMS as shown below.



style="display:inline-block;width:468px;height:60px"
data-ad-client="ca-pub-0421766735265280"
data-ad-slot="6955268175">


Runtime Settings in LoadRunner
Runtime Settings in LoadRunner

Enter the full path of JARs in Classpath text field with semicolon separated or you simply enter %CLASSPATH% and map the JARs in your computer’s environment variables.

Add JAR to Classpath in JMeter
Add JAR to Classpath in JMeter

To map the JARs in JMeter, click on Test Plan and click on Browse button to map all the JARs as shown below.

Most of the errors that you encounter during unit testing can be solved by mapping right set of JARs and mention right send/receive queue names in the HP LoadRunner or Apache JMeter.

Now we will see about the common errors:

  1. Error: Failed to send message with javax.naming.NameNotFoundException

This error can be solved easily. The common mistake that testers do is mapping the wrong queue name in the script. Check for the right queue and map it accordingly to the script.

  1. naming.InvalidNameException

You get javax.naming.InvalidNameException when the port number is invalid, you need to check for the correct port and append it in the set property name.

  1. naming.AuthenticationException

You get javax.naming.AuthenticationException error when the JMS username and password is incorrect. Please check for any extra spaces in the username/password. You can get the username from the TIBCO configuration as well.

  1. Incorrect Initial Context Factory

Always make sure that you select appropriate initial context factory details in the settings. E.g. by default you can select com.tibco.tibjms.naming.TibjmsInitialContextFactory from the dropdown as shown below.

Initial Context Factory Settings in LoadRunner
Initial Context Factory Settings in LoadRunner

HP LoadRunner Help Center is now public

Recently HP had made LoadRunner help manual publicly accessible. Here is the link to access LoadRunner help http://lrhelp.saas.hp.com/en/latest/help/WebHelp/Default.htm

Above link has LoadRunner 12.02 help contents.

HP LoadRunner Help Center
HP LoadRunner Help Center

LoadRunner help center has easy navigation as shown below.

HP LoadRunner Help Center Navigation
HP LoadRunner Help Center Navigation

It has following options: Go back in browser history, Go forward in browser history, Go back to previous topic in Contents, Go next to topic in Contents, Expand All, Remove Highlights, and Print the current topic.

HP LoadRunner Help Center
HP LoadRunner Help Center

To check for the latest updates on the LoadRunner help, visit https://softwaresupport.hp.com/group/softwaresupport/search-result?keyword=loadrunner&lang=en&cc=us&hpappid=OSP

To access LoadRunner tutorial, please visit http://lrhelp.saas.hp.com/en/latest/tutorial/Tutorial_html/Default.htm

If you already installed LoadRunner in your system, you can access LoadRunner help by navigating Start > All Programs > HP Software > HP LoadRunner > Documentation

 To submit feedback about the HP documentation, please email at sw-doc@hp.com.

To submit service request, please visit https://softwaresupport.hp.com/group/softwaresupport/home?lang=en&cc=us&hpappid=OSP (login required)