CN112651701A - Automatic processing method for D5000 system data - Google Patents
Automatic processing method for D5000 system data Download PDFInfo
- Publication number
- CN112651701A CN112651701A CN202011127049.5A CN202011127049A CN112651701A CN 112651701 A CN112651701 A CN 112651701A CN 202011127049 A CN202011127049 A CN 202011127049A CN 112651701 A CN112651701 A CN 112651701A
- Authority
- CN
- China
- Prior art keywords
- data
- automatically
- processing method
- statistical analysis
- selecting
- 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
Images
Classifications
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- 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/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Human Resources & Organizations (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Entrepreneurship & Innovation (AREA)
- Probability & Statistics with Applications (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- Software Systems (AREA)
- Fuzzy Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Mathematical Physics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- General Factory Administration (AREA)
Abstract
The invention relates to a D5000 system data automatic processing method, which comprises the following steps: respectively and automatically calling systems corresponding to the application scenes according to different application scenes, and inputting an account password for login by an operator; an operator selects a set parameter to be inquired, and then required data is automatically extracted from an original data source of the system according to the set parameter; collecting the extracted data into an excel table to be stored for later use; and setting parameters by an operator aiming at the data in the excel table, automatically screening and counting the data, and outputting and storing the data. Through the whole flow realization automation mechanized operation with data extraction, the operating personnel manual operation that has significantly reduced has not only effectively improved operating efficiency, is difficult for moreover makeing mistakes, has improved the accuracy of operation.
Description
Technical Field
The invention relates to the technical field of power supply data processing, in particular to a D5000 system data automatic processing method.
Background
Due to the fact that functions of the D5000 system are imperfect at present, data formats need to be adjusted and counted manually when dispatchers of North Power supply companies in Chongqing of China and network conduct statistics of alarm data, power utilization period inspection data and standing book maintenance data, due to the fact that data volumes are huge, the traditional mode is mainly clicking query in time periods of mechanical and repetitive clicking operation, queried data are exported into excel forms, and finally manual screening and statistics are conducted by operators.
Due to the fact that the data size is large, the work task of an operator is heavy, manual operation is prone to making mistakes, and accuracy of data statistics is affected.
Disclosure of Invention
The invention aims to provide a D5000 system data automatic processing method to solve the defects in the prior art.
The technical scheme for solving the technical problems is as follows:
a D5000 system data automatic processing method comprises the following steps:
s1, respectively and automatically calling systems corresponding to the application scenes according to different application scenes, and inputting an account password for login by an operator;
s2, the operator selects the setting parameter to be inquired, and then automatically extracts the needed data from the original data source of the system according to the setting parameter;
s3, summarizing the extracted data into an excel table for storage and standby;
and S4, setting parameters by an operator according to the data in the excel table, automatically screening and counting the data, and outputting and storing the data.
Specifically, in step S1, the application scenarios are divided into three categories, that is, statistical analysis is performed on the telecommand displacement alarm data; secondly, carrying out statistical analysis on the power utilization period inspection data; thirdly, performing statistical analysis on the changed equipment standing book maintenance data;
furthermore, when the remote signaling displacement alarm data is subjected to statistical analysis, the method mainly comprises the following steps of opening a web page of the system and inputting an account number and a password to log in the system; selecting the alarm type as remote signaling deflection; selecting a time period to be queried and clicking for query; exporting into an excel table; automatically performing screening statistics and outputting results for storage;
furthermore, when the electricity cycle inspection data is subjected to statistical analysis, the method mainly comprises the following steps of opening an SG186 system, and inputting an account number and a password to log in the system; selecting power utilization inspection management; selecting a time period to be queried and clicking for query; according to the number of the inquired plan numbers, clicking one by one to inquire the detail of the next-level sub-items; copying all contents in each plan number sub item to excel for gathering; checking the summarized content;
furthermore, when statistical analysis is carried out on the changed equipment standing book maintenance data, the method mainly comprises the following steps of opening the PMS and inputting an account password to log in the system; selecting a task needing standing book maintenance in a flow to be handled; automatically modifying one by one according to the type of the equipment;
more specifically, when data is automatically extracted, the data is automatically acquired by adopting a button, and the time scheduling management of the data acquisition is carried out by using an Azkaban tool;
the invention has the beneficial effects that: through the whole flow realization automation mechanized operation with data extraction, the operating personnel manual operation that has significantly reduced has not only effectively improved operating efficiency, is difficult for moreover makeing mistakes, has improved the accuracy of operation.
Drawings
FIG. 1 is a schematic view of a data processing flow according to the present invention;
Detailed Description
The principles and features of this invention are described below in conjunction with the following drawings, which are set forth by way of illustration only and are not intended to limit the scope of the invention.
As shown in fig. 1, an automated processing method for D5000 system data includes the following steps:
s1, respectively and automatically calling systems corresponding to the application scenes according to different application scenes, and inputting an account password for login by an operator;
s2, the operator selects the setting parameter to be inquired, and then automatically extracts the needed data from the original data source of the system according to the setting parameter;
s3, summarizing the extracted data into an excel table for storage and standby;
and S4, setting parameters by an operator according to the data in the excel table, automatically screening and counting the data, and outputting and storing the data.
Specifically, in step S1, the application scenarios are divided into three categories, that is, statistical analysis is performed on the telecommand displacement alarm data; secondly, carrying out statistical analysis on the power utilization period inspection data; thirdly, performing statistical analysis on the changed equipment standing book maintenance data;
furthermore, when the remote signaling displacement alarm data is subjected to statistical analysis, the method mainly comprises the following steps of opening a web page of the system and inputting an account number and a password to log in the system; selecting the alarm type as remote signaling deflection; selecting a time period to be queried and clicking for query; exporting into an excel table; automatically performing screening statistics and outputting results for storage;
furthermore, when the electricity cycle inspection data is subjected to statistical analysis, the method mainly comprises the following steps of opening an SG186 system, and inputting an account number and a password to log in the system; selecting power utilization inspection management; selecting a time period to be queried and clicking for query; according to the number of the inquired plan numbers, clicking one by one to inquire the detail of the next-level sub-items; copying all contents in each plan number sub item to excel for gathering; checking the summarized content;
furthermore, when statistical analysis is carried out on the changed equipment standing book maintenance data, the method mainly comprises the following steps of opening the PMS and inputting an account password to log in the system; selecting a task needing standing book maintenance in a flow to be handled; automatically modifying one by one according to the type of the equipment;
repeated mechanical clicking operation is carried out by original artifical login system, changes into only needing the manual work to maintain the template according to PMS system equipment machine account, maintains equipment machine account information on local office computer after, uploads to flow automation platform, and the operation is operated by automatic operation robot completely thereafter, realizes the automatic of PMS system equipment machine account and types in, alleviates staff's work burden, promotes work efficiency.
More specifically, when data is automatically extracted, the data is automatically acquired by adopting a button, and the time scheduling management of the data acquisition is carried out by using an Azkaban tool;
the above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (6)
1. A D5000 system data automatic processing method is characterized in that: the method comprises the following steps:
s1, respectively and automatically calling systems corresponding to the application scenes according to different application scenes, and inputting an account password for login by an operator;
s2, the operator selects the setting parameter to be inquired, and then automatically extracts the needed data from the original data source of the system according to the setting parameter;
s3, summarizing the extracted data into an excel table for storage and standby;
and S4, setting parameters by an operator according to the data in the excel table, automatically screening and counting the data, and outputting and storing the data.
2. The automated D5000 system data processing method according to claim 1, characterized in that: in the step S1, the application scenarios are classified into three categories, that is, statistical analysis is performed on the remote signaling displacement alarm data; secondly, carrying out statistical analysis on the power utilization period inspection data; and thirdly, performing statistical analysis on the changed equipment standing book maintenance data.
3. The automated D5000 system data processing method according to claim 2, characterized in that: when the remote signaling deflection alarm data is subjected to statistical analysis, the method mainly comprises the following steps of opening a web page of the system and inputting an account number and a password to log in the system; selecting the alarm type as remote signaling deflection; selecting a time period to be queried and clicking for query; exporting into an excel table; and automatically performing screening statistics and outputting results for storage.
4. The automated D5000 system data processing method according to claim 2, characterized in that: when the electricity cycle inspection data are subjected to statistical analysis, the method mainly comprises the following steps of opening an SG186 system, and inputting an account number and a password to log in the system; selecting power utilization inspection management; selecting a time period to be queried and clicking for query; according to the number of the inquired plan numbers, clicking one by one to inquire the detail of the next-level sub-items; copying all contents in each plan number sub item to excel for gathering; the aggregated content is checked.
5. The automated D5000 system data processing method according to claim 2, characterized in that: when the statistical analysis is carried out on the changed equipment ledger maintenance data, the method mainly comprises the following steps of opening the PMS and inputting an account password to log in the system; selecting a task needing standing book maintenance in a flow to be handled; and automatically modifying the equipment items by items according to the equipment types.
6. The automated D5000 system data processing method according to any one of claims 3 to 5, characterized in that: when the data is automatically extracted, the data is automatically collected by adopting a button, and the time scheduling management of the data collection is carried out by using an Azkaban tool.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011127049.5A CN112651701A (en) | 2020-10-20 | 2020-10-20 | Automatic processing method for D5000 system data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011127049.5A CN112651701A (en) | 2020-10-20 | 2020-10-20 | Automatic processing method for D5000 system data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112651701A true CN112651701A (en) | 2021-04-13 |
Family
ID=75347052
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011127049.5A Pending CN112651701A (en) | 2020-10-20 | 2020-10-20 | Automatic processing method for D5000 system data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112651701A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107133338A (en) * | 2017-05-16 | 2017-09-05 | 廊坊市新思维科技有限公司 | Non-destructive Testing Data auditing system |
| CN109508331A (en) * | 2018-09-26 | 2019-03-22 | 国家电网有限公司 | Power grid financial data processing method and system |
| CN111666741A (en) * | 2020-05-22 | 2020-09-15 | 深圳供电局有限公司 | Automatic generation method of scheduling comprehensive report |
| CN111708814A (en) * | 2020-04-27 | 2020-09-25 | 广东电网有限责任公司东莞供电局 | Data statistical method, device, equipment and medium |
-
2020
- 2020-10-20 CN CN202011127049.5A patent/CN112651701A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107133338A (en) * | 2017-05-16 | 2017-09-05 | 廊坊市新思维科技有限公司 | Non-destructive Testing Data auditing system |
| CN109508331A (en) * | 2018-09-26 | 2019-03-22 | 国家电网有限公司 | Power grid financial data processing method and system |
| CN111708814A (en) * | 2020-04-27 | 2020-09-25 | 广东电网有限责任公司东莞供电局 | Data statistical method, device, equipment and medium |
| CN111666741A (en) * | 2020-05-22 | 2020-09-15 | 深圳供电局有限公司 | Automatic generation method of scheduling comprehensive report |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110674189B (en) | Method for monitoring secondary state and positioning fault of intelligent substation | |
| CN104680612A (en) | Automatic IT equipment inspection method | |
| CN107862392B (en) | Equipment account management and control method based on power distribution network intelligent operation and maintenance management and control platform | |
| CN110688389B (en) | Cloud management system for defects of secondary equipment of transformer substation | |
| CN106815373A (en) | Big data methods of exhibiting and system are rushed to repair in distribution based on BI analyses | |
| CN107908994A (en) | Wood-based product's processing progress tracking and clout information management system based on cloud platform | |
| CN102880882B (en) | Equipment-patrolling managing device based on Quick Response Code | |
| CN111507635A (en) | Power transformation operation and inspection intelligent mobile operation system and method based on power internet of things | |
| CN202854576U (en) | Automobile production line data management system | |
| CN113781257A (en) | Method and system for classified storage of fault data of wind turbine generator | |
| CN111984656B (en) | Method and system for checking basic data key parameters of intelligent substation automation equipment | |
| CN113506098A (en) | Power plant metadata management system and method based on multi-source data | |
| CN112862242A (en) | A production overall process acceptance tool for transformer substation capital construction engineering | |
| CN111080040A (en) | Key process quality management and tracing system | |
| CN112651701A (en) | Automatic processing method for D5000 system data | |
| CN109165753B (en) | Transformer substation defect management method based on mobile platform | |
| CN202282008U (en) | Two-dimensional-code-based equipment-patrolling managing device | |
| CN110738427A (en) | electric power part work quality scoring system | |
| CN110298585B (en) | Hierarchical automatic auditing method for monitoring information of substation equipment | |
| CN114003774A (en) | A big data information collection system of electric power for wisdom city | |
| CN111200315B (en) | Transformer substation monitoring background fault diagnosis system and method | |
| CN112541833A (en) | Power system telemechanical data quality management method and system based on feature matching knowledge base | |
| CN111429154A (en) | Traceable system for cable product production and inspection procedures | |
| CN113886469B (en) | Multi-source data-based automatic mining method and system for power distribution network engineering effect abnormity | |
| CN108376274A (en) | A kind of measuring asset management system and method based on mobile operation |
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 |