Method and system for realizing automatic data collection and calculation based on printing function

Abstract

The present invention provides a method and system for realizing automatic data collection and calculation based on a printing function, comprising: step M1: realizing automatic capture and binding of a test report through a printing function; step M2: analyzing and reading the test data in the test report through image recognition technology; step M3: realizing automatic filling, calculation and rounding of the test data through the configuration of a record template; the record template is a templated configuration of a test record in a laboratory information management system. The present invention realizes the automatic collection and calculation of laboratory test data.

Description

Technical Field

[0001] The present invention relates to the field of laboratory testing, and in particular, to a method and system for realizing automatic data collection and calculation based on a printing function, and more particularly, to a method and system for realizing automatic data collection and calculation based on a printing function and image recognition technology. The present invention can be widely used in data collection and calculation of various laboratory testing instruments in the steel industry, the pharmaceutical industry, and the chemical industry. Background Art

[0002] In the future society, industry informatization is an inevitable trend. Establishing an industry information system in the fiercely competitive economic market can effectively increase the competitiveness of enterprises. The informatization construction of the pharmaceutical industry is also very necessary in modern society. Building an information system in a pharmaceutical enterprise is not only to establish an information system, but also to change the internal management mode of the pharmaceutical enterprise and the personnel structure of the entire enterprise, to change the system of the pharmaceutical enterprise, to make the pharmaceutical enterprise closer to the goal of modernization, to adapt to the modern economic market, and to enhance its own competitiveness.

[0003] Laboratory Information Management System, or LIMS, is the abbreviation of Laboratory Information Management System. It refers to connecting the laboratory's analytical instruments through a computer network, establishing a laboratory-centered distributed management system, and establishing a complete quality assurance system based on scientific laboratory management theory and computer database technology. It can achieve networked sharing of test data, paperless records and office, resource and cost management, and quantitative assessment of personnel, providing advanced technical support for the overall improvement of laboratory management level and comprehensive management of laboratories.

[0004] The laboratory inspection process involves a wide variety of inspection instruments and equipment. The inspection data generated by the inspection instruments and equipment is an important basis for judging the inspection results. The unified management of the interfaces of various instruments and equipment and the ability to obtain inspection data more accurately and conveniently are the keys to the success of the LIMS system. However, since the construction of informatization often lags behind the purchase and use of inspection instruments and equipment, it is difficult to debug and modify the interface with the instrument and equipment manufacturers. Even if the interface can be docked, the requirements for manpower, financial resources and material resources are relatively high. Therefore, how to invent a technical demand that does not change the existing instruments and equipment while accurately collecting the instrument's inspection structure data is imminent.

[0005] Patent document CN110729027A (application number: 201910963780.2) discloses a residence time distribution measurement experimental data acquisition and processing system, the data acquisition module collects and saves the experimental data; the data processing module imports the collected and saved experimental data and draws it into a curve graph. The data acquisition module of the present invention can collect the data of relevant chemical experiments in real time, stably and accurately, and display the experimental data in the form of a curve graph on the user interface of the software, so that the personnel conducting the experiment can understand the status of the experiment in time; after the relevant chemical experiment is completed, the data acquisition module will save the experimental data in an Excel workbook; the experimental data processing module can import the experimental data saved by the experimental data acquisition software and draw it into a curve graph, and then according to the requirements of the relevant chemical experiments, the experimental data is processed and calculated according to different processing schemes and the results are displayed to the user. Summary of the invention

[0006] In view of the defects in the prior art, the object of the present invention is to provide a method and system for realizing automatic data collection and calculation based on a printing function.

[0007] A method for realizing automatic data collection and calculation based on a printing function provided by the present invention includes:

[0008] Step M1: Automatically capture and bind the inspection report through the printing function;

[0009] Step M2: Analyze and read the inspection data in the inspection report through image recognition technology;

[0010] Step M3: Automatic filling, calculation and rounding of inspection data are realized through configuration of record templates;

[0011] The record template is a templated configuration of the test record in the laboratory information management system.

[0012] Preferably, the step M1 comprises:

[0013] Step M1.1: Obtain the inspection report file through the print function, and save the original inspection report attachment while obtaining the inspection report;

[0014] Step M1.2: Bind the inspection report attachment to the inspection item, and use the inspection report as the corresponding attachment of the inspection item for corresponding reference on the ELN information entry page.

