Self-checking method for graph and document in product data management system
Technical Field
The invention relates to the technical field of product data management systems, in particular to a self-checking method for graphs and documents in a product data management system.
Background
By analyzing and counting data of the current domestic manufacturing industry, most enterprises use a product data management system for managing complex product data, various graphs and documents which are researched and produced by the product data management system are examined and signed, and relevant standards of all units of the graphs and documents are defined for ensuring the consistency of the graphs and the documents in order to ensure the unified management of the product data. About four images and documents can not pass through once in the filing link because the images and the documents can not meet the standard and are rejected and modified, thereby reducing the publishing efficiency of the images and the documents and influencing the manufacturing production of the whole product.
The image-text quality and the image-text label checking efficiency are important links related to the whole life cycle of a product, how to realize the error correction check of a product data management system on the image-text is a difficult point of informatization, visual and flexible self-service check tools are not provided by image-text self-check designers, the error correction is carried out in real time in the design process, the problem is avoided at the initial design stage, the accuracy and the consistency of product data are realized,
aiming at the existing problems, most enterprises adopt a design that whether a picture and a document to be submitted meet requirements is checked by themselves before submitting and approving, for most designers, the work is busy every day, the careful inspection of each picture and document ensures that no problem is not realistic, the problem is that the picture and document are submitted once and checked once, and signers need to check related contents in all signing and auditing links, and the release time is multiplied because the same work needs to be done once in all links.
Disclosure of Invention
The present invention is directed to solving, at least to some extent, one of the technical problems in the related art. Therefore, one purpose of the invention is to provide a diagram and document self-checking method in a product data management system, the image-text uploading condition of the invention can be tracked in real time, the monitoring can be realized, the text self-checking rule can be expanded, the text checking is explicit, a designer is assisted to quickly locate problems, the text error correction process can be traced, the image-text error probability is displayed from different dimensions, the macroscopic display of the image-text problem is in a serious disaster area, the text quality is continuously improved, the text approval process period is shortened, and the purposes of reducing the cost, shortening the period and improving the efficiency are achieved.
The invention discloses a diagram and document self-checking method in a product data management system, which comprises the following steps:
s1: classifying and summarizing the problems through data analysis, finding out the correlation, extracting rules, establishing program coding rules by means of informatization, and carrying out rule configuration on the problems;
s2: when the document is submitted for approval, pattern self-checking and document self-checking are firstly carried out, the monitored problems are directly exposed, and the submission is not allowed before the problems are not solved; and the self-checking result can be displayed in each link in the signing and reviewing process, and the whole self-checking result is transmitted to the whole graph and document filing and publishing implementation.
Preferably, the S1 step includes:
s11: extracting and analyzing data for different units due to failure of filing, classifying and summarizing the problems, and performing large-class summarization;
s12: then, dividing related subclasses under each major class;
s13: according to the classification statistical result, the error occurrence frequency, the influence degree and the like can be evaluated, which errors can be checked through computer rules before the pictures and the documents are submitted can be determined, and meanwhile, the problems which can be checked through the computer can be marked;
s14: if the error type is identified in the result formed in S13, the error type is encoded and the corresponding correct rule is stored in a background database according to the error;
s15: and reading the source file uploaded by the design by the background and the rule in the database for comparison, and if the result of reading the source file is consistent with the rule of the database, the file is passed, otherwise, the file is not passed.
Preferably, the broad categories of the taxonomy aggregate include BOMs, attributes, and covers.
Preferably, the rule configuration comprises a document self-check item configuration and a pattern self-check item configuration;
document self-checking item configuration: configuring the document self-checking items required to be performed according to the data analysis result; the method mainly aims at the fact that programs can be configured in other word file areas, such as headers, footers and covers (mainly composed of specific tables), and each check point has a coordinate configuration (such as (docNumber 1,1, 1.) which can be automatically expanded according to requirements.
Pattern self-check item configuration: and configuring according to the data analysis result mainly aiming at the structural attribute consistency of the BOM, the integrity of the BOM related patterns and the correctness of pattern uploading.
The rules for configuring the self-checking items comprise enforcement and prompting, wherein the enforcement represents that the self-checking items do not conform to the configuration rules and do not allow the self-checking items to pass through, and the prompting represents that the self-checking items do not satisfy the rules but can be ignored.
Preferably, the database is Oracle.
Preferably, the S2 step includes:
s21: the rule formed by aiming at the codes is self-checked before drawing submission and document reviewing each time;
s22: the system exposes the problems in the source file as much as possible according to the configuration rule and displays the problems through a graphical interface;
s23: the system provides a negligible option in the checked problem, if the designer believes that the source file itself is not a problem, it is a system configuration problem, and the option can be chosen to be ignored, otherwise the modification is completed.
Preferably, the step S2 further includes that each time a self-check is required before submitting a checkup, the system records a question that occurs as a result of each self-check, the system does not allow submission until the last found problem is not solved, if the last modification is completed but other correct rules are destroyed in the operation process, an error correction record is formed for each time, and each error correction process can be found in the system.
Preferably, the document self-check includes obtaining document content to be self-checked and obtaining entity document attributes:
acquiring the content of a document to be self-checked: for the configuration of the document self-checking item, reading the content of a Word document by adopting common WordExtractor in java for checking, reading the table content according to the configured coordinates, and if the checking configuration of the table is (1,1, 1.,) then the first 1 represents the first table, the second 1 is the first row, and the third 1 is the first column, thus the relevant self-checking content can be obtained, and the configuration such as font, size and the like can be expanded; meanwhile, related content of a header footer can also be acquired, the acquired table content is stored according to a Map set and is used as original content to be compared, the key value is check item of the configuration file, if (docNumber is 1,1, 1.), the key value is docNumber, and the value is word content corresponding to the coordinates.
Acquiring entity document attributes: each Word document has a related document entity corresponding to it, while the Word document to be compared is obtained, the contents of the document entity to which it belongs, such as the entity number, name, version, stage, file code number, etc., are obtained, the attributes of the entity document and the stored result of the previous Word content are compared in an information matching manner, if the numbering content corresponds to the DocNumber in the Map set, the corresponding relations need to be clearly configured in advance in the configuration of the self-check item, so that the program can dynamically compare information in the execution process, if the results of the two comparisons are consistent, the self-check is passed, otherwise, the self-check is not passed.
Preferably, the pattern self-check comprises a basic information self-check and a pattern correlation self-check;
self-checking basic information: and taking the information of the top BOM as basic information, storing the basic information needing to be checked, obtaining the BOM information of each level in a deep traversal mode, comparing the BOM information with the information of the top node, and keeping the relevant information of each lower BOM node consistent with the top information of the BOM.
Self-checking pattern relevance: and acquiring BOM information of each level and acquiring BOM-associated drawing information at the same time, comparing according to the service configuration rule, if the BOM information is in charge of the service configuration rule, passing self-checking, and otherwise, failing to pass the self-checking item.
Preferably, the method further comprises displaying the graphic questions from different dimensions, wherein the graphic questions are the frequency and the frequency of each type of questions appearing in the whole self-checking process and the frequency of each type of files appearing in the self-checking process, and meanwhile, the questions appearing in the whole process are seen in a self-checking mode.
The beneficial effects of the invention are as follows: the invention forms a whole complete closed-loop problem solving way, thereby realizing the purposes of real-time traceability of image-text uploading condition, monitoring, extensible text self-checking rule, explicit text checking, assisting designers in quickly positioning problems, traceable text error correcting process, displaying image-text error probability from different dimensions, macroscopically displaying image-text problems in disaster areas, continuously improving text quality and shortening text approval process period, and achieving the purposes of reducing cost, shortening period and improving efficiency.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings:
fig. 1 is a flowchart of a self-checking method for graphs and documents in a product data management system according to the present invention.
Detailed Description
The present invention will now be described in further detail with reference to the accompanying drawings. These drawings are simplified schematic views illustrating only the basic structure of the present invention in a schematic manner, and thus show only the constitution related to the present invention.
Referring to fig. 1, a diagram and document self-checking method in a product data management system, the method comprises the following steps:
s1: classifying and summarizing the problems through data analysis, finding out the correlation, extracting rules, establishing program coding rules by means of informatization, and carrying out rule configuration on the problems;
s2: when the document is submitted for approval, pattern self-checking and document self-checking are firstly carried out, the monitored problems are directly exposed, and the submission is not allowed before the problems are not solved; and the self-checking result can be displayed in each link in the signing and reviewing process, and the whole self-checking result is transmitted to the whole graph and document filing and publishing implementation.
The step of S1 includes:
s11: extracting and analyzing data for different units due to failure of filing, classifying and summarizing the problems, and performing large-class summarization;
s12: then, dividing related subclasses under each major class;
s13: according to the classification statistical result, the error occurrence frequency, the influence degree and the like can be evaluated, which errors can be checked through computer rules before the pictures and the documents are submitted can be determined, and meanwhile, the problems which can be checked through the computer can be marked;
s14: if the error type is identified in the result formed in S13, the error type is encoded and the corresponding correct rule is stored in a background database according to the error;
s15: and reading the source file uploaded by the design by the background and the rule in the database for comparison, and if the result of reading the source file is consistent with the rule of the database, the file is passed, otherwise, the file is not passed.
The broad categories of the taxonomy summary include BOMs, attributes, and covers.
The rule configuration comprises document self-checking item configuration and pattern self-checking item configuration;
the document self-checking item configuration configures the document self-checking items required to be performed according to the result of data analysis;
and the pattern self-check item configuration is configured according to the data analysis result, wherein the data analysis result is directed at the consistency of the structural attributes of the BOM, the integrity of the BOM associated patterns and the correctness of pattern uploading.
The database is Oracle.
The step of S2 includes:
s21: the rule formed by aiming at the codes is self-checked before drawing submission and document reviewing each time;
s22: the system exposes the problems in the source file as much as possible according to the configuration rule and displays the problems through a graphical interface;
s23: the system provides a negligible option in the checked problem, if the designer believes that the source file itself is not a problem, it is a system configuration problem, and the option can be chosen to be ignored, otherwise the modification is completed.
The step S2 further includes that each time a self-check is required before submitting a checkup, the system records the question that the result of each self-check appears, the system does not allow submission until the last found problem is not solved, if the last modification is completed but other correct rules are destroyed in the operation process, an error correction record is formed each time, and the error correction process each time can be found in the system.
The document self-checking comprises the steps of obtaining document contents to be self-checked and obtaining entity document attributes:
the method comprises the steps of obtaining document contents to be self-checked, including configuration aiming at document self-checking items, reading contents of a Word document by adopting a common WordExtractor in java for checking, reading table contents according to configured coordinates, thus obtaining related self-checking contents, expanding configuration such as fonts and sizes, obtaining related contents of a header and a footer, and storing the obtained table contents according to a Map set to serve as original contents to be compared.
The method comprises the steps of obtaining entity document attributes, wherein each Word document has a related document entity corresponding to the Word document, obtaining the content of the document entity to which the Word document belongs while obtaining the Word documents to be compared, comparing the attributes of the entity documents with the stored result of the previous Word content in an information matching mode, and comparing information dynamically only in the process of executing a program, wherein self-checking is carried out if the compared result of the attributes of the entity documents is consistent with the stored result of the previous Word content, and otherwise, the self-checking is not carried out.
The pattern self-check comprises basic information self-check and pattern correlation self-check;
the basic information self-checking takes the information of the top BOM as basic information, stores the basic information which needs to be checked to be consistent, obtains the BOM information of each level in a deep traversal mode and compares the BOM information with the information of the top node, and the relevant information of each lower BOM node needs to be consistent with the top information of the BOM as the stage;
and the pattern relevance self-checking acquires BOM information of each level and simultaneously acquires BOM-related drawing information, and compares the BOM-related drawing information according to the service configuration rule, wherein the self-checking is passed if the BOM information is in charge of the service configuration rule, and otherwise, the self-checking is failed.
And displaying the image-text problems from different dimensions, wherein the image-text problems are the frequency and the frequency of each type of problems in the whole self-checking process and the frequency of each type of files in the self-checking process, and the problems in the whole process are seen in a self-checking mode.
Example (b):
the data is extracted and analyzed for the reason that the archiving of different units fails in the last 1-2 years, the problems are classified and summarized (for example, according to BOM, attributes and covers), the major categories are firstly summarized, then the related minor categories are specifically divided under each major category (specifically to each different error), and the possible classification modes of different units do not count the occurrence frequency of each category of errors in the classification process. The following results are finally formed:
according to the classification statistical result, the error occurrence frequency, the influence degree and the like can be evaluated, which errors can be checked through computer rules before the submission of the graph and the document is determined, and meanwhile, the problems which can be checked through the computer are labeled, so that a developer can carry out coding input, and finally the following graph is obtained:
if the error type is identified by the (√) mark in the formed result, the error type is coded, and the corresponding correct rule (display rule and coding rule) is stored in a background database according to the error (the Oracle is adopted in the invention), and meanwhile, the rule configuration can be expanded and maintained, so that a manager can conveniently check the following graph. The background of the invention mainly has Java to realize that the general Word file is read by jacob or Poi to compare the source file uploaded by the design with the rule in the database, if the result of reading the source file is consistent with the rule in the database, the BOM structure and the related attribute are obtained by a deep traversal algorithm aiming at the processing mode of the graph, and the consistency is checked according to the rule if the result is not passed. And meanwhile, the result of each detection is recorded so as to facilitate follow-up tracking and problem analysis.
Aiming at the rule formed by the codes, a designer only needs to perform self-checking before submitting a picture and a document to be checked each time, the system can expose the problems in the source file as much as possible according to the configuration rule and display the problems through a graphical interface, so that the design is convenient to quickly find the problems and locate the problems, the system provides negligible options in the checked problems, if the designer considers that the source file has no problems, the system is a system configuration problem, the option can be selected to be ignored, and otherwise, the modification is required to be completed.
For the above description, the designer needs to perform self-checking each time before submitting the checkup, the system records the question appearing in the result of each self-checking, the system is not allowed to submit until the last found problem is not solved, if the last modification is completed but other correct rules are destroyed in the operation process, an error correction record is formed each time, and the error correction process each time can be found in the system.
In the process of signing and reviewing the figures and the documents, because the person in each link is responsible for issuing the document, each person needs to check the correctness of the document (the correctness of contents and the correctness of formats), the invention provides the final check result as the final check result of the signed and reviewed document for the signing and reviewing personnel in each link to assist the signing and reviewing personnel in finishing the check of the document correctness, thereby reducing repeated work, improving the work efficiency, and besides finishing the problem of auxiliary design and positioning and assisting the signing and reviewing personnel in checking the document correctness, the invention also provides a data analysis function: displaying image-text problems 'disaster areas' from different dimensions, wherein the frequency and the times of each type of problems in the whole self-inspection process are increased; the number of times and rate that each respective type of file appears during the self-test. Meanwhile, each person can also see the problems in the whole process in a self-checking mode, so that the same problems are avoided not appearing repeatedly.
The problems are classified and summarized through data analysis (mainly in all rejections), the correlation is found out, the rule is extracted, the program coding rule is established by an informatization means, and the rule configuration is carried out on the problems (the rule can be expanded when new problems occur).
When a designer submits a document for checking, drawing and document self-checking are carried out, the detected problem is directly exposed to the designer, and the submission is not allowed before the problem is not solved (the problem has a prompt item (can be ignored) and a mandatory item (has to be modified)).
The self-checking result can be displayed in each link in the signing and examining process, all the link personnel can see the whole error correcting process, other signing and examining personnel only need to pay attention to professional technical problems, time is not wasted for formats and standards, the whole self-checking result is always transmitted to the whole picture and document filing and publishing, the picture and text checking dominance is realized, the problem is quickly positioned by an auxiliary designer, the picture and text error correcting process can be traced, the picture and text error probability is displayed from different dimensions, the picture and text problem is macroscopically displayed in a disaster area, the picture and text quality is continuously improved, and the picture and text approval process period is shortened. The cost is reduced, the efficiency is improved, and the time is shortened.
The invention extracts (formulate solution) program code (implement solution), auxiliary positioning (verification scheme), auxiliary review (verification scheme), self-checking analysis (regression feedback), and whole complete closed-loop problem solving mode, thereby realizing real-time traceability of image-text uploading condition, monitoring, expandable image-text self-checking rule, explicit inspection, quick positioning of auxiliary designer, traceable text error correction process, display of image-text error probability from different dimensions, macroscopically displaying image-text problem disaster area, continuously improving text quality, and shortening text approval process period, and achieving the purposes of reducing cost, shortening period and improving efficiency.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art should be able to cover the technical scope of the present invention by equivalent replacement or change according to the technical solution and the inventive concept of the present invention within the technical scope of the present invention.