CN213210789U

CN213210789U - Data acquisition and monitoring system based on SCADA system

Info

Publication number: CN213210789U
Application number: CN202022504470.5U
Authority: CN
Inventors: 黄栋斐; 程明; 李福有; 何慧强
Original assignee: Dongguan Gaofei Electronic Technology Co ltd
Current assignee: Dongguan Gaofei Electronic Technology Co ltd
Priority date: 2020-11-03
Filing date: 2020-11-03
Publication date: 2021-05-14
Anticipated expiration: 2030-11-03

Abstract

The utility model belongs to the technical field of copper-clad plate production and processing technique and specifically relates to indicate a data acquisition and monitored control system based on SCADA system, including host computer, switch and through switch and host computer communication connection's a plurality of conversation controlling means HMI to and the execution controller of being connected with conversation controlling means electricity, execution controller is connected with the sensor electricity of installing in actuating mechanism, WinCC control software is installed to the host computer, is configured into the data in the access execution controller, the utility model discloses break through system architecture in the past, the similar SCADA data acquisition of development configuration and the control system of control increase data control layer between equipment CPU and host computer WinCC, be responsible for accomplishing contents such as data pre-collection, data editing, data increase, data format preliminary treatment. The system greatly improves the working efficiency, effectively ensures the authenticity and reliability of data, optimizes the working process, reduces personnel establishment and paper waste, and has strong practicability.

Description

Data acquisition and monitoring system based on SCADA system

Technical Field

The utility model relates to a copper-clad plate production and processing technology field especially indicates a data acquisition and monitoring system based on SCADA system.

Background

Automatic prepreg production equipment (called gluing machine in industry) is the most important equipment for producing copper-clad plates, and the prepreg production equipment in a certain workshop mainly comprises two vertical gluing machines and an RTO (Regenerative Thermal Oxidizer) treatment system.

In order to guarantee the yield of the copper-clad plate and the retrospection of the quality problem of the later stage of the product in the production process, the operation data of the sizing equipment is required to be as follows: the method is characterized in that the wind mill frequency, the wind pressure of the wind mill, the temperature of a combustion chamber, the temperature of waste gas, the concentration of the waste gas, an air valve and other dozens of data are monitored, recorded and stored for three years, for old equipment, due to the limited function of the system architecture problem, the recording of the operation data of the equipment is mainly carried out by configuring a special meter reading post in a control room, and a meter reading person regularly inspects the manual recording of the data required by the operation of the equipment and then inputs the data into a computer, so that the accuracy of the data cannot be ensured, and the problems of error reading, missing reading; the data are recorded into a computer after being manually copied, the workload is large, repetitive work exists, and error data are possibly recorded.

The new equipment introduced in recent years is provided with data acquisition and recording functions, but because the new equipment is general equipment produced by manufacturers, the new equipment also has the following defects and shortcomings in the using process: firstly, recording data once after a set interval time is reached, wherein a time frame is a parameter which is regularly acquired, the state gradual change process is generally difficult to identify in a timing recording system, and although partial data in the system can be automatically identified and alarmed, a plurality of important parameters and states cannot be identified (such as air valve position, LEL concentration monitoring, abnormal oil consumption change and the like); secondly, the operation parameter (such as temperature) abnormity of the equipment is usually a gradual change process without manual monitoring and checking, and a traditional manual meter reading method has the responsibility of checking and checking the operation parameter of the equipment, so that the abnormity of the equipment can be found and corresponding adjustment can be made in time; in addition, the data cannot be recorded by original old equipment and instruments without the automatic data acquisition function.

Disclosure of Invention

The to-be-solved technical problem of the utility model is to provide a break through system architecture in the past, the similar SCADA data acquisition of development configuration and the control system of control increase the data control layer between equipment CPU and host computer WinCC, are responsible for accomplishing contents such as data preliminary collection, data editing, data increase, data format preliminary treatment. The system greatly improves the working efficiency, effectively ensures the authenticity and reliability of data, optimizes the working process, reduces personnel establishment and paper waste, and has strong practicability.

