CN105912462A - Automatic archiving method and device for test results - Google Patents
Automatic archiving method and device for test results Download PDFInfo
- Publication number
- CN105912462A CN105912462A CN201610206542.3A CN201610206542A CN105912462A CN 105912462 A CN105912462 A CN 105912462A CN 201610206542 A CN201610206542 A CN 201610206542A CN 105912462 A CN105912462 A CN 105912462A
- Authority
- CN
- China
- Prior art keywords
- grand
- test result
- test
- document
- statement
- 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
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
Abstract
The invention provides an automatic archiving method and device for test results. The method comprises following steps: pre-setting at least one macro and determining a label of each macro, determining at least one test item of an object to be tested and obtaining time of a test result corresponding to each test time and a label of each corresponding macro; obtaining corresponding test results from a test instrument when the test result of any test item arrives and determining an automatic macro based on a macro corresponding to each test item; and saving each test result obtained to a file by running a target macro. By running pre-set macros, obtained test results can be saved to files in a real-time manner. The test results can be archived without participation of any person. Therefore, the scheme can achieve automatic archiving of test results.
Description
Technical field
The present invention relates to field of computer technology, a kind of automatically achieve particularly to test result method and
Device.
Background technology
Along with developing rapidly of server industries, power supply, such as server power supply, set as power supply application
Standby critical component, industry is more and more higher to the requirement of its performance.Therefore, the exploitation at power supply is applied
During, test process is essential.
At present, test system by control dependence test instrument, such as oscillograph, it is possible to achieve power supply from
Dynamicization is tested.When test instrunment captures test result, staff clicks on office software, such as excel
Add-in in specific function button, thus test result is preserved.
But, existing test result preserving type needs artificial participation to be accomplished, it is impossible to realize test
The automatic archive of result.
Summary of the invention
The invention provides the method and device that a kind of test result achieves automatically, it is possible to realize test result
Automatic archive.
In order to achieve the above object, the present invention is achieved through the following technical solutions:
On the one hand, the invention provides a kind of method that test result achieves automatically, pre-set at least one
Individual grand, and determine each described grand mark;Determine at least one test item of tested object, with
And the test result corresponding with test item each described obtains time and corresponding grand mark, also
Including:
When reaching the test result corresponding with target detection item and obtaining the time, obtain from test instrunment
Corresponding test result;
According to the grand mark corresponding with described target detection item, determine relative with described target detection item
That answers is grand;
Test result preservation that is described corresponding with described target detection item grand by running, that will get
To document.
Further, described document includes: excel document;
Described grand include: comprise and connect statement and obtain the grand of statement;
Described by running test result that is described corresponding with described target detection item grand, that will get
Preserve to document, including:
Obtain the Excel VI of Run Macro.vi in the report generation tool kit of LabVIEW;
Utilize the described Excel VI of Run Macro.vi, described with described target detection item phase by running
Corresponding grand in connection statement, connect described test instrunment and excel document, and by running institute
State corresponding with described target detection item grand in acquisition statement, the test result got is preserved extremely
In described excel document.
Further, described connection statement includes:
Application.Run("TekXLToolbar.xla!btnVConnect_Click()");
Described acquisition statement includes:
Application.Run("TekXLToolbar.xla!btnVHardcopy_Click").
Further, described grand include: comprise and the grand of statement is set;
Described determine each described grand mark before, also include: utilize and described statement is set, if
Put corresponding test result grand with each described and preserve parameter;
Described by running test result that is described corresponding with described target detection item grand, that will get
Preserve in document, including: described corresponding with described target detection item grand by running, Yi Jigen
Preserve parameter according to corresponding test result, the test result got is preserved to document.
Further, described statement is set, including:
Range("A383").Select
Selection.ShapeRange.Width=340.157480315.
Further, described test result preserves parameter, including: test result save location, and/or,
Test result preserves size.
Further, described test instrunment includes: oscillograph.
Further, described test item includes: ripple Ripple, dynamic load Transient, power-on and power-off
Waveform Turn On/Off, the time Deadtime that dies, overcurrent protection value OCP, load regulation Load
Appointing in voltage Vds, the shake Jitter of dutycycle between the drain electrode of Regulation, mos pipe and source class
Anticipate one or more.
Further, described test result includes: in screen picture, numerical value, sequence, waveform, word
Any one or more data mode.
Further, described from test instrunment, obtain corresponding test result, including: from test instrunment
The corresponding test result of middle acquisition, and corresponding test record information;
Described the test result that gets is preserved to document, including: by the test result got and
Corresponding test record information preserves to document.
Further, described document includes: excel document;
Described tested object includes: server Switching Power Supply;
Described from test instrunment, obtain corresponding test result before, also include: in advance at excel
Document arranges the sheet corresponding with each server Switching Power Supply;
Described the test result that gets is preserved to document, including: the test result that will get is protected
Deposit to the corresponding sheet of excel document.
On the other hand, the invention provides the device that a kind of test result achieves automatically, including:
Determine unit, be used for arranging that at least one is grand, and determine each described grand mark;Determine by
Test at least one test item of object, and the test result corresponding with test item each described obtains
Take time and corresponding grand mark;Receive acquiring unit send triggering signal time, according to
The grand mark that described target detection item is corresponding, determines corresponding with described target detection item grand;
Described acquiring unit, is used for when reaching the test result corresponding with target detection item and obtaining the time,
From test instrunment, obtain corresponding test result, and trigger and described determine unit;
Processing unit, for described corresponding with described target detection item grand by running, will get
Test result preserve in document.
Further, described document includes: excel document;
Described grand include: comprise and connect statement and obtain the grand of statement;
Described processing unit, specifically for the Excel in the report generation tool kit of acquisition LabVIEW
The sub-VI of Run Macro.vi;Utilize the described Excel VI of Run Macro.vi, by running described and institute
State the connection statement in corresponding grand of target detection item, connect described test instrunment and excel document,
And by run described corresponding with described target detection item grand in acquisition statement, by get
Test result preserves to described excel document.
Further, described grand include: comprise and the grand of statement is set;
Described determine unit, be additionally operable to utilize the described statement that arranges, arrange grand with each described corresponding
Test result preserve parameter;
Described processing unit, specifically for described corresponding with described target detection item grand by running,
And preserve parameter according to corresponding test result, the test result got is preserved to document.
The invention provides the method and device that a kind of test result achieves automatically, pre-set at least one
Grand and determine each grand mark, determine at least one test item of tested object, and with each
The corresponding test result of individual test item obtains time and corresponding grand mark;Reaching arbitrary test
Test result when obtaining the time, from test instrunment, obtain corresponding test result, and according to this survey
Try the corresponding grand mark of item to determine target macro;Then by running this target macro, by get
Test result preserves to document.Test knot that is pre-set grand by running, that can get
Automatically preserving to document during fruit, this test result achieves mode and participates in without artificial, therefore,
The present invention is capable of the automatic archive of test result.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to reality
Execute the required accompanying drawing used in example or description of the prior art to be briefly described, it should be apparent that below,
Accompanying drawing in description is some embodiments of the present invention, for those of ordinary skill in the art, not
On the premise of paying creative work, it is also possible to obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the flow chart of the method that a kind of test result that one embodiment of the invention provides achieves automatically;
Fig. 2 is the flow process of the method that the another kind of test result that one embodiment of the invention provides achieves automatically
Figure;
Fig. 3 is the schematic diagram of the device that a kind of test result that one embodiment of the invention provides achieves automatically.
Detailed description of the invention
For making the purpose of the embodiment of the present invention, technical scheme and advantage clearer, below in conjunction with this
Accompanying drawing in bright embodiment, is clearly and completely described the technical scheme in the embodiment of the present invention,
Obviously, described embodiment is a part of embodiment of the present invention rather than whole embodiments, based on
Embodiment in the present invention, those of ordinary skill in the art are institute on the premise of not making creative work
The every other embodiment obtained, broadly falls into the scope of protection of the invention.
As it is shown in figure 1, embodiments provide a kind of method that test result achieves automatically, permissible
Comprise the following steps:
Step 101: pre-set that at least one is grand, and determine each described grand mark;Determine by
Test at least one test item of object, and the test result corresponding with test item each described obtains
Take time and corresponding grand mark.
Step 102: when reaching the test result corresponding with target detection item and obtaining the time, from test
Instrument obtains corresponding test result.
Step 103: according to the grand mark corresponding with described target detection item, determine and described target
Corresponding grand of test item.
Step 104: described corresponding with described target detection item grand by running, the survey that will get
Test result preserves to document.
Embodiments provide a kind of method that test result achieves automatically, pre-set at least one
Grand and determine each grand mark, determine at least one test item of tested object, and with each
The corresponding test result of individual test item obtains time and corresponding grand mark;Reaching arbitrary test
Test result when obtaining the time, from test instrunment, obtain corresponding test result, and according to this survey
Try the corresponding grand mark of item to determine target macro;Then by running this target macro, by get
Test result preserves to document.Test knot that is pre-set grand by running, that can get
Automatically preserving to document during fruit, this test result achieves mode and participates in without artificial, therefore,
The embodiment of the present invention is capable of the automatic archive of test result.
In a kind of possible implementation, in order to the specific implementation that test result achieves automatically is described,
So, described document includes: excel document;
Described grand include: comprise and connect statement and obtain the grand of statement;
Described by running test result that is described corresponding with described target detection item grand, that will get
Preserve to document, including:
Obtain the Excel VI of Run Macro.vi in the report generation tool kit of LabVIEW;
Utilize the described Excel VI of Run Macro.vi, described with described target detection item phase by running
Corresponding grand in connection statement, connect described test instrunment and excel document, and by running institute
State corresponding with described target detection item grand in acquisition statement, the test result got is preserved extremely
In described excel document.
In a kind of possible implementation, described connection statement includes:
Application.Run("TekXLToolbar.xla!btnVConnect_Click()");
Described acquisition statement includes:
Application.Run("TekXLToolbar.xla!btnVHardcopy_Click").
In a kind of possible implementation, in order on the basis that test result achieves automatically,
Test result is preserved to the pre-position of document, so, described grand include: comprise and statement is set
Grand;
Described determine each described grand mark before, farther include: utilize and described statement is set,
Corresponding test result grand with each described is set and preserves parameter;
Described by running test result that is described corresponding with described target detection item grand, that will get
Preserve in document, including: described corresponding with described target detection item grand by running, Yi Jigen
Preserve parameter according to corresponding test result, the test result got is preserved to document.
In a kind of possible implementation, described statement is set, including:
Range("A383").Select
Selection.ShapeRange.Width=340.157480315.
In a kind of possible implementation, described test result preserves parameter, including: test result is protected
Deposit position, and/or, test result preserves size.
In a kind of possible implementation, described test instrunment includes: oscillograph.
In a kind of possible implementation, described test item includes: Ripple (ripple), Transient
(dynamic load), Turn On/Off (power-on and power-off waveform), Deadtime (dying the time), OCP
(over current portect, overcurrent protection value), Load Regulation (load regulation), Vds
(voltage drain source, the voltage between the drain electrode of mos pipe and source class), Jitter (trembling of dutycycle
Dynamic) in any one or more.
In a kind of possible implementation, described test result includes: screen picture, numerical value, sequence,
Any one or more data mode in waveform, word.
In a kind of possible implementation, it is analyzed checking to test result for the ease of staff
With understand respective record information, so, described from test instrunment, obtain corresponding test result, including:
Corresponding test result, and corresponding test record information is obtained from test instrunment;
Described the test result that gets is preserved to document, including: by the test result got and
Corresponding test record information preserves to document.
In a kind of possible implementation, system identification and management for convenience, and it is easy to work people
The test result of similar tested object is analyzed checking by member, so, described document includes: excel
Document;
Described tested object includes: server Switching Power Supply;
Described from test instrunment, obtain corresponding test result before, farther include: exist in advance
Excel document arranges the sheet corresponding with each server Switching Power Supply;
Described the test result that gets is preserved to document, including: the test result that will get is protected
Deposit to the corresponding sheet of excel document.
For making the object, technical solutions and advantages of the present invention clearer, below in conjunction with the accompanying drawings and specifically real
The present invention is described in further detail to execute example.
As in figure 2 it is shown, one embodiment of the invention provides the method that test result achieves automatically, the party
Method may comprise steps of:
Step 201: arrange 8 grand, and each grand in all comprise connection statement, obtain statement and setting
Put statement, and determine each grand grand name.
In detail, connecting statement can be:
Application.Run("TekXLToolbar.xla!btnVConnect_Click()");
Obtaining statement can be:
Application.Run("TekXLToolbar.xla!btnVHardcopy_Click");
Arranging statement can be:
Range("****").Select
Selection.ShapeRange.Width=****.
In detail, in grand editing process, it is possible to use the write of VB statement connects statement, obtains language
Sentence and statement is set.
For example, now need 5 server Switching Power Supplies are carried out performance test, and each service
Device Switching Power Supply is required to carry out the test assignment of 8 test items.Wherein, these 5 server switch electricity
The mark in source is respectively power supply 1, power supply 2, power supply 3, power supply 4 and power supply 5.In the present embodiment,
For any one tested power supply, need its sequential automation carrying out 8 test items is tested, therefore
Accordingly, can pre-set 8 grand.After completing 8 grand settings, it may be determined that each is grand
Mark, such as may determine that its grand name, respectively 001,002 ..., 008.
In the present embodiment, tested power supply can be server Switching Power Supply, based on same realize former
Reason, tested power supply can also is that other power supplys, such as cellular phone power supplies etc..
Specifically, for a tested power supply, can be by automatic for the test result of corresponding each test item
Preserve in arbitrary excel document, thus can write in advance in this excel document these 8 grand.Its
In, each is grand all comprises identical connection statement, obtain statement and arrange statement.A kind of possible
In implementation, equally test result is preserved to other documents, such as word document.
In detail, in the present embodiment, connect statement to may be used for setting up test instrunment and excel document
Annexation;Obtain statement to may be used for obtaining the test result in test instrunment;It is permissible that statement is set
For limiting the specific preserving type of the test result got.By the these three statement in run macro,
The automatization being possible not only to realize test result achieves, and achieves mode and can predefine.
Step 202: utilize and arrange statement, arranges and preserves ginseng with each grand corresponding test result
Number.
In detail, test result preserves parameter can include test result save location, and/or, test
Result preserves size.
In detail, appointing during test result can include screen picture, numerical value, sequence, waveform, word
Anticipate one or more data modes.
Such as, in the present embodiment, need 5 server Switching Power Supplies are tested, therefore can obtain
Taking test instrunment, such as the test result in oscillograph, and this test result is oscillogram.Accordingly, pin
To oscillogram, test result preserves parameter can include that oscillogram specifically preserves position in excel document
Put the preservation size with oscillogram.
In the present embodiment, staff can input grand corresponding with each according to the actual requirements
Test result preserves parameter.Such as, for corresponding with grand name 001 grand, it interior can be arranged language
Sentence is set to:
Range("A383").Select
Selection.ShapeRange.Width=340.157480315
By run this grand in statement is set, can by oscillograph oscillogram preserve to one
A383 position in excel document, and the picture width of oscillogram is 340.157480315 pounds, i.e.
12cm.Wherein, 1cm=28.346 pound.Based on this mode, can be respectively provided with grand with each
Corresponding test result preserves parameter.
Step 203: arrange corresponding with each server Switching Power Supply in excel document
sheet。
Owing to the present embodiment needing test 5 server Switching Power Supplies successively, for ease of test
The archive of result and facilitate staff to be analyzed checking, can divide the test result of these 5 power supplys
Bao Cun be in the different sheet in same excel document.Additionally, for different types of tested right
As, corresponding test result can be preserved to different excel documents.
Such as, the test result of power supply 1, power supply 2, power supply 3, power supply 4 and power supply 5 can be protected respectively
Deposit in sheet1, sheet2, sheet3, sheet4, the sheet5 to same excel document.Work as system
Get the mark of current tested power supply, during such as power supply 1, test result can be achieved automatically to this
In the sheet1 of excel document.Therefore, in the present embodiment, can set in advance in this excel document
Put this 5 sheet.
Step 204: determine 8 test items of tested power supply, and corresponding with each test item
Test result obtain time and corresponding grand grand name.
In detail, test item can include Ripple, Transient, Turn On/Off, Deadtime,
Any one or more in OCP, Load Regulation, Vds, Jitter.In the present embodiment,
Can be for above-mentioned 8 test items, with respectively to current tested power supply: power supply 1 is tested.
The test result being determined by each test item obtains the time, and system can be made to set reaching arbitrary
When fixing time, the test of the current test item corresponding with this setting time in acquisition test instrunment in real time
Result.Additionally, according to the setting time corresponding with these 8 test items, it is also possible to determine corresponding 8
Plant the acquisition order of test result.
Further, it is also possible to set up the one_to_one corresponding pass of these 8 test items and 8 grand grand names of setting
System.Such as, test item Ripple corresponds to grand name corresponding to grand name 001, test item Transient
002, test item Turn On/Off corresponds to grand name corresponding to grand name 003, test item Deadtime
004, test item OCP corresponds to grand name 005, test item Load Regulation corresponds to grand name 006,
Test item Vds corresponds to grand name 008 corresponding to grand name 007, test item Jitter.By setting up this pair
Should be related to, when system gets the test result of arbitrary test item, it may be determined that relative with this test item
The grand grand name answered, such that it is able to run the grandest according to the grand name determined in subsequent operation.
Step 205: when reaching the test result corresponding with test item Deadtime and obtaining the time, from
Oscillograph obtains corresponding test result and test record information.
In embodiments of the present invention, system program, by programming, can control DC source, electronic load
The instrument and equipment such as instrument, oscillograph, so that tested power supply is carried out automatic test, often completes a survey
After the test operation of examination item, can be shown by oscillograph and output test result.
In detail, DC source is used to tested power supply and powers, and it is right that electronic load instrument may be used for
Tested power supply applies dead load, and oscillograph is displayed for test result, and record is corresponding
Test record information.
In detail, test record information can include testing time, test instrunment, test mode etc..
In the automatic test course of tested power supply, reach a test result obtain when system gets
When taking the time, can determine that current test item, such as system get and work as according to this concrete time
The front test item set corresponding to the time is as Deadtime.Meanwhile, when reaching this setting time, from
Oscillograph obtains corresponding test result, and corresponding test record information.Additionally, system also may be used
To get the mark of current tested power supply, such as power supply 1.
Step 206: the grand name according to corresponding with test item Deadtime: 004, determines and test item
The target macro that Deadtime is corresponding.
One-to-one relationship according to test item Yu grand name, it may be determined that relative with test item Deadtime
Grand grand entitled 004 answered, then can determine corresponding with grand name 004 grand be according to grand name 004
It is subsequently used for preserving the grand of the test result that currently gets.
Step 207: obtain Excel Run Macro.vi in the report generation tool kit of LabVIEW
VI。
In the present embodiment, the sub-VI of Excel Run Macro.vi may be used for running write in advance grand.
Owing to LabVIEW test result to test instrunment cannot carry out automatic archive process in real time, therefore
In the case of not run macro, often get a test result, be required to staff and artificially click on
The TekXL Toolbar:TekXL on TekXL Toolbar toolbar in excel form add-in
Connection and TekXL Toolbar:TekXL Screen Capture the two specific button, with reality
The manual archive of existing test result.
In the present embodiment, by utilizing the Excel VI of Run Macro.vi in LabVIEW with fortune
It is grand that row is write in advance, with the specific function that reaches to be similar to manually to click in excel form add-in by
The effect of button, thus solve this technical problem that prior art cannot achieve automatically.This mode
Automatic operating, completely without the participation of staff, can carry out real-time automatization to test result and deposit
Shelves, save the input of human resources.
Step 208: utilize the Excel VI of Run Macro.vi, by operational objective connection language in grand
Sentence, connects oscillograph and excel document.
In order to the test result got is automatically saved in excel document, first can pass through
Run corresponding with grand name 004 grand in connection statement, to set up oscillograph and the company of excel document
Connect relation.
Step 209: by operational objective acquisition statement in grand with arrange statement, and according to test
Test result corresponding for item Deadtime preserves parameter, the test result that will get and test record
Information preserves to the sheet1 of excel document.
It is designated power supply 1 due to what system had detected that tested power supply, therefore accordingly, can will obtain
To test result preserve in the sheet1 of excel document.
Ensureing on the basis that oscillograph and excel document connect, relative with grand name 004 by running
Answer grand in acquisition statement, the test result that gets and corresponding test record information can be preserved extremely
In the sheet1 of excel document.But, simple running obtains statement and simply completes test result
Automatically achieve, do not determine corresponding concrete save location.When test result substantial amounts, this
Mode is unfavorable for that staff is analyzed checking.Therefore, automatically saving of test result equally has
The assistance of statement is set.
Owing to arranging, statement can comprise test result save location and test result preservation size these two
Set information, thus by run corresponding with grand name 004 grand in statement is set, can be according to setting
Test result preserve the size of the size waveform figure to getting and carry out corresponding flexible process,
And at the save location of the extremely setting of the graphics saving after processing.Accordingly, get tests note accordingly
Record information preserves the most on request.
In embodiments of the present invention, pre-set specific by utilizing LabVIEW system to run
Grand, test result can be preserved setting position to document the most automatically.This implementation can
So that automatic test speed is effectively ensured, improves the whole work efficiency of test system, reduce a staff
Monitoring, writing task amount, and the archive mode of test result is not only easy to staff and is analyzed looking into
See and arrange storage, and be easy to computer system and the test result of storage carried out automatic business processing and divides
Analysis.
Additionally, the embodiment of the present invention is on automatic test basis, it is achieved that automatically depositing of test result
Shelves, thus perfect integrated automation test program, automaticity is high, and the testing time shortens, test
Effect accuracy is good, uses manpower and material resources sparingly.
As it is shown on figure 3, embodiments provide the device that a kind of test result achieves automatically, including:
Determine unit 301, be used for arranging that at least one is grand, and determine each described grand mark;Really
At least one test item of fixed tested object, and the test knot corresponding with test item each described
Fruit obtains time and corresponding grand mark;When receiving the triggering signal that acquiring unit 302 sends,
According to the grand mark corresponding with described target detection item, determine corresponding with described target detection item
Grand;
Described acquiring unit 302, for when reaching the test result corresponding with target detection item and obtaining
Between time, from test instrunment, obtain corresponding test result, and trigger and described determine unit 301;
Processing unit 303, for described corresponding with described target detection item grand by running, will obtain
The test result got preserves to document.
In one embodiment of the invention, described document includes: excel document;
Described grand include: comprise and connect statement and obtain the grand of statement;
Described processing unit 303, specifically for the Excel in the report generation tool kit of acquisition LabVIEW
The sub-VI of Run Macro.vi;Utilize the described Excel VI of Run Macro.vi, by running described and institute
State the connection statement in corresponding grand of target detection item, connect described test instrunment and excel document,
And by run described corresponding with described target detection item grand in acquisition statement, by get
Test result preserves to described excel document.
In one embodiment of the invention, described grand include: comprise and the grand of statement is set;
Described determine unit 301, be further used for utilizing the described statement that arranges, arrange with described in each
Grand corresponding test result preserves parameter;
Described processing unit 303, specifically for described corresponding with described target detection item by running
Grand, and preserve parameter according to corresponding test result, the test result got is preserved to document.
The contents such as the information between each unit in said apparatus is mutual, execution process, due to the present invention
Embodiment of the method is based on same design, and particular content can be found in the narration in the inventive method embodiment, this
Place repeats no more.
In sum, each embodiment of the present invention at least has the advantages that
1, in the embodiment of the present invention, pre-set that at least one is grand and determine each grand mark, determine
At least one test item of tested object, and the test result acquisition corresponding with each test item
Time and corresponding grand mark;When the test result reaching arbitrary test item obtains the time, from survey
Test instrument obtains corresponding test result, and according to the grand mark corresponding with this test item to determine mesh
Mark grand;Then by running this target macro, the test result got is preserved to document.By fortune
Row is pre-set grand, can the test result that get the most automatically be preserved to document, this
One test result achieves mode and participates in without artificial, and therefore, the embodiment of the present invention is capable of test result
Automatic archive.
2, in the embodiment of the present invention, by utilizing the Excel VI of Run Macro.vi in LabVIEW
With run write in advance grand, to reach to be similar to manually click on the specific merit in excel form add-in
The effect of energy button, thus solve this technical problem that prior art cannot achieve automatically.This side
The automatic operating of formula, completely without the participation of staff, can carry out real-time automatization to test result
Achieve, save the input of human resources.
3, in the embodiment of the present invention, pre-set specific by utilizing LabVIEW system to run
Grand, test result can be preserved setting position to document the most automatically.This implementation can
So that automatic test speed is effectively ensured, improves the whole work efficiency of test system, reduce a staff
Monitoring, writing task amount, and the archive mode of test result is not only easy to staff and is analyzed looking into
See and arrange storage, and be easy to computer system and the test result of storage carried out automatic business processing and divides
Analysis.
4, in the embodiment of the present invention, on automatic test basis, the embodiment of the present invention achieves test
The automatic archive of result, thus perfect integrated automation test program, automaticity is high, during test
Between shorten, test effect accuracy good, use manpower and material resources sparingly.
It should be noted that in this article, the relational terms of such as first and second etc be used merely to by
One entity or operation separate with another entity or operating space, and not necessarily require or imply this
Relation or the order of any this reality is there is between a little entities or operation.And, term " includes ",
" comprise " or its any other variant is intended to comprising of nonexcludability, so that include that one is
The process of row key element, method, article or equipment not only include those key elements, but also include the brightest
Other key elements really listed, or also include intrinsic for this process, method, article or equipment
Key element.In the case of there is no more restriction, statement " include one " and limit
Key element, it is not excluded that there is also another in including the process of described key element, method, article or equipment
Outer same factor.
One of ordinary skill in the art will appreciate that: realize all or part of step of said method embodiment
Can be completed by the hardware that programmed instruction is relevant, aforesaid program can be stored in embodied on computer readable
Storage medium in, this program upon execution, performs to include the step of said method embodiment;And it is aforementioned
Storage medium include: various Jie that can store program code such as ROM, RAM, magnetic disc or CD
In matter.
Last it should be understood that the foregoing is only presently preferred embodiments of the present invention, it is merely to illustrate this
The technical scheme of invention, is not intended to limit protection scope of the present invention.All spirit in the present invention and former
Any modification, equivalent substitution and improvement etc. done within then, are all contained in protection scope of the present invention.
Claims (10)
1. the method that a test result achieves automatically, it is characterised in that pre-set that at least one is grand,
And determine each described grand mark;Determine at least one test item of tested object, and with often
The corresponding test result of one described test item obtains time and corresponding grand mark, also includes:
When reaching the test result corresponding with target detection item and obtaining the time, obtain from test instrunment
Corresponding test result;
According to the grand mark corresponding with described target detection item, determine relative with described target detection item
That answers is grand;
Test result preservation that is described corresponding with described target detection item grand by running, that will get
To document.
Method the most according to claim 1, it is characterised in that
Described document includes: excel document;
Described grand include: comprise and connect statement and obtain the grand of statement;
Described by running test result that is described corresponding with described target detection item grand, that will get
Preserve to document, including:
Obtain the Excel VI of Run Macro.vi in the report generation tool kit of LabVIEW;
Utilize the described Excel VI of Run Macro.vi, described with described target detection item phase by running
Corresponding grand in connection statement, connect described test instrunment and excel document, and by running institute
State corresponding with described target detection item grand in acquisition statement, the test result got is preserved extremely
In described excel document.
Method the most according to claim 2, it is characterised in that
Described connection statement includes:
Application.Run("TekXLToolbar.xla!btnVConnect_Click()");
Described acquisition statement includes:
Application.Run("TekXLToolbar.xla!btnVHardcopy_Click").
4. according to described method arbitrary in claims 1 to 3, it is characterised in that
Described grand include: comprise and the grand of statement is set;
Described determine each described grand mark before, farther include: utilize and described statement is set,
Corresponding test result grand with each described is set and preserves parameter;
Described by running test result that is described corresponding with described target detection item grand, that will get
Preserve in document, including: described corresponding with described target detection item grand by running, Yi Jigen
Preserve parameter according to corresponding test result, the test result got is preserved to document.
Method the most according to claim 4, it is characterised in that
Described statement is set, including:
Range("A383").Select
Selection.ShapeRange.Width=340.157480315;
And/or,
Described test result preserves parameter, including: test result save location, and/or, test result is protected
Deposit size.
Method the most according to claim 1, it is characterised in that
Described test instrunment includes: oscillograph;
And/or,
Described test item includes: ripple Ripple, dynamic load Transient, power-on and power-off waveform Turn
On/Off, the time Deadtime that dies, overcurrent protection value OCP, load regulation Load Regulation,
Any one or more in voltage Vds, the shake Jitter of dutycycle between the drain electrode of mos pipe and source class;
And/or,
Described test result includes: any one in screen picture, numerical value, sequence, waveform, word
Or multiple data mode.
Method the most according to claim 1, it is characterised in that
Described from test instrunment, obtain corresponding test result, including: obtain corresponding from test instrunment
Test result, and corresponding test record information;
Described the test result that gets is preserved to document, including: by the test result got and
Corresponding test record information preserves to document;
And/or,
Described document includes: excel document;
Described tested object includes: server Switching Power Supply;
Described from test instrunment, obtain corresponding test result before, farther include: exist in advance
Excel document arranges the sheet corresponding with each server Switching Power Supply;
Described the test result that gets is preserved to document, including: the test result that will get is protected
Deposit to the corresponding sheet of excel document.
8. the device that a test result achieves automatically, it is characterised in that including:
Determine unit, be used for arranging that at least one is grand, and determine each described grand mark;Determine by
Test at least one test item of object, and the test result corresponding with test item each described obtains
Take time and corresponding grand mark;Receive acquiring unit send triggering signal time, according to
The grand mark that described target detection item is corresponding, determines corresponding with described target detection item grand;
Described acquiring unit, is used for when reaching the test result corresponding with target detection item and obtaining the time,
From test instrunment, obtain corresponding test result, and trigger and described determine unit;
Processing unit, for described corresponding with described target detection item grand by running, will get
Test result preserve in document.
The device that test result the most according to claim 8 achieves automatically, it is characterised in that
Described document includes: excel document;
Described grand include: comprise and connect statement and obtain the grand of statement;
Described processing unit, specifically for the Excel in the report generation tool kit of acquisition LabVIEW
The sub-VI of Run Macro.vi;Utilize the described Excel VI of Run Macro.vi, by running described and institute
State the connection statement in corresponding grand of target detection item, connect described test instrunment and excel document,
And by run described corresponding with described target detection item grand in acquisition statement, by get
Test result preserves to described excel document.
The device that the most according to Claim 8, in 9 arbitrary described test result achieves automatically, it is special
Levy and be,
Described grand include: comprise and the grand of statement is set;
Described determine unit, be further used for utilizing the described statement that arranges, grand phase is set with each described
Corresponding test result preserves parameter;
Described processing unit, specifically for described corresponding with described target detection item grand by running,
And preserve parameter according to corresponding test result, the test result got is preserved to document.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610206542.3A CN105912462A (en) | 2016-04-05 | 2016-04-05 | Automatic archiving method and device for test results |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610206542.3A CN105912462A (en) | 2016-04-05 | 2016-04-05 | Automatic archiving method and device for test results |
Publications (1)
Publication Number | Publication Date |
---|---|
CN105912462A true CN105912462A (en) | 2016-08-31 |
Family
ID=56745458
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610206542.3A Pending CN105912462A (en) | 2016-04-05 | 2016-04-05 | Automatic archiving method and device for test results |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105912462A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108802459A (en) * | 2018-06-04 | 2018-11-13 | 北京交通大学 | A kind of oscillograph Auto-Test System and method |
CN111653045A (en) * | 2020-07-13 | 2020-09-11 | 魏洪校 | Paper report enterprise internal filing method |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020147561A1 (en) * | 2001-04-09 | 2002-10-10 | William Baracat | System and method for intelligent wire testing |
CN103577388A (en) * | 2013-11-21 | 2014-02-12 | 中国农业银行股份有限公司 | Excel template based data processing method and device |
CN103792498A (en) * | 2014-02-14 | 2014-05-14 | 浪潮电子信息产业股份有限公司 | Automatic power supply testing method |
CN104461570A (en) * | 2014-12-29 | 2015-03-25 | 浪潮电子信息产业股份有限公司 | BOM automatic analysis method |
CN105260297A (en) * | 2015-09-14 | 2016-01-20 | 上海斐讯数据通信技术有限公司 | Test data management system and method |
CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
-
2016
- 2016-04-05 CN CN201610206542.3A patent/CN105912462A/en active Pending
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020147561A1 (en) * | 2001-04-09 | 2002-10-10 | William Baracat | System and method for intelligent wire testing |
CN103577388A (en) * | 2013-11-21 | 2014-02-12 | 中国农业银行股份有限公司 | Excel template based data processing method and device |
CN103792498A (en) * | 2014-02-14 | 2014-05-14 | 浪潮电子信息产业股份有限公司 | Automatic power supply testing method |
CN104461570A (en) * | 2014-12-29 | 2015-03-25 | 浪潮电子信息产业股份有限公司 | BOM automatic analysis method |
CN105260297A (en) * | 2015-09-14 | 2016-01-20 | 上海斐讯数据通信技术有限公司 | Test data management system and method |
CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
Non-Patent Citations (1)
Title |
---|
越测越开心: "示波器与Excel自动建立连接一不需要编程,轻松监测波形数据和测量数据", 《HTTP://WWW.EEFOCUS.COM/HAPPYTESTING/BLOG/10-07/192858_BA3C3.HTML》 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108802459A (en) * | 2018-06-04 | 2018-11-13 | 北京交通大学 | A kind of oscillograph Auto-Test System and method |
CN111653045A (en) * | 2020-07-13 | 2020-09-11 | 魏洪校 | Paper report enterprise internal filing method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105891733A (en) | Method, device and system for debugging in process of power source test | |
CN108446190A (en) | interface test method and device | |
CN109684947A (en) | Mark quality control method, device, computer equipment and storage medium | |
CN103605606B (en) | A kind of embedded software test use-case batch execution method that can automatically change | |
Bik et al. | A reference method for user story requirements in agile systems development | |
CN113190443A (en) | Test method, test device, computer equipment and storage medium | |
Suryawan | Information technology service performance management using COBIT and ITIL frameworks: A case study | |
CN1987820A (en) | Method and system for tracing program execution in field programmable gate arrays | |
CN105912462A (en) | Automatic archiving method and device for test results | |
Axmann et al. | A framework of cost drivers for robotic process automation projects | |
CN111654691B (en) | Performance test method, device, computer storage medium and system | |
CN110633213B (en) | Unit test method, unit test device, computer equipment and storage medium | |
CN106557419B (en) | Program testing method and device | |
JP2006234621A (en) | Semi-conductor measurement system and its control method | |
Cui et al. | Research of an intelligent experimental teaching platform based on Internet | |
Masuda et al. | Software Test Architecture Definition by Analogy with Software Architecture | |
CN107766228B (en) | Multi-language-based automatic testing method and device | |
Ghosh et al. | A study of software change management problem | |
CN114625448A (en) | Flow generation method and device combining RPA and AI, electronic equipment and storage medium | |
CN113572900A (en) | Outbound test method, device, computer equipment and computer readable storage medium | |
Zhang | Research on software development and test environment automation based on android platform | |
Aggarwal et al. | Escalated methods for software defects audit in repercussion and effects construe to nature-inspired and behavior-driven mechanisms | |
Popoola et al. | Development and Performance Evaluation of an Intelligent Electric Power Switching System [J] | |
Ivanov et al. | The complex of automated control of secondary power supplies parameters | |
US20170185624A1 (en) | Method of reusing existing statistics to load database tables |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160831 |
|
WD01 | Invention patent application deemed withdrawn after publication |