CN102591808B - System and method for DCS (distributed control system) hardware configuration based on Excel - Google Patents
System and method for DCS (distributed control system) hardware configuration based on Excel Download PDFInfo
- Publication number
- CN102591808B CN102591808B CN201110426736.1A CN201110426736A CN102591808B CN 102591808 B CN102591808 B CN 102591808B CN 201110426736 A CN201110426736 A CN 201110426736A CN 102591808 B CN102591808 B CN 102591808B
- Authority
- CN
- China
- Prior art keywords
- hardware
- dcs
- configuration
- fastener
- excel
- 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
Links
Landscapes
- Stored Programmes (AREA)
Abstract
The invention discloses a system and a method for DCS (distributed control system) hardware configuration based on Excel. The system for DCS hardware configuration comprises a configuration module, a configuration drawing module, a system communication module and an address allocation module. According to the technical scheme, DCS hardware configuration can be conveniently implemented in the Excel software environment, and results can be directly converted into hardware configuration results in the DCS software system, so that DCS hardware configuration operations are greatly simplified, time and resources are saved, and risks caused by human errors can be avoided.
Description
Technical field
The present invention relates to DCS control system field, particularly a kind of DCS hardware configuration system and method based on Excel list.
Background technology
Dcs (Distributed Control System, DCS) is the complex control system of arising at the historic moment along with require day by day complicated of the continuous rise of the modern large scale industry production automation and process control.In the incipient stage of DCS project, DCS slip-stick artist conventionally need to be according to the hardware design of user's requirement and design data complete process control station, comprise that rack/fastener arranges, input/output point address assignment is to a series of activities such as fastener passages, and we are referred to as " hardware configuration " by this process conventionally.
First hardware configuration work manually complete by softwares such as Excel lists conventionally, but due to the many factors that will consider, need to repeatedly adjust, thereby can consume plenty of time and resource.Simultaneously, owing to lacking special interface between Excel list and typical DCS Software tool (as the PCS_7 of Siemens Company etc.), DCS slip-stick artist also needs according to the hardware system having designed in Excel list, in DCS software systems, again complete again a hardware configuration job, this can cause the waste of time and resource, and the risk that exists human error to bring.
Summary of the invention
In view of this, the object of the present invention is to provide a kind of system and method, make DCS slip-stick artist can under Excel software environment, carry out easily hardware configuration work, and this result can be converted into the hardware configuration result in DCS software systems.
According to an aspect of the present invention, a kind of DCS hardware configuration system based on Excel list is provided, comprise configuration configuration module, the drafting module of arranging, system communication module and address assignment module, wherein, described configuration configuration module, for according to the hsrdware requirements of DCS project, in hardware database, select needed hardware, and the drafting module of arranging described in selected hardware the is formed hardware scope that will configure; The described drafting module of arranging, carries out option and installment for the hardware in described hardware scope, DCS project being used; Described system communication module, for being converted to the discernible configuration file of DCS software systems by described Excel file of arranging after drafting module configuration; And described address assignment module, for by DCS software systems being each passage that fastener is distributed in the address of fastener channel allocation under Excel software environment.
From such scheme, can find out, hardware configuration system based on Excel of the present invention can carry out easily hardware configuration work under Excel software environment, and this result can be converted into the hardware configuration result in DCS software systems, greatly simplified the operation of DCS hardware configuration, time and resource have been saved, the risk of having avoided human error to bring.
Preferably, described configuration configuration module, specifically for DCS hardware database being imported to the nextport hardware component NextPort list of Excel, according to the hsrdware requirements of DCS project, in this nextport hardware component NextPort list, find needed ardware model number and it is selected, and selected ardware model number is formed respectively to ardware model number scope according to the hardware kind in DCS, the described ardware model number scope ardware model number scope that drafting module will configure of arranging described in being exactly, wherein said hardware kind comprises CPU, communication network interface card, frame, power supply and fastener, the described drafting module of arranging, specifically for carry out arranging of hardware device by system configuration list, draw operation, this is arranged to draw to operate and comprises that automated station is arranged and fastener is arranged, by the order under system configuration list state, realize respectively, when described automated station is arranged, described order of arranging under drafting module triggering system configuration list state is to create automated station sublist, and the frame that DCS system is used, power supply, CPU, communication network is stuck in corresponding described ardware model number scope and carries out option and installment, when described fastener is arranged, described order of arranging under drafting module triggering system configuration status is to create fastener sublist, and the fastener that DCS system is used carries out option and installment in the described ardware model number scope of correspondence, described system communication module, specifically for according to the data characteristics of existing DCS software systems, the hardware layout viewing of the Excel file layout that the described drafting module of arranging is drawn changes into the configuration file that can be identified by DCS software systems, wherein this configuration file can be after importing DCS software systems by relevant hardware device according to importing existing hardware configuration automatic placement in file, and described address assignment module, specifically for the hardware configuration file that DCS software systems are derived, again import in Excel list, and by DCS software systems, be that each passage of fastener is distributed in the address of fastener channel allocation under Excel software environment, thereby complete the hardware configuration work group under Excel software environment.
Preferably, described in arrange drafting module when hardware is arranged in described system configuration list, described automated station is consistent with drafting position and the putting position of each actual hardware module in rack of described fastener.
Preferably, the drop-down menu when drafting module of arranging described in the selected ardware model number of described configuration configuration module forms according to the hardware kind in DCS is selected corresponding kind, thus form respectively ardware model number scope.
Preferably, the order under described system configuration list state is right mouse button menu option.
According to another aspect of the present invention, a kind of DCS hardware configuration method based on Excel list is provided, comprise configuration configuration step, the plot step of arranging, system communication step and address assignment step, wherein, described configuration configuration step, for according to the hsrdware requirements of DCS project, in hardware database, select needed hardware, and the hardware scope that will configure in the plot step of arranging described in selected hardware is formed on; The described plot step of arranging, carries out option and installment for the hardware in described hardware scope, DCS project being used; Described system communication step, for being converted to the discernible configuration file of DCS software systems at described Excel file of arranging after plot step configuration; And described address assignment step, for by DCS software systems being each passage that fastener is distributed in the address of fastener channel allocation under Excel software environment.
From such scheme, can find out, hardware configuration method based on Excel of the present invention can be carried out easily hardware configuration work under Excel software environment, and this result can be converted into the hardware configuration result in DCS software systems, greatly simplified the operation of DCS hardware configuration, time and resource have been saved, the risk of having avoided human error to bring.
Preferably, in described configuration configuration step, DCS hardware database is imported to the nextport hardware component NextPort list of Excel, according to the hsrdware requirements of DCS project, in this nextport hardware component NextPort list, find needed ardware model number and it is selected, and selected ardware model number is formed respectively to ardware model number scope according to the hardware kind in DCS, described ardware model number scope is exactly the described ardware model number scope that will configure in the described drafting module of arranging, and wherein said hardware kind comprises CPU, communication network interface card, frame, power supply and fastener, described, arrange in plot step, by system configuration list, carry out arranging of hardware device and draw operation, this is arranged to draw to operate and comprises that automated station is arranged and fastener is arranged, by the order under system configuration list state, realize respectively, when described automated station is arranged, order under triggering system configuration list state is to create automated station sublist, and the frame that DCS system is used, power supply, CPU, communication network is stuck in corresponding described ardware model number scope and carries out option and installment, when described fastener is arranged, order under triggering system configuration status is to create fastener sublist, and the fastener that DCS system is used carries out option and installment in the described ardware model number scope of correspondence, in described system communication step, according to the data characteristics of existing DCS software systems, the hardware layout viewing of the Excel file layout of drawing is changed into the configuration file that can be identified by DCS software systems in the described plot step of arranging, wherein this configuration file can be after importing DCS software systems by relevant hardware device according to importing existing hardware configuration automatic placement in file, and in described address assignment step, the hardware configuration file that DCS software systems are derived imports in Excel list again, and by DCS software systems, be that each passage of fastener is distributed in the address of fastener channel allocation under Excel software environment, thereby complete the hardware configuration work group under Excel software environment.
Preferably, described, arrange in drafting, when hardware is arranged in described system configuration list, described automated station is consistent with drafting position and the putting position of each actual hardware module in rack of described fastener.
Preferably, in described configuration configuration step, selected ardware model number forms the drop-down menu while selecting corresponding kind in described system configuration list according to the hardware kind in DCS, thereby forms respectively ardware model number scope.
Preferably, the order under described system configuration list state is right mouse button menu option.
Accompanying drawing explanation
To the person of ordinary skill in the art is more clear that above-mentioned and other feature and advantage of the present invention by describing the preferred embodiments of the present invention in detail with reference to accompanying drawing below, in accompanying drawing:
Fig. 1 is the system construction drawing of DCS hardware configuration system in the specific embodiment of the invention;
Fig. 2 is the system interface figure that carries out hardware selection in the DCS hardware configuration process of the specific embodiment of the invention;
Fig. 3 is the system interface figure that carries out automated station configuration in the DCS hardware configuration process of the specific embodiment of the invention;
Fig. 4 is the system interface figure of the right-click menu that uses in the DCS hardware configuration process of the specific embodiment of the invention;
Fig. 5 is the system interface figure that carries out fastener configuration in the DCS hardware configuration process of the specific embodiment of the invention;
Fig. 6 is the system interface figure that carries out channel address distribution in the DCS hardware configuration process of the specific embodiment of the invention;
Fig. 7 is the operational flowchart of DCS hardware configuration method in the specific embodiment of the invention.
Embodiment
For making the object, technical solutions and advantages of the present invention clearer, the present invention is described in more detail by the following examples.
For technical matters of the prior art, the present invention utilize Excel software VBA interface exploitation the DCS hardware configuration system based on Excel list.In this system, DCS slip-stick artist can be according to DCS project user data and custom rule, realize the various hardware devices of automatic placement, automatically by input/output point address assignment to functions such as fastener passages, thereby complete the hardware configuration of DCS system in Excel list.This result is so that figure and forms mode are presented to user intuitively, support further artificial adjustment, and all hardware configuration info can directly preserve into the hardware configuration file that DCS software systems can be identified, thereby directly the hardware configuration result in Excel software is converted into the hardware configuration result in DCS software systems.
In the specific embodiment of the present invention, this DCS hardware configuration system based on Excel mainly comprises configuration configuration module 10, the drafting module 20 of arranging, system communication module 30 and address assignment module 40, as shown in Figure 1.Below just introduce respectively the major function of each module:
(1) configuration configuration module 10
The design datas such as the user's point table by DCS project user is provided, cable meter, order inventory are analyzed, first DCS slip-stick artist can obtain the hsrdware requirements of this project, determine all hardware kind that this DCS project will be used, comprise CPU, communication network interface card, frame, power supply, fastener etc., concrete model and quantity.
No matter at traditional Excel list or in DCS software systems, DCS slip-stick artist need to select this hardware before the configuration of carrying out each hardware from complete DCS hardware database, because the ardware model number quantity in hardware database is all very huge with the hardware quantity that need to carry out configuration, therefore need to require considerable time and effort and carry out this selection operation, in process, also easily make a mistake.For example, if DCS slip-stick artist need to select 321-1BL00-0AA0 type I/O module as needed fastener, need to comprise at the same time in the hardware database of the equipment such as thousands of kinds of CPU, communication network interface card, frame, power supply, fastener and make a choice, and when again needing to use this I/O module in this project, need again to select.
In order to simplify aforesaid operations, the configuration configuration module 10 in the specific embodiment of the invention provides mode more easily.This configuration configuration module 10 imports " nextport hardware component NextPort (Hardware Component) list " in DCS hardware configuration system by DCS hardware database, as shown in Figure 2.In this list, can carry out disposable selection to the ardware model number that may use in DCS project, this selection is only carried out choosing of " X " mark by " select " row in left side, as shown in Figure 2.For example, if can use 321-1BL00-0AA0 type I/O module as needed fastener in DCS project, DCS slip-stick artist only need to find this I/O module to be expert in nextport hardware component NextPort list, then in " select " of this row row, carries out choosing of " X " mark, as shown in Figure 2.
The hardware of choosing in this nextport hardware component NextPort list can appear in corresponding range of choice in follow-up hardware is arranged drafting operation.For example, if DCS slip-stick artist has selected the hardware device of " 400-2JA00-0AA0 " type and " 400-2JA10-0AA0 " type power supply and other model in nextport hardware component NextPort list, the power supply of these two kinds of models will appear at follow-up hardware and arrange and draw in the drop-down menu of selecting for power supply in operation, for DCS slip-stick artist, select, as shown in Figure 3.
By above-mentioned explanation, can find out, the quantity no matter a certain hardware is used in whole DCS project has how many, in only need the hardware database in nextport hardware component NextPort list, it be once selected just can to make in its hardware range of choice very little in appearing at subsequent operation, this has simplified the operation that each hardware is arranged and drawn greatly, thereby saved significantly running time and resource, effectively avoided misoperation.
(2) drafting module 20 of arranging
The drafting module 20 of arranging in the specific embodiment of the invention carries out arranging of hardware device by " system configuration (SysCon) list " and draws operation, this is arranged to draw to operate and is mainly divided into automated station (Automation Station, AS) arrange and fastener (DP) two parts of arranging, these two parts realize by " Add AS " in the right mouse button menu under system configuration list state and " Add DP " order respectively, as shown in Figure 4.
As shown in Figure 3, first DCS slip-stick artist is configured the automated station in rack.In this operation, first DCS slip-stick artist triggers the right-click menu shown in Fig. 4 and selects " Add AS " order, and the automated station sublist shown in Fig. 3 (sublist of arrow points to the right) will appear in the upper position of system configuration list.The hardware devices such as the frame (Rack) that can use DCS system respectively on this basis,, power supply (Power Supply), CPU, communication network interface card (CP) carry out option and installment.It should be noted that by the operation of configuration configuration module, the scope that hardware is selected be limited at that DCS system likely used more among a small circle in, thereby such hardware setting is very convenient quick.
After carrying out automated station configuration, DCS slip-stick artist can be configured a series of fasteners that use in system.In this operation, first DCS slip-stick artist triggers the right-click menu shown in Fig. 4 and selects " Add DP " order, and the fastener sublist shown in Fig. 5 (sublist of arrow points downwards) will appear in list.If need to many groups fastener be configured, repeatedly carry out " Add DP " order.On this basis, a series of fasteners that DCS slip-stick artist can use system respectively carry out option and installment.Similar with automated station configuration, the selection of fastener has also been limited to DCS system likely used more among a small circle in, thereby such fastener arranges very convenient quick.Meanwhile, the title of each fastener can be according to the predefined rule generation of system, and DCS slip-stick artist can also further arrange the concrete connection mode of each fastener.
The corresponding a plurality of passages (Channel) of each fastener, each passage should a corresponding input/output point in system.In follow-up operation, DCS slip-stick artist also can utilize the channel address distribution function of DCS software systems to be configured the address of each passage, will be specifically introduced hereinafter.
It is worth mentioning that, when hardware is arranged in system configuration list, automated station is consistent with drafting position and the putting position of actual hardware module in rack of fastener.That is to say, hardware configuration system in Excel list, hardware is arranged situation with image efficiently mode draw out, this provides great convenience for the assembling that rack assembly crewman from now on carries out hardware in rack.
(3) system communication module 30
Owing to lacking the interface of Excel software and DCS software systems in prior art, after the hardware configuration having completed under Excel software environment, also need all working to be repeated once under DCS software systems environment according to the Excel list having configured, this has wasted the plenty of time, and easily occurs mistake.
System communication module 30 in the specific embodiment of the invention provides the interface from Excel software to DCS software systems, it can, according to the data characteristics of existing DCS software systems, change into the hardware layout viewing of drawing in Excel the configuration file (.cfg file) that can be identified by DCS software systems.
Under DCS software systems operation interface, import after this .cfg file, relevant hardware device will be according to importing existing hardware configuration automatic placement in file, and this has just saved the extensive work that re-starts hardware configuration in DCS software systems.Afterwards, DCS software systems are each fastener passage calculated address for having configured automatically, and this function is the existing function of existing DCS software systems, repeats no more herein.
After passage calculated address for each fastener, DCS software systems can be corresponding hardware configuration file by hardware configuration result store, and Excel software itself possesses the function of identification the type hardware configuration file.
(4) address assignment module 40
The hardware configuration file that DCS slip-stick artist can derive DCS system imports in Excel list again, address assignment module 40 in the specific embodiment of the invention can automatically be distributed to each passage of fastener by the fastener channel address generating in DCS software systems in system configuration list, thereby completes the hardware configuration work under Excel software environment.Fig. 6 shows channel address is distributed to the hardware configuration state after each fastener passage.
Utilize the hardware configuration file completing under Excel environment, DCS slip-stick artist can utilize the various existing function of Excel list to form various required DCS system forms subsequently, thereby lays a good foundation for follow-up DCS software programming work.
A kind of DCS hardware configuration method based on Excel is also provided in the specific embodiment of the present invention, and the method mainly comprises configuration configuration step, the plot step of arranging, system communication step and address assignment step, as shown in Figure 7.Below just introduce respectively each step in this hardware group the method:
S10: configuration configuration step
The design datas such as the user's point table by DCS project user is provided, cable meter, order inventory are analyzed, first DCS slip-stick artist can obtain the hsrdware requirements of this project, determine all hardware that this DCS project will be used, comprise CPU, communication network interface card, frame, power supply, fastener etc., model and quantity.
In the configuration configuration step of the specific embodiment of the invention, DCS hardware database is imported to " the nextport hardware component NextPort list " in DCS hardware configuration system, as shown in Figure 2.In this list, DCS slip-stick artist can carry out disposable selection to the ardware model number that may use in DCS project, and this selection is only carried out choosing of " X " mark by " select " row in left side, as shown in Figure 2.The hardware of choosing in this nextport hardware component NextPort list can appear in corresponding range of choice in follow-up hardware is arranged drafting operation.
By above-mentioned explanation, can find out, the quantity no matter a certain hardware is used in whole DCS project has how many, only need in hardware database, to it, once select just can make it to appear in hardware range of choice very little in subsequent operation, this has simplified the operation that each hardware is arranged and drawn greatly, thereby saved significantly running time and energy, effectively avoided misoperation.
S20: the plot step of arranging
The plot step of arranging in the specific embodiment of the invention is carried out arranging of hardware device by " system configuration " list and is drawn operation, this is arranged and draws operation two parts that are mainly divided into that automated station is arranged and fastener is arranged, these two parts realize by " Add AS " in the right mouse button menu under system configuration list state and " Add DP " order respectively, as shown in Figure 4.
As shown in Figure 3, in the plot step of arranging, first DCS slip-stick artist is configured the automated station in rack.In this operation, first DCS slip-stick artist triggers the right-click menu shown in Fig. 4 and selects " Add AS " order, and the automated station sublist shown in Fig. 3 (sublist of arrow points to the right) will appear in the upper position of system configuration list.The hardware devices such as the frame that on this basis, DCS slip-stick artist can use DCS system respectively, power supply, CPU, communication network interface card carry out option and installment.It should be noted that by the operation of configuration configuration module, the scope that hardware is selected be limited at that DCS system likely used more among a small circle in, thereby such hardware setting is very convenient quick.
After automated station configuration in the plot step of arranging, DCS slip-stick artist can be configured a series of fasteners that use in system.In this operation, first DCS slip-stick artist triggers the right-click menu shown in Fig. 4 and selects " Add DP " order, and the fastener sublist shown in Fig. 5 (sublist of arrow points downwards) will appear in list.If need to many groups fastener be configured, repeatedly carry out " Add DP " order.On this basis, a series of fasteners that DCS slip-stick artist can use system respectively carry out option and installment.Similar with automated station configuration, the selection of fastener has also been limited to DCS system likely used more among a small circle in, thereby such fastener arranges very convenient quick.Meanwhile, the title of each fastener can be according to the predefined rule generation of system, and DCS slip-stick artist can also further arrange the concrete connection mode of each fastener.
It is worth mentioning that, when hardware is arranged in system configuration list, automated station is consistent with drafting position and the putting position of actual hardware module in rack of fastener.That is to say, hardware configuration system in Excel list, hardware is arranged situation with image efficiently mode draw out, this provides great convenience for the assembling that rack assembly crewman from now on carries out hardware in rack.
S30: system communication step
System communication step in the specific embodiment of the invention provides the interface from Excel software to DCS software systems, it can, according to the data characteristics of existing DCS software systems, change into the hardware layout viewing of drawing in Excel the configuration file (.cfg file) that can be identified by DCS software systems.
In system communication step, under DCS software systems operation interface, import after this .cfg file, relevant hardware device will be according to importing existing hardware configuration automatic placement in file, and this has just saved the extensive work that re-starts hardware configuration in DCS software systems.Afterwards, DCS software systems are each fastener passage calculated address for having configured automatically, and this function is the existing function of existing DCS software systems, repeats no more herein.
After passage calculated address for each fastener, DCS software systems can be corresponding hardware configuration file by hardware configuration result store, and this document can be identified by Excel software.
S40: address assignment step
The hardware configuration file that DCS slip-stick artist can derive DCS system imports in Excel list again, in address assignment step in the specific embodiment of the invention, the fastener channel address generating automatically can be distributed to each passage of fastener in system configuration list in DCS software systems, thereby complete the hardware configuration work under Excel software environment.Fig. 6 shows channel address is distributed to the hardware configuration state after each fastener passage.
Utilize the hardware configuration file completing under Excel environment, DCS slip-stick artist can utilize the various existing function of Excel list to form various required DCS system forms subsequently, thereby lays a good foundation for follow-up DCS software programming work.
As can be seen here, hardware configuration system based on Excel in the specific embodiment of the invention and method can be carried out easily hardware configuration work under Excel software environment, and this result can be converted into the hardware configuration result in DCS software systems, greatly simplified the operation of DCS hardware configuration, time and resource have been saved, the risk of having avoided human error to bring.
The foregoing is only preferred embodiment of the present invention, in order to limit the present invention, within the spirit and principles in the present invention not all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (8)
1. the DCS hardware configuration system based on Excel list, comprises configuration configuration module (10), the drafting module of arranging (20), system communication module (30) and address assignment module (40), wherein,
Described configuration configuration module (10) for according to the hsrdware requirements of DCS project, is selected needed hardware in hardware database, and the drafting module (20) of arranging described in selected hardware the is formed hardware scope that will configure;
The described drafting module of arranging (20), carries out option and installment for the hardware in described hardware scope, DCS project being used;
Described system communication module (30), for by described in the Excel file of arranging after drafting module (20) configuration be converted to the discernible configuration file of DCS software systems; And
Described address assignment module (40), for by DCS software systems being each passage that fastener is distributed in the address of fastener channel allocation under Excel software environment,
It is characterized in that,
Described configuration configuration module (10), specifically for DCS hardware database being imported to the nextport hardware component NextPort list of Excel, according to the hsrdware requirements of DCS project, in this nextport hardware component NextPort list, find needed ardware model number and it is selected, and selected ardware model number is formed respectively to ardware model number scope according to the hardware kind in DCS, the ardware model number scope that the drafting module (20) of arranging described in described ardware model number scope is exactly will configure, wherein said hardware kind comprises CPU, communication network interface card, frame, power supply and fastener;
The described drafting module of arranging (20), specifically for carry out arranging of hardware device by system configuration list, draw operation, this is arranged to draw to operate and comprises that automated station is arranged and fastener is arranged, by the order under system configuration list state, realize respectively, when described automated station is arranged, order under the described drafting module of arranging (20) triggering system configuration list state is to create automated station sublist, and the frame that DCS system is used, power supply, CPU, communication network is stuck in corresponding described ardware model number scope and carries out option and installment, when described fastener is arranged, order under the described drafting module of arranging (20) triggering system configuration status is to create fastener sublist, and the fastener that DCS system is used carries out option and installment in the described ardware model number scope of correspondence,
Described system communication module (30), specifically for according to the data characteristics of existing DCS software systems, by described in the arrange hardware layout viewing of the Excel file layout that drafting module (20) draws change into the configuration file that can be identified by DCS software systems, wherein this configuration file can be after importing DCS software systems by relevant hardware device according to importing existing hardware configuration automatic placement in file; And
Described address assignment module (40), specifically for the hardware configuration file that DCS software systems are derived, again import in Excel list, and by DCS software systems, be that each passage of fastener is distributed in the address of fastener channel allocation under Excel software environment, thereby complete the hardware configuration work group under Excel software environment.
2. system according to claim 1, is characterized in that,
When the described drafting module of arranging (20) is arranged to hardware in described system configuration list, described automated station is consistent with drafting position and the putting position of each actual hardware module in rack of described fastener.
3. according to the system described in any one in claim 1-2, it is characterized in that,
The drop-down menu when drafting module (20) of arranging described in the selected ardware model number of described configuration configuration module (10) forms according to the hardware kind in DCS is selected corresponding kind, thus ardware model number scope formed respectively.
4. system according to claim 1, is characterized in that,
Order under described system configuration list state is right mouse button menu option.
5. the DCS hardware configuration method based on Excel list, comprises configuration configuration step, the plot step of arranging, system communication step and address assignment step, wherein,
Described configuration configuration step (S10) for according to the hsrdware requirements of DCS project, is selected needed hardware in hardware database, and the hardware scope that will configure in the plot step (S20) of arranging described in selected hardware is formed on;
The described plot step of arranging (S20), carries out option and installment for the hardware in described hardware scope, DCS project being used;
Described system communication step (S30), for being converted to the discernible configuration file of DCS software systems by the Excel file after the described plot step of arranging (S20) configuration; And
Described address assignment step (S40), for by DCS software systems being each passage that fastener is distributed in the address of fastener channel allocation under Excel software environment,
It is characterized in that,
In described configuration configuration step, DCS hardware database is imported to the nextport hardware component NextPort list of Excel, according to the hsrdware requirements of DCS project, in this nextport hardware component NextPort list, find needed ardware model number and it is selected, and selected ardware model number is formed respectively to ardware model number scope according to the hardware kind in DCS, described ardware model number scope is exactly the described ardware model number scope that will configure in the described drafting module of arranging, and wherein said hardware kind comprises CPU, communication network interface card, frame, power supply and fastener;
Described, arrange in plot step, by system configuration list, carry out arranging of hardware device and draw operation, this is arranged to draw to operate and comprises that automated station is arranged and fastener is arranged, by the order under system configuration list state, realize respectively, when described automated station is arranged, order under triggering system configuration list state is to create automated station sublist, and the frame that DCS system is used, power supply, CPU, communication network is stuck in corresponding described ardware model number scope and carries out option and installment, when described fastener is arranged, order under triggering system configuration status is to create fastener sublist, and the fastener that DCS system is used carries out option and installment in the described ardware model number scope of correspondence,
In described system communication step, according to the data characteristics of existing DCS software systems, the hardware layout viewing of the Excel file layout of drawing is changed into the configuration file that can be identified by DCS software systems in the described plot step of arranging, wherein this configuration file can be after importing DCS software systems by relevant hardware device according to importing existing hardware configuration automatic placement in file; And
In described address assignment step, the hardware configuration file that DCS software systems are derived imports in Excel list again, and by DCS software systems, be that each passage of fastener is distributed in the address of fastener channel allocation under Excel software environment, thereby complete the hardware configuration work group under Excel software environment.
6. method according to claim 5, is characterized in that,
Described, arrange in drafting, when hardware is arranged in described system configuration list, described automated station is consistent with drafting position and the putting position of each actual hardware module in rack of described fastener.
7. according to the method described in any one in claim 5-6, it is characterized in that,
In described configuration configuration step, selected ardware model number forms the drop-down menu while selecting corresponding kind in described system configuration list according to the hardware kind in DCS, thereby forms respectively ardware model number scope.
8. method according to claim 5, is characterized in that,
Order under described system configuration list state is right mouse button menu option.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110426736.1A CN102591808B (en) | 2011-12-19 | 2011-12-19 | System and method for DCS (distributed control system) hardware configuration based on Excel |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110426736.1A CN102591808B (en) | 2011-12-19 | 2011-12-19 | System and method for DCS (distributed control system) hardware configuration based on Excel |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102591808A CN102591808A (en) | 2012-07-18 |
| CN102591808B true CN102591808B (en) | 2014-11-26 |
Family
ID=46480493
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110426736.1A Active CN102591808B (en) | 2011-12-19 | 2011-12-19 | System and method for DCS (distributed control system) hardware configuration based on Excel |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102591808B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108469808A (en) * | 2018-04-03 | 2018-08-31 | 中国神华能源股份有限公司 | DCS hardware configuration hidden troubles removing system and methods |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102880748A (en) * | 2012-09-06 | 2013-01-16 | 国电联合动力技术有限公司 | Method for automatically drawing electric diagrams |
| CN104200397B (en) * | 2014-08-27 | 2018-04-03 | 北京广利核系统工程有限公司 | A kind of nuclear power station DCS system input design file and variable information data base consistency(-tance) method of calibration |
| CN105589351A (en) * | 2016-01-26 | 2016-05-18 | 北京科力通电气股份有限公司 | Configuration system |
| CN108491510A (en) * | 2018-03-22 | 2018-09-04 | 平安科技（深圳）有限公司 | Excel data import method, apparatus, computer equipment and the storage medium of database |
| CN111752188A (en) * | 2020-05-28 | 2020-10-09 | 南京南瑞继保电气有限公司 | IO configuration method and system |
| CN114326488A (en) * | 2021-12-01 | 2022-04-12 | 浙江源创智控技术有限公司 | Configuration allocation method and device for IO module channel linkage of building control system |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6163806A (en) * | 1997-06-30 | 2000-12-19 | Sun Microsystems, Inc. | System and method for transparent, global access to physical devices on a computer cluster |
| CN101339569A (en) * | 2007-07-02 | 2009-01-07 | 中港疏浚股份有限公司 | Use of independently configured hardware configuration in dredging software |
-
2011
- 2011-12-19 CN CN201110426736.1A patent/CN102591808B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6163806A (en) * | 1997-06-30 | 2000-12-19 | Sun Microsystems, Inc. | System and method for transparent, global access to physical devices on a computer cluster |
| CN101339569A (en) * | 2007-07-02 | 2009-01-07 | 中港疏浚股份有限公司 | Use of independently configured hardware configuration in dredging software |
Non-Patent Citations (2)
| Title |
|---|
| 余丹.基于S7-300与WinCC的桥式起重机监控管理系统.《华东交通大学学报》.华东交通大学,2010,第27卷(第6期),71-74. * |
| 基于S7-300与WinCC的桥式起重机监控管理系统;余丹;《华东交通大学学报》;华东交通大学;20101231;第27卷(第6期);71-74 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108469808A (en) * | 2018-04-03 | 2018-08-31 | 中国神华能源股份有限公司 | DCS hardware configuration hidden troubles removing system and methods |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102591808A (en) | 2012-07-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102591808B (en) | System and method for DCS (distributed control system) hardware configuration based on Excel | |
| CN104778124B (en) | A kind of software application automated testing method | |
| CN101718977B (en) | CAM system for automobile longeron punching processing and control method and construction method thereof | |
| CN101888655B (en) | Method and device for configuring network element data in template way in network management system | |
| CN102750301B (en) | Blueprint generating method for integrated avionic system model aiming at architecture analysis and design language (AADL) description | |
| CN104407576A (en) | Realization method for general type production and manufacturing unit and control system thereof | |
| CN107003664B (en) | Design of information system auxiliary tool and design of information system auxiliary program | |
| CN113557517A (en) | Automatic generation device and method of electrical design drawing | |
| CN103164573B (en) | PDM managing and designing system | |
| CN105653245A (en) | Code automatic generation system, device and method | |
| CN102870108A (en) | Method of generating electronic report | |
| CN109358549A (en) | A kind of intelligent control method and device of excavator | |
| CN106094587B (en) | A kind of satellite frame telemetry channel determines system and method | |
| CN103902757A (en) | System and method for rapid creation and interaction of three-dimensional model | |
| CN101667124A (en) | System and method for configuring monitoring device based on object model | |
| CN103177074B (en) | Customize the graphic user interface of manufacturing execution system screen | |
| CN103870540A (en) | Database based on structural design and analysis integration | |
| CN112418820B (en) | Cloud system and method for supporting customized industrial process production management | |
| CN102034168A (en) | Method and system for matching task executor for work breakdown structure | |
| CN104636529A (en) | Circuit design simulation system of printed circuit board and circuit design method thereof | |
| US20090241075A1 (en) | Test chip validation and development system | |
| CN105607595B (en) | Method and apparatus for managing and configuring the field device of automation installation | |
| CN107330173B (en) | Integrated circuit back end design automation system | |
| CN102236559A (en) | Software generation system | |
| CN102087506B (en) | Crude oil pipe transportation process simulation and automatic test scheme compilation system and automatic generation method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20151029 Address after: 100016 Beijing, Jiuxianqiao, East Chaoyang District Road, building No. 9, building A1, layer 8 Patentee after: Siemens Factory Automation Engineering Co., Ltd. Address before: 200030, 22-25 floor, Xuhui yuan building, 1089 south two road, Shanghai, Zhongshan Patentee before: Siemens Industrial Automation Ltd., Shanghai |