In order to solve the technical problem, the utility model discloses a following technical scheme: the data acquisition and monitoring system based on the SCADA system comprises an upper computer, a switch, a plurality of session control devices HMI which are in communication connection with the upper computer through the switch, and an execution controller which is electrically connected with the session control devices, wherein the execution controller is electrically connected with a sensor arranged on an execution mechanism, the upper computer is provided with WinCC control software and is configured to access data in the execution controller,

the data entry and acquisition steps are as follows:

step A, an execution controller transmits PLC data to be acquired to a session control device HMI;

b, the upper computer reads the local address of the HMI through an MODBUS TCP/IP communication protocol and calls PLC data;

and step C, the upper computer presets the address of the MODBUS TCP/IP communication protocol to correspond to the address of the execution controller by utilizing WinCC control software, and then accesses the PLC data on the execution controller by utilizing the MODBUS TCP/IP communication protocol.

Preferably, the MODBUS TCP/IP communication protocol adopts a continuous register mode for reading and writing.

Preferably, the WinCC control software of the upper computer reads and sorts the PLC data directly read by the execution controller and the data of the macro instruction by the macro instruction, and stores the sorted PLC data and the data of the macro instruction into a self-defined array inside the dialog control device HMI through a SetData instruction.

Preferably, the dialogue control device HMI is provided with a system interaction interface and a recording interface for displaying monitoring data.

Preferably, the dialog control device HMI is provided with a manual confirmation button.

Preferably, the monitoring data collected by the sensor are displayed on a recording interface in real time, after the manual confirmation button is triggered, the monitoring data and the PLC data are uploaded to an upper computer for storage, and in the data storage process, the recording interface displays the time and the monitoring data which are recorded successfully at the last time.

Preferably, the state of the switches in the actuator is represented in digital form.

The utility model also provides a copper-clad plate rubberizing system based on data acquisition of SCADA system and monitored control system, including data entry collection system, actuating mechanism is copper-clad plate rubberizing equipment.

Preferably, the actuator includes a windmill, a combustion chamber, an exhaust gas discharge device, and an air valve, and the sensor includes a frequency sensor for detecting a frequency of the windmill, a sensor for detecting a wind pressure, a switching sensor for detecting a state of the damper, and a temperature sensor for detecting a temperature of the combustion chamber and a temperature of the exhaust gas.

Preferably, the detection result of the opening/closing sensor is represented in a digital form, and the numbers "0, 1, and 2" represent "open, closed, and abnormal" of the damper, respectively.

The beneficial effects of the utility model reside in that: the utility model relates to a data acquisition of SCADA system and monitor control system's beneficial effect as follows:

the conversation control device is friendly in HMI interface, and can acquire all and accurately various data of various instruments and equipment, and the format processing is correct.

And secondly, after the collected data are checked by the equipment operation staff, some process data which cannot be collected from the outside (for example, part of detection equipment or mechanisms do not have an electric signal feedback device due to the requirement of on-site explosion prevention) but need to be recorded can be input, and the process data are confirmed and stored after the work number is input.

And thirdly, the upper computer system is required to operate stably and reliably, and has good compatibility with control systems such as Siemens S7-300 series and Mitsubishi Q series.

And fourthly, uploading the acquired data to a database, and having related functions of inquiry, retrieval, printing, exception prompt and the like.

And fifthly, automatically optimizing a protocol by the system, automatically packaging and reading data acquisition, and acquiring the data at the rate of 100M by the Ethernet.

Drawings

Fig. 1 is the design flow block diagram of the data recording and collecting system of the present invention.

Fig. 2 is the schematic block diagram of the data input acquisition system of the present invention constructed during design.

Detailed Description

In order to facilitate the understanding of those skilled in the art, the present invention will be further described with reference to the following examples, which are not intended to limit the scope of the present invention.

As shown in fig. 1 to 2, a data acquisition and monitoring system based on SCADA system includes an upper computer 1, an exchanger 2, a plurality of session control devices HMI3 communicatively connected with the upper computer 1 through the exchanger 2, and an execution controller 4 electrically connected with the session control devices, wherein the execution controller 4 is electrically connected with a sensor 6 installed in an execution mechanism 5, the upper computer 1 is installed with WinCC control software configured to access data in the execution controller 4, and the data recording and acquisition steps are as follows:

step A, the execution controller 4 transmits PLC data to be acquired to a conversation control device HMI 3;

b, the upper computer 1 reads a local address of the HMI through an MODBUS TCP/IP communication protocol and calls PLC data;

and step C, the upper computer 1 presets the address of the MODBUS TCP/IP communication protocol to correspond to the address of the execution controller 4 by utilizing WinCC control software, and then accesses the PLC data on the execution controller 4 by utilizing the MODBUS TCP/IP communication protocol.

In this embodiment, the MODBUS TCP/IP communication protocol uses a continuous register mode for reading and writing.

In practical application, the system is based on an SCADA (supervisory control and data acquisition) system, namely a data acquisition and monitoring control system, utilizes Modbus TCP drive in WinCC V7.3 to compile related interface correspondence and data conversion programs by scripts in a touch screen macro, converts the protocol of Mitsubishi and the protocol of Siemens and then transmits the converted protocols to an upper computer 1 for acquisition, and selects a Weilun MT8050iE touch screen as protocol conversion processing and manual parameter input equipment. MT8050iE is equivalent to Server in the acquisition system, WinCC V7.3 reads and writes macro-processed data through MODBUS TCP/IP Server and records the data in SQL database.

The specific system design steps are as follows:

1. constructing a block diagram of the system as described in FIG. 1, as shown in FIG. 2

2. Touch screen data acquisition and processing for data control layer

3. Address mapping for dialog control devices

4. Data processing

5. Touch screen interface design for dialog control device

6. Upper computer 1 system design

7. Variable data archiving

8. Data writing

9. Database query

10. Data acquisition and processing

As shown in the system block diagram of fig. 2, the control layer touch screen is connected to the company network switch 2 through an ethernet port, communicates with siemens and mitsubishi PLC through invoking corresponding drivers, and the upper computer 1 is installed in an office to complete data collection and recording functions, and is convenient for relevant responsible persons to inquire

In this embodiment, the WinCC control software of the upper computer 1 reads and collates the PLC data directly read by the execution controller 4 and the data of the macro instruction by the GetData instruction through the macro instruction, and then stores the data into a self-defined array inside the dialog control device HMI3 through the SetData instruction.

In this embodiment, the dialog control device HMI3 is provided with a system interface and a recording interface for displaying monitoring data.

In this embodiment, the dialog control device HMI3 is provided with a manual confirmation button.

In this embodiment, the monitoring data collected by the sensor 6 are displayed on the recording interface in real time, after the manual confirmation button is triggered, the monitoring data and the PLC data are uploaded to the upper computer 1 for storage, and in the data storage process, the recording interface displays the time and the monitoring data recorded successfully for the last time.

In this embodiment, the state of the switch in the actuator 5 is represented in digital form.

The utility model also provides a copper-clad plate rubberizing system of data acquisition and monitored control system based on SCADA system, include data entry collection system, actuating mechanism 5 is copper-clad plate rubberizing equipment.

Wherein, the actuating mechanism 5 includes a windmill, a combustion chamber, an exhaust gas discharge device and an air valve, the sensor 6 includes a frequency sensor 6 for detecting the frequency of the windmill, a sensor 6 for detecting the air pressure, an on-off sensor 6 for detecting the state of the air door, and a temperature sensor 6 for detecting the temperature of the combustion chamber and the temperature of the exhaust gas.

In the present embodiment, the detection result of the opening/closing sensor 6 is represented in a digital form, and the numbers "0, 1, and 2" represent "open, closed, and abnormal" of the damper, respectively.

The working principle of the utility model is as follows: when WINCC7.3 accesses the PLC data connected with HMI, the PLC data is firstly transmitted to the local address of HMI through data transmission, and then the local address of HMI is read by PC using MODBUS TCP/IP communication protocol to retrieve the PLC data. The system can directly access the data on the PLC by using the MODBUS TCP/IP communication protocol after the MODBUS address is preset and corresponds to the address of the PLC.

The system reads and arranges the data directly read by the PLC and the data of the macro instruction by the macro instruction through the GetData instruction, and then stores the data into a self-defined array in the HMI through the SetData instruction, and the array is the communication content of the MODBUS. The communication speed of MODBUS communication in a continuous register read-write mode is effectively increased.

The specific codes are as follows:

macro_command main()

short GetD[30]

GetData(GetD[0],"Mitsubishi Q02/02H",D,65,1)

GetData(GetD[1],"Mitsubishi Q02/02H",D,60,1)

GetData(GetD[2],"Mitsubishi Q02/02H",D,64,1)

GetData(GetD[3],"Mitsubishi Q02/02H",D,52,1)

GetData(GetD[4],"Mitsubishi Q02/02H",D,99,1)

GetData(GetD[5],"Mitsubishi Q02/02H",D,38,1)

GetData(GetD[6],"Mitsubishi Q02/02H",D,30,4)

GetData(GetD[10],"Mitsubishi Q02/02H",D,345,1)

GetData(GetD[11],"Mitsubishi Q02/02H",D,34,4)

GetData(GetD[15],"Mitsubishi Q02/02H",D,346,1)

GetData(GetD[16],"Mitsubishi Q02/02H",D,51,1)

GetData(GetD[17],"Mitsubishi Q02/02H",D,41,2)

GetData(GetD[19],"Mitsubishi Q02/02H",D,2071,1)

GetData(GetD[20],"Mitsubishi Q02/02H",D,43,2)

GetData(GetD[22],"Mitsubishi Q02/02H",D,66,1)

GetData(GetD[23],"Local HMI",RW,22,7)

SetData(GetD[0],"Local HMI",RW,100,30)

end macro_command。

the macro-instruction is used for writing codes to obtain the air door state information of the waste gas treatment system, and the bit state of the Mitsubishi PLC is directly read through the GetData instruction. Since no text information can be saved in a mixed manner in the WinCC database, the system processes the data to represent the state 0 of the damper in a numerical form: turning off 1: opening 2: and (4) abnormal data, namely processing identification program INT data of the data acquired by the BOOL, and writing the processed data into a memory register of the touch screen through a SetData instruction for the upper computer 1 to read. The specific codes are as follows:

macro_command main()

bool M2333

bool M2334

bool M2349

bool M2350

bool L[2]

short intL[2]

GetData(M2333,"Mitsubishi Q02/02H",M,2333,1)

GetData(M2334,"Mitsubishi Q02/02H",M,2334,1)

GetData(M2349,"Mitsubishi Q02/02H",M,2349,1)

GetData(M2350,"Mitsubishi Q02/02H",M,2350,1)

if M2334 and M2333= =0 then// door position in furnace state open

L[0]=1

intL[0]=1

else if M2333 and M2334= =0 then// in-furnace damper position status off

L[0]=0

intL[0]=0

else if (M2333= =1 and M2334= =1) or (M2333= =0 and M2334= =0) the/in-furnace damper position status abnormality

intL[0]=2

end if

if M2349 and M2350= =0 then// chimney damper position state open

L[1]=1

intL[1]=1

else if M2350 and M2349= =0 then// chimney damper position state closed

L[1]=0

intL[1]=0

else if (M2349= =1 and M2350= =1) or (M2349= =0 and M2350= =0) the/chimney damper position state anomaly

