HPE Software Products: Quality Center Support and News
Share |

What is the difference between TDAPIOLE80 and TDAPIOLELib?Open in a New Window

Hi all,

I'm trying to establish connection to QC via Excel VBA

Set com = CreateObject("TDapioleLib.TDConnection")

will report an error message "Run-time error '429' : ActiveX component can't create object"

Set com = CreateObject("TDapiole80.TDConnection")

will not report any errors

I have googled a lot, but I still cannot find any useful and clearly message about the differences.

So I need to clarify, what are the differences?

* Updates: 

I might have posted on the wrong topic, but the QC / ALM Practition Center prompted me I do not have the sufficient privileges, and I don't know how and why. Would someone please to help me move this topic to the correct board? Thanks a lot in advance.

 

Excel Add on handleCreateAction errorOpen in a New Window

Am trying to upload test cases from Excel add on to ALM and am receiving an error "handleCreateAction"

 

Is there somethiogn I am missing as when I Vaiidate the spread sheet it validates ok.

 

Thanks

 

PREVIOUSMONTHOpen in a New Window

Interactively, I can choose PreviousMonth when setting up filters against date format fields. Such as Modified PreviousMonth.

Below is how it comes up when I copy the filter setting:

TableName:BUG,
ColumnName:BG_VTS,
LogicalFilter:[PreviousMonth],
VisualFilter:[PreviousMonth],
NO_CASE:

 

 

I am building query for output in excel format and I will like to utilise the PreviousMonth there too.

So instead of using as below

AUDIT_LOG.AU_TIME >= DATE '2017-04-01' and AUDIT_LOG.AU_TIME <= DATE '2017-04-30'

I will like it to be 

AUDIT_LOG.AU_TIME is PreviousMonth

-> Of course it does not work.

 

Any help?

Idea is not to go and edit the query every month for the desired results.

 

 

History section want at start of document err :15,15,15,55Open in a New Window

Hi All,

1. Instead of history section at end of document i want it at start of document how is it possible?

2. While generating project report in histroy section im getting <CaliberColumnWidth>15,15,15,55</CaliberColumnWidth> error any idea why so?

 

HP Excel Addin to Import Test Cases from HP ALM to ExcelOpen in a New Window

I am using the Excel Addin to import test cases from test plan folder in HP ALM to Excel.

In the wizard - 4 to 6, where i can choose the folders and sub folders. I can see a difference that looks like a bug.

there are few folders that are displayed with sub folders (+) expand mark, and few with no sub folders.

But the Actual folder in ALM had sub folders, I dont know whats the difference disabling the view of subfolders for few of them.

Kindly help me how to solve this, let me know if you need illustrations to explain.

 

How to create Custom Field in project report creation - ALM 12.53Open in a New Window

Hi All,

I want to create project report using different templates. I have customized template as per the requirement but im fingind it difficult to use Custom field.

e.g. 1. if i want to use Author on first page and it should pick value from ALM how will that work.

2. When im trying to use cross refeence in filter i want to pick data from different section. e.g. i am creating table where im fetching testcase details and i also want host name which is available in Run its not getting populated as required.

If anyone has come across such issue please suggest how did you resolve it 

 

ALM REST API - JAVA - Connection refused: connectOpen in a New Window

I got connectio nrefused error in below code

new test().authenticateLoginLogoutExample("http://" + Constants.HOST+ ":" +Constants.PORT + "/qcbin",Constants.DOMAIN,Constants.PROJECT,Constants.USERNAME,Constants.PASSWORD);

Error :

Exception in thread "main" java.net.ConnectException: Connection refused: connect

 

My QC doesn't have port number, its a full URL like "http://COMPANYURL.com/qcbin". Can someone help me how to fix the code?

 

Migrating ALM 12.00 project to new ALM 12..00Open in a New Window

Hello 

I am doing planning for migrating ALM projects from One server to Another ALM Server. 

Can you please point me to the right documents

Thanks

Saurabh

 

For defect or at Test Lab : video recording optionOpen in a New Window

Currently in HP ALM while creating defect we have option to attach the proof or we can capture the screen.

 

It would be better to have video recording option. While executing we can record all the steps.

This is also applicable at Test Lab attaching execution screenprint if we have video option.

while executing the test case we can enable the video option and it will capture all the steps accordingly..

 

Vishnu

 

Best practice for workflow editing in Template ProjectsOpen in a New Window

Hi, I find the process of developing workflow scripts in a Template project to be laborous. Everytime I want to test a change I need to:

  1. Save the script
  2. Cross-project customization Verify and then Apply
  3. Exit Template Project customisation 
  4. Switch to my target test project
  5. Perform the test
  6. Switch back to template project
  7. Enter customization and open the script again  

