QC11 用excel导入测试用例，总提示"主题"值不对，怎么解决

hkxgzxt1987

QC11 用excel导入测试用例，总提示"主题"值不对，怎么解决？最好给分享个完善的模板，谢啦

fhhh_eyou

value属性值信息错误。

hkxgzxt1987

没人用QC吗？这个应该经常用啊

hkxgzxt1987

1. Make sure that the project has been backed up recently
2. Login to Site Administration and select the affected project
3. Click on the + next to the project name from the Site Projects screen to see the list of tables in this projecta s DB
4. Select the SYSTEM_FIELDS table
5. Paste the following query and click on a Execute SQLa button. Make a note of the SF_ROOT_ID (pointer to a list maintained in the ALL_LIST table) value for this record
SELECT * FROM SYSTEM_FIELD WHERE SF_COLUMN_NAME='TS_SUBJECT'
6. Verify that there is no list associated with this root id:
SELECT * FROM ALL_LISTS WHERE AL_ITEM_ID = (SELECT SF_ROOT_ID FROM SYSTEM_FIELD WHERE SF_COLUMN_NAME='TS_SUBJECT')
7. Verify that the default list we intend to use for the a Subjecta field still exists:
SELECT * FROM ALL_LISTS WHERE AL_ITEM_ID = 2
8. Update the SYSTEM_FIELD table so that the a Subjecta field correctly points to an existing list
UPDATE SYSTEM_FIELD SET SF_ROOT_ID=2 WHERE SF_COLUMN_NAME='TS_SUBJECT'
9. Verify that the changes were made as expected
SELECT SF_ROOT_ID FROM SYSTEM_FIELD WHERE SF_COLUMN_NAME='TS_SUBJECT'
10. Update the SEQUENCES table so that QC knows that fields have been modified
UPDATE SEQUENCES SET SQ_SEQ_VALUE = SQ_SEQ_VALUE+1 WHERE SQ_SEQ_NAME IN ('FIELDS_VERSION', 'TABLES_VERSION')
11. Verify that the updates were made correctly
SELECT * FROM SEQUENCES WHERE SQ_SEQ_NAME IN ('FIELDS_VERSION', 'TABLES_VERSION')
12. Logout of Site Administration
13. Export Tests to QC using Excel add-in and verify that Tests are exported and no errors are noticed

hkxgzxt1987

自己解决了，还是谷歌搜索好用啊

猫星人

其实很少用。。。。

休言一缘强为牵

用英文试试