Xmind用例匯入到TAPD的解決方案

#修改表頭
def xmind_to_zentao_csv_file(xmind_file):
    """Convert XMind file to a zentao csv file"""
    xmind_file = get_absolute_path(xmind_file)  #路徑處理
    logging.info('Start converting XMind file(%s) to zentao file...', xmind_file)
    testcases = get_xmind_testcase_list(xmind_file) #解析xmind檔案，得到原始資料
    # print("testcases",testcases)
    #fileheader =      ["所屬模組","用例標題","前置條件","步驟", "預期", "關鍵詞>用例狀態", "優先順序", "用例型別", "適用階段?"]
    fileheader_tapd = ["用例目錄","用例名稱","需求ID","前置條件","用例步驟","預期結果","用例型別","用例狀態","用例等級","建立人","測試結果","備註說明"]
 
    zentao_testcase_rows = [fileheader_tapd]
    for testcase in testcases:
        #row = gen_a_testcase_row(testcase)
        row = gen_a_testcase_row_tapd(testcase)
        zentao_testcase_rows.append(row)
    zentao_file = xmind_file[:-6] + '.csv'
    if os.path.exists(zentao_file):  #判斷括號裡的檔案是否存在
        os.remove(zentao_file)
        # logging.info('The zentao csv file already exists, return it directly: %s', zentao_file)
        # return zentao_file
 
    with open(zentao_file, 'w', encoding='utf8') as f:
        writer = csv.writer(f)
        writer.writerows(zentao_testcase_rows)
        logging.info('Convert XMind file(%s) to a zentao csv file(%s) successfully!', xmind_file, zentao_file)
 
    return zentao_file
    
#修改為tapd的資料格式、增加獲取需求ID
def gen_a_testcase_row_tapd(testcase_dict):
 
    #用例標題
    case_title = testcase_dict['name']
    #需求ID         產品名稱裡的目錄獲取  
    requirement_id, product_catalog = gen_requirement_id(testcase_dict['product'])
    # 所屬模組
    case_module =product_catalog +"-" + gen_case_module(testcase_dict['suite'])
 
    #前置條件
    case_precontion = testcase_dict['preconditions']
    #步驟       預期結果
    case_step, case_expected_result = gen_case_step_and_expected_result(testcase_dict['steps'])
    #用例型別
    case_type = gen_case_type(testcase_dict['execution_type'])
    # case_type = "功能測試"
    #用例狀態
    case_status = "正常"
    #用例等級
    case_priority = gen_case_priority(testcase_dict['importance'])
    #建立人
    case_created_by = ""
    #測試結果
    case_actual_result= ""
 
    row = [case_module,case_title,requirement_id,case_precontion,case_step,case_expected_result,case_type,case_status,case_priority,case_created_by,case_actual_result]
    return row
 
#修改用例型別
def get_execution_type(topics):
    labels = [topic.get('label', '') for topic in topics]
    labels = filter_empty_or_ignore_element(labels)
    exe_type = 1
    for item in labels[::-1]:
        if item.lower() in ['效能測試', '效能']:
            exe_type = 2
            break
        if item.lower() in ['功能測試', '功能']:
            exe_type = 1
            break
        if item.lower() in ['安全測試', '安全','安全性測試']:
            exe_type = 3
            break
        if item.lower() in ['其他']:
            exe_type = 4
            break
    return exe_type