That's very tedious. Probably there's a better way, I'd love to hear about it. thanks in advance.

 

Compile Error : User-defined type not definedOpen in a New Window

Hi Team,

I am looking to connect perfromance center 12.20 using excel macro. 

facing "Compile Error : User-defined type not defined" at the first line of the code. which is - 'Public tdC As New tdConnection'

if i comment that line and try to create object using createobject function - "Set tdC = CreateObject("TDApiOle80.tdConnection")" facing error message "activeX component can't create object".

I suppose i am missing some dll files. kindly look into below code and suggest. Thanks in advance

 

Public tdC As New tdConnection


Sub ConnectToQualityCenter()

Dim qcURL As String
Dim qcID As String
Dim qcPWD As String
Dim qcDomain As String
Dim qcProject As String
Dim tdConnection As Object

On Error GoTo err
qcURL = "http://hppcbccwd2alm01:8080/qcbin/start_a.jsp"
qcID = "iiiiiii"
qcPWD = "ppppppppp"
qcDomain = "PERSONAL"
qcProject = "Migration"

Application.StatusBar = "Connecting to Quality Center.. Wait..."

Set tdC = CreateObject("TDApiOle80.tdConnection")

tdC.InitConnectionEx qcURL

tdC.Login qcID, qcPWD

tdC.Connect qcDomain, qcProject

Application.StatusBar = "........QC Connection is done Successfully"
Exit Sub
err:
'Display the error message in Status bar
Application.StatusBar = err.Description
End Sub

 

Export to Excel from Test LabOpen in a New Window

I've seen a lot of similar problems on here but none that have clearly articulated the solution to extracting the Test Cases and their Test Steps from the Test LAB to an Excel spreadsheet.

Given the noise on the subject, why hasn't HP developed an extract that does this from the menu?

The problem I have is that I've a lot of Test Cases in the Test LAB which have been executed but they have no corresponding library entries in the Test Plan and I need to retro-fit the information.

Anything anyone can suggest (that works!) would be really helpful.

 

 

XTools.Run to Invoke batch file. Code working with ALM 12 but not with ALM SaaS Trial.Open in a New Window

I have used XTools.Run to Invoke a batch file from VAPI-XP test in Test Plan. Same code is working with ALM 12 Desktop version but not working with ALM SaaS Trial. Batch file is not getting invoked. What could be the possible reason? Help me in troubleshooting the same.

 

QTP scripts is not running when we running the script by using OTAOpen in a New Window

QTP scripts  is not running when we running the script by using OTA.attaching the screen shot.Please help me on this.

 

Problem OTA 64 bitsOpen in a New Window

Has anyone found any solutions to the OTA 64bit problem?
I am using ALM 12.53 and this problem remains, I can only run with office 32bits.

 

Calculate Defect TATOpen in a New Window

I am looking for a query that can be used to calculate the Defect Turnaround time of a defect which satisfies the following condition.

TAT is calculated based on the time difference between Defect status = "new" and Defect Status "For Retest".

If Defect was raised against A and defect was closed against B , then the TAT hours should be calculated from only the time when the defect was assigned to B and not A until the defect was moved to retest.

 

I am using HP ALM tool.

 

Attachments at step level via RESTOpen in a New Window

Hi!

I am building a library for QC, and I am having trouble uploading files at step level.

I already have made attachments through defects and test case level, but I am not being able to attach files via REST at step levels.

This is for example what I made to attach at run level:

/qcbin/rest/domains/DEFAULT/projects/TestProject/runs/2/attachments

using POST as a multipart form data, perfect, but when I do try with steps:

/qcbin/rest/domains/DEFAULT/projects/TestProject/runs/2/run-steps/1/attachments

 

I get error 404, even though /qcbin/rest/domains/DEFAULT/projects/TestProject/runs/2/run-steps/1 exists, and steps in QC has attachments, I am not being able to attach files with it. Is it different than how it works with both defects and runs?

I am using Java with Apache fluent, all the rest is ok, but at step level I can't manage to make it work

 

If someone could help me with that, I will be very glad!

 

Thanks :) .

 

 

 

Anyone seen this error before?Open in a New Window

Attempting to create a new linked project from a template. The template project has gone offline as well, which is a bit worrying to say the least...

oops.png

 

How to fetch Testcase being executed from scheduler ?Open in a New Window

Hello 

 

I have a two part query. 

 

1. How one can get the test case being run via ALM Scheduler using OTA. Intention is to get the Current testcase under execution initiated by ALM Scheduler. 

2. If Query#1 if at all possible, is there any possibility to fetch the Target Cycle Assigned to Testcase being run by the scheduler ?

 

