CN104008201B - A kind of Digit Control Machine Tool production information acquisition methods - Google Patents

Abstract

The invention discloses a kind of Digit Control Machine Tool production information acquisition methods, belong to manufacturing informatization field.Its step is：(1) log read module is write, and is installed in lathe main control computer；(2) digital control system performs numerical control code and automatically generates journal file；(3) starting log read module analyzes journal file and the structural data of acquisition is saved in described production information database；(4) in report server, Reports module is set according to the pattern that user requires, data source is set up for all forms with the tables of data of above-mentioned production information database；(5) user accesses report server by client, obtains the much information statistical report form defined in Reports module.The present invention can realize the automatic acquisition of production management related data and automatically generating for managerial report based on existing lathe log system.

Description

A method for acquiring production information of CNC machine tools

technical field

The invention belongs to the field of manufacturing informatization, and more specifically relates to a method for acquiring and counting production information of a numerically controlled machine tool.

Background technique

CNC machine tools can achieve efficient production through cyclic execution of processing programs, and are widely used in modern manufacturing. CNC machine tools can combine multiple parts to write processing programs, and realize that the program can be executed in a cycle to complete the processing of multiple parts at the same time. For example, using CNC laser cutting machine tools can cut out multiple types and specifications of parts in batches after clamping steel plates at one time. This brings complexity to management while improving efficiency. For production management, it is necessary to count the consumption of raw materials, the type and quantity of finished products, the number of waste products, and the start and end time of team production; for equipment management, it is necessary to Statistics of the total running time of equipment, failure time, execution time or times of key processes, etc. At present, there is no effective automatic statistical method for the above information, and it is difficult to obtain complete information on the working process of the machine tool, and this type of information has very important reference significance for how to improve production efficiency.

The CNC (Computer Numerical Control) system runs in the main control computer of the machine tool, and controls the operation of the machine tool by executing the NC program. The CNC system will generate a log file during operation, which records the machine status information, program execution process information and other operation information in time series. At present, log files are only used for technical personnel to troubleshoot or analyze equipment after the event, and have not been applied to the statistics of production management informatization.

The patent application document with publication number 103064905A discloses a log management method of a numerical control system. The method includes a log generation process and a log use process. The log generation process includes: dividing the information of the numerical control system into six types of log files, managing the capacity of the log files when the numerical control system is turned on, and storing the recorded logs in corresponding categories. In the log file; the log usage process includes: displaying the log file to the user in the form of a list, exporting the log file as a text file, partially intercepting the continuous operation process in the operation log, generating a script file according to the continuous operation process, and using the script The file plays back the continuous operation process, extracts all the information in the fault log, processing log, file modification log and operation log respectively, and generates the corresponding log report according to the information. The invention solves the problems of lack of data in the information management of the numerical control machine tool and the statistical analysis of the use status of the numerical control machine tool in the existing system due to the absence of log records. Since the machine tool log is oriented to the machine tool operation process, it does not solve the problems related to the statistical analysis of production management information. Specifically, the current technology cannot automatically obtain the specifications and quantities of finished products, the types and quantities of raw materials, the quantity of waste products, and the execution of key processes. Duration or times, equipment utilization and other information reports.

Contents of the invention

1. Technical issues

Existing CNC machine tools generally have the function of a log system, but the log files generated by the log system are only aimed at the operation process of the machine tool and have incomplete information, so it is impossible to completely or directly count the data reports for production management. The machine tool production information acquisition method can realize the automatic acquisition of production management related data and the automatic generation of management reports based on the existing machine tool log system, and can obtain the information in the process of production and processing of CNC machine tools and products in real time and simply.

2. Technical solution

The purpose of the present invention is achieved through the following technical solutions.

A method for obtaining production information of a CNC machine tool, the system includes a machine tool main control computer, a database server, a report server and a client; the machine tool main control computer is provided with a log reading module; the database server is provided with production information A database; a report module is set in the report server;

The steps of the information acquisition method are as follows:

(1) Connect the main control computer of the machine tool to the local area network, and deploy the database server and report server on the Internet; write the CNC machining code of the machine tool, operate the CNC machine tool system to read the CNC machining code for production, and the CNC machine tool system automatically generates log files ;

(2) In the main control computer of the machine tool, the log reading module is written according to the log file format of the machine tool. The internal process of the log reading module is as follows:

a. Obtain a list of log files;

b. Read the log files in the list one by one;

c. Scan the string information in the log file line by line;

d. Carry out time series analysis and structured processing on log lines and save structured data, establish CNC program execution information table and parts processing information table for storage; said structured data includes machine tool operation information and notes when writing CNC code product and material information;

e. Read the remaining log files in sequence and extract the data;

f. Rename the read log file and move it to the backup folder;

(3) The described log reading module automatically saves data in the described production information database, the production information database is created by the database management system installed in the database server, and the database is used to store the information read by the log reading module. At the same time, as the data source of the report module, the fields in the data table include "machine tool code", "program name", "material number", "part thickness", "steel plate size", "program start time" , "Program running end time", "Program repetition times", "Part name", "Part start cutting time", "Part weight", "Laser perforation times", "Cutting length", "Idle length", " Cutting time", "working time", "downtime" and "failure downtime";

(4) In the report server, set the report module according to the data in the production information database and the report style required by the user;

The report module is responsible for responding to the request sent by the client, generating the statistical report required by the user, defining the report format according to the requirements in the report module, and counting the corresponding data from the table of the production information database; the report view can be divided into daily, The time period of month and year or the category design of materials, procedures and parts, the data sources of all reports are established from the data tables of the above-mentioned production information database;

(5) The user accesses the report server through the client to obtain various information statistical reports defined in the report module.

Further, in the step (1), when writing the numerical control code of the machine tool, the specification information of the product, the model and the specification information of the material are written into the numerical control code in the form of comments.

3. Beneficial effect

The present invention compares with prior art, and its beneficial effect is:

(1) The original data of the production report is automatically obtained from the log system of the machine tool PLC through information technology, eliminating the need for manual recording and input;

(2) The present invention is by adding in the numerical control code the comment information relevant to the object of this code processing, as raw material type, size, finished product name, specification, weight and other information, because these comment information can follow the execution of the numerical control code Output to the log file, so that the log reading module of the present invention can obtain complete production management information, including not only machine tool operation process information, but also business information such as product specifications added in the form of programming notes;

(3) The automatic statistical information of machine tool production information report form of the present invention is comprehensive, can generate the production information report form that user cares about with machine tool, team and group, time interval etc. as statistical conditions, can realize the automation of machine tool production information statistics;

(4) The information acquisition and release in the present invention are all based on the network, so that the managed machine tool objects are not restricted by regional locations, and cross-regional information management can be realized;

(5) The present invention has high scalability and low cost, and the number of CNC machine tools managed by the present invention is not limited. When adding machine tools, it is only necessary to install a log reading system in the corresponding machine tool computer and connect to the network.

Description of drawings

Figure 1 is a network topology diagram of the processing information extraction system of a single machine tool;

Figure 2 is a functional frame diagram of the production information acquisition system of CNC machine tools;

Fig. 3 is the working flowchart of log reading system;

Fig. 4 is a schematic diagram of a machine tool production information report obtained by using the present invention.

detailed description

The technical solution of the invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments.

Example 1

Combined with Figure 2, take the production information management of a CNC laser cutting machine tool as an example. This machine tool uses the famous German Global Control CNC system:

First prepare the log reading module, which is developed in C# language, and the processing object is the log file generated by the operation of the Global Control CNC system. The log is in text format, and the log fragment example is as follows:

Since the log record is very long, a random section is intercepted here as an example. It can be seen that the log file uses text as a record unit, and each line consists of three parts. The first part at the beginning is a timestamp, such as "2011-04-22_19-14-12", which means April 22, 2011 at 19:14 Minutes and 12 seconds, the second part is the status code, such as "1213", "1211", "138", "302", etc., and the third part is the status information, such as "X=0.0Y=0.0", "S:0 ", "Part-Cut-Length/1383/525-FBM29-1", "M:MildSteel T:6.0X:1282.0Y:859.0P:'/Part Programs/k1/test program_GC/01852580.txt'", " Part-Cut-Length/2620/525-FBM29-2", these three parts are separated by multiple space characters, where the status code indicates the status of the machine, such as "1240" indicates that the CNC system loads the NC program, and the subsequent status The information indicates the path of the loaded program file, "137" indicates the start of cutting, "138" indicates the end of cutting, and the status code often needs to cooperate with the subsequent status information to express the specific meaning, such as "312S:2" indicates that the machine tool runs automatically “312S:1” means that the machine tool stops running under the automatic running state. Sometimes it is necessary to cooperate with the status codes of the front and rear log lines to judge the specific status of the machine tool, such as the following line of the “180” status code line "132" status code means that the machine tool is stopped. The meaning of the status code here is based on the German Global Control CNC system as an example. For the log meaning of other manufacturers’ CNC systems, please refer to relevant information or guess based on production experience.

The programming of the log reading module is to extract the structured machine tool processing process information according to the meaning of the above log rules, so as to be used for the statistics of the report module. As shown in Figure 3, the workflow of designing the log reading module is as follows: 1. First obtain the log file list; 2. Read the log files in the list; 3. Scan the string information in the log file line by line; 4. Identify and filter Log information, because the log information is generated in real time along with the machine's work, sometimes the machine is in a fault state, shutdown state, or idle state. At this time, a large number of log line records generated are invalid information that the user does not care about, and can be filtered. Structuralize the effective information according to the meaning of the previous code example, convert it into structured data and save it to the database; 5. Read the remaining log files in sequence and extract information; 6. Rename and move the read log files to the backup folder.

After the log reading module is compiled, it is installed in the main control computer of the CNC laser cutting machine tool. The log reading system can be set to run regularly to ensure that the log information of the CNC system can be read in time. The extracted structured data is stored in two data tables. The structure of the data tables is as follows (Table 1, Table 2). Table 1 and Table 2 are associated using the jobId field. Table 1 is used to store the machine tool to execute a certain CNC program. Information, such as the code of the machine tool used to execute the program, the specifications of the materials required for processing the program, the specifications of the products produced by the program, the number of executions of the program, the start time, the end time, etc., Table 2 is used for storage The part processing information corresponding to the information in the row of Table 1, such as cutting time, cutting length, number of perforations, working time, failure time and other information.

Table 1 NC program execution information table

Table 2 Parts processing information table

Deploy the database server, install the SQL server2005 database system in the database server, and create the production information database. This database is used to store the data read by the log reading module and also serves as the data source of the report module. Therefore, the design of the database table structure only needs It is enough to meet the data definition and access requirements of the log reading module and the report module. Generally speaking, the data table should include "machine tool code", "program name", "material number", "part thickness", and "steel plate size" , "Program running start time", "Program running end time", "Program repetition times", "Part name", "Part start cutting time", "Part weight", "Laser perforation times", "Cutting length", Fields such as "idling length", "cutting time", "working time", "downtime" and "failure downtime", as shown in Table 1 and Table 2, are used to store the structured data extracted by the log reading module. Information constitutes the database module in the present invention.

Deploy the report server, define the report format according to the needs of workshop management in the report module, and count the corresponding data from the tables of the database server. The report module in the report server is designed and realized by the RDLC report tool of Microsoft Corporation, and can also be designed by Crystal Report (Crystal Report). The report view can be designed according to time periods such as day, month, year, or materials, programs, and parts. , the data sources of all reports are established from the data tables of the upper production information database. The database system and the Web report module can also be installed in the same server.

The log reading module reads information from the CNC log and saves it in the production information database of the database server. The production information database provides a data source for the report module. The report module is responsible for responding to the request sent by the user through the Web browser, and generating the statistical report required by the user. A typical report is shown in Figure 4.

The log reading module is installed in the main control computer of the machine tool and connected to the local area network, and the database server and report server are deployed on the network. When the CNC machine tool is produced, the machine tool operator compiles the CNC code according to the product requirements. It should be noted that since the CNC program only controls the processing process of the product, the log file will usually only contain the machine tool system status and process. Information, and for some information that has management value in production but has nothing to do with machine tool operation control, it cannot be directly obtained, but such information can be written into the CNC program in the form of comments, such as product name, code, weight, etc. , size specification, material and size specification of the blank, etc., so that when the machine tool executes the NC code, it will write the above comment information into the log file, thus greatly enriching the information of the log file. The information realizes the reading of the relevant information of the processed products. The comments here are ordinary program code comments. The general comments are to help understand the meaning of the code, and the comments here are to add information to the log file.

When users view reports, they use PCs or laptops to access the report server in a wired or wireless manner. The network topology is shown in Figure 1. The reporting module retrieves relevant data from the database server and returns it to the user's computer.

Example 2

Manage production information of multiple CNC machine tools. When the present invention is used to manage multiple CNC machine tools, the method and steps are the same as in Embodiment 1, only the main control computers of all CNC machine tools need to be installed with a log reading system and connected to the workshop LAN, and the management of all machine tools is shared. The database server and the report module use the CNC machine number to distinguish different machine tools in the database table, and the log reading module uploads the machine tool number at the same time when uploading the respective machine data. In this way, statistics of production information by machine number can be realized in the report module.

Claims (1)

1. A method for acquiring production information of a numerically controlled machine tool, the system includes a machine tool main control computer, a database server, a report server and a client; the described machine tool main control computer is provided with a log reading module; the described database server is provided with a production An information database; a report module is set in the report server; The steps of the information acquisition method are as follows: (1) Connect the main control computer of the machine tool to the local area network, and deploy the database server and report server on the Internet; write the CNC machining code of the machine tool, operate the CNC machine tool system to read the CNC machining code for production, and the CNC machine tool system automatically generates log files ; In the described step (1), when writing the numerical control code of the machine tool, the specification information of the specification, model and material of the product is written in the numerical control code in the form of notes; (2) In the main control computer of the machine tool, the log reading module is written according to the log file format of the machine tool. The internal process of the log reading module is as follows: a. Obtain a list of log files; b. Read the log files in the list one by one; c. Scan the string information in the log file line by line; d. Carry out time series analysis and structured processing on log lines and save structured data, establish CNC program execution information table and parts processing information table for storage; said structured data includes machine tool operation information and notes when writing CNC code product and material information; e. Read the remaining log files in sequence and extract the data; f. Rename the read log file and move it to the backup folder; (3) The described log reading module automatically saves data in the described production information database, the production information database is created by the database management system installed in the database server, and the database is used to store the information read by the log reading module. At the same time, as the data source of the report module, the fields in the data table include "machine tool code", "program name", "material number", "part thickness", "steel plate size", "program start time" , "Program running end time", "Program repetition times", "Part name", "Part start cutting time", "Part weight", "Laser perforation times", "Cutting length", "Idle length", " Cutting time", "working time", "downtime" and "failure downtime"; (4) In the report server, set the report module according to the data in the production information database and the report style required by the user; The report module is responsible for responding to the request sent by the client, generating the statistical report required by the user, defining the report format according to the requirements in the report module, and counting the corresponding data from the table of the production information database; the report view can be divided into days, months, and years The time period or category design of materials, procedures, and parts, and the data sources of all reports are established from the data tables of the above-mentioned production information database; (5) The user accesses the report server through the client to obtain various information statistical reports defined in the report module.