CN103049558A - Method and system for generating report forms in Factory Talk View SE (site edition) configuration environment - Google Patents
Method and system for generating report forms in Factory Talk View SE (site edition) configuration environment Download PDFInfo
- Publication number
- CN103049558A CN103049558A CN2012105892519A CN201210589251A CN103049558A CN 103049558 A CN103049558 A CN 103049558A CN 2012105892519 A CN2012105892519 A CN 2012105892519A CN 201210589251 A CN201210589251 A CN 201210589251A CN 103049558 A CN103049558 A CN 103049558A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- vba
- analysis
- database
- 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
- 238000000034 method Methods 0.000 title claims abstract description 56
- 238000004891 communication Methods 0.000 claims abstract description 37
- 238000004519 manufacturing process Methods 0.000 claims abstract description 26
- 238000012545 processing Methods 0.000 claims abstract description 19
- 230000007246 mechanism Effects 0.000 claims abstract description 15
- 238000013480 data collection Methods 0.000 claims description 35
- 238000007405 data analysis Methods 0.000 claims description 25
- 230000008569 process Effects 0.000 claims description 14
- 238000004458 analytical method Methods 0.000 claims description 8
- 230000008859 change Effects 0.000 claims description 6
- 230000006870 function Effects 0.000 claims description 6
- 238000013523 data management Methods 0.000 claims description 5
- 238000007726 management method Methods 0.000 claims description 5
- 239000000203 mixture Substances 0.000 claims description 5
- 241001269238 Data Species 0.000 claims description 3
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000002955 isolation Methods 0.000 claims description 3
- 238000004064 recycling Methods 0.000 claims description 3
- 238000004321 preservation Methods 0.000 claims description 2
- 230000000007 visual effect Effects 0.000 abstract description 2
- 238000005516 engineering process Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 3
- 238000012544 monitoring process Methods 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000007812 deficiency Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
Images
Landscapes
- General Factory Administration (AREA)
Abstract
The invention relates to a method and a system for automatically generating report forms in an upper computer of an industrial automatic control system, in particular to a method and a system for generating report forms in the Factory Talk View SE (site edition) configuration environment. Steps of data acquisition and report form generation include 1), establishing an access mechanism of real-time data in the Factory Talk View SE (site edition) configuration environment; 2) writing data of a data acquirer into a database of access through VBA (visual basic for application) codes; 3) establishing a trigger mechanism for recording and write-in database programs; and 4), reading ADO (active data object) communication from the Access to EXCEL by the VBA: generating an EXCEL report form template by means of the VBA codes and reading content of the Access database into the EXCEL sheet. The system comprises a distributed server, a distributed controller, a central processing unit, a data acquirer and a data acquisition terminal, wherein the distributed server is connected with the distributed controller and used for storing, analyzing and computing various production data of an assembly line and generating the report forms, and accordingly provides database support for the method.
Description
Technical field
The present invention relates to how host computer carries out the automatic collection of process signal in a kind of Automation Control System on Industry, analyze, and the method and system of automatic report generation.
Background technology
At present, form is the important component part of process of factory production analysis and control management as the powerful measure of a kind of Information Organization and analysis.Development along with computer technology and industrial automation monitoring technique, each main flow monitoring and control configuration software all provides the database interface scheme to the exploitation of reporting system, automatic generation for form, realize that original on-the-spot write by hand arrangement develops into remote monitoring, automatically record, and analyze that provide may.Do not provide this function in the import main flow automated system manufacturer configuration software, if the data analysis software cost of buying special use is very high.FactoryTalk View Site Edition(is FactoryTalk View SE, hereinafter to be referred as SE) be a member in the FactoryTalk of the RockWell company groupware product as the upgraded version of RsView SE.It is for the integrated software package of developing and move multi-user, distributed server man-machine interface application item, aims at automation process and monitors and control design.The Visual Basic For Application(VBA that it is embedded), provide perfect development environment for self-defined and expansion software function.Under SE monitoring software environment, obtain data source two kinds of methods are arranged: the one, the access history data storehouse, the 2nd, the access real-time data base, the access method of two kinds of databases is different.Historical data base can be directly as the data source of reporting system, but because historical data base and the close relation of configuration software own, form is fixed, thereby causes the access method complexity, and historical data base is huger, is not suitable for the too much data of single treatment.
Summary of the invention
The present invention is directed to the prior art deficiency, propose auto report completing method and system under a kind of FactoryTalk View SE configuration environment.The method is simple to operate, be fit to flexibly, very much industry control personnel operation at different levels.
The technical solution adopted in the present invention:
Content of the present invention is: utilize the embedded VBA function of Factory Talk View SE configuration environment by the coding code, and utilize the ADO Principle of Communication regularly to deposit the purpose that Access database and Access database and Excel software carry out exchanges data and generating report forms in to reach field data.
Data collection and analysis and report form generation method under a kind of FactoryTalk View SE configuration environment, at distributed controller operation FactoryTalk View SE, then the data acquisition unit that connects is scanned and connect, connect with specified data and be in normal operating conditions; The step of data acquisition and report generation comprises:
1) set up the access mechanism of real time data under the FactoryTalk View SE configuration environment:
At first according to the label that in VBA, will use among the SE, set up set of tags object TagGpObj, then the Add method of utilizing the set of tags object adds the set of tags object with concrete label, the Item attribute of recycling set of tags object with the value of tagging give label among the VBA;
2) data communication device of data acquisition unit is crossed the database that the VBA code writes Access:
The label value that obtains in VBA is stored in the Access database by the mode of ADO communication, and the composition data source is inquired about at any time for data management system;
3) set up the trigger mechanism that records the data writing library:
Use the variable reading system time, and the Change event of utilizing this variable is as trigger condition, the creation facilities program (CFP) trigger mechanism regularly writes described database to determine the real time data in the described data acquisition unit;
4) realize that VBA reads Access and communicates by letter to the ADO of EXCEL:
The content of utilizing the VBA code to generate the EXCEL report form template and reading the Access database is in Microsoft Excel.
Data collection and analysis and report generating system under a kind of FactoryTalk View SE configuration environment comprise: distributed server, distributed controller, central processing unit, data acquisition unit and data collection station;
Described distributed server is connected with distributed controller, be used for to realize storage, analysis, statistics and the generating report forms of the various production datas of production line, thereby provides the database support for described method;
Described distributed controller is as the main control part of system, be connected with described data acquisition unit, be used for the data of the described data acquisition unit of real-time collecting, described data are carried out initial analysis, the result who processes, regularly collects, processes to each distributed server storage;
Described data acquisition unit is connected with described data collection station, is used for realizing that the described electric signal that the data acquisition terminal is passed over carries out Isolation, reads and stores, and in real time data is sent to described distributed controller;
Described data collection station is used for on-the-spot production information is converted to described electric signal, and passes to described data acquisition unit.
Be connected with communication unit with described distributed controller, be used under the control of described distributed controller, production control information being passed to central processing unit in real time, thereby the production management personnel can being responded to production information in time; Described communication unit also passes to each distributed controller and distributed server in real time with on-the-spot real time data;
Described distributed formula controller comprises control module and interface unit, is respectively applied to Data Collection, analysis and control to system, and carries out communication with described central processing unit; Described control module has system state detecting unit, data-reading unit and also contains data write unit; Described interface unit contains RS232 interface, Ethernet interface and ControlNet interface;
Described data acquisition unit comprises communication unit, central processing unit, communication base plate, PLC analog module and the signal isolated location that connects successively; Wherein communication module is used for carrying out exchanges data with described distributed controller, control provides physical link; Central processing unit is used for realizing the data of described PLC analog module are carried out data-switching, realizes that electric signal is to the conversion of real physical; The communication base plate provides physical link for described communication unit, central processing unit, PLC analog module; Described signal isolated location is used for the various undesired signals from production line are isolated, and prevents that unsafe event from occuring.
Described data collection and analysis and report generating system also comprise the report inquiring system that is connected with described distributed server, be used for realization the historical record of the production information of described distributed server storage is inquired about and printed.
Useful good effect of the present invention:
1, auto report completing method of the present invention, flexible design, simple to operate, replaced artificial loaded down with trivial details notes process, the saving human cost is remarkable.Through the Practical Project checking, flexibility and reliability, easy to operate, have widely use value.Utilize the database interface of configuration software adopt the VBA instrument write one can automatic data collection and the method for generating report forms (data source is with some cycles collection and storage field data, and data management system is responsible for selecting data and generating report forms according to different requirements from data source.The method can with configuration project seamless combination, better through on-the-spot result of use.
2, report automatic generatioin system of the present invention, automatic controlling level is high, and real-time is high, and data recording is more accurate, and reliability is high.Use VBA access real-time data base, extract the field instrument data and deposit the third party database of independent foundation in, as data source, produce corresponding form according to different demands, simple to operate, flexibly, very be fit to industry control personnel operation at different levels.The data base management system (DBMS) that the present invention relates to uses the VBA code to write fully, combines together fully with SE, and the generation of form does not need to switch to other environment and can directly generate by button click.
Description of drawings
Fig. 1: data collection and analysis and report form generation method program mechanism synoptic diagram under the FactoryTalk ViewSE configuration environment of the present invention;
Fig. 2: data collection and analysis and report form generation method data scanning linked, diagram under the FactoryTalk ViewSE configuration environment of the present invention;
Fig. 3: data collection and analysis and report form generation method system chart under the FactoryTalk ViewSE configuration environment of the present invention;
Fig. 4: auto report completing method operating process synoptic diagram under the FactoryTalk View SE configuration environment of the present invention;
Fig. 5: automatically generated data Report Operations picture in the production technology;
Fig. 6: the form that generates in the production technology.
Embodiment
Embodiment one: referring to Fig. 1, Fig. 2, data collection and analysis and report form generation method under the FactoryTalk View SE configuration environment of the present invention, at distributed controller operation FactoryTalk View SE, then the data acquisition unit that connects is scanned and connect, be in normal operating conditions with the specified data link, the step of its data acquisition and report generation comprises:
1) set up the access mechanism of real time data under the FactoryTalk View SE configuration environment:
At first according to the label that in VBA, will use among the SE, set up set of tags object TagGpObj, then the Add method of utilizing the set of tags object adds the set of tags object with concrete label, the Item attribute of recycling set of tags object with the value of tagging give label among the VBA;
2) data communication device of data acquisition unit is crossed the database that the VBA code writes Access:
The label value that obtains in VBA is stored in the Access database by the mode of ADO communication, and the composition data source is inquired about at any time for data management system;
3) set up the trigger mechanism that records the data writing library:
Use the variable reading system time, and the Change event of utilizing this variable is as trigger condition, the creation facilities program (CFP) trigger mechanism regularly writes described database to determine the real time data in the described data acquisition unit;
4) realize that VBA reads Access and communicates by letter to the ADO of EXCEL:
The content of utilizing the VBA code to generate the EXCEL report form template and reading the Access database is in Microsoft Excel.
Embodiment two: ADO is ActiveX Data Objects, be by Microsoft release take one group the senior automation application layer interface based on OLE DB data of ActiveX technology as the basis, be a kind of novel data access method.
Data collection and analysis and report form generation method under the present embodiment FactoryTalk View SE configuration environment are with the difference of embodiment one:
The label value that obtains in VBA is stored in composition data source in the Access database by the mode of ADO communication, can inquire about at any time use for data management system.Concrete steps are as follows:
A. defining first a name is called variable and the name that the cnn type is ADODB.Connection and is called two variablees that the SQL type is character string;
B. the ConnectionString attribute of the particular content assignment of database connection string to cnnStr;
C. the particular content assignment of data base query language to the SQL variable;
D. carry out the open method of cnn;
E. carry out the Execute method of cnn, call simultaneously SQL as parameter;
F. carry out the close method of cnn, and cnn is set is nothing;
G. described Access data-base content is detected, find that data exceed the preservation timeliness, namely delete it.
Embodiment three: data collection and analysis and report form generation method under the present embodiment FactoryTalk View SE configuration environment, be with the difference of embodiment two: the program that record writes the Access database is by the VBA code and utilize the ADO Principle of Communication to write, and step is as follows:
A. set up record and write Access database program trigger mechanism, the data recording of reporting system is usually in integral point or least bit time trigger, because VBA does not have the control of Timer and so on, so use the variable reading system time, and to utilize the Change event of this variable be a kind of simple effective method as trigger condition;
B. global schema give a definition timer as the set of tags object and with the MM of Event Function as label;
C. in the Display_AnimationStart of picture () process to the timer object value, and to wherein add among the SE label system Minute;
D. judge in the MM_Change event whether the current time arrive the least bit, if so, just carry out the command statement in data inserting storehouse.
Embodiment four: referring to Fig. 4, Fig. 5, Fig. 6.Data collection and analysis and report form generation method under the present embodiment FactoryTalk View SE configuration environment, be with the difference of aforementioned each embodiment: in the step 4), when the user on described distributed controller, when clicking the report generation button, described distributed controller automatically performs and calls the report generation code, preserves or prints in order to generate required form.
Embodiment five: referring to Fig. 3.Present embodiment is a kind of embodiment of data collection and analysis and report generating system under the FactoryTalk View SE configuration environment.System comprises distributed server, distributed controller, central processing unit, data acquisition unit and data collection station; Wherein:
Described distributed server is connected with distributed controller, be used for to realize storage, analysis, statistics and the generating report forms of the various production datas of production line, thereby provides the database support for described method;
Described distributed controller is as the main control part of system, be connected with described data acquisition unit, be used for the data of the described data acquisition unit of real-time collecting, described data are carried out initial analysis, the result who processes, regularly collects, processes to each distributed server storage;
Described data acquisition unit is connected with described data collection station, is used for realizing that the described electric signal that the data acquisition terminal is passed over carries out Isolation, reads and stores, and in real time data is sent to described distributed controller;
Described data collection station is used for on-the-spot production information is converted to described electric signal, and passes to described data acquisition unit.
Be connected with communication unit with described distributed controller, be used under the control of described distributed controller, production control information being passed to central processing unit in real time, thereby the production management personnel can being responded to production information in time; Described communication unit also passes to each distributed controller and distributed server in real time with on-the-spot real time data.
Embodiment six: the data collection and analysis of present embodiment and report generating system, different from embodiment five is: described distributed formula controller comprises control module and interface unit, be respectively applied to Data Collection, analysis and control to system, and carry out communication with described central processing unit; Described control module has system state detecting unit, data-reading unit and also contains data write unit; Described interface unit contains RS232 interface, Ethernet interface and ControlNet interface.
Embodiment seven: the data collection and analysis of present embodiment and report generating system, and different from embodiment five or embodiment six is: described data acquisition unit comprises communication unit, central processing unit, communication base plate, PLC analog module and the signal isolated location that connects successively; Wherein communication module is used for carrying out exchanges data with described distributed controller, control provides physical link; Central processing unit is used for realizing the data of described PLC analog module are carried out data-switching, realizes that electric signal is to the conversion of real physical; The communication base plate provides physical link for described communication unit, central processing unit, PLC analog module; Described signal isolated location is used for the various undesired signals from production line are isolated, and prevents that unsafe event from occuring.
Claims (9)
1. data collection and analysis and report form generation method under the FactoryTalk View SE configuration environment, at distributed controller operation FactoryTalk View SE, then the data acquisition unit that connects is scanned and connect, connect with specified data and be in normal operating conditions; It is characterized in that: the step of data acquisition and report generation comprises:
1) set up the access mechanism of real time data under the FactoryTalk View SE configuration environment:
At first according to the label that in VBA, will use among the SE, set up set of tags object TagGpObj, then the Add method of utilizing the set of tags object adds the set of tags object with concrete label, the Item attribute of recycling set of tags object with the value of tagging give label among the VBA;
2) data communication device of data acquisition unit is crossed the database that the VBA code writes Access:
The label value that obtains in VBA is stored in the Access database by the mode of ADO communication, and the composition data source is inquired about at any time for data management system;
3) set up the trigger mechanism that records the data writing library:
Use the variable reading system time, and the Change event of utilizing this variable is as trigger condition, the creation facilities program (CFP) trigger mechanism regularly writes described database to determine the real time data in the described data acquisition unit;
4) realize that VBA reads Access and communicates by letter to the ADO of EXCEL:
The content of utilizing the VBA code to generate the EXCEL report form template and reading the Access database is in Microsoft Excel.
2. data collection and analysis according to claim 1 and report form generation method is characterized in that:
Step 2) in, the label value that obtains in VBA is as follows by the concrete steps that the ADO communication mode is stored in composition data source in the Access database:
A. defining first a name is called variable and the name that the cnn type is ADODB.Connection and is called two variablees that the SQL type is character string;
B. the ConnectionString attribute of the particular content assignment of database connection string to cnnStr;
C. the particular content assignment of data base query language to the SQL variable;
D. carry out the open method of cnn;
E. carry out the Execute method of cnn, call simultaneously SQL as parameter;
F. carry out the close method of cnn, and cnn is set is nothing;
G. described Access data-base content is detected, find that data exceed the preservation timeliness, namely delete it.
3. data collection and analysis according to claim 1 and report form generation method is characterized in that: in the step 3), by the VBA code and utilize the ADO communication mode that the step that record writes the Access database is as follows:
A. set up record and write Access database program trigger mechanism, the data recording of reporting system is used the variable reading system time usually in integral point or least bit time trigger, and the Change event of utilizing this variable is as trigger condition;
B. global schema give a definition timer as the set of tags object and with the MM of Event Function as label;
C. in the Display_AnimationStart of picture () process to the timer object value, and to wherein add among the SE label system Minute;
D. judge in the MM_Change event whether the current time arrive the least bit, if so, just carry out the command statement in data inserting storehouse.
4. data collection and analysis according to claim 2 and report form generation method is characterized in that: in the step 3), by the VBA code and utilize the ADO communication mode that the step that record writes the Access database is as follows:
A. set up record and write Access database program trigger mechanism, the data recording of reporting system is used the variable reading system time usually in integral point or least bit time trigger, and the Change event of utilizing this variable is as trigger condition;
B. global schema give a definition timer as the set of tags object and with the MM of Event Function as label;
C. in the Display_AnimationStart of picture () process to the timer object value, and to wherein add among the SE label system Minute;
D. judge in the MM_Change event whether the current time arrive the least bit, if so, just carry out the command statement in data inserting storehouse.
5. according to claim 1～4 each described data collection and analysis and report form generation method, it is characterized in that: in the step 4), when the user on described distributed controller, when clicking the report generation button, described distributed controller automatically performs and calls the report generation code, preserves or prints in order to generate required form.
6. data collection and analysis and report generating system under the FactoryTalk View SE configuration environment comprise: distributed server, distributed controller, central processing unit, data acquisition unit and data collection station; It is characterized in that:
Described distributed server is connected with distributed controller, be used for to realize storage, analysis, statistics and the generating report forms of the various production datas of production line, thereby provides the database support for described method;
Described distributed controller is as the main control part of system, be connected with described data acquisition unit, be used for the data of the described data acquisition unit of real-time collecting, described data are carried out initial analysis, the result who processes, regularly collects, processes to each distributed server storage;
Described data acquisition unit is connected with described data collection station, is used for realizing that the described electric signal that the data acquisition terminal is passed over carries out Isolation, reads and stores, and in real time data is sent to described distributed controller;
Described data collection station is used for on-the-spot production information is converted to described electric signal, and passes to described data acquisition unit.
7. data collection and analysis according to claim 6 and report generating system, it is characterized in that: comprise the communication unit that is connected with described distributed controller, be used under the control of described distributed controller, production control information is passed to central processing unit in real time, thereby the production management personnel can be responded to production information in time; Described communication unit also passes to each distributed controller and distributed server in real time with on-the-spot real time data.
8. according to claim 6 or 7 described data collection and analysis and report generating systems, it is characterized in that: described distributed formula controller comprises control module and interface unit, be respectively applied to Data Collection, analysis and control to system, and carry out communication with described central processing unit; Described control module has system state detecting unit, data-reading unit and also contains data write unit; Described interface unit contains RS232 interface, Ethernet interface and ControlNet interface.
9. according to data collection and analysis claimed in claim 8 and report generating system, it is characterized in that: data acquisition unit comprises communication unit, central processing unit, communication base plate, PLC analog module and the signal isolated location that connects successively; Wherein communication module is used for carrying out exchanges data with described distributed controller, control provides physical link; Central processing unit is used for realizing the data of described PLC analog module are carried out data-switching, realizes that electric signal is to the conversion of real physical; The communication base plate provides physical link for described communication unit, central processing unit, PLC analog module; Described signal isolated location is used for the various undesired signals from production line are isolated, and prevents that unsafe event from occuring.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012105892519A CN103049558A (en) | 2012-12-31 | 2012-12-31 | Method and system for generating report forms in Factory Talk View SE (site edition) configuration environment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012105892519A CN103049558A (en) | 2012-12-31 | 2012-12-31 | Method and system for generating report forms in Factory Talk View SE (site edition) configuration environment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103049558A true CN103049558A (en) | 2013-04-17 |
Family
ID=48062199
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012105892519A Pending CN103049558A (en) | 2012-12-31 | 2012-12-31 | Method and system for generating report forms in Factory Talk View SE (site edition) configuration environment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103049558A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103295101A (en) * | 2013-05-30 | 2013-09-11 | 福建四创软件有限公司 | Method for automatically generating disaster-prevention consultation report material |
| CN104320477A (en) * | 2014-10-31 | 2015-01-28 | 上海许继电气有限公司 | Method and system for achieving photovoltaic power station data processing based on distributed servers |
| CN104503744A (en) * | 2014-12-08 | 2015-04-08 | 金川集团股份有限公司 | Automatic report form generating method for mine filling technology |
| CN104914760A (en) * | 2015-05-12 | 2015-09-16 | 山东成泰化工有限公司 | Chromatography analysis data submission control method and device |
| CN105528666A (en) * | 2014-10-25 | 2016-04-27 | 国家电网公司 | Comprehensive report generation method of transformer station |
| CN104483038B (en) * | 2014-12-09 | 2018-07-24 | 中国电建集团贵阳勘测设计研究院有限公司 | Method for extracting target point temperature in DTS optical fiber temperature measurement host |
| CN108334477A (en) * | 2018-01-30 | 2018-07-27 | 深圳壹账通智能科技有限公司 | Implementation method, device, computer equipment and the storage medium of Intelligent file |
| CN109086015A (en) * | 2018-08-28 | 2018-12-25 | 中航三鑫太阳能光电玻璃有限公司 | A kind of method of solar energy photovoltaic glass production line case ticket automatic printing |
| CN109783496A (en) * | 2019-01-14 | 2019-05-21 | 东北大学 | Data collection and processing automation tools and application method based on Excel&VBA |
| CN110502522A (en) * | 2019-08-30 | 2019-11-26 | 携程计算机技术（上海）有限公司 | Report processing system and method |
| CN111459111A (en) * | 2020-04-13 | 2020-07-28 | 昱源宁海环保科技股份有限公司 | Application system of DCS in ceramsite production line |
| CN113191128A (en) * | 2021-05-24 | 2021-07-30 | 中国工商银行股份有限公司 | Report form checking tool generation method and device and electronic equipment |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101158859A (en) * | 2007-10-29 | 2008-04-09 | 中兴通讯股份有限公司 | Defect data real time collecting device and method thereof, and production line real-time data capturing system |
| CN101419448A (en) * | 2007-10-24 | 2009-04-29 | 中兴通讯股份有限公司 | Production line real time acquiring and data accounting system and method |
-
2012
- 2012-12-31 CN CN2012105892519A patent/CN103049558A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101419448A (en) * | 2007-10-24 | 2009-04-29 | 中兴通讯股份有限公司 | Production line real time acquiring and data accounting system and method |
| CN101158859A (en) * | 2007-10-29 | 2008-04-09 | 中兴通讯股份有限公司 | Defect data real time collecting device and method thereof, and production line real-time data capturing system |
Non-Patent Citations (2)
| Title |
|---|
| 孙云辉等: "FactoryTalk View SE组态环境下报表系统的开发", 《制造业自动化》 * |
| 康英等: "利用VBA实现FactoryTalk View SE报表功能", 《电气传动自动化》 * |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103295101A (en) * | 2013-05-30 | 2013-09-11 | 福建四创软件有限公司 | Method for automatically generating disaster-prevention consultation report material |
| CN105528666A (en) * | 2014-10-25 | 2016-04-27 | 国家电网公司 | Comprehensive report generation method of transformer station |
| CN104320477A (en) * | 2014-10-31 | 2015-01-28 | 上海许继电气有限公司 | Method and system for achieving photovoltaic power station data processing based on distributed servers |
| CN104503744A (en) * | 2014-12-08 | 2015-04-08 | 金川集团股份有限公司 | Automatic report form generating method for mine filling technology |
| CN104483038B (en) * | 2014-12-09 | 2018-07-24 | 中国电建集团贵阳勘测设计研究院有限公司 | Method for extracting target point temperature in DTS optical fiber temperature measurement host |
| CN104914760A (en) * | 2015-05-12 | 2015-09-16 | 山东成泰化工有限公司 | Chromatography analysis data submission control method and device |
| CN108334477A (en) * | 2018-01-30 | 2018-07-27 | 深圳壹账通智能科技有限公司 | Implementation method, device, computer equipment and the storage medium of Intelligent file |
| CN109086015A (en) * | 2018-08-28 | 2018-12-25 | 中航三鑫太阳能光电玻璃有限公司 | A kind of method of solar energy photovoltaic glass production line case ticket automatic printing |
| CN109783496A (en) * | 2019-01-14 | 2019-05-21 | 东北大学 | Data collection and processing automation tools and application method based on Excel&VBA |
| CN109783496B (en) * | 2019-01-14 | 2023-04-18 | 东北大学 | Excel & VBA-based data collection and processing automation tool and using method |
| CN110502522A (en) * | 2019-08-30 | 2019-11-26 | 携程计算机技术（上海）有限公司 | Report processing system and method |
| CN110502522B (en) * | 2019-08-30 | 2022-11-29 | 携程计算机技术（上海）有限公司 | Report processing system and method |
| CN111459111A (en) * | 2020-04-13 | 2020-07-28 | 昱源宁海环保科技股份有限公司 | Application system of DCS in ceramsite production line |
| CN113191128A (en) * | 2021-05-24 | 2021-07-30 | 中国工商银行股份有限公司 | Report form checking tool generation method and device and electronic equipment |
| CN113191128B (en) * | 2021-05-24 | 2024-03-19 | 中国工商银行股份有限公司 | Report checking tool generation method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103049558A (en) | Method and system for generating report forms in Factory Talk View SE (site edition) configuration environment | |
| US10996660B2 (en) | Augmented manufacturing system | |
| CN104036375B (en) | Storage data based on the goods and materials dynamic tracking of bar code processes system and method | |
| CN112668355B (en) | Maintenance enterprise intelligent tool management system based on RFID technology | |
| EP3336639B1 (en) | Asset management of field devices | |
| CN107945307B (en) | Railway equipment tracking management system | |
| CN112734207A (en) | Asset operation and maintenance management method and system | |
| CN116300736A (en) | MES-based digital factory twin management system, platform and method | |
| CN110223768A (en) | A kind of Medical Devices data supervision system and its operation method based on two dimensional code | |
| CN104866619A (en) | Data monitoring method and system for data warehouse | |
| CN110503273A (en) | One kind being based on satellite dynamic two-dimension code intelligent patrol repair method and system | |
| CN105160477A (en) | RFID-based geographical position simulation positioning method and asset equipment management system using the method | |
| CN111624960A (en) | Intelligent remote parameter monitoring system of manned spacecraft manufacturing equipment production line | |
| CN219716141U (en) | Distributed operation system of intelligent factory | |
| CN105335770A (en) | Abnormal production event real-time management system | |
| CN104766107A (en) | System utilizing RFID electronic product code to collect data in BIM | |
| CN113867286B (en) | 3D visualization intelligent control system and production system for nuclear industry production lines | |
| US11815872B2 (en) | Systems, methods and computer program products for automated revision comparison of engineering data in process control systems | |
| CN112734059A (en) | Water plant equipment point inspection information management system, method and storage medium | |
| Budak et al. | Design of an RFID-based manufacturing monitoring and analysis system | |
| CN104123759A (en) | Plant inspection method and system | |
| CN116156428A (en) | Workshop personnel information management and control method and system based on digital twinning | |
| CN206378742U (en) | A kind of AGV data collocation systems | |
| CN118351609B (en) | A multi-mode mutual verification intelligent inspection system and method | |
| CN117077040B (en) | Large-scale complex equipment fault diagnosis and prediction system based on machine learning |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130417 |