Any help or guidance will be appreciated. 

 

Thanks in advance. 

 

 

HP ALM Rest API 401 Unauthorized Create Defect C# .NETOpen in a New Window

Hello !

I can not create a Defect in HP ALM, 

When I request to create a defect I receive a 401 Unauthorized...

From what I understood from API:

  1. Authenticate (HttpRequest on /api/authentication/sign-in) and retrieve the following cookies "LWSSO_COOKIE_KEY", "QCSession", "ALM_USER", "XSRF-TOKEN";
  2. A session (HttpRequest on /rest/site-session) must be initialized by placing the retrieved cookies in the header and then retrieving the last "JSESSIONID" cookie;
  3. Finally, I request HTTP at this address "/rest/domains/" + HPALMDomain + "/projects/" + HPALMProject + "/defects" by placing all the cookies.

Each of the steps go perfectly well, I retrieve each time the cookies that I reuse for the following query. I have already tried to place only certain cookies at certain times.

Here is my source code, if you could help me it would be great!

public static class HPALMHelper
{
    #region Properties

    private static string HPALMUrl = ConfigurationManager.AppSettings["HPALMUrl"];
    private static string HPALMDomain = ConfigurationManager.AppSettings["HPALMDomain"];
    private static string HPALMUserName = ConfigurationManager.AppSettings["HPALMUserName"];
    private static string HPALMPassWord = ConfigurationManager.AppSettings["HPALMPassWord"];
    private static string HPALMProject = ConfigurationManager.AppSettings["HPALMProject"];

    #endregion

    private static string Base64Encode(string plainText)
    {
        var plainTextBytes = System.Text.Encoding.UTF8.GetBytes(plainText);

        return Convert.ToBase64String(plainTextBytes);
    }

    /*private static WebResponse ConnectHPALM()
    {
        #region Authentication Request

        string StrServerLogin = HPALMUrl + "/api/authentication/sign-in";
        HttpWebRequest authRequest = (HttpWebRequest)WebRequest.Create(StrServerLogin);
        authRequest.Headers[HttpRequestHeader.Authorization] = "Basic " + Base64Encode(HPALMUserName + ":" + HPALMPassWord);
        WebResponse authResponse = authRequest.GetResponse();

        #endregion

        return authResponse;
    }*/

    private static WebResponse ConnectHPALM(out string SSOCookie)
    {
        #region Authentication Request

        string StrServerLogin = HPALMUrl + "/api/authentication/sign-in";
        HttpWebRequest authRequest = (HttpWebRequest)WebRequest.Create(StrServerLogin);
        authRequest.Headers[HttpRequestHeader.Authorization] = "Basic " + Base64Encode(HPALMUserName + ":" + HPALMPassWord);
        WebResponse authResponse = authRequest.GetResponse();

        #endregion

        #region Session Request

        Uri target = new Uri(HPALMUrl);
        string SiteSession = HPALMUrl + "/rest/site-session";
        HttpWebRequest createSessionRequest = (HttpWebRequest)WebRequest.Create(SiteSession);
        createSessionRequest.Method = "POST";

        createSessionRequest.CookieContainer = new CookieContainer();
        string AuthCookies = authResponse.Headers.ToString();

        string LWSSOCookie = AuthCookies.Substring(AuthCookies.IndexOf("LWSSO_COOKIE_KEY=") + 17);
        LWSSOCookie = LWSSOCookie.Substring(0, LWSSOCookie.IndexOf(";"));
        createSessionRequest.CookieContainer.Add(new Cookie("LWSSO_COOKIE_KEY", LWSSOCookie) { Domain = target.Host });

        string QCSessionCookie = AuthCookies.Substring(AuthCookies.IndexOf("QCSession=") + 10);
        QCSessionCookie = QCSessionCookie.Substring(0, QCSessionCookie.IndexOf(";"));
        createSessionRequest.CookieContainer.Add(new Cookie("QCSession", QCSessionCookie) { Domain = target.Host });

        string UserCookie = AuthCookies.Substring(AuthCookies.IndexOf("ALM_USER=") + 9);
        UserCookie = UserCookie.Substring(0, UserCookie.IndexOf(";"));
        createSessionRequest.CookieContainer.Add(new Cookie("ALM_USER", UserCookie) { Domain = target.Host });

        string TokenCookie = AuthCookies.Substring(AuthCookies.IndexOf("XSRF-TOKEN=") + 12);
        TokenCookie = TokenCookie.Substring(0, TokenCookie.IndexOf(";"));
        createSessionRequest.CookieContainer.Add(new Cookie("XSRF-TOKEN", TokenCookie) { Domain = target.Host });

        SSOCookie = LWSSOCookie;

        createSessionRequest.Headers[HttpRequestHeader.Authorization] = "Basic " + Base64Encode(HPALMUserName + ":" + HPALMPassWord);
        WebResponse createSessionResponse = createSessionRequest.GetResponse();

        #endregion

        return createSessionResponse;
    }

