CN114238043A - Test data analysis system and forming method - Google Patents

Test data analysis system and forming method Download PDF

Info

Publication number
CN114238043A
CN114238043A CN202111675377.3A CN202111675377A CN114238043A CN 114238043 A CN114238043 A CN 114238043A CN 202111675377 A CN202111675377 A CN 202111675377A CN 114238043 A CN114238043 A CN 114238043A
Authority
CN
China
Prior art keywords
test
test data
file
analysis system
template file
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
Application number
CN202111675377.3A
Other languages
Chinese (zh)
Inventor
张宝芳
张善睿
张琳
邓波
李新智
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Luogu Technology Shanghai Co ltd
North Valley Electronics Co ltd
Original Assignee
Luogu Technology Shanghai Co ltd
North Valley Electronics Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Luogu Technology Shanghai Co ltd, North Valley Electronics Co ltd filed Critical Luogu Technology Shanghai Co ltd
Priority to CN202111675377.3A priority Critical patent/CN114238043A/en
Publication of CN114238043A publication Critical patent/CN114238043A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/32—Monitoring with visual or acoustical indication of the functioning of the machine
    • G06F11/323—Visualisation of programs or trace data
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3466—Performance evaluation by tracing or monitoring
    • G06F11/3476—Data logging
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/186—Templates
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G06F9/451—Execution arrangements for user interfaces

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Quality & Reliability (AREA)
  • Computer Hardware Design (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Human Computer Interaction (AREA)
  • Health & Medical Sciences (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The invention provides a test data analysis system and a forming method thereof, comprising the following steps: establishing a test template file by using Excel, and naming the test template file by using a test project name; recording the name of the test project by using a notebook, and storing the name as a recording file; establishing a tracing system table by using an SQLsever database; writing a front panel control to create a test interface of the Labview application program, wherein part of the front panel control is written according to the record file; compiling a program diagram of data interaction between the Labview application program and the test template file, and displaying the content in the test template file to a test interface; so as to compile a program block diagram of data interaction between the Labview application program and the tracing system table. The test data is judged and the judgment result is displayed through the test interface, and the test data and the judgment result can be recorded and inquired through the test interface, so that the paper record is replaced, and the resources are saved.

Description

Test data analysis system and forming method
Technical Field
The invention relates to the field of industrial data automation, in particular to a test data analysis system and a forming method.
Background
At present, an electric drive controller is assembled in multiple processes, and in the manual assembly process, relevant data assembled in a certain step needs to be manually measured, recorded and analyzed to determine whether to perform the next step of assembly, and one product needs a record table.
In the prior art, some conclusive data, such as whether the test data is in the required range, can be obtained by manually calculating the measurement data or calculating the measurement data by using a tool such as Excel, and if so, the next assembly can be carried out. The test data includes resistance, voltage, insulation, on/off, and the like.
However, if the manual recording and calculating method in the prior art is adopted, one recording table is used for each product, the number is huge, the paper report is difficult to store and search, the storage period is limited, and manual calculation and comparison are not only tedious in work, but also prone to errors. The Excel report can be used for data recording and automatic analysis, but has small data capacity and small safety, any person can modify or modify errors, and the Excel report is only suitable for single-person operation at the same time, is not suitable for simultaneous use by multiple persons, and cannot meet the condition of remote management.
Disclosure of Invention
The invention aims to provide a test data analysis system and a forming method thereof, which can replace a paper report, save materials, improve the accuracy of recorded test data, and further adapt to simultaneous operation and remote management of multiple persons.
In order to achieve the above object, the present invention provides a method for forming a test data analysis system, including:
establishing a test template file by using Excel, and naming the test template file by using a test project name;
recording the test project name by using a notebook, and storing the test project name as a recording file;
establishing a tracing system table by using an SQLsever database;
writing a front panel control to create a test interface of a Labview application program, wherein part of the front panel control is written according to the record file;
compiling a program diagram of data interaction between the Labview application program and the test template file so as to read the test template file and display the content in the test template file to the test interface; and
and compiling a program block diagram of data interaction between the Labview application program and the tracing system table.
Optionally, in the method for forming a test data analysis system, the method further includes: and associating the Labview application program with an MES system.
Optionally, in the method for forming a test data analysis system, creating a test interface of a Labview application includes: creating a test information input panel and creating a data query panel.
Optionally, in the method for forming the test data analysis system, the method for creating the test template file includes: and listing the content of the test item in an excel document, and storing the content as an excel file.
Optionally, in the method for forming a test data analysis system, the content of the test template file includes: test conditions, test data, upper limits, standard lower limits, test data units, and/or judgment results.
Optionally, in the method for forming the test data analysis system, at least one test template file is provided, and when at least two test template files are provided, the file names of all the test template files are different.
Optionally, in the method for forming the test data analysis system, the method for recording the name of the test item by using the notepad includes: and listing the test item names in a notebook according to a column mode.
Optionally, in the forming method of the test data analysis system, a suffix name of the record file is. ini.
Optionally, in the method for forming the test data analysis system, the method for establishing the trace back system table by using the SQLsever database includes: establishing a test item, a test serial number, a test sub-item, test data, a judgment result, test time and a tester; unifying the test items, the test serial numbers, the test sub-items, the test data, the judgment results, the test time and the formats of the testers.
Correspondingly, the invention also provides a test data analysis system, which comprises:
the Excel tool is used for establishing a test template file;
the notebook tool is used for recording the name of the test project and storing the test project as a recording file;
the SQLsever database is used for establishing a tracing system table and storing the content of the test template file and the test result; and
the test interface of the Labview application program comprises an input control, a test information input panel and a test data query panel, wherein the input control is used for inputting the test data, the display control is used for displaying a judgment result, the test information input panel is used for displaying the test data and the judgment result according to the content in the test template file, and the test data query panel is used for recording the test data and the judgment result, and querying the test data and the judgment result.
Optionally, in the test data analysis system, the method further includes: and the MES system is used for remotely recording the test data and the judgment result and remotely inquiring the test data and the judgment result, and is associated with the Labview application program.
In the test data analysis system and the forming method provided by the invention, a test template file is firstly established, the content to be displayed and the judgment condition of the test data are compiled in the test template file, a Labview application program test interface is then established, the test data and the judgment test data are displayed through the Labview application program test interface, the mode of recording the test record by a paper report is replaced, and the material is saved. Meanwhile, the Labview application program test interface can be operated by multiple persons.
Drawings
FIG. 1 is a flow chart of a method of forming a test data analysis system according to an embodiment of the present invention;
FIG. 2 is a schematic illustration of the contents of a test template file according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of recording file content in accordance with an embodiment of the present invention;
fig. 4 and 5 are schematic diagrams of a test interface according to an embodiment of the present invention.
Detailed Description
The following describes in more detail embodiments of the present invention with reference to the schematic drawings. The advantages and features of the present invention will become more apparent from the following description. It is to be noted that the drawings are in a very simplified form and are not to precise scale, which is provided for the purpose of facilitating and distinctly claiming the embodiments of the present invention.
In the following, the terms "first," "second," and the like are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the terms so used are interchangeable under appropriate circumstances. Similarly, if the method described herein comprises a series of steps, the order in which these steps are presented herein is not necessarily the only order in which these steps may be performed, and some of the described steps may be omitted and/or some other steps not described herein may be added to the method.
Referring to fig. 1, the present invention provides a method for forming a test data analysis system, including:
s11: establishing a test template file by using Excel, and naming the test template file by using a test project name;
s12: recording the name of the test project by using a notebook, and storing the name as a recording file;
s13: establishing a tracing system table by using an SQLsever database;
s14: writing a front panel control to create a test interface of the Labview application program, wherein part of the front panel control is written according to the record file;
s15: compiling a program diagram of data interaction between the Labview application program and the test template file so as to read the test template file and display the content in the test template file on a test interface;
s16: compiling a program block diagram of data interaction between the Labview application program and the tracing system table; and
s17: and inputting test data of the test items in the test interface to obtain a test result, and recording the test result into the tracing system table.
Further, the method for forming the test data analysis system further includes: the labview application is associated with the MES system. The Labview application program and the MES system are related through a WEB interface. The MES system sends the flow code or the identification number of the product to be tested through the WEB interface, and the Labview returns the test data and the judgment result to the MES system for recording through the WEB interface. The operator can remotely record, query and judge the result through the MES system.
In the embodiment of the invention, the method for establishing the test template file comprises the following steps: and listing the content of the test item in an excel document, and storing the content as an excel file. The contents of the test template file include, but are not limited to: test conditions, test data, upper limits, standard lower limits, test data units, and/or judgment results. For example, referring to fig. 2, taking the Q25 impedance test as an example, the test item name is Q25 impedance test, and the test item may further include a plurality of sub-items, such as a first impedance, a second impedance and a third impedance. In this way, if each test item of each process is pass, the next process can be assembled. And the upper and lower standard limits of the test range are given in units of k Ω. And establishing an excel test template file by taking the contents of the items as rows and the sub-items as columns. For example, in fig. 2, the first impedance, the second impedance and the third impedance are in a column, and the contents of the items in the row are respectively: column B is the test condition (within range), column C is the test data, and since there is no test data yet at this time, the control column is left as the subsequent manual input. The column D is the upper limit value, the column E is the lower limit value, the column F is the unit of the test data, the column G is the judgment result, and after the test data is subsequently input, the judgment is carried out to obtain the judgment result. In other embodiments of the present invention, the content of the item may further include more items, and the sub-items may also further include more items, which are not described herein again.
Furthermore, the number of the test template files is at least one, and when the number of the test template files is at least two, the file names of all the test template files are different. For example, in addition to the Q25 impedance test, there may be tests such as a product status test, a dielectric breakdown test, a MOS detection short circuit test, an air tightness test, a speed regulation test, a load temperature rise test, and a voltage regulation test, and therefore, there are a corresponding number of test template files, each test item is made a test template file according to the previous Q25 impedance test, and the file names cannot be the same. For details, reference is made to the Q25 impedance test, which is not described herein.
Further, the method for recording the name of the test item by using the notepad comprises the following steps: the test item names are listed in a columnar manner within the notepad. After the test template file of each test item is completed, the file names of the test template files are sequentially listed in the notepad, one file name occupies one line and is not provided with a serial number and a punctuation mark, and when a test file template is newly added, the maintenance can be convenient, as shown in fig. 3. And, the suffix name of the record file is. ini.
Further, the method for establishing the trace system table by using the SQLsever database comprises the following steps: establishing a test item, a test serial number, a test sub-item, test data, a judgment result, test time and a tester; and unifying the test items, the test serial numbers, the test sub-items, the test data, the judgment results, the test time and the formats of the testers. In the embodiment of the invention, because the subsequent connection with the MES network is needed, the formats are unified into the JSON format, and in other embodiments of the invention, the formats can be unified into other formats so as to adapt to other websites. The test interface is used for storing the test data, the SQLsever database interacts with the test interface, and the trace system table provides the stored test record for query.
Further, creating a test interface of the Labview application comprises: creating a test information input panel and creating a data query panel. As shown in fig. 4, since the embodiment of the present invention is for electrical actuation detection, the name of the test information input panel is named electrical actuation detection for selection and input of test information, and the data query panel (shown as data records in the figure) can be used for querying the data records. The test information input panel and the data query panel can be switched by an operation user, in addition, each control is arranged on the test page, and other information can be queried through the controls. Therefore, when making this page, it is necessary to write controls, for example, to create an input control, a display control, and a list box, the input control also includes an input of a test template file, as shown in fig. 4, the test table name of one of the input controls, whose function is to select the test template file, and in the list box, the item name recorded in the record file can be selected, where the selectable item name is provided by the content of the record file. The written control also comprises test value data and test procedure name input; the display control is used for displaying date and time, testing serial number and material number codes, displaying data of the PCBA, testing data and finishing time; and the list box displays the contents of the test item template, the voltage, power and resistance data of various measurements in the assembly process test and a judgment result. Wherein: the PCBA control can display the PCBA information of the product; the test serial number control can display the test serial number of the product; and the test result control can display pass and fail, so that an operator can obtain the result of the test data intuitively. In addition, there may be controls such as material coding control, VI description control, process name, completion number, section, return time control, and environment selection control. When an operator manually inputs test data on an electrically-driven detection panel (test information input panel), the Labview application program automatically judges the test data by clicking a test data input finishing control and outputs a test result in a test result column. For example, if the test table name selects the Q25 impedance test, Data is displayed in the Data frame according to the format of the test template file named Q25 impedance test, including measurement conditions, test Data, an upper limit, a lower limit, units and a judgment result, each column displays the values of the contents of the items, the test Data needs to be manually input, after the input is completed, the input of the test Data is clicked, and the judgment result column directly displays the judgment result, such as pass or fail. Similarly, if the Data query panel is selected, the historical Data records can be seen in the Data box, so that query is facilitated.
Further, in step S15, the program diagram of data interaction between the Labview application and the test template file is written as follows: and a program block diagram of a data relation and a processing method corresponding to the content in the Labview application program and the test template file. In step S16, a program diagram of data interaction between the Labview application and the trace back system table is compiled, so that the Labview application writes the test item name and the test item content into the trace back system table according to the test template file. In the whole recording and judging of the test Data, the test template file and the Labview application program are continuously interacted, the SQLsegment database and the Labview application program are also continuously interacted, the SQLsegment database is provided as a database with storage capacity, the test template file provides changeable project contents, and after the test Data analysis system is formed, the contents of the test template file can be directly changed so as to change the contents displayed by a Data frame of an electrically-driven detection panel (test information input panel).
Correspondingly, the invention also provides a test data analysis system, which comprises:
the Excel tool is used for establishing a test template file;
the notebook tool is used for recording the name of the test project and storing the test project as a recording file;
the SQLsever database is used for establishing a tracing system table and storing the content of the test template file and the test result; and
the test interface of the Labview application program comprises an input control, a test information input panel and a test data query panel, wherein the input control is used for inputting test data, the display control is used for displaying a judgment result, the test information input panel is used for displaying the test data and the judgment result according to the content in the test template file, and the test data query panel is used for recording the test data and the judgment result as well as querying the test data and the judgment result.
Further, in the test data analysis system, the method further includes: and the MES system is used for remotely recording the test data and the judgment result and remotely inquiring the test data and the judgment result, and is associated with the Labview application program.
In summary, in the test data analysis system and the forming method provided in the embodiments of the present invention, a test template file is first established, contents to be displayed and determination conditions of the test data are written in the test template file, a Labview application test interface is then created, and the test data and the determination test data are displayed through the Labview application test interface, so that a way of recording test records in a paper report is replaced, and materials are saved. Meanwhile, the Labview application program test interface can be operated by multiple persons.
The above description is only a preferred embodiment of the present invention, and does not limit the present invention in any way. It will be understood by those skilled in the art that various changes, substitutions and alterations can be made herein without departing from the spirit and scope of the invention as defined by the appended claims.

Claims (11)

1. A method of forming a test data analysis system, comprising:
establishing a test template file by using Excel, and naming the test template file by using a test project name;
recording the test project name by using a notebook, and storing the test project name as a recording file;
establishing a tracing system table by using an SQLsever database;
writing a front panel control to create a test interface of a Labview application program, wherein part of the front panel control is written according to the record file;
compiling a program diagram of data interaction between the Labview application program and the test template file so as to read the test template file and display the content in the test template file to the test interface; and
and compiling a program block diagram of data interaction between the Labview application program and the tracing system table.
2. The method of forming a test data analysis system of claim 1, further comprising: and associating the Labview application program with an MES system.
3. The method of forming a test data analysis system of claim 1, wherein creating a test interface for a Labview application comprises: creating a test information input panel and creating a data query panel.
4. The method of forming a test data analysis system of claim 1, wherein the method of creating a test template file comprises: and listing the content of the test item in an excel document, and storing the content as an excel file.
5. The method of forming a test data analysis system of claim 1, wherein the contents of the test template file include: test conditions, test data, upper limits, standard lower limits, test data units, and/or judgment results.
6. The method of forming a test data analysis system according to claim 1, wherein there is at least one test template file, and when there are at least two test template files, file names of all the test template files are different.
7. The method of forming a test data analysis system of claim 1, wherein the method of recording the name of the test item using the notepad comprises: and listing the test item names in a notebook according to a column mode.
8. The method of forming a test data analysis system of claim 1, wherein the record file has a suffix name of.
9. The method of forming a test data analysis system of claim 1, wherein the method of using the SQLsever database to build a trace back system table comprises: establishing a test item, a test serial number, a test sub-item, test data, a judgment result, test time and a tester; and
unifying the test items, the test serial numbers, the test sub-items, the test data, the judgment results, the test time and the formats of the testers.
10. A test data analysis system formed using the method of forming a test data analysis system according to any one of claims 1 to 9, comprising:
the Excel tool is used for establishing a test template file;
the notebook tool is used for recording the name of the test project and storing the test project as a recording file;
the SQLsever database is used for establishing a tracing system table and storing the content of the test template file and the test result; and
the test interface of the Labview application program comprises an input control, a test information input panel and a test data query panel, wherein the input control is used for inputting the test data, the display control is used for displaying a judgment result, the test information input panel is used for displaying the test data and the judgment result according to the content in the test template file, and the test data query panel is used for recording the test data and the judgment result, and querying the test data and the judgment result.
11. The test data analysis system of claim 10, further comprising: and the MES system is used for remotely recording the test data and the judgment result and remotely inquiring the test data and the judgment result, and is associated with the Labview application program.
CN202111675377.3A 2021-12-31 2021-12-31 Test data analysis system and forming method Pending CN114238043A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111675377.3A CN114238043A (en) 2021-12-31 2021-12-31 Test data analysis system and forming method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111675377.3A CN114238043A (en) 2021-12-31 2021-12-31 Test data analysis system and forming method

Publications (1)

Publication Number Publication Date
CN114238043A true CN114238043A (en) 2022-03-25

Family

ID=80745451

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111675377.3A Pending CN114238043A (en) 2021-12-31 2021-12-31 Test data analysis system and forming method

Country Status (1)

Country Link
CN (1) CN114238043A (en)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6442714B1 (en) * 1999-03-17 2002-08-27 Cisco Technology Web-based integrated testing and reporting system
CN103440135A (en) * 2013-09-05 2013-12-11 株洲变流技术国家工程研究中心有限公司 Motor testing port automatic generating method
CN109376069A (en) * 2018-09-03 2019-02-22 中国平安人寿保险股份有限公司 A kind of generation method and equipment of test report

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6442714B1 (en) * 1999-03-17 2002-08-27 Cisco Technology Web-based integrated testing and reporting system
CN103440135A (en) * 2013-09-05 2013-12-11 株洲变流技术国家工程研究中心有限公司 Motor testing port automatic generating method
CN109376069A (en) * 2018-09-03 2019-02-22 中国平安人寿保险股份有限公司 A kind of generation method and equipment of test report

Similar Documents

Publication Publication Date Title
US10534329B2 (en) System and method for improving performance of a plant with a furnace
US8830052B2 (en) Alarm display apparatus and alarm display method
US20180270321A1 (en) Systems and methods for adapting a user interface based on a profile
JPS6332604A (en) System and method for controlling mechanical process by computer
JP4981479B2 (en) Equipment fault diagnosis system
EP2958059A1 (en) Systems and methods for designing an industrial automation system
CN104424539A (en) Maintenance information management system and method, and maintenance information display method
US5541846A (en) Self-improving work instruction system
JP6626630B2 (en) Electronic device evaluation method, apparatus, and storage medium having display in data sheet format
CN109634847A (en) Embedded product automated testing method and system
US11231697B2 (en) Systems and methods for incorporating proxy components in an industrial automation system
CN102621517A (en) Detecting and controlling method in ammeter production process
US8316023B2 (en) Data management system
CN104090186A (en) Analog quantity automatic check system based on safety instrument
Ayağ A hybrid approach to machine-tool selection through AHP and simulation
CN114238043A (en) Test data analysis system and forming method
WO2012006679A1 (en) Engineering quality system
Meeker et al. SPLIDA (S-PLUS life data analysis)
JP5365329B2 (en) Manufacturing failure factor analysis support device
Chang et al. A development of a web-based and user-centered process analysis system for quality improvement
Frey et al. Big graphics and little screens: designing graphical displays for maintenance tasks
CN116610681B (en) Data processing method, device, equipment and computer program for multidimensional table
US11815872B2 (en) Systems, methods and computer program products for automated revision comparison of engineering data in process control systems
CN116781745B (en) Mobile APP system for on-site monitoring of offline environment-friendly industry
Rodrigues et al. I-AM: Interface for Additive Manufacturing.

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

Application publication date: 20220325

RJ01 Rejection of invention patent application after publication