Need to automate user adding and role assigning process in QC v11

[chept]

Hi All,

We have QC v11 and I am supporting for the same in Global level, in our project there will be minimum 5 to 6 mails for user adding, its taking our lot of time.

Can you suggest is there any way we can automate this process ?

[Anton_Labachev]

Hello Chept,

I would like to inform you that you can use Site Administration API for automating this.

You can find Site Admin API Reference Guide on the following URL:

http://support.openview.hp.com/selfsolve/document/KM997954

There is a method called SetUserProperty with which you can set email for specific user.

How to use this method you can check in the following article:

http://support.openview.hp.com/selfsolve/document/KM183366

I hope this helps.

[chept]

Hi Anton,

Thanks for response,

Actually i need this,

just by running one query in DB or in site admin i must be able to add user and same for assigning roles in project level.

or 

Using Excel Macros import user details ?

[Trudy Claspill]

I know that the Site Admin API provides a method for adding users to the site, because I do this. I think that there might be Site Admin APIs to add users to projects, but I'm not positive (and don't have access to the reference documents at this moment). Have you tried reviewing the Site Admin API Reference document?

[Srihari-]

Hi Chept,

Using Site Admin First Add the User into Site Admin Users List.

Ex:

Site Admin API functionality DLL can be found here: C:\Users\<<<USER ID>>>\AppData\Local\HP\ALM-Client\almdev\SAClient.dll

OTA API functionality DLL can be found here: C:\Users\<<<USER ID>>>\AppData\Local\HP\ALM-Client\almdev\OTAClient.dll

Below are the sample programs which got successfully executed:

Module Module1

    Sub Main()

        Dim objSAClient

        objSAClient = CreateObject("SAClient.SaApi.9")        'you have to know which is the correct reference to the SiteAdmin

        'then login as admin:

        objSAClient.login("http://almdev/qcbin", "svanumu", "ABCD")

        'List all the projects in the SiteAdminsitrator

        Console.WriteLine("I am connected to the Site Administrator Link")

        Console.WriteLine("Adding User to Site Administrator")

        objSAClient.CreateUserEx("UserID", "User Name", "mail id", "phone number", "Naveen Details", "dummy", "uniqueIdentifier=104393,ou=people,dc=Enterprise,dc=Organization,dc=com")

     '   objSAClient.AddUsersToProject("DEFAULT", "AMGEN_ERP", "UserID")

        Console.WriteLine("User Added to Site Administration")

        Console.ReadLine()

    End Sub

After this using the OTA API add the roles to that User in a specific project.

To automate this process you can accept values like userid, roles and project name as a input from webpage and provide them as parameters to functions using this SiteAdmin and OTA api.

Regards,

Srihari

[chept]

Good day,

Sorry, i have less knowledge in this.

Using VB or shall i use Excel Macro to run this ?

[Srihari-]

Hi Chept,

Please go through below program , you will understand how to grant and remove roles in ALM User Site.

http://loadtestingnotes.wordpress.com/2014/01/21/how-to-remove-all-the-user-roles-except-inactive-role-for-genilogix-template-projects/

Regarding Automation:

You can call the methods of OTAClient.dll or SAClient.dll from a C#.Net webprogram or VBScript or VB or VB.NET

Site Admin API functionality DLL can be found here: C:\Users\<<<USER ID>>>\AppData\Local\HP\ALM-Client\almdev\SAClient.dll

OTA API functionality DLL can be found here: C:\Users\<<<USER ID>>>\AppData\Local\HP\ALM-Client\almdev\OTAClient.dll

Regards,

Srihari

[Anil Nandam]

We have Cloud version of ALM and I have Admin access.

I confirm that I opened IE as Admin and Register HP Site Admin components on the machine successfully.

I am getting the following error when trying to create an object for SAClient.SaApi.9:

Description: User has no permission to access application

Please help