CN111459904A

CN111459904A - TPM document automatic management system and method

Info

Publication number: CN111459904A
Application number: CN202010116314.3A
Authority: CN
Inventors: 张盼盼; 张应红; 王海峰
Original assignee: Shanghai Trw Automotive Safety Systems Co ltd
Current assignee: Shanghai Trw Automotive Safety Systems Co ltd
Priority date: 2020-02-25
Filing date: 2020-02-25
Publication date: 2020-07-28
Anticipated expiration: 2040-02-25
Also published as: CN111459904B

Abstract

The invention discloses a TPM document automatic management system and a TPM document automatic management method, wherein the TPM document automatic management system comprises a TPM data management module, a TPM data analysis module, a TPM file creation module and a TPM file output module; the TPM data management module is used for assisting a user in adding equipment information, editing or adding TPM spot check content of the equipment, automatically managing TPM ID content of the equipment, assisting the user in configuring TPM document parameters for each equipment, and automatically counting configuration parameters and use data in a database; the TPM data analysis module is used for creating an equipment instance, initializing the instance and loading the equipment information in the database into the instance; the TPM file creating module is used for creating a TPM document instruction book and a click-through table; the TPM file output module is used for exporting the created TPM document into an independent Excel file and deleting unnecessary contents in the Excel file.

Description

TPM document automatic management system and method

Technical Field

The invention relates to the technical field of TPM (full production maintenance and full production security) document management, in particular to a TPM document automatic management system and a TPM document automatic management method.

Background

The TPM document in the existing equipment maintenance generally is modified and edited manually, the checking content, personnel, risk analysis and the picture corresponding to the checking content in the document are edited, and each piece of equipment needs to configure the TPM document, so that the TPM document management work is repeated and complicated, most working time of staff is occupied, and finally, a plurality of problems occur in TPM file management and equipment maintenance:

1, the TPM document can not be updated in time, so that the updating of the TPM file content is delayed or omitted;

2, TPM document management occupies most time of the staff, so that the staff cannot pay attention to TPM implementation work of the equipment in a drawing mode, and TPM point inspection content is not implemented in place;

3. the TPM documents of the equipment have the same points and different points, but the staff need to edit each file manually, and the working efficiency is low.

4. If the TPM check content or the image needs to be updated, all the devices using the TPM check content need to be modified, managers need to open and search each TPM document and then edit the TPM document, and the work task is repeated but the equivalent value is not created;

5. newly-built a TPM file, every TPM point examines the content and must look for and confirm in the existing file, consume a large amount of time, the figure inserted is when printing out, often appear misplacing, lose the aesthetic property.

And 6, when the content sequence of the TPM file needs to be adjusted, all related characters and pictures need to be manually modified, which wastes time and is easy to cause mistakes and careless mistakes.

7. Because factory equipment is generally many, when the TPM file is used for replacing the file template, huge engineering is required, and a great deal of labor time is consumed.

These problems cause great work difficulty for the equipment management personnel, cost a lot of manpower and material resources, do not create much value for the company, and often also lead to the trouble of normal maintenance of the equipment, but the equipment management personnel are not under the control.

Disclosure of Invention

Aiming at the problems and the defects in the prior art, the invention provides a TPM document automatic management system and a TPM document automatic management method.

The invention solves the technical problems through the following technical scheme:

the invention provides a TPM document automatic management system which is characterized by comprising a TPM data management module, a TPM data analysis module, a TPM file creation module and a TPM file output module;

the TPM data management module is used for assisting a user in adding equipment information, editing or adding TPM spot check content of the equipment, automatically managing TPM ID content of the equipment, assisting the user in configuring TPM document parameters for each equipment, and automatically counting configuration parameters and use data in a database;

the TPM data analysis module is used for creating an equipment instance, initializing the instance and loading the equipment information and TPM spot check content in the database into the instance;

the TPM file creating module is used for creating a TPM document instruction book and a click-through table;

the TPM file output module is used for exporting the created TPM document into an independent Excel file and deleting unnecessary contents in the Excel file.

Preferably, the TPM data analysis module comprises an equipment information analysis submodule, a TPM content analysis submodule and a graphic information management submodule;

the equipment information analysis submodule is used for creating an equipment class object and performing default setting on the TPM picture position of the equipment;

the TPM content analysis submodule is used for analyzing and sequencing the basic information loaded into the equipment by the equipment basic information table for the user to select and use; collecting, analyzing and recombining TPM click-check content, a main view picture, a TPM click-check matching picture and the like of the equipment, verifying whether a picture link is legal, and creating output information corresponding to a TPM document;

the graphic information management submodule is used for reading the storage data information such as the shape, the position, the size and the like of the graphics and the pictures in the TPM document.

Preferably, the TPM file creating module comprises a template address parsing submodule, a content initialization submodule, a TPM content insertion submodule and a picture graph insertion submodule;

