Serialized product inspection specification file automatic generation method and device and medium thereof

Abstract

The invention relates to the technical field of computers, in particular to an automatic generation method and device for a serialized product inspection specification file and a medium of the automatic generation method and device. The method comprises the following steps: designing an inspection specification file template; creating an inspection specification database according to the serialized product inspection specifications; in response to a file creation instruction, a corresponding template filling interface is displayed based on the file creation instruction, and the file creation instruction comprises an inspection key point table creation instruction and an inspection key point record table creation instruction; the template filling interface comprises a plurality of pieces of information filling, and material filling corresponding to a certain content framework is carried out on the certain content framework of the table based on matching of the information of the serialized product and key data of the database; and filling all materials of the table content framework to form an inspection specification file. According to the automatic generation method for the serialized product inspection specification file, the inspection specification file can be automatically written, the writing efficiency is high, and the reliability and the consistency of the inspection specification file are improved.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method, device and medium for automatically generating serialized product inspection specification files. Background Art

[0002] In industrial production, inspection specifications are crucial for product quality control. Traditional document preparation methods are usually manual, and the process has the following disadvantages:

[0003] (1) Low efficiency. Manually writing documents takes a lot of time and effort, especially for documents that are long and complex. From conceiving the framework to writing word by word, to repeated checking and revision, the whole process may take hours or even days. When multiple similar documents need to be written, repetitive work will further reduce work efficiency.

[0004] (2) Errors are prone to occur. Manual operations are prone to spelling errors, grammatical errors, data entry errors, etc. Even after careful inspection, it is difficult to completely avoid errors. These errors may have a negative impact on the accuracy and professionalism of the document. For documents containing large amounts of data, manual calculations and data entry are also prone to errors, affecting the reliability of the document.

[0005] (3) Lack of consistency. Documents written by different people may differ in format, style, and content. This will give readers an inconsistent reading experience and may also affect the professionalism and authority of the document. For enterprises or organizations, the inconsistency of documents may affect the brand image and the standardization of business processes. Summary of the invention

[0006] The technical problem to be solved by the present invention is: in order to solve the technical problem that manually writing product inspection specification documents is inefficient, error-prone and lacks consistency, the present invention provides a method for automatically generating serialized product inspection specification documents, which can automatically write inspection specification documents with high writing efficiency, and improves the reliability and consistency of inspection specification documents.

[0007] The technical solution adopted by the present invention to solve the technical problem is: a method for automatically generating a serialized product inspection specification file, the method comprising:

[0008] Step S1, designing an inspection specification document template, wherein the inspection specification document template includes: an inspection key point form and an inspection key point record form;

[0009] Step S2, creating a specification database according to the serialized product inspection specification;

[0010] Step S3, in response to the file creation instruction, displaying a corresponding template filling interface based on the file creation instruction, wherein the file creation instruction includes an inspection key point table creation instruction and an inspection key point record table creation instruction;

[0011] Step S4, the template filling interface includes multiple information fillings, based on the matching of the serialized product information with the key data of the inspection specification database, a certain content frame of the table is filled with materials corresponding to the certain content frame;

[0012] Step S5, repeat steps S3 and S4 to complete the filling of all materials in the table content framework to form an inspection specification file.

[0013] Further, specifically, the specification database includes: serialized product names, material names, specifications and models, verification items, reference drawings, technical requirements, inspection tools and operating instructions.

[0014] Further, specifically, in the step S4, the multiple information filling includes file information and material information;

[0015] Fill in the file information to number and version the created inspection specification file and fill in the creation date of the inspection specification file;

[0016] Fill in the material information, match the material information with the content of the specification database, and fill the material into the content frame of the corresponding table.

[0017] Further, specifically, in step S5, the format of the table is automatically adjusted based on the filled material content, the table row height and column width are automatically adjusted, and paging is automatically performed.

[0018] Further, specifically,

[0019] Automatically adjusting table row height and column width involves the following steps:

[0020] Filter the cells in the table to obtain the cells to be adjusted;

[0021] Get the content length value of each cell in the same column and the row height value of each cell in the same row;

[0022] Determine column width based on content length value;

[0023] Obtaining the filled material content of each cell to be adjusted in the same row, and determining the row height value of each cell based on the filled material content;

[0024] Compare the row height values ​​of each cell, and merge rows based on the maximum row height value and the row height values ​​of each cell in the same row, until the row height of the current row is equal to the maximum row height value.

[0025] Further, specifically, in step S4, when matching the serialized product with the data specification data, if no material is matched, the corresponding content frame is manually filled in, and the manually filled content is automatically saved in the inspection specification database.

[0026] Further, specifically, matching the material information with the specification database content includes:

[0027] Determine keywords of material information, traverse the inspection specification database, and obtain materials matching the keywords;

[0028] Dynamically cluster multiple materials with the same keywords to obtain the final material.

[0029] A computer device comprising:

[0030] processor;

[0031] A memory for storing executable instructions;

[0032] Wherein, the processor is used to read the executable instructions from the memory and execute the executable instructions to implement the method for automatically generating a serialized product inspection specification file as described above.

[0033] A computer-readable storage medium stores a computer program. When the computer program is executed by a processor, the processor implements the method for automatically generating a serialized product inspection specification file as described above.

[0034] The beneficial effects of the present invention are:

[0035] (1) The automatic generation method of the serialized product inspection specification file of the present invention improves the efficiency of document writing. Traditional document preparation usually requires a lot of manpower and time investment. Manually writing assembly process and inspection specification files is not only cumbersome, but also prone to errors and omissions. The automatic generation method can quickly fill in information and generate files according to a preset template, greatly shortening the time for document preparation.

[0036] (2) Ensure the quality of the document. During the generation process, it can ensure that the format of the document is standardized, the content is complete, the data is accurate, and the document is highly accurate;

[0037] (3) The format requirements of the generated files are the same, which avoids typesetting work, reduces the time and errors of manually setting complex formats, and further improves writing efficiency. The generated files are consistent, which is convenient for file archiving and has a good reading experience during review. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] The present invention is further described below in conjunction with the accompanying drawings and embodiments.

[0039] Figure 1 It is a schematic diagram of the method flow of embodiment 1 of the present invention.

[0040] Figure 2 It is a schematic diagram of the inspection key points table after filling in the first embodiment of the present invention.

[0041] Figure 3 It is a schematic diagram of the inspection key point record table after filling in the first embodiment of the present invention.

[0042] Figure 4 It is a schematic diagram of the structure of a computer device according to Embodiment 2 of the present invention.

[0043] In the figure, 10 is a computer device; 1002 is a processor; 1004 is a memory; and 1006 is a transmission device. DETAILED DESCRIPTION

[0044] The present invention will now be described in further detail with reference to the accompanying drawings. These drawings are simplified schematic diagrams, which only illustrate the basic structure of the present invention in a schematic manner, and therefore only show the components related to the present invention.

[0045] In the description of the present invention, it should be understood that the terms "center", "longitudinal", "lateral", "length", "width", "thickness", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside", "outside", "clockwise", "counterclockwise", "axial", "radial", "circumferential" and the like indicate positions or positional relationships based on the positions or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as a limitation on the present invention. In addition, features defined as "first" and "second" may explicitly or implicitly include one or more of the features. In the description of the present invention, unless otherwise specified, "multiple" means two or more.

[0046] In the description of the present invention, it should be noted that, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium, or it can be the internal communication of two components. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0047] Example 1

[0048] The present application embodiment provides a method for automatically generating a serialized product inspection specification file, such as Figure 1 As shown, the method includes:

[0049] Step S1, design the inspection specification document template, the inspection specification document template includes: inspection key points form and inspection key points record form. Among them, the inspection key points form clearly stipulates the specific requirements of the product size, appearance, performance, etc. according to the design drawings, so that the inspectors can follow the content of the inspection key points form when conducting inspections. The inspection key points record form is a detailed record of the inspection process and results, providing a basis for subsequent quality tracing and problem analysis.

[0050] Step S2, creating a specification database according to the serialized product inspection specifications.

[0051] Step S3, in response to the file creation instruction, displaying a corresponding template filling interface based on the file creation instruction, wherein the file creation instruction includes an inspection key point table creation instruction and an inspection key point record table creation instruction;

[0052] Step S4, the template filling interface includes multiple information fillings, based on the matching of the serialized product information with the database key data, a certain content frame of the table is filled with materials corresponding to a certain content frame;

[0053] Step S5, repeat steps S3 and S4 to complete the filling of all materials in the table content framework to form an inspection specification file.

[0054] The specification database includes: serialized product name, material name, specification model, inspection items, reference drawings, technical requirements, inspection tools and operation instructions. A serialized product has multiple specifications and models, and the inspection items, reference drawings and technical requirements under each specification and model are different. Inspection items include but are not limited to inspection of appearance, size, packaging and labeling, and material. Inspection items correspond to reference images and technical requirements one by one. Taking a material in a serialized product as a compression nut as an example, the data file formed is shown in the table below.

[0055] Table 1

[0056]

[0057]

[0058]

[0059] In step S4, multiple information filling includes file information and material information; the file information is used to name the inspection specification file for easy archiving and searching, and the material information is the assembly material information of the serialized product.

[0060] Fill in the file information in the template filling interface, number the created inspection specification file, fill in the version and creation date of the inspection specification file; the file number creation rule is: the first capital letter of the Chinese pinyin of the process + the first capital letter of the Chinese pinyin of the specification table + the creation sequence number, such as GY-GFB383.

