Method for automatically generating vTESTstudio test sequence based on Excel table

Abstract

The invention relates to the technical field of automobile electronic test automation, in particular to a method for automatically generating a vTESTstudio test sequence based on an Excel table, and the method comprises the following steps: analyzing a test demand; designing an Excel test case template and a test case; parameterized configuration is carried out; automatically generating a test sequence; importing and compiling a test sequence; and executing a test and generating a report. According to the method for automatically generating the vTESTstudio test sequence based on the Excel table, the manual workload is reduced, the test accuracy is improved, the expandability is enhanced, efficient reporting and regression are achieved, test asset reuse is supported, and modularization and reusability of test components are promoted through template and parameterization design.

Description

Technical Field

[0001] The present invention relates to the technical field of automotive electronic test automation, and in particular to a method for automatically generating a vTESTstudio test sequence based on an Excel table. Background Art

[0002] With the rapid development of automotive electronic systems and their increasing functionality and performance complexity, the workload for electronic control unit (ECU) testing has grown exponentially to ensure the functional integrity and reliability of ECUs. Traditional automated testing methods rely primarily on test engineers manually converting Excel spreadsheet test cases into automated test sequences. This approach has the following drawbacks: high workload, low efficiency, prone to errors, difficulty ensuring consistency, poor repeatability, and difficulty adapting to frequent changes in requirements and use cases.

[0003] vTESTstudio, developed by Vector, is an automated testing software for automotive bus system testing. It features automated sequence design and creation. However, vTESTstudio currently has limitations. Manual test sequence creation, configuration, and data entry are still the primary methods of use, resulting in time-consuming, error-prone, and repetitive tasks. Therefore, there is an urgent need to develop an Excel-based method for automatically generating vTESTstudio test sequences to overcome these shortcomings. Summary of the Invention

[0004] The purpose of the present invention is to provide a method for automatically generating a vTESTstudio test sequence based on an Excel spreadsheet to solve the problems raised in the above background technology.

[0005] To achieve the above object, the present invention provides the following technical solutions: A method for automatically generating a vTESTstudio test sequence based on an Excel spreadsheet, comprising the following steps: Test requirements analysis: Determine the functional specifications and communication protocols of the test object, identify key test parameters and test scenarios, and define test conditions and expected results; Excel test case template and test case design: Create a test case template in an Excel spreadsheet. The template includes initialization steps, test execution steps, result verification steps, reset steps, and a custom action library module. Design test cases based on the requirements analysis and template. Parameterized configuration: Declare variables in the test case as parameters in vTESTstudio or CANoe, set the parameter data type, default value and value range, and map the parameters to the model or board interface path; Automatic generation of test sequences: The parsing program reads the test case operation steps, corresponding parameters and custom action library in the Excel spreadsheet to generate a test sequence .vtt file; Test sequence import and compilation: import the generated .vtt file into the vTESTstudio project, perform grouping, sorting and version management, and compile it into an executable .vtuexe file; Test execution and report generation: Execute test sequences in the CANoe environment, collect logs and test results in real time, and automatically generate test reports.

[0006] As a further solution of the present invention: in the test requirement analysis, the test conditions include input parameters, output parameters and expected results.

[0007] As a further solution of the present invention: in the Excel test case template, the initialization step includes system configuration, the test execution step includes parameter setting and action triggering, and the result verification step includes output comparison.

[0008] As a further solution of the present invention: in the parameterized configuration, the variables include device status and communication instructions, and the data types include integers and floating-point numbers.

[0009] As a further solution of the present invention: in the automatic generation of the test sequence, the parsing program is a Python script, which reads the test case data according to the hierarchy and logical order of the Excel table and generates a .vtt file.

[0010] As a further solution of the present invention: the Python script constructs a nested data structure by parsing the first-level title, second-level title and use case number in the Excel table, and fills the test steps, setting parameters and expected results into the test sequence.

[0011] As a further solution of the present invention: during the import and compilation of the test sequence, the grouping and sorting are performed according to the test scenario or function, and the version management includes version control and history tracking of the test sequence.

[0012] As a further solution of the present invention: during the test execution and report generation, the test report includes statistics on test coverage, pass rate and failed cases.

[0013] As a further solution of the present invention: the custom action library module includes predefined test actions and indexes, and the action library is called through the index when the test sequence is generated.

[0014] As a further solution of the present invention: the method further includes verifying the correctness of the test sequence through vTESTstudio after the test sequence is generated, and compiling it into a .vtuexe file after the verification is passed.

