Algape83 Absent Member.
Absent Member.
1012 views

Migrate Users and Passwords from QC 10 to ALM 11.5

Hi there,

 

I am migrating service QC 10 to ALM 11.5 (BD and new servers), reviewing my first migration, I see that users are not migrated with their full details (full name, email, password).

 

Do you know if there is a way to migrate?

 

The only way I find is to manually but are more than 100 users.

 

 

Thank you very much for your support.

0 Likes
4 Replies
Absent Member.. Trudy Claspill Absent Member..
Absent Member..

Re: Migrate Users and Passwords from QC 10 to ALM 11.5

Are you using LDAP authentication or QC authentication?

You could use the Site Admin API to extract the data from the v10 system and then add it to the v11.5 system.

You could copy the Site Admin database from your v10 system to the system where you will install v11.5, and then when you install v11.5 you can execute an upgrade on the existing Site Admin database.
[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
0 Likes
Algape83 Absent Member.
Absent Member.

Re: Migrate Users and Passwords from QC 10 to ALM 11.5

Password QC (QC authentication) is used.

Might explain me how to use the API Site Admin please? that is not how to use it.

Thank you very much for your help

0 Likes
Established Member.. William Schmitt
Established Member..

Re: Migrate Users and Passwords from QC 10 to ALM 11.5

You can get the list of site users from your old QC with the Site Admin API.  This code will do it:

 

Sub GetSiteUsers()
    Dim sReply As String
    Dim sa As New SACLIENTLib.SAapi
            
    sa.Login "http://xxx/qcbin", "sa_user", "sa_password"
         
    sReply = sa.GetAllUsers()
 
   sa.Logout
 
End Sub

 The returned value sReply is an XML string that looks like this:

 

<?xml version="1.0"?>
<GetAllUsers>
<TDXItem>
<USER_ID>258</USER_ID>
<USER_NAME>admin</USER_NAME>
<ACC_IS_ACTIVE>Y</ACC_IS_ACTIVE>
<FULL_NAME></FULL_NAME>
<EMAIL></EMAIL>
<USER_PASSWORD>DEF:2jmj7l5rSw0yVb/vlWAYkK/YBwk=</USER_PASSWORD>
<DESCRIPTION></DESCRIPTION>
<PHONE_NUMBER></PHONE_NUMBER>
<LAST_UPDATE>2007-06-19 17:56:08</LAST_UPDATE>
<US_DOM_AUTH></US_DOM_AUTH>
<US_REPORT_ROLE>0</US_REPORT_ROLE>
</TDXItem>
<TDXItem>
<USER_ID>461</USER_ID>
<USER_NAME>new user 2</USER_NAME>
<ACC_IS_ACTIVE>Y</ACC_IS_ACTIVE>
<FULL_NAME>New User</FULL_NAME>
<EMAIL>new@user.com</EMAIL>
<USER_PASSWORD>455290</USER_PASSWORD>
<DESCRIPTION>This is new user</DESCRIPTION>
<PHONE_NUMBER>123456789</PHONE_NUMBER>
<LAST_UPDATE>2007-07-01 14:28:43</LAST_UPDATE>
<US_DOM_AUTH></US_DOM_AUTH>
<US_REPORT_ROLE>0</US_REPORT_ROLE>
</TDXItem>
</GetAllUsers>

 

So you will have to parse it to extract information for each user. 

 

Then you can use the OTA to add the users to your new QC.  All user data can be migrated in this manner except for password.  In OTA, the CustomizationUser.AddSiteUser method will do this.  Check the OTA help for examples.

 

 

 

0 Likes
Highlighted
Absent Member.. pde Absent Member..
Absent Member..

Re: Migrate Users and Passwords from QC 10 to ALM 11.5

Hi,

 

You can do this directly in the database by extracting all the information from the USERS table (qcsiteadmin_db.td.USERS) in the old database and insert it in the new database. When you have inserted all the users in the new database, you must update the counter that keeps track of user ids in use.

 

For information about BCP, go to http://msdn.microsoft.com/en-us/library/ms162802.aspx.

 

Here's a description of how it can be done:


1) Extract the user information from the old database using Bulk Copy program (BCP)

 

1.1) Start a command prompt

 

1.2) Run this command:
bcp "SELECT * FROM [qcsiteadmin_db].[td].[USERS]" queryout "C:\Users\Administrator\Desktop\USER_EXPORT.txt" -c -U InsertUserName -S DatabaseServerName\DatabaseInstance

 

2) Insert the user information in the new database using Bulk Copy Program (BCP)

 

2.1) Start a command prompt

 

2.2) Run this command:
bcp [qcsiteadmin_db].[td].[USERS] in "C:\Users\Administrator\Desktop\USER_EXPORT.txt" -c -U InsertUserName -S DatabaseServerName\DatabaseInstanceName
 

3) Update the user counter value

 

3.1) Open a database query on qcsitadmin_db

 

3.2) Find the highest USER_ID in the USERS table by running this SQL:
SELECT MAX (USER_ID)
FROM [qcsiteadmin_db].[td].[USERS]


3.3) Update the counter by running this SQL:
UPDATE [qcsiteadmin_db].[td].[SEQUENCES]
SET SQ_SEQ_VALUE = InsertTheResultFrom3.2
WHERE SQ_SEQ_NAME = 'USER_SEQ'

 

 

Regards,
PDE

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.