[0015] Preferably, the step M3 comprises:

[0016] Step M3.1: After capturing the inspection result data in the inspection report, automatically fill it into the corresponding inspection record through the configuration function of the record template;

[0017] Step M3.2: After the data is filled in, the formula calculation is automatically triggered, and the laboratory information management system automatically calculates the test results, and at the same time rounds and converts the test results according to the preset requirements.

[0018] Preferably, the configuration of the record template in step M3 includes the control configuration, calculation formula configuration and rounding method configuration of the record template.

[0019] Preferably, the calculation formula configuration and rounding method configuration include setting various formulas and rounding off the test results according to the actual test record situation;

[0020] The calculation formula includes an F value calculation formula, a K value calculation formula and an RSD calculation formula;

[0021] The rounding methods include: rounding up, rounding off, rounding up and rounding down, as well as scientific notation and percentage conversion.

[0022] According to the present invention, a system for realizing automatic data collection and calculation based on a printing function includes:

[0023] Module M1: Automatically capture and bind inspection reports through the printing function;

[0024] Module M2: Analyze and read the inspection data in the inspection report through image recognition technology;

[0025] Module M3: Automatic filling, calculation and rounding of inspection data through configuration of record templates;

[0026] The record template is a templated configuration of the test record in the laboratory information management system.

[0027] Preferably, the module M1 comprises:

[0028] Module M1.1: Obtain the inspection report file through the printing function, and save the original inspection report attachments while obtaining the inspection report;

[0029] Module M1.2: Bind the inspection report attachment to the inspection item, and use the inspection report as the corresponding attachment of the inspection item for corresponding reference on the ELN information entry page.

[0030] Preferably, the module M3 comprises:

[0031] Module M3.1: Through the configuration function of the record template, after the inspection result data in the inspection report is captured, it is automatically filled into the corresponding inspection record;

[0032] Module M3.2: After the data is filled in, the formula calculation is automatically triggered, and the laboratory information management system automatically calculates the test results, and at the same time rounds and converts the test results according to the preset requirements.

[0033] Preferably, the configuration of the record template in the module M3 includes the control configuration, calculation formula configuration and rounding method configuration of the record template.

[0034] Preferably, the calculation formula configuration and rounding method configuration include setting various formulas and rounding off the test results according to the actual test record situation;

[0035] The calculation formula includes an F value calculation formula, a K value calculation formula and an RSD calculation formula;

[0036] The rounding methods include: rounding up, rounding off, rounding up and rounding down, as well as scientific notation and percentage conversion.

[0037] Compared with the prior art, the present invention has the following beneficial effects:

[0038] 1. The present invention realizes the automatic collection and calculation of laboratory test data;

[0039] 2. Simplified laboratory inspection process: The automatic collection and calculation of test instrument data greatly simplifies the laboratory inspection process, making the inspection process clearer, more transparent and concise. After the inspection report of the relevant inspection instrument is formed, the system can automatically identify and fill in the corresponding inspection data in the corresponding inspection record, and automatically calculate and determine the inspection results;

[0040] 3. Improve the accuracy of test data: Automatic collection and calculation of test instrument data prevents inspectors from entering incorrect test data, reduces the workload of inspectors, improves the accuracy of test data, and eliminates the possibility of errors. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Other features, objects and advantages of the present invention will become more apparent from the detailed description of non-limiting embodiments made with reference to the following drawings:

[0042] Figure 1 Flowchart of the method for automatic data collection and calculation. DETAILED DESCRIPTION

[0043] The present invention is described in detail below in conjunction with specific embodiments. The following embodiments will help those skilled in the art to further understand the present invention, but are not intended to limit the present invention in any form. It should be noted that, for those of ordinary skill in the art, several changes and improvements can also be made without departing from the concept of the present invention. These all belong to the protection scope of the present invention.

[0044] In view of the defects in the above-mentioned prior art, the technical problem to be solved by the present invention is based on how to quickly and accurately obtain the original data of laboratory testing instruments. The premise of the present invention is to rely on relevant technologies to directly obtain the original data of the testing instruments. The present invention can support any time period and any testing instrument with an operating terminal to meet the data collection requirements of any laboratory.

