EMI data processing and report generating system and method

Abstract

The invention provides an EMI data processing and report generation system and method, and the method comprises the steps: extracting data features of a data file through a data feature extraction module, and judging whether a limit value condition is correct or not; the limit value condition correction module imports a correct limit value condition and corrects the data file; the data result summarizing module summarizes the data file information to obtain a test result; the effective data identification and screenshot generation module identifies an area where the effective data is located and generates a screenshot for the effective data; the test information input module inputs a report template and test information; a matching field generation module generates a matching field corresponding to the data file; the data screenshot and report template matching module is used for completing matching of the data screenshot and the report template; and the report generation and output module outputs an EMI summary report. According to the method, the report compiling efficiency is improved by automatically processing and summarizing the data, the problem of low data processing efficiency is solved, and the test result cannot be influenced by the change of the test process and test software.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and particularly to an EMI data processing and report generation system and method. Background Art

[0002] Currently, there are already technical solutions that can integrate EMI test equipment, collect and process test data in real time, detect and correct outliers in the data, and provide comprehensive test results and analysis reports. The key point of this solution is to achieve automated control and coordinated operation of multiple test equipment through a unified control platform, and collect, store, process, and analyze test data in real time to provide accurate and comprehensive test results and analysis reports.

[0003] Electromagnetic interference (EMI) testing is an important part of electromagnetic compatibility (EMC). After testing, a large number of data files formed by different frequency bands, different working modes, and different samples are often generated. Common EMI test software on the market cannot automatically summarize data, and the limit conditions cannot be reset after the test, which brings difficulties to the issuance of test reports. The processing of EMI data is often the reason for the long compilation time of EMC reports. If the method of using automated control test equipment, collecting and storing test data in real time, and forming an analysis report after processing and analysis is adopted, the original equipment needs to be modified, which will cause changes in the test process and test software, and it is necessary to re-obtain the recognition of test qualifications from various institutions, enterprises, and customers. Summary of the Invention

[0004] The technical problem to be solved by the present invention is: In order to overcome the following problems in the prior art: (1) Common EMI test software on the market cannot summarize test data; (2) The limit conditions of the test data may need to be changed, but it cannot be achieved under the current technology and can only be retested, resulting in an extension of the test time; (3) From test data to a summary report, the entire process relies on manual processing, with low efficiency and unable to meet the market's demand for quickly issuing reports. The present invention provides an EMI data processing and report generation system that does not participate in the entire process from the beginning of the test, but analyzes and summarizes the test results after the test is completed and test data is generated, so as to achieve the goal of improving the report compilation efficiency. This makes the transformation cost and time cost of the technical solution adopted by the present invention lower, does not require modification of the original test process, and does not affect the recognition of test qualifications by various institutions, enterprises, and customers.

[0005] The technical solution adopted by the present invention to solve its technical problems is: An EMI data processing and report generation system, including

[0006] The data feature extraction module is used to extract the data features of the input data file after the data file is input, and to judge whether the limit conditions are correctly set;

[0007] The limit condition correction module is used to import the correct limit conditions, reset the correct limit conditions, and correct the data file when the limit conditions are incorrect;

[0008] The data result summary module is used to summarize the information of the data file extracted after the limit conditions are correctly set, and to obtain the summarized test results;

[0009] The valid data identification and screenshot generation module is used to identify the area where the valid data is located in each data file, and to generate screenshots of the valid data. The screenshots generated here will be finally posted in the report;

[0010] The test information input module is used to input the EMI report template and input the test information into the EMI report template;

[0011] The matching field generation module is used to generate matching fields corresponding to the data file in the EMI report template after the test information is input;

[0012] The data screenshot and report template matching module is used to complete the matching of the data screenshot and the EMI report template according to the set fuzzy matching mode for the generated matching fields;

[0013] The report generation and output module is used to insert the matched data screenshots into the corresponding positions of the EMI report template, input the summarized test results into the EMI report template, and output the EMI summary report.

[0014] An EMI data processing and report generation method includes the following steps: Applied to the EMI data processing and report generation system as described in claim 1, it includes the following steps:

[0015] S-1: Input the data file into the data feature extraction module. Use the data feature extraction module to read the frequency column Frequency, limit column Limit, and the corresponding detector Detector in the data file table, and compare with the data image. If the limit conditions are set incorrectly after the comparison, or there is no error but need to be modified to other limit conditions, then enter step S-2 for limit re-import and correction; if there is no need to reset the limit conditions, directly enter step S-3;