intL[1]=2

end if

SetData(L[0],"Local HMI",LB,0,2)

SetData(intL[0],"Local HMI",RW,22,2)

end macro_command。

The system interaction interface comprises a login interface, a main interface, an on-line state interface, a data management and recording interface, an alarm interface and the like, and relevant equipment operators verify that data are abnormal and input relevant parameters such as the opening degree of an air valve, the current natural gas consumption and the work number of the operators and then press a confirmation button to trigger the upper computer 1 to collect the data. After the confirmation button is pressed, the touch screen displays 'data storage in the process' and returns a record completion signal after the upper computer 1 finishes acquisition, and the last recording time of the touch screen is updated to the last successful recording time of the system. Data is important in the production process, a line or an exchanger or a computer fault may exist in a network communication system, and an operator of the terminal is informed to perform corresponding processing when any fault is generated and storage is unsuccessful. After the confirming button is pressed, if the background storage fails, a 'storage failure' window can be popped up to remind an operator, the reliability of PLC data and monitoring data is guaranteed through the improvement, the method not only is a root source for tracing the subsequent product quality problem, but also is important audit content for auditing of listed companies, and the practicability is high.

Siemens configuration software WinCC has strong functions in the aspects of monitoring data in production and the running state of equipment, WinCC7.3 supports the programming of a database SQL and a VB-Script, the direct operation on the database can be realized, and the data can be written into an SQL data table. The VB-Script programming can realize the functions of filing, inquiring, displaying and printing data, thereby greatly improving the flexibility of data storage and report forms and designing a self-defined report form meeting the requirements of users.

The system interaction interface has real-time data monitoring contents, managers can monitor the running state of the equipment in real time in offices, relevant data cannot be read when network faults occur, and question marks can appear in data frames, so that system faults can be found timely.

The production backtracking is carried out on the premise that a production backtracking database is established, all production information needing backtracking is recorded into the database, a plurality of information recording methods based on the WinCC configuration environment exist, and the WinCC filing database or the relational database is operated by adopting a WinCC VBS script in the project.

And establishing a filing variable in the variable record, connecting the filing variable with a system management variable, setting variable record event control as variable control through filing variable configuration, triggering database writing once when the set initial variable BOOL variable is subjected to bit change, and setting the detection change period of the variable to be 500 ms.

The global script needs to monitor the state of a button on the touch screen in real time, when the button "confirm" on the touch screen is pressed down, a corresponding variable of the system is set, meanwhile, the touch screen waits for the confirmation information stored in the system, and the waiting time is 3S, so that the "RTOhmiok" variable which is refreshed mutually corresponding to the touch screen in the following procedures executes setting processing after the XOR operation of a data storage flag bit "startRTO", and specific codes are as follows:

Option Explicit

Function action

'RTO

Dim RTOhmiok

Set RTOhmiok=HMIRuntime.Tags("ok_RTO")

RTOhmiok.Read

If RTOhmiok.value=1 Then

Dim startRTO

Set startRTO=HMIRuntime.Tags("Save_RTO")

startRTO.Write startRTO.Read Xor 1

RTOhmiok.Value=0

RTOhmiok.Write

End If

End Function

the 'WinCC Online TableContrl' control is quoted in the monitoring picture, related parameters are configured, data columns corresponding to the archived content are defined, functions needing to be used are reserved, and records corresponding to time periods can be searched through the time selection control during running

In the data acquisition and processing process, the VBS script is applied to the global script to write the data processing program, so that the corresponding script program executes operation once per second, and the speed can meet the project requirement. In order to improve the speed of MODBUS TCP/IP communication, the uniformity and continuity of data formats and convenience in transmission, data needing to be communicated in the project are defined into INT and BOOL formats, and therefore further processing is needed after data acquisition. For example: the temperature display should be real, so the collected data needs to be divided by 10, and the specific codes are as follows:

Option Explicit

Function action

Dim D1a

