Automatic processing system and method for electric power information communication scheduling operation data
The automated data processing system for power information and communication dispatch utilizes robotic process automation (RPA) technology to extract and process data across systems, solving the problems of tedious and error-prone manual operations. This achieves efficient and accurate data processing, meeting the automation and intelligent requirements of power communication dispatch.
Patent Information
- Application Number
- CN202511730836.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-11-24
- Publication Date
- 2026-02-17
AI Technical Summary
In existing power information communication and dispatching systems, manual operation is cumbersome and prone to errors, resulting in low data processing efficiency and poor accuracy, which cannot meet the needs of large-scale real-time processing. Moreover, repetitive operations occupy the core business time of dispatchers.
An automated data processing system for power information communication dispatching is adopted, including a human-computer interaction module, a data capture module, a report processing module, a file management module, and a data verification module. It uses robotic process automation technology to extract data across systems, and the report processing module realizes automated generation and archiving, while the data verification module ensures accuracy.
It achieves efficient, accurate, and cross-system adaptability in data processing, reduces manual operation time, improves data processing efficiency, ensures data integrity and consistency, and meets the automation and intelligent requirements of power communication dispatch.
Smart Images
Figure CN121544012A_ABST
Abstract
Description
TECHNICAL FIELD
[0001] The present application belongs to the field of electrical automation, and particularly relates to a power information communication dispatching operation data automatic processing system and method. BACKGROUND
[0002] With the acceleration of the digitalization process of the power grid, information communication dispatching has become the core support link for the stable operation of the power system. The current information communication dispatching needs to rely on the communication management system (TMS2.0) and the intelligent integrated operation support platform (I60002.0) to carry out work. The two platforms integrate the core functions of real-time monitoring, resource management, defect management, maintenance management and dispatching matter management of communication and information professionals. The daily work order data update quantity shows an explosive growth with the implementation of the digital safety management and control system of the large power grid.
[0003] The existing information communication dispatching data processing mode mainly relies on manual operation, that is, the dispatching personnel need to manually copy the work order number, flow state and other key information between the two business systems every day, update the offline monthly report (hereinafter referred to as "monthly report") one by one, and then select the unfinished matters and the newly added matters on the same day to arrange into the daily report (hereinafter referred to as "daily report") and report to each department of the company. At the end of the month, additional time needs to be invested to archive the completed work orders. According to statistics, such repetitive operation takes 2-3 hours per day, and takes about 1 hour at the end of the month. There are obvious defects. First, the manual cross-system operation process is complicated, especially when the work order quantity increases sharply during the maintenance peak period, the processing time is further prolonged, and it is impossible to quickly respond to the data reporting demand. Second, manual copying and screening of data are prone to errors due to operation errors, the accuracy is affected by the subjective state and operation proficiency of the personnel, and it is difficult to meet the accuracy requirements of dispatching data. Third, a large amount of energy of the grassroots dispatching personnel is occupied by repetitive operations, which occupies the time of core businesses such as fault diagnosis and dispatching strategy optimization, which is contrary to the demand of "quality improvement and burden reduction" of the digital power grid. Fourth, it is not suitable for a large number of scenes. When the daily work order quantity exceeds 300, the manual processing efficiency decreases exponentially, and it is completely impossible to meet the real-time processing demand of large-scale information communication dispatching data. SUMMARY
[0004] In view of the deficiencies of the prior art, one of the purposes of the present application is to provide a power information communication dispatching operation data automatic processing system to achieve high efficiency, high accuracy and adapt to cross-system scenarios.
[0005] The second purpose of the present application is to provide a method for using the power information communication dispatching operation data automatic processing system.
[0006] The application provides a power information communication dispatch operation data automatic processing system, which comprises a man-machine interaction module, a data grabbing module, a report processing module, a file management module and a data verification module; the man-machine interaction module is used for realizing data interaction between the system and an operator, uploading data input by the operator to the data grabbing module; the data grabbing module is used for automatically extracting work order data across the Xintong dispatch core business system and uploading the data to the report processing module and the data verification module; the report processing module is used for realizing monthly report updating, daily report generation and monthly data archiving and uploading the data to the file management module and the data verification module; the file management module is used for managing template files, result files and log files related to the system; and the data verification module is used for verifying the accuracy of data processing results.
[0007] The man-machine interaction module is used for providing a visual operation interface, printing prompt information of the operator, obtaining configuration parameters (such as data acquisition time range, report storage path and data processing trigger time) input by the operator and displaying system operation parameters, so as to support manual intervention of the operator in an abnormal situation.
[0008] The data grabbing module realizes cross-system data extraction based on the robot process automation (RPA) technology, and the core functions include automatically logging in the Xintong dispatch core business system through preset account and password, automatically grabbing work order data in the system according to time parameters set by the man-machine interaction module, extracting core fields of the data work order, uniformly formatting the fields into a preset standard, and temporarily storing the standardized work order data in a temporary data table to provide a stable data source for the report processing module.
[0009] The report processing module is used for realizing report processing, wherein a monthly report updating submodule reads work order data from the temporary data table, automatically writes the data into a to-be-updated monthly report file, completes table format unification and work order sorting; a daily report generation submodule is triggered at 8:30 in the morning, filters work orders added on the current day and not completed from monthly report data, and automatically generates a daily report in a submission format; and a monthly end archiving submodule is triggered at the end of the month, automatically identifies completed work orders in the monthly report, migrates the work orders to an annual archiving Excel file, simultaneously empties the archived data in the monthly report, and keeps the monthly report file lightweight.
[0010] The file management module is used for managing various files in the system running process, standardizing standard Excel templates of monthly reports and daily reports, naming a new report file generated each day according to a date mark, saving a path preset by the operator, saving system operation log records, and facilitating subsequent tracing and operation and maintenance.
[0011] The data verification module is used to verify the accuracy of the data processing results. First, it performs a data integrity comparison, comparing the number of work orders extracted by the data capture module with the original number of work orders in the business system to ensure no omissions or over-captures. Second, it performs a consistency verification, comparing the automatically generated reports with the manually processed results (in the pilot phase) at the field level to determine the data accuracy. Third, it provides anomaly alarms. If the verification finds problems such as missing data or field mismatches, an alarm prompt will pop up through the human-computer interaction module, pausing the subsequent processing flow until the operator verifies and repairs the issues before restarting.
[0012] The present invention also provides a method for using the power information communication dispatching and operation data automation processing system, comprising the following steps:
[0013] S1. Through the human-computer interaction module, the system collects the time parameters, baseline files, data processing task types, and triggering methods input by the operator. Based on different triggering commands, the system enters the corresponding processing flow: triggering "monthly report update" proceeds to step S2, triggering "daily report generation" proceeds to step S5, and triggering "monthly report archiving" proceeds to step S6.
[0014] S2. Through the file management module, the baseline file is copied and standardized with the current date or timestamp as the identifier to generate the corresponding version of the monthly report file, so as to realize the traceability and unified management of document versions;
[0015] S3. Through the data capture module, access the two core business systems, TMS2.0 and I60002.0, filter target work orders according to the time parameters in step S1, automatically perform field extraction and format standardization, and store the results in a temporary data table;
[0016] S4. Through the report processing module - monthly report update submodule, obtain work order data from the temporary data table, and realize dynamic comparison and writing with the monthly report file, then continue to step S7;
[0017] S5. Using the report processing module - daily report generation submodule, automatically filter "newly added" work orders and "unfinished" work orders based on the baseline file to generate a structured daily report file, and continue to step S7;
[0018] S6. Through the report processing module - month-end archiving submodule, extract the completed work orders from the base file in S1, migrate them to the annual archive Excel file, and clear the archived data in the monthly report to keep the monthly report file lightweight;
[0019] S7. The data verification module performs integrity, consistency and redundancy checks on the updated files and supports anomaly alarms (such as missing fields, duplicate work orders, time conflicts).
[0020] S8. Through the file management module, newly generated reports are output to the path specified by the operator, and a complete system operation log is recorded.
[0021] Step S4 specifically includes the following steps:
[0022] A. Extract the work order number set Set1 from the temporary data table, and extract the work order number set Set2 from the monthly report file;
[0023] B. Perform set operations on Set1 and Set2, specifically including: obtaining the intersection Set1∩Set2, updating the data fields of the corresponding work order and writing them to the target row in the monthly report file; obtaining the difference Set1-Set2, writing the corresponding work order as a new work order to the end of the monthly report file; obtaining the difference Set2-Set1, marking the corresponding work order as a historical legacy or abnormal work order, triggering a prompt message or migrating it to the abnormal record table;
[0024] C. Repeat steps A to B until all types of work orders in the temporary data table have been updated and written.
[0025] D. After completing the above differential operations, a differential log file is generated to record the number of new work orders, the number of updated work orders, and the number of legacy work orders, so as to achieve traceability and statistical analysis of data changes.
[0026] This invention discloses an automated processing system and method for power information and communication dispatching operation data. Relying on an innovatively designed automated data capture, differential update, and report generation mechanism, it can not only achieve efficient and accurate processing of information and communication service operation data, but also enhance operational traceability, improve data integrity and consistency, and significantly improve processing efficiency, thus meeting the comprehensive needs of power communication dispatching services for automation, intelligence, and precision. Attached Figure Description
[0027] Figure 1 This is a schematic diagram of the functional modules of the system of the present invention.
[0028] Figure 2 This is a schematic diagram of the method flow of the present invention. Detailed Implementation
[0029] like Figure 1The diagram shows the functional modules of the system of this invention: The automated data processing system for power information communication dispatching and operation disclosed in this invention includes a human-computer interaction module, a data capture module, a report processing module, a file management module, and a data verification module; the human-computer interaction module is used to realize data interaction between the system and operators; the data capture module is used to automatically extract work order data from the cross-communication dispatching core business system; the report processing module is used to realize monthly report updates, daily report generation, and month-end data archiving; the file management module is used to manage the template files, result files, and log files involved in the system; and the data verification module is used to verify the accuracy of the data processing results.
[0030] The human-computer interaction module is used to provide a visual operation interface, print prompts for operators (such as "Please configure business system login information" and "Data capture completed, start generating reports"), obtain configuration parameters input by operators (such as data acquisition time range, report storage path, and data processing trigger time), and display system operation parameters (such as the number of work orders processed, time consumed, and success rate), and support operators to manually intervene in case of abnormalities.
[0031] The data capture module, based on Robotic Process Automation (RPA) technology, enables cross-system data extraction. Its core functions include: automatically logging into the core business system of information and communication scheduling using a preset account and password; automatically capturing work order data within the system according to the time parameters set by the human-computer interaction module; extracting core fields of the work orders (work order number, business type, flow status, creation time, and completion time), and standardizing the field format to a preset standard; and temporarily storing the standardized work order data in a temporary data table to provide a stable data source for the report processing module.
[0032] The report processing module is implemented using Excel macro (VBA) programming. The monthly report update submodule reads work order data from a temporary data table and automatically writes it to the monthly report file to be updated (including worksheets such as "Scheduling Items Summary," "Maintenance Task Statistics," and "Fault Handling Records"), ensuring consistent table formatting and work order sorting. The daily report generation submodule is triggered at 8:30 AM, automatically generating a daily report conforming to the reporting format from the monthly report data based on newly added and incomplete work orders selected that day. The end-of-month archiving submodule is triggered at the end of the month, automatically identifying completed work orders in the monthly report, migrating them to an annual archive Excel file, and simultaneously clearing archived data from the monthly report to maintain a lightweight monthly report file.
[0033] The file management module is used to manage various files during system operation, standardize monthly and daily report Excel templates, generate new report files daily using date markers as rules, and save the files to a path preset by the operator. It also saves system operation logs for easy traceability and maintenance.
[0034] The data verification module is used to verify the accuracy of the data processing results. First, it performs a data integrity comparison, comparing the number of work orders extracted by the data capture module with the original number of work orders in the business system to ensure no omissions or over-captures. Second, it performs a consistency verification, comparing the automatically generated reports with the manually processed results (in the pilot phase) at the field level to determine the data accuracy. Third, it provides anomaly alarms. If the verification finds problems such as missing data or field mismatches, an alarm prompt will pop up through the human-computer interaction module, pausing the subsequent processing flow until the operator verifies and repairs the issues before restarting.
[0035] like Figure 2 The diagram shown is a flowchart of the method of the present invention: The method disclosed in this invention, which uses the power information communication dispatching and operation data automation processing system, includes the following steps:
[0036] S1. Through the human-computer interaction module, the system collects the time parameters, baseline files (such as the previously generated monthly report file), data processing task type, and triggering method input by the operator. Based on different triggering instructions, the system enters the corresponding processing flow: triggering "monthly report update" proceeds to step S2, triggering "daily report generation" proceeds to step S5, and triggering "monthly report archiving" proceeds to step S6.
[0037] S2. Through the file management module, the baseline file is copied and standardized with the current date or timestamp as the identifier to generate the corresponding version of the monthly report file, so as to realize the traceability and unified management of document versions;
[0038] S3. Through the data capture module, connect to the two core business systems, TMS2.0 and I60002.0. Filter target work orders based on the time parameters from step S1, automatically perform field extraction and format standardization, and store the results in a temporary data table.
[0039] S4. Through the report processing module - monthly report update submodule, retrieve work order data from the temporary data table, and dynamically compare and write it with the monthly report file. The specific steps include the following:
[0040] A. Extract the work order number set Set1 from the temporary data table, and extract the work order number set Set2 from the monthly report file;
[0041] B. Perform set operations on Set1 and Set2, specifically including: obtaining the intersection Set1∩Set2, updating the data fields of the corresponding work order and writing them to the target row in the monthly report file; obtaining the difference Set1-Set2, writing the corresponding work order as a new work order to the end of the monthly report file; obtaining the difference Set2-Set1, marking the corresponding work order as a historical legacy or abnormal work order, triggering a prompt message or migrating it to the abnormal record table;
[0042] C. Repeat steps A to B until all types of work orders in the temporary data table have been updated and written.
[0043] D. After completing the above differential operation, generate a differential log file to record the number of new work orders, the number of updated work orders, and the number of legacy work orders, so as to achieve traceability and statistical analysis of data changes, and continue to step S7.
[0044] S5. Using the report processing module - daily report generation submodule, automatically filter "newly added" work orders and "unfinished" work orders based on the baseline file to generate a structured daily report file, and continue to step S7;
[0045] S6. Through the report processing module - month-end archiving submodule, extract the completed work orders from the base file in S1, migrate them to the annual archive Excel file, and clear the archived data in the monthly report to keep the monthly report file lightweight;
[0046] S7. The data verification module performs integrity, consistency and redundancy checks on the updated files and supports anomaly alarms (such as missing fields, duplicate work orders, time conflicts).
[0047] S8. Through the file management module, newly generated reports are output to the path specified by the operator, and a complete system operation log is recorded.
Claims
1. A power information communication dispatch operation data automation processing system, characterized by, The system comprises a man-machine interaction module, a data extraction module, a report processing module, a file management module and a data verification module; the man-machine interaction module is used for realizing data interaction between the system and an operator, uploading data input by the operator to the data extraction module; The data extraction module is used for automatically extracting work order data across the Xintong dispatching core business system and uploading the data to the report processing module and the data verification module; the report processing module is used for realizing monthly report updating, daily report generation and monthly data archiving and uploading the data to the file management module and the data verification module; The file management module is used for managing template files, result files and log files related to the system; The data verification module is used for verifying the accuracy of data processing results.
2. The electric power information communication dispatch operation data automation processing system, as claimed in claim 1, wherein, The man-machine interaction module is used for providing a visual operation interface, printing prompt information of the operator, obtaining configuration parameters input by the operator and displaying system operation parameters, and supports manual intervention by the operator in an abnormal situation; the configuration parameters include data acquisition time range, report storage path and data processing trigger time.
3. The electric power information communication dispatch operation data automation processing system, as claimed in claim 1, wherein, The data extraction module realizes cross-system data extraction based on robot process automation technology, and the core functions include automatically logging in the Xintong dispatching core business system through a preset account and password, automatically extracting work order data in the system according to time parameters set by the man-machine interaction module, extracting core fields of the data work order, uniformly formatting the fields into a preset standard, and temporarily storing the standardized work order data in a temporary data table to provide a stable data source for the report processing module.
4. The electric power information communication dispatch operation data automation processing system, as claimed in claim 1, wherein, The report processing module comprises a monthly report updating submodule, a daily report generation submodule and a monthly archiving submodule, and is used for realizing report processing; the monthly report updating submodule reads work order data from the temporary data table, automatically writes the data into a monthly report file to be updated, and completes table format unification and work order sorting; the daily report generation submodule is triggered at 8:30 in the morning, extracts work orders added on the current day and not completed from the monthly report data, and automatically generates a daily report in a submission format; the monthly archiving submodule is triggered at the end of the month, automatically identifies the completed work orders in the monthly report, migrates the work orders to an annual archiving Excel file, empties the archived data in the monthly report, and keeps the monthly report file lightweight.
5. The electric power information communication dispatch operation data automation processing system, as claimed in claim 1, wherein, The file management module is used for managing various files in the system running process, and standardizing standard Excel templates of monthly reports and daily reports; a new report file is generated every day according to a date mark as a rule, and a saving path is preset by the operator; system operation log records are saved, facilitating subsequent tracing and operation and maintenance.
6. The electric power information communication dispatch operation data automation processing system, as set forth in claim 1, wherein, The data verification module is used for verifying the accuracy of data processing results, specifically: Comparing data integrity, comparing the number of work orders extracted by the data extraction module with the original number of work orders in the business system; Performing consistency verification, comparing the automatically generated report with the manual processing result at the field level to determine the data accuracy; Performing abnormal alarm, if the verification finds that the data is missing or the fields do not match, an alarm prompt is popped up through the man-machine interaction module, the subsequent processing process is paused, and the system is re-run after the operator checks and repairs.
7. A method for use in the power information communication dispatch operation data automation processing system according to any one of claims 1 to 6, characterized by, The method comprises the following steps: S1. Collect the time parameter, reference file, data processing task type and trigger mode input by the operator through the human-computer interaction module; The system enters the corresponding processing flow according to different trigger instructions: trigger "monthly report update" to enter step S2, trigger "daily report generation" to enter step S5, and trigger "monthly report archiving" to enter step S6; S2. Through the file management module, the reference file is copied, and the current date or timestamp is used as an identifier for standardized naming to generate the corresponding version of the monthly report file, realizing traceability and unified management of document versions; S3. Through the data extraction module, access to the two core business systems TMS2.0 and I60002.0, filter target work orders according to the time parameter of step S1, automatically perform field extraction and format standardization, and store the results in a temporary data table; S4. Through the report processing module-monthly report update submodule, obtain work order data from the temporary data table, and realize dynamic comparison and writing with the monthly report file, continue step S7; S5. Through the report processing module-daily report generation submodule, automatically filter "newly added" work orders and "uncompleted" work orders based on the reference file to generate structured daily report files, and continue step S7; S6. Through the report processing module-month-end archiving submodule, extract completed work orders in the monthly report from the reference file in S1, migrate them to the annual archiving Excel file, and at the same time, empty the archived data in the monthly report to keep the monthly report file lightweight; S7. Through the data verification module, check the integrity, consistency and redundancy of the updated file, and support abnormal alarm; abnormal alarm includes field missing, work order duplication, and time conflict; S8. Through the file management module, output the newly generated report to the path specified by the operator, and record the complete system operation log.
8. The method of claim 7, wherein, The step S4 specifically comprises the following steps: A. Extract the work order number set Set1 from the temporary data table, and extract the work order number set Set2 from the monthly report file; B. Perform set operation on Set1 and Set2, specifically: obtain the intersection Set1∩Set2, update the data field of the corresponding work order and write it to the target row in the monthly report file; obtain the difference Set1-Set2, write the corresponding work order as a new work order to the end of the monthly report file; Obtain the difference Set2-Set1, mark the corresponding work order as a historical legacy or abnormal work order, trigger a prompt message or migrate to the abnormal record table; C. Repeat steps A~B until all types of work orders in the temporary data table are updated and written; D. After completing the above difference operation, generate a difference log file to record the number of new work orders, the number of updated work orders and the number of legacy work orders, so as to realize traceability and statistical analysis of data changes.