CN106599261A - Processing method for detection result data - Google Patents
Processing method for detection result data Download PDFInfo
- Publication number
- CN106599261A CN106599261A CN201611192809.4A CN201611192809A CN106599261A CN 106599261 A CN106599261 A CN 106599261A CN 201611192809 A CN201611192809 A CN 201611192809A CN 106599261 A CN106599261 A CN 106599261A
- Authority
- CN
- China
- Prior art keywords
- data
- item
- information
- row
- sample
- 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.)
- Pending
Links
Classifications
-
- 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/11—File system administration, e.g. details of archiving or snapshots
- G06F16/116—Details of conversion of file system types or formats
Abstract
The invention discloses a processing method for detection result data, and belongs to the technical field of data processing. The method comprises the following steps of: obtaining an input data template selection instruction, and calling a pre-stored corresponding data template according to the data template selection instruction; obtaining an input detection report selection instruction, and according to the detection report selection instruction, calling a pre-stored corresponding detection report; according to data items listed in the data template, according to a preset information item extraction way, extracting an information item corresponding to each data item in the detection report; and importing the information item into the data item corresponding to the data template, and forming formatting detection data. By use of the method, all detection instruments which can generate a formatting detection report can realize the automatic extraction of the detection data, and the efficiency, the reliability and the safety of detection data transferring can be improved.
Description
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of processing method of testing result data.
Background technology
Lab managers are in order to ensure the safety of this test in laboratory data, confidentiality, stringency, accuracy and can
Traceability, continually introduces advanced Design of Laboratory Management System (LIMS) as the Treatment Analysis and other things of test in laboratory data
The management of business property, how safe efficient the testing result of wherein testing equipment output is, accurately and effectively enters Management System Data
Kucheng is the emphasis of LIMS management systems research and development.At present the way of main flow mainly has 3 kinds, is respectively：
1st, buy or freely obtain each equipment vendors' data communication protocol, by working out special interface on each equipment
The mode of program directly obtains data and imports third party database from device databases.
2nd, examining report is printed as into PDF or XML format by way of virtual printer is set in Facility Control Terminal
Report, TXT documents are converted into by third party's converse routine by PDF or XML file in system background, then specific from this
The data of needs are extracted in TXT documents.Reporting format or the space of a whole page of this pattern based on particular device output is relatively fixed, program
Member can work out specific data converter and take out the result in report individually for the equipment.
3rd, friendly equipment vendors provide the TXT report output patterns that easily format, can be by Third party system
TXT data are imported LIMS systems by the mode of establishment interface routine.
But these ways have the disadvantage that respectively：
1st technical disadvantages have：A, manufacturer's communications protocol are difficult to obtain easily, and interface routine is because of manufacturer and unit type
Difference need to orient establishment, and cost and stability exist greatly uncertain.The sample item title of the detection that b, equipment are exported is not true
Surely cause data to adopt process and produce third-party application system detectio parameter setting difficulty.
2nd technical disadvantages have：A, inspection software upgrading or device variations will cause again customize switching software.B, set
The sample item title of the detection of standby output is uncertain to be caused data to adopt process and produce third-party application system detectio parameter to set
Put difficulty.
3rd technical disadvantages have：Some manufacturers or equipment do not provide this service.
The content of the invention
The present invention proposes a kind of processing method of testing result data, to the detection for solving laboratory testing equipment output
As a result management system database problem encountered is imported.
Embodiments provide a kind of processing method of testing result data.In order to some for the embodiment for disclosing
Aspect has a basic understanding, shown below is simple summary.The summarized section is not extensive overview, nor to determine
Key/critical component describes the protection domain of these embodiments.Its sole purpose is presented with simple form
Concept, in this, as the preamble of following detailed description.
A kind of processing method of testing result data is embodiments provided, including：
The data template selection instruction of input is obtained, is transferred according to the data template selection instruction prestoring, corresponding
Data template；
The examining report selection instruction of input is obtained, is transferred according to the examining report selection instruction prestoring, corresponding
Examining report；
According to the data items listed in the data template, according to default item of information extracting mode, from the detection
The corresponding item of information of the data items is extracted in report；
Described information item is imported in the corresponding data project of the data template, the detection data of form format.
In one embodiment, the data template includes the data template for entry examining report, the data
Template includes multiple lines and multiple rows, and per a line, one sample item of correspondence, every a line are divided into multi-column data project, in multi-column data project
Including at least sample unique mark position, sample item title, testing result, measurement unit, minimum detectable concentration and sample item
Another name；
The examining report includes entry examining report；
It is described according to the data items listed in the data template, according to default item of information extracting mode, from described
The corresponding item of information of the data items is extracted in examining report, including：
Configuration-direct of the user to the sample item another name in every a line of the data template is obtained, according to the configuration
Sample item another name in every a line of the instruction configuration data template；The configuration-direct has another name called including the sample item
Value；
The entry examining report is processed as into the single-row data of multirow and is shown；There is bag in these multirow data
Multirow containing testing result information, sample item another name, testing result and an other information item is included per data line, often
Separated with default list separator between different items of information in data line；
Obtain the row of presupposed information item in the single-row data of the multirow that user pre-sets or user's current setting
Position information, the presupposed information item row position information include sample item another name row position information, the row position information of testing result,
Any one row position or multiple row positions information in total column number information of examining report data row；
Sample unique mark is first extracted from the report head of the entry examining report；
Sample item another name in data template described in poll, is asking to a sample item in the data template every time
After mesh another name：Line by line the single-row data of multirow described in poll, the sample item in the single-row data of the multirow is had another name called and this time
Sample item another name in the data template ask is matched, and from the single-row data of the multirow, is determined and this time
The data line of the sample item another name matching in the data template ask, believes according to the row position of the presupposed information item
Breath, from the respective column position of the row data item of information is extracted；
It is described described information item to be imported in the corresponding data project of the data template, the detection number of form format
According to, including：
The item of information that will be extracted from every data line of the single-row data of the multirow, imports the right of the data template
In the corresponding data project of the data line that should be matched, while importing the detection data of sample unique mark form format.
In one embodiment, the row position information according to the presupposed information item, from the respective column position of the row data
On extract item of information, including：
If the total columns number of the examining report data row of the data line being presently processing, gets than described
The few N of total columns of examining report data row in the row position information of presupposed information item, then：
It is determined that the row bits number of the testing result of the data line being presently processing is：The presupposed information for getting
The row digit of testing result deducts N in the row position information of item.
In one embodiment, the data template includes the data template for individual event mesh examining report, the data
Template includes single file multiple row, and row correspondence one sample item, the row are divided into multi-column data project, in multi-column data project at least
Comprising sample unique mark position, sample item title, testing result, measurement unit and minimum detectable concentration；
The examining report includes individual event mesh examining report；
It is described according to the data items listed in the data template, according to default item of information extracting mode, from described
The corresponding item of information of the data items is extracted in examining report, including：
Obtain the sample unique mark received by sample unique mark setting area；Wherein, when the sample unique mark
Setting area shows that the multiple sample unique marks that may be included in individual event mesh examining report are selected for user to select during area, obtains
Take selected sample unique mark；When the sample unique mark setting area is typing area, obtains user and record in typing area
The multiple sample unique marks for entering；
The individual event mesh examining report is processed into into the single-row data of multirow and is shown；Include sample per data line
Unique mark, sample item title, a testing result and other information item, use between the different items of information in every data line
Default list separator separates；
Sample unique mark received by poll sample unique mark setting area, uniquely marks in inquiry every time to a sample
After knowledge：Line by line the single-row data of multirow described in poll, the sample unique mark in the single-row data of the multirow and this inquiry are arrived
The sample unique mark that receives of sample unique mark setting area matched, from the single-row data of the multirow, determine
With this inquiry to the data line that matches of the sample unique mark that receives of sample unique mark setting area；
Obtain the row position information of testing result in the single-row data of the multirow of input；
From the single-row data of the multirow, according to sample mark setting area poll sample uniquely identified order and aforementioned
The result matched somebody with somebody, line by line according to the row position information and information extracting method of the testing result, above carries from the respective column position of every a line
Take out testing result；
Described information item is imported in the corresponding data project of the data template, the detection data of form format, bag
Include：
Sample unique mark received by poll sample unique mark setting area, uniquely marks in inquiry every time to a sample
After knowledge：Simultaneously automatically data receiver area according to the data template the newly-built a line of form, will be from the single-row number of the multirow
According to Corresponding matching data line in the item of information that extracts, import the correspondence of the newly-built data line in the data receiver area
In data items, while the sample unique mark that this inquiry is arrived is imported in the sample unique mark position of the newly-built data line,
The detection data of form format.
In one embodiment, methods described also includes：
When also at least other projects of string are included in the multi-column data project of every data line of the data template, obtain
Take the corresponding item of information of described other projects of at least string of user input；
The item of information that will be extracted from every data line of the single-row data of the multirow, imports the data template
Corresponding matching data line corresponding data project in, while import sample unique mark form format detection number
According to, including：
By described in the item of information extracted from every data line of the single-row data of the multirow and the user input
At least the corresponding item of information of other projects of string, imports the corresponding data item of the data line of the Corresponding matching of the data template
In mesh, while importing the detection data of sample unique mark form format.
In one embodiment, methods described also includes：
The data template is shown in the template for displaying region of data window；
The examining report is shown in the examining report viewing area of the data window and forbids changing the detection
Report；
The detection data of the formatting is shown in the formatting detection data viewing area of the data window.
It is in one embodiment, described to extract from the examining report after the corresponding item of information of the data items,
Methods described also includes：
Whether the data form for judging described information item meets the call format of the data template；
When not meeting, the Data Format Transform by described information item is the form of the data template requirement.
In one embodiment, after the detection data of the form format, methods described also includes：
The detection data for forbidding the formatting is edited.
In one embodiment, in the single-row data from the multirow, the data mould arrived with this inquiry is determined
The data line of the sample item another name matching in plate, according to the row position information of the presupposed information item, from the phase of the row data
Item of information is extracted on Ying Liewei, including：
For the every data line in the single-row data of the multirow：Using character string technology of identification, in identification the row data
Default list separator, the default list separator include space；
The character string of default list separator one or both sides is defined as into continuation character string；
Each continuation character string position is defined as into the row position of the row data；
Item of information continuation character string on each row position being defined as on the row position.
In one embodiment, it is described according to the data items listed in the data template, according to default item of information
Extracting mode, extracts the corresponding item of information of the data items from the examining report, including：
Using speech recognition, title identification is carried out to the item of information in the examining report；
According to title recognition result, the item of information matched with the data items in the examining report is determined；
The item of information that will be matched with the data items in the examining report, is defined as the corresponding letter of the data items
Breath item；
The corresponding item of information of the data items is extracted from the examining report.
Technical scheme provided in an embodiment of the present invention can include following beneficial effect：
When the 1st, the examining report that testing equipment is exported being imported to into third party database, the built-in report of testing equipment output
Form (such as TXT, EXCE, word, pdf) is without the need for any format conversion；
When the 2nd, the examining report that testing equipment is exported being imported to into third party database, do not affected by report space of a whole page change,
When system upgrade and built-in report template change without the need for special programming；
When the 3rd, the examining report that testing equipment is exported being imported to into third party database, reviewer can voluntarily according to report
Content and structure dynamics adjustment data lead-in mode.
The present invention is adapted to the process of the output file of most of instruments, including to the different-formats such as txt, Excel text
The process of part, moreover it is possible to entry examining report and individual event mesh examining report are adapted to by stencil design.Mould is imported by default
Plate and preset data column information mode, is adapted to the form of different instrument output reports, so as to convenient receive data
It is believed that breath, realizes the versatility of data introducting interface, secondary development can be independent of and realize examining report and third party's number
According to the slitless connection in storehouse, convenience, safety and reliability that data are imported are improved.
It should be appreciated that the general description of the above and detailed description hereinafter are only exemplary and explanatory, not
The present invention can be limited.
Description of the drawings
Accompanying drawing herein is merged in description and constitutes the part of this specification, shows the enforcement for meeting the present invention
Example, and be used to explain the principle of the present invention together with description.
Fig. 1 is a kind of flow chart of the processing method of the testing result data according to an exemplary embodiment；
Fig. 2 is a kind of process surface chart of detection data report according to an exemplary embodiment；
Fig. 3 is a kind of process surface chart of detection data report according to an exemplary embodiment；
Fig. 4 is a kind of process surface chart of detection data report according to an exemplary embodiment.
Specific embodiment
The following description and drawings fully illustrate specific embodiments of the present invention, to enable those skilled in the art to
Put into practice them.Embodiment only represents possible change.Unless explicitly requested, otherwise single components and functionality is optional, and
And the order for operating can change.The part of some embodiments and feature can be included in or replace other embodiments
Part and feature.The scope of embodiment of the present invention includes the gamut of claims, and the institute of claims
There is obtainable equivalent.Herein, each embodiment individually or generally can be represented with term " invention " that this is only
It is merely for convenience, and if in fact disclosing the invention more than, be not meant to automatically limit the scope of the application
For any single invention or inventive concept.Herein, such as first and second or the like relational terms are used only for one
Entity or operation make a distinction with another entity or operation, and do not require or imply presence between these entities or operation
Any actual relation or order.And, term " including ", "comprising" or its any other variant are intended to non-exclusive
Property include so that a series of process, method or equipment including key elements not only include those key elements, but also including
Other key elements being not expressly set out.Herein each embodiment is described by the way of progressive, and each embodiment is stressed
Be all difference with other embodiment, between each embodiment identical similar portion mutually referring to.For enforcement
It is corresponding with part disclosed in embodiment due to it for example disclosed structure, product etc., so fairly simple, the phase of description
Part is closed referring to method part illustration.
Fig. 1 is a kind of flow chart of the processing method of the testing result data according to an exemplary embodiment；According to
The embodiment of the present invention, comprises the steps：
Step 101, the data template selection instruction for obtaining input, transfer according to the data template selection instruction and prestore
, corresponding data template；
Step 102, the examining report selection instruction for obtaining input, transfer according to the examining report selection instruction and prestore
, corresponding examining report；
Step 103, according to the data items listed in the data template, according to default item of information extracting mode, from
The corresponding item of information of the data items is extracted in the examining report；
Step 104, described information item is imported in the corresponding data project of the data template, the detection of form format
Data.
In the embodiment of the present invention, according to the number of detected sample item included in examining report, by detection report
Announcement is divided into two classes, is respectively entry examining report and individual event mesh examining report.Wherein, entry examining report refers to detection report
At least two testing results of multiple sample items are included in announcement, individual event mesh examining report is referred in examining report and only included
One testing result of multiple sample items.
In one embodiment, the examining report of different-format can be uniformly processed into unification by the embodiment of the present invention in advance
The examining report of the file of form, such as Excel, Word format, can all be processed into txt forms.
Illustrate the inventive method respectively for entry examining report, the process side of individual event mesh examining report separately below
Formula：
For the processing mode of entry examining report：
In one embodiment, as shown in Fig. 2 the indication of labelling 100 is interface, the examining report is detected including entry
Report, such as includes " lithium ", " beryllium ", the sample item of " boron ".
In one embodiment, the data template includes the data template for entry examining report, the data
Template includes multiple lines and multiple rows, and per a line, one sample item of correspondence, every a line are divided into multi-column data project, in multi-column data project
Including at least sample unique mark position (column data is sky, waits the sample in examining report to be imported to identify), sample item name
Title, testing result, measurement unit, minimum detectable concentration and sample item another name.Wherein, sample item another name is in examining report
Sample item title, to dock examining report in set sample item title and the sample item title being actually needed.
In one embodiment, as shown in Fig. 2 every a line of data template corresponds to a sample item, three rows are right respectively
The sample item answered is：" lithium " " beryllium " " boron ", per a line multi-column data project is divided into, and such as can be divided into：Sample unique mark, such as
" sample number into spectrum AA "；Sample item title, such as " lithium "；Testing result, such as " a "；Measurement unit, such as " mg/L "；Minimum detection is dense
Degree, such as " 0.05 " and sample item another name " Li ".Wherein, sample item another name " Li " is the project name in examining report
" Li ", with the data of " lithium " in this recognition detection report, needing to extract.
Above-mentioned steps 103 are " according to the data items listed in the data template, according to default item of information extraction side
Formula, extracts the corresponding item of information of the data items from the examining report ", step A1-A6 can be embodied as：
The configuration-direct of step A1, acquisition user to the sample item another name in every a line of the data template, it is described
Configuration-direct includes the value of sample item another name；Sample in every a line of the data template is configured according to the configuration-direct
Product project has another name called；As shown in Fig. 2 configuration of the user for obtaining to the sample item another name in every a line of the data template refers to
Order be respectively " Li ", " Be ", " B ", just can be respectively configured in every a line of the data template sample item another name be " Li ",
“Be”、“B”。
Step A2, the entry examining report is processed as the single-row data of multirow and is shown；These multirow data
It is middle to there is the multirow comprising testing result information, include per data line sample item have another name called, testing result and other
Item of information, is separated per between the different items of information in data line with default list separator, separator can for space or other
List separator.
Letter is preset in the single-row data of the multirow that step A3, acquisition user pre-set or user's current setting
The row position information of breath item, the row position information of the presupposed information item includes row position information, the testing result of sample item another name
Any one row position or multiple row positions information in row position information, total column number information of examining report data row, this row position information is used
Which arrange in the data corresponding with presupposed information item are positioned in examining report.
These row position information can pre-set in data template, it is also possible to interim setting, be easy to data processing people
Member adjusts at random data acquisition modes according to examining report practical situation.For example, the data in itself examining report from
Row defines the value of either rank or any multi-column data project in data to be used by template, such as sample item another name etc.,
To sample item name column position, testing result row position, total data columns can also be self-defined, such as by which row in examining report
Sample item title is defined as, which row is defined as testing result, and need to read altogether to which column data etc..Such as Fig. 2
Shown, the project name row position (i.e. ingredient names row position) of user input is the 1st row, testing result row position (i.e. testing result number
According to row position) arrange for the 6th, total columns (i.e. the total columns of object information) of examining report data row is 10 row.
Step A4, first the extraction sample unique mark from the report head of the entry examining report.
Sample item another name in step A5, polling data template, is asking to a sample item in data template every time
After mesh another name：Single-row data of poll multirow line by line, the number that the sample item another name in the single-row data of multirow is arrived with this inquiry
Matched according to the sample item another name in template, from the single-row data of multirow, in determining the data template ask with this time
Sample item another name matching data line, according to the row position information of presupposed information item, from the respective column position of the row data
Extract item of information.As shown in Fig. 2 according to the row position information of default testing result, extracting corresponding measurement result " a ".
Abovementioned steps 104 " described information item is imported in the corresponding data project of the data template, form format
Detection data ", can be embodied as：
The item of information that will be extracted from every data line of the single-row data of multirow, imports the Corresponding matching of data template
In the corresponding data project of data line, while importing the detection data of sample unique mark form format.
By the implementation, according to format design corresponding template parameter (sample item title, the sample of examining report
Project another name, sample item name column position, testing result row position, total data columns etc.), can be setting in effectively solving inspection software
The fixed project name and data form problem inconsistent with the project name and data form being actually needed.
In one embodiment, sometimes in examining report the row position information of the data of certain a line with it is aforementioned get it is default
The row position information of item of information is inconsistent, now, for the accuracy for ensureing to extract item of information in examining report, abovementioned steps A5
In " according to the row position information of presupposed information item, from the respective column position of the row data item of information is extracted ", can be embodied as：
If total columns number of the examining report data row of the data line being presently processing, more default than what is got
The few N of total columns of examining report data row in the row position information of item of information, then：
It is determined that the row bits number of the testing result of the data line being presently processing is：The presupposed information item for getting
Total columns of examining report data row deducts N in row position information.
For example, total columns number of the examining report data row of the data line for processing is 8, more default than what is got
Total columns 10 few 2 of examining report data row in the row position information of item of information, it is determined that the data line being presently processing
The row bits number of testing result is that the row digit for arranging testing result in the information of position of the presupposed information item for getting deducts 2.
For the processing mode of individual event mesh examining report：
In one embodiment, as shown in figure 3, the indication of labelling 200 is interface, the information of guide-in window is processed into multirow
Columnar version, can extract uniline message and process in the way of character string by endless form.
In one embodiment, data template includes the data template for individual event mesh examining report, the data template
Including single file multiple row, row correspondence one sample item, the row are divided into multi-column data project, include at least in multi-column data project
Sample unique mark position, sample item title, testing result, measurement unit and minimum detectable concentration.As shown in figure 3, per a line
It is divided into multi-column data project, has sample unique mark position, sample item title, testing result, measurement unit and minimum detection dense
Degree, sample number into spectrum, project name, method foundation etc..
In one embodiment, step 103 " it is described according to the data items listed in the data template, according to default
Item of information extracting mode, the corresponding item of information of the data items is extracted from the examining report ", step can be embodied as
B1-B5：
Sample unique mark received by step B1, acquisition sample unique mark setting area；Wherein, when sample is uniquely marked
Setting area is known to select during area, show that sample unique mark is selected for user in individual event mesh examining report, obtains selected sample
Product unique mark；When sample unique mark setting area is typing area, sample unique mark of the user in the typing of typing area is obtained；
Step B2, individual event mesh examining report is processed into the single-row data of multirow and is shown；Include per data line
Sample unique mark, sample item title, a testing result and other information item, per the different items of information in data line it
Between separated with default list separator；
Sample unique mark received by step B3, poll sample unique mark setting area, is asking to a sample every time
After product unique mark：Line by line the single-row data of poll multirow, the sample unique mark in the single-row data of multirow and this inquiry are arrived
The sample unique mark that receives of sample unique mark setting area matched, from the single-row data of multirow, determine and this
The data line of the sample unique mark matching that the secondary sample unique mark setting area ask receives；
Step B4, the row position information for obtaining testing result in the single-row data of multirow being input into；
Step B5, from the single-row data of multirow, according to sample mark setting area poll sample uniquely identified order and front
The result of matching is stated, line by line according to the row position information and information extracting method of testing result, is above carried from the respective column position of every a line
Take out testing result.
For example, as shown in figure 3, sample unique mark select area show " WJ2016-10-54 ", " WJ2016-10-59 ",
" WJ2016-10-60 ", " WJ2016-10-61 " etc. sample unique mark is selected for user；Acquisition " WJ2016-10-60 ",
The sample unique mark that " WJ2016-10-61 " etc. user selects.Examining report is processed into into the single-row data of multirow and is shown
Show, sample unique mark such as " WJ2016-09-38 ", sample item title such as " cyanide ", an inspection are included per data line
Survey result as "<0.005 " and other information item such as detects the date, per data line in different items of information between with default point
Separate every symbol.The sample unique mark that poll is easily selected by a user, is asking every time to after a sample unique mark：Take turns line by line
Ask the single-row data of the multirow, by the sample unique mark in the single-row data of the multirow and this inquiry to sample uniquely mark
Know the sample unique mark that receives of setting area to be matched, from the single-row data of the multirow, determine and arrived with this inquiry
The data line of the sample unique mark matching that sample unique mark setting area receives.As shown in figure 3, obtaining the described of input
The row position information of testing result in the single-row data of multirow；Such as the 7th row.From the single-row data of the multirow, set according to sample mark
The result of area's poll sample uniquely identified order and aforementioned matching is put, line by line according to the row position information and letter of the testing result
Breath extracting method, from the respective column position of every a line testing result is extracted.
Correspondingly, step 104 " imports described information item in the corresponding data project of the data template, form format
The detection data of change ", can be embodied as：
Sample unique mark received by poll sample unique mark setting area, uniquely marks in inquiry every time to a sample
After knowledge：Simultaneously automatically data receiver area according to data template the newly-built a line of form, by from the correspondence of the single-row data of multirow
The item of information extracted in the data line of matching, in importing the corresponding data project of the newly-built data line in data receiver area,
Simultaneously the sample unique mark that this inquiry is arrived is imported in the sample unique mark position of the newly-built data line, form format
Detection data.
In one embodiment, methods described also includes：
When also at least other projects of string are included in the multi-column data project of every data line of the data template, obtain
The corresponding item of information of described other projects of at least string of user input is taken, as shown in figure 4, each line number of the data template
According to multi-column data project in also include " testing staff ", " device numbering " project, obtain its corresponding item of information, such as " appoint
Space ", " JL001 ".
" item of information that will be extracted from every data line of the single-row data of multirow imports data template to abovementioned steps
In the corresponding data project of the data line of Corresponding matching, while importing the detection data of sample unique mark form format "
Can be embodied as：
By at least string of the item of information extracted from every data line of the single-row data of multirow and user input other
The corresponding item of information of project, in the corresponding data project of the data line for importing the Corresponding matching of data template, while importing sample
The detection data of product unique mark form format.
As shown in figure 4, the indication of labelling 300 is interface, will extract from every data line of the single-row data of the multirow
Item of information as " 0.05 ", the corresponding item of information of described other projects of at least string of " a " and the user input as " appoint
Space ", " JL001 ", in the corresponding data project of the data line for importing the Corresponding matching of the data template, form format
Detection data, as shown in Figure 4.
In one embodiment, as shown in figure 4, methods described also includes：
The data template is shown in the template for displaying region of data window；
The examining report is shown in the examining report viewing area of the data window and forbids changing the detection
Report；Or in the data window do not show examining report；With the safety of certificate of guarantee, reliability；
The detection data of the formatting is shown in the formatting detection data viewing area of the data window.
In one embodiment, after the detection data of form format, the detection data for forbidding the formatting is compiled
Volume, preventing the maloperation of operator causes corrupt data, ensures safety, the reliability of data.
It is in one embodiment, described to extract from the examining report after the corresponding item of information of the data items,
Methods described also includes：
Whether the data form for judging described information item meets the call format of the data template, when not meeting, will
The Data Format Transform of described information item is the form of the data template requirement.Call format such as data template is floating-point lattice
Formula, and the data form of described information item is scientific notation, then be converted into floating-point format.
In one embodiment, in order to realize that more intelligence is automatically processed, raising testing result processing speed, aforementioned step
Suddenly " from the single-row data of multirow, the data line that the another name of the sample item in the data template ask with this time is matched is determined,
According to the row position information of presupposed information item, from the respective column position of the row data item of information is extracted ", can be embodied as：
For the every data line in the single-row data of multirow：Using character string technology of identification, recognize pre- in the row data
If list separator, default list separator is including space etc.；
The character string of default list separator one or both sides is defined as into continuation character string；Multiple separators continuously occur
When, it is considered as a separator.
Each continuation character string position is defined as into the row position of the row data.By the continuation character string on each row position
The item of information being defined as on the row position.
In one embodiment, it is empty as shown in figure 4, the default list separator in identification " B 9 26.66762 " is space
Character string " B " between data or branch between lattice, " 9 ", " 26.66762 " are defined as continuation character string.“B 9
26.66762 " continuation character string " B ", " 9 ", the row position of " 26.66762 " are respectively 1,2,3 determined by, by " B ", " 9 ",
" 26.66762 " are defined as the item of information on 1,2,3 row positions, wherein the as described acquired sample item corresponding to " B " is other
Claim.
In one embodiment, in order to realize that more intelligence is automatically processed, raising testing result processing speed, aforementioned step
Rapid 103 " according to the data items listed in data template, according to default item of information extracting mode, extract from examining report
The corresponding item of information of data items ", can be embodied as：
Using speech recognition, title identification is carried out to the item of information in examining report；Language identification can be passed through
Mode replace input through keyboard.
According to title recognition result, the item of information matched with data items in examining report is determined；
The item of information that will be matched with data items in examining report, is defined as the corresponding item of information of data items；
The corresponding item of information of data items is extracted from examining report.
The present invention is adapted to the process of the output file of most of instruments, including to the different-formats such as txt, Excel text
The process of part, moreover it is possible to entry examining report and individual event mesh examining report are adapted to by stencil design.Mould is imported by default
Plate and preset data column information mode, is adapted to the form of different instrument output reports, so as to convenient receive data
It is believed that breath, realizes the versatility of data introducting interface, secondary development can be independent of and realize examining report and third party's number
According to the slitless connection in storehouse, convenience, safety and reliability that data are imported are improved.
It should be appreciated that the flow process and structure for being described above and being shown in the drawings is the invention is not limited in,
And can without departing from the scope carry out various modifications and changes.The scope of the present invention is only limited by appended claim
System.
Claims (10)
1. a kind of processing method of testing result data, it is characterised in that include：
The data template selection instruction of input is obtained, data prestore, corresponding are transferred according to the data template selection instruction
Template；
The examining report selection instruction of input is obtained, detection prestore, corresponding is transferred according to the examining report selection instruction
Report；
According to the data items listed in the data template, according to default item of information extracting mode, from the examining report
It is middle to extract the corresponding item of information of the data items；
Described information item is imported in the corresponding data project of the data template, the detection data of form format.
2. the method for claim 1, it is characterised in that
The data template includes the data template for entry examining report, and the data template includes multiple lines and multiple rows, often
A line one sample item of correspondence, every a line are divided into multi-column data project, uniquely mark including at least sample in multi-column data project
Know position, sample item title, testing result, measurement unit, minimum detectable concentration and sample item another name；
The examining report includes entry examining report；
It is described according to the data items listed in the data template, according to default item of information extracting mode, from the detection
The corresponding item of information of the data items is extracted in report, including：
Configuration-direct of the user to the sample item another name in every a line of the data template is obtained, according to the configuration-direct
Configure the sample item another name in every a line of the data template；The configuration-direct includes taking for sample item another name
Value；
The entry examining report is processed as into the single-row data of multirow and is shown；Exist comprising inspection in these multirow data
The multirow of object information is surveyed, sample item another name, testing result and an other information item is included per data line, per a line
Separated with default list separator between different items of information in data；
Obtain the row position letter of presupposed information item in the single-row data of the multirow that user pre-sets or user's current setting
Breath, the row position information of the presupposed information item includes row position information, the row position information of testing result, the detection of sample item another name
Any one row position or multiple row positions information in total column number information of data reporting row；
Sample unique mark is first extracted from the report head of the entry examining report；
Sample item another name in data template described in poll, is asking every time other to a sample item in the data template
After referred to as：Line by line the single-row data of multirow described in poll, the sample item another name in the single-row data of the multirow is arrived with this inquiry
The data template in sample item another name matched, from the single-row data of the multirow, determine and arrived with this inquiry
The data template in sample item another name matching data line, according to the row position information of the presupposed information item, from
Item of information is extracted on the respective column position of the row data；
It is described described information item to be imported in the corresponding data project of the data template, the detection data of form format, bag
Include：
The item of information that will be extracted from every data line of the single-row data of the multirow, imports the correspondence of the data template
In the corresponding data project of the data line matched somebody with somebody, while importing the detection data of sample unique mark form format.
3. method as claimed in claim 2, it is characterised in that
The row position information according to the presupposed information item, from the respective column position of the row data item of information is extracted, including：
If total columns number of the examining report data row of the data line being presently processing, than it is described get it is default
The few N of total columns of examining report data row in the row position information of item of information, then：
It is determined that the row bits number of the testing result of the data line being presently processing is：The presupposed information item for getting
The row digit of testing result deducts N in row position information.
4. the method for claim 1, it is characterised in that
The data template includes the data template for individual event mesh examining report, and the data template includes single file multiple row, should
Row correspondence one sample item, the row be divided into multi-column data project, in multi-column data project including at least sample unique mark position,
Sample item title, testing result, measurement unit and minimum detectable concentration；
The examining report includes individual event mesh examining report；
It is described according to the data items listed in the data template, according to default item of information extracting mode, from the detection
The corresponding item of information of the data items is extracted in report, including：
Obtain the sample unique mark received by sample unique mark setting area；Wherein, when the sample unique mark is arranged
Area shows that the multiple sample unique marks that may be included in individual event mesh examining report are selected for user to select during area, obtains quilt
The sample unique mark of selection；When the sample unique mark setting area is typing area, user is obtained in the typing of typing area
Multiple sample unique marks；
The individual event mesh examining report is processed into into the single-row data of multirow and is shown；Include that sample is unique per data line
Mark, sample item title, a testing result and other information item, use default between the different items of information in every data line
List separator separates；
Sample unique mark received by poll sample unique mark setting area, ask every time to sample unique mark it
Afterwards：Single-row data of multirow described in poll line by line, the sample that the sample unique mark in the single-row data of the multirow and this inquiry are arrived
The sample unique mark that product unique mark setting area receives is matched, and from the single-row data of the multirow, is determined and this
The data line of the sample unique mark matching that the secondary sample unique mark setting area ask receives；
Obtain the row position information of testing result in the single-row data of the multirow of input；
From the single-row data of the multirow, according to sample setting area poll sample uniquely identified order and aforementioned matching are identified
As a result, extract from the respective column position of every a line according to the row position information and information extracting method of the testing result line by line
Testing result；
Described information item is imported in the corresponding data project of the data template, the detection data of form format, including：
Sample unique mark received by poll sample unique mark setting area, ask every time to sample unique mark it
Afterwards：Simultaneously automatically data receiver area according to the data template the newly-built a line of form, by from the single-row data of the multirow
The item of information extracted in the data line of Corresponding matching, imports the corresponding data of the newly-built data line in the data receiver area
In project, while importing the sample unique mark that this inquiry is arrived in the sample unique mark position of the newly-built data line, formed
The detection data of formatting.
5. method as claimed in claim 2 or claim 3, it is characterised in that methods described also includes：
When also at least other projects of string are included in the multi-column data project of every data line of the data template, obtain and use
The corresponding item of information of described other projects of at least string of family input；
The item of information that will be extracted from every data line of the single-row data of the multirow, imports the right of the data template
In the corresponding data project of the data line that should be matched, while the detection data of sample unique mark form format is imported, bag
Include：
By described in the item of information extracted from every data line of the single-row data of the multirow and the user input at least
The corresponding item of information of other projects of string, imports the corresponding data project of the data line of the Corresponding matching of the data template
In, while importing the detection data of sample unique mark form format.
6. the method as described in arbitrary in claims 1 to 3, it is characterised in that methods described also includes：
The data template is shown in the template for displaying region of data window；
The examining report is shown in the examining report viewing area of the data window and forbids changing the examining report；
The detection data of the formatting is shown in the formatting detection data viewing area of the data window.
7. the method for claim 1, it is characterised in that
Described to extract from the examining report after the corresponding item of information of the data items, methods described also includes：
Whether the data form for judging described information item meets the call format of the data template；
When not meeting, the Data Format Transform by described information item is the form of the data template requirement.
8. the method for claim 1, it is characterised in that after the detection data of the form format, methods described
Also include：
The detection data for forbidding the formatting is edited.
9. method as claimed in claim 2, it is characterised in that
In the single-row data from the multirow, the sample item another name in the data template ask with this time is determined
The data line matched somebody with somebody, according to the row position information of the presupposed information item, from the respective column position of the row data item of information is extracted,
Including：
For the every data line in the single-row data of the multirow：Using character string technology of identification, recognize pre- in the row data
If list separator, the default list separator includes space；
The character string of default list separator one or both sides is defined as into continuation character string；
Each continuation character string position is defined as into the row position of the row data；
Item of information continuation character string on each row position being defined as on the row position.
10. the method for claim 1, it is characterised in that
It is described according to the data items listed in the data template, according to default item of information extracting mode, from the detection
The corresponding item of information of the data items is extracted in report, including：
Using speech recognition, title identification is carried out to the item of information in the examining report；
According to title recognition result, the item of information matched with the data items in the examining report is determined；
The item of information that will be matched with the data items in the examining report, is defined as the corresponding information of the data items
；
The corresponding item of information of the data items is extracted from the examining report.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611192809.4A CN106599261A (en) | 2016-12-21 | 2016-12-21 | Processing method for detection result data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611192809.4A CN106599261A (en) | 2016-12-21 | 2016-12-21 | Processing method for detection result data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106599261A true CN106599261A (en) | 2017-04-26 |
Family
ID=58602354
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611192809.4A Pending CN106599261A (en) | 2016-12-21 | 2016-12-21 | Processing method for detection result data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106599261A (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107845033A (en) * | 2017-11-08 | 2018-03-27 | 上海壹账通金融科技有限公司 | Air control report-generating method, device, equipment and computer-readable recording medium |
| CN108536659A (en) * | 2018-03-26 | 2018-09-14 | 鹤山市明鹤电力建设有限公司 | A kind of automatic processing method and its device based on insulating tool test report |
| CN108959213A (en) * | 2017-05-22 | 2018-12-07 | 宁波江丰电子材料股份有限公司 | Generation method and device, computer-readable medium, the terminal of product inspection report |
| CN109346142A (en) * | 2018-09-30 | 2019-02-15 | 广州金域医学检验中心有限公司 | Comprehensive report generation method, device, terminal device and readable storage medium storing program for executing |
| CN109446498A (en) * | 2018-09-12 | 2019-03-08 | 杭州优工品科技有限公司 | Components inspection report template data processing method and processing device |
| CN109614430A (en) * | 2018-12-05 | 2019-04-12 | 云南大学 | Configurable data acquisition and data verification system and method based on WLAN |
| CN109815109A (en) * | 2018-12-11 | 2019-05-28 | 口碑(上海)信息技术有限公司 | Data pattern alteration detection method, apparatus, equipment and readable storage medium storing program for executing |
| CN109859808A (en) * | 2018-07-25 | 2019-06-07 | 武汉心络科技有限公司 | A kind of medical data acquisition method and system |
| WO2020253151A1 (en) * | 2019-06-19 | 2020-12-24 | 飞依诺科技(苏州)有限公司 | Automatic matching method and system for ultrasonic diagnosis report |
| CN112580321A (en) * | 2020-12-29 | 2021-03-30 | 山东爱新卓尔智慧医疗技术有限公司 | Inspection report automatic generation method and system based on dual-model designer |
| CN113312881A (en) * | 2021-05-06 | 2021-08-27 | 上海移远通信技术股份有限公司 | Frequency band information conversion method and device, electronic equipment and computer storage medium |
| CN113808696A (en) * | 2020-06-15 | 2021-12-17 | 飞依诺科技(苏州)有限公司 | Ultrasonic data processing method and device, computer equipment and storage medium |
| WO2024007481A1 (en) * | 2022-07-06 | 2024-01-11 | 北京智芯半导体科技有限公司 | Fault detection method and apparatus for security chip, electronic device, and medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070047765A1 (en) * | 1996-11-12 | 2007-03-01 | Rhoads Geoffrey B | Methods and Apparatus to Process Media |
| CN101201833A (en) * | 2006-12-13 | 2008-06-18 | 鸿富锦精密工业（深圳）有限公司 | System and method for filling PDF document data |
-
2016
- 2016-12-21 CN CN201611192809.4A patent/CN106599261A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070047765A1 (en) * | 1996-11-12 | 2007-03-01 | Rhoads Geoffrey B | Methods and Apparatus to Process Media |
| CN101201833A (en) * | 2006-12-13 | 2008-06-18 | 鸿富锦精密工业（深圳）有限公司 | System and method for filling PDF document data |
Non-Patent Citations (1)
| Title |
|---|
| 文天才等: "利用光学识别技术构建临床研究数据管理系统", 《医学信息学》 * |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108959213A (en) * | 2017-05-22 | 2018-12-07 | 宁波江丰电子材料股份有限公司 | Generation method and device, computer-readable medium, the terminal of product inspection report |
| CN107845033A (en) * | 2017-11-08 | 2018-03-27 | 上海壹账通金融科技有限公司 | Air control report-generating method, device, equipment and computer-readable recording medium |
| CN108536659A (en) * | 2018-03-26 | 2018-09-14 | 鹤山市明鹤电力建设有限公司 | A kind of automatic processing method and its device based on insulating tool test report |
| CN109859808A (en) * | 2018-07-25 | 2019-06-07 | 武汉心络科技有限公司 | A kind of medical data acquisition method and system |
| CN109446498A (en) * | 2018-09-12 | 2019-03-08 | 杭州优工品科技有限公司 | Components inspection report template data processing method and processing device |
| CN109346142A (en) * | 2018-09-30 | 2019-02-15 | 广州金域医学检验中心有限公司 | Comprehensive report generation method, device, terminal device and readable storage medium storing program for executing |
| CN109614430A (en) * | 2018-12-05 | 2019-04-12 | 云南大学 | Configurable data acquisition and data verification system and method based on WLAN |
| CN109614430B (en) * | 2018-12-05 | 2022-03-04 | 云南大学 | Configurable data acquisition and data verification system and method based on WLAN |
| CN109815109B (en) * | 2018-12-11 | 2020-05-12 | 口碑(上海)信息技术有限公司 | Data mode change detection method, device, equipment and readable storage medium |
| CN109815109A (en) * | 2018-12-11 | 2019-05-28 | 口碑(上海)信息技术有限公司 | Data pattern alteration detection method, apparatus, equipment and readable storage medium storing program for executing |
| WO2020253151A1 (en) * | 2019-06-19 | 2020-12-24 | 飞依诺科技(苏州)有限公司 | Automatic matching method and system for ultrasonic diagnosis report |
| CN113808696A (en) * | 2020-06-15 | 2021-12-17 | 飞依诺科技(苏州)有限公司 | Ultrasonic data processing method and device, computer equipment and storage medium |
| CN112580321A (en) * | 2020-12-29 | 2021-03-30 | 山东爱新卓尔智慧医疗技术有限公司 | Inspection report automatic generation method and system based on dual-model designer |
| CN113312881A (en) * | 2021-05-06 | 2021-08-27 | 上海移远通信技术股份有限公司 | Frequency band information conversion method and device, electronic equipment and computer storage medium |
| CN113312881B (en) * | 2021-05-06 | 2024-04-05 | 上海移远通信技术股份有限公司 | Frequency band information conversion method and device, electronic equipment and computer storage medium |
| WO2024007481A1 (en) * | 2022-07-06 | 2024-01-11 | 北京智芯半导体科技有限公司 | Fault detection method and apparatus for security chip, electronic device, and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106599261A (en) | Processing method for detection result data | |
| CN106445795B (en) | A kind of database SQL Efficiency testing method and device | |
| CN105825138B (en) | A kind of method and apparatus of sensitive data identification | |
| CN108768654B (en) | Identity verification method based on voiceprint recognition, server and storage medium | |
| US20080281860A1 (en) | Systems and methods for analyzing documents | |
| US9710519B1 (en) | Error identification, indexing and linking construction documents | |
| CN107092694A (en) | The inspection task creating method and device of the quality of data | |
| CN110389941B (en) | Database checking method, device, equipment and storage medium | |
| CN103761331A (en) | Processing system for drawing data and processing method thereof | |
| CN110007906A (en) | Processing method, device and the server of script file | |
| CN110083527A (en) | A kind of generation method and device, electronic equipment of test case | |
| CN107169321A (en) | The program plagiarism detection method and system being combined based on attribute count and structure measurement technology | |
| CN102546296A (en) | Automatic detecting method and device for electric power industry information system networking safety evaluation | |
| CN106301975A (en) | A kind of data detection method and device thereof | |
| CN113168538A (en) | Scanning device with regional OCR user interface | |
| CN107943966A (en) | Abnormal individual character decision method and device based on microblogging text | |
| CN106844684A (en) | The generation method and device of electronic test paper | |
| CN103186247A (en) | Formula input method and system | |
| US20160027123A1 (en) | Automatic tagging of trial balance | |
| CN112116314B (en) | Sample weighing data management system | |
| CN109684844A (en) | A kind of webshell detection method and device | |
| CN109145609A (en) | A kind of data processing method and device | |
| CN107015954A (en) | Equipment mainboard dial-up method to set up and system | |
| CN112085081A (en) | Sewage component detection method and system | |
| CN108376081A (en) | A method of detection mobile application third party library function |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170426 |