Download and Install Microsoft Excel Add-in for HP Quality Center or ALM 11.5x

The MS-excel Add-in provided by HP QC/ALM enables the user to export requirements, tests, and defects from Microsoft Excel directly to ALM.

Please note that the Add-In is only compatible with Microsoft Office 32 bit. If you have 64 bit Ms Office, that needs to be updated to 32 bit in order to run this Add-In.
Unsure of your MS-Office version? Click below link to find out:

How To Find If The MS Office Version is 32 or 64 Bit?

Following are the steps to download and install the Microsoft Excel Add-in for HP Quality Center or ALM 11.5x. The steps to install other MS Add-ins like MS-word would also be more or less similar.

1. Navigate to HP ALM Home Page
2. Click “Tools” as highlighted above. Following window would be displayed.
3. Click “More HP ALM Add-ins” as highlighted above. Following window would be displayed.
4. Click “Add-Ins” icon as highlighted above. Following page would be displayed.
5. Click “Add-ins for Microsoft Applications” as highlighted above.
6. Click “Microsoft Excel” as highlighted above. Following window would be displayed.
7. Click “HP ALM Microsoft Excel Add-in for ALM 11.00 and 11.5x – No Admin Rights Required” as highlighted above. The page will scroll to selected option.
8. Click “HP ALM 11.5x Microsoft Excel Add-in Download” as highlighted above. Downloading would start. Open the download folder after it completes. 
9. Run the executable file downloaded. Following window would be displayed.
10. Click “Next” button as highlighted above. Following window would be displayed.
11. Select the type of setup type (I selected ‘For All Users’).
12. Click “Next” and the Add-In would be installed. Following window would be displayed after successful installation.
13. Click Finish. The installation wizard would close. In order to verify that the add-in is installed, open a new excel sheet.
14. A new tab named “Add-Ins” would now be displayed. Click on the same and the HP-ALM Add-in can now be seen.

