CN101604311A - Breaking away industrial configuration software database interface is realized the method for historical data report - Google Patents
Breaking away industrial configuration software database interface is realized the method for historical data report Download PDFInfo
- Publication number
- CN101604311A CN101604311A CNA2008101811268A CN200810181126A CN101604311A CN 101604311 A CN101604311 A CN 101604311A CN A2008101811268 A CNA2008101811268 A CN A2008101811268A CN 200810181126 A CN200810181126 A CN 200810181126A CN 101604311 A CN101604311 A CN 101604311A
- Authority
- CN
- China
- Prior art keywords
- data
- configuration software
- user
- breaking away
- industrial configuration
- 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
Landscapes
- Stored Programmes (AREA)
Abstract
Breaking away industrial configuration software database interface of the present invention is realized the method for historical data report, comprises following order: select according to the user, determine the type of general-purpose industrial configuration software; Select the OPC/DDE interface function; By the real-time image data of OPC/DDE interface; The data of gathering in real time are saved in the data buffer, wait request to be extracted; According to user's selection, set the type that will generate data sheet; According to user's selection, set the data area that will generate data sheet; Use call function, transfer data from the data that are saved in buffer zone; Generate data sheet.After by above-mentioned method configuration software being operated, can make the configuration software of arbitrary format realize the function that data generate, and preservation that can be real-time and kind and the quantity of on the basis of preserving, making amendment, delete or increase data variable, have simply, at a high speed, arbitrarily, practical characteristics.
Description
Technical field
The present invention relates to from database software, extract the method for data, particularly a kind of method of from any industrial general configuration software, extracting industrial data formation form.
Background technology
The domestic and international industrial general configuration software present situation aspect data sheet at present shows:
(1), import software great majority integrated data form software not, the software that wherein has can select to buy extra assembly realizing the function of data sheet according to client's needs, but this has increased client's use cost undoubtedly;
(2), have in the import software contain data sheet software, but these softwares exist the relatively poor problem of specific aim, the form that made comes out does not satisfy or can not satisfy fully demestic user's requirement;
(3), homemade industrial general class form software contains this partial function, realizes simple browsing data function, but do not have complicated format and data statistics function thereof;
(4), the most important thing is, configuration software commonly used carries out complicated program work to needs user or Development Engineering personnel, user or engineering staff are required certain programming language grounding in basic skills, be not easy to popularize, for the company of utility software, improve the threshold requirement, also just improved cost of labor virtually;
(5), construction cycle of individual data form is long, restriction was more when inquiry was promptly printed;
(6), need database software, or the support in configuration software its data storehouse.
The technical matters that this method solves realizes industrial class data sheet for realizations such as domestic employed import at present and homemade general-purpose industrial configuration software software such as iFix, Wincc, KingView break away from the software ontology database, use unified third party software, adopt unified method to realize the method for arbitrary format data sheet, also do not have such tool software and its implementation at present both at home and abroad.
The soluble problem of this method comprises:
(1), by general-purpose industrial configuration software OPCServer, DDE real time data interface obtains data source;
(2), reduce on the present automation engineering the requirement of slip-stick artist programming language class ability and database knowledge;
(3), the software that adopts this method to realize can be unified construction quality;
(4), the user can use the simple setup parameter of software of Excel instrument and this method establishment to realize data sheet;
(5), the EXCEL file of fast browsing generation.
Summary of the invention
The purpose of this invention is to provide a kind of breaking away industrial configuration software database interface and realize the method for historical data report, realize the arbitrary format configuration software is generated the function of data sheet.
The objective of the invention is to be achieved through the following technical solutions:
Breaking away industrial configuration software database interface is realized the method for historical data report, comprises following order:
A, select, determine the type of general-purpose industrial configuration software according to the user;
B, selection OPC/DDE interface function;
C, by the real-time image data of OPC/DDE interface;
D, the data that will gather in real time are saved in the data buffer, wait request to be extracted;
E, according to user's selection, set the type that will generate data sheet;
F, according to user's selection, set the data area that will generate data sheet;
G, use call function, the data that are saved in buffer zone from step D are transferred data;
H, the data of transferring according to step G and the parameter of setting according to step e, F generate data sheet.
Steps A can select to determine the type of general-purpose industrial configuration software automatically.
The type of data sheet described in the step e comprises EXCEL.
Step e, F order are in no particular order.
The data area of data sheet described in the step F comprises the variable parameter of data initial row/row, termination row/row, zero-time, termination time and other user's needs etc.
The data sheet that step H generated is preserved according to user's needs.
The user can further select to generate new data sheet to the variable parameter in the data sheet that is generated.
After by above-mentioned method configuration software being operated, can make the configuration software of arbitrary format realize the function that data generate, and preservation that can be real-time and kind and the quantity of on the basis of preserving, making amendment, delete or increase data variable, have simply, at a high speed, arbitrarily, practical characteristics.
Description of drawings
Fig. 1 is the process flow diagram of the method for realization industrial configuration software general-purpose interface of the present invention.
Embodiment
The objective of the invention is to be achieved through the following technical solutions:
Breaking away industrial configuration software database interface is realized the method for historical data report, comprises following order:
A, select, determine the type of general-purpose industrial configuration software according to the user;
B, selection OPC/DDE interface function;
C, by the real-time image data of OPC/DDE interface;
D, the data that will gather in real time are saved in the data buffer, wait request to be extracted;
E, according to user's selection, set the type that will generate data sheet;
F, according to user's selection, set the data area that will generate data sheet;
G, use call function, the data that are saved in buffer zone from step D are transferred data;
H, the data of transferring according to step G and the parameter of setting according to step e, F generate data sheet.
Steps A can select to determine the type of general-purpose industrial configuration software automatically.
The type of data sheet described in the step e comprises EXCEL.
Step e, F order are in no particular order.
The data area of data sheet described in the step F comprises the variable parameter of data initial row/row, termination row/row, zero-time, termination time and other user's needs etc.
The data sheet that step H generated is preserved according to user's needs.
The user can further select to generate new data sheet to the variable parameter in the data sheet that is generated.
The support of adopting method of the present invention can make the client break away from database configuration software its data storehouse fully, the perhaps support of third party database software.Realize the extract real-time data, preserve the function of data in real time.
Can be by a kind of approach, the unified mode of choosing data source is provided concerning the user, the user does not just need difference like this, solve which kind of software that the user uses need learn which kind of knowledge frequently extract the user need the problem of data.The user only need know that the mode that a kind of data source is extracted gets final product.Method is easy to realize, has reduced the burden of user learning in a large number.
Adopt instrument commonly used to realize data sheet Stencil Production (for example EXCEL), user and engineering staff only need learn a kind of data sheet template software commonly used and get final product like this, and need not provide instrument separately to go to design and loaded down with trivial details method for designing going to learn every kind of industrial configuration software.
The design masterplate can satisfy the common requirement of users at home and abroad, designs one group of parameter commonly used, can allow the engineering staff finish stamp fabrication, and the user is as long as select according to the needs of oneself.
Can in the process of the data sheet of realizing user's request, not need the user to work out any program and realize data extract, data analysis and data sink general function.Can make the engineering staff can realize each data sheet fast like this.
The user also can revise the kind and the quantity of data layout or deletion, increase data variable in the later maintenance process.
Adopt form instrument (for example EXCEL) commonly used to realize complicated stamp fabrication, Print Preview work comprises that the user can independently revise masterplate work.
Can make the engineering staff realize rapidly the function of data individual data form by above method, have Simply, at a high speed, arbitrarily, practical characteristics.
Claims (7)
1, breaking away industrial configuration software database interface is realized the method for historical data report, comprises following order:
A, select, determine the type of general-purpose industrial configuration software according to the user;
B, selection OPC/DDE interface function;
C, by the real-time image data of OPC/DDE interface;
D, the data that will gather in real time are saved in the data buffer, wait request to be extracted;
E, according to user's selection, set the type that will generate data sheet;
F, according to user's selection, set the data area that will generate data sheet;
G, use call function, the data that are saved in buffer zone from step D are transferred data;
H, the data of transferring according to step G and the parameter of setting according to step e, F generate data sheet.
2, breaking away industrial configuration software database interface according to claim 1 is realized the method for historical data report, it is characterized in that, step e, F order are in no particular order.
3, breaking away industrial configuration software database interface according to claim 1 and 2 is realized the method for historical data report, it is characterized in that, steps A can select to determine the type of general-purpose industrial configuration software automatically.
4, breaking away industrial configuration software database interface according to claim 1 and 2 is realized the method for historical data report, it is characterized in that the type of data sheet described in the step e comprises EXCEL.
5, breaking away industrial configuration software database interface according to claim 1 and 2 is realized the method for historical data report, it is characterized in that the data area of data sheet described in the step F comprises the variable parameter of data initial row/row, termination row/row, zero-time, termination time and other user's needs etc.
6, realize the method for historical data report according to any described breaking away industrial configuration software database interface of claim 1-5, it is characterized in that the data sheet that is generated is preserved according to user's needs.
7, realize the method for historical data report according to any described breaking away industrial configuration software database interface of claim 1-5, it is characterized in that the user can further select to generate new data sheet to the variable parameter in the data sheet that is generated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008101811268A CN101604311A (en) | 2008-11-25 | 2008-11-25 | Breaking away industrial configuration software database interface is realized the method for historical data report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008101811268A CN101604311A (en) | 2008-11-25 | 2008-11-25 | Breaking away industrial configuration software database interface is realized the method for historical data report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101604311A true CN101604311A (en) | 2009-12-16 |
Family
ID=41470046
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2008101811268A Pending CN101604311A (en) | 2008-11-25 | 2008-11-25 | Breaking away industrial configuration software database interface is realized the method for historical data report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101604311A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102663209A (en) * | 2012-04-28 | 2012-09-12 | 楚天科技股份有限公司 | Application of configurable statement on rubber plug or aluminium cap cleaning device |
| CN102831245A (en) * | 2012-09-17 | 2012-12-19 | 洛阳翔霏机电科技有限责任公司 | Real-time data storage and reading method of relational database |
| CN104933546B (en) * | 2014-09-04 | 2017-10-03 | 国网山东省电力公司应急管理中心 | Data reporting method and system based on custom built forms |
-
2008
- 2008-11-25 CN CNA2008101811268A patent/CN101604311A/en active Pending
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102663209A (en) * | 2012-04-28 | 2012-09-12 | 楚天科技股份有限公司 | Application of configurable statement on rubber plug or aluminium cap cleaning device |
| CN102831245A (en) * | 2012-09-17 | 2012-12-19 | 洛阳翔霏机电科技有限责任公司 | Real-time data storage and reading method of relational database |
| CN102831245B (en) * | 2012-09-17 | 2015-08-05 | 洛阳翔霏机电科技有限责任公司 | A kind of real-time data memory of relevant database and read method |
| CN104933546B (en) * | 2014-09-04 | 2017-10-03 | 国网山东省电力公司应急管理中心 | Data reporting method and system based on custom built forms |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103138981B (en) | A kind of social network analysis method and apparatus | |
| CN105426394B (en) | Based on cross-platform mobile report form generation method and system | |
| CN103092890A (en) | System and method for automatic generation and sending of reports | |
| CN103593456B (en) | Worksheet self-defining method for designing and device | |
| CN106951552A (en) | A kind of user behavior data processing method based on Hadoop | |
| CN102708213A (en) | Method for realizing BOM (Bill of Material) information transmission between PDM (Product Data Management) system and ERP (Enterprise Resource Planning) system | |
| CN106709778A (en) | Clothing customization method and device | |
| CN113918533B (en) | Application method of RCS unified message cloud service system based on big data direction | |
| CN105512380A (en) | Hydraulic system CAD collaborative design system and construction method thereof | |
| CN105824944B (en) | A kind of XML configuration data maintaining method and system based on scripting language | |
| CN101604311A (en) | Breaking away industrial configuration software database interface is realized the method for historical data report | |
| CN109408494B (en) | Model production record generation method based on form self-defining function | |
| CN104598622A (en) | Method and system for implementing data modification log as well as application server | |
| CN101604238A (en) | Realize the method for industrial configuration software general-purpose interface | |
| CN101110022A (en) | Method for implementing workflow model by software | |
| CN102521318A (en) | General data exchange device based on extensible markup language (XML) | |
| CN111797178A (en) | Data acquisition and processing method based on report tool | |
| CN101847142A (en) | Web page development method based on data sheet mould encapsulation | |
| CN101609463B (en) | Method for establishing data conversion relation among notes and method for data migration among notes | |
| Šimek et al. | Mobile access to information in the agrarian sector | |
| CN106940724B (en) | Multi-paradigm fusion analysis processing method for big data | |
| CN105574002A (en) | SQL database-data file transmission method | |
| CN104636446B (en) | A kind of legacy Web application mobile edition method for transformation based on cloud computing mode | |
| CN105515822A (en) | Internet architecture driven by big data and realization method | |
| CN104462205B (en) | A kind of adaptive method for organizing of manufacture system based on dynamic knowledge net |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20091216 |