set D1a = hmiruntitime. tags ("vehicle speed _ D1")

D1a.Read

Dim D1b

Set D1b=HMIRuntime.Tags("Speed_D1")

D1b.Read

D1b.Value=D1a.Value/10

D1b.Write

Dim D2a

Set D2a = hmiruntitime. tags ("vehicle speed _ D2")

D2a.Read

Dim D2b

Set D2b=HMIRuntime.Tags("Speed_D2")

D2b.Read

D2b.Value=D2a.Value/10

D2b.Write

Dim RTOa

Set RTOa = hmiruntitime. tags ("main windmill frequency")

RTOa.Read

Dim RTOb

Set RTOb=HMIRuntime.Tags("RTO_MINHZ")

RTOb.Read

RTOb.Value=RTOa.Value/10

RTOb.Write

Dim RTOc

Set RTOc = hmiruntitime. tags ("circulating windmill operating frequency")

RTOc.Read

Dim RTOd

Set RTOd=HMIRuntime.Tags("RTO_CYCLEHZ")

RTOd.Read

RTOd.Value=RTOc.Value/10

RTOd.Write

End Function

In the description of the present invention, it should be noted that, for the orientation words, such as the terms "center", "lateral (X)", "longitudinal (Y)", "vertical (Z)", "length", "width", "thickness", "upper", "lower", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", "clockwise", "counterclockwise", etc., it indicates that the orientation and positional relationship are based on the orientation or positional relationship shown in the drawings, and it is only for convenience of describing the present invention and simplifying the description, but it is not intended to indicate or imply that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and should not be construed as limiting the specific scope of the present invention.

Furthermore, if the terms "first" and "second" are used for descriptive purposes only, they are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features. Thus, the definition of "a first" or "a second" feature may explicitly or implicitly include one or more of the features, and in the description of the invention, "a plurality" means two or more unless specifically defined otherwise.

In the present invention, unless otherwise expressly specified or limited, the terms "assembled", "connected", and "connected", if any, are to be construed broadly, e.g., as meaning fixedly connected, detachably connected, or integrally connected; or may be a mechanical connection; the two elements can be directly connected or connected through an intermediate medium, and the two elements can be communicated with each other. The specific meaning of the above terms in the present invention can be understood by those of ordinary skill in the art according to specific situations.

The above-mentioned embodiments only express a plurality of embodiments of the present invention, and the description thereof is specific and detailed, but not construed as limiting the scope of the present invention. It should be noted that, for those skilled in the art, without departing from the spirit of the present invention, several variations and modifications can be made, which are within the scope of the present invention. Therefore, the protection scope of the present invention should be subject to the appended claims.

Claims

1. Data acquisition and monitored control system based on SCADA system, including host computer (1), switch (2) and through switch (2) and host computer (1) communication connection's a plurality of conversation controlling means HMI (3) to and execution controller (4) of being connected with conversation controlling means electricity, execution controller (4) are connected with sensor (6) of installing in actuating mechanism (5) electricity, its characterized in that: the upper computer (1) is provided with WinCC control software and is configured to access data in the execution controller (4).

2. A SCADA system based data acquisition and monitoring system according to claim 1, characterized in that: the session control device HMI (3) is provided with a system interaction interface and a recording interface for displaying monitoring data.

3. A SCADA system based data acquisition and monitoring system according to claim 2, characterized in that: the dialog control device HMI (3) is provided with a manual confirmation button.

4. A SCADA system based data acquisition and monitoring system according to claim 1, characterized in that: the monitoring data collected by the sensor (6) are displayed on a recording interface in real time, after the manual confirmation button is triggered, the monitoring data and the PLC data are uploaded to the upper computer (1) to be stored, and in the data storage process, the recording interface displays the time and the monitoring data which are recorded successfully at the last time.

5. A SCADA system based data acquisition and monitoring system according to claim 1, characterized in that: the actuating mechanism (5) is copper-clad plate gluing equipment.