    private static WebResponse LogOutHPALM()
    {
        #region Authentication Request

        string StrServerLogin = HPALMUrl + "/api/authentication/sign-out";
        HttpWebRequest authRequest = (HttpWebRequest)WebRequest.Create(StrServerLogin);
        authRequest.Headers[HttpRequestHeader.Authorization] = "Basic " + Base64Encode(HPALMUserName + ":" + HPALMPassWord);
        WebResponse authResponse = authRequest.GetResponse();

        #endregion

        return authResponse;
    }

    public static HttpStatusCode CreateDefect(string entity, out string createDefectResponseURL)
    {
        string SSOCookie;
        WebResponse authResponse = ConnectHPALM(out SSOCookie);

        HttpWebRequest createDefectRequest = (HttpWebRequest)WebRequest.Create(HPALMUrl + "/rest/domains/" + HPALMDomain + "/projects/" + HPALMProject + "/defects");
        createDefectRequest.Method = "POST";
        Uri target = new Uri(HPALMUrl);

        #region Stream Datas

        using (var defectDatas = new StreamWriter(createDefectRequest.GetRequestStream()))
        {
            defectDatas.Write(entity);
            defectDatas.Flush();
            defectDatas.Close();
        }

        #endregion

        #region Header

        createDefectRequest.Headers.Add("Accept-Language", "en-US,en;q=0.8,he;q=0.6");
        createDefectRequest.Headers.Add("Accept-Encoding", "gzip, deflate, sdch");
        createDefectRequest.KeepAlive = true;
        createDefectRequest.Accept = "application/json";
        createDefectRequest.ContentType = "application/json";

        #endregion

        #region Get & Set all cookies

        createDefectRequest.CookieContainer = new CookieContainer();

        string AuthCookies = authResponse.Headers.ToString();

        /*string JSESSIONIDCookie = AuthCookies.Substring(AuthCookies.IndexOf("JSESSIONID=") + 11);
        JSESSIONIDCookie = JSESSIONIDCookie.Substring(0, JSESSIONIDCookie.IndexOf(";"));
        createDefectRequest.CookieContainer.Add(new Cookie("JSESSIONID", JSESSIONIDCookie) { Domain = target.Host });*/

        //createDefectRequest.CookieContainer.Add(new Cookie("LWSSO_COOKIE_KEY", SSOCookie) { Domain = target.Host });

        /*string QCSessionCookie = AuthCookies.Substring(AuthCookies.IndexOf("QCSession=") + 10);
        QCSessionCookie = QCSessionCookie.Substring(0, QCSessionCookie.IndexOf(";"));
        createDefectRequest.CookieContainer.Add(new Cookie("QCSession", QCSessionCookie) { Domain = target.Host });

        string UserCookie = AuthCookies.Substring(AuthCookies.IndexOf("ALM_USER=") + 9);
        UserCookie = UserCookie.Substring(0, UserCookie.IndexOf(";"));
        createDefectRequest.CookieContainer.Add(new Cookie("ALM_USER", UserCookie) { Domain = target.Host });

        string TokenCookie = AuthCookies.Substring(AuthCookies.IndexOf("XSRF-TOKEN=") + 12);
        TokenCookie = TokenCookie.Substring(0, TokenCookie.IndexOf(";"));
        createDefectRequest.CookieContainer.Add(new Cookie("XSRF-TOKEN", TokenCookie) { Domain = target.Host });*/

        #endregion

        HttpWebResponse createDefectResponse = (HttpWebResponse)createDefectRequest.GetResponse();
        createDefectResponseURL = createDefectResponse.Headers.Get("Location");

        LogOutHPALM();

        return createDefectResponse.StatusCode;
    }

    public static string GetDefectId(string createDefectResponseURL)
    {
        if (!String.IsNullOrEmpty(createDefectResponseURL))
        {
            string defectId = createDefectResponseURL.Substring(createDefectResponseURL.LastIndexOf('/') + 1, (createDefectResponseURL.Length - (createDefectResponseURL.LastIndexOf('/') + 1)));

            return defectId;
        }

        return null;
    }
}

Thank you in advance !

Best regards,

Gary

Contact Us

Vivit Worldwide
P.O. Box 18510
Boulder, CO 80308

Email: info@vivit-worldwide.org

Mission

Vivit's mission is to serve
the Hewlett Packard
Enterprise User
Community through
Advocacy, Community,
and Education.