[0045] In the laboratory inspection process, there are many types of testing instruments used. The original method of manually entering the test values ​​will not only increase the workload, but also have the risk of entering the wrong test values. The patent of this invention is based on the automatic data collection and calculation realized by the printing function and image recognition technology. The system can directly read the original data of the testing instrument and automatically calculate the data at the same time. While improving the accuracy, it greatly improves the laboratory's testing efficiency and makes the inspection process smoother.

[0046] Example 1

[0047] According to the present invention, a method for realizing automatic data collection and calculation based on a printing function includes: Figure 1 As shown,

[0048] Step M1: Automatically capture and bind the inspection report through the printing function;

[0049] Step M2: Analyze and read the inspection data in the inspection report through image recognition technology;

[0050] Step M3: Automatic filling, calculation and rounding of inspection data are realized through configuration of record templates;

[0051] The record template is a templated configuration of the test record in the laboratory information management system. The template configures which data in which position in the test report needs to be captured, and also configures the calculation formula, so that automatic calculation is performed after the data is captured.

[0052] Specifically, the step M1 includes:

[0053] Step M1.1: Obtain the inspection report file through the printing function. When obtaining the inspection report, save the original inspection report attachments. This not only maintains the original inspection report style, but also does not change the inspector's original operating habits, and achieves seamless connection between online and offline. At the same time, it realizes that the inspection result file is not on the ground, and eliminates the possibility of tampering with the data, so as to fully comply with the requirements of relevant regulations to the greatest extent possible;

[0054] Step M1.2: Bind the inspection report attachment to the inspection item, and use the inspection report as the corresponding attachment of the inspection item. It can be checked on the ELN information entry page at any time to facilitate later traceability.

[0055] Specifically, the step M2 includes:

[0056] The automatic analysis and acquisition of data can be realized through image recognition technology, which fundamentally eliminates the possibility of inspectors entering incorrect test values. At the same time, the technology is universal and can be used as long as the original testing equipment has operating terminal software. There is no need for other complex interface docking with instrument manufacturers.

[0057] Specifically, the step M3 includes:

[0058] The control configuration, calculation formula configuration and rounding method configuration of the record template include: in the editing of the corresponding inspection record template, by using the record template configuration tool, the configuration of the corresponding inspection record template is realized, including the configuration of the inspection report data capture, the configuration of the calculation formula, the configuration of the rounding method, etc.;

[0059] More specifically,

[0060] Step M3.1: Through the configuration function of the record template, after the inspection result data in the inspection report is captured, it is automatically filled into the corresponding inspection record; there is no need for the inspector to enter it manually, which reduces the inspector's workload and further improves the inspection efficiency;

[0061] Step M3.2: After the data is filled in, the formula calculation is automatically triggered, and the laboratory information management system automatically calculates the test results. At the same time, the test results are rounded and converted according to the preset requirements, which improves the accuracy of the test and further reduces the workload of the inspector, providing a strong guarantee for the accurate implementation of the laboratory's test work.

[0062] The automatic filling is to automatically fill the identified inspection results into the inspection record generated according to the record template;

[0063] Specifically, the configuration of the recording template in step M3 includes the configuration of the control, the calculation formula and the rounding method of the recording template. The recording module supports various control selections, and the calculation formula and the rounding method are also preset in the recording module.

[0064] Specifically, the calculation formula configuration and rounding method configuration include setting various formulas and rounding off the test results according to the actual test record situation;

[0065] The calculation formula includes an F value calculation formula, a K value calculation formula and an RSD calculation formula;

[0066] The rounding methods include: rounding up, rounding off, rounding up and rounding down, as well as scientific notation and percentage conversion.

[0067] According to the present invention, a system for realizing automatic data collection and calculation based on a printing function includes:

[0068] Module M1: Automatically capture and bind inspection reports through the printing function;

[0069] Module M2: Analyze and read the inspection data in the inspection report through image recognition technology;

[0070] Module M3: Automatic filling, calculation and rounding of inspection data through configuration of record templates;

[0071] The record template is a templated configuration of the test record in the laboratory information management system. The template configures which data in which position in the test report needs to be captured, and also configures the calculation formula, so that automatic calculation is performed after the data is captured.

[0072] Specifically, the module M1 includes:

[0073] Module M1.1: Obtain the inspection report file through the printing function, and save the original inspection report attachments while obtaining the inspection report; it not only maintains the original inspection report style, but also does not need to change the inspector's original operating habits, and realizes the seamless connection between online and offline. At the same time, it realizes that the inspection result file is not on the ground, and eliminates the possibility of tampering with the data, so as to fully comply with the requirements of relevant regulations to the greatest extent possible;