the template address analysis submodule is used for analyzing each page of cell address of the TPM document according to the existing template so as to fill TPM spot inspection content in each cell address;

the content initialization submodule is used for cleaning the old TPM spot inspection content, the TPM graph and the picture information in the template and eliminating unnecessary content;

the TPM content insertion submodule is used for inserting the equipment information and the TPM spot inspection content into the analyzed cell address and setting the page printing range of the template;

the picture graph inserting sub-module is used for inserting the picture and the icon of the main view into the TPM document and inserting the position, the size and the shape information of each picture graph according to the TPMID.

Preferably, the system includes a menu initialization module, and the menu initialization module is configured to perform initialization operation of a system menu and perform command management according to a page selected by a user.

The invention also provides a TPM document automatic management method, which is characterized by comprising the following steps:

s1, updating the information of the equipment and the TPM: the method comprises the following steps that an auxiliary user adds equipment information, edits or adds TPM spot check content of the equipment, automatically manages TPM ID content of the equipment, assists the user to configure TPM document parameters for each equipment, and automatically counts configuration parameters and use data in a database;

s2, preparing interactive data: analyzing a production line and equipment number list from the equipment information, and determining the number of the target equipment by a user through a dialog box interacted with the user;

s3, creating an equipment instance, initializing the instance, loading equipment information in a database into the instance, initializing the shape, size and position information of pictures and graphics, collecting, analyzing and recombining TPM information of the equipment, confirming the information in the analyzing process, prompting a user by a program if illegal conditions are found, interrupting or continuing the program execution according to the selection of the user, and automatically executing the collection work of the content data of the TPM template if the illegal conditions are not found;

s4, calculating the addresses of each cell of the content to be filled according to the template, initializing the content of the existing template, deleting unnecessary content, preparing for generating a new TPM document, writing the information in the equipment object into the corresponding cell according to the address information, and creating a new picture graph according to the shape, the size and the position information;

s5, adjusting graphics and pictures: the method comprises the steps that a TPM document is created for the first time, positions and sizes of graphics and pictures are software defaults, a user needs to adjust the positions and sizes of pictures and sequence icons of a home page, add or adjust an auto-definition graph to the pictures of TPM text content to identify, select and store a picture and graphic information command in a menu, store current pictures and graphic information, and automatically update contents in a picture and graphic information base by a program;

s6, TPM file output: and the software generates the finally generated TPM document into an independent workbook, deletes unnecessary contents in the workbook and performs some necessary settings.

Preferably, step S1 is preceded by: s0, auto-initialization system menu item.

On the basis of the common knowledge in the field, the above preferred conditions can be combined randomly to obtain the preferred embodiments of the invention.

The positive progress effects of the invention are as follows:

the invention greatly reduces the workload of users, the workload is determined by the number of the devices before, the number of the devices is basically not influenced at present, and the workload of one device is basically equivalent to the workload of the modification of the device no matter how many devices are modified, thereby saving a great amount of time for the users; TPM check content is managed by a program in a unified mode, redundant work is avoided, the same TPM check content only needs to be edited once, and other equipment is updated automatically; creating a TPM document of a new TPM device very quickly, and automatically using the TPM document by a user only needing to input a device number and then configuring TPM spot check content to display patrol; the TPM spot check content is automatically collected and counted, and various information is clear; once the TPM content is determined, basically no maintenance is needed, software does not need to be installed, the use is convenient, the operation is simple, and a smooth feeling of managing files is created for users.

Drawings

FIG. 1 is a block diagram of the TPM document automatic management system according to the preferred embodiment of the present invention.

FIG. 2 is a flowchart illustrating an exemplary method for automatically managing TPM documents according to an embodiment of the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, 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 some, but not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.

As shown in fig. 1, the present embodiment provides an automatic TPM document management system, which includes a menu initialization module 1, a TPM data management module 2, a TPM data parsing module 3, a TPM file creation module 4, and a TPM file output module 5.

The menu initialization module 1 is used for initializing the system menu and managing commands according to the page selected by the user. When the system software is opened every time, the system menu initialization program can be automatically executed, a temporary menu is created in the 'loading item' of the main menu, and when the system software is closed, the temporarily created menu can be automatically destroyed, so that other files are prevented from being affected.

The TPM data management module 2 is used for assisting a user to add equipment information, edit or add TPM spot check content of the equipment, automatically manage TPM ID content of the equipment, assist the user to configure TPM document parameters for each equipment, and automatically count configuration parameters and use data in a database.

The TPM data analysis module 3 is used for creating an equipment instance, initializing the instance, and loading the equipment information and TPM spot check content in the database into the instance.

Specifically, the TPM data analysis module 3 includes a device information analysis module 31, a TPM content analysis module 32, and a graphic information management module 33.