[0015] Compared with the prior art, the present invention has the following beneficial effects: 1. Reduce manual workload: Significantly improve test efficiency, automatically generate large-scale test sequences, avoid manual editing and maintenance of test sequences one by one, and save a lot of time and labor costs; 2. Improve test accuracy: Automatically generated test sequences reduce manual editing errors, lower the risk of errors, and improve test accuracy and consistency; 3. Enhanced scalability: Through unified template and parameterized management, custom library configuration and script generation mechanism, it can flexibly respond to various new functions and changing test requirements, and improve the maintainability and scalability of test sequences; 4. Efficient reporting and regression: Quickly import, uniformly manage and execute test sequences, and test sequences can be executed repeatedly. Automatically generate reports and immediately support regression testing, quickly locate and verify problems; 5. Support test asset reuse and promote modularity and reusability of test components through templates and parameterized design. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] Figure 1 This is a flowchart of a method for automatically generating a vTESTstudio test sequence based on an Excel spreadsheet in an embodiment of the present invention.

[0017] Figure 2 This is a schematic diagram of the Excel spreadsheet test case template structure in an embodiment of the present invention.

[0018] Figure 3 This is a schematic diagram of the test sequence automatically generated in an embodiment of the present invention after being imported into vTESTstudio.

[0019] Figure 4 This is a schematic diagram of the structure of a custom action library for Excel spreadsheet test cases in an embodiment of the present invention.

[0020] Figure 5 This is a schematic diagram of the custom action library after it is imported into vTESTstudio in an embodiment of the present invention.

[0021] Figure 6 This is a schematic diagram of an example of an Excel spreadsheet test case in an embodiment of the present invention.

[0022] Figure 7 This is an example schematic diagram of the test sequence generated in an embodiment of the present invention after being imported into vTESTstudio. DETAILED DESCRIPTION

[0023] The following will provide a clear and complete description of the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of them. All other embodiments obtained by ordinary technicians in this field based on the embodiments of the present invention without making any creative efforts shall fall within the scope of protection of the present invention.

[0024] The specific implementation of the present invention is described in detail below with reference to specific embodiments.

[0025] See also Figure 1-Figure 7 , the embodiment of the present invention provides a method for automatically generating a vTESTstudio test sequence based on an Excel spreadsheet, such as Figure 1 The flowchart shown includes the following steps: 1. Test requirements analysis: Determine the functional specifications and communication protocols of the test object; Identify key test parameters and test scenarios; Define test conditions and expected results.

[0026] 2. Excel test case template and test case design: Create a test case template in Excel. The template includes five basic modules: initialization step, test execution step and result verification step, reset step and custom action library. Excel spreadsheet test case design, based on demand analysis and test case template, establish Excel spreadsheet test case through test case design method. Figure 2 and Figure 4 shown.

[0027] 3. Parameterized configuration: In vTESTstudio or CANoe, declare variables in the relevant test case (such as speed (0 km / h to 240 km / h), temperature (-40° to 60°), vehicle status, communication commands, etc.) as parameters. Set the relevant parameter data type, default value, and allowed value range, and map the relevant parameters to the model or board interface path. Subsequently, keep the variable names used in the test sequence automatically generated by the test case consistent with the declared parameter names. This allows you to directly operate on the variables in the test sequence during test execution.

[0028] 4. Automatic generation of test sequences: Develop a program module for parsing Excel spreadsheet test cases, and read the test case operation steps, corresponding operation step parameters, related custom action libraries, and action library indexes according to the original Excel spreadsheet hierarchy and logical order; Fill the read test data (including test operation steps and corresponding parameters, test custom action library and its index) into the vTESTstudio test sequence to form a complete automatic test sequence .vtt file for use by vTESTstudio.

[0029] 5. Test sequence import and compilation: Import the generated test sequence .vtt file into the vTESTstudio project; Figure 3 and Figure 5 shown.

[0030] Regroup, sort and version the test sequences according to the test scenarios or functions to form a complete test sequence. After verifying the correctness of the test sequence in the vTESTstudio environment, compile it into a .vtuexe file that can be automatically executed by CANoe.

[0031] 6. Test execution and report generation: Execute automatically generated test sequences in the CANoe environment and collect logs and test results in real time; Automatically generate test reports, including test coverage, pass rate, and failure case statistics, for subsequent regression and problem diagnosis.

[0032] Therefore, by designing test cases in Excel spreadsheets according to pre-set Excel templates, we automatically generate batches of test sequence .vtt files and import them into vTESTstudio to form the test sequence Test Table, ultimately achieving automated test execution and report generation. Automatic import and unified management of test cases makes test sequence creation, maintenance, and execution more efficient and accurate, significantly reducing the risks and costs of manual operations, improving case consistency and scalability, and meeting large-scale testing needs.

[0033] Example: Step 1, test requirements analysis: Decompose the requirements of a certain ECU function, list typical functional scenarios and abnormal scenarios, and define the input parameters (such as gear position, switch signal, etc.), output parameters (such as engine speed, etc.) and test conditions (such as the system is powered on, etc.) that need to be tested in the test case.

[0034] 2. Test case template creation: Create a test case template in Excel and define the basic structure and steps of the test case. For example, the template includes initialization steps, input parameter setting steps, test execution steps, result verification steps, and a custom action library.

