201232252 六、發明說明: 【發明所屬之技術領域】 [0001] 本發明涉及一種測試報告生成系統及方法。 【先前技ί标】 [0002] 在電腦主板生產過程中,需要對主板的PCI-E (Peripheral Component Interconnect Express,高速外 設元件互連標準)介面進行測試。測試完成以後所產生 的測試結果會存儲在一個測試結果檔案中。所述測試結 果檔案中包括測試過程所產生的各種測試參數值以及眼 圖等資訊。該測試結果檔案中所包含的各種參數以及眼 圖很多,整理起來相當的不容易。當測試完成,製作測 試報告時,需要測試人員將各種參數以及眼圖手動添加 到測試報告的相應位置處,耗費許多的時間,且容易出 錯。 【發明内容】 [0003] 鑒於以上内容,有必要提供一種測試報告生成系統,其 將測試結果檔案中的參數和眼圖自動添加到測試報告範 本的相應位置中,可以快速生成測試報告。 [0004] 還有必要提供一種測試報告生成方法,其使用電腦將測 試結果檔案中的參數和眼圖自動添加到測試報告範本的 相應位置中,可以快速生成測試報告。 [0005] 所述測試報告生成系統,用於將PCI-E介面經測試所獲得 的測試結果檔案整理成測試報告,該系統包括:建立一 個E X c e 1格式的測試報告範本'並在該測試報告範本的弟 一張工作表中為PCI-E介面的每個測試專案建立一個參數 100101573 表單編號A0101 第4頁/共17頁 1002002811-0 201232252 Ο 欄位的模組;在該測試報告範本的第二張工作表中,為 PCI-E介面的每個通道建立一個貼圖欄位的模組;讀取該 測試結果檔案,並從該測試結果檔案中獲取PCI-E介面各 測試專案對應的通道名稱、測試參數值,及測試結果的 模組;將上述獲取的各測試專案對應的通道名稱、測試 參數值及測試結果依次填入上述在第一張工作表中各測 試專案對應的參數欄位中的模組;從該測試結果檔案中 依次獲取PCI-E介面每個通道對應的眼圖,並將獲取的眼 圖依次填入上述在第二張工作表中為每個通道所建立的 貼圖櫊位中的模組;及調整第二張工作表的分頁線,保 存調整後的測試報告範本,生成PCI-E介面的測試報告的 模組。 [0006]201232252 VI. Description of the Invention: [Technical Field of the Invention] [0001] The present invention relates to a test report generation system and method. [Previous technical 标 】 [0002] In the production process of the computer motherboard, the PCI-E (Peripheral Component Interconnect Express) interface of the motherboard needs to be tested. Test results generated after the test is completed are stored in a test result file. The test result file includes information such as various test parameter values and eye diagrams generated by the test process. The various parameters and eye diagrams included in the test result file are quite difficult to organize. When the test is completed and the test report is produced, the tester is required to manually add various parameters and eye diagrams to the corresponding positions of the test report, which takes a lot of time and is prone to error. SUMMARY OF THE INVENTION [0003] In view of the above, it is necessary to provide a test report generation system that automatically adds parameters and eye diagrams in a test result file to corresponding positions of a test report template, and can quickly generate a test report. [0004] It is also necessary to provide a test report generation method that automatically adds a parameter and an eye diagram in a test result file to a corresponding position of a test report template using a computer, and can quickly generate a test report. [0005] The test report generation system is configured to organize a test result file obtained by testing a PCI-E interface into a test report, and the system includes: establishing a test report template in an EX ce 1 format and in the test report Fan Ben's brother creates a parameter for each test project of the PCI-E interface in a worksheet. 100101573 Form No. A0101 Page 4 / Total 17 Page 1002002811-0 201232252 模组 Module of the field; in the test report template In the two worksheets, a module for mapping fields is established for each channel of the PCI-E interface; the test result file is read, and the channel name corresponding to each test project of the PCI-E interface is obtained from the test result file. And the module for testing the parameter value and the test result; the channel name, the test parameter value and the test result corresponding to the test items obtained above are sequentially filled in the parameter fields corresponding to the test items in the first work table. The module is obtained from the test result file, and the eye diagram corresponding to each channel of the PCI-E interface is sequentially obtained, and the acquired eye diagram is sequentially filled in the second worksheet as described above. Ge bit map established channels in the module; tab line and adjustment of the second sheet, test reports template saved after adjustment module generates a PCI-E interface test report. [0006]
所述測試報告生成方法,用於將PCI-E介面經測試所獲得 的測試結果檔案整理成測試報告,該方法包括步驟:建 立·個Excel格式的測試報告範本’並在該測試報告範本 的第一張工作表中為PC I-E介面的每個測試專案建立一個 參數欄位;在該測試報告範本的第二張工作表中,為 PCI-E介面的每個通道建立一個貼圖欄位;讀取該測試結 果檔案,並從該測試結果檔案中獲取PCI-E介面各測試專 案對應的通道名稱、測試參數值及測試結果;將上述獲 取的各測試專案對應的通道名稱、測試參數值及測試結 果依次填入上述在第一張工作表中各測試專案對應的參 數欄位中;從該測試結果檔案中依次獲取PCI-E介面每個 通道對應的眼圖,並將獲取的眼圖依次填入上述在第二 張工作表中為每個通道所建立的貼圖欄位中;及調整第 100101573 表單編號A0101 第5頁/共17頁 1002002811-0 201232252 二張工作表的分頁線,保存調整後的測試報告範本生 成PCI-E介面的測試報告。 [0007] [0008] [0009] 相較於f知技術’所制試報告生«統及方法,其將 測試結果㈣巾的參數和_自躲加到職報告範本 的相應位置中’可以快速生成測試報告,避免了手動添 加資料時容易出現的錯誤。 【實施方式】 如圖1所不’係本發明測試報告生成系統的運行環境架構 圖。該測試報告生成系統1〇運行於電腦1中。該電腦1的 。己隐體11中存儲有對P c卜E介面進行測試所獲得的測試結 果檔案110。該PCI-E介面可以為四通道(pCI_Ex4)、 十六通道(PCI-Exl6)等各種規格。 測試結果檔案11 G中包括所述P CI - E介面進行的測試專案 、每個測試專案測試了 PCI-E介面的哪些通道、對每個測 試專案進行測試所得到的測試參數值和測試結果、以及 對每個通道進行測試後所產生的眼圖等各種測試資料。 所述測試結果為通過(paSlS)或失敗(fail) ^所述眼 圖是反映PCI-E介面通道資料傳輸性能的圖形,該眼圖包 括轉換眼圖和非轉換眼圖兩種類型。例如,pci_E介面進 行的測試專案之一為資料傳輸率,該資料傳輸率測試專 案測試到了 PCI-E的6個通道,各通道的名稱依次為The test report generation method is used to organize a test result file obtained by testing a PCI-E interface into a test report, and the method includes the steps of: establishing an Excel test report template and in the test report template Create a parameter field for each test project of the PC IE interface in a worksheet; in the second worksheet of the test report template, create a map field for each channel of the PCI-E interface; read The test result file, and the channel name, the test parameter value and the test result corresponding to each test item of the PCI-E interface are obtained from the test result file; the channel name, the test parameter value and the test result corresponding to the test items obtained above are obtained. Fill in the parameter fields corresponding to the test items in the first worksheet in turn; obtain the eye diagram corresponding to each channel of the PCI-E interface in turn from the test result file, and fill in the acquired eye patterns in turn. In the map field established for each channel in the second worksheet; and adjustment 100101573 Form No. A0101 Page 5 / Total 17 Page 1002002811-0 20 1232252 The paging line of two worksheets, save the adjusted test report template to generate a test report of the PCI-E interface. [0008] [0009] [0009] Compared with the "reported technology" test report and the method, the test results (four) towel parameters and _ self-hiding in the corresponding position of the job report template 'can be fast Generate test reports to avoid errors that are easy to add when adding data manually. [Embodiment] FIG. 1 is a diagram showing an operating environment architecture of a test report generation system of the present invention. The test report generation system 1 runs on the computer 1. The computer 1's. The test result file 110 obtained by testing the P c E interface is stored in the hidden body 11. The PCI-E interface can be of various specifications such as four channels (pCI_Ex4) and sixteen channels (PCI-Exl6). The test result file 11G includes the test program of the P CI-E interface, which channels of the PCI-E interface are tested for each test project, test parameter values and test results obtained by testing each test project, And various test data such as eye diagrams produced after testing each channel. The test result is a pass (paSlS) or a fail (fail). The eye diagram is a graph reflecting the performance of the PCI-E interface channel data transmission, and the eye diagram includes two types: a converted eye diagram and a non-converted eye diagram. For example, one of the test projects conducted by the pci_E interface is the data transfer rate. The data transfer rate test program tests six channels of PCI-E, and the names of the channels are
PortO、P〇rtl、port2、P〇rt3、P〇rt4、P〇rt5,該資 料傳輸率對應的測試參數值包括最大單元間隙值、最小 單元間隙值和平均單元間隙值等。 [0010] 100101573 測試報告生成系統1 〇用於從記憶體1 J 表單編號A0101 第6頁/共17頁 中讀取測試結果檔 1002002811-0 201232252 案110中的測試資料,從而獲得PCI-E介面的各個測試專 案對應的PCI-E介面通道、測試參數值和測試結果,以及 每個通道測試後產生的眼圖等,並根據讀取的該測試資 料生成對PC I -E介面進行測試的測試報告。該測試報告生 •成系統10包含一個或多個功能模組,該一個或多個功能 模組是具有特定功能的軟體程式段,該等軟體程式段存 儲於電腦1的可讀存儲介質或其他存儲設備中,可被電腦 1或其他包含處理器的計算裝置執行,從而完成本發明中 生成測試報告的作業流程。 Ο [0011] 下面結合圖2,對測試報告生成系統10生成測試報告的方 法進行詳細說明。 [0012] 如圖2所示,係本發明測試報告生成方法較佳實施例的流 程圖。所述測試報告生成系統10通過執行以下所述的步 驟來完成生成測試報告的作業流程。 [0013] 步驟S01,建立一個Excel格式的測試報告範本,並在該 測試報告範本的第一張工作表中為PCI-E介面的每個測試PortO, P〇rtl, port2, P〇rt3, P〇rt4, P〇rt5, the test parameter values corresponding to the data transmission rate include the maximum cell gap value, the minimum cell gap value, and the average cell gap value. [0010] 100101573 Test report generation system 1 〇 for reading the test data in the test result file 1002002811-0 201232252 case 110 from the memory 1 J form number A0101 page 6 of 17 to obtain the PCI-E interface Each test project corresponds to the PCI-E interface channel, test parameter values and test results, and the eye diagram generated after each channel test, and generates a test for testing the PC I-E interface based on the read test data. report. The test report generation system 10 includes one or more function modules, which are software sections having specific functions, which are stored in the readable storage medium of the computer 1 or other The storage device can be executed by the computer 1 or other computing device including the processor, thereby completing the workflow of generating the test report in the present invention. [0011] A method of generating a test report by the test report generation system 10 will be described in detail below with reference to FIG. [0012] As shown in FIG. 2, it is a flow chart of a preferred embodiment of the test report generation method of the present invention. The test report generation system 10 completes the workflow of generating a test report by performing the steps described below. [0013] Step S01, creating a test report template in Excel format, and testing each test of the PCI-E interface in the first worksheet of the test report template.
Q 專案建立一個參數欄位。該參數攔位在該第一張工作表 中的某幾列某幾櫊所在的區域,例如PCI-E介面的某個測 試專案對應的參數欄位為該第一張工作表中第2列至第7 列,以及第2欄至第6欄所在的區域。 [0014] 該每個測試專案的參數攔位中包括存放通道名稱、測試 參數值和測試結果的欄位。該通道是指該測試專案測試 的PCI-E介面通道,該測試參數值和測試結果是指對該測 試專案進行測試所使用的測試參數對應的測試參數值及 100101573 表單編號A0101 第7頁/共17頁 1002002811-0 201232252 測試結果。 [0015] [0016] [0017] [0018] 如圖3所示’係在步驟S1G中所建立的-個測試報告範本 第一張工作表中一個參數攔位的示例圖。設PCI-E介面的 四個通道P〇rto、PorU、Port2、p〇rt3進行了測試專 案(1)的測試,該測試專案(1)所使用的測試參數為 測試參數⑴、測試參數⑴和測試參數(3),圖3 的第1列第3行至第6行為存放通道名稱的欄位,第2、第3 、第4列的第3行至第6行為存放測試參數值的欄位,第5 列第3行至第6行為存放測試結果的攔位。 步驟S02,在該測試報告範本的第二張工作表中,為pci — E介面的每個通道建立一個貼圖襴位,如圖4所示該貼 圖欄位中又包括兩個欄位,其中一個攔位用於填入對應 通道的轉換眼圖,另一個欄位用於填入對應通道的非轉 換眼圖。如圖4所示,轉換眼圖(1)和非轉換眼圖(1 ) 所在區域就是為通道p〇rt 1所建立的貼圖攔位。 步驟S03,從記憶體π中讀取测試結果檔案11(),並從該 測試結果檔案11 〇中獲取p C卜E介面各測試專案對應的通 道名稱、測試參數值及測試結果。 步驟S04,將上述獲取的各測試專案對應的通道名稱、測 試參數值及測試結果依次對應填入在步驟s 〇丨建立的測試 報告範本中的第一張工作表中各測試專案對應的參數攔 位0 步驟S05 ’從所述測試結果檔案110中依次獲取pci_E介 面每個通道對應的眼圖,並將獲取的眼圖依次填入上述 100101573 表單編號A0101 第8頁/共17頁 1002002811-0 [0019] 201232252 在第二張工作表中為每個通道所建立的貼圖欄位中。 [0020] [0021] ❹ [0022] [0023] Ο [0024] [0025] [0026] 此外,當每個通道對應的眼圖被填入到相應的貼圖欄位 中時,測試報告生成系統10還將每個通道對應的眼圖名 稱以及編號填入該眼圖的貼圖攔位中。同時,測試報告 生成系統10還將根據為眼圖所建立的貼圖欄位的大小, 通過調整該眼圖格式的寬度與高度,調整該眼圖的大小 ,使該眼圖能完全填入對應的貼圖欄位中。 步驟S06,調整第二張工作表的分頁線,使該第二張工作 表預覽時的每一頁都完整顯示若干個通道對應的眼圖, 如圖4所示,第二張工作表預覽時,每一頁都顯示兩個通 道對應的眼圖,包括兩個轉換眼圖和兩個非轉換眼圖。 步驟S07,將調整後的測試報告範本保存在記憶體11中, 生成PC Ι-E介面的測試報告。該第一張工作表和第二張工 作表即為所生成的測試報告。 綜上所述,本發明符合發明專利要件,爰依法提出專利 申請。惟,以上所述者僅爲本發明之較佳實施例,本發 明之範圍並不以上述實施例爲限,舉凡熟悉本案技藝之 人士援依本發明之精神所作之等效修飾或變化,皆應涵 蓋於以下申請專利範圍内。 【圖式簡單說明】 圖1係本發明測試報告生成系統的運行環境架構圖。 圖2係本發明測試報告生成方法較佳實施例的流程圖。 圖3係參數欄位的一個示例圖。 100101573 表單編號A0101 第9頁/共17頁 1002002811-0 201232252 [0027] 圖4係貼圖攔位的一個示例圖。 【主要元件符號說明】 [0028] 電腦 1 [0029] 測試報告生成系統1 0 [0030] 記憶體11 [0031] 測試結果檔案110 [0032] 建立一個Exce 1格式的測試報告範本,並在第一張工作表 中為PC I -E介面的每個測試專案建立一個參數櫊位SO 1 [0033] 在該測試報告範本的第二張工作表中,為PCI-E介面的每 個通道建立一個貼圖攔位S02 [0034] 讀取測試結果檔案,並從該測試結果檔案中獲取PCI-E介 面各測試專案對應通道名稱、測試參數值及測試結果 S03 [0035] 將上述獲取的各測試專案對應的通道名稱、測試參數值 及測試結果依次填入各測試專案對應的參數攔位中S 0 4 [0036] 從所述測試結果檔案中依次獲取PCI-E介面每個通道對應 的眼圖,並將獲取的眼圖依次填入上述為每個通道所建 立的貼圖欄位中S05 [0037] 調整第二張工作表的分頁線S06 [0038] 保存調整後的測試報告範本,生成PCI-E介面的測試報告 S07 100101573 表單編號A0101 第10頁/共17頁 1002002811-0The Q project creates a parameter field. The parameter is located in an area of a certain column of the first worksheet, for example, a parameter field corresponding to a test project of the PCI-E interface is the second column in the first worksheet to Column 7, and the area where columns 2 through 6 are located. [0014] The parameter block of each test project includes a field for storing a channel name, a test parameter value, and a test result. The channel refers to the PCI-E interface channel of the test project test. The test parameter value and the test result refer to the test parameter value corresponding to the test parameter used for testing the test project and 100101573 Form No. A0101 Page 7 / Total 17 pages 1002002811-0 201232252 Test results. [0018] [0018] As shown in FIG. 3, an example diagram of a parameter block in the first worksheet of the test report templates established in step S1G is shown. The four channels P〇rto, PorU, Port2, and p〇rt3 of the PCI-E interface were tested by the test project (1). The test parameters used in the test project (1) were test parameters (1), test parameters (1), and Test parameter (3), the third row to the sixth behavior of the first column of Figure 3 stores the field of the channel name, and the third row to the sixth row of the second, third, and fourth columns stores the field of the test parameter value. , column 5, line 3 to sixth, store the block of test results. Step S02, in the second worksheet of the test report template, a map field is established for each channel of the pci-E interface, and as shown in FIG. 4, the map field includes two fields, one of which The block is used to fill in the converted eye diagram of the corresponding channel, and the other field is used to fill in the non-converted eye diagram of the corresponding channel. As shown in Fig. 4, the area where the conversion eye diagram (1) and the non-conversion eye diagram (1) are located is the texture barrier created for the channel p〇rt 1. In step S03, the test result file 11() is read from the memory π, and the channel name, the test parameter value and the test result corresponding to the test items of the p C E interface are obtained from the test result file 11 。. Step S04, the channel name, the test parameter value and the test result corresponding to the test items obtained in the above are sequentially corresponding to the parameter blocks corresponding to the test items in the first work table in the test report template established in the step s 〇丨Bit 0, step S05' sequentially obtains the eye diagram corresponding to each channel of the pci_E interface from the test result file 110, and fills the acquired eye diagram into the above 100101573 form number A0101, page 8 / total 17 pages 1002002811-0 [ 0019] 201232252 In the map field created for each channel in the second worksheet. [0020] [0023] [0025] Further, when the eye pattern corresponding to each channel is filled into the corresponding map field, the test report generation system 10 The eye name and number corresponding to each channel are also filled in the texture map of the eye. At the same time, the test report generation system 10 also adjusts the size of the eye map according to the size of the map field created for the eye diagram, and adjusts the size of the eye map so that the eye map can be completely filled in corresponding In the map field. Step S06, adjusting the page line of the second worksheet so that each page of the second worksheet preview completely displays the eye diagram corresponding to the plurality of channels, as shown in FIG. 4, when the second worksheet is previewed. Each page displays an eye diagram corresponding to two channels, including two converted eye diagrams and two non-converted eye diagrams. In step S07, the adjusted test report template is saved in the memory 11, and a test report of the PC Ι-E interface is generated. The first worksheet and the second worksheet are the generated test reports. In summary, the present invention complies with the requirements of the invention patent and submits a patent application according to law. The above is only the preferred embodiment of the present invention, and the scope of the present invention is not limited to the above-described embodiments, and equivalent modifications or variations made by those skilled in the art in light of the spirit of the present invention are It should be covered by the following patent application. BRIEF DESCRIPTION OF THE DRAWINGS Fig. 1 is a diagram showing the architecture of the operating environment of the test report generation system of the present invention. 2 is a flow chart of a preferred embodiment of a test report generation method of the present invention. Figure 3 is an example diagram of a parameter field. 100101573 Form No. A0101 Page 9 of 17 1002002811-0 201232252 [0027] FIG. 4 is an exemplary diagram of a map stop. [Main component symbol description] [0028] Computer 1 [0029] Test report generation system 1 [0030] Memory 11 [0031] Test result file 110 [0032] Create an Exce 1 format test report template, and at first A parameter clamp SO 1 is created for each test project in the worksheet for the PC I -E interface. [0033] In the second worksheet of the test report template, a map is created for each channel of the PCI-E interface. Block S02 [0034] Read the test result file, and obtain the corresponding channel name, test parameter value and test result of the PCI-E interface test items from the test result file. S03 [0035] Corresponding to the test items obtained above The channel name, the test parameter value, and the test result are sequentially filled in the parameter block corresponding to each test project. S 0 4 [0036] The eye pattern corresponding to each channel of the PCI-E interface is sequentially obtained from the test result file, and The acquired eye diagram is sequentially filled in the above-mentioned map field established for each channel. S05 [0037] Adjusting the page line S06 of the second worksheet [0038] Save the adjusted test report template to generate the PCI-E interface. Test report S07 100101573 Form Number A0101 Page 10 / Total 17 1002002811-0