Enable ‘Create a new Excel report’ option in HP-ALM

Excel Reports in Quality Center or HP-ALM have always been quite useful in extracting various reports. One of the many advantages has been to export test cases from ALM to excel sheet for convenient use and reporting

From HP-ALM version 12, the option to ‘Create New Excel Report’ is disabled by default. It means, the user cannot create new excel report, but can view, edit and run existing reports (if any) from previous versions.

ALM: Create New Excel Report Option Missing
ALM: Create New Excel Report Option Missing
ALM: Existing Excel Reports
ALM: Existing Excel Reports
 However, the option to ‘Create New Excel Report’ can be enabled by site configuration parameter – ‘ENABLE_CREATE_LEGACY_EXCEL_REPORT’. Following are the steps to do so:
  1. Login to ALM site administration.
  2. Navigate to ‘Site Configuration’ tab.
    ALM: Site Admin Site Configuration
    ALM: Site Admin Site Configuration
  3. Look for the parameter – ‘ENABLE_CREATE_LEGACY_EXCEL_REPORT’. Double click to configure it.
  4. If the above parameter is not found, the site admin can create it by clicking ‘New’. Enter the details as below.
    ALM: Site Admin Site Configuration New Parameter
    ALM: Site Admin Site Configuration New Parameter

  5. Please note that the parameter name is case sensitive and must be entered in all Capital letters.
  6. Click Ok.
ALM: Site Admin Site Configuration Excel Report Parameter
ALM: Site Admin Site Configuration Excel Report Parameter

The users must log off and login again in order to see the changes being effective.
ALM: Create New Excel Report Option Enabled
ALM: Create New Excel Report Option Enabled

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

    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

    QC Export Wizard – Error on Step 4 of 8 – User is not permitted to export this kind of data – Quality Center

    While exporting from Excel to QC, the export wizard throws following error at step 4 –

    • Above error is thrown when the user does not have required rights to upload data.
    • In this case, if the user would not be able to create requirements/test/defects manually also.
    • To resolve the issue, please verify the permissions or the role on project you are trying to export data. This may be checked by navigating to Tools-> customizations. 
    • If you do not have proper rights, chances are that you would not be able to view the customizations screen. 
    • In that case, either try logging with admin login or ask your teammates for the same.

    Quality Center QC Error : ACCESS VIOLATION AT ADDRESS IN MODULE abc.ocx . Read of address

    Some times, we get access violation error at some address on some of the functions in quality center.

     99% of cases when i got this error was when i tried copy and paste in quality center. The copy paste would work fine for some time and suddenly, it would stop working.

    The solution i have found to resolve it is as below:-

    I recommend that our users follow this procedure to make sure that IE has a clean startup.

    1. Close all instances of IE and all instances of Windows Explorer.
    2. Open task manager and kill the explorer.exe process (don’t close task manager at this point….otherwise use ctrl-alt-del to get back to Task Manager). Click File –> New Task (run)  –>  type explorer.exe and hit enter.
    3. Open a new browser and try to access Quality Center again.

    IE and Windows explorer and the desktop explorer.exe process are intertwined and can hold onto certain session parameters and not get cleaned up if you don’t restart all of them at the same time.

    I know it is a pain…..but it seems to clear up the problem.

    For a shortcut, you may also just close the window in which QC has been opened and start a new session.