[0016] At the same time, use the test information input module to input the EMI report template and input the initial test information into the EMI report template;

[0017] S-2: Set the limit conditions that meet the requirements as needed, input the limit information, and select the data file that needs to be corrected. The limit condition correction module will correct the data file. During the correction process, the limit condition correction module redraws the limit curve and corrects the limit Limit and the difference Delta of the test sampling points, where Limit is corrected to the input limit, and Delta = Level – Limit;

[0018] S-3: The data file has sampled the frequency points that exceed the limit conditions or are closest to the limit conditions and listed them in a table. The data result summary module will sequentially read the data file, identify the unqualified data in the data file, record the entire frequency band of the test and the sampling points that exceed the limit conditions, and form a summarized data result;

[0019] S-4: In order to generate a summary report, after the unqualified data is identified, the valid data identification and screenshot generation module identifies the valid data in the data file, takes a screenshot of the valid data content, generates a valid data screenshot, and inserts the valid data screenshot into the EMI report template at S-7;

[0020] S-5: According to the report content and the naming rules of the data file, after inputting the test information into the EMI report template in step S-1, matching fields are generated at each position where data screenshots need to be pasted according to a certain logic, and the matching fields need to be as consistent as possible with the naming of the data file;

[0021] S-6: After generating matching fields at each position where data screenshots need to be pasted in the EMI report template in S-5, the data screenshot and report template matching module completes the matching with the valid data screenshots generated in step S-4 one by one according to the preset fuzzy matching mode. The specific matching logic can be designed according to the actual situation;

[0022] S-7: The report generation and output module inserts the valid data screenshots that match successfully in step S-6 into the corresponding positions of the report template, and adjusts the size of the pasted image proportionally according to the positions reserved in the template and the size of the data screenshots;

[0023] S-8: After all the data screenshots have been inserted into the EMI report template, the report generation and output module fills in the summarized data result obtained in step S-3 on the result page of the report;

[0024] S-9: After all the above 8 steps are implemented, the report generation and output module converts the edited EMI report into a PDF format file and outputs it.

[0025] Specifically, the data file is the output data of the EMI test equipment.

[0026] Specifically, the data file is a PDF format file.

[0027] Further, for the commonly used limit conditions in step S-2, they are saved as a configuration file, and the configuration file is directly imported when needed next time.

[0028] Further, the specific process of identifying valid data in step S-4 is as follows:

[0029] First, convert the entire data file into a picture, and then define a total of 4 boundary lines, namely the upper, lower, left, and right boundary lines. The positions of the boundary lines are preset according to the positions of the valid data; in order to adapt to the different positions of the valid data under different test conditions, when identifying the valid data, it is necessary to identify that each boundary line is blank and has no content. If no blank and contentless area is identified on the boundary line, it will be extended outward until the valid data is determined after the 4 boundary lines are identified; then, take a screenshot of the valid data area defined by the boundary lines.

[0030] Further, for the positions in the EMI report template where no data is inserted due to matching failure in step S-7, they should be summarized and prompted to the report compiler, and handed over to the compiler for further processing.

[0031] The beneficial effects of the present invention are:

[0032] (1) Rapidly identify the unqualified data points in the EMI data and summarize the results.

[0033] (2) For the data errors caused by incorrect setting of the limit conditions in the test, the correct standard limit conditions can be imported and the data can be automatically corrected.

[0034] (3) Automatically match the data file name with the data template to quickly generate an EMI test report. (Adopt the fuzzy matching mode to improve the matching success rate: for some conditions that may not exist in the test or have an unfixed position in the test data, perform fuzzy matching, and the matching success rate can be increased from about 75% in the exact matching mode to about 98%).

[0035] (4) Using this system to process the EMI data and generate a report, compared with the pure manual processing and report compilation, the report efficiency can reach 10 - 20 times the original.

[0036] (5) The present invention starts from the data file output by the EMI test software, and improves the report compilation efficiency through the automated processing and summarization of the data. This can not only solve the problem of low EMI data processing efficiency, but also will not affect the recognition of the test qualifications by various institutions, enterprises, and customers due to changes in the test process and test software. Description of the Drawings