[0061] Fill in the material information in the template filling interface, match the material information with the content of the inspection specification database, and fill the material into the content frame of the corresponding table. Matching the material information with the content of the specification database includes:

[0062] Determine the keywords of material information, and traverse the materials that match the keywords in the specification database, such as automatically obtaining the corresponding inspection items, reference drawings, technical requirements and other materials based on the first 8 digits of the material name and specification model.

[0063] Dynamically cluster multiple materials with the same keywords to obtain the final material, and fill the final material into the content frame of the corresponding table, see Figure 2 and Figure 3 shown.

[0064] In step S4, when matching the serialized products with the data specification data, if no material is matched, the corresponding content frame is manually filled, and the manually filled content is automatically saved to the specification database to facilitate the next material filling.

[0065] In step S5, the format of the table is automatically adjusted based on the filled material content, the table row height and column width are automatically adjusted, and the page is automatically divided. Specifically, it includes:

[0066] Filter the cells in the table to obtain the cells to be adjusted;

[0067] Get the content length value of each cell in the same column and the row height value of each cell in the same row;

[0068] Determine column width based on content length value;

[0069] Obtaining the filled material content of each cell to be adjusted in the same row, and determining the row height value of each cell based on the filled material content;

[0070] Compare the row height values ​​of each cell, and merge rows based on the maximum row height value and the row height values ​​of each cell in the same row, until the row height of the current row is equal to the maximum row height value.

[0071] Automatic paging can ensure that there will be no wrong pages during the printing process. At the same time, the generated inspection specification file is automatically named according to the file number and saved in the specified path for easy reference and archiving.

[0072] To sum up, the automatic generation method of serialized product inspection specification files of the present invention improves the efficiency of file writing. Traditional file preparation usually requires a lot of manpower and time investment. Manual writing of inspection specification files is not only cumbersome, but also prone to errors and omissions. The automatic generation method can quickly fill in information and generate files according to preset templates, which greatly shortens the time for file preparation. In addition, the quality of the file is guaranteed. During the generation process, it can be ensured that the format of the file is standardized, the content is complete, the data is accurate, and the file accuracy is high. The format requirements of the generated files are all the same, which avoids typesetting work, reduces the time and errors of manually setting complex formats, and further improves writing efficiency. The generated files have good consistency, are convenient for file archiving, and have a good reading experience during review.

[0073] Example 2

[0074] An embodiment of the present application provides a computer device, which includes a processor and a memory, wherein the memory stores at least one instruction or at least one program, and the at least one instruction or the at least one program is loaded and executed by the processor to implement a method for automatically generating a serialized product inspection specification file as provided in the above method embodiment.

[0075] Figure 4 The hardware structure diagram of a device for implementing a method for automatically generating a serialized product inspection specification file provided in an embodiment of the present application is shown. The device may participate in or include the apparatus or system provided in an embodiment of the present application. Figure 4 As shown, the computer device 10 may include one or more processors 1002 (the processor may include but is not limited to a processing device such as a microprocessor MCU or a programmable logic device FPGA), a memory 1004 for storing data, and a transmission device 1006 for communication functions. In addition, it may also include: a display, an input / output interface (I / O interface), a universal serial bus (USB) port (which may be included as one of the ports of the I / O interface), a network interface, a power supply and / or a camera. It can be understood by those skilled in the art that Figure 4 The structure shown is only for illustration and does not limit the structure of the above electronic device. Figure 4 More or fewer components as shown, or with Figure 4 Different configurations are shown.

[0076] It should be noted that the one or more processors and / or other data processing circuits described above may generally be referred to herein as "data processing circuits". The data processing circuits may be embodied in whole or in part as software, hardware, firmware, or any other combination thereof. In addition, the data processing circuit may be a single independent processing module, or may be incorporated in whole or in part into any of the other components in the computer device 10 (or mobile device). As described in the embodiments of the present application, the data processing circuit acts as a processor control (e.g., selection of a variable resistor terminal path connected to an interface).

[0077] The memory 1004 can be used to store software programs and modules of application software, such as a program instruction / data storage device corresponding to a method for automatically generating a serialized product inspection specification file in an embodiment of the present application. The processor executes various functional applications and data processing by running the software programs and modules stored in the memory 1004, that is, implementing the above-mentioned method. The memory 1004 may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 1004 may further include a memory remotely arranged relative to the processor, and these remote memories may be connected to the computer device 10 via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0078] The transmission device 1006 is used to receive or send data via a network. The specific example of the above network may include a wireless network provided by a communication provider of the computer device 10. In one example, the transmission device 1006 includes a network adapter (Network Interface Controller, NIC), which can be connected to other network devices through a base station so as to communicate with the Internet. In one example, the transmission device 1006 can be a radio frequency (RF) module, which is used to communicate with the Internet wirelessly.

[0079] The display may be, for example, a touch screen liquid crystal display (LCD) that enables a user to interact with a user interface of the computer device 10 (or mobile device).

[0080] Example 3

[0081] An embodiment of the present application also provides a computer-readable storage medium, which can be set in a server to store at least one instruction or at least one program related to a method for automatically generating a serialized product inspection specification file in a method embodiment. The at least one instruction or the at least one program is loaded and executed by the processor to implement a method for automatically generating a serialized product inspection specification file provided in the above method embodiment.

[0082] Optionally, in this embodiment, the storage medium may be located in at least one of the multiple network servers of the computer network. Optionally, in this embodiment, the storage medium may include, but is not limited to, various media that can store program codes, such as a USB flash drive, a read-only memory (ROM), a random access memory (RAM), a mobile hard disk, a magnetic disk, or an optical disk.

[0083] Example 4

[0084] The embodiment of the present invention also provides a computer program product or a computer program, which includes computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device executes a method for automatically generating a serialized product inspection specification file provided in the above various optional embodiments.

[0085] It should be noted that the above-mentioned sequence of the embodiments of the present application is for description only and does not represent the advantages and disadvantages of the embodiments. The above-mentioned specific embodiments of the present application are described. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recorded in the claims can be performed in an order different from that in the embodiments and still achieve the desired results. In addition, the processes depicted in the drawings do not necessarily require the specific order or continuous order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0086] Each embodiment in this application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device, equipment and storage medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0087] A person skilled in the art will understand that all or part of the steps to implement the above embodiments may be accomplished by hardware or by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a disk or an optical disk, etc.

[0088] Based on the above ideal embodiments of the present invention, the relevant staff can make various changes and modifications without departing from the technical concept of the present invention through the above description. The technical scope of the present invention is not limited to the contents of the specification, and its technical scope must be determined according to the scope of the claims.

Claims

1. A method for automatically generating a serialized product inspection specification file, characterized in that: The method comprises: Step S1, designing an inspection specification document template, wherein the inspection specification document template includes: an inspection key point form and an inspection key point record form; Step S2, creating an inspection specification database according to the serialized product inspection specifications; Step S3, in response to the file creation instruction, displaying a corresponding template filling interface based on the file creation instruction, wherein the file creation instruction includes an inspection key point table creation instruction and an inspection key point record table creation instruction; Step S4, the template filling interface includes multiple information fillings, based on the matching of the serialized product information with the database key data, a certain content frame of the table is filled with materials corresponding to the certain content frame; Step S5, repeat steps S3 and S4 to complete the filling of all materials in the table content framework to form an inspection specification file.

2. The method for automatically generating a serialized product inspection specification file according to claim 1, characterized in that: The specification database includes: serialized product names, material names, specifications and models, inspection items, reference drawings, technical requirements, inspection tools and operating instructions.

3. The method for automatically generating a serialized product inspection specification file according to claim 1, characterized in that: In the step S4, the multiple information filling includes file information and material information; Fill in the file information to number and version the created inspection specification file and fill in the creation date of the inspection specification file; Fill in the material information, match the material information with the inspection specification database content, and fill the material into the content frame of the corresponding table.

4. The method for automatically generating a serialized product inspection specification file according to claim 1, characterized in that: In step S5, the format of the table is automatically adjusted based on the filled material content, the table row height and column width are automatically adjusted, and the paging is automatically performed.

5. The method for automatically generating a serialized product inspection specification file according to claim 4, characterized in that: Automatically adjusting table row height and column width involves the following steps: Filter the cells in the table to obtain the cells to be adjusted; Get the content length value of each cell in the same column and the row height value of each cell in the same row; Determine column width based on content length value; Obtaining the filled material content of each cell to be adjusted in the same row, and determining the row height value of each cell based on the filled material content; Compare the row height values ​​of each cell, and merge rows based on the maximum row height value and the row height values ​​of each cell in the same row, until the row height of the current row is equal to the maximum row height value.

6. The method for automatically generating a serialized product inspection specification file according to claim 1, characterized in that: In step S4, when matching the serialized product with the inspection specification database, if no material is matched, the corresponding content frame is manually filled in, and the manually filled content is automatically saved in the specification database.

7. The method for automatically generating a serialized product inspection specification file according to claim 3, characterized in that: Matching material information with the specification database content includes: Determine keywords of material information, traverse the inspection specification database, and obtain materials matching the keywords; Dynamically cluster multiple materials with the same keywords to obtain the final material.

8. A computer device, characterized in that: include: processor; A memory for storing executable instructions; Wherein, the processor is used to read the executable instructions from the memory and execute the executable instructions to implement the method for automatically generating a serialized product inspection specification file as described in any one of claims 1 to 7.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the processor implements the method for automatically generating a serialized product inspection specification file according to any one of claims 1 to 7.

Images