CN102591808A - 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
- CN102591808A CN102591808A CN2011104267361A CN201110426736A CN102591808A CN 102591808 A CN102591808 A CN 102591808A CN 2011104267361 A CN2011104267361 A CN 2011104267361A CN 201110426736 A CN201110426736 A CN 201110426736A CN 102591808 A CN102591808 A CN 102591808A
- Authority
- CN
- China
- Prior art keywords
- configuration
- hardware
- dcs
- fastener
- arranging
- 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.)
- Granted
Links
Images
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 the Excel list.
Background technology
(Distributed Control System DCS) is the complex control system of arising at the historic moment along with require complicated day by day of the continuous rise of the modern large scale industry production automation and process control to dcs.In the incipient stage of DCS project; DCS slip-stick artist usually need be according to the hardware designs of customer requirements and design data complete process control station; Comprise that rack/fastener arranges; A series of activities such as input/output point address assignment to fastener passage, we are referred to as " hardware configuration " with this process usually.
Hardware configuration work is at first accomplished by softwares such as Excel list are artificial usually, but because the factor that will consider is numerous, needs adjustment repeatedly, thereby can consume plenty of time and resource.Simultaneously; Because the special interface of shortage between Excel list and typical DCS Software tool (like the PCS_7 of Siemens Company etc.); DCS slip-stick artist also needs according to the hardware system that in the Excel list, has designed; In the DCS software systems, accomplish a hardware configuration job more again, 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 the Excel software environment, carry out hardware configuration work easily, and can this result be converted into the hardware configuration result in the DCS software systems.
According to an aspect of the present invention; A kind of DCS hardware configuration system based on the Excel list is provided, comprises the configuration configuration module, the drafting module of arranging, system communication module and address assignment module, wherein; Said configuration configuration module; Be used for hsrdware requirements, in hardware database, select needed hardware, and selected hardware is formed the said drafting module of arranging want the configured hardware scope according to the DCS project; The said drafting module of arranging is used in said hardware scope, the employed hardware of DCS project being selected configuration; Said system communication module, being used for the Excel file conversion after the said drafting module configuration of arranging is the discernible configuration files of DCS software systems; And said address assignment module, being used for the DCS software systems is fastener is distributed in the address of fastener channel allocation under the Excel software environment each passage.
From such scheme, can find out; Hardware configuration system based on Excel of the present invention can carry out hardware configuration work easily under the Excel software environment; And can this result be converted into the hardware configuration result in the DCS software systems; Simplify the operation of DCS hardware configuration greatly, practiced thrift time and resource, the risk of having avoided human error to bring.
Preferably; Said configuration configuration module; Specifically be used for the DCS hardware database is imported 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 the ardware model number scope respectively according to the hardware kind among the DCS; Said ardware model number scope is exactly that the said drafting module of arranging is wanted configured hardware model scope, and wherein said hardware kind comprises CPU, communication network interface card, frame, power supply and fastener; The said drafting module of arranging; Specifically be used for carrying out arranging of hardware device and draw operation through the system configuration list; This is arranged to draw to operate and comprises that automated station is arranged and fastener is arranged; Realize through the order under system configuration list state that respectively when said automated station was arranged, the order under the said drafting module triggering system configuration list state of arranging was to create the automated station sublist; And the employed frame of DCS system, power supply, CPU, communication network are stuck in corresponding said ardware model number scope select configuration; When said fastener was arranged, the order under the said drafting module triggering system configuration status of arranging to be creating the fastener sublist, and the employed fastener of DCS system is selected configuration in the said ardware model number scope of correspondence; Said system communication module; Specifically be used for data characteristics according to existing DCS software systems; The hardware layout viewing of the Excel file layout that the said drafting module of arranging is drawn changes into can be by the configuration file of DCS software systems identification, wherein this configuration file can be after importing the DCS software systems with relevant hardware device according to importing existing Hardware configuration automatic placement in the file; And said address assignment module; Specifically be used for the hardware configuration file that the DCS software systems derive is imported the Excel list again; And be that each passage of fastener is distributed in the address of fastener channel allocation with the DCS software systems under the Excel software environment, thereby accomplish the hardware configuration worker group under the Excel software environment.
Preferably, when the said drafting module of arranging was arranged to hardware in said system configuration list, said automated station was consistent with the drafting position and the putting position of each actual hardware module in rack of said fastener.
Preferably, the selected ardware model number of said configuration configuration module forms the said drafting module of arranging according to the hardware kind among the DCS and selects the drop-down menu of corresponding kind of time-like, thereby forms the ardware model number scope respectively.
Preferably, the order under the said system configuration list state is the right mouse button menu option.
According to another aspect of the present invention; A kind of DCS hardware configuration method based on the Excel list is provided, comprises the configuration configuration step, the plot step of arranging, system communication step and address assignment step, wherein; Said configuration configuration step; Be used for hsrdware requirements, in hardware database, select needed hardware, and selected hardware is formed on the configured hardware scope of wanting in the said plot step of arranging according to the DCS project; The said plot step of arranging is used in said hardware scope, the employed hardware of DCS project being selected configuration; Said system communication step, being used for the Excel file conversion after the said plot step configuration of arranging is the discernible configuration files of DCS software systems; And said address assignment step, being used for the DCS software systems is fastener is distributed in the address of fastener channel allocation under the Excel software environment each passage.
From such scheme, can find out; Hardware configuration method based on Excel of the present invention can be carried out hardware configuration work easily under the Excel software environment; And can this result be converted into the hardware configuration result in the DCS software systems; Simplify the operation of DCS hardware configuration greatly, practiced thrift time and resource, the risk of having avoided human error to bring.
Preferably; In said configuration configuration step; The DCS hardware database is imported 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 the ardware model number scope respectively according to the hardware kind among the DCS; Said ardware model number scope be exactly said in the said drafting module of arranging the configured hardware model scope of wanting, wherein said hardware kind comprises CPU, communication network interface card, frame, power supply and fastener; In the said plot step of arranging; Carry out arranging of hardware device through the system configuration list and draw operation; This is arranged to draw to operate and comprises that automated station is arranged and fastener is arranged; Realize through the order under system configuration list state that respectively when said automated station was arranged, the order under the triggering system configuration list state was to create the automated station sublist; And the employed frame of DCS system, power supply, CPU, communication network are stuck in corresponding said ardware model number scope select configuration; When said fastener was arranged, the order under the triggering system configuration status to be creating the fastener sublist, and the employed fastener of DCS system is selected configuration in the said ardware model number scope of correspondence; In said system communication step; Data characteristics according to existing DCS software systems; The hardware layout viewing of the Excel file layout that will in the said plot step of arranging, draw changes into can be by the configuration file of DCS software systems identification, wherein this configuration file can be after importing the DCS software systems with relevant hardware device according to importing existing Hardware configuration automatic placement in the file; And in said address assignment step; The hardware configuration file that the DCS software systems are derived imports in the Excel list again; And be that each passage of fastener is distributed in the address of fastener channel allocation with the DCS software systems under the Excel software environment, thereby accomplish the hardware configuration worker group under the Excel software environment.
Preferably, draw said arranging, when in said system configuration list, hardware being arranged, said automated station is consistent with the drafting position and the putting position of each actual hardware module in rack of said fastener.
Preferably, in said configuration configuration step, selected ardware model number forms the drop-down menu of selecting corresponding kind of time-like in the said system configuration list according to the hardware kind among the DCS, thereby forms the ardware model number scope respectively.
Preferably, the order under the said system configuration list state is the right mouse button menu option.
Description of drawings
To make clearer above-mentioned and other feature and advantage of the present invention of those of ordinary skill in the art through describing the preferred embodiments of the present invention in detail below with reference to accompanying drawing, in the 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 the hardware selection in the DCS hardware configuration process of the specific embodiment of the invention;
Fig. 3 carries out automated station system configured surface chart in the DCS hardware configuration process of the specific embodiment of the invention;
Fig. 4 is the system interface figure of employed right-click menu in the DCS hardware configuration process of the specific embodiment of the invention;
Fig. 5 carries out fastener system configured surface chart in the DCS hardware configuration process of the specific embodiment of the invention;
Fig. 6 is the system interface figure that carries out the 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 of the invention, technical scheme and advantage clearer, below lift embodiment to further explain of the present invention.
To technical matters of the prior art, the present invention utilize Excel software the VBA interface exploitation based on the DCS hardware configuration system of 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 with functions such as input/output point address assignment to fastener passages, thereby accomplish the hardware configuration of DCS system in the Excel list.This result is so that figure and forms mode are presented to the user intuitively; Support further artificial adjustment; And all hardware configuration info can directly preserve into the hardware configuration file that the DCS software systems can be discerned, thereby directly the hardware configuration result in the Excel software is converted into the hardware configuration result in the DCS software systems.
In embodiment of the present invention, based on this DCS hardware configuration system of Excel mainly comprise 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 each module functions respectively:
(1) the configuration configuration module 10
Through design datas such as user's point table that DCS project user provided, cable meter, order inventory are analyzed; DCS slip-stick artist can at first obtain the hsrdware requirements of this project; Promptly 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 still in the DCS software systems; DCS slip-stick artist need select this hardware from complete DCS hardware database before the configuration of carrying out each hardware; Because the ardware model number quantity in the hardware database is all very huge with the hardware quantity that need carry out configuration; Therefore need require considerable time and effort and carry out this selection operation, also make a mistake easily in the process.For example; If DCS slip-stick artist need select 321-1BL00-0AA0 type I/O module as needed fastener; Then need comprise at the same time in the hardware database of equipment such as thousands of kinds of CPU, communication network interface card, frame, power supply, fastener and making a choice; And in the time in this project, need using this I/O module once more, then need to select once more.
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 the DCS hardware configuration system with the DCS hardware database, and is as shown in Figure 2.In this list, can carry out disposable selection to the ardware model number that possibly use in the DCS project, this selection only gets final product through carrying out choosing of " X " mark at " select " in left side row, and is as shown in Figure 2.For example; If can use 321-1BL00-0AA0 type I/O module in the DCS project as needed fastener; DCS slip-stick artist only need find this I/O module to be expert in the nextport hardware component NextPort list, in " select " of this row row, carries out choosing of " X " mark then and gets final product, and is as shown in Figure 2.
The hardware of in this nextport hardware component NextPort list, choosing can be arranged to draw in the operation and appeared in the corresponding range of choice at follow-up hardware.For example; If DCS slip-stick artist has selected the hardware device of " 400-2JA00-0AA0 " type with " 400-2JA10-0AA0 " type power supply and other model in the 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 the operation; Supply DCS slip-stick artist to select, as shown in Figure 3.
Can find out through above-mentioned explanation; How much quantity no matter a certain hardware uses in whole DCS project has; Only need once to select just can make it to appear in the hardware range of choice very little in the subsequent operation to it in the hardware database in the nextport hardware component NextPort list; This has simplified the operation that each hardware is arranged and drawn greatly, thereby has saved running time and resource significantly, has 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 through " system configuration (SysCon) list " and draws operation; This is arranged to draw to operate and mainly is divided into automated station (Automation Station; AS) arrange and fastener (DP) two parts of arranging; These two parts realize through " Add AS " in the right mouse button menu under system configuration list state and " Add DP " order respectively, and are as shown in Figure 4.
As shown in Figure 3, DCS slip-stick artist at first is configured the automated station in the rack.In this operation, DCS slip-stick artist at first triggers right-click menu shown in Figure 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.On this basis, can select configuration to the employed frame of DCS system (Rack), power supply (Power Supply), CPU, communication network interface card hardware devices such as (CP) respectively.It should be noted that operation through the configuration configuration module, the scope that hardware is selected be limited at that the DCS system might use more among a small circle in, thereby such hardware setting is very convenient quick.
After carrying out the automated station configuration, DCS slip-stick artist can be configured a series of fasteners that use in the system.In this operation, DCS slip-stick artist at first triggers right-click menu shown in Figure 4 and selects " Add DP " order, and the fastener sublist shown in Fig. 5 (sublist of arrow points downwards) will appear in the list.If desired many groups fastener is configured, then carries out " Add DP " order repeatedly and get final product.On this basis, DCS slip-stick artist can select configuration to the employed a series of fasteners of system respectively.Similar with automated station configuration, to the selection of fastener be limited at also that the DCS system might use more among a small circle in, thereby such fastener is provided with very convenient quick.Simultaneously, the title of each fastener can generate according to the predefined rule of system automatically, and DCS slip-stick artist can also be further be provided with the concrete connection mode of each fastener.
The corresponding a plurality of passages (Channel) of each fastener, each passage should corresponding input/output points in system.In follow-up operation, DCS slip-stick artist also can utilize the channel address distribution function of DCS software systems to come the address of each passage is configured, and will specifically introduce in the back literary composition.
What deserves to be mentioned is that when in the system configuration list, hardware being arranged, automated station is consistent with the drafting position and the putting position of actual hardware module in rack of fastener.That is to say, hardware configuration system in the Excel list with hardware arrange 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 the rack.
(3) system communication module 30
Owing to lack the interface of Excel software and DCS software systems in the prior art; Behind the hardware configuration of having accomplished under the Excel software environment; Also need under DCS software systems environment, all working to be repeated once according to the Excel list that has disposed; This has wasted the plenty of time, and mistake occurs easily.
After importing this .cfg file under the DCS software systems operation interface, relevant hardware device will be according to importing existing Hardware configuration automatic placement in the file, and this has just saved the extensive work that in the DCS software systems, carries out hardware configuration again.Afterwards, the DCS software systems are each the fastener passage calculated address for having disposed automatically, and this function repeats no more for the existing function of existing DCS software systems here.
After the passage calculated address for each fastener, the DCS software systems can be stored as relevant hardware configuration file with the hardware configuration result, and Excel software itself possesses the function of identification the type hardware configuration file.
(4) address assignment module 40
DCS slip-stick artist can import the hardware configuration file that the DCS system derives in the Excel list again; The fastener channel address that address assignment module 40 in the specific embodiment of the invention can will be generated in the DCS software systems is distributed to each passage of fastener automatically in the system configuration list, thereby accomplishes the hardware configuration work under the Excel software environment.Fig. 6 shows channel address is distributed to the hardware configuration state behind each fastener passage.
Utilize the hardware configuration file of accomplishing under the 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 also is provided in embodiment of the present invention, and this method mainly comprises the configuration configuration step, the plot step of arranging, system communication step and address assignment step, and is as shown in Figure 7.Below just introduce each step in this method of this hardware group respectively:
S10: configuration configuration step
Through design datas such as user's point table that DCS project user provided, cable meter, order inventory are analyzed; DCS slip-stick artist can at first obtain the hsrdware requirements of this project; Promptly 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, the DCS hardware database is imported " nextport hardware component NextPort list " in the 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 possibly use in the DCS project, and this selection only gets final product through carrying out choosing of " X " mark at " select " in left side row, and is as shown in Figure 2.The hardware of in this nextport hardware component NextPort list, choosing can be arranged to draw in the operation and appeared in the corresponding range of choice at follow-up hardware.
Can find out through above-mentioned explanation; How much quantity no matter a certain hardware uses in whole DCS project has; Only need in hardware database, once to select just can make it to appear in the hardware range of choice very little in the subsequent operation to it; This has simplified the operation that each hardware is arranged and drawn greatly, thereby has saved running time and energy significantly, has 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 through " system configuration " list and is drawn operation; This is arranged and draws operation and mainly be divided into automated station and arrange and fastener two parts of arranging; These two parts realize through " Add AS " in the right mouse button menu under system configuration list state and " Add DP " order respectively, and are as shown in Figure 4.
As shown in Figure 3, in the plot step of arranging, DCS slip-stick artist at first is configured the automated station in the rack.In this operation, DCS slip-stick artist at first triggers right-click menu shown in Figure 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.On this basis, DCS slip-stick artist can select configuration to hardware devices such as the employed frame of DCS system, power supply, CPU, communication network interface cards respectively.It should be noted that operation through the configuration configuration module, the scope that hardware is selected be limited at that the DCS system might use more among a small circle in, thereby such hardware setting is very convenient quick.
After the automated station configuration in the plot step of arranging, DCS slip-stick artist can be configured a series of fasteners that use in the system.In this operation, DCS slip-stick artist at first triggers right-click menu shown in Figure 4 and selects " Add DP " order, and the fastener sublist shown in Fig. 5 (sublist of arrow points downwards) will appear in the list.If desired many groups fastener is configured, then carries out " Add DP " order repeatedly and get final product.On this basis, DCS slip-stick artist can select configuration to the employed a series of fasteners of system respectively.Similar with automated station configuration, to the selection of fastener be limited at also that the DCS system might use more among a small circle in, thereby such fastener is provided with very convenient quick.Simultaneously, the title of each fastener can generate according to the predefined rule of system automatically, and DCS slip-stick artist can also be further be provided with the concrete connection mode of each fastener.
What deserves to be mentioned is that when in the system configuration list, hardware being arranged, automated station is consistent with the drafting position and the putting position of actual hardware module in rack of fastener.That is to say, hardware configuration system in the Excel list with hardware arrange 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 the rack.
S30: system communication step
System communication step in the specific embodiment of the invention provides the interface from Excel software to the DCS software systems; It can be according to the data characteristics of existing DCS software systems, and the hardware layout viewing that will in Excel, draw changes into can be by the configuration file (.cfg file) of DCS software systems identification.
In the system communication step; After importing this .cfg file under the DCS software systems operation interface; Relevant hardware device will be according to importing existing Hardware configuration automatic placement in the file, and this has just saved the extensive work that in the DCS software systems, carries out hardware configuration again.Afterwards, the DCS software systems are each the fastener passage calculated address for having disposed automatically, and this function repeats no more for the existing function of existing DCS software systems here.
After the passage calculated address for each fastener, the DCS software systems can be stored as relevant hardware configuration file with the hardware configuration result, and this document can be discerned by Excel software.
S40: address assignment step
DCS slip-stick artist can import the hardware configuration file that the DCS system derives in the Excel list again; In the address assignment step in the specific embodiment of the invention; The fastener channel address that can will in the DCS software systems, be generated is distributed to each passage of fastener automatically in the system configuration list, thereby accomplishes the hardware configuration work under the Excel software environment.Fig. 6 shows channel address is distributed to the hardware configuration state behind each fastener passage.
Utilize the hardware configuration file of accomplishing under the 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.
This shows; Hardware configuration system and method based on Excel in the specific embodiment of the invention can be carried out hardware configuration work easily under the Excel software environment; And can this result be converted into the hardware configuration result in the DCS software systems; Simplify the operation of DCS hardware configuration greatly, practiced thrift time and resource, the risk of having avoided human error to bring.
The above is merely preferred embodiment of the present invention, and is in order to restriction the present invention, not all within spirit of the present invention and principle, any modification of being done, is equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. the DCS hardware configuration system based on the Excel list is characterized in that, comprises configuration configuration module (10), the drafting module of arranging (20), system communication module (30) and address assignment module (40), wherein,
Said configuration configuration module (10) is used for the hsrdware requirements according to the DCS project, in hardware database, selects needed hardware, and selected hardware is formed the said drafting module of arranging (20) the configured hardware scope of wanting;
The said drafting module of arranging (20) is used in said hardware scope, the employed hardware of DCS project being selected configuration;
Said system communication module (30), being used for the Excel file conversion after the said drafting module of arranging (20) configuration is the discernible configuration files of DCS software systems; And
Said address assignment module (40), being used for the DCS software systems is fastener is distributed in the address of fastener channel allocation under the Excel software environment each passage.
2. system according to claim 1 is characterized in that,
Said configuration configuration module (10); Specifically be used for the DCS hardware database is imported the nextport hardware component NextPort list of Excel; Hsrdware requirements according to the DCS project; In this nextport hardware component NextPort list, find needed ardware model number and it is selected; And selected ardware model number formed the ardware model number scope respectively according to the hardware kind among the DCS, and said ardware model number scope is exactly the said drafting module of arranging (20) the configured hardware model scope of wanting, and wherein said hardware kind comprises CPU, communication network interface card, frame, power supply and fastener;
The said drafting module of arranging (20); Specifically be used for carrying out arranging of hardware device and draw operation through the system configuration list; This is arranged to draw to operate and comprises that automated station is arranged and fastener is arranged; Realize through the order under system configuration list state that respectively when said automated station was arranged, the order under the said drafting module of arranging (20) the triggering system configuration list state was to create the automated station sublist; And the employed frame of DCS system, power supply, CPU, communication network are stuck in corresponding said ardware model number scope select configuration; When said fastener was arranged, the order under the said drafting module of arranging (20) the triggering system configuration status to be creating the fastener sublist, and the employed fastener of DCS system is selected configuration in the said ardware model number scope of correspondence;
Said system communication module (30); Specifically be used for data characteristics according to existing DCS software systems; The hardware layout viewing of the Excel file layout that the said drafting module of arranging (20) is drawn changes into can be by the configuration file of DCS software systems identification, wherein this configuration file can be after importing the DCS software systems with relevant hardware device according to importing existing Hardware configuration automatic placement in the file; And
Said address assignment module (40); Specifically be used for the hardware configuration file that the DCS software systems derive is imported the Excel list again; And be that each passage of fastener is distributed in the address of fastener channel allocation with the DCS software systems under the Excel software environment, thereby accomplish the hardware configuration worker group under the Excel software environment.
3. system according to claim 1 and 2 is characterized in that,
When the said drafting module of arranging (20) was arranged to hardware in said system configuration list, said automated station was consistent with the drafting position and the putting position of each actual hardware module in rack of said fastener.
4. according to any described system among the claim 1-3, it is characterized in that,
The selected ardware model number of said configuration configuration module (10) forms the drop-down menu that the said drafting module of arranging (20) is selected corresponding kind of time-like according to the hardware kind among the DCS, thereby forms the ardware model number scope respectively.
5. according to any described system among the claim 1-4, it is characterized in that,
Order under the said system configuration list state is the right mouse button menu option.
6. the DCS hardware configuration method based on the Excel list is characterized in that, comprises the configuration configuration step, the plot step of arranging, system communication step and address assignment step, wherein,
Said configuration configuration step (S10) is used for the hsrdware requirements according to the DCS project, in hardware database, selects needed hardware, and selected hardware is formed on the configured hardware scope of wanting in the said plot step of arranging (S20);
The said plot step of arranging (S20) is used in said hardware scope, the employed hardware of DCS project being selected configuration;
Said system communication step (S30), being used for the Excel file conversion after the said plot step of arranging (S20) configuration is the discernible configuration files of DCS software systems; And
Said address assignment step (S40), being used for the DCS software systems is fastener is distributed in the address of fastener channel allocation under the Excel software environment each passage.
7. method according to claim 6 is characterized in that,
In said configuration configuration step; The DCS hardware database is imported the nextport hardware component NextPort list of Excel; Hsrdware requirements according to the DCS project; In this nextport hardware component NextPort list, find needed ardware model number and it is selected; And selected ardware model number formed the ardware model number scope respectively according to the hardware kind among the DCS, said ardware model number scope be exactly said in the said drafting module of arranging the configured hardware model scope of wanting, wherein said hardware kind comprises CPU, communication network interface card, frame, power supply and fastener;
In the said plot step of arranging; Carry out arranging of hardware device through the system configuration list and draw operation; This is arranged to draw to operate and comprises that automated station is arranged and fastener is arranged; Realize through the order under system configuration list state that respectively when said automated station was arranged, the order under the triggering system configuration list state was to create the automated station sublist; And the employed frame of DCS system, power supply, CPU, communication network are stuck in corresponding said ardware model number scope select configuration; When said fastener was arranged, the order under the triggering system configuration status to be creating the fastener sublist, and the employed fastener of DCS system is selected configuration in the said ardware model number scope of correspondence;
In said system communication step; Data characteristics according to existing DCS software systems; The hardware layout viewing of the Excel file layout that will in the said plot step of arranging, draw changes into can be by the configuration file of DCS software systems identification, wherein this configuration file can be after importing the DCS software systems with relevant hardware device according to importing existing Hardware configuration automatic placement in the file; And
In said address assignment step; The hardware configuration file that the DCS software systems are derived imports in the Excel list again; And be that each passage of fastener is distributed in the address of fastener channel allocation with the DCS software systems under the Excel software environment, thereby accomplish the hardware configuration worker group under the Excel software environment.
8. according to claim 6 or 7 described methods, it is characterized in that,
Draw said arranging, when in said system configuration list, hardware being arranged, said automated station is consistent with the drafting position and the putting position of each actual hardware module in rack of said fastener.
9. according to any described method among the claim 6-8, it is characterized in that,
In said configuration configuration step, selected ardware model number forms the drop-down menu of selecting corresponding kind of time-like in the said system configuration list according to the hardware kind among the DCS, thereby forms the ardware model number scope respectively.
10. according to any described method among the claim 6-9, it is characterized in that,
Order under the said system configuration list state is the 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 true CN102591808A (en) | 2012-07-18 |
| CN102591808B 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 (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102880748A (en) * | 2012-09-06 | 2013-01-16 | 国电联合动力技术有限公司 | Method for automatically drawing electric diagrams |
| CN104200397A (en) * | 2014-08-27 | 2014-12-10 | 北京广利核***工程有限公司 | Method for verifying consistence of designed input file and variable information database of DCS (Distributed Control System) of nuclear power station |
| CN105589351A (en) * | 2016-01-26 | 2016-05-18 | 北京科力通电气股份有限公司 | Configuration system |
| CN108469808A (en) * | 2018-04-03 | 2018-08-31 | 中国神华能源股份有限公司 | DCS hardware configuration hidden troubles removing system and methods |
| 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 (1)
| Title |
|---|
| 余丹: "基于S7-300与WinCC的桥式起重机监控管理***", 《华东交通大学学报》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102880748A (en) * | 2012-09-06 | 2013-01-16 | 国电联合动力技术有限公司 | Method for automatically drawing electric diagrams |
| CN104200397A (en) * | 2014-08-27 | 2014-12-10 | 北京广利核***工程有限公司 | Method for verifying consistence of designed input file and variable information database of DCS (Distributed Control System) of nuclear power station |
| 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 |
| CN108469808A (en) * | 2018-04-03 | 2018-08-31 | 中国神华能源股份有限公司 | DCS hardware configuration hidden troubles removing system and methods |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102591808B (en) | 2014-11-26 |
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 | |
| CN113557517A (en) | Automatic generation device and method of electrical design drawing | |
| CN102819557B (en) | Data query treating apparatus and data query disposal route | |
| CN102707669B (en) | Method for constructing CAM (computer-aided manufacturing) system for punching for automobile girders | |
| CN102870108A (en) | Method of generating electronic report | |
| CN105653245A (en) | Code automatic generation system, device and method | |
| CN106228338A (en) | A kind of distribution engineering intelligentized design integrated service system and using method | |
| CN103577165A (en) | Form generation method and form generator | |
| CN105787229B (en) | A kind of design of automatic production line and operation combined optimization method | |
| CN107590592A (en) | Job dependence relation method for expressing, operation displaying and dispatch control method and device | |
| CN103164573A (en) | Product data management (PDM) design system | |
| He et al. | ISA-95 tool for enterprise modeling | |
| EP2747001A1 (en) | A method and a system for granting an access to MES functionalities | |
| CN1329818C (en) | Implement method of the man machine command based on plain text command script files | |
| CN103870540A (en) | Database based on structural design and analysis integration | |
| EP1775667A2 (en) | Automatic qualification of plant equipment | |
| CN107016475B (en) | Method and device for electric commerce worksheet system platformization | |
| WO2012066683A1 (en) | System construction support tool and system construction support device | |
| CN103177074B (en) | Customize the graphic user interface of manufacturing execution system screen | |
| CN109377184B (en) | Work order opening method, device, storage medium and terminal | |
| CN104486117A (en) | Configuration command interaction method and configuration command interaction system of multi-board card core switch | |
| CN101518175A (en) | Inventory manager service and assistant for PCB manufacturing | |
| US20200057832A1 (en) | Method for Computer Assisted Planning of a Technical System |
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 |