The device information analysis module 31 is configured to create a device class object, and perform default setting on a TPM picture position of a device.

The TPM content analysis module 32 is configured to analyze and sort the basic information loaded into the device in the device basic information table, so that the user can select and use the basic information; collecting, analyzing and recombining TPM point inspection content, a main view picture, a TPM point inspection matching picture and the like of the equipment, verifying whether the picture link is legal, and creating output information corresponding to the TPM document.

The graphic information management module 33 is used for reading information such as shapes and positions of graphics and pictures in the TPM document, and reading storage data information such as storage information of the graphics and the pictures.

The TPM file creating module 4 is used for creating a TPM document guide book and a point checking table.

Specifically, the TPM file creation module 4 includes a template address resolution module 41, a content initialization module 42, a TPM content insertion module 43, and a picture graphics insertion module 44.

The template address resolution module 41 is configured to resolve the cell address of each page of the TPM document according to an existing template, so as to fill TPM checkpointing content in each cell address.

The content initialization module 42 is used for cleaning the old TPM content, TPM graphics, and picture information in the template, and removing unnecessary content.

The TPM content inserting module 43 is configured to insert the device information and TPM content for spot inspection into the parsed cell address, and set a page printing range of the template.

The picture graph inserting module 44 is used for inserting the picture and the icon of the main view into the TPM document, and inserting the position, the size and the shape information of each picture graph according to the TPMID.

The TPM file output module 5 is configured to export the created TPM document as an independent Excel file, and delete unnecessary contents therein, such as codes and formulas.

As shown in fig. 2, this embodiment further provides an automatic TPM document management method, which includes the following steps:

1. initialization menu (step 1001): when the software is opened, the program automatically initializes the software menu item;

2. update device and TPM information (step 1002): the method comprises the steps of assisting a user to add equipment information, editing or adding TPM spot check content of the equipment, automatically managing TPM ID content of the equipment, assisting the user to configure TPM document parameters for each equipment, and automatically counting configuration parameters and use data in a database, wherein the user and software are required to collaboratively edit and adjust the TPM content.

3. Prepare interaction data (steps 1003 and 1004): and analyzing a production line and equipment number list from the equipment information, and determining the number of the required target equipment by a user through a dialog box interacted with the user.

4. Creating a device instance class object and initializing (step 1005), wherein the initialized content is mainly the shape and position information of pictures and graphs; collecting and parsing the device TPM information (step 1006); in the analysis process, the information is confirmed (step 1007), if an illegal condition is found, the program prompts a user, and then the program execution is interrupted (step 1002); if there is no exception, the next operation is executed, i.e. the TPM template content is initialized (step 1008).

5. TPM file creation (steps 1009-1010): the software calculates each cell address of the content to be filled according to the template (step 1009), initializes the unnecessary content in the existing model, prepares for generating a new TPM document (step 1010), and writes the information in the device class object into the corresponding cell according to the address information and creates the information according to the information of the picture graph.

6. Graphics and picture adjustment (steps 1011 and 1012): the TPM document is created for the first time, a user needs to adjust the picture and the serial number icon of the home page, the picture of the TPM text content is identified by using a user-defined graph (step 1011), finally, a command for saving the picture and the graph information is selected from a menu, the current picture and the graph information are stored, and the program automatically updates the content in the picture graph information base (step 1012).

7. TPM file output (step 1013): software generates an independent workbook from the TPM document generated finally, deletes unnecessary content in the workbook, and performs some necessary settings, such as setting a printing area, so that the user can use the TPM document directly after confirming the TPM document.

While specific embodiments of the invention have been described above, it will be appreciated by those skilled in the art that these are by way of example only, and that the scope of the invention is defined by the appended claims. Various changes and modifications to these embodiments may be made by those skilled in the art without departing from the spirit and scope of the invention, and these changes and modifications are within the scope of the invention.

Claims

1. A TPM document automatic management system is characterized by comprising a TPM data management module, a TPM data analysis module, a TPM file creation module and a TPM file output module;

2. The TPM document automatic management system of claim 1, wherein the TPM data parsing module comprises an equipment information parsing submodule, a TPM content analyzing submodule, and a graphic information management submodule;

3. The TPM document automatic management system according to claim 1, wherein the TPM file creation module comprises a template address resolution submodule, a content initialization submodule, a TPM content insertion submodule and a picture graph insertion submodule;

the picture graph inserting submodule is used for inserting the picture and the icon of the main view into the TPM document and inserting the position, the size and the shape information of each picture graph according to the TPM ID.

4. The TPM document auto-management system of claim 1, wherein the system comprises a menu initialization module, and the menu initialization module is used to initialize the system menu and manage the command according to the page selected by the user.

5. A TPM document automatic management method is characterized by comprising the following steps:

6. The TPM document automatic management method as claimed in claim 5, wherein step S1 is preceded by: s0, auto-initialization system menu item.