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 outputAs 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 disclosingAspect has a basic understanding, shown below is simple summary.The summarized section is not extensive overview, nor to determineKey/critical component describes the protection domain of these embodiments.Its sole purpose is presented with simple formConcept, 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, correspondingData template；
The examining report selection instruction of input is obtained, is transferred according to the examining report selection instruction prestoring, correspondingExamining report；
According to the data items listed in the data template, according to default item of information extracting mode, from the detectionThe 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 dataTemplate 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 projectIncluding at least sample unique mark position, sample item title, testing result, measurement unit, minimum detectable concentration and sample itemAnother 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 describedThe 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 configurationSample item another name in every a line of the instruction configuration data template；The configuration-direct has another name called including the sample itemValue；
The entry examining report is processed as into the single-row data of multirow and is shown；There is bag in these multirow dataMultirow containing testing result information, sample item another name, testing result and an other information item is included per data line, oftenSeparated 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 settingPosition 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 timeAfter 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 timeSample item another name in the data template ask is matched, and from the single-row data of the multirow, is determined and this timeThe data line of the sample item another name matching in the data template ask, believes according to the row position of the presupposed information itemBreath, 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 formatAccording 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 templateIn 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 dataOn 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 describedThe 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 gettingThe 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 dataTemplate 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 leastComprising 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 describedThe 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 markSetting 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, obtainsTake selected sample unique mark；When the sample unique mark setting area is typing area, obtains user and record in typing areaThe 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 lineUnique mark, sample item title, a testing result and other information item, use between the different items of information in every data lineDefault list separator separates；
Sample unique mark received by poll sample unique mark setting area, uniquely marks in inquiry every time to a sampleAfter 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 arrivedThe sample unique mark that receives of sample unique mark setting area matched, from the single-row data of the multirow, determineWith 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 aforementionedThe 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 lineTake out testing result；
Described information item is imported in the corresponding data project of the data template, the detection data of form format, bagInclude：
Sample unique mark received by poll sample unique mark setting area, uniquely marks in inquiry every time to a sampleAfter 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 multirowAccording 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 areaIn 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, obtainTake 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 templateCorresponding matching data line corresponding data project in, while import sample unique mark form format detection numberAccording 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 inputAt 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 templateIn 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 detectionReport；
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 determinedThe 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 dataItem 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 dataDefault 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 informationExtracting 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 itemsBreath 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 outputForm (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 reportContent 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 textThe 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 defaultPlate and preset data column information mode, is adapted to the form of different instrument output reports, so as to convenient receive dataIt 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 numberAccording 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, notThe present invention can be limited.
Specific embodiment
The following description and drawings fully illustrate specific embodiments of the present invention, to enable those skilled in the art toPut into practice them.Embodiment only represents possible change.Unless explicitly requested, otherwise single components and functionality is optional, andAnd the order for operating can change.The part of some embodiments and feature can be included in or replace other embodimentsPart and feature.The scope of embodiment of the present invention includes the gamut of claims, and the institute of claimsThere is obtainable equivalent.Herein, each embodiment individually or generally can be represented with term " invention " that this is onlyIt is merely for convenience, and if in fact disclosing the invention more than, be not meant to automatically limit the scope of the applicationFor any single invention or inventive concept.Herein, such as first and second or the like relational terms are used only for oneEntity or operation make a distinction with another entity or operation, and do not require or imply presence between these entities or operationAny actual relation or order.And, term " including ", "comprising" or its any other variant are intended to non-exclusiveProperty include so that a series of process, method or equipment including key elements not only include those key elements, but also includingOther key elements being not expressly set out.Herein each embodiment is described by the way of progressive, and each embodiment is stressedBe all difference with other embodiment, between each embodiment identical similar portion mutually referring to.For enforcementIt is corresponding with part disclosed in embodiment due to it for example disclosed structure, product etc., so fairly simple, the phase of descriptionPart 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 toThe 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, fromThe 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 formatData.
In the embodiment of the present invention, according to the number of detected sample item included in examining report, by detection reportAnnouncement is divided into two classes, is respectively entry examining report and individual event mesh examining report.Wherein, entry examining report refers to detection reportAt least two testing results of multiple sample items are included in announcement, individual event mesh examining report is referred in examining report and only includedOne 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 advanceThe 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 belowFormula：
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 entryReport, 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 dataTemplate 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 projectIncluding at least sample unique mark position (column data is sky, waits the sample in examining report to be imported to identify), sample item nameTitle, testing result, measurement unit, minimum detectable concentration and sample item another name.Wherein, sample item another name is in examining reportSample 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 respectivelyThe 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 denseDegree, 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 sideFormula, 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 describedConfiguration-direct includes the value of sample item another name；Sample in every a line of the data template is configured according to the configuration-directProduct 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 toOrder 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 dataIt is middle to there is the multirow comprising testing result information, include per data line sample item have another name called, testing result and otherItem of information, is separated per between the different items of information in data line with default list separator, separator can for space or otherList separator.
Letter is preset in the single-row data of the multirow that step A3, acquisition user pre-set or user's current settingThe 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 nameAny 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 usedWhich 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 peopleMember adjusts at random data acquisition modes according to examining report practical situation.For example, the data in itself examining report fromRow 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 reportSample 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. 2Shown, 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 numberAccording 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 timeAfter 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 inquiryMatched according to the sample item another name in template, from the single-row data of multirow, in determining the data template ask with this timeSample item another name matching data line, according to the row position information of presupposed information item, from the respective column position of the row dataExtract 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 formatDetection 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 templateIn 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 reportProject another name, sample item name column position, testing result row position, total data columns etc.), can be setting in effectively solving inspection softwareThe 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 defaultThe 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 A5In " 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 gotThe 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 gettingTotal 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 gotTotal 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 processingThe 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 multirowColumnar 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 templateIncluding 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 projectSample unique mark position, sample item title, testing result, measurement unit and minimum detectable concentration.As shown in figure 3, per a lineIt is divided into multi-column data project, has sample unique mark position, sample item title, testing result, measurement unit and minimum detection denseDegree, 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 defaultItem of information extracting mode, the corresponding item of information of the data items is extracted from the examining report ", step can be embodied asB1-B5：
Sample unique mark received by step B1, acquisition sample unique mark setting area；Wherein, when sample is uniquely markedSetting area is known to select during area, show that sample unique mark is selected for user in individual event mesh examining report, obtains selected sampleProduct 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 lineSample unique mark, sample item title, a testing result and other information item, per the different items of information in data line itBetween separated with default list separator；
Sample unique mark received by step B3, poll sample unique mark setting area, is asking to a sample every timeAfter 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 arrivedThe sample unique mark that receives of sample unique mark setting area matched, from the single-row data of multirow, determine and thisThe 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 frontThe 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 lineTake 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 shownShow, sample unique mark such as " WJ2016-09-38 ", sample item title such as " cyanide ", an inspection are included per data lineSurvey result as "<0.005 " and other information item such as detects the date, per data line in different items of information between with default pointSeparate 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 lineAsk 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 markKnow 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 inquiryThe data line of the sample unique mark matching that sample unique mark setting area receives.As shown in figure 3, obtaining the described of inputThe 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 markThe 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 resultBreath 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 formatThe 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 sampleAfter 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 multirowThe 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 formatDetection 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, obtainThe 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 templateAccording to multi-column data project in also include " testing staff ", " device numbering " project, obtain its corresponding item of information, such as " appointSpace ", " JL001 ".
" item of information that will be extracted from every data line of the single-row data of multirow imports data template to abovementioned stepsIn 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 otherThe 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 sampleThe 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 multirowItem 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 " appointSpace ", " JL001 ", in the corresponding data project of the data line for importing the Corresponding matching of the data template, form formatDetection 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 detectionReport；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 compiledVolume, 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, willThe Data Format Transform of described information item is the form of the data template requirement.Call format such as data template is floating-point latticeFormula, 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 stepSuddenly " 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 dataIf 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 occurWhen, 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 positionThe 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 spaceCharacter string " B " between data or branch between lattice, " 9 ", " 26.66762 " are defined as continuation character string.“B 926.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 otherClaim.
In one embodiment, in order to realize that more intelligence is automatically processed, raising testing result processing speed, aforementioned stepRapid 103 " according to the data items listed in data template, according to default item of information extracting mode, extract from examining reportThe 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 throughMode 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 textThe 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 defaultPlate and preset data column information mode, is adapted to the form of different instrument output reports, so as to convenient receive dataIt 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 numberAccording 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 claimSystem.