[0037] The present invention will be further described below in conjunction with the drawings and embodiments.

[0038] Figure 1 It is a schematic structural diagram of the EMI data processing and report generation system of the present invention.

[0039] Figure 2 It is a schematic flowchart of the EMI data processing and report generation method of the present invention.

[0040] Figure 3 It is a schematic diagram of the software interface of the test data import system. Specific embodiments

[0041] The present invention will now be described in detail in conjunction with the drawings. This figure is a simplified schematic diagram, which only illustrates the basic structure of the present invention in a schematic manner, so it only shows the components related to the present invention.

[0042] As Figure 1 shown, an EMI data processing and report generation system of the present invention includes eight modules, namely: a data feature extraction module, a limit condition correction module, a data result summary module, a valid data identification and screenshot generation module, a test information input module, a matching field generation module, a data screenshot and report template matching module, and a report generation and output module. By inputting a data file, a report template, and test information, an EMI summary report is generated and output.

[0043] Among them, the data feature extraction module is used to extract the data features of the input data file and judge whether the limit conditions are correctly set after the data file is input;

[0044] The limit condition correction module is used to import the correct limit conditions, reset the correct limit conditions, and correct the data file when the limit conditions are incorrect;

[0045] The data result summary module is used to summarize the information of the extracted data file and obtain the summarized test results after the limit conditions are correctly set;

[0046] The valid data identification and screenshot generation module is used to identify the area where the valid data is located in each data file and generate a screenshot of the valid data. The screenshot generated here will be finally pasted into the report;

[0047] The test information input module is used to input the EMI report template and input test information into the EMI report template;

[0048] The matching field generation module is used to generate matching fields corresponding to the data file in the report template after the test information is input;

[0049] A data screenshot and report template matching module, which is used to complete the matching of data screenshots and report templates according to the set fuzzy matching mode for the generated matching fields;

[0050] A report generation and output module, which is used to insert the matched data screenshots into the corresponding positions of the report template, input the summarized test results into the report template, and output the EMI summary report.

[0051] Such as Figure 2 As shown, a method for EMI data processing and report generation according to the present invention is applied to the above EMI data processing and report generation system, and includes the following steps:

[0052] After the data file is input, in step S-1, the data feature extraction module will extract data features and judge whether the limit conditions are correctly set. If the correct limit needs to be reset, in step S-2, the limit condition correction module will import the correct limit conditions and correct the data file. After the limit conditions are correctly set, in step S-3, the data result summary module will summarize the information of the extracted data file and obtain the summarized test results. In step S-4, the valid data identification and screenshot generation module will identify the area where the valid data is located in each data file and generate screenshots of the valid data. The screenshots generated here will finally be posted in the report. In step S-5, the matching field generation module will generate matching fields corresponding to the data file in the report template after inputting the test information. In step S-6, the data screenshot and report template matching module will complete the matching of the data screenshot and the report template according to the set fuzzy matching mode for the matching fields generated in S-5. Next, in step S-7 of report generation and output, the matched data screenshots will be inserted into the corresponding positions of the report template, in step S-8, the summarized test results obtained in S-3 will be input into the report template, and in step S-9, the EMI summary report will be output.

[0053] After inputting the EMI data file and the report template, through the Figure 2 process shown, a method for processing data and generating an EMI summary report will be described in detail for each of the above steps:

[0054] S-1: Input the data file into the data feature extraction module. Use the data feature extraction module to read the frequency column "Frequency", limit column "Limit" and the corresponding detector in the data file table, and compare them with the data image. If the limit condition setting is incorrect after comparison, or there is no error but it needs to be modified to other limit conditions, then go to step S-2 for limit re-import and correction; if there is no need to reset the limit conditions, directly go to step S-3; at the same time, use the test information input module to input the EMI report template and input the initial test information into the EMI report template.

[0055] In this embodiment, the input data file is the output data of the EMI test equipment, and the format is a large number of PDF data files. The data file can be the existing output data of the EMI test equipment, or the output data of the EMI test equipment can be read in real time during the test, and then processed and a test report can be generated. However, for the real-time acquisition solution, since the test and report generation are carried out simultaneously, in fact, the overall test efficiency is relatively low, not flexible enough, and the control of the test equipment may affect the recognition of the test qualification.

[0056] S-2: According to the required and compliant limit conditions, input the limit information and select the data file that needs to be corrected. The limit condition correction module will correct the data file; during the correction process, the limit condition correction module redraws the limit curve and corrects the limit "Limit" and difference "Delta" of the test sampling points, where "Limit" is corrected to the input limit, and "Delta = Level - Limit"; for common limit conditions, they can be saved as a configuration file and can be directly imported next time when needed.

[0057] S-3: The data file has sampled the frequency points that exceed the limit conditions or are closest to the limit conditions and listed them in a table. The data result summary module will sequentially read the data file, identify the unqualified data in the data file, record the full frequency range of the test and the sampling points that exceed the limit conditions, and form a summary data result;

[0058] S-4: To generate a summary report, after the identification of non-conforming data is completed, the valid data identification and screenshot generation module is used to identify the valid data in the data file, take screenshots of the valid data content, generate valid data screenshots, and insert the valid data screenshots into the EMI report template at [S-7]. When identifying valid data, the entire data file is first converted into a picture, and then a total of 4 boundary lines, namely the upper, lower, left, and right boundary lines, are defined. The positions of the boundary lines are preset according to the positions of the valid data. To adapt to the different positions of valid data under different test conditions, when identifying valid data, it is necessary to identify that each boundary line is blank and has no content. If no blank and no-content is identified on the boundary line, it will be extended outward until the valid data is determined after the 4 boundary lines are identified. Next, just take a screenshot of the valid data area defined by the boundary lines.

[0059] S-5: According to the naming rules of the report content and the data file, after inputting the test information into the EMI report template in step S-1, matching fields are generated at each position where data screenshots need to be pasted according to a certain logic. The matching fields need to be as consistent as possible with the naming of the data file. For example, the sample numbers of a test are 001 and 002, and the working mode is Mode1. As shown in Figure 3 the test data is obtained by testing sample 001 in the range of 30M - 173.98MHz with a bicone antenna in the vertical polarization direction for the X direction of the sample. The data file name is "Bicone 001Mode1 30M - 173.98M Ver X", and the matching field generation module will generate "*Bicone**X*001Mode1 30M - 173.98M Ver" at the corresponding position in the EMI report template, where the fields between the two "*" represent the fuzzy matching mode.

[0060] S-6: After generating matching fields at each position in the EMI report template where data screenshots need to be pasted in S-5, the data screenshot and report template matching module completes the matching with the valid data screenshots generated in step S-4 one by one according to the preset fuzzy matching mode. The specific matching logic can be designed according to the actual situation. For example, for the matching field "*Double Cone**X*001Mode130M-173.98M Ver", the fuzzy fields "Double Cone" and "X" can be extracted first. The remaining part "001Mode130M-173.98M Ver" is entirely included in the data file name "Double Cone001Mode1 30M-173.98M Ver X", and the fuzzy fields "Double Cone" and "X" are respectively included in it, so the matching can be successful. The advantage of this fuzzy matching is that the fuzzy fields like "Double Cone" and "X" do not have fixed positions, the naming of data files can be relatively free, and it can also take into account the matching accuracy rate, matching efficiency, and matching success rate. If the actual situation is different from this example, the matching logic should be redesigned.

[0061] S-7: The report generation and output module inserts the valid data screenshots successfully matched in step S-6 into the corresponding positions of the report template, and proportionally adjusts the size of the pasted pictures according to the positions reserved in the template and the size of the data screenshots; for the positions in the template where no data is inserted due to matching failure, they should be summarized and prompted to the report compiler for further processing by the compiler.

[0062] S-8: After all the data screenshots have been inserted into the EMI report template, the report generation and output module fills in the summarized data results obtained in step S-3 on the result page of the report;

[0063] S-9: After all the above 8 steps are implemented, the report generation and output module converts the edited EMI report into a PDF format file and outputs it.

[0064] Enlightened by the ideal embodiments of the present invention as described above, through the above description, relevant staff can completely make various changes and modifications without departing from the scope of the present invention. The technical scope of this invention is not limited to the content in the specification, and its technical scope must be determined according to the scope of the claims.

Claims

1. An EMI data processing and report generation system, characterized in that: including a data feature extraction module, which is used to extract the data features of the input data file after the data file is input, and judge whether the limit conditions are correctly set; a limit condition correction module, which is used to import the correct limit conditions, reset the correct limit conditions, and correct the data file when the limit conditions are incorrect; a data result summary module, which is used to summarize the information of the extracted data file and obtain the summarized test results after the limit conditions are correctly set; a valid data identification and screenshot generation module, which is used to identify the area where the valid data is located in each data file and generate a screenshot of the valid data; a test information input module, which is used to input the EMI report template and input test information into the EMI report template; a matching field generation module, which is used to generate matching fields corresponding to the data file in the EMI report template after the test information is input; a data screenshot and report template matching module, which is used to complete the matching of the data screenshot and the EMI report template according to the set fuzzy matching mode for the generated matching fields; a report generation and output module, which is used to insert the matched data screenshot into the corresponding position of the EMI report template, input the summarized test results into the EMI report template, and output the EMI summary report.

2. The EMI data processing and report generation method according to claim 1, characterized in that: Applied to the EMI data processing and report generation system as described in claim 1, including the following steps: S-1: Input the data file into the data feature extraction module, use the data feature extraction module to read the frequency column Frequency, limit column Limit and the corresponding detector Detector in the data file table, and compare with the data image. If the limit conditions are set incorrectly after the comparison, or there is no error but need to be modified to other limit conditions, then enter step S-2 for limit re-import and correction; if there is no need to reset the limit conditions, directly enter step S-3; At the same time, use the test information input module to input the EMI report template and input the initial test information into the EMI report template; S-2: According to the required and compliant limit conditions, input the limit information and select the data file to be corrected. The limit condition correction module will correct the data file; during the correction process, the limit condition correction module redraws the limit curve and corrects the limit Limit and difference Delta of the test sampling point, where Limit is corrected to the input limit, and Delta = Level–Limit; S-3: The data file has sampled the frequency points that exceed the limit conditions or are closest to the limit conditions and listed them in the table. The data result summary module will sequentially read the data files, identify the unqualified data in the data files, record the full frequency range of the test and the sampling points that exceed the limit conditions, and form a summarized data result; S-4: After the identification of unqualified data is completed, use the valid data identification and screenshot generation module to identify the valid data in the data file and take a screenshot of the valid data content to generate a valid data screenshot; S-5: According to the content of the report and the naming rules of the data file, after inputting the test information into the EMI report template in step S-1, matching fields are generated at each position where data screenshots need to be pasted according to a certain logic, and the matching fields need to be consistent with the naming of the data file; S-6: The data screenshot and report template matching module completes the matching with the valid data screenshots generated in step S-4 one by one according to the preset fuzzy matching mode according to the matching fields generated in step S-5; S-7: The report generation and output module inserts the valid data screenshots successfully matched in step S-6 into the corresponding positions of the report template, and proportionally adjusts the size of the pasted pictures according to the positions reserved in the template and the size of the data screenshots; S-8: After all the data screenshots have been inserted into the EMI report template, the report generation and output module fills in the summarized data results obtained in step S-3 on the result page of the report; S-9: After all the above 8 steps are implemented, the report generation and output module converts the edited EMI report into a PDF format file and outputs it.

3. The EMI data processing and report generation method according to claim 2, wherein: The data file is the output data of the EMI test equipment.

4. The EMI data processing and report generation system according to claim 2, characterized in that: The data file is a PDF format file.

5. The EMI data processing and report generation system according to claim 2, characterized in that: In step S-2, for the common limit conditions, they are saved as a configuration file, and the configuration file is directly imported when needed next time.

6. The EMI data processing and report generation system according to claim 2, wherein: The specific process of identifying valid data in step S-4 is as follows: First, convert the entire data file into a picture, and then define a total of 4 boundary lines, namely the upper, lower, left, and right boundary lines. The positions of the boundary lines are preset according to the positions of the valid data. In order to adapt to the different positions of the valid data under different test conditions, it is necessary to identify that each boundary line is blank and has no content when identifying the valid data. If no blank and no-content is identified on the boundary line, it is expanded outward until the valid data is determined after the 4 boundary lines are identified. Then, take a screenshot of the valid data area defined by the boundary lines.

7. The EMI data processing and report generation system according to claim 2, wherein: In step S-7, for the positions in the EMI report template where no data is inserted due to matching failure, they should be summarized and prompted to the report compiler for further processing by the compiler.

Images