[0035] Based on the demand analysis and test case template, an Excel spreadsheet test case is created through the test case design method to verify whether the engine speed meets the functional specifications. Figure 6 shown.

[0036] 3. Parameterized configuration: In vTESTstudio or CANoe, declare relevant test case variables (such as wiper switch, wiper status, power status, etc.) as parameters, set the relevant parameter type (such as integer, floating point, etc.), default value and allowed value range.

[0037] 4. Automatically generate test sequences: Write a Python script to read the test case operation steps and corresponding step parameters according to the hierarchy and logical order in the Excel spreadsheet test case, read the relevant test custom action library and action library index, and automatically generate a specific test sequence .vtt file.

[0038] 5. Test sequence import and compilation: Import the automatically generated test sequence .vtt file into the vTESTstudio project and compile it into a .vtuexe file that can be automatically executed by CANoe. Figure 7 shown.

[0039] 6. Test result analysis: Execute test cases in CANoe, monitor the test process in real time, record test results, and perform data analysis and report generation. Analyze test results to determine whether they meet design requirements and relevant specifications. Provide timely feedback to the development team for corrections if any anomalies or discrepancies are found.

[0040] Through the above embodiment, the test sequence .vtt file can be automatically generated, which improves the test efficiency and accuracy, has important application value and promotion prospects. In addition, those skilled in the art can deduce other application scenarios based on this embodiment, such as vehicle body electronic testing.

[0041] It should be noted that, in the present invention, it should be understood that although this specification is described in terms of implementation methods, not every implementation method contains only one independent technical solution. This narrative method of the specification is only for the sake of clarity. Those skilled in the art should regard the specification as a whole. The technical solutions in each embodiment can also be appropriately combined to form other implementation methods that can be understood by those skilled in the art.

Claims

1. A method for automatically generating a vTESTstudio test sequence based on an Excel spreadsheet, characterized in that: The following steps are involved: Test requirements analysis: Determine the functional specifications and communication protocols of the test object, identify key test parameters and test scenarios, and define test conditions and expected results; Excel test case template and test case design: Create a test case template in an Excel spreadsheet. The template includes initialization steps, test execution steps, result verification steps, reset steps, and a custom action library module. Design test cases based on the requirements analysis and template. Parameterized configuration: Declare variables in the test case as parameters in vTESTstudio or CANoe, set the parameter data type, default value and value range, and map the parameters to the model or board interface path; Automatic generation of test sequences: The parsing program reads the test case operation steps, corresponding parameters and custom action library in the Excel spreadsheet to generate a test sequence .vtt file; Test sequence import and compilation: import the generated .vtt file into the vTESTstudio project, perform grouping, sorting and version management, and compile it into an executable .vtuexe file; Test execution and report generation: Execute test sequences in the CANoe environment, collect logs and test results in real time, and automatically generate test reports.

2. The method for automatically generating a vTESTstudio test sequence based on an Excel table according to claim 1, wherein: In the test requirement analysis, the test conditions include input parameters, output parameters and expected results.

3. The method for automatically generating a vTESTstudio test sequence based on an Excel table according to claim 1, wherein: In the Excel test case template, the initialization step includes system configuration, the test execution step includes parameter setting and action triggering, and the result verification step includes output comparison.

4. The method for automatically generating a vTESTstudio test sequence based on an Excel table according to claim 1, wherein: In the parameterized configuration, the variables include device status and communication instructions, and the data types include integers and floating-point numbers.

5. The method for automatically generating a vTESTstudio test sequence based on an Excel table according to claim 1, wherein: In the automatic generation of the test sequence, the parsing program is a Python script, which reads the test case data according to the hierarchy and logical order of the Excel table and generates a .vtt file.

6. The method for automatically generating a vTESTstudio test sequence based on an Excel table according to claim 5, characterized in that: The Python script constructs a nested data structure by parsing the first-level headings, second-level headings, and use case numbers in the Excel spreadsheet, and fills the test steps, setting parameters, and expected results into the test sequence.

7. The method for automatically generating a vTESTstudio test sequence based on an Excel table according to claim 1, wherein: During the import and compilation of the test sequence, the grouping and sorting are performed based on the test scenario or function, and the version management includes version control and history tracking of the test sequence.

8. The method for automatically generating a vTESTstudio test sequence based on an Excel table according to claim 1, wherein: During the test execution and report generation, the test report includes test coverage, pass rate and failure case statistics.

9. The method for automatically generating a vTESTstudio test sequence based on an Excel table according to claim 1, wherein: The custom action library module includes predefined test actions and indexes, and the action library is called through the index when a test sequence is generated.

10. The method for automatically generating a vTESTstudio test sequence based on an Excel table according to claim 1, wherein: The method further includes verifying the correctness of the test sequence through vTESTstudio after the test sequence is generated, and compiling it into a .vtuexe file after the verification is passed.

Images