Click the below links for further read on same topic:
Upload Test cases from Excel to Quality Center (QC) – HP QC 9.2

    How To Find If The MS Office Version is 32 or 64 Bit?

    Whenever we need to install a new software or tool, the most basic question one need to answer is to find the MS Office version installed. So, want to find if you’re running the 32 bit or the 64 bit Office 2010? 
    Following are the steps to  find out:
    1. Open any MS Office application – Word/Excel/Power point or any other.
    2. Click ‘File’ Menu.
    3. Click at ‘Help’.
    4. The Office version is displayed on right hand side as highlighted in red box.

    ms office version

    MS-Excel 32 Bit
    And it’s done! Quite easy right?
    The steps to find the version would be almost similar for all office applications and any windows version. 
     
    Hope it helped.
     
    Also check the below link for more posts related to MS Office:

    Penetration Testing


    Penetration Testing is also known by the terms – Pen Testing, Security Testing, Ethical Hacking and White Hat Hacking. While all of these terms are many times used in exchange of each other, they are slightly different from each other. But for the time, let’s consider them same owing to their mostly common contents.

    Definition of Penetration Testing (In my words):
    Penetration testing is the process which tests the systems or websites or applications and tries to find the flaws concerning security issues and reporting the same along with possible solutions to get them corrected.
    As per Wikipedia, A penetration test, or the short form pen-test, is an attack on a computer system with the intention of finding security weaknesses, potentially gaining access to it, its functionality and data.
    The process involves identifying the target systems and the goal, then reviewing the information available and undertaking available means to attain the goal. A penetration test target may be a white box (where all background and system information is provided) or black box (where only basic or no information is provided except the company name). A penetration test will advise if a system is vulnerable to attack, if the defences were sufficient and which defences (if any) were defeated in the penetration test.

    Removing Port Number from QC/ALM URL

    We had been struggling to get rid of the port number in qc URL. Finally, we got it done with the help of HP Support.
    Below is the solution we have found to remove the port number 8080 from QC URL:

    1. Update the port number to 80 in configuration files of the application. In this case, they were ‘qcconfigfile.properties’ and ‘jetty.xml’.
    2. The ALM service would not start now as port 80 is likely to be used by other processes.
    3. Release port number 80 from all processes.
      • The command “netstat -o -n -a | findstr 0.0:80” help us find out if the port is being used or not.
      • If any website in IIS points to port 80, update the same.
    4. Start the ALM service
    5. Re-Start any other services stopped.

    In this case, we stopped 3 services – World Wide Web Publishing Service, Windows Remote Management (WS-Management) Service and IIS Admin Service

    Mobile Application Types – Native, Web and Hybrid

    The mobile apps are broadly classified under three categories:
    • NATIVE APPLICATION – A native application (native app) is an application program that is developed for use on a particular platform or device iPhone or iPad apps built using Objective-C, and Android application built with Java. Native apps are installed through an application store (such as Google Play or Apple’s App Store). For example, Camera+ app for Apple’s iOS devices.
      • Advantages:
        • Native apps perform faster
        • Native apps provide easy access to all native features of the device
        • Native apps generally operate in offline mode
        • Native apps are fully supported from concerned app stores
        • Because of their support, Native apps provide better security
      • Disadvantages:
        • Native apps are expensive to develop because of their platform dependency
        • Maintenance is also expensive for Native apps.
        • Different teams need to me maintained and tracked for different platforms
        • Multiple versions are often required to be maintained
        • Native apps need approval from app stores to be published and this may prove tedious and time consuming in case the app is not developed with high standards.
    • WEB APPLICATION – Web applications are webpages that look like an app. They are basically Internet-enabled apps that are accessible via the mobile device’s Web browser. Web apps are accesses via browsers are not required to be downloaded on to the device. Web apps are built using HTML5, CSS3 etc. 
      • Advantages:
        • Web apps are platform independent and can be used on all devices irrespective of operating systems.
        • Since Web apps are platform independent, deployment is easier for them
        • As web apps are not downloaded on devices, users need not worry about versions and updates released.
      • Disadvantages
        • The native API’s and device specific features are not accessible to Web apps which limit their scope of usage.
        • Since Web apps are not listed in app stores, users may find it difficult to find them
        • Security is also a concern with Web apps as it’s all internet based and come with it’s own set of vulnerabilities
        • All Web apps may not always work with multiple browsers. Thus is also adds to the cost of developing and maintenance.
        • Web apps need internet connection to operate and do not work offline
    • HYBRID APPLICATION– Native apps are part native apps, part web apps. They are installed in the same way as native apps and use the web apps technologies to perform certain functions. Actually, it’s very hard for the users to differentiate between native and hybrid apps. Hybrid app may look an easy option for websites which want to be listed in app stores without spending much and required effort to develop a native version of themselves.
      • Advantages:
        • Because most of the development is done using web technologies, hybrid apps are faster and easier to develop as compared to Native apps.
        • Hybrid app come with best of both Web and Native apps
      • Disadvantages:
        • Along with best, worst of both Native and web apps is also packaged in Hybrid apps
        • The use of native features of device is limited
        • Performance is not up to the mark when compared with Native apps
        • While most of the code is written in web technologies and is platform independent, there is some part of code which need to be designed as per the platforms of devices.

    What is Mobile Application or Mobile App

    With the advancement of technology, the mobile phone has advanced at rapid fast speed. There was a time when we were surprised that we could take pictures and videos from mobile phone. Before people could digest it properly, came a device that makes calls, plays videos, takes pictures, and receive/send email, more. All this with a regular phone! They are definitely smart – Smartphone. Carrying a small phone is almost equivalent to carrying a pocket-sized personal computer. They have an operating system of their own such as Google’s Android or Microsoft’s Windows Mobile.

    Mobile Application or Mobile App
    As per Wikipedia, A mobile app is a computer program designed to run on smartphonestablet computers and other mobile devices.
    Anyone who uses a smartphone/tablet most probably uses apps. There is hardly any task which cannot be done on a smartphone/tablet as compared to traditional desktops/laptops. There are thousands of apps available for all operating systems. Name a thing or game, and we have a mobile app for it – News, Weather, chatting, Facebook, email, moves, trains, flights, everything.
    While most applications function independently, but some of them integrate with tools in other media. For example, some websites have a different user interface for mobile and desktop version, while others have a separate app for the same – like Facebook. There are some apps which use location-based features  – like maps, weather etc.
    How to download and use an app
    Straight answer would be – A mobile app is used on a smartphone like iphone, Samsung S2/3/4 etx series, HTC mobiles etc or a tablet like – iPad, tab etc. It is to be noted that all apps do not work on all devices. It depends on the operating systems – ios, Android etc. For example, there is an app called iTunes – which works only on ios devices – iPhone/iPad.
    The app needs to be downloaded on the device to use. All operating systems have their online app-stores from where, the users can search and download and install the apps. Some of the apps are free for use while some of them may charge the users. For example, the Facebook app is free for use on all devices and operating systems while the ‘what’s app’ charges ios users a one-time fees and is free for other operating systems (not sure if that’s updated now).

    Types of Mobile Applications:
    1. Native App
    2. Web App
    3. Hybrid App

    Save a powerpoint presentation as a template

    Many times, we choose a presentation template and apply some changes to suit our need. In fact, most of the companies have a predefined template for presentations to be used. This is achieved by creating customized templates and saving them as template files. A template file (.potx/.pot) saves all the customizations made to slide masters, slide layouts, and themes to reuse in other presentations.

    When we create a presentation, and then save it as a Power Point Template (.pot) file, can be reused more than once. Thus saving the presentation as a template offers the following advantages:
    • The exact slide layout can be used in other presentations
    • The template can also be to existing presentations to quickly update the way they look.
    • The template can be used to quickly create a new presentation.
    • The template file can be shared with friends and colleagues.


    To save the presentation as a template:
    1. On the File menu, click Save As.
    2. In the File name box, type a name for the template.
    3. In the Save as type list, click PowerPoint Template (.potx/.pot). As soon as the type is changed to power point template, the default location(might be different for different windows and office versions) “C:UsersName>AppDataRoamingMicrosoftTemplates”. Copy and save the path somewhere for future, in case the template does not appear by default in the list while creating new templates.
    4. Click Save.

    Suggest Topics

    Hi Friends,
    Let me try this.

    Please mention your topic on Software Testing on which you would love to read more. I would try and document my knowledge or find out some relevant material and compile. Though I cannot promise, but I would definitely try to cater maximum requests.

    Let’s see how it goes. wish me luck and do drop in a comment with the current Software Testing topic on your mind…:)

    JIRA Query to find the list of issues updated in a month

    As a process, we need to make an effort variance report every month for all the applications tested b y our team.  We use JIRA to log the efforts for each item.

    Effort Variance = (Planned Efforts-Actual Efforts)/100

    Following query may be used in JIRA to help:

    project = TEST AND assignee in (“[email protected]”,”[email protected]”,”[email protected]”) AND updated >= “2014/06/01” and updated < “2014/07/01”

    The above query would list all issues for the project ‘TEST’ having assignee among ‘abc’, ‘pqr’ or ‘ijk’ which were updated in the month of June-2014.

    The query can also be modified as per needs…:)

    Find the RSS Feed URL for a web page

    Well, it’s nothing new, but still, below are the steps to find the RSS feed URL of a webpage (website, blog, or any particular post/page).

    1. Navigate to the website

    2. Right click anywhere on the page
    3. Click View Source
    4. Type Control + F
    5. Type “rss”in the search text box and click Next 

    6. The URL highlighted in black rectangle is the rss feed URL.
    7. Click on the URL or copy and paste it anywhere required.