CN109508953B - Form template generation method - Google Patents
Form template generation method Download PDFInfo
- Publication number
- CN109508953B CN109508953B CN201811250662.9A CN201811250662A CN109508953B CN 109508953 B CN109508953 B CN 109508953B CN 201811250662 A CN201811250662 A CN 201811250662A CN 109508953 B CN109508953 B CN 109508953B
- Authority
- CN
- China
- Prior art keywords
- data
- monitoring data
- database
- production
- data model
- 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.)
- Active
Links
Images
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
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Data Mining & Analysis (AREA)
- Artificial Intelligence (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a table template generation method, which comprises the following steps: acquiring monitoring data in a production process and establishing a production database; extracting tool icons in the tool area and indexing the tool icons with the monitoring data in the production database; establishing a data model for the indexed monitoring data and the indexed icons; setting a reference path in a cell, and referencing the reference path to a background operation area; applying the established data model in a background operation area and connecting a reference path; the method solves the technical problem that the table in the system can only select the preset table template by establishing the data model, and autonomously configures the table module according to the requirement, thereby realizing the operation diversification in the actual production and meeting the condition of the actual production requirement.
Description
Technical Field
The invention relates to the field of enterprise transaction management, in particular to a form template generation method.
Background
The workflow technology of the production process of the process enterprise aims to solve the production coordination problem of a plurality of links in the production process of a complex process. Manufacturing Execution System (MES) is an information execution system facing to the inter-vehicle layer between a plan management system on the upper layer of a production type enterprise and an industrial control system on the field layer, and performs production information management and data processing on the whole production process from production order issuing to product completion, including the contents of order data issuing, production instruction data issuing, production process execution monitoring, field production data acquisition, data statistical processing and reporting, and the like, and is the key for realizing production information processing and man-machine interaction in a complex flow production process.
Although the introduction of the MES system in modern enterprises can improve the production efficiency, in the prior art, the MES system monitors various data in the production process and acquires various forms by extracting the monitored data, but the forms in the system can only select a preset form template, and a form module cannot be configured autonomously as required, so that the operation is simplified, and the actual production requirements cannot be met.
Disclosure of Invention
The invention provides a form template generation method, which aims to solve the technical problem that a form in a system can only select a preset form template, so that a form module is configured autonomously according to needs, operation diversification in actual production is further realized, and the condition of actual production requirements is met.
In order to solve the above technical problem, an embodiment of the present invention provides a form template generating method, including:
acquiring monitoring data in a production process and establishing a production database;
extracting tool icons in the tool area and indexing the tool icons with the monitoring data in the production database;
establishing a data model for the indexed monitoring data and the indexed icons;
setting a reference path in a cell, and referencing the reference path to a background operation area;
the built data model is applied to a background operating area and the reference path is connected.
As a preferred scheme, the acquiring monitoring data in the production process to establish a production database includes:
acquiring monitoring data in a production process, and carrying out threshold processing on the monitoring data;
extracting events from the monitoring data subjected to threshold processing to generate event rising edges and event falling edges;
calculating absolute values of the event rising edge and the event falling edge, and eliminating invalid monitoring data by setting an error value and deleting the absolute value events larger than the error value;
and integrating the monitoring data after the invalid monitoring data are removed, and establishing a production database.
Preferably, the extracting the tool icon in the tool area and indexing the tool icon with the monitoring data in the production database includes:
acquiring a tool icon in a tool area, and extracting the tool icon;
and according to the product in actual production and the corresponding product data, carrying out relevant correspondence on the extracted tool icon and the monitoring data in the production database, and indexing the tool icon and the monitoring data.
As a preferred scheme, the establishing a data model for the indexed monitoring data and the indexed icons includes:
copying the production database into a training database and a testing database, and respectively storing the indexed production data and tool icons in the training database and the testing database;
establishing a data model, transmitting data in the training database to the data model for repeated training, extracting a feature integration data structure, and stopping training until a training threshold and training accuracy are reached;
and transmitting the data in the test database to the integrated data model, repeatedly testing the data model, and optimizing the data model until the test threshold and the test accuracy are reached.
As a preferred scheme, the setting a reference path in a cell and referencing the reference path to a background operation area includes:
calling a cell program command, and setting a reference path for the cell;
associating the reference path into all cells;
and the reference path is referred to a background operation area through a background starting program, and the background operation area is started after the cell is triggered to enter a configuration interface.
Preferably, the applying the created data model in a background operation area and connecting the reference path includes:
applying the established data model to a background operation area through a background starting program, and storing the data model in a background server;
and connecting the reference path with the data model to realize that the data model is started after the cell is triggered to enter a configuration interface, and calling the tool icon and the production data associated with the tool icon.
Preferably, the tool icons include characters, lines and figures.
Preferably, the set error value is 5.
Preferably, the training threshold is 20 ten thousand times, and the training accuracy is 90%.
Preferably, the test threshold is 20 ten thousand times, and the test accuracy is 90%.
Compared with the prior art, the embodiment of the invention has the following beneficial effects:
the technical problem that the form in the system can only select the preset form template is solved by establishing a data model, and the form module is configured autonomously according to needs, so that the operation diversification in the actual production is realized, and the condition of the actual production requirement is met.
Drawings
FIG. 1: is a flow chart of the concrete steps of the embodiment of the table template generation method of the invention;
FIG. 2: a detailed flowchart of step S1 in the embodiment of the table template generating method of the present invention;
FIG. 3: a detailed flowchart of step S2 in the embodiment of the table template generating method of the present invention;
FIG. 4: a detailed flowchart of step S3 in the embodiment of the table template generating method of the present invention;
FIG. 5: a detailed flowchart of step S4 in the embodiment of the table template generating method of the present invention;
FIG. 6: a detailed flowchart of step S5 in the embodiment of the table template generating method of the present invention;
FIG. 7: an example of step S1 in the form template generating method of the present invention is shown.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, a preferred embodiment of the present invention provides a form template generating method, including:
s1, acquiring monitoring data in the production process and establishing a production database;
s2, extracting the tool icon in the tool area and indexing the tool icon with the monitoring data in the production database;
s3, establishing a data model for the indexed monitoring data and the indexed icons;
s4, setting a reference path in the cell, and referencing the reference path to the background operation area;
and S5, applying the established data model in a background operation area and connecting the reference path.
Referring to fig. 2 and fig. 7, in this embodiment, the step S1 of acquiring the monitoring data in the production process to establish the production database includes:
s11, acquiring monitoring data in the production process, and performing threshold processing on the monitoring data;
s12, extracting events from the monitoring data after threshold processing, and generating event rising edges and event falling edges;
s13, calculating absolute values of the event rising edge and the event falling edge, and eliminating invalid monitoring data by setting an error value and deleting the absolute value events larger than the error value;
and S14, integrating the monitoring data after the invalid monitoring data are removed, and establishing a production database.
Referring to fig. 3, in this embodiment, the extracting and indexing the tool icon in the tool area and the monitoring data in the production database in step S2 includes:
s21, acquiring the tool icons in the tool area, and extracting the tool icons;
and S22, according to the products in actual production and the corresponding product data, carrying out relevant correspondence on the extracted tool icons and the monitoring data in the production database, and indexing the tool icons and the monitoring data.
Referring to fig. 4, in this embodiment, the establishing a data model for the indexed monitoring data and the indexed icon in step S3 includes:
s31, copying the production database into a training database and a testing database, and respectively storing the indexed production data and tool icons in the training database and the testing database;
s32, establishing a data model, transmitting the data in the training database to the data model for repeated training, extracting a feature integration data structure, and stopping training until a training threshold and training accuracy are reached;
and S33, transmitting the data in the test database to the integrated data model, repeatedly testing the data model, and optimizing the data model until reaching the test threshold and the test accuracy.
Referring to fig. 5, in this embodiment, the setting, in the step S4, a referring path in a cell, and referring the referring path to a background operation area includes:
s41, calling a cell program command, and setting a reference path for the cell;
s42, associating the reference path to all cells;
and S43, the reference path is referred to the background operation area through the background starting program, the background operation area is started after the cell is triggered, and the configuration interface is entered.
Referring to fig. 6, in this embodiment, applying the created data model in the step S5 to the background operation area and connecting the reference path includes:
s51, applying the established data model to a background operation area through a background starting program, and storing the data model in a background server;
and S52, connecting the reference path with the data model, starting the data model after triggering the cell to enter a configuration interface, and calling the tool icon and the production data associated with the tool icon.
In this embodiment, the tool icons include text, lines, and graphics.
In the present embodiment, the set error value is 5.
In this embodiment, the training threshold is 20 ten thousand times, and the training accuracy is 90%.
In this embodiment, the test threshold is 20 ten thousand times, and the test accuracy is 90%.
In the embodiment, the specific implementation flow of the invention is as follows:
firstly, acquiring monitoring data in a production process, performing threshold processing on the monitoring data, extracting events from the monitoring data subjected to threshold processing, generating event rising edges and event falling edges, calculating absolute values of the event rising edges and the event falling edges, deleting events with the absolute values larger than the error value of 5 by setting an error value, rejecting invalid monitoring data, integrating the monitoring data from which the invalid monitoring data are rejected, and establishing a production database; then, characters, lines and figures in the tool area are obtained, the characters, the lines and the figures are extracted, the extracted characters, the lines and the figures are related and correspond to monitoring data in a production database according to products and corresponding product data in actual production, and the characters, the lines and the figures and the monitoring data are indexed; then copying the production database into a training database and a testing database, respectively storing the indexed production data, characters, lines and figures in the training database and the testing database, establishing a data model, transmitting the data in the training database to the data model for repeated training, extracting a characteristic integration data structure, stopping training until a training threshold value of 20 ten thousand times and a training accuracy of 90% are reached, transmitting the data in the testing database to the integrated data model, repeatedly testing the data model, optimizing the data model, and stopping testing until the testing threshold value of 20 ten thousand times and the testing accuracy of 90% are reached; furthermore, a cell program command is called, a quote path is set for the cell, the quote path is associated to all the cells, the quote path is quoted to a background operation area through a background starting program, the background operation area is started after the cell is triggered, and a configuration interface is entered; and finally, applying the established data model to a background operation area through a background starting program, storing the data model in a background server, connecting the reference path with the data model, starting the data model after triggering the cell to enter a configuration interface, and calling characters, lines and graphs and production data related to the characters, lines and graphs.
The invention solves the technical problem that the form in the system can only select the preset form template by establishing the data model, and autonomously configures the form module according to the requirement, thereby realizing the operation diversification in the actual production and meeting the condition of the actual production requirement.
The above-mentioned embodiments are provided to further explain the objects, technical solutions and advantages of the present invention in detail, and it should be understood that the above-mentioned embodiments are only examples of the present invention and are not intended to limit the scope of the present invention. It should be understood that any modifications, equivalents, improvements and the like, which come within the spirit and principle of the invention, may occur to those skilled in the art and are intended to be included within the scope of the invention.
Claims (6)
1. A form template generation method, comprising:
acquiring monitoring data in a production process and establishing a production database;
extracting tool icons in the tool area and indexing the tool icons with the monitoring data in the production database;
establishing a data model for the indexed monitoring data and the indexed icons;
setting a reference path in a cell, and referencing the reference path to a background operation area;
applying the established data model in a background operation area and connecting a reference path;
the establishing of the data model for the indexed monitoring data and the indexed icons comprises the following steps:
copying the production database into a training database and a testing database, and respectively storing the indexed production data and tool icons in the training database and the testing database;
establishing a data model, transmitting data in the training database to the data model for repeated training, extracting a feature integration data structure, and stopping training until a training threshold and training accuracy are reached;
transmitting the data in the test database to the integrated data model, repeatedly testing the data model, optimizing the data model, and stopping testing until a test threshold and test accuracy are reached;
the applying the established data model in a background operation area and connecting the reference path comprises the following steps:
applying the established data model to a background operation area through a background starting program, and storing the data model in a background server;
and connecting the reference path with the data model to realize that the data model is started after the cell is triggered to enter a configuration interface, and calling characters, lines and graphs and production data related to the characters, lines and graphs.
2. The form template generating method of claim 1, wherein said obtaining monitoring data in a production process creates a production database comprising:
acquiring monitoring data in a production process, and carrying out threshold processing on the monitoring data;
extracting events from the monitoring data subjected to threshold processing to generate event rising edges and event falling edges;
calculating absolute values of the event rising edge and the event falling edge, and eliminating invalid monitoring data by setting an error value and deleting the absolute value events larger than the error value;
and integrating the monitoring data after the invalid monitoring data are removed, and establishing a production database.
3. The form template generation method of claim 1, wherein said extracting tool icons in a tool field and indexing with monitoring data in the production database comprises:
acquiring a tool icon in a tool area, and extracting the tool icon;
and according to the product in actual production and the corresponding product data, carrying out relevant correspondence on the extracted tool icon and the monitoring data in the production database, and indexing the tool icon and the monitoring data.
4. The form template generation method of claim 1, wherein setting a reference path in a cell and referencing the reference path to a background operating area comprises:
calling a cell program command, and setting a reference path for the cell;
associating the reference path into all cells;
and the reference path is referred to a background operation area through a background starting program, and the background operation area is started after the cell is triggered to enter a configuration interface.
5. The form template generating method of claim 2, wherein the set error value is 5.
6. The form template generation method of claim 1, wherein the training threshold is 20 ten thousand times and the training accuracy is 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 CN109508953A (en) | 2019-03-22 |
| CN109508953B true 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) |
Families Citing this family (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 |
| CN113032633B (en) * | 2021-04-15 | 2022-03-08 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20060102402A (en) * | 2005-03-23 | 2006-09-27 | 김민수 | Merlin templete form |
| CN103530127B (en) * | 2013-10-22 | 2017-08-29 | 北京奇虎科技有限公司 | icon display method and device |
| CN104778241B (en) * | 2015-04-08 | 2019-06-04 | 北京京东尚科信息技术有限公司 | A kind of report form generation method and system |
| CN105447174B (en) * | 2015-12-09 | 2019-02-15 | 中国农业银行股份有限公司 | A kind of report generation method and device |
| EP3296864A1 (en) * | 2016-09-20 | 2018-03-21 | Siemens Aktiengesellschaft | Storing and retrieving documentation |
| CN106547729B (en) * | 2016-12-01 | 2019-02-01 | 长城计算机软件与系统有限公司 | A kind of dynamic creation method and system of data sheet |
| CN108664638B (en) * | 2018-05-15 | 2019-12-10 | 口碑(上海)信息技术有限公司 | report generation method and device based on index system |
-
2018
- 2018-10-25 CN CN201811250662.9A patent/CN109508953B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN109508953A (en) | 2019-03-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6901243B2 (en) | Systems and methods for optimizing control systems for process environments | |
| CN111857470B (en) | Unattended control method and device for production equipment and controller | |
| CN111538731B (en) | Automatic report generation system for industrial data | |
| CN109508953B (en) | Form template generation method | |
| CN103077448A (en) | CAPP (computer aided progress planning) system of sheetmetal | |
| CN112561370B (en) | Method and device for managing software release, computer equipment and storage medium | |
| CN113409555B (en) | Real-time alarm linkage method and system based on Internet of things | |
| CN113947468B (en) | Data management method and platform | |
| CN109522536B (en) | Automatic form filling method | |
| CN111651968A (en) | Automatic EXCEL report generation method and system and information data processing terminal | |
| CN109492209B (en) | Automatic generation method of form signature column | |
| CN109446182B (en) | Composite acquisition method | |
| CN112633850A (en) | Method for realizing service flow automation by managing, calling and monitoring RPA robot | |
| CN109376159B (en) | Batch record automatic generation method | |
| CN114860346B (en) | Modeling task management method and modeling task operation method | |
| CN109242357B (en) | Process editing method of MES system | |
| CN114756468A (en) | Test data creating method, device, equipment and storage medium | |
| CN107992995A (en) | A kind of method and system for creating technological process title | |
| CN112287021A (en) | Data real-time synchronization parameter generation method, data real-time synchronization parameter synchronization method, data real-time synchronization parameter generation device, data real-time synchronization parameter synchronization device, storage medium and terminal | |
| CN116431698B (en) | Data extraction method, device, equipment and storage medium | |
| CN110569868A (en) | Dangerous work standard management system and management method thereof | |
| CN216751819U (en) | Intelligent detection system based on 5G communication technology | |
| CN114090548B (en) | Database-based data processing method, device, equipment and storage medium | |
| CN115187025A (en) | Manufacturing software molding system and method thereof | |
| CN114755979A (en) | Die numerical control programming method, system and device |
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 |