Method for automatically extracting and printing label information

Abstract

The invention relates to an information printing method, in particular to a method for automatically extracting and printing label information. The method comprises the following steps: 1, receiving a given production schedule; 2, according to the production plan table, continuous factory codes are sequentially generated in the label information table; 3, generating a complete label information table; 4, screening out all information corresponding to the product model from the label information table based on the product model needing to be printed on that day, the date and the corresponding label information table; 5, selecting a corresponding label template, assigning all information corresponding to the model of the product needing to be printed to a corresponding position according to a set corresponding relation of the selected label template, and automatically generating a two-dimensional code; and finally, printing the information of the corresponding position of the label template and the two-dimensional code information to a preset label to complete printing. All information does not need to be manually input into the label printing template for printing, efficiency is greatly improved, convenience is improved, and the mistake proofing function is achieved.

Description

Technical Field

[0001] The invention relates to an information printing method, in particular to a method for automatically extracting and printing sign information. Background Art

[0002] The product label is the product's ID card and is an indispensable and extremely important part of the product. The printed label information needs to be clear and the printing operation needs to be convenient. However, due to the fact that the content and format required to be printed on different products are very different, the printing method should first consider its compatibility and then convenience.

[0003] Faced with a variety of products, the information and formats that need to be printed on their labels are diverse. The current printing method is to establish a printing template in the software. Different label templates can be established according to the label style, and then the specific content to be printed is filled in each label template.

[0004] However, since the information needs to be manually input into the sign template for printing, it brings a heavy workload to the sign printing operator, and the efficiency is low and it is prone to errors. Summary of the invention

[0005] The purpose of the present invention is to solve the technical problems that the prior art requires manual input of information into a sign template for printing, which brings a heavy workload to the sign printing operator, is inefficient, and is prone to errors, and to provide a method for automatically extracting sign information and printing.

[0006] To achieve the above purpose, the technical solution adopted by the present invention is:

[0007] A method for automatically extracting and printing sign information includes the following steps:

[0008] Step 1: Receive a given production schedule, where each row of information includes tasks, assembly descriptions, agreement numbers, dates, and quantities;

[0009] Step 2: According to the quantity and date information in the production schedule, sequentially generate the corresponding factory codes of quantity and production date in the label information table;

[0010] Step 3, copy any row of information in the production schedule to the specified position in the label information table, and assign the assembly description and protocol number in the production schedule to the product model and user number in the label information table through the automatic supplementary information table remaining content technology, and generate a complete label information table, the information in the label information table includes product model, production date, user number and factory code;

[0011] Step 4: Based on the product model and production date to be printed on the day, all the information corresponding to the product model is filtered out from the label information table and displayed in a set manner;

[0012] Step 5. Select the corresponding sign template, assign all the information corresponding to the product model to be printed to the corresponding position on the sign template according to the corresponding relationship set with the selected sign template, and automatically generate a QR code at the set position of the sign template. The information in the QR code includes the product model, production date, user number and factory code; finally, print the information at the corresponding position of the sign template and the QR code information on the preset sign to obtain the sign with the corresponding quantity and information, and complete the sign printing.

[0013] Furthermore, step 2 is specifically to set the coding rules of the factory code as needed, select the quantity and date information in the production plan, and generate continuous factory codes corresponding to the quantity and production date in the nameplate information table in sequence based on the automatic generation function that complies with the coding rules.

[0014] Furthermore, in step 4, all information corresponding to the product models required to be printed on that day is displayed in the form of a multi-row and multi-column information matrix.

[0015] Furthermore, in step 5, in the process of printing the information of the corresponding position of the sign template and the QR code information onto the preset sign, the printed row information in the multi-row and multi-column information matrix is ​​locked until it is unlocked according to the set method and can be printed again.

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

[0017] When printing a label, the present invention does not need to manually input all the information required for printing the label into the label template for printing, which greatly improves efficiency, enhances convenience, and achieves an error-proofing function. DETAILED DESCRIPTION

[0018] In order to make the purpose, advantages and features of the present invention more clear, the following specific embodiments further describe the method of automatically extracting and printing label information proposed by the present invention. According to the following specific implementation methods, the advantages and features of the present invention will be more clear.

[0019] The present embodiment provides a method for automatically extracting and printing sign information, comprising the following steps:

[0020] Step 1: Receive the given production schedule issued by the manufacturing department to the production department. The information in the production schedule is shown in Table 1 below. Each row of information includes tasks, assembly descriptions, agreement numbers, units of use, dates and quantities, status and remarks, etc.

[0021] Table 1 2024.12.20 Power take-off production schedule

[0022]

[0023]

[0024] Step 2. Set the coding rules of the factory code as needed. By selecting the quantity and date information in the production plan table, and automatically generating the coding rule-compliant function, generate the continuous factory codes corresponding to the quantity and production date in the nameplate information table in sequence, as shown in Table 2 below; the factory codes in this embodiment include common and special (user-specified coding formats), the conventional format is such as 6.24 (year) 02 (month) 00001 (number, accumulated in sequence, the maximum number of numbers is equal to the quantity); the special format is such as BA600028.

[0025] Table 2 2024.12.20 Power take-off label information table

[0026] Factory number Production Date Product Model User Number 6.241200001 2024.12.01 QH50 CH1-560 6.241200002 2024.12.01 QH50 CH1-560 6.241200003 2024.12.01 QH50 CH1-560 6.241200004 2024.12.01 QH50 CH1-560 6.241200005 2024.12.01 QH50 CH1-560 6.241200006 2024.12.01 QH50 CH1-560

[0027] Step 3, copy any row of information in the production schedule to the specified position in the label information table, and automatically assign the "assembly description" and "protocol number" in the production schedule to the "product model" and "user number" in the label information table through the function of automatically supplementing the remaining content of the label information table, and generate a complete label information table, as shown in Table 2. The information in the label information table includes product model, production date, user number and factory code, etc. It should be noted that the information in the above label information table is only an example of the embodiment of the present invention, and those skilled in the art are not limited to the above information, and can increase or decrease the required information according to actual needs, for example, increase technical requirements and / or speed ratio information.

[0028] Preferably, a column countdown may be added on the far right of the table, and the column countdown corresponds to the factory code in sequence to facilitate checking and prevent errors.

[0029] Step 4. Click the "General Flat Marking" command in the marking setting interface to open the marking setting interface. By entering the file name (label information table), model (product model to be printed on that day), and date in the dialog box in the marking setting interface, all the information corresponding to the product model will be automatically filtered out from the label information table and displayed in a multi-row and multi-column information matrix.

[0030] Step 5. Select the corresponding sign template, assign all the information corresponding to the required printed product model to the corresponding position on the sign template according to the set correspondence between the selected sign template, and automatically generate a QR code at the set position of the sign template. The information in the QR code includes the product model, production date, assembly instructions, agreement number, quantity and factory code; finally, print the information at the corresponding position of the sign template and the QR code information on the preset metal sign. In the process of printing the information at the corresponding position of the sign template and the QR code information on the preset metal sign, lock the printed row information in the multi-row and multi-column information matrix until it is unlocked according to the set method and can be printed again to obtain the metal sign of the corresponding quantity and information, and complete the sign printing.

[0031] For example, the first sign template needs to print four sets of information: "Model", "Module Number", "Factory Number" and QR code. The second sign template needs to print three sets of information: "Technical Requirements", "Factory Number" and QR code. The third sign template needs to print four sets of information: "Speed ​​Ratio", "Technical Requirements", "Factory Number" and QR code.

[0032] The information contained in the QR code is:

[0033] item=QH50F-G17011, ver=1, vender=080001, num=1, Unit=P, date=2023 / 07 / 23, batch=6.230511419.

[0034] Among them, QH50F-G17011 is composed of "product model" - "user number", 2023 / 07 / 23 is the "production date", and 6.230511419 is the "factory code".

[0035] The above QR code has the following uses:

[0036] 1. The QR code in the sign can be bound to the key and important parts

[0037] Use a barcode scanner to identify the QR codes on key or important parts and sub-assembly labels, upload the read QR code information to the real-time production management system, bind the information, and achieve traceability; secondly, achieve error prevention by comparing with the BOM in the management system.

[0038] 2. The QR code in the sign can be bound to the upper assembly

[0039] Use a barcode scanner to identify the QR code on the sub-assembly and assembly nameplate, upload the read information to the real-time production management system, bind the information, and achieve traceability; secondly, achieve error prevention by comparing with the BOM in the management system.

[0040] 3. The QR code in the sign can realize the traceability of offline inspection data

[0041] Use a barcode scanner to identify the QR code on the sub-assembly and assembly nameplate, upload the read information to the assembly offline inspection equipment, and record the inspection results accordingly to achieve traceability of offline inspection data.

Claims

1. A method for automatically extracting and printing sign information, characterized in that: The following steps are involved: Step 1: Receive a given production schedule, where each row of information includes tasks, assembly descriptions, agreement numbers, dates, and quantities; Step 2: According to the quantity and date information in the production schedule, sequentially generate the corresponding factory codes of quantity and production date in the label information table; Step 3, copy any row of information in the production schedule to the designated position in the label information table, and assign the assembly description and protocol number in the production schedule to the product model and user number in the label information table by automatically supplementing the remaining content of the information table, so as to generate a complete label information table, in which the information includes product model, production date, user number and factory code; Step 4: Based on the product model and production date to be printed on the day, all the information corresponding to the product model is filtered out from the label information table and displayed in a set manner; Step 5. Select the corresponding sign template, assign all the information corresponding to the product model to be printed to the corresponding position on the sign template according to the corresponding relationship set with the selected sign template, and automatically generate a QR code at the set position of the sign template. The information in the QR code includes the product model, production date, user number and factory code; finally, print the information at the corresponding position of the sign template and the QR code information on the preset sign to obtain the sign with the corresponding quantity and information, and complete the sign printing.

2. A method for automatically extracting and printing sign information according to claim 1, characterized in that: Step 2 is as follows: Set the coding rules of the factory code according to the needs, select the quantity and date information in the production plan, and use the automatic generation function that complies with the coding rules to generate continuous factory codes corresponding to the quantity and production date in the nameplate information table.

3. A method for automatically extracting and printing sign information according to claim 1 or 2, characterized in that: In step 4, all the information corresponding to the product models required to be printed on that day is displayed in the form of a multi-row and multi-column information matrix.

4. The method for automatically extracting and printing sign information according to claim 3, characterized in that: In step 5, when printing the information of the corresponding position of the sign template and the QR code information to the preset sign, the printed row information in the multi-row and multi-column information matrix is ​​locked until it is unlocked according to the set method and can be printed again.

Images