[0074] Module M1.2: Bind the inspection report attachment to the inspection item, and use the inspection report as the corresponding attachment of the inspection item. It can be checked on the ELN information entry page at any time to facilitate later traceability.

[0075] Specifically, the module M2 includes:

[0076] The automatic analysis and acquisition of data can be realized through image recognition technology, which fundamentally eliminates the possibility of inspectors entering incorrect test values. At the same time, the technology is universal and can be used as long as the original testing equipment has operating terminal software. There is no need for other complex interface docking with instrument manufacturers.

[0077] Specifically, the module M3 includes:

[0078] The control configuration, calculation formula configuration and rounding method configuration of the record template include: in the editing of the corresponding inspection record template, by using the record template configuration tool, the configuration of the corresponding inspection record template is realized, including the configuration of the inspection report data capture, the configuration of the calculation formula, the configuration of the rounding method, etc.;

[0079] More specifically,

[0080] Module M3.1: Through the configuration function of the record template, after the inspection result data in the inspection report is captured, it is automatically filled into the corresponding inspection record; there is no need for the inspector to enter it manually, which reduces the inspector's workload and further improves the inspection efficiency;

[0081] Module M3.2: After the data is filled in, the formula calculation is automatically triggered, and the laboratory information management system automatically calculates the test results. At the same time, the test results are rounded and converted according to the preset requirements, which improves the accuracy of the test and further reduces the workload of the inspectors, providing a strong guarantee for the accurate implementation of the laboratory's test work.

[0082] The automatic filling is to automatically fill the identified inspection results into the inspection record generated according to the record template;

[0083] Specifically, the configuration of the recording template in the module M3 includes the control configuration, calculation formula configuration and rounding method configuration of the recording template. The recording module supports various control selections, and the calculation formula and rounding method are also preset in the recording module.

[0084] Specifically, the calculation formula configuration and rounding method configuration include setting various formulas and rounding off the test results according to the actual test record situation;

[0085] The calculation formula includes an F value calculation formula, a K value calculation formula and an RSD calculation formula;

[0086] The rounding methods include: rounding up, rounding off, rounding up and rounding down, as well as scientific notation and percentage conversion.

[0087] Example 2

[0088] Example 2 is a variation of Example 1

[0089] The method for automatic data collection and calculation based on the printing function provided by the present invention comprises the following steps:

[0090] (1) Through the configuration function of the record template, in the corresponding inspection record template editing, by using the record template configuration tool, the configuration of the corresponding inspection record template is realized, including the configuration of controls, the configuration of the corresponding position in the inspection data capture report, the configuration of the calculation formula, the configuration of the rounding method, etc.;

[0091] (2) Printing of the test report is performed through the client software of the test instrument. The present invention realizes automatic uploading of the test report attachments and binding them to the corresponding test items. At the same time, the image recognition technology is used to realize automatic reading and analysis of the test report data and fill in the test data.

[0092] (3) In the LIMS system inspection process, in the "ELN Information Entry" module, confirm that the instrument inspection data attachment is automatically uploaded successfully;

[0093] (4) In the "ELN Information Entry" module, by clicking the corresponding inspection record link, you can check in the inspection record that the uploaded inspection data has been automatically uploaded and automatically filled into the inspection record, and the correct inspection result has been automatically calculated.

[0094] Example 3

[0095] Embodiment 3 is a variation of Embodiment 1 and / or Embodiment 2.

[0096] In view of the above existing needs, the present invention proposes a method for automatically collecting data based on the printing function and automatically calculating the data. The operation flow of the method includes collecting data modules, configuring record template information, configuring inspection instruments, etc.

[0097] Record template configuration module:

[0098] The corresponding file capture location is configured in the record template, and the automatic calculation event is triggered after the data is captured. According to the actual inspection record situation, various formulas are set and the inspection results are rounded off. In addition to supporting mainstream calculation formulas, it also supports formulas including: F value, K value, RSD and other calculation formulas in laboratory inspections; rounding methods include rounding up, rounding down, carrying up, carrying down, etc.; scientific notation and percentage conversion are also supported.

[0099] Data acquisition module and image recognition module:

[0100] After the test is completed, when printing is performed on the client side of the testing instrument, the acquisition module automatically obtains the printed file stream and saves the file. All printed files are saved as attachments to the inspection items, thus ensuring that the files are not dropped and there is no possibility of tampering. After the attachment is successfully captured, the image recognition technology is used to automatically identify and analyze the inspection data in the inspection report, and the inspection data is analyzed and automatically filled according to the corresponding configuration in the record template, thereby achieving the purpose of timely data collection. At the same time, the inspection report is saved in the corresponding inspection item record as an attachment for easy viewing and tracing.

[0101] In the description of the present application, it should be understood that the terms "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside", "outside", etc., indicating orientations or positional relationships, are based on the orientations or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the present application and simplifying the description, and do not indicate or imply that the referred device or element must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be understood as a limitation on the present application.

[0102] Those skilled in the art know that, in addition to implementing the system, device and its various modules provided by the present invention in a purely computer-readable program code, it is entirely possible to implement the same program in the form of logic gates, switches, application-specific integrated circuits, programmable logic controllers and embedded microcontrollers by logically programming the method steps. Therefore, the system, device and its various modules provided by the present invention can be considered as a hardware component, and the modules included therein for implementing various programs can also be considered as structures within the hardware component; the modules for implementing various functions can also be considered as both software programs for implementing the method and structures within the hardware component.

[0103] The above describes the specific embodiments of the present invention. It should be understood that the present invention is not limited to the above specific embodiments, and those skilled in the art can make various changes or modifications within the scope of the claims, which does not affect the essence of the present invention. In the absence of conflict, the embodiments of the present application and the features in the embodiments can be combined with each other arbitrarily.

Claims

1. A method for realizing automatic data collection and calculation based on printing function, characterized in that: include: Step M1: Automatically capture and bind the inspection report through the printing function; Step M2: Analyze and read the inspection data in the inspection report through image recognition technology; Step M3: Automatic filling, calculation and rounding of inspection data are realized through configuration of record templates; The record template is a templated configuration of the test record in the laboratory information management system; The step M1 comprises: Step M1.1: Obtain the inspection report file through the print function, and save the original inspection report attachment while obtaining the inspection report; Step M1.2: Bind the inspection report attachment to the inspection item, and use the inspection report as the corresponding attachment of the inspection item for corresponding reference on the ELN information entry page; The step M3 comprises: Step M3.1: After capturing the inspection result data in the inspection report, automatically fill it into the corresponding inspection record through the configuration function of the record template; Step M3.2: After the data is filled, the formula calculation is automatically triggered, and the laboratory information management system automatically calculates the test results and rounds and converts the test results according to the preset requirements; The configuration of the record template in step M3 includes the configuration of the control, the calculation formula and the rounding method of the record template; The calculation formula configuration and rounding method configuration include setting various formulas and rounding off the test results according to the actual test record situation; The calculation formula includes an F value calculation formula, a K value calculation formula and an RSD calculation formula; The rounding methods include: rounding up, rounding off, rounding up and rounding down, as well as scientific notation and percentage conversion.

2. A system for realizing automatic data collection and calculation based on printing function, characterized in that: include: Module M1: Automatically capture and bind inspection reports through the printing function; Module M2: Analyze and read the inspection data in the inspection report through image recognition technology; Module M3: Automatic filling, calculation and rounding of inspection data through configuration of record templates; The record template is a templated configuration of the test record in the laboratory information management system; The module M1 comprises: Module M1.1: Obtain the inspection report file through the printing function, and save the original inspection report attachments while obtaining the inspection report; Module M1.2: Bind the inspection report attachment to the inspection item, and use the inspection report as the corresponding attachment of the inspection item for corresponding reference on the ELN information entry page; The module M3 comprises: Module M3.1: Through the configuration function of the record template, after the inspection result data in the inspection report is captured, it is automatically filled into the corresponding inspection record; Module M3.2: After the data is filled, the formula calculation is automatically triggered, and the laboratory information management system automatically calculates the test results, and at the same time rounds and converts the test results according to the preset requirements; The configuration of the record template in the module M3 includes the control configuration, calculation formula configuration and rounding method configuration of the record template; The calculation formula configuration and rounding method configuration include setting various formulas and rounding off the test results according to the actual test record situation; The calculation formula includes an F value calculation formula, a K value calculation formula and an RSD calculation formula; The rounding methods include: rounding up, rounding off, rounding up and rounding down, as well as scientific notation and percentage conversion.

Images