A Single Automatic Generation System and Method for the IP Address Mode of a Local Dispatching Access Network

Abstract

The present invention relates to a system and method for automatically generating a single IP address mode for a local dispatching access network, which obtains an overall IP address planning library and an IP address planning sheet; uses the substation name as a trigger condition to generate an intermediate IP address mode sheet for the IP parameters corresponding to the substation name in the overall IP address planning library and in the IP address planning sheet corresponding to the substation name; maps the parameters planned in the IP address planning sheet to the intermediate IP address mode sheet, and establishes an association between all IP parameters and the overall IP address planning library in the intermediate IP address mode sheet to generate a final IP address mode sheet; and displays the IP parameters in the overall IP address planning library corresponding to the substation name on a display window. It can quickly query the existing substation IP addresses, quickly call the unused IP addresses and plan them into the required planning table, greatly improving the work efficiency and the accuracy of the IP address mode sheet for the local dispatching access network.

Description

Technical Field

[0001] The present invention belongs to the field of power dispatching, and more specifically, it is an automatic generation system and method for the IP address mode list of the local dispatching access network. Background Art

[0002] Currently, the planning of the IP address mode list of the local dispatching access network is manually planned, which requires a high technical level of automated operation and maintenance personnel. There are problems such as large workload and low efficiency, and it is easy to make human errors, resulting in poor accuracy of the IP address mode list of the local dispatching access network, affecting the normal access of newly built and renovated substations. Summary of the Invention

[0003] The technical problem to be solved by the present invention is to provide an automatic generation system and method for the IP address mode list of the local dispatching access network, improve the work efficiency of automated operation and maintenance personnel, and shorten the joint debugging time of the substation data network channel during infrastructure construction and technical transformation.

[0004] The present invention is implemented as follows:

[0005] An automatic generation method for the IP address mode list of the local dispatching access network, the method comprising:

[0006] Obtain the overall IP address planning library;

[0007] Obtain the IP address planning list;

[0008] Generate an index directory according to the substation name in the overall IP address planning library;

[0009] Taking the substation name in the index directory as a trigger condition, generate an intermediate IP address mode list with the IP parameters corresponding to the substation name in the overall IP address planning library and in the IP address planning list corresponding to the substation name, and establish the association between all IP parameters and the overall IP address planning library in the intermediate IP address mode list;

[0010] Correspond the parameters planned in the IP address planning list to the intermediate IP address mode list, and establish the association between all IP parameters and the overall IP address planning library in the intermediate IP address mode list to generate the final IP address mode list;

[0011] Display the IP parameters in the overall IP address planning library corresponding to the substation name on a display window.

[0012] Further, the overall IP address planning library includes communication time slots, substation names, loopback addresses, interface addresses, service addresses, management addresses, and OSPF areas corresponding to each substation address in the local dispatching access network established according to the network address and subnet mask.

[0013] Furthermore, the IP address planning sheet includes the substation name, LoopBack address, interconnection address, OSPF area, real-time switch management R address and S address, non-real-time switch management R address and S address, real-time R service interface address and longitudinal encryption address, non-real-time R service interface address and longitudinal encryption address, real-time VPN telecontrol service address, and non-real-time VPN power consumption service address.

[0014] Furthermore, generate an IP address method sheet for the IP parameters corresponding to the substation name in the overall IP address planning library, including invoking an IP address method sheet template, establishing the relationship between each IP parameter and the corresponding parameter and location in the IP address planning library in the IP address method sheet template, and updating the corresponding parameters in the IP address method sheet template as the parameters in the IP address planning library change.

[0015] Furthermore, invoking the IP address method sheet template includes creating a copy of the IP address method sheet template as an intermediate IP address method sheet and retaining the original IP address method sheet template.

[0016] Furthermore, the overall IP address planning library, the IP address planning sheet template, and the IP address method sheet adopt Excel files, and the association of parameters between the two is established through Excel functions.

[0017] Furthermore, the overall IP address planning library includes the IP parameters corresponding to the established substations and the unused IP parameters as standby substations. When a standby substation is triggered to generate an IP address method sheet, an event of modifying the name is triggered.

[0018] A system for automatically generating an IP address method sheet for a local dispatching access network, the system includes:

[0019] An acquisition module, which acquires the overall IP address planning library and the IP address planning sheet;

[0020] An indexing module, which generates an index directory according to the substation name in the overall IP address planning library;

[0021] A first association module, taking the substation name in the index directory as a trigger condition, generating an intermediate IP address method sheet for the IP parameters corresponding to the substation name in the overall IP address planning library and in the IP address planning sheet, and establishing the association between all IP parameters and the overall IP address planning library in the intermediate IP address method sheet;

[0022] A second association module, taking the end of the first association module as a trigger condition, corresponding the planned parameters in the IP address planning sheet to the intermediate IP address method sheet, and establishing the association between all IP parameters and the overall IP address planning library in the intermediate IP address method sheet to generate the final IP address method sheet;

[0023] A display module that displays the IP parameters corresponding to the substation name on a display window.

[0024] Furthermore, the first association module is also used to generate an IP address form sheet for the IP parameters corresponding to the substation name in the IP address master plan library, including invoking an IP address form sheet template, establishing the relationship between each IP parameter and the corresponding parameters and positions in the IP address master plan library in the IP address form sheet template, and updating the corresponding parameters in the IP address form sheet template as the parameters in the IP address master plan library change.

[0025] Furthermore, the first association module is also used to create a copy of the IP address form sheet template as an intermediate IP address form sheet and retain the original IP address form sheet template.

[0026] Compared with the prior art, the beneficial effects of the present invention are as follows:

[0027] The present invention can quickly query the existing substation IP addresses, quickly call and plan the unused IP addresses into the required plan sheets, greatly improving the work efficiency and the accuracy of the IP address form sheet for the local dispatching access network. BRIEF DESCRIPTION OF THE DRAWINGS

[0028] Figure 1 It is a flowchart of the method provided by an embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0029] In order to make the objectives, technical solutions and advantages of the present invention clearer and more understandable, the present invention will be further described in detail below in conjunction with embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0030] See Figure 1 As shown, a method for automatically generating an IP address form sheet for a local dispatching access network, the method includes:

[0031] Obtain an IP address master plan library;

[0032] Obtain an IP address planning sheet;

[0033] Generate an index directory according to the substation name in the IP address master plan library;

[0034] Using the substation name in the index directory as a trigger condition, generate an intermediate IP address form sheet for the IP parameters corresponding to the substation name in the IP address master plan library and in the IP address planning sheet, and establish the association between all IP parameters and the IP address master plan library in the intermediate IP address form sheet;

[0035] Map the parameters planned in the IP address planning sheet to the intermediate IP address method sheet, and establish the association between all IP parameters and the IP address overall planning library in the intermediate IP address method sheet to generate the final IP address method sheet;

[0036] Display the IP parameters in the IP address overall planning library corresponding to the substation name on a display window.

[0037] The IP address overall planning database, based on the overall planning of the IP address of the dispatching access network, formulates the communication time slots, substation names, loopback addresses, interface addresses, service addresses, management addresses, and OSPF areas of each substation in the dispatching access network with the set network addresses and subnet masks.

[0038] The IP address planning sheet includes the substation name, LoopBack address, interconnection address, OSPF area, real-time switch management R address and S address, non-real-time switch management R address and S address, real-time R service interface address and longitudinal encryption address, non-real-time R service interface address and longitudinal encryption address, real-time VPN telecontrol service address, and non-real-time VPN power consumption service address.

[0039] Generate an IP address method sheet for the IP parameters corresponding to the substation name in the IP address overall planning library, including calling an IP address method sheet template, establishing the relationship between each IP parameter and the corresponding parameters and positions in the IP address overall planning library in the IP address method sheet template, and updating the corresponding parameters in the IP address method sheet template as the parameters in the IP address overall planning library change.

[0040] Calling the IP address method sheet template includes creating a copy of the IP address method sheet template as the intermediate IP address method sheet and retaining the original IP address method sheet template.

[0041] In one embodiment, the IP address overall planning library and the IP address method sheet template adopt Excel files, and the association between the parameters of the two is established through Excel functions. For example, through the built-in functions of Excel, the variables such as the communication time slots, substation names, loopback addresses, interface addresses, service addresses, management addresses, and OSPF areas of a single substation in the IP address overall planning database are corresponded one by one with the content required in the transition data row in the columns of the IP address method sheet template.

[0042] In one embodiment, the corresponding relationship is as follows:

[0043] Substation name: =C5

[0044] Loopback address: =SUBSTITUTE(D5," / 32","")

[0045] Interface Address: =SUBSTITUTE(E5," / 30","")

[0046] Real-time Service Address: =SUBSTITUTE(F5," / 27","")

[0047] Non-real-time Service Address: =SUBSTITUTE(H5," / 27","")

[0048] Management Address: =SUBSTITUTE(G5," / 29","")

[0049] OSPF Area: =I5

[0050] Real-time Network:

[0051] =IF(F10="","",LEFT(F10,FIND("A",SUBSTITUTE(F10,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(F10,".","A",3),{1;2;3}))-2)

[0052] Non-real-time Network:

[0053] =IF(H10="","",LEFT(H10,FIND("A",SUBSTITUTE(H10,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(H10,".","A",3),{1;2;3}))-2)

[0054] Management Network:

[0055] =IF(G10="","",LEFT(G10,FIND("A",SUBSTITUTE(G10,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(G10,".","A",3),{1;2;3}))-2).

[0056] Map the variables such as the substation name, LoopBack address, interconnection address, OSPF area, real-time switch management R address and S address, non-real-time switch management R address and S address, real-time R service interface address and longitudinal encryption address, non-real-time R service interface address and longitudinal encryption address, real-time VPN telecontrol service address, non-real-time VPN power quantity service address, etc. in the P address planning form to the variables in the IP address mode single template one by one, and automatically generate the content in the final substation IP address mode form for the dispatching access network. The specific mapping relationship function is as follows:

[0057] Substation Name: = Template!C5

[0058] LoopBack Address: = Template!D5; = Template!D7

[0059] Interconnection Address: = Template!E5; = Template!E7

[0060] OSPF Area: = Template!I5

[0061] Real-time Switch Management R Address: =(IF(Template!D14="","",LEFT(Template!D14,FIND("A",SUBSTITUTE(Template!D14,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D14,".","A",3),{1;2;3}))+1))&" / 30"

[0062] Real-time Switch Management S Address: =(IF(Template!D14="","",LEFT(Template!D14,FIND("A",SUBSTITUTE(Template!D14,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D14,".","A",3),{1;2;3}))+2))&" / 30"

[0063] Non-real-time Switch Management R Address: =(IF(Template!D14="","",LEFT(Template!D14,FIND("A",SUBSTITUTE(Template!D14,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D14,".","A",3),{1;2;3}))+5))&" / 30"

[0064] Non-real-time Switch Management S Address: =(IF(Template!D14="","",LEFT(Template!D14,FIND("A",SUBSTITUTE(Template!D14,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D14,".","A",3),{1;2;3}))+6))&" / 30"

[0065] Non-real-time Switch Management R Address: =(IF(Template!D14="","",LEFT(Template!D14,FIND("A",SUBSTITUTE(Template!D14,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D14,".","A",3),{1;2;3}))+5))&" / 30"

[0066] Non-real-time Switch Management S Address: =(IF(Template!D14="","",LEFT(Template!D14,FIND("A",SUBSTITUTE(Template!D14,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D14,".","A",3),{1;2;3}))+6))&" / 30"

[0067] Real-time R service interface address: =(IF(Template!D12="","",LEFT(Template!D12,FIND("A",SUBSTITUTE(Template!D12,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D12,".","A",3),{1;2;3}))+1))&" / 27"

[0068] Real-time longitudinal encryption address: =(IF(Template!D12="","",LEFT(Template!D12,FIND("A",SUBSTITUTE(Template!D12,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D12,".","A",3),{1;2;3}))+30))&" / 27"

[0069] Non-real-time R service interface address: =(IF(Template!D13="","",LEFT(Template!D13,FIND("A",SUBSTITUTE(Template!D13,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D13,".","A",3),{1;2;3}))+1))&" / 27"

[0070] Non-real-time longitudinal encryption address: =(IF(Template!D13="","",LEFT(Template!D13,FIND("A",SUBSTITUTE(Template!D13,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D13,".","A",3),{1;2;3}))+30))&" / 27"

[0071] Real-time VPN telecontrol service address 1: =(IF(Template!D12="","",LEFT(Template!D12,FIND("A",SUBSTITUTE(Template!D12,".","A",3)))&-LOOKUP(0,-RIGHT(SUBSTITUTE(Template!D12,".","A",3),{1;2;3}))+4))&" / 27"

[0072] Real-time VPN telecontrol service address 2 := (IF(Template!D12 = "", "", LEFT(Template!D12, FIND("A", SUBSTITUTE(Template!D12, ".", "A", 3))) & -LOOKUP(0, -RIGHT(SUBSTITUTE(Template!D12, ".", "A", 3), {1; 2; 3})) + 5)) & " / 27"

[0073] Real-time VPN telecontrol service address 3 := (IF(Template!D13 = "", "", LEFT(Template!D12, FIND("A", SUBSTITUTE(Template!D13, ".", "A", 3))) & -LOOKUP(0, -RIGHT(SUBSTITUTE(Template!D12, ".", "A", 3), {1; 2; 3})) + 6)) & " / 27"

[0074] Non-real-time VPN power quantity service address 1 := (IF(Template!D13 = "", "", LEFT(Template!D13, FIND("A", SUBSTITUTE(Template!D13, ".", "A", 3))) & -LOOKUP(0, -RIGHT(SUBSTITUTE(Template!D13, ".", "A", 3), {1; 2; 3})) + 4)) & " / 27"

[0075] Non-real-time VPN power quantity service address 2 := (IF(Template!D13 = "", "", LEFT(Template!D13, FIND("A", SUBSTITUTE(Template!D13, ".", "A", 3))) & -LOOKUP(0, -RIGHT(SUBSTITUTE(Template!D13, ".", "A", 3), {1; 2; 3})) + 5)) & " / 27."

[0076] The IP address overall planning library includes the IP parameters corresponding to the established substations and the unused IP parameters as standby substations. When a standby substation is triggered and an IP address mode list is generated, an event of modifying the name is triggered. When the substation in the IP address planning list is a standby substation, a standby data in the IP address overall planning library can be retrieved.

[0077] The generated IP address mode list is automatically stored in the planning list folder.

[0078] The present invention also provides a system for automatically generating an IP address mode list for a local dispatching access network, and the system includes:

[0079] Obtain the IP address overall planning library;

[0080] Obtain an IP address planning list;

[0081] Generate an index directory based on the substation name in the overall IP address planning library;

[0082] Using the substation name in the index directory as a trigger condition, generate an intermediate IP address mode list for the IP parameters corresponding to this substation name in the overall IP address planning library and in the IP address planning form, and establish the association between all IP parameters and the overall IP address planning library in the intermediate IP address mode list;

[0083] Correspond the parameters planned in the IP address planning form to the intermediate IP address mode list, and establish the association between all IP parameters and the overall IP address planning library in the intermediate IP address mode list to generate the final IP address mode list;

[0084] Display the IP parameters in the overall IP address planning library corresponding to the substation name on a display window.

[0085] The above are only the preferred embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent replacements, and improvements made within the spirit and principles of the present invention shall be included within the protection scope of the present invention.

Claims

1. A method for automatically generating a single IP address mode for a dispatching access network, characterized in that, the method includes: Obtaining an overall IP address planning library; Obtaining an IP address planning sheet; Generating an index directory according to the substation names in the overall IP address planning library; Taking the substation name in the index directory as a trigger condition, generating an intermediate IP address mode sheet for the IP parameters corresponding to the substation name in the overall IP address planning library and in the IP address planning sheet corresponding to the substation name, and establishing an association between all IP parameters and the overall IP address planning library in the intermediate IP address mode sheet; generating an IP address mode sheet for the IP parameters corresponding to the substation name in the overall IP address planning library includes calling an IP address mode sheet template, establishing the relationship between each IP parameter and the corresponding parameter and location in the overall IP address planning library in the IP address mode sheet template, and updating the corresponding parameters in the IP address mode sheet template as the parameters in the overall IP address planning library change; Mapping the planned parameters in the IP address planning sheet to the intermediate IP address mode sheet, and establishing an association between all IP parameters and the overall IP address planning library in the intermediate IP address mode sheet to generate the final IP address mode sheet; Displaying the IP parameters in the overall IP address planning library corresponding to the substation name on a display window.

2. The method according to claim 1, characterized in that, the overall IP address planning library includes communication time slots, substation names, loopback addresses, interface addresses, service addresses, management addresses, and OSPF areas corresponding to the addresses of each substation in the dispatching access network established according to the network address and subnet mask.

3. The method according to claim 2, characterized in that, The IP address planning sheet includes substation name, LoopBack address, interconnection address, OSPF area, real-time switch management R address and S address, non-real-time switch management R address and S address, real-time R service interface address and longitudinal encryption address, non-real-time R service interface address and longitudinal encryption address, real-time VPN telecontrol service address, non-real-time VPN power quantity service address.

4. The method according to claim 1, characterized in that, Calling the IP address mode sheet template includes creating a copy of the IP address mode sheet template as the intermediate IP address mode sheet and retaining the original IP address mode sheet template.

5. The method according to claim 4, characterized in that, The overall IP address planning library, the IP address mode sheet template, and the IP address mode sheet adopt Excel files, and the association between the parameters of the two is established through Excel functions.

6. The method according to claim 4, characterized in that, The overall IP address planning library includes the IP parameters corresponding to the established substations and the spare substations with unused IP parameters. When triggering a spare substation to generate an IP address mode sheet, an event of modifying the name is triggered.

7. A system for automatically generating a single IP address mode for a dispatching access network, characterized in that, the system includes: An acquisition module that acquires an IP address overall planning library and an IP address planning form; An indexing module that generates an index directory based on the substation names in the IP address overall planning library; A first association module that uses the substation name in the index directory as a trigger condition to generate an intermediate IP address mode form for the IP parameters corresponding to the substation name in the IP address overall planning library and included in the IP address planning form, and establishes an association between all IP parameters and the IP address overall planning library in the intermediate IP address mode form; A second association module that uses the end of the first association module as a trigger condition to map the planned parameters in the IP address planning form to the intermediate IP address mode form, and establishes an association between all IP parameters and the IP address overall planning library in the intermediate IP address mode form to generate a final IP address mode form; A display module that displays the IP parameters corresponding to the substation name on a display window; The first association module is further configured to generate an IP address mode form for the IP parameters corresponding to the substation name in the IP address overall planning library, including calling an IP address mode form template, establishing the relationship between each IP parameter and the corresponding parameter and location in the IP address overall planning library in the IP address mode form template, and updating the corresponding parameters in the IP address mode form template as the parameters in the IP address overall planning library change.

8. The system according to claim 7, wherein, the first association module is further configured to create a copy of the IP address mode form template as the intermediate IP address mode form and retain the original IP address mode form template.

Images