Import XLSX Sheet to UFT/QTP Datatable

Import XLSX Sheet to UFT/QTP Datatable Most of the people are facing problem with one of the major limitation of QTP/UFT. That is importing data from XLSX extension files. QTP/UFT does not support directly Import option below QTP/UFT 12 versions But using Excel Object Model we can overcome this problem.UFT 12 and above version can support this XLSX extension files. The below function will import the data from XLSX file to QTP/UFT specified...

Read More

How to change the order of Test Plan fields in Quality Center?

Using workflow to change the order of Test Plan fields Custom workflow is required to change the order of the fields in the Test Plan module. The order is changed using the ViewOrder property. The ViewOrder must be modified in both the Test_New and Test_MoveTo subroutines. Fields are displayed Left to Right, Top to Bottom. See the example below. Sub Test_New ‘Remember to also include in the Test_MoveTo subroutine ... Test_Fields("TS_NAME").ViewOrder=10   'Test Name fieldTest_Fields("TS_TEST_ID").ViewOrder=20   'Test ID fieldTest_Fields("TS_USER_03").ViewOrder=30...

Read More

Error when adding a User Defined Field, v11.52

Error when adding a User Defined Field, v11.52 When trying to add a custom user defined field in a project that was created originally in Quality Center 9.2 or earlier, a memory protected or corrupted error may occur. Workaround: Run the following query on the project's schema: For SQL Server: UPDATE td.SYSTEM_FIELDSET SF_ROOT_ID=NULLWHERE SF_ROOT_ID = 0 ANDSF_COLUMN_NAME <> 'CF_FATHER_ID' ANDSF_COLUMN_NAME <> 'CY_FOLDER_ID' For Oracle: UPDATE .SYSTEM_FIELDSET SF_ROOT_ID=NULLWHERE SF_ROOT_ID = 0 ANDSF_COLUMN_NAME <>...

Read More

Limit Test Plan field change

Limit Test Plan field change First create a new user field in Test under Project Entities in Project Customization. This is the field that we will use to hold the user that last changed the field to “Design” once that user has changed the value to Design they should not be able to change the status again. In a sense what we are doing is locking the test when it is changed to “Design” so that the user that last made the change might not try to circumvent the rules by changing the status to something else and then try and jump straight to...

Read More

How to retreive TestLab execution report using Excel Reports

How to retreive Test Lab execution report using Excel Reports The below query will give you the Testlab execution report wrt Testlab folder Id'sSelect CF_ITEM_NAME FOLDER,CY_CYCLE TESTSET_NAME,TEST.TS_NAME TEST_SCRIPT,RUN.RN_RUN_NAME RUN_NAME,RN_RUN_ID RUN_ID,RN_STATUS RUN_EXECUTION_STATUS,RN_TESTER_NAME LAST_TESTER_NAME ,RUN.RN_EXECUTION_DATE,TEST.TS_TEST_IDFrom CYCLE,RUN,TEST,TESTCYCL, CYCL_FOLDWhere CYCLE.CY_FOLDER_ID=CYCL_FOLD.CF_ITEM_IDAND TESTCYCL.TC_CYCLE_ID=CYCLE.CY_CYCLE_IDAND TEST.TS_TEST_ID=TESTCYCL.TC_TEST_IDAND RUN.RN_CYCLE_ID=TESTCYCL.TC_CYCLE_IDAND...

Read More

Quality Center / ALM site admin password change oracle

Quality Center / ALM  site admin password change oracle Changing the Site Administrator Schema password for QC installed on Oracle The Site Administrator connects to the Site Admin schema by decrypting the password in the td_siteadmin.xml file, then connects to the database back-end using the decrypted password. Since there is no direct way of changing the Site Admin schema, the instructions below will demonstrate how to generate a new encrypted password and insert that into the td_siteadmin.xml file. An update query will also be...

Read More

Quality Center / ALM LDAP

Quality Center LDAP How to change the authentication from LDAP to Quality Center when LDAP server is down?Below are the steps to change the Authentication from LDAP to QC.1.In the qcsiteadmin_db database, find the PARAMS table.2. Look for the record where PARAM_NAME = 'Authentication'. Change the PARAM_VALUE to 'QualityCenter'.3. Look for records where PARAM_NAME starts with 'LDAP', and delete all of them except one 'LDAP_SEARCH_USER_CRITIRIA'.4. Restart the Quality Center service using the Quality Center icon in system tray.5. Users...

Read More