CN116150157A - Method, device, equipment and medium for processing equipment account data - Google Patents
Method, device, equipment and medium for processing equipment account data Download PDFInfo
- Publication number
- CN116150157A CN116150157A CN202310168331.5A CN202310168331A CN116150157A CN 116150157 A CN116150157 A CN 116150157A CN 202310168331 A CN202310168331 A CN 202310168331A CN 116150157 A CN116150157 A CN 116150157A
- Authority
- CN
- China
- Prior art keywords
- equipment
- data
- ledger data
- substation
- ledger
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 48
- 238000012545 processing Methods 0.000 title claims abstract description 39
- 238000004590 computer program Methods 0.000 claims description 17
- 238000013523 data management Methods 0.000 claims description 9
- 238000001514 detection method Methods 0.000 description 9
- 238000004891 communication Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 5
- 238000003672 processing method Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000001276 controlling effect Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 239000011521 glass Substances 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000010801 machine learning Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000001105 regulatory effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000001953 sensory effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Public Health (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method, a device, equipment and a medium for processing equipment ledger data. The method comprises the following steps: acquiring a substation configuration description file of a substation to be processed; determining the ledger data of at least one secondary device in the transformer substation to be processed according to the transformer substation configuration description file; and writing the ledger data of each secondary device into a device ledger data table. According to the embodiment of the invention, the standing book data of each secondary device in the transformer substation can be automatically determined according to the transformer substation configuration description file of the transformer substation, the standing book data of each secondary device can be automatically written into the device standing book data table, and the standing book data of the secondary devices in the transformer substation are uniformly stored and managed through the device standing book data table, so that the working efficiency is high and the accuracy is high.
Description
Technical Field
The present invention relates to the field of electric power technologies, and in particular, to a method, an apparatus, a device, and a medium for processing equipment ledger data.
Background
The transformer substation contains a large number of primary and secondary devices. Primary devices are devices that are directly used to produce and use electrical energy. The secondary device is a device in the substation, which is not directly connected with the electric energy generation, and is generally an auxiliary device in the substation for monitoring, measuring, controlling, protecting or adjusting the primary device. The ledger data of the secondary device is a key device parameter of the secondary device. In order to effectively monitor the secondary equipment in the transformer substation, the ledger data of the secondary equipment in the transformer substation needs to be processed, and the ledger data of the secondary equipment in the transformer substation is uniformly stored and managed.
In the related art, the processing scheme of the equipment ledger data is as follows: and a technician collects the account standing data of the secondary equipment in the transformer substation to be monitored, then manually inputs the account standing data of the secondary equipment in the transformer substation into a designated file, and uniformly stores and manages the account standing data of the secondary equipment in the transformer substation by manpower. The processing scheme of the equipment account data in the related technology mainly depends on manual work, so that time and labor are wasted, the working efficiency is low, and the accuracy is difficult to guarantee.
Disclosure of Invention
The invention provides a method, a device, equipment and a medium for processing equipment ledger data, which are used for solving the problems that the processing scheme of the equipment ledger data in the related technology mainly depends on manpower, and is time-consuming and labor-consuming, low in working efficiency and difficult to guarantee in accuracy.
According to an aspect of the present invention, there is provided a method for processing equipment ledger data, including:
acquiring a substation configuration description file of a substation to be processed;
determining the ledger data of at least one secondary device in the transformer substation to be processed according to the transformer substation configuration description file;
and writing the ledger data of each secondary device into a device ledger data table.
According to another aspect of the present invention, there is provided a processing apparatus for device ledger data, including:
the file acquisition module is used for acquiring a substation configuration description file of the substation to be processed;
the data determining module is used for determining the ledger data of at least one secondary device in the transformer substation to be processed according to the transformer substation configuration description file;
and the data writing module is used for writing the ledger data of each secondary device into the device ledger data table.
According to another aspect of the present invention, there is provided an electronic apparatus including:
at least one processor;
and a memory communicatively coupled to the at least one processor;
the memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor, so that the at least one processor can execute the method for processing the equipment ledger data according to any embodiment of the present invention.
According to another aspect of the present invention, there is provided a computer readable storage medium storing computer instructions for causing a processor to implement the method for processing equipment ledger data according to any one of the embodiments of the present invention when executed.
According to the technical scheme, the transformer substation configuration description file of the transformer substation to be processed is obtained, then the standing book data of at least one secondary device in the transformer substation to be processed is determined according to the transformer substation configuration description file, finally the standing book data of each secondary device are written into the device standing book data table, the problems that the processing scheme of the device standing book data in the related art mainly depends on manpower, time and labor are wasted, the working efficiency is low, the accuracy is difficult to guarantee are solved, the standing book data of each secondary device in the transformer substation can be automatically determined according to the transformer substation configuration description file of the transformer substation, the standing book data of each secondary device can be automatically written into the device standing book data table, and the standing book data of the secondary devices in the transformer substation are uniformly stored and managed through the device standing book data table.
It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the invention or to delineate the scope of the invention. Other features of the present invention will become apparent from the description that follows.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a flowchart of a method for processing equipment ledger data according to an embodiment of the present invention.
Fig. 2 is a flowchart of a method for processing equipment ledger data according to a second embodiment of the present invention.
Fig. 3 is a schematic structural diagram of a device for processing equipment ledger data according to a third embodiment of the present invention.
Fig. 4 is a schematic structural diagram of an electronic device implementing a method for processing device ledger data according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "object," "first," "second," and the like in the description and the claims of the present invention and the above drawings are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example 1
Fig. 1 is a flowchart of a method for processing equipment ledger data, which is provided in an embodiment of the present invention, where the embodiment is applicable to a case of processing ledger data of secondary equipment in a substation to be monitored, and uniformly storing and managing ledger data of secondary equipment in the substation. The method may be performed by a device for processing device ledger data, which may be implemented in hardware and/or software, and which may be configured in an electronic device. The electronic equipment is used for processing the ledger data of the secondary equipment in the transformer substation to be monitored, and uniformly storing and managing the ledger data of the secondary equipment in the transformer substation.
As shown in fig. 1, the method includes:
and 101, acquiring a substation configuration description file of the substation to be processed.
Optionally, the substation to be treated is one or more substations that need to be monitored. In order to effectively monitor the secondary equipment in the transformer substation to be processed, the ledger data of the secondary equipment in the transformer substation to be processed needs to be processed, and the ledger data of the secondary equipment in the transformer substation to be processed is uniformly stored and managed.
Optionally, the substation to be treated contains a large number of primary devices and secondary devices. Primary devices are devices that are directly used to produce and use electrical energy. Such as generators, transformers, circuit breakers, disconnectors, bus bars, power cables and transmission lines, etc. The secondary equipment is equipment which is not directly connected with the electric energy generation in the transformer substation to be processed, and is generally auxiliary equipment for monitoring, measuring, controlling, protecting or adjusting the primary equipment in the transformer substation to be processed. The ledger data of the secondary device is a key device parameter of the secondary device, namely an important device parameter in all device parameters of the secondary device.
Optionally, a substation configuration description (Substation Configuration Description, SCD) file of the substation to be processed describes all intelligent electronic devices (Intelligent Electronic Device, IEDs) in the substation to be processed, and configuration conditions of all intelligent electronic devices, including device information and configuration information of all intelligent electronic devices in the substation to be processed. The device information of the intelligent electronic device may include a plurality of device parameters of the intelligent electronic device, and description information related to the intelligent electronic device. The intelligent electronic devices in the substation to be processed comprise secondary devices in the substation to be processed. Therefore, the substation configuration description file of the substation to be processed can be used as an important basis for determining the ledger data of each secondary device in the substation to be processed.
Optionally, the obtaining a substation configuration description file of the substation to be processed includes: and obtaining a substation configuration description file of the substation to be processed, which is uploaded by the target user. The target user may be a technician responsible for managing the substation to be treated. And uploading the substation configuration description file of the substation to be processed to the electronic equipment by the target user through the terminal equipment. The electronic equipment acquires a substation configuration description file of the substation to be processed, which is uploaded by a target user.
And 102, determining the ledger data of at least one secondary device in the transformer substation to be processed according to the transformer substation configuration description file.
Optionally, the ledger data includes basic parameters and technical parameters; the step of determining the ledger data of at least one secondary device in the transformer substation to be processed according to the transformer substation configuration description file comprises the following steps: the following operations are executed for each secondary device in the substation to be processed: extracting basic parameters of secondary equipment from the file name of the transformer substation configuration description file; extracting the equipment information of the secondary equipment from an equipment information list in the substation configuration description file; and determining technical parameters of the secondary equipment according to the equipment information of the secondary equipment.
Optionally, the basic parameters of the secondary device include: the name of the transformer station where the secondary equipment is located and/or the operation time of the secondary equipment. The technical parameters of the secondary equipment include: the name of the protected device corresponding to the secondary device, the name of the secondary device, the device type of the secondary device, the device class remark of the secondary device, the model of the secondary device, the manufacturer of the secondary device, the configuration version of the secondary device, the IED capability description file (IED Capability Description, ICD) check code of the secondary device, the IP address of the secondary device and/or the voltage class of the secondary device.
Optionally, the name of the transformer substation where each secondary device in the transformer substation to be processed is located is the name of the transformer substation to be processed. The operation time of each secondary device in the transformer substation to be processed is the operation time of the transformer substation to be processed. The file name of the substation configuration description file of the substation to be processed comprises the name of the substation to be processed and the operation time of the substation to be processed.
Optionally, extracting the basic parameters of the secondary device from the file name of the substation configuration description file includes: extracting the name of the transformer substation to be processed from the file name of the transformer substation configuration description file, and determining the name of the transformer substation to be processed as the name of the transformer substation where the secondary equipment is located; and extracting the operation time of the transformer substation to be processed from the file name of the transformer substation configuration description file, and determining the operation time of the transformer substation to be processed as the operation time of the secondary equipment.
Optionally, the device information list in the substation configuration description file is a list for storing device information of all intelligent electronic devices in the substation to be processed. And the equipment information list in the substation configuration description file contains the equipment information of each secondary equipment in the substation to be processed. The device information of the secondary device includes, but is not limited to: the name of the secondary device, the model of the secondary device, the manufacturer of the secondary device, the configuration version of the secondary device, the ICD check code of the secondary device, the IP address of the secondary device, the voltage class of the secondary device and the description text of the secondary device. The electronic equipment can extract the equipment information of each secondary equipment from the equipment information list in the substation configuration description file.
Optionally, determining the technical parameter of the secondary device according to the device information of the secondary device includes: extracting the name of the secondary equipment, the model of the secondary equipment, the manufacturer of the secondary equipment, the configuration version of the secondary equipment, the ICD check code of the secondary equipment, the IP address of the secondary equipment and the voltage level of the secondary equipment from the equipment information of the secondary equipment; and determining the name of the protected equipment corresponding to the secondary equipment, the equipment type of the secondary equipment and the equipment type remark of the secondary equipment according to the name of the secondary equipment and the description text of the secondary equipment in the equipment information of the secondary equipment.
Optionally, the protected device corresponding to the secondary device is a primary device that is monitored, measured, controlled, protected or regulated by the secondary device.
Optionally, the description text of the secondary device is text for describing the attribute of the secondary device and the protected device corresponding to the secondary device. The description text of the secondary device contains the name of the protected device corresponding to the secondary device.
Optionally, the device type of the secondary device is main transformer protection, bus protection, line protection, breaker protection, grounding transformer protection, intelligent terminal, high intelligent terminal, medium intelligent terminal, low intelligent terminal, body intelligent terminal, non-electric quantity protection, body intelligent terminal, merging unit, central switch, interval switch or intelligent wave recording acquisition unit.
Optionally, the device class of the secondary device is a protection device, a measurement and control device, an intelligent terminal, a merging unit, a process layer switch or an intelligent recorder.
Optionally, the device class remark of the secondary device is information for describing the sequence numbers of the secondary device in a plurality of secondary devices in the same device class.
Optionally, determining the name of the protected device corresponding to the secondary device, the device type of the secondary device, the device class of the secondary device and the device class remark of the secondary device according to the name of the secondary device and the description text of the secondary device in the device information of the secondary device includes: extracting the name of the protected equipment corresponding to the secondary equipment from the description text of the secondary equipment; detecting whether the name of the secondary equipment and the description text of the secondary equipment contain preset type keywords or not, and determining the equipment type of the secondary equipment according to a detection result; determining the equipment type of the secondary equipment according to the equipment type of the secondary equipment; and detecting whether the name of the secondary equipment and the description text of the secondary equipment contain preset ordering keywords or not, and determining equipment category remarks of the secondary equipment according to detection results.
Optionally, the preset type of keyword is a character or word related to a device type of the secondary device. Preset types of keywords include, but are not limited to: p_ T, P _ M, P _ L, P _ K, P _ J, P _ B, PCG, main transformer, bus bar, line, segment, bus bar, circuit breaker, and ground transformer.
Optionally, detecting whether the name of the secondary device and the description text of the secondary device contain a preset type keyword, and determining the device type of the secondary device according to the detection result includes: detecting whether the name of the secondary equipment and the description text of the secondary equipment contain preset type keywords or not; if the name of the secondary equipment comprises P_T and the description text of the secondary equipment comprises a main transformer, determining the equipment type of the secondary equipment as main transformer protection; if the name of the secondary equipment comprises P_M and the description text of the secondary equipment comprises bus or bus difference, determining the equipment type of the secondary equipment as bus protection; if the name of the secondary equipment comprises P_L and the description text of the secondary equipment comprises a line, determining the equipment type of the secondary equipment as line protection; if the name of the secondary equipment comprises P_ K, P _J or P_B and the description text of the secondary equipment comprises a segment, a bus or a breaker, determining the equipment type of the secondary equipment as breaker protection; and if the name of the secondary equipment comprises PCG and the description text of the secondary equipment comprises grounding transformer, determining the equipment type of the secondary equipment as grounding transformer protection.
Optionally, detecting whether the name of the secondary device and the description text of the secondary device contain a preset type keyword, determining the device type of the secondary device according to the detection result, and further including: if the name of the secondary equipment starts with I, the third letter is not T, and the description text of the secondary equipment contains the intelligent terminal, the equipment type of the secondary equipment is determined to be the intelligent terminal.
Optionally, detecting whether the name of the secondary device and the description text of the secondary device contain a preset type keyword, determining the device type of the secondary device according to the detection result, and further including: if the third letter in the name of the secondary equipment is T, the third data in the name of the secondary equipment is 1, the fourth data in the name of the secondary equipment is 1, and the substation level of the substation to be processed is 110 kilovolts, determining that the equipment type of the secondary equipment is a high intelligent terminal; if the third letter in the name of the secondary equipment is T, the third data in the name of the secondary equipment is 1, the fourth data in the name of the secondary equipment is 0, and the substation level of the substation to be processed is 110 kilovolts, determining that the equipment type of the secondary equipment is a low-voltage intelligent terminal; if the third letter in the name of the secondary equipment is T, the third data in the name of the secondary equipment is 2, the fourth data in the name of the secondary equipment is 2, and the substation level of the substation to be processed is 220 kilovolts, determining that the equipment type of the secondary equipment is a high intelligent terminal; if the third letter in the name of the secondary equipment is T, the third data in the name of the secondary equipment is 1, the fourth data in the name of the secondary equipment is 1, and the substation level of the substation to be processed is 220 kilovolts, determining that the equipment type of the secondary equipment is a variable-center intelligent terminal; if the third letter in the name of the secondary equipment is T, the third data in the name of the secondary equipment is 1, the fourth data in the name of the secondary equipment is 0, and the substation level of the substation to be processed is 220 kilovolts, determining that the equipment type of the secondary equipment is a low-voltage intelligent terminal; if the third letter in the name of the secondary equipment is T, the third data in the name of the secondary equipment is 5, the fourth data in the name of the secondary equipment is 0, and the substation level of the substation to be processed is 500 kilovolts, determining that the equipment type of the secondary equipment is a high intelligent terminal; if the third letter in the name of the secondary equipment is T, the third data in the name of the secondary equipment is 2, the fourth data in the name of the secondary equipment is 2, and the substation level of the substation to be processed is 500 kilovolts, determining that the equipment type of the secondary equipment is a variable-center intelligent terminal; if the third letter in the name of the secondary equipment is T, the third data in the name of the secondary equipment is 3, the fourth data in the name of the secondary equipment is 5, and the substation level of the substation to be processed is 500 kilovolts, determining that the equipment type of the secondary equipment is a low-voltage intelligent terminal.
Optionally, detecting whether the name of the secondary device and the description text of the secondary device contain a preset type keyword, determining the device type of the secondary device according to the detection result, and further including: if the name of the secondary equipment starts with NIT and the description text of the secondary equipment contains main transformer, determining the equipment type of the secondary equipment as an intelligent terminal and non-electric quantity protection; if the name of the secondary equipment starts with IBT and the description text of the secondary equipment contains main transformers, determining the equipment type of the secondary equipment as an intelligent terminal of the body; if the name of the secondary equipment starts with M and the description text of the secondary equipment contains a merging unit, determining the equipment type of the secondary equipment as the merging unit; if the name of the secondary equipment starts with SW and the description text of the secondary equipment contains a central switch, determining the equipment type of the secondary equipment as the central switch; if the name of the secondary equipment starts with SW and the description text of the secondary equipment contains an x-number switch, determining the equipment type of the secondary equipment as an interval switch; if the name of the secondary equipment starts with SUL and the description text of the secondary equipment contains intelligent recording, determining the equipment type of the secondary equipment as an intelligent recording acquisition unit. x in the x switch is any number or letter.
Optionally, determining the device class of the secondary device according to the device type of the secondary device includes: if the equipment type of the secondary equipment is main transformer protection, bus protection, line protection, breaker protection or grounding transformer protection, determining the equipment type of the secondary equipment as a protection device; if the equipment types of the secondary equipment are intelligent terminals, high-level intelligent terminals, medium-level intelligent terminals, low-level intelligent terminals, body intelligent terminals or body intelligent terminals and non-electric quantity protection, determining the equipment type of the secondary equipment as the intelligent terminals; and if the equipment type of the secondary equipment is a central switch or an interval switch, determining the equipment type of the secondary equipment as a process layer switch.
Optionally, the preset sort key is a character or word associated with a device class note of the secondary device. Preset ranking keywords include, but are not limited to: the device comprises a sleeve A, a sleeve B, a sleeve C, a primary first sleeve, a primary second sleeve, a first sleeve and a second sleeve.
Optionally, detecting whether the name of the secondary device and the description text of the secondary device include a preset ordering keyword, and determining a device class remark of the secondary device according to a detection result, including: if the name of the secondary equipment ends with A and the description text of the secondary equipment contains A set, primary set or first set, determining the equipment category remark of the secondary equipment as the first set; if the name of the secondary equipment ends with B and the description text of the secondary equipment contains a B set, a primary set or a secondary set, determining the equipment category remark of the secondary equipment as the secondary set; and if the name of the secondary equipment ends with C and the description text of the secondary equipment contains C sets, determining that the equipment category remark of the secondary equipment is a third set.
Optionally, detecting whether the name of the secondary device and the description text of the secondary device contain preset ordering keywords, determining a device class remark of the secondary device according to a detection result, and further including: and if the name of the secondary equipment ends with X and the description text of the secondary equipment does not contain the A sleeve, the B sleeve, the C sleeve, the primary first or the primary second, determining the equipment category remark of the secondary equipment as the first sleeve.
Optionally, detecting whether the name of the secondary device and the description text of the secondary device contain preset ordering keywords, determining a device class remark of the secondary device according to a detection result, and further including: and if the name of the secondary equipment starts with SW and the description text of the secondary equipment contains an xxkV process layer x-network x-number switch, determining that the equipment category remark of the secondary equipment is the x-network x-number switch. x in the xxkV process layer x network x number switch is any number or letter.
And 103, writing the ledger data of each secondary device into a device ledger data table.
Optionally, the device ledger data table is a table for storing ledger data of the secondary device. The device ledger data table includes a plurality of data rows. One data line is used to store ledger data for one secondary device. The data line includes a plurality of cells. Each cell is used for storing one item of data in the ledger data.
Optionally, the writing the ledger data of each secondary device into the device ledger data table includes: the following operations are executed for each secondary device in the substation to be processed: determining a target data row corresponding to the standing account data of the secondary equipment in blank data rows of the equipment standing account data table; and writing the ledger data of the secondary equipment into the target data row.
Optionally, the target data line corresponding to the ledger data of the secondary device is a data line for storing ledger data of the secondary device. The blank data line is a data line without corresponding ledger data. No ledger data is stored in the blank data line.
Optionally, determining, in the blank data rows of the device ledger data table, a target data row corresponding to ledger data of the secondary device includes: and determining one blank data row in all blank data rows of the equipment ledger data table as a target data row corresponding to the ledger data of the secondary equipment. Therefore, a corresponding blank data row is respectively allocated to each secondary device in the transformer substation to be processed.
Optionally, writing the ledger data of the secondary device into the target data row includes: writing each item of data in the ledger data of the secondary equipment into each cell in the target data row; wherein one item of data in the ledger data corresponds to one cell in one of the target data lines. Thereby, the objective data line stores the ledger data of the secondary device.
Optionally, after writing the ledger data of each secondary device into the device ledger data table, the method further includes: and correspondingly storing the identification information of each secondary device and the table position of the standing account data of each secondary device in the equipment standing account data table into a preset database.
Optionally, after the identification information of each secondary device and the table position of the ledger data of each secondary device in the device ledger data table are correspondingly stored in a preset database, the method further includes: acquiring a standing book data query request corresponding to target secondary equipment, which is input by a target user; acquiring the table position of the standing book data of the target secondary equipment in the equipment standing book data table from the preset database according to the identification information of the target secondary equipment; according to the table position of the standing book data of the target secondary equipment in the equipment standing book data table, acquiring the standing book data of the target secondary equipment from the equipment standing book data table; and providing the ledger data of the target secondary equipment for the target user.
According to the technical scheme, the transformer substation configuration description file of the transformer substation to be processed is obtained, then the standing book data of at least one secondary device in the transformer substation to be processed is determined according to the transformer substation configuration description file, finally the standing book data of each secondary device are written into the device standing book data table, the problems that the processing scheme of the device standing book data in the related art mainly depends on manpower, time and labor are wasted, the working efficiency is low, the accuracy is difficult to guarantee are solved, the standing book data of each secondary device in the transformer substation can be automatically determined according to the transformer substation configuration description file of the transformer substation, the standing book data of each secondary device can be automatically written into the device standing book data table, and the standing book data of the secondary devices in the transformer substation are uniformly stored and managed through the device standing book data table.
Example two
Fig. 2 is a flowchart of a method for processing equipment ledger data according to a second embodiment of the present invention, where the embodiment of the present invention may be combined with each of the alternatives in one or more embodiments described above. As shown in fig. 2, the method includes:
And 204, correspondingly storing the identification information of each secondary device and the table position of the standing book data of each secondary device in the device standing book data table into a preset database.
Alternatively, the identification information of each of the secondary devices may be a name of each of the secondary devices.
Optionally, the table position of the ledger data of each secondary device in the ledger data table of the device is a line number of a target data line corresponding to the ledger data of each secondary device. Each data line in the equipment ledger data table has a unique corresponding line number. And positioning the data row in the equipment ledger data table according to the row number of the data row. According to the table position of the ledger data of each secondary device in the device ledger data table, a target data row corresponding to the ledger data of each secondary device in the device ledger data table can be determined.
Optionally, the preset database is a database for storing information related to ledger data of secondary devices of the substation to be processed.
Optionally, the target secondary device is one or more secondary devices in the substation to be treated. The ledger data inquiry request corresponding to the target secondary device is a request for requesting acquisition of ledger data of the target secondary device.
Optionally, obtaining the ledger data query request corresponding to the target secondary device, which is input by the target user, includes: and acquiring a ledger data query request corresponding to the target secondary equipment, which is input by the target user, through the data management page. The data management page is a page for interacting with a user, acquiring information related to the ledger data of the secondary equipment of the transformer substation to be processed, which is input by the user, or providing the ledger data of the secondary equipment of the transformer substation to be processed to the user. The target user may be a technician responsible for managing the substation to be treated. And the target user inputs the ledger data query request corresponding to the target secondary equipment by filling or selecting the identification information of the target secondary equipment on the data management page.
Optionally, according to the identification information of the target secondary device, a table position of the ledger data of the target secondary device in the ledger data table of the device is obtained from the preset database, including: inquiring target identification information which is the same as the identification information of the target secondary equipment in the identification information of each secondary equipment in the preset database; if the target identification information which is the same as the identification information of the target secondary equipment is queried, acquiring a table position corresponding to the target identification information, and determining the table position corresponding to the target identification information as the table position of the ledger data of the target secondary equipment in the equipment ledger data table.
Optionally, if the target identification information identical to the identification information of the target secondary device is not queried, displaying preset error prompt information on a data management page. The preset error prompt information is used for prompting that the standing book data of the target secondary equipment cannot be acquired.
Optionally, according to a table position of the ledger data of the target secondary device in the device ledger data table, obtaining the ledger data of the target secondary device from the device ledger data table includes: determining a target data row corresponding to the ledger data of the target secondary equipment in the equipment ledger data table according to the table position of the ledger data of the target secondary equipment in the equipment ledger data table; and acquiring the ledger data of the target secondary equipment from a target data row corresponding to the ledger data of the target secondary equipment.
Optionally, the providing the ledger data of the target secondary device to the target user includes: and providing the ledger data of the target secondary equipment to the target user through a data management page.
Optionally, the step of providing the ledger data of the target secondary device to the target user through a data management page includes: and displaying the ledger data of the target secondary equipment on a data management page.
According to the technical scheme, the account setting data of each secondary device in the transformer substation can be automatically determined according to the transformer substation configuration description file of the transformer substation, the account setting data of each secondary device can be automatically written into the device account setting data table, the account setting data of the secondary devices in the transformer substation are uniformly stored and managed through the device account setting data table, the working efficiency is high, the accuracy is high, and the account setting data of the appointed secondary device can be quickly acquired based on the table position of the account setting data of the appointed secondary device in the device account setting data table under the condition that a user requests to acquire the account setting data of the appointed secondary device, so that the account setting data of the appointed secondary device is provided for the user.
Example III
Fig. 3 is a schematic structural diagram of a device for processing equipment ledger data according to a third embodiment of the present invention. The apparatus may be configured in an electronic device. As shown in fig. 3, the apparatus includes: a file acquisition module 301, a data determination module 302, and a data writing module 303.
The file obtaining module 301 is configured to obtain a substation configuration description file of a substation to be processed; the data determining module 302 is configured to determine, according to the substation configuration description file, ledger data of at least one secondary device in the substation to be processed; the data writing module 303 is configured to write the ledger data of each secondary device into a device ledger data table.
According to the technical scheme, the transformer substation configuration description file of the transformer substation to be processed is obtained, then the standing book data of at least one secondary device in the transformer substation to be processed is determined according to the transformer substation configuration description file, finally the standing book data of each secondary device are written into the device standing book data table, the problems that the processing scheme of the device standing book data in the related art mainly depends on manpower, time and labor are wasted, the working efficiency is low, the accuracy is difficult to guarantee are solved, the standing book data of each secondary device in the transformer substation can be automatically determined according to the transformer substation configuration description file of the transformer substation, the standing book data of each secondary device can be automatically written into the device standing book data table, and the standing book data of the secondary devices in the transformer substation are uniformly stored and managed through the device standing book data table.
In an optional implementation manner of the embodiment of the present invention, optionally, the ledger data includes basic parameters and technical parameters; the data determining module 302 is specifically configured to: the following operations are executed for each secondary device in the substation to be processed: extracting basic parameters of secondary equipment from the file name of the transformer substation configuration description file; extracting the equipment information of the secondary equipment from an equipment information list in the substation configuration description file; and determining technical parameters of the secondary equipment according to the equipment information of the secondary equipment.
In an optional implementation manner of the embodiment of the present invention, optionally, the data writing module 303 is specifically configured to: the following operations are performed for each secondary device: determining a target data row corresponding to the standing account data of the secondary equipment in blank data rows of the equipment standing account data table; and writing the ledger data of the secondary equipment into the target data row.
In an optional implementation manner of the embodiment of the present invention, optionally, the method further includes: the information storage module is used for correspondingly storing the identification information of each secondary device and the table position of the standing account data of each secondary device in the device standing account data table into a preset database.
In an optional implementation manner of the embodiment of the present invention, optionally, the method further includes: the request acquisition module is used for acquiring a standing book data query request corresponding to the target secondary equipment, which is input by a target user; the position acquisition module is used for acquiring the table position of the standing book data of the target secondary equipment in the equipment standing book data table from the preset database according to the identification information of the target secondary equipment; the data acquisition module is used for acquiring the ledger data of the target secondary equipment from the equipment ledger data table according to the table position of the ledger data of the target secondary equipment in the equipment ledger data table; and the data providing module is used for providing the ledger data of the target secondary equipment for the target user.
In an optional implementation manner of the embodiment of the present invention, optionally, the data providing module is specifically configured to: and providing the ledger data of the target secondary equipment to the target user through a data management page.
In an optional implementation manner of the embodiment of the present invention, optionally, the file obtaining module 301 is specifically configured to: and obtaining a substation configuration description file of the substation to be processed, which is uploaded by the target user.
The specific manner in which the various modules perform the operations in the apparatus of the above embodiments have been described in detail in connection with the embodiments of the method, and will not be described in detail herein.
The processing device for the equipment ledger data can execute the processing method for the equipment ledger data provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of executing the processing method for the equipment ledger data.
Example IV
Fig. 4 is a schematic diagram of an electronic device 10 that may be used to implement the method for processing device ledger data according to an embodiment of the present invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic equipment may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 4, the electronic device 10 includes at least one processor 11, and a memory, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, etc., communicatively connected to the at least one processor 11, in which the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program built into the Random Access Memory (RAM) 13 from the storage unit 18. In the RAM 13, various programs and data required for the operation of the electronic device 10 may also be stored. The processor 11, the ROM 12 and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.
Various components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, etc.; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 11 performs the respective methods and processes described above, for example, the processing method of the equipment ledger data.
In some embodiments, the method of processing device ledger data may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When a computer program is built into the RAM 13 and executed by the processor 11, one or more steps of the above-described processing method of device ledger data may be performed. Alternatively, in other embodiments, processor 11 may be configured to perform the method of processing device ledger data in any other suitable manner (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.
The computer program for implementing the device ledger data processing method of the present invention can be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.
Claims (10)
1. A method for processing equipment ledger data, comprising:
acquiring a substation configuration description file of a substation to be processed;
determining the ledger data of at least one secondary device in the transformer substation to be processed according to the transformer substation configuration description file;
and writing the ledger data of each secondary device into a device ledger data table.
2. The method of claim 1, wherein the ledger data includes base parameters and technical parameters;
The step of determining the ledger data of at least one secondary device in the transformer substation to be processed according to the transformer substation configuration description file comprises the following steps:
the following operations are executed for each secondary device in the substation to be processed:
extracting basic parameters of secondary equipment from the file name of the transformer substation configuration description file;
extracting the equipment information of the secondary equipment from an equipment information list in the substation configuration description file;
and determining technical parameters of the secondary equipment according to the equipment information of the secondary equipment.
3. The method of claim 1, wherein writing the ledger data for each of the secondary devices into a device ledger data table comprises:
the following operations are executed for each secondary device in the substation to be processed:
determining a target data row corresponding to the standing account data of the secondary equipment in blank data rows of the equipment standing account data table;
and writing the ledger data of the secondary equipment into the target data row.
4. The method of claim 1, further comprising, after writing the ledger data for each of the secondary devices to a device ledger data table:
And correspondingly storing the identification information of each secondary device and the table position of the standing account data of each secondary device in the equipment standing account data table into a preset database.
5. The method according to claim 4, further comprising, after storing the identification information of each of the secondary devices, the table location correspondence of the ledger data of each of the secondary devices in the device ledger data table into a preset database:
acquiring a standing book data query request corresponding to target secondary equipment, which is input by a target user;
acquiring the table position of the standing book data of the target secondary equipment in the equipment standing book data table from the preset database according to the identification information of the target secondary equipment;
according to the table position of the standing book data of the target secondary equipment in the equipment standing book data table, acquiring the standing book data of the target secondary equipment from the equipment standing book data table;
and providing the ledger data of the target secondary equipment for the target user.
6. The method of claim 5, wherein providing the ledger data of the target secondary device to the target user comprises:
And providing the ledger data of the target secondary equipment to the target user through a data management page.
7. The method according to claim 1, wherein the obtaining a substation configuration description file of the substation to be processed comprises:
and obtaining a substation configuration description file of the substation to be processed, which is uploaded by the target user.
8. A device for processing equipment ledger data, comprising:
the file acquisition module is used for acquiring a substation configuration description file of the substation to be processed;
the data determining module is used for determining the ledger data of at least one secondary device in the transformer substation to be processed according to the transformer substation configuration description file;
and the data writing module is used for writing the ledger data of each secondary device into the device ledger data table.
9. An electronic device, the electronic device comprising:
at least one processor;
and a memory communicatively coupled to the at least one processor;
wherein the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the method of processing device ledger data of any one of claims 1-7.
10. A computer readable storage medium storing computer instructions for causing a processor to implement the method of processing equipment ledger data of any one of claims 1-7 when executed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310168331.5A CN116150157A (en) | 2023-02-23 | 2023-02-23 | Method, device, equipment and medium for processing equipment account data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310168331.5A CN116150157A (en) | 2023-02-23 | 2023-02-23 | Method, device, equipment and medium for processing equipment account data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116150157A true CN116150157A (en) | 2023-05-23 |
Family
ID=86338865
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310168331.5A Pending CN116150157A (en) | 2023-02-23 | 2023-02-23 | Method, device, equipment and medium for processing equipment account data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116150157A (en) |
-
2023
- 2023-02-23 CN CN202310168331.5A patent/CN116150157A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108563708B (en) | equipment information retrieval method and device and computer equipment | |
| CN111914101B (en) | File association relationship abnormality identification method and device and computer equipment | |
| CN117473384A (en) | Power grid line safety constraint identification method, device, equipment and storage medium | |
| CN112235146A (en) | Automatic association method and device for primary and secondary equipment models of intelligent substation | |
| CN116799953A (en) | Equipment abnormality identification method, device and equipment based on power grid dispatching monitoring | |
| CN116150157A (en) | Method, device, equipment and medium for processing equipment account data | |
| CN115407150A (en) | System, method, meter and medium for determining use condition of protective pressing plate | |
| CN115203281A (en) | Information searching method and device, electronic equipment and storage medium | |
| CN114936612A (en) | Short circuit type identification method and device, electronic equipment and storage medium | |
| CN115051912A (en) | Method, device, equipment and medium for positioning power failure user | |
| CN109241168B (en) | Processing method, device and equipment for technical standard data of power grid and storage medium | |
| CN111143296A (en) | Substation SCD file classification method and device, terminal and storage medium | |
| CN115391376A (en) | Power failure query method and device, electronic equipment and storage medium | |
| CN110929219A (en) | Distribution network equipment group state evaluation method, device and system and computer storage medium | |
| CN117573561B (en) | Automatic test system, method, electronic equipment and storage medium | |
| CN117131353B (en) | Method and device for determining out-of-tolerance electric energy meter, electronic equipment and storage medium | |
| CN117200444A (en) | Main distribution network model splicing method, device, equipment and storage medium | |
| CN115453271A (en) | Power distribution network problem diagnosis method, device, equipment and storage medium | |
| CN117559427A (en) | Power grid fault processing method and device, electronic equipment and storage medium | |
| CN115409381A (en) | Line loss cause determination method and device, electronic equipment and storage medium | |
| CN115392712A (en) | Method, device and equipment for checking operation task and storage medium | |
| CN116820041A (en) | Comparison method, device, equipment and storage medium for controller control logic function | |
| CN117172748A (en) | Operation ticket generation method, device, equipment and medium applied to power grid | |
| CN116933088A (en) | Secondary equipment fault data generation method and device, electronic equipment and medium | |
| CN117368588A (en) | Method, device, equipment and storage medium for determining consistency of voltage phase sequence |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |