CN111026460B - Method and device for rapidly allocating points by using regional templates in configuration tool - Google Patents

Method and device for rapidly allocating points by using regional templates in configuration tool Download PDF

Info

Publication number
CN111026460B
CN111026460B CN201911236648.8A CN201911236648A CN111026460B CN 111026460 B CN111026460 B CN 111026460B CN 201911236648 A CN201911236648 A CN 201911236648A CN 111026460 B CN111026460 B CN 111026460B
Authority
CN
China
Prior art keywords
point
table file
equipment
header
point table
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201911236648.8A
Other languages
Chinese (zh)
Other versions
CN111026460A (en
Inventor
高红伟
姜闿笈
陈旭晖
邱富东
王振华
张文礼
王泽军
叶先亮
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xinao Shuneng Technology Co Ltd
Original Assignee
Xinao Shuneng Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Xinao Shuneng Technology Co Ltd filed Critical Xinao Shuneng Technology Co Ltd
Priority to CN201911236648.8A priority Critical patent/CN111026460B/en
Publication of CN111026460A publication Critical patent/CN111026460A/en
Application granted granted Critical
Publication of CN111026460B publication Critical patent/CN111026460B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/445Program loading or initiating
    • G06F9/44521Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading
    • GPHYSICS
    • G05CONTROLLING; REGULATING
    • G05BCONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
    • G05B19/00Programme-control systems
    • G05B19/02Programme-control systems electric
    • G05B19/04Programme control other than numerical control, i.e. in sequence controllers or logic controllers
    • G05B19/05Programmable logic controllers, e.g. simulating logic interconnections of signals according to ladder diagrams or function charts
    • G05B19/058Safety, monitoring
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof

Landscapes

  • Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Automation & Control Theory (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Stored Programmes (AREA)
  • Programmable Controllers (AREA)

Abstract

The invention is suitable for the technical field of SCADA configuration tool application, and provides a method and a device for rapidly allocating points by using a region template in a configuration tool, wherein the method comprises the following steps: correcting according to the configured first point table file to generate a second point table file of the point area to be matched; analyzing the second point table file to generate a measuring point structure body; according to the measuring point structure body, creating logic equipment, logic nodes and measuring points; and creating channels according to the actual conditions of the on-site hardware equipment, and carrying out batch mounting on the equipment through a newly designed interface. The invention adopts the unified point table file format of the point to be allocated area, has compatibility, and can adapt to the point allocation requirements of different devices, so that templates are not required to be independently created one by one in the point allocation process, the data configuration process can be greatly simplified by using the unified templates, and the configuration efficiency and accuracy of the data are obviously improved.

Description

Method and device for rapidly allocating points by using regional templates in configuration tool
Technical Field
The invention belongs to the technical field of SCADA configuration tool application, and particularly relates to a method and a device for rapidly allocating points by using a regional template in a configuration tool.
Background
The data acquisition and monitoring control system (Supervisory Control And Data Acquisition system, hereafter referred to as SCADA) is a man-machine interaction system for monitoring and controlling factories and engineering equipment, comprising: the system comprises a monitoring computer, a remote terminal unit (Remote Terminal Units, hereinafter referred to as RTU), a programmable logic controller (Programmable Logic Controller, hereinafter referred to as PLC), a communication infrastructure, a human-machine interface (Human Machine Interaction, referred to as HMI) and the like, wherein the RTU and the PLC are in communication connection with field devices, an operator initiates a command through the human-machine interface, and then the monitoring computer controls the RTU and the PLC to execute the command on the field devices, so that remote monitoring is realized.
When the SCADA is constructed, the field devices are matched with the primitives in the human-computer interface one by one to form accurate remote control, the existing device configuration points are configured one by one, each device is required to be respectively built with a configuration template, when the area is large and the number of devices is large, different devices form more templates, at the moment, the configuration process is extremely complex and the configuration is easy to make mistakes one by one; the addition of the distribution points one by one is carried out according to the equipment, so that great workload and pressure are brought to personnel configuring engineering, and the engineering is wrong with little carelessness.
Therefore, the prior art lacks a rapid point allocation method applicable to different devices, and when the devices with a large number and variety are allocated, the workload of allocation personnel is large and errors are easy to occur.
Disclosure of Invention
In view of this, the embodiment of the invention provides a method and a device for rapidly allocating points by using a region template in a configuration tool, so as to solve the problem that each device needs to be allocated one by one when allocating points to a plurality of devices in the prior art.
A first aspect of an embodiment of the present invention provides a method for quickly allocating points by using a region template in a configuration tool, including:
generating a second point table file of the point area to be allocated according to the configured first point table file;
analyzing the second point table file to generate a measuring point structure body;
creating logic equipment, logic nodes and measuring points according to the measuring point structure body;
and creating a channel of the field device, mounting the corresponding field device, and completing configuration of the measuring point.
A second aspect of the present invention provides a device for quick matching points by using a region template in a configuration tool, including:
the point table file acquisition module is used for generating a second point table file of the point area to be allocated according to the configured first point table file;
the measuring point structure body acquisition module is used for analyzing the second point table file to generate a measuring point structure body;
the first creation module is used for creating logic equipment, logic nodes and measuring points according to the measuring point structural body;
the second creation module is used for creating a channel of the field device and mounting the corresponding field device to complete the configuration of the measuring point.
A third aspect of the embodiments of the present invention provides a terminal device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the above method when executing the computer program.
A fourth aspect of the embodiments of the present invention provides a computer readable storage medium storing a computer program which, when executed by a processor, implements the steps of the above method.
Compared with the prior art, the embodiment of the invention has the beneficial effects that: the embodiment of the invention adopts the unified point table file format of the point to be distributed area, namely the second point table file has compatibility, and can adapt to the point distribution requirements of different devices, so that templates are not required to be independently created one by one in the point distribution process, the unified templates are used, the data configuration process can be greatly simplified, and the configuration efficiency and accuracy of data are obviously improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of an implementation flow of a method for quick allocation of points by using a region template in a configuration tool according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of an implementation flow for generating a second point table file according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of an implementation flow for creating a logical device, a logical node, and a measurement point according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of an implementation flow of creating a channel and mounting a field device according to an embodiment of the present invention;
FIG. 5 is a flowchart illustrating a complete implementation of a method for rapid point allocation of a boiler plant according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of a parameter setting for creating a channel provided by an embodiment of the present invention;
FIG. 7 is a schematic diagram of an apparatus for selecting an unconfigured channel provided by an embodiment of the present invention;
FIG. 8 is a schematic diagram of a batch mounting device to channel provided by an embodiment of the present invention;
FIG. 9 is a schematic diagram of an apparatus for quick matching of points using region templates in a configuration tool according to an embodiment of the present invention;
fig. 10 is a schematic diagram of a terminal device according to an embodiment of the present invention.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth such as the particular system architecture, techniques, etc., in order to provide a thorough understanding of the embodiments of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail. All other embodiments, which are obtained by a person skilled in the art based on the described embodiments of the invention, fall within the scope of protection of the invention. The technical means used in the examples are conventional means well known to those skilled in the art unless otherwise indicated.
It should be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It is also to be understood that the terminology used in the description of the present application is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in this specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes such combinations.
As used in this specification and the appended claims, the term "if" may be interpreted as "when..once" or "in response to a determination" or "in response to detection" depending on the context. Similarly, the phrase "if a determination" or "if a [ described condition or event ] is detected" may be interpreted in the context of meaning "upon determination" or "in response to determination" or "upon detection of a [ described condition or event ]" or "in response to detection of a [ described condition or event ]".
In order to illustrate the technical scheme of the invention, the following description is made by specific examples.
Referring to fig. 1, a method for quick matching points by using a region template in a configuration tool according to an embodiment of the invention includes:
step S10: generating a second point table file of the point area to be allocated according to the configured first point table file;
step S20: analyzing the second point table file to generate a measuring point structure body;
step S30: creating logic equipment, logic nodes and measuring points according to the measuring point structure body;
step S40: and creating a channel of the field device, mounting the corresponding field device, and completing configuration of the measuring point.
The point table file is a table file for displaying and storing the information of the measuring points in a list form, wherein each row of data of one measuring point is classified by different data of the measuring point. Normally, when the SCADA needs to be created, the site has completed the initial debugging on the field device, so that the configuration point table file after the debugging can be directly exported by adopting the PLC configured on the site, or the configuration point table file after the debugging, namely the first point table file, can be exported by a gateway. All information of the field device is almost contained in the first point table file, but only a few items of the information are needed in the actual point allocation process, so that the first point table file needs to be deleted and subjected to format correction to form unified format measurement point data, namely the second point table file.
Each row in the second point table file represents a device measuring point to be configured, and corresponding measuring point structures are respectively generated for each device measuring point by analyzing table data so as to facilitate subsequent configuration work. The steps can smoothly obtain the measuring points needing to be matched by generating a measuring point table with a uniform format, so that a measuring point structure body is quickly generated, and each equipment measuring point is not required to independently create templates to be matched one by one.
After the measuring point structure body is generated, virtual logic equipment, logic nodes and measuring points are correspondingly created in the system, and finally channels of the field equipment and the virtual logic equipment, the virtual nodes and the measuring points are established, so that the configuration of the measuring points is completed, and the field equipment and the SCADA platform can realize data communication and control.
The embodiment adopts a unified point table file format of the to-be-allocated point area, namely the second point table file has compatibility, and can adapt to the allocation requirements of different devices, so that templates are not required to be independently created one by one in the allocation process, the data configuration process can be greatly simplified by using the unified templates, and the configuration efficiency and accuracy of the data are remarkably improved. Thanks to the second point table file, the method can carry out batch configuration of the measuring points on the equipment, greatly simplifies the work flow of a large number of equipment during point configuration, is simple and convenient to check, and reduces the error rate.
More specifically, in the present embodiment, step S10: according to the configured first point table file, generating a second point table file of the to-be-configured point area as shown in fig. 2 may include:
step S101: deleting redundant headers in the first point table file and information of columns where the redundant headers are located according to the header format of the point table file template;
step S102: comparing the first point table file with a general information model, and judging whether the cell content of which the table head is a column of the equipment instance in the first point table file exists in the general information model correspondingly or not;
if the cell content of the column whose header is the device instance in the first point table file is correspondingly present in the generic information model, step S103 is entered: the corresponding rows of the existing cells are reserved;
if the cell content of the column whose header is the device instance in the first point table file does not exist in the generic information model, step S104 is entered: deleting the row corresponding to the non-existing cell;
step S105: screening the list of which the header is a point location in the first point list file, and judging whether the cell content of the list of which the header is a point location is empty or not;
if the cell content of the column with the header being the point location is empty, the step S106 is entered: deleting the row corresponding to the empty cell;
if the cell content of the column with the header being the point location is not empty, the process proceeds to step S107: the rows corresponding to the non-empty cells are reserved.
Because the information amount in the obtained spot table file of the field configuration is more, if the workload is increased in all the processing, the spot table file needs to be adjusted, the formats of the spot table file are unified firstly, namely, other information except the most critical measuring point information needs to be reserved can be deleted, and finally the measuring point data amount is reduced;
the general information model (Common Information Model, abbreviated as CIM hereinafter) can be suitable for most measuring points, so that a template can be established according to the data types in the CIM when the measuring points are configured, and for the equipment instances which do not exist in the CIM, configuration is not suggested in the embodiment, so that all the equipment instances which do not exist in the CIM are deleted, and the data volume is reduced;
in general, a measurement point with an empty point location may be regarded as a measurement point that does not need to be monitored and controlled, and may be deleted.
In addition, the steps S101, S102-104, and S105-107 may be adopted and the sequence of the steps may be changed arbitrarily, and is not limited to the above sequence.
Preferably, the header format of the point table file template in this embodiment includes: the description, address, subsystem instance code, device instance, device name, point location, point type, control type. The sequence of the headers can be adjusted according to actual demands or habits, and is not limited to the sequence.
For step S20: and analyzing the second point table file to generate a measuring point structure body, wherein the second point table file is used as a unified template of a large number of devices, the analysis method is simpler, and the data of each row can be obtained by only reading the second point table file by adopting table analysis software to form measuring point data of all measuring points.
Whereas the site structure may include: the device address, the measuring point name, the energy station name, the equipment instance, the point type, the control type, the universal template path, the affiliated interval container, the container type, the affiliated area identifier, the measuring point type, the remote terminal unit description and the like can be directly obtained through the second point table file, but the universal template path, the affiliated interval container, the container type, the affiliated area identifier, the measuring point type and the remote terminal unit are not contained in the second point table file, at the moment, data acquisition software such as mtide is needed, required data are read and spliced from the files such as CIM, the energy station and the power station, and finally, the data are stored according to the formats of the energy station, the equipment and the equipment instance to which the equipment belongs, so that a corresponding large number of measuring point structures are obtained.
And the step S20: in the step of analyzing the second point table file to generate the measurement point structure body, the analysis condition of the second point table file may further include:
the number of columns of the table, the name of the table header are consistent with the format of the table header of the dot table file template;
except the row where the header is located, the contents of the other rows are correct data;
the file name contains a variable table.
And if all the conditions are met, calculating the correct second point table file, and performing subsequent operation on the second point table file, otherwise, re-verifying or acquiring the correct second point table file, thereby ensuring the accuracy of the final configuration point. The contents of the other rows except the row where the header is located are data formats corresponding to the header, so that the data can be regarded as correct, and when the table file is stored, only the second point table file format can store the file name of the variable table XXX, otherwise, three words of the variable table can not be stored, and when the table file is analyzed, only the file containing the three words of the variable table can be regarded as the second point table file.
Referring to fig. 3, the step S30: creating a logical device, a logical node, a measurement point may include:
step S301: newly-building remote terminal unit equipment and setting parameters of the remote terminal unit equipment;
step S302: creating logic equipment and logic nodes corresponding to the remote terminal unit equipment;
step S303: and creating the measuring point according to the point type and the control type of the measuring point structure body.
According to the requirements of the SCADA platform communication model, the field device needs to rely on a logic device and a logic node to acquire communication data, so that before the measurement point configuration is implemented, RTU equipment, corresponding logic devices and logic nodes are required to be established, and then the measurement point of the RTU equipment is set.
When the RTU equipment is newly built, the matched equipment instance is directly copied to form the new RTU equipment only by comparing the equipment instance of the first point table file or the second point table file with the primary equipment of the CIM and performing content matching, and then the equipment id, the address, the affiliated park, the affiliated energy station, the affiliated channel and the like of the RTU equipment are set. And then, creating virtual logic equipment and logic nodes according to the equipment id, and finally, creating a measuring point. The measuring points can comprise one or more of a remote measuring point, a remote adjusting point, a remote pulse point, a remote signaling point and a remote control point, the point types can be three types of instantaneous 1, accumulated 2 and state 3, the control types can be controllable 1 and uncontrollable 0, and the maximum of 6 types can be obtained by combining the point types and the control types, so that the types of the measuring points can be created by combining the point types and the control types.
Referring to fig. 4, the step S40: creating a channel of a field device and mounting a corresponding field device may include:
step S401: according to the setting of the corresponding IP address and port number of the field device, selecting corresponding parameters and creating a channel of the field device;
step S402: in the established channel configuration interface, selecting equipment without configuring channels in batches;
step S403: adding the selected equipment without the configured channel into the equipment with the configured channel;
step S404: confirming the save configuration.
The device needs to communicate with and collect devices, and a channel is needed, and each channel can be hung below a plurality of devices to communicate, and the channel can be divided into a single channel and a plurality of channels. If only one device is on site, only one channel is established; if there are multiple devices on site, multiple channels need to be established. But the arrangement of each channel is the same whether single or multiple channels.
The following describes an embodiment in a specific application scenario shown in fig. 5, and a method for quickly allocating points by using a regional template in a configuration tool, taking a boiler device applied to an industrial park as an example, includes:
preparation: downloading the CIM model;
step S500: a configured point table file is exported according to the PLC configured on site and is used as a boiler equipment point table file of an industrial park;
step S501: header format according to the point table file template shown in table 1:
sequence number Header name
1 Description of the invention
2 Address of
3 Subsystem instance code
4 Apparatus and method for controlling the operation of a device
5 Device instance
6 Device name
7 Point location
8 Instantaneous 1, cumulative 2, state 3
9 Controllable 1, uncontrollable 0
TABLE 1
Deleting redundant list heads in the boiler equipment point list file and the information of the list where the redundant list heads are named except the 9 list key information;
step S502: comparing the boiler equipment point table file with a pre-downloaded CIM model, judging whether the cell content of the column with the head of the equipment instance in the boiler equipment point table file exists in the CIM model correspondingly,
if the cell content of the column whose header is the equipment instance in the boiler equipment point table file is correspondingly present in the CIM model, step S503 is entered: the row corresponding to the existing cell is reserved;
if the cell content of the column whose header is the equipment instance in the boiler equipment point table file does not exist in the CIM model, step S504 is entered: deleting the row corresponding to the non-existing cell;
step S505: screening the column with the head of the point in the boiler equipment point table file, and judging whether the cell content of the column with the head of the point is empty or not;
if the cell content of the column with the header being the point location is empty, step S506 is entered: deleting the row corresponding to the empty cell;
if the cell content of the column with the header being the point location is not empty, step S507 is entered: the rows corresponding to the non-empty cells are reserved.
Finally, a second point table file shown in table 2 is formed, and the file name is saved as a boiler variable table:
Figure BDA0002305067800000101
TABLE 2
Wherein each row, except for the header, represents a measurement point.
Step S508: starting mtide software, and reading corresponding table data of a CIM model, an energy station, power station equipment and the like;
step S509: analyzing a boiler variable table by using QAxObject provided by QT, and reading data of each row until all measuring point data are read;
before reading, analyzing and verifying the boiler variable table, wherein the analyzing conditions comprise:
whether the table column number is 9 or not, and the name of the table header is consistent with the format of the table header of the point table file template;
the contents of the other rows except the row where the header is located are correct data;
the file name contains three words of the variable table.
Only when the above analysis conditions are all met, reading of the data in the variable table will be started.
Step S510: all devices are stored by QMap according to the energy station, device and device instance to which they belong, as follows: QMAP < QSTRING, QList < sExcelPoint > >;
obtaining a measuring point structure body of each measuring point, wherein measuring point data of the measuring point structure body comprises: device address, station name, energy station name, equipment instance, point type, control type, generic template path, belonging interval container, container type, belonging area identification, station type, remote terminal unit description, specific examples are as follows:
Figure BDA0002305067800000102
Figure BDA0002305067800000111
the content before "//" of each row is the definition of each measurement point data, and the content after "//" is the description of the row.
Step S511: comparing the content of the column of the equipment instance with the content of the primary equipment in the CIM model, if the content is consistent with the content of the primary equipment, copying the data of the equipment instance to form new RTU equipment, and setting parameters of the RTU equipment: device id, address, belonging park, belonging energy station, belonging channel, etc.;
step S512: creating virtual logic equipment and logic nodes in the RTU equipment corresponding to SCADA man-machine control;
step S513: the measurement points are created, taking the point type and the control type of the measurement point structure in table 3 as a combination example:
Figure BDA0002305067800000121
TABLE 3 Table 3
Wherein Yc represents a remote point, yt represents a remote point, ym represents a remote pulse point, yx represents a remote signaling point, and Yk represents a remote point. According to table 3, the creation of various measurement points can be performed on the data in the structure.
After the creation of the virtual logic devices, logic nodes and measuring points is completed, the field devices are required to be in communication link with the corresponding logic devices, logic nodes and measuring points, and then channels are required to be created.
Step S514: according to the corresponding IP address and port number of the field device, selecting corresponding parameters such as a protocol, and creating a channel of the field device, wherein the parameter setting is shown in FIG. 6;
in this embodiment, a draggable configuration interface is taken as an example, the interface is divided into two sides, the left side is a device with a configured channel, the right side is a device without a configured channel, when in operation, a device on one side can be arbitrarily selected to drag into an interface frame on the other side, and the setting can be saved by clicking and determining.
Step S515: in the draggable interface, selecting objects in the equipment with the right side not provided with the channel in batches, as shown in fig. 7;
step S516: dragging the selected object to the device with the left configured channel, see fig. 8;
step S517: and finally, clicking to determine, namely completing the configuration of the measuring point.
The previously adopted method is to select a selection channel for each device, which is low in efficiency. In the embodiment, the device or the measuring point to be configured can be selected in a large batch according to the way of directly dragging the setting according to the channel, so that the configuration is completed once, and the efficiency is high.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic, and should not limit the implementation process of the embodiment of the present invention.
Referring to fig. 9, the present embodiment further aims to provide a device for quick matching points by using a region template in a configuration tool, which includes a point table file obtaining module 61, a measurement point structure obtaining module 62, a first creating module 63, and a second creating module 64, wherein,
the point table file obtaining module 61 is configured to generate a second point table file of the to-be-configured point area according to the configured first point table file;
the measurement point structure body obtaining module 62 is configured to parse the second point table file to generate a measurement point structure body;
the first creating module 63 is configured to create a logic device, a logic node, and a measurement point according to the measurement point structure;
the second creating module 64 is configured to create a channel of the field device, mount the corresponding field device, and complete configuration of the measurement point.
Fig. 10 is a schematic diagram of a terminal device 7 according to an embodiment of the present invention. As shown in fig. 10, the terminal device 7 of this embodiment includes a processor 70, a memory 71, and a computer program 72 stored in the memory 71 and executable on the processor 70, such as a quick-point-allocation program using a region template in a configuration tool. The processor 70 executes the computer program 72 to implement the steps of the embodiment of the rapid pointing method using region templates in each of the configuration tools described above, such as steps S10 to S40 shown in fig. 1. Alternatively, the processor 70, when executing the computer program 72, performs the functions of the modules/units of the apparatus embodiments described above, such as the functions of the modules 61 to 64 shown in fig. 9.
By way of example, the computer program 72 may be partitioned into one or more modules/units that are stored in the memory 71 and executed by the processor 70 to complete the present invention. The one or more modules/units may be a series of computer program instruction segments capable of performing specific functions for describing the execution of the computer program 72 in the terminal device 7.
The terminal device 7 may be a computing device such as a desktop computer, a notebook computer, a palm computer, a cloud server, etc. The terminal device 7 may include, but is not limited to, a processor 70, a memory 71. It will be appreciated by those skilled in the art that fig. 10 is merely an example of the terminal device 7 and does not constitute a limitation of the terminal device 7, and may include more or less components than illustrated, or may combine certain components, or different components, e.g. the terminal device 7 may further include an input-output device, a network access device, a bus, etc.
The processor 70 may be a central processing unit (Central Processing Unit, CPU), or may be another general purpose processor, a digital signal processor (Digital Signal Processor, DSP), an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), a Field-programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic device, a discrete gate or transistor logic device, a discrete hardware component, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory 71 may be an internal storage unit of the terminal device 7, such as a hard disk or a memory of the terminal device 7. The memory 71 may be an external storage device of the terminal device 7, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) or the like, which are provided on the terminal device 7. Further, the memory 71 may also include both an internal storage unit and an external storage device of the terminal device 7. The memory 71 is used for storing the computer program as well as other programs and data required by the terminal device 7. The memory 71 may also be used for temporarily storing data that has been output or is to be output.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions. Of course, the units and modules can be replaced by a processor containing a computer program, and the work of each part can be completed in the form of pure software
The functional units and modules in the embodiment may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit, where the integrated units may be implemented in a form of hardware or a form of a software functional unit. In addition, specific names of the functional units and modules are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present application. The specific working process of the units and modules in the above system may refer to the corresponding process in the foregoing method embodiment, which is not described herein again.
In the foregoing embodiments, the descriptions of the embodiments are emphasized, and in part, not described or illustrated in any particular embodiment, reference is made to the related descriptions of other embodiments.
Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus/terminal device and method may be implemented in other manners. For example, the apparatus/terminal device embodiments described above are merely illustrative, e.g., the division of the modules or units is merely a logical function division, and there may be additional divisions in actual implementation, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection via interfaces, devices or units, which may be in electrical, mechanical or other forms.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated modules/units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the present invention may implement all or part of the flow of the method of the above embodiment, or may be implemented by a computer program to instruct related hardware, where the computer program may be stored in a computer readable storage medium, and when the computer program is executed by a processor, the computer program may implement the steps of each of the method embodiments described above. Wherein the computer program comprises computer program code which may be in source code form, object code form, executable file or some intermediate form etc. The computer readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a U disk, a removable hard disk, a magnetic disk, an optical disk, a computer Memory, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), an electrical carrier signal, a telecommunications signal, a software distribution medium, and so forth. It should be noted that the computer readable medium contains content that can be appropriately scaled according to the requirements of jurisdictions in which such content is subject to legislation and patent practice, such as in certain jurisdictions in which such content is subject to legislation and patent practice, the computer readable medium does not include electrical carrier signals and telecommunication signals.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.

Claims (9)

1. A method for quickly matching points by using a region template in a configuration tool, comprising the following steps:
generating a second point table file of the point area to be allocated according to the configured first point table file;
analyzing the second point table file to generate a measuring point structure body;
creating logic equipment, logic nodes and measuring points according to the measuring point structure body;
creating a channel of the field device, mounting the corresponding field device, and completing configuration of the measuring point;
the step of generating a second point table file of the point area to be configured according to the configured first point table file comprises the following steps:
deleting redundant headers in the first point table file and information of columns where the redundant headers are located according to the header format of the point table file template;
comparing the first point table file with a general information model, and judging whether the cell content of which the table head is a column of the equipment instance in the first point table file exists in the general information model correspondingly or not;
if the cell content of the column with the header of the equipment instance in the first point table file is correspondingly present in the general information model, the row corresponding to the existing cell is reserved;
if the cell content of the column with the header of the equipment instance in the first point table file does not exist in the general information model, deleting the row corresponding to the cell which does not exist;
screening the list of which the header is a point location in the first point list file, and judging whether the cell content of the list of which the header is a point location is empty or not;
if the cell content of the column with the header being the point position is empty, deleting the row corresponding to the empty cell;
if the cell content of the column with the header being the point position is not empty, the row corresponding to the non-empty cell is reserved.
2. The method for rapid matching of points by using regional templates in a configuration tool according to claim 1, wherein the header format of the point table file template comprises: description, address, subsystem instance code, device instance, device name, point location, point type, and control type.
3. The method for rapid matching using regional templates in a configuration tool according to claim 1, wherein in the step of parsing the second point table file to generate a measurement point structure, the parsing conditions of the second point table file include:
the number of columns of the table, the name of the table header are consistent with the format of the table header of the dot table file template;
except the row where the header is located, the contents of the other rows are correct data;
the file name contains a variable table.
4. The method for rapid pointing by using a regional template in a configuration tool according to claim 3, wherein the site data of the site structure comprises: device address, station name, energy station name, equipment instance, point type, control type, generic template path, belonging interval container, container type, belonging area identification, station type, remote terminal unit description.
5. The method for quick matching using regional templates in a configuration tool according to claim 1, wherein the step of creating logical devices, logical nodes, and points according to the point structure comprises:
newly-building remote terminal unit equipment and setting parameters of the remote terminal unit equipment;
creating logic equipment and logic nodes corresponding to the remote terminal unit equipment;
and creating the measuring point according to the point type and the control type of the measuring point structure body.
6. The method for quick matching using a region template in a configuration tool according to claim 1, wherein the step of creating a channel of a field device and mounting a corresponding field device comprises:
according to the setting of the corresponding IP address and port number of the field device, selecting corresponding parameters and creating a channel of the field device;
in the established channel configuration interface, selecting equipment without configuring channels in batches;
adding the selected equipment without the configured channel into the equipment with the configured channel;
confirming the save configuration.
7. A device for quick matching of a configuration tool by using a region template, comprising:
the point table file acquisition module is used for generating a second point table file of the point area to be allocated according to the configured first point table file;
the measuring point structure body acquisition module is used for analyzing the second point table file to generate a measuring point structure body;
the first creation module is used for creating logic equipment, logic nodes and measuring points according to the measuring point structural body;
the second creation module is used for creating a channel of the field device, mounting the corresponding field device and completing configuration of the measuring point;
the point table file acquisition module is specifically configured to:
deleting redundant headers in the first point table file and information of columns where the redundant headers are located according to the header format of the point table file template;
comparing the first point table file with a general information model, and judging whether the cell content of which the table head is a column of the equipment instance in the first point table file exists in the general information model correspondingly or not;
if the cell content of the column with the header of the equipment instance in the first point table file is correspondingly present in the general information model, the row corresponding to the existing cell is reserved;
if the cell content of the column with the header of the equipment instance in the first point table file does not exist in the general information model, deleting the row corresponding to the cell which does not exist;
screening the list of which the header is a point location in the first point list file, and judging whether the cell content of the list of which the header is a point location is empty or not;
if the cell content of the column with the header being the point position is empty, deleting the row corresponding to the empty cell;
if the cell content of the column with the header being the point position is not empty, the row corresponding to the non-empty cell is reserved.
8. A terminal device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 1 to 6 when the computer program is executed.
9. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the steps of the method according to any one of claims 1 to 6.
CN201911236648.8A 2019-12-05 2019-12-05 Method and device for rapidly allocating points by using regional templates in configuration tool Active CN111026460B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911236648.8A CN111026460B (en) 2019-12-05 2019-12-05 Method and device for rapidly allocating points by using regional templates in configuration tool

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911236648.8A CN111026460B (en) 2019-12-05 2019-12-05 Method and device for rapidly allocating points by using regional templates in configuration tool

Publications (2)

Publication Number Publication Date
CN111026460A CN111026460A (en) 2020-04-17
CN111026460B true CN111026460B (en) 2023-06-20

Family

ID=70204408

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911236648.8A Active CN111026460B (en) 2019-12-05 2019-12-05 Method and device for rapidly allocating points by using regional templates in configuration tool

Country Status (1)

Country Link
CN (1) CN111026460B (en)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111638690B (en) * 2020-05-26 2022-04-29 新奥数能科技有限公司 Data acquisition method, device, system and equipment based on general information model
CN111882264B (en) * 2020-06-11 2024-05-31 中国铁道科学研究院集团有限公司电子计算技术研究所 Method and device for establishing railway land management department model
CN111781890A (en) * 2020-07-14 2020-10-16 厦门海为科技有限公司 Multi-equipment engineering communication method and system in configuration engineering
CN112667119A (en) * 2020-12-31 2021-04-16 新奥数能科技有限公司 Measuring point batch correlation method and device, electronic equipment and computer readable medium
CN113311788A (en) * 2021-04-13 2021-08-27 南京南瑞继保电气有限公司 Variable configuration processing method and device, computer storage medium and equipment

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104501848A (en) * 2014-12-04 2015-04-08 国家电网公司 Data accessing method and system of substation equipment
CN105279275A (en) * 2015-10-31 2016-01-27 南京南瑞继保电气有限公司 Point list configuration method of dispatch master station end

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9495347B2 (en) * 2013-07-16 2016-11-15 Recommind, Inc. Systems and methods for extracting table information from documents

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104501848A (en) * 2014-12-04 2015-04-08 国家电网公司 Data accessing method and system of substation equipment
CN105279275A (en) * 2015-10-31 2016-01-27 南京南瑞继保电气有限公司 Point list configuration method of dispatch master station end

Also Published As

Publication number Publication date
CN111026460A (en) 2020-04-17

Similar Documents

Publication Publication Date Title
CN111026460B (en) Method and device for rapidly allocating points by using regional templates in configuration tool
US11469951B2 (en) Network-configuration-information generation method and communication device
CN109327486A (en) Data are uploaded to the method for cloud platform, system and gateway and machine readable media
CN102750301A (en) Blueprint generating method for integrated avionic system model aiming at architecture analysis and design language (AADL) description
CN102880149B (en) A kind of dcs and user data report form generation method
CN115277882B (en) CAN message database establishment method and device, vehicle-mounted electronic equipment and storage medium
ES2643599T3 (en) Integrated interface system for a monitoring and control system of an electrical system
CN111711677A (en) Virtual and real loop visualization method, system and medium for process layer switch of intelligent substation
US20230066703A1 (en) Method for estimating structural vibration in real time
CN107247827B (en) Virtual terminal model modeling and automatic wiring method based on machine learning
CN112905635A (en) Service processing method, device, equipment and storage medium
CN108200062B (en) Data management method and system for intelligent instrument equipment
CN110071948B (en) Internet of things domain control method and system and Internet of things system
CN101971562B (en) Method, device and system for controlling automatic running process performance
CN116302669A (en) Substation protection fixed value monitoring method, system, device and medium
EP4373047A1 (en) Network fault root cause determining method and apparatus, device, and storage medium
CN110209722A (en) A kind of data-interface for data exchange
CN102053571A (en) Data acquisition method of information acquisition terminal
CN114598602A (en) Data acquisition method and device, computer equipment and computer readable storage medium
CN109088765B (en) Interconnection network routing fault diagnosis method and device
CN105930296A (en) System and method for realizing conversion from Profibus-DP to CANopen
CN112526949B (en) Module information setting method, acquisition method and device of industrial control system
CN110275812A (en) The method and terminal device of faulted-phase judgment
CN110012109A (en) Method for establishing engineering information capable of realizing high accuracy
KR102243708B1 (en) Editing tool update method of the HMI system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant