CN116796932A - Detection laboratory equipment data acquisition and electronic original record list management system - Google Patents
Detection laboratory equipment data acquisition and electronic original record list management system Download PDFInfo
- Publication number
- CN116796932A CN116796932A CN202311097598.6A CN202311097598A CN116796932A CN 116796932 A CN116796932 A CN 116796932A CN 202311097598 A CN202311097598 A CN 202311097598A CN 116796932 A CN116796932 A CN 116796932A
- Authority
- CN
- China
- Prior art keywords
- data
- detection
- sample
- file
- laboratory
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000001514 detection method Methods 0.000 title claims abstract description 124
- 238000007726 management method Methods 0.000 claims abstract description 26
- 238000012545 processing Methods 0.000 claims abstract description 24
- 238000005259 measurement Methods 0.000 claims abstract description 15
- 230000010354 integration Effects 0.000 claims abstract description 8
- 238000007405 data analysis Methods 0.000 claims abstract description 7
- 238000003860 storage Methods 0.000 claims abstract description 7
- 238000004364 calculation method Methods 0.000 claims abstract description 6
- 238000013500 data storage Methods 0.000 claims abstract description 3
- 230000009467 reduction Effects 0.000 claims abstract description 3
- 239000000523 sample Substances 0.000 claims description 83
- 238000004458 analytical method Methods 0.000 claims description 43
- 238000000034 method Methods 0.000 claims description 23
- 238000002347 injection Methods 0.000 claims description 11
- 239000007924 injection Substances 0.000 claims description 11
- 239000012496 blank sample Substances 0.000 claims description 8
- 238000004891 communication Methods 0.000 claims description 4
- 238000012544 monitoring process Methods 0.000 claims description 4
- 230000005540 biological transmission Effects 0.000 claims description 3
- 230000003993 interaction Effects 0.000 claims description 3
- 238000012360 testing method Methods 0.000 claims description 3
- 230000001351 cycling effect Effects 0.000 claims description 2
- 238000013506 data mapping Methods 0.000 claims description 2
- 230000008569 process Effects 0.000 claims description 2
- 238000003672 processing method Methods 0.000 claims description 2
- 238000000926 separation method Methods 0.000 claims description 2
- 238000007689 inspection Methods 0.000 claims 1
- 238000012423 maintenance Methods 0.000 claims 1
- 238000005303 weighing Methods 0.000 description 3
- 238000011208 chromatographic data Methods 0.000 description 2
- 238000013480 data collection Methods 0.000 description 2
- 230000008439 repair process Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000003153 chemical reaction reagent Substances 0.000 description 1
- 238000004587 chromatography analysis Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000002474 experimental method Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000007788 liquid Substances 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
- 238000003908 quality control method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Entrepreneurship & Innovation (AREA)
- Strategic Management (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Human Computer Interaction (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Automatic Analysis And Handling Materials Therefor (AREA)
Abstract
The invention provides a detection laboratory equipment data acquisition and electronic original record management system, which comprises a detection instrument management workstation, a laboratory data acquisition module and a laboratory data processing module; the specific steps of the work are as follows: firstly, capturing a data file generated by detection instrument equipment, transmitting the data file to a laboratory data acquisition module for centralized storage, and then carrying out data analysis and integration; and finally, the analyzed and integrated data are subjected to data storage in a laboratory data processing module to generate an original record list, automatic assignment is performed according to the analyzed data, formula calculation, automatic reduction and actual measurement value feedback processing are performed, and the acquired original data file and map data are automatically associated or matched. The system can automatically analyze and store the detection data files of various different types of detection laboratory remote acquisition instrument and equipment, generate an original record list and associate the matched original data files with the map data.
Description
Technical Field
The invention belongs to the technical field of information interaction equipment, and particularly relates to a data acquisition and electronic original record management system for detection laboratory equipment.
Background
At present, laboratory detection instruments are of various types, and are commonly used as a UV tester, an IR tester, a liquid chromatograph, a gas chromatograph and the like, and analysis or test staff usually directly store the original data of detection results on a PC workstation connected with the tester, especially when a plurality of detection instruments are used for detecting different detection items of the same sample, the scattered storage of the detection data easily causes the problems of non-correspondence, data omission, difficult data utilization and the like between the detection result data and the information of the entrusted detector.
Disclosure of Invention
In order to solve the technical problems, the invention provides a detection laboratory equipment data acquisition and electronic original record management system, which comprises a detection instrument management workstation, a laboratory data acquisition module and a laboratory data processing module;
the detecting instrument management workstation is used for capturing or collecting data or files generated by detecting instrument equipment and transmitting the data or files to the laboratory data acquisition module;
the laboratory data acquisition module is used for carrying out centralized storage on the transmitted data or files, then carrying out data analysis and integration, and transmitting the data to the experimental data processing module;
and the experimental data processing module is used for storing and processing the transmitted data.
As an improvement, the system works by the following specific steps:
firstly, capturing a data file generated by detection instrument equipment, transmitting the data file to a laboratory data acquisition module for centralized storage, and then analyzing and integrating the data;
finally, the analyzed and integrated data are subjected to data storage in a laboratory data processing module to generate an original record list, automatic assignment is carried out according to the analyzed data, formula calculation, automatic contract repair and actual measurement value feedback processing are carried out, and the acquired original data file and map data are automatically associated or matched;
the data processing method comprises the following steps: constructing a timing task, remotely accessing a detection instrument management workstation to capture detection data files, automatically starting an associated data analysis task, analyzing detection data from the detection data files according to preconfigured analysis class parameters, analysis templates and the like, and completing data processing tasks such as analysis data mapping, analysis document management, analysis task operation log records and the like;
the integration method is any one of the following steps:
(1) The laboratory data acquisition module is directly integrated with the networked instrument cloud platform;
(2) The laboratory data acquisition module is integrated with data saving software of a single machine instrument workstation;
(3) The laboratory data acquisition module is connected with a serial port of detection instrument equipment in a mode of converting serial port into wifi, acquires detection data by using a mobile terminal APP and stores the detection data in a system background.
The method for detecting the data file grabbing comprises the following steps: firstly, configuring a special remote folder for each single machine instrument, configuring a timing task for the equipment, capturing detection data files in the designated remote folder at fixed time according to equipment information, and storing the detection data files in a corresponding folder of a data acquisition and processing system server; or, the special file grabbing client is installed in the instrument workstation to directly grab the monitoring data file in the instrument workstation, and the monitoring data file is uploaded and stored in the corresponding file folder of the data acquisition and processing system server.
The data analysis adopts a mode of combining an analysis template with an analysis rule. Configuring at least one analysis template for detection data files acquired from different instrument equipment, and correlating according to the modes of keyword equivalent matching, keyword fuzzy matching and the like; the analysis template outputs the structured detection result data of the corresponding template by using a preconfigured analysis rule; or, according to the pre-configured keyword information, intercepting the corresponding spectrogram from the data file and outputting the spectrogram file stored as the known type. The analysis rules comprise a main analysis rule and a sub analysis rule; the main analysis rule refers to that when the detection data file of the instrument equipment contains multiple sample and multiple items, a report needs to be split into multiple single sample data files, key information needing to be configured comprises a interception starting position key and an interception ending position key, when the starting key and the ending key are configured, the information contained in the middle is intercepted by cycling through the starting key and the ending key, and one section is a data file of one sample; if only the end key is configured, the end key is used as a separator to divide the original file into a plurality of parts, and each part is a sample data file; the sub-analysis rule is to obtain the name of the detection item, the result value of the detection item, the number unit and other information from the single sample data file according to the pre-configured separation character, and store the information in a background database.
The integrated method (1) adopts a network service interface to interact data with a remote machine through a post request and a get request of an HTTP protocol, and XML message calling under a simple object access protocol is completed. The integrated method (2) adopts an FTP file transmission method, processes and analyzes the file according to a certain file format, and after obtaining sample information and detection results in the file, stores the data in a background database and carries out information association with a detected sample, wherein the file format comprises PDF, TXT, word, excel and other types; when the file format is processed and analyzed, the analysis of the data file is completed by configuring a template analysis class, or by directly referencing a fixed template containing multiple parameters, or by configuring a text template and analyzing parameters. The integrated method (3) is characterized in that an instrument communication interface is connected with a local area network and a data acquisition and processing server through a serial port-to-wifi, a mobile terminal APP scans a sample bar code to obtain sample information, and meanwhile, the instrument communication interface is connected with a data acquisition module through the local area network to obtain detection data of a corresponding sample and store the detection data in a system background database.
The original record list is manufactured by adopting an online electronic form, different original record templates are configured according to different samples and detection items, sample information, detection items and actual measurement values in the original record list are automatically filled in, and calculation and automatic reduction are performed according to a preconfigured formula. The original record list is automatically filled in by comprehensively adopting one or more of the following methods:
data binding: designating the data source of each cell of the original record list, and binding the data source with the detection item and the detection result data after collecting the instrument and equipment data file and analyzing the data file;
loop domain: performing automatic circulation assignment on a set partial area of the electronic record list of multiple items and multiple samples;
automatic injection: for the part with repeated filling, automatically filling the region into the frame, automatically storing the region content, and configuring to clear periodically;
actual measurement value setting: setting a certain cell as an actual measurement value and transmitting the actual measurement value back to a detection report;
unit setting: and setting the content of a certain cell as a measurement unit of the detection result, and transmitting the measurement unit back to the detection report.
The manufacturing method of the electronic original record comprises the following steps: finding a corresponding original record form template according to the detection item, generating an original record form, and automatically opening, automatically associating or matching the acquired original data file in the online electronic form, wherein the specific steps are as follows:
(1) According to a circulation domain configured by the template, automatically filling in a designated area in a circulation way, wherein the circulation times are products of the number of samples and the number of detection items;
(2) Judging whether an automatic injection area is configured, if so, searching whether corresponding automatic injection area information content exists and judging whether the automatic injection area information content is out of date, and if so, automatically filling by using the automatic injection area information content;
(3) Finding out data binding information configured in an original record list, finding out corresponding field values according to rules, filling in the bound cells, and centering the picture;
(4) The corresponding relation between the sample number and the data file is recorded during data acquisition and analysis, the data file corresponding to the sample is found according to the corresponding relation, and the page number containing the sample number and the detection item name is screened out according to the detection item name;
(5) Searching blank sample and standard sample detection data files of samples and items in the following three modes, finding page numbers corresponding to the blank sample and standard sample detection data files according to the blank sample, the keywords of the standard sample and the names of the detection items configured in the analysis rules, and storing the page numbers;
-according to the time sequence, the same instrument and equipment is used for the same detection project, and the latest blank and standard sample are used as the blank and standard sample of the sample and project before the sample starts to test;
-the file names of the blank and standard sample contain the sample number of the sample according to the data file name;
-according to the folder path, if the devices and paths of the detection data file and the sample detection data file of the blank and the standard are the same, the blank and the standard are the blank and the standard of the sample;
(6) If the sample is associated with a plurality of data files from different detection instrument devices, searching the plurality of data files, and storing page numbers of each file including sample numbers and detection item names;
(7) Recording the id of a sample associated data file and the page number of a detection item in the file;
(8) De-duplication for file ID and page number combination values;
(9) Displaying an original record list on the left side of the screen, displaying detection data files and corresponding page numbers associated with the sample, the blank sample and the standard sample on the right side of the screen, and supporting manual selection of the page numbers;
(10) After selecting the detection data file and page number, clicking a save button, merging the selected pages in all detection data files into a complete pdf document, and archiving the complete pdf document as the original data file associated with the original record sheet.
The beneficial effects are that: the system for acquiring the data of the detection laboratory equipment and managing the electronic original record list can automatically analyze and store the data files according to the detection data files of various different types of detection laboratory remote acquisition instruments and equipment, generate the original record list and correlate and match the original data files and map data.
Drawings
Fig. 1 is a schematic diagram of the principle structure of the system of the present invention.
Description of the embodiments
The invention is further described below with reference to examples of embodiments.
Referring to fig. 1, the data acquisition and electronic original record management system of the detection laboratory equipment of the present invention is described and illustrated in the following two aspects.
The laboratory uses instrument equipment to detect the sample, and the detection laboratory equipment data acquisition and electronic original record list management system is connected with the instrument equipment to obtain a detection result data file in one of the following modes, and performs data analysis according to a pre-configured analysis template and analysis rules and stores the data in a background database.
(1) The laboratory data acquisition module is directly integrated with the networked instrument cloud platform, and sample information to be analyzed and sample detection result data are acquired from the networked instrument cloud platform;
(2) The laboratory data acquisition module acquires sample information and sample detection result data through integration with management software of a detection instrument equipment workstation;
(3) The laboratory data acquisition module is connected with a detection instrument and equipment serial port in a mode of converting serial port into wifi, and obtains sample information and detection result data by using the mobile terminal APP and stores the sample information and the detection result data in a background database.
And secondly, in the first method, the networked instrument cloud platform adopts a network service interface to interact data with a remote machine through a post request and a get request of an HTTP protocol, so that XML message calling under a simple object access protocol is completed.
For example, when a company performs chromatographic analysis experiments, through a first integration method, data interaction is performed between a laboratory data acquisition module and a networked chromatographic management system, chromatograph operators find an integration module or a plug-in unit associated with the laboratory data acquisition module in a networked instrument cloud platform, sample information is directly acquired through the module or the plug-in unit, chromatographic data files are recorded in the networked instrument cloud platform after sample detection is completed, and the chromatographic data files are pushed to the laboratory data acquisition module, so that the acquisition efficiency and quality of the whole analysis data are improved.
(III) as a specific implementation mode of the invention, in the second method, an FTP file transmission method is adopted, processing and analysis are carried out through PDF, TXT, word, excel and other file formats, after sample information and detection results in the file are obtained, data of the sample information and detection results are stored in a background database, and information association is carried out on the sample to be detected; when the file format is processed and analyzed, the analysis of the data file is completed by configuring a template analysis class, or by directly referencing a fixed template containing multiple parameters, or by configuring a text template and analyzing parameters.
For example, when a laboratory uses a mass spectrometer to measure a sample, a remote folder special for data collection can be configured for each instrument workstation computer, meanwhile, equipment IP addresses, ports, usernames, passwords, remote file directories, smb versions and the like are registered in a combined manner, a timing task is configured, and specified remote folders are used for capturing detection result data files at a timing and are stored in corresponding folders of a data collection server. In another method, a universal file grabbing client is installed on an equipment workstation, detection result data files generated by instrument equipment are grabbed at fixed time, and the detection result data files are uploaded and stored in a corresponding folder of a data acquisition server.
And fourthly, in the third method, the laboratory data acquisition module is connected with the instrument and equipment serial port by adopting the serial port to wifi, the mobile terminal APP scans the sample bar code to acquire sample information, and meanwhile, the laboratory data acquisition module is connected with the data acquisition module through a local area network to acquire detection data of a corresponding sample and store the detection data in a system background database.
For example, when a laboratory performs balance weighing, a balance operator uses a PAD or a mobile phone provided with a balance weighing APP to scan a sample bar code to obtain sample information, the sample bar code is connected with an RS232 port of an electronic balance through a serial port-to-wifi converter, one or more serial port acquisition methods are developed according to a protocol provided by an equipment manufacturer, a serial port acquisition class is called by a program at regular time, a modleBus protocol command is sent, balance weighing data is obtained, and the acquired data is transmitted to a server for storage.
And fifthly, as a specific implementation mode of the invention, an electronic original record form template is manufactured by adopting an online electronic form similar to excel, and each laboratory can bind or not bind detection items according to the characteristics of the electronic original record form template, and can configure calculation functions and automatic repair rules for measured values. The electronic original record sheet can be filled out by comprehensively adopting one or more of the following methods:
(1) Data binding: and designating the data source in each cell by the data acquired by the data acquisition module in a data binding mode, and automatically filling in an electronic original record list. At present, automatic filling of actual measurement values of items such as samples, blanks, quality control samples, standard curves, balance and the like and reagent information data is provided.
(2) Loop domain: if there are multiple samples and multiple items in one electronic record, a loop field needs to be allocated to a certain part of the area of the form. When the sample or item is detected to be not unique, the automatic circulation and assignment are performed.
(3) Automatic injection: the same type of electronic original record sheet has a part which is filled in repeatedly, after the automatic injection of the frame into the area, the system automatically saves the content of the area, and the periodic clearing can be configured, for example, for one day or one week.
(4) Actual measurement value setting: and setting a certain cell as the actual measurement value for transmitting the actual measurement value back to the report.
(5) The measurement unit is set: a certain cell is set as a unit of measure for returning the unit to the report.
The above examples illustrate only a few embodiments of the invention, which are described in detail and are not to be construed as limiting the scope of the invention. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the invention, which are all within the scope of the invention. Accordingly, the scope of protection of the present invention is to be determined by the appended claims.
Claims (10)
1. A detection laboratory equipment data acquisition and electronic original record management system is characterized in that: the system comprises a detection instrument management workstation, a laboratory data acquisition module and a laboratory data processing module;
the detecting instrument management workstation is used for capturing or collecting data or files generated by detecting instrument equipment and transmitting the data or files to the laboratory data acquisition module;
the laboratory data acquisition module is used for carrying out centralized storage on the transmitted data or files, then carrying out data analysis and integration, and transmitting the data to the experimental data processing module;
and the experimental data processing module is used for storing and processing the transmitted data.
2. The detection laboratory equipment data acquisition and electronic raw record management system according to claim 1, wherein: the system comprises the following specific steps of:
firstly, capturing a data file generated by detection instrument equipment, transmitting the data file to a laboratory data acquisition module for centralized storage, and then analyzing and integrating the data;
finally, the analyzed and integrated data are subjected to data storage in a laboratory data processing module to generate an original record list, automatic assignment is carried out according to the analyzed data, formula calculation, automatic maintenance and actual measurement value feedback processing are carried out, and the acquired original data file and map data are automatically associated or matched;
the data processing method comprises the following steps: constructing a timing task, remotely accessing a detection instrument management workstation to capture detection data files, automatically starting an associated data analysis task, analyzing detection data from the detection data files according to a pre-configured analysis class parameter and an analysis template, and completing analysis data mapping, analysis document management and analysis task operation log record data processing tasks;
the integration method is any one of the following steps:
(1) The laboratory data acquisition module is directly integrated with the networked instrument cloud platform;
(2) The laboratory data acquisition module is integrated with data saving software of a single machine instrument workstation;
(3) The laboratory data acquisition module is connected with a serial port of detection instrument equipment in a mode of converting serial port into wifi, acquires detection data by using a mobile terminal APP and stores the detection data in a system background.
3. The detection laboratory equipment data acquisition and electronic raw record management system according to claim 2, wherein: the method for detecting the data file grabbing comprises the following steps: firstly, configuring a special remote folder for each single machine instrument, configuring a timing task for the equipment, capturing detection data files in the designated remote folder at fixed time according to equipment information, and storing the detection data files in a corresponding folder of a data acquisition and processing system server; or, the special file grabbing client is installed in the instrument workstation to directly grab the monitoring data file in the instrument workstation, and the monitoring data file is uploaded and stored in the corresponding file folder of the data acquisition and processing system server.
4. A detection laboratory equipment data acquisition and electronic raw record management system according to claim 3, characterized in that: configuring at least one analysis template for detection data files acquired from different instrument equipment, and correlating according to a keyword equivalent matching mode and a keyword fuzzy matching mode; the analysis template outputs the structured detection result data of the corresponding template by using a preconfigured analysis rule; or, according to the pre-configured keyword information, intercepting the corresponding spectrogram from the data file and outputting the spectrogram file stored as the known type.
5. The inspection laboratory equipment data acquisition and electronic raw record management system of claim 4, wherein: the analysis rules comprise a main analysis rule and a sub analysis rule; the main analysis rule refers to that when the detection data file of the instrument equipment contains multiple sample and multiple items, a report needs to be split into multiple single sample data files, key information needing to be configured comprises a interception starting position key and an interception ending position key, when the starting key and the ending key are configured, the information contained in the middle is intercepted by cycling through the starting key and the ending key, and one section is a data file of one sample; if only the end key is configured, the end key is used as a separator to divide the original file into a plurality of parts, and each part is a sample data file; the sub-analysis rule is to obtain the name of the detection item, the result value of the detection item and the information of the number unit from the single sample data file according to the pre-configured separation character, and store the information into a background database.
6. The detection laboratory equipment data acquisition and electronic raw record management system according to claim 2, wherein: the integrated method (1) is that a network service interface is adopted by the networked instrument cloud platform, and data interaction is carried out with a remote machine through a post request and a get request of an HTTP protocol, so that XML message calling under a simple object access protocol is completed.
7. The detection laboratory equipment data acquisition and electronic raw record management system according to claim 2, wherein: the integrated method (2) adopts an FTP file transmission method to process and analyze different file formats, after sample information and detection results in the file are obtained, the data of the file are stored in a background database and are in information association with a detected sample, wherein the types of the file formats comprise PDF, TXT, word, excel;
when the file format is processed and analyzed, the analysis of the data file is completed by configuring a template analysis class, or by directly referencing a fixed template containing multiple parameters, or by configuring a text template and analyzing parameters.
8. The detection laboratory equipment data acquisition and electronic raw record management system according to claim 2, wherein: the integrated method (3) is characterized in that an instrument communication interface is connected with a local area network and a data acquisition and processing server through a serial port-to-wifi, a mobile terminal APP scans a sample bar code to obtain sample information, and meanwhile, the instrument communication interface is connected with a data acquisition module through the local area network to obtain detection data of a corresponding sample and store the detection data in a system background database.
9. The detection laboratory equipment data acquisition and electronic raw record management system according to claim 2, wherein: the original record list is made by adopting an online electronic form, different original record templates are configured according to different samples and detection items, sample information, detection items and actual measurement values in the original record list are automatically filled in, and calculation and automatic reduction are performed according to a pre-configured formula.
10. The detection laboratory equipment data acquisition and electronic raw record management system according to claim 2, wherein: finding out a corresponding original record form template according to the detection item, generating an original record form, and automatically opening, automatically associating or matching the acquired original data file and the acquired map data in the online electronic form, wherein the specific steps are as follows:
(1) According to a circulation domain configured by the template, automatically filling in a designated area in a circulation way, wherein the circulation times are products of the number of samples and the number of detection items;
(2) Judging whether an automatic injection area is configured, if so, searching whether corresponding automatic injection area information content exists and judging whether the automatic injection area information content is out of date, and if so, automatically filling by using the automatic injection area information content;
(3) Finding out data binding information configured in an original record list, finding out corresponding field values according to rules, filling in the bound cells, and centering the picture;
(4) The corresponding relation between the sample number and the data file is recorded during data acquisition and analysis, the data file corresponding to the sample is found according to the corresponding relation, and the page number containing the sample number and the detection item name is screened out according to the detection item name;
(5) Searching blank sample and standard sample detection data files of samples and items in the following three modes, finding page numbers corresponding to the blank sample and standard sample detection data files according to the blank sample, the keywords of the standard sample and the names of the detection items configured in the analysis rules, and storing the page numbers;
-according to the time sequence, the same instrument and equipment is used for the same detection project, and the latest blank and standard sample are used as the blank and standard sample of the sample and project before the sample starts to test;
-the file names of the blank and standard sample contain the sample number of the sample according to the data file name;
-according to the folder path, if the devices and paths of the detection data file and the sample detection data file of the blank and the standard are the same, the blank and the standard are the blank and the standard of the sample;
(6) If the sample is associated with a plurality of data files from different detection instrument devices, searching the plurality of data files, and storing page numbers of each file including sample numbers and detection item names;
(7) Recording the id of a sample associated data file and the page number of a detection item in the file;
(8) De-duplication for file ID and page number combination values;
(9) Displaying an original record list on the left side of the screen, displaying detection data files and corresponding page numbers associated with the sample, the blank sample and the standard sample on the right side of the screen, and supporting manual selection of the page numbers;
(10) After selecting the detection data file and page number, clicking a save button, merging the selected pages in all detection data files into a complete pdf document, and archiving the complete pdf document as the original data file associated with the original record sheet.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311097598.6A CN116796932B (en) | 2023-08-29 | 2023-08-29 | Detection laboratory equipment data acquisition and electronic original record list management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311097598.6A CN116796932B (en) | 2023-08-29 | 2023-08-29 | Detection laboratory equipment data acquisition and electronic original record list management system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116796932A true CN116796932A (en) | 2023-09-22 |
| CN116796932B CN116796932B (en) | 2023-12-05 |
Family
ID=88044393
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311097598.6A Active CN116796932B (en) | 2023-08-29 | 2023-08-29 | Detection laboratory equipment data acquisition and electronic original record list management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116796932B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117973688A (en) * | 2024-02-01 | 2024-05-03 | 南京朗赢信息技术有限公司 | Detection laboratory instrument and equipment management system based on Internet of things and electronic ink screen technology |
| CN118583906A (en) * | 2024-08-05 | 2024-09-03 | 杭州研趣信息技术有限公司 | X-ray spectrum detection system, method, equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170374573A1 (en) * | 2013-03-15 | 2017-12-28 | DGS Global Systems, Inc. | Systems, methods, and devices having databases and automated reports for electronic spectrum management |
| CN110321531A (en) * | 2018-03-30 | 2019-10-11 | 中国石化销售有限公司 | Laboratory Instruments information management system |
| CN110717322A (en) * | 2019-10-10 | 2020-01-21 | 湖南舞龙软件开发有限公司 | Universal generation method for quality monitoring analysis original record table |
| CN110889018A (en) * | 2019-11-22 | 2020-03-17 | 贵州科学院(贵州省应用技术研究院) | Based on GLP laboratory information management integration platform system |
| CN111461517A (en) * | 2020-03-27 | 2020-07-28 | 机械工业仪器仪表综合技术经济研究所 | Intelligent information system for planning laboratory workflow |
| CN111914026A (en) * | 2020-07-31 | 2020-11-10 | 南京朗赢信息技术有限公司 | General data exchange sharing service platform |
| CN112632949A (en) * | 2020-12-30 | 2021-04-09 | 甘肃省商业科技研究所有限公司 | Method for realizing on-line original record input by adopting on-line document |
| CN115272649A (en) * | 2021-04-30 | 2022-11-01 | 南京燧坤智能科技有限公司 | Image recognition, retrieval and entry method and system of molecular structure diagram and medium |
-
2023
- 2023-08-29 CN CN202311097598.6A patent/CN116796932B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170374573A1 (en) * | 2013-03-15 | 2017-12-28 | DGS Global Systems, Inc. | Systems, methods, and devices having databases and automated reports for electronic spectrum management |
| CN110321531A (en) * | 2018-03-30 | 2019-10-11 | 中国石化销售有限公司 | Laboratory Instruments information management system |
| CN110717322A (en) * | 2019-10-10 | 2020-01-21 | 湖南舞龙软件开发有限公司 | Universal generation method for quality monitoring analysis original record table |
| CN110889018A (en) * | 2019-11-22 | 2020-03-17 | 贵州科学院(贵州省应用技术研究院) | Based on GLP laboratory information management integration platform system |
| CN111461517A (en) * | 2020-03-27 | 2020-07-28 | 机械工业仪器仪表综合技术经济研究所 | Intelligent information system for planning laboratory workflow |
| CN111914026A (en) * | 2020-07-31 | 2020-11-10 | 南京朗赢信息技术有限公司 | General data exchange sharing service platform |
| CN112632949A (en) * | 2020-12-30 | 2021-04-09 | 甘肃省商业科技研究所有限公司 | Method for realizing on-line original record input by adopting on-line document |
| CN115272649A (en) * | 2021-04-30 | 2022-11-01 | 南京燧坤智能科技有限公司 | Image recognition, retrieval and entry method and system of molecular structure diagram and medium |
Non-Patent Citations (4)
| Title |
|---|
| JIAYE PAN等: "Lightweight and Efficient Hypervisor-Based Dynamic Binary Instrumentation and Analysis Method", 《IEEE ACCESS》, no. 08, pages 164593 - 164610, XP011809744, DOI: 10.1109/ACCESS.2020.3021463 * |
| 倪浩然: "基于LIBS的煤炭检测数据分析技术及应用", 《中国优秀硕士学位论文全文数据库 基础科学辑》, no. 02, pages 005 - 553 * |
| 谭敏清等: "全国新兴产业检验检测服务资源分布的调研报告", 《中国检验检测》, vol. 30, no. 05, pages 3 - 7 * |
| 阮士杰: "大数据环境下高效检索算法的研究和实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》, no. 03, pages 138 - 2334 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117973688A (en) * | 2024-02-01 | 2024-05-03 | 南京朗赢信息技术有限公司 | Detection laboratory instrument and equipment management system based on Internet of things and electronic ink screen technology |
| CN118583906A (en) * | 2024-08-05 | 2024-09-03 | 杭州研趣信息技术有限公司 | X-ray spectrum detection system, method, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116796932B (en) | 2023-12-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN116796932B (en) | Detection laboratory equipment data acquisition and electronic original record list management system | |
| CN108604358B (en) | Analysis information management system | |
| CN110347644B (en) | Paperless inspection and detection system and operation method thereof | |
| CN111400186B (en) | Performance test method and system | |
| CN105893340A (en) | Efficient data processing system used during detection and analysis | |
| CN103261883B (en) | Automatically control the separation for quantitative sample analysis and the control system of multiple equipment of detection process | |
| US11003633B2 (en) | Analysis information management system | |
| CN101902505A (en) | Distributed DNS inquiry log real-time statistic device and method thereof | |
| CN106530121B (en) | Method and system for detecting safety protection compliance of power monitoring system | |
| CN106443032A (en) | Data acquisition method and device | |
| CN111459944A (en) | MR data storage method, device, server and storage medium | |
| CN109582286B (en) | Freemarker technology-based data normalization verification method and device | |
| CN110674083A (en) | Workflow migration method, device, equipment and computer readable storage medium | |
| CN104123397A (en) | Automatic test device and method for Web page | |
| CN113821554B (en) | Method for realizing heterogeneous database data acquisition | |
| CN111309791A (en) | Automatic data acquisition method for detection instrument | |
| CN109359707B (en) | Method and device for processing rock and soil sample information, computer equipment and storage medium | |
| US20190056361A1 (en) | Analysis information management system | |
| CN103488712B (en) | A kind of automated testing method and system | |
| JP2021140430A (en) | Database migration method, database migration system, and database migration program | |
| CN102880926B (en) | Business information data auditing method and device | |
| CN116186147A (en) | Intelligent classification experimental data collection and storage system | |
| CN109447844A (en) | A kind of management method of electronization test report | |
| CN108897877A (en) | Big data analysis tool and method based on EXCEL | |
| CN113253685A (en) | Industrial data acquisition method, device, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |