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.
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.
To download attachment using Apache JMeter, add a HTTP Request Sampler as shown below.
When you execute the test plan, in View Results Tree, you can see below response data from the server.
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.
Now execute the test plan and go to your JMETER_FOLDER\bin\. You could see the attachment which got downloaded as shown below.
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.
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.
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.
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.
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.
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:
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.
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.
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.
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.
LoadRunner help center has easy navigation as shown below.
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.