CN109508953A - A kind of form template generation method - Google Patents
A kind of form template generation method Download PDFInfo
- Publication number
- CN109508953A CN109508953A CN201811250662.9A CN201811250662A CN109508953A CN 109508953 A CN109508953 A CN 109508953A CN 201811250662 A CN201811250662 A CN 201811250662A CN 109508953 A CN109508953 A CN 109508953A
- Authority
- CN
- China
- Prior art keywords
- data
- monitoring data
- database
- reference path
- form template
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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
Abstract
The invention discloses a kind of form template generation methods, comprising: the monitoring data obtained in production process establishes Production database；The tool icon in extracting tool area is simultaneously indexed with the monitoring data in the Production database；To after being indexed monitoring data and icon establish data model；The setting reference path in cell, and the reference path is referred into consistency operation area；The data model of foundation is applied in consistency operation area and connects reference path；The case where the technical issues of the method for the present invention can only select preset form template by the table established in data model solution system, autonomous configuration table module as needed realizes operation diversification in actual production, meets actual production demand.
Description
Technical field
The present invention relates to business affair management domain more particularly to a kind of form template generation methods.
Background technique
Process Industry production process workflow technology is to solve the production of multiple links in Complicated Flow production process
Research on Interactive Problem.MES (manufacturingexecutionsystem, manufacturing execution system) is to be located at production enterprise upper layer
Information towards shop layer between project management system and the industrial control system of field layer executes system, to from production order
Under reach the entire production process of product completion and carry out production information management and data processing, including order data is assigned, is produced
Director data is assigned, production process executes monitoring, Field Production Data acquisition, data statistics processing and the contents such as reports, and is multiple
Miscellaneous process production process realizes the key of production information processing and human-computer interaction.
Although MES system can be improved production efficiency in the introducing of modern enterprise, in the prior art, MES system
A variety of data in monitoring industrial processes, by extracting a variety of tables of data acquisition of monitoring, but the table in system can only
Select preset form template, and cannot autonomous configuration table module as needed, cause to operate unification, be not able to satisfy reality
Production requirement.
Summary of the invention
The present invention provides a kind of form template generation methods, can only select preset table with the table in solution system
The technical issues of template, thus autonomous configuration table module as needed, and then realize operation diversification in actual production, it is full
The case where full border production requirement.
In order to solve the above-mentioned technical problem, the embodiment of the invention provides a kind of form template generation methods, comprising:
The monitoring data obtained in production process establishes Production database；
The tool icon in extracting tool area is simultaneously indexed with the monitoring data in the Production database；
To after being indexed monitoring data and icon establish data model；
The setting reference path in cell, and the reference path is referred into consistency operation area；
The data model of foundation is applied in consistency operation area and connects reference path.
Preferably, the monitoring data obtained in production process establishes Production database, comprising:
The monitoring data in production process is obtained, and threshold process is carried out to the monitoring data；
Event is extracted to the monitoring data after progress threshold process, generates event rising edge and event failing edge；
The absolute value for calculating the event rising edge and event failing edge, by step-up error value, and to greater than error amount
Absolute value event deleted, reject invalid monitoring data；
Monitoring data after the monitoring data invalid to rejecting is integrated, and Production database is established.
Preferably, the tool icon in the extracting tool area and with the monitoring data in the Production database
It is indexed, comprising:
The tool icon in Accessorial Tools Storage is obtained, described the tool icon is extracted；
According in actual production product and corresponding product data, by the tool icon of extraction and the Production database
In monitoring data carry out related corresponding, and described the tool icon and the monitoring data are indexed.
Preferably, described pair be indexed after monitoring data and icon establish data model, comprising:
By the Production database by copying as tranining database and test database, by the production number after index
It is separately stored in the tranining database and the test database according to the tool icon；
Data model is established, the data in above-mentioned tranining database are transferred to data model and carry out repetition training, are extracted
Feature integration data structure, until reaching deconditioning after trained threshold value and training accuracy；
Data in the test database are transferred in the data model after integration, data model is surveyed repeatedly
Examination optimizes data model, until stopping test after reaching test threshold and test accuracy.
Preferably, the setting reference path in cell, and the reference path is referred into backstage and is grasped
Make area, comprising:
Reference path is arranged to the cell in call unit lattice program command；
The reference path is associated in all cells；
The reference path is referred into consistency operation area by backstage startup program, after starting after realization trigger unit lattice
Platform operating space, into configuration interface.
It is preferably, described that the data model of foundation is applied in consistency operation area and connects reference path, comprising:
The data model of foundation is applied in consistency operation area by backstage startup program, is stored in background server；
The reference path is connect with the data model, realize that trigger unit lattice enter after configuration interface and enable described in
Data model, calls tool icon and the creation data being associated.
Preferably, described the tool icon includes text, lines and figure.
Preferably, the error amount of the setting is 5.
Preferably, the trained threshold value is 200,000 times, and the training accuracy is 90%.
Preferably, the test threshold is 200,000 times, and the test accuracy is 90%.
Compared with the prior art, the embodiment of the present invention has the following beneficial effects:
The technical issues of can only selecting preset form template by the table established in data model solution system, according to
The case where needing autonomous configuration table module, realizing operation diversification in actual production, meet actual production demand.
Detailed description of the invention
Fig. 1: for the specific steps flow chart of form template generation method embodiment of the present invention；
Fig. 2: for the specific flow chart of step S1 in form template generation method embodiment of the present invention；
Fig. 3: for the specific flow chart of step S2 in form template generation method embodiment of the present invention；
Fig. 4: for the specific flow chart of step S3 in form template generation method embodiment of the present invention；
Fig. 5: for the specific flow chart of step S4 in form template generation method embodiment of the present invention；
Fig. 6: for the specific flow chart of step S5 in form template generation method embodiment of the present invention；
Fig. 7: for the example schematic of step S1 in form template generation method embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
Fig. 1 is please referred to, the preferred embodiment of the present invention provides a kind of form template generation method, comprising:
S1, the monitoring data obtained in production process establish Production database；
S2, the tool icon in extracting tool area are simultaneously indexed with the monitoring data in the Production database；
S3, to after being indexed monitoring data and icon establish data model；
S4, the setting reference path in cell, and the reference path is referred into consistency operation area；
The data model of foundation is applied in consistency operation area and connects reference path by S5.
Referring to Fig. 2 and Fig. 7, the monitoring data obtained in production process in the present embodiment, in the step S1 establishes life
Produce database, comprising:
S11 obtains the monitoring data in production process, and carries out threshold process to the monitoring data；
S12 extracts event to the monitoring data after progress threshold process, generates event rising edge and event decline
Edge；
S13 calculates the absolute value of the event rising edge and event failing edge, misses by step-up error value, and to being greater than
The absolute value event of difference is deleted, and invalid monitoring data is rejected；
S14 integrates to the monitoring data after invalid monitoring data is rejected, establishes Production database.
Referring to Fig. 3, in the present embodiment, the tool icon in the step S2 in extracting tool area and with the production number
It is indexed according to the monitoring data in library, comprising:
S21 obtains the tool icon in Accessorial Tools Storage, extracts to described the tool icon；
S22, according in actual production product and corresponding product data, by the tool icon of extraction and the production number
It is corresponding that correlation is carried out according to the monitoring data in library, and described the tool icon and the monitoring data are indexed.
Referring to Fig. 4, in the present embodiment, in the step S3 to after being indexed monitoring data and icon establish data
Model, comprising:
S31, by the Production database by copying as tranining database and test database, by the life after index
It produces data and the tool icon is separately stored in the tranining database and the test database；
S32 establishes data model, and the data in above-mentioned tranining database are transferred to data model and carry out repetition training,
Feature integration data structure is extracted, until reaching deconditioning after trained threshold value and training accuracy；
Data in the test database are transferred in the data model after integration by S33, are carried out to data model anti-
Repetition measurement examination, optimizes data model, until stopping test after reaching test threshold and test accuracy.
Referring to Fig. 5, in the present embodiment, in the step S4 in cell setting reference path, and by the reference
Path refers to consistency operation area, comprising:
Reference path is arranged to the cell in S41, call unit lattice program command；
The reference path is associated in all cells by S42；
The reference path is referred to consistency operation area by backstage startup program, opened after realizing trigger unit lattice by S43
Dynamic consistency operation area, into configuration interface.
The data model of foundation is applied in consistency operation Qu Binglian in the step S5 in the present embodiment referring to Fig. 6
Connect reference path, comprising:
The data model of foundation is applied in consistency operation area by backstage startup program, is stored in background server by S51
In；
The reference path is connect by S52 with the data model, is realized and is enabled after trigger unit lattice enter configuration interface
The data model, calls tool icon and the creation data being associated.
In the present embodiment, described the tool icon includes text, lines and figure.
In the present embodiment, the error amount of the setting is 5.
In the present embodiment, the trained threshold value is 200,000 times, and the training accuracy is 90%.
In the present embodiment, the test threshold is 200,000 times, and the test accuracy is 90%.
In embodiment, specific implementation process of the invention is as follows:
Firstly, obtaining the monitoring data in production process, and threshold process is carried out to the monitoring data, to progress threshold value
Monitoring data that treated extracts event, generates event rising edge and event failing edge, calculate the event rising edge and
The absolute value of event failing edge is deleted by step-up error value, and to the absolute value event that error amount is 5 is greater than, is rejected
Invalid monitoring data is integrated to the monitoring data after invalid monitoring data is rejected, establishes Production database；Then,
Text, lines and the figure in Accessorial Tools Storage are obtained, the text, lines and figure are extracted, according in actual production
Product and corresponding product data carry out the monitoring data in the text, lines and figure of extraction and the Production database
Correlation is corresponding, and is indexed to the text, lines and figure and the monitoring data；Then, by the Production database
By copying as tranining database and test database, creation data and text, the lines and figure after index are distinguished
It is stored in the tranining database and the test database, establishes data model, by the data in above-mentioned tranining database
It is transferred to data model and carries out repetition training, extract feature integration data structure, until reaching trained threshold value 200,000 times and training
Data in the test database are transferred in the data model after integration, to data by deconditioning after accuracy 90%
Model is tested repeatedly, optimizes data model, until stopping surveying after reaching test threshold 200,000 times and test accuracy 90%
Examination；Further, call unit lattice program command is arranged reference path to the cell, the reference path is associated with
In all cells, the reference path is referred into consistency operation area by backstage startup program, realizes trigger unit lattice
Start consistency operation area afterwards, into configuration interface；Finally, the data model of foundation is applied on backstage by backstage startup program
Operating space is stored in background server, and the reference path is connect with the data model, realizes that trigger unit lattice enter
The data model is enabled after configuration interface, calls text, lines and figure and the creation data being associated.
The present invention can only select the technology of preset form template to ask by the table established in data model solution system
Topic, autonomous configuration table module as needed realize operation diversification in actual production, meet the feelings of actual production demand
Condition.
Particular embodiments described above has carried out further the purpose of the present invention, technical scheme and beneficial effects
It is described in detail, it should be understood that the above is only a specific embodiment of the present invention, the protection being not intended to limit the present invention
Range.It particularly points out, to those skilled in the art, all within the spirits and principles of the present invention, that is done any repairs
Change, equivalent replacement, improvement etc., should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of form template generation method characterized by comprising
The monitoring data obtained in production process establishes Production database；
The tool icon in extracting tool area is simultaneously indexed with the monitoring data in the Production database；
To after being indexed monitoring data and icon establish data model；
The setting reference path in cell, and the reference path is referred into consistency operation area；
The data model of foundation is applied in consistency operation area and connects reference path.
2. form template generation method as described in claim 1, which is characterized in that the monitoring number obtained in production process
According to establishing Production database, comprising:
The monitoring data in production process is obtained, and threshold process is carried out to the monitoring data；
Event is extracted to the monitoring data after progress threshold process, generates event rising edge and event failing edge；
The absolute value for calculating the event rising edge and event failing edge, by step-up error value, and to exhausted greater than error amount
Value event is deleted, invalid monitoring data is rejected；
Monitoring data after the monitoring data invalid to rejecting is integrated, and Production database is established.
3. form template generation method as described in claim 1, which is characterized in that the tool icon in the extracting tool area
And it is indexed with the monitoring data in the Production database, comprising:
The tool icon in Accessorial Tools Storage is obtained, described the tool icon is extracted；
According in actual production product and corresponding product data, will be in the tool icon of extraction and the Production database
It is corresponding that monitoring data carries out correlation, and is indexed to described the tool icon and the monitoring data.
4. form template generation method as described in claim 1, which is characterized in that described pair be indexed after monitoring data
Data model is established with icon, comprising:
By the Production database by copying as tranining database and test database, by by index after creation data and
The tool icon is separately stored in the tranining database and the test database；
Data model is established, the data in above-mentioned tranining database are transferred to data model and carry out repetition training, extract feature
Integral data structure, until reaching deconditioning after trained threshold value and training accuracy；
Data in the test database are transferred in the data model after integration, data model is tested repeatedly,
Optimize data model, until stopping test after reaching test threshold and test accuracy.
5. form template generation method as described in claim 1, which is characterized in that the setting reference road in cell
Diameter, and the reference path is referred into consistency operation area, comprising:
Reference path is arranged to the cell in call unit lattice program command；
The reference path is associated in all cells；
The reference path is referred into consistency operation area by backstage startup program, starting backstage is grasped after realizing trigger unit lattice
Make area, into configuration interface.
6. form template generation method as described in claim 1, which is characterized in that described to apply the data model of foundation
Consistency operation area simultaneously connects reference path, comprising:
The data model of foundation is applied in consistency operation area by backstage startup program, is stored in background server；
The reference path is connect with the data model, realizes and enables the data after trigger unit lattice enter configuration interface
Model, calls tool icon and the creation data being associated.
7. form template generation method as described in claim 1, which is characterized in that described the tool icon includes text, lines
And figure.
8. form template generation method as claimed in claim 2, which is characterized in that the error amount of the setting is 5.
9. form template generation method as claimed in claim 4, which is characterized in that the trained threshold value is 200,000 times, described
Training accuracy be 90%.
10. form template generation method as claimed in claim 4, which is characterized in that the test threshold is 200,000 times, described
Test accuracy be 90%.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811250662.9A CN109508953B (en) | 2018-10-25 | 2018-10-25 | Form template generation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811250662.9A CN109508953B (en) | 2018-10-25 | 2018-10-25 | Form template generation method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109508953A true CN109508953A (en) | 2019-03-22 |
| CN109508953B CN109508953B (en) | 2020-10-09 |
Family
ID=65745979
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811250662.9A Active CN109508953B (en) | 2018-10-25 | 2018-10-25 | Form template generation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109508953B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110197142A (en) * | 2019-05-16 | 2019-09-03 | 谷东科技有限公司 | Object identification method, device, medium and terminal device under faint light condition |
| CN113032633A (en) * | 2021-04-15 | 2021-06-25 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20060102402A (en) * | 2005-03-23 | 2006-09-27 | 김민수 | Merlin templete form |
| CN103530127A (en) * | 2013-10-22 | 2014-01-22 | 北京奇虎科技有限公司 | Icon display method and device |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
| CN105447174A (en) * | 2015-12-09 | 2016-03-30 | 中国农业银行股份有限公司 | Report generation method and apparatus |
| CN106547729A (en) * | 2016-12-01 | 2017-03-29 | 长城计算机软件与系统有限公司 | A kind of dynamic creation method and system of data sheet |
| EP3296864A1 (en) * | 2016-09-20 | 2018-03-21 | Siemens Aktiengesellschaft | Storing and retrieving documentation |
| CN108664638A (en) * | 2018-05-15 | 2018-10-16 | 口碑(上海)信息技术有限公司 | Report form generation method based on index system and device |
-
2018
- 2018-10-25 CN CN201811250662.9A patent/CN109508953B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20060102402A (en) * | 2005-03-23 | 2006-09-27 | 김민수 | Merlin templete form |
| CN103530127A (en) * | 2013-10-22 | 2014-01-22 | 北京奇虎科技有限公司 | Icon display method and device |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
| CN105447174A (en) * | 2015-12-09 | 2016-03-30 | 中国农业银行股份有限公司 | Report generation method and apparatus |
| EP3296864A1 (en) * | 2016-09-20 | 2018-03-21 | Siemens Aktiengesellschaft | Storing and retrieving documentation |
| CN106547729A (en) * | 2016-12-01 | 2017-03-29 | 长城计算机软件与系统有限公司 | A kind of dynamic creation method and system of data sheet |
| CN108664638A (en) * | 2018-05-15 | 2018-10-16 | 口碑(上海)信息技术有限公司 | Report form generation method based on index system and device |
Non-Patent Citations (1)
| Title |
|---|
| 孙明珠等: "基于广源报表的Word 表格数据自动获取方法研究", 《测控技术》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110197142A (en) * | 2019-05-16 | 2019-09-03 | 谷东科技有限公司 | Object identification method, device, medium and terminal device under faint light condition |
| CN113032633A (en) * | 2021-04-15 | 2021-06-25 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| CN113032633B (en) * | 2021-04-15 | 2022-03-08 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109508953B (en) | 2020-10-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107045526A (en) | A kind of pattern recognition method of electronics architectural working drawing | |
| CN111552700A (en) | Intelligent audit platform for dynamically auditing project construction process of power system | |
| CN102496083B (en) | Credit rating report manuscript manufacturing method | |
| CN101620691A (en) | Automatic data mining platform in telecommunications industry | |
| CN104599024A (en) | Generation system of welding process guide system for structural part | |
| CN108985471B (en) | Aircraft management system based on 3D lightweight model | |
| CN108764610A (en) | Standard technology construction management of project method based on big data, storage medium | |
| CN109508953A (en) | A kind of form template generation method | |
| WO2024060725A1 (en) | Aircraft tool change method and apparatus, device, and storage medium | |
| CN112395317A (en) | Method for collaborative design and achievement management of data model | |
| CN111651968A (en) | Automatic EXCEL report generation method and system and information data processing terminal | |
| CN109522536A (en) | A kind of table Auto-writing method | |
| CN105335459A (en) | XBRL intelligent report platform based statement consolidation data extraction method | |
| CN107193736A (en) | Method of testing, device, electronic equipment and storage medium | |
| CN109446182A (en) | A kind of compound acquisition method | |
| CN109492209A (en) | A kind of table signature automatic generation method | |
| CN112287021B (en) | Method and device for generating and synchronizing real-time data synchronization parameters, storage medium and terminal | |
| CN109376159A (en) | A kind of batch record automatic generation method | |
| CN113342987A (en) | Composite network construction method of special corpus for power distribution DTU acceptance | |
| CN114328452A (en) | Data auditing method, device, platform, electronic equipment and storage medium | |
| CN107040564A (en) | Method of data synchronization, data synchronization server and the cloud storage system of cloud storage | |
| CN110674631A (en) | Software defect automatic assignment method and system based on version submission information | |
| CN117635072A (en) | Quality inspection and evaluation form filling evaluation method, system and storage medium | |
| US20220237388A1 (en) | Method and apparatus for generating table description text, device and storage medium | |
| CN116431698B (en) | Data extraction method, device, equipment and storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |