Automatic data filling method and device for new energy power production management system

Abstract

An automatic data filling method, apparatus and device for a new energy power production management system, and a computer readable storage medium, the method comprising: executing process initialization, the process initialization being used for configuring a process execution environment; the method comprises the following steps: acquiring source data to be reported, and processing and summarizing the source data to obtain data to be reported, the data to be reported comprising electric quantity data of a new energy station; starting robot process automation software, and executing data reporting operation in the new energy power production management system according to the to-be-reported data; in the data reporting operation process, exception handling and exception notification are carried out, the technical problems that in the related technology, only manual data collection and Excel table data importing and exporting can be adopted, work is tedious, efficiency is low, errors are prone to occurring in the collection and carrying process, and correctness cannot be guaranteed are solved, automatic filling and reporting of the electric quantity data are achieved, and the user experience is improved. And the working efficiency and the accuracy are improved.

Description

Technical Field

[0001] This application relates to the field of data processing, specifically to a method, apparatus, equipment, and computer-readable storage medium for automatic data entry in a new energy power production management system. Background Technology

[0002] The New Energy Company's centralized control center needs to manually acquire, transport, process, and summarize data in different systems to complete the data reporting requirements of different platforms and time periods. All of these tasks are highly standardized, have clear rules, involve large amounts of statistical data, and have high daily repetition. At the same time, the processing time and cycle of these tasks are relatively fixed. The operation center's special tasks require a large amount of manpower to complete, including power production data entry, centralized control data monitoring and forecasting, daily, weekly, and monthly data reporting to the OPS system, power forecast data reporting, output of regular tables and monthly reports, data capture and processing of the "two detailed rules", report submission, and supervision of the production management system.

[0003] Currently, because the systems are developed by different software vendors, there are multiple databases and the data interfaces cannot be communicated with each other. The only way to collect data is to manually collect data and import and export data in Excel spreadsheets. This is tedious, inefficient, and prone to errors during the collection and transfer process, and the accuracy cannot be guaranteed. Summary of the Invention

[0004] This application provides a method, device, equipment, and computer-readable storage medium for automatic data entry in a new energy power production management system. It can solve the technical problems existing in the prior art, which can only rely on manual data collection and import / export of data from Excel spreadsheets. This is cumbersome, inefficient, and prone to errors during data collection and transfer, making it impossible to guarantee accuracy.

[0005] In a first aspect, embodiments of this application provide a method for automatically filling in data in a new energy power production management system, including: Execution process initialization, which is used to configure the process execution environment; The source data to be reported is obtained, and the source data is processed and summarized to obtain the data to be reported, which includes the power generation data of the new energy power station. Start the robotic process automation software and, based on the data to be reported, perform a data reporting operation in the new energy power production management system. During the data reporting process, exception handling and exception notification are performed.

[0006] In conjunction with the first aspect, in one implementation, the execution flow initialization includes: Close all WPS spreadsheet files; Assign values ​​to global variables; Determine if a month folder and a day folder with a specified structure exist; Determine whether the source data needs to be scraped.

[0007] In conjunction with the first aspect, in one implementation, the step of acquiring the source data to be reported and processing and summarizing the source data includes: Retrieve source data records for a specified date from the source data table; The source data records are processed according to the reporting requirements of the new energy power production management system. The processed data is summarized into the daily data to be reported record table; Additionally, a pop-up window reminds the user to check the summarized data.

[0008] In conjunction with the first aspect, in one implementation, after the robotic process automation software is launched, the method further includes: Start the robotic process automation software and access the new energy power production management system in a browser; In addition, the robotic process automation software is started to automatically log in to the new energy power production management system. The automatic login includes automatically recognizing the verification code. If the recognition is incorrect, it will automatically retry until successful.

[0009] In conjunction with the first aspect, in one implementation, after the robotic process automation software is launched, the method further includes: The robotic process automation software is launched and automatically redirects to the preset business data reporting page; Input preset query conditions, which include data collection name, power plant name, and unreported status; Also, click the query button and then click the report link in the query results.

[0010] In conjunction with the first aspect, in one embodiment, the step of performing the data reporting operation in the new energy power production management system further includes: Start the robotic process automation software and automatically fill in the data to be reported on the opened reporting page; Click the save button; In addition, based on the reported results, the reporting status is marked in the daily pending data record table.

[0011] In conjunction with the first aspect, in one implementation, the exception handling and exception notification include: When an exception occurs during process execution, the exception information is recorded; Close all WPS spreadsheet files; Retry within the maximum number of retries; If the number of retries exceeds the maximum number of attempts, the process will be terminated and the exception information will be recorded.

[0012] Secondly, embodiments of this application provide an automatic data entry device for a new energy power production management system, the automatic data entry device for the new energy power production management system comprising: An initialization module is used to perform process initialization, which is used to configure the process execution environment. The acquisition module is used to acquire the source data to be reported, process and summarize the source data to obtain the data to be reported, including the power generation data of the new energy power station. The reporting module is used to perform data reporting operations in the new energy power production management system based on the data to be reported using robotic process automation software. An exception handling and notification module is used to handle exceptions and provide exception notifications during the data reporting operation.

[0013] Thirdly, this application provides an automatic data filling device for a new energy power production management system. The automatic data filling device for the new energy power production management system includes a processor, a memory, and an automatic data filling program for the new energy power production management system stored in the memory and executable by the processor. When the automatic data filling program for the new energy power production management system is executed by the processor, it implements the steps of the automatic data filling method for the new energy power production management system as described above.

[0014] Fourthly, embodiments of this application provide a computer-readable storage medium storing an automatic data filling program for a new energy power production management system. When the automatic data filling program for the new energy power production management system is executed by a processor, it implements the steps of the automatic data filling method for the new energy power production management system as described above.

[0015] The beneficial effects of the technical solutions provided in this application include: The process initialization is used to configure the process execution environment; the source data to be reported is obtained, processed and summarized to obtain the data to be reported, which includes the power generation data of new energy power plants; the robotic process automation software is started, and the data reporting operation is performed in the new energy power production management system according to the data to be reported; during the data reporting operation, anomaly handling and anomaly notification are performed. This solves the technical problems in related technologies that can only manually collect data and import and export data from Excel spreadsheets, which is cumbersome, inefficient, and prone to errors during collection and transportation, and whose accuracy cannot be guaranteed. It realizes the automatic filling of power generation data and improves work efficiency and accuracy. Attached Figure Description

[0016] Figure 1 This is a flowchart illustrating the first embodiment of the automatic data entry method for the new energy power production management system of this application; Figure 2 This is a schematic diagram of the functional modules of an embodiment of the automatic data filling device for the new energy power production management system of this application; Figure 3 This is a schematic diagram of the hardware structure of the automatic data filling device for the new energy power production management system involved in the embodiments of this application. Detailed Implementation

[0017] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present application, and not all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative effort are within the scope of protection of the present application.

[0018] First, some of the technical terms used in this application will be explained to help those skilled in the art understand this application.

[0019] To make the objectives, technical solutions, and advantages of this application clearer, the embodiments of this application will be described in further detail below with reference to the accompanying drawings.

[0020] In a first aspect, embodiments of this application provide a method for automatically filling in data in a new energy power production management system.

[0021] In one embodiment, reference is made to Figure 1 , Figure 1 This is a flowchart illustrating the first embodiment of the automatic data entry method for the new energy power production management system of this application. Figure 1As shown, the automatic data entry method for the new energy power production management system includes: Step S10: Perform process initialization, which is used to configure the process execution environment; As an example, the process initialization function closes all WPS spreadsheet files, assigns values ​​to global variables, checks if monthly and daily folders for electricity loss data already exist, and determines whether data needs to be fetched after the process starts. Each day, the latest raw electricity statistics tables from each site are placed in the automatic reports folder, overwriting or backing up previous reports. The Chinese characters in the names remain constant, and the year and month are automatically retrieved. Specifically, the execution process initialization includes: closing all WPS spreadsheet files; assigning values ​​to global variables; determining whether a month folder and a day folder with a specified structure exist; and determining whether the source data needs to be fetched.

[0022] Demonstration: Closing WPS Spreadsheet files: Ensures files are not occupied by detecting and terminating the WPS Spreadsheet process (et.exe); Global variable management: Stores and manages all global configuration information using a dictionary structure; Folder inspection and creation: Automatically creates data storage directories according to the year and month structure; Data retrieval judgment: Intelligently determines whether data needs to be updated based on file modification time; Data processing and saving: Simulates the process of acquiring and processing data from source data.

[0023] Step S20: Obtain the source data to be reported, process and summarize the source data to obtain the data to be reported, including the power generation data of the new energy power station. As an example, the function of data aggregation is to query the power loss records for a specified date from the master table of the data source, process the data according to the reporting requirements of the power loss page of the power production system, and then summarize it into the daily power loss record table. Finally, a pop-up window reminds the user to check the summary data.

[0024] Step S30: Start the robotic process automation software and perform a data reporting operation in the new energy power production management system based on the data to be reported. As an example, the function of data reporting is to access the power production management system through a browser, jump to the power loss page, then loop through the row data in the daily power loss record table, fill the row data into the system page, mark the successfully filled row data as successful, mark the unfilled row data as unsuccessful, and note the reason for the failure.

[0025] Step S40 involves handling and notifying users of any exceptions during the data reporting process.

[0026] The exemplary function of exception handling is to record exception information, close all WPS spreadsheet files, and retry within the maximum number of retries when various exceptions occur during process execution. The function of exception notification is to terminate the process, record exception information, and close all WPS spreadsheet files when exceptions persist beyond the maximum number of retries during process execution.

[0027] Practical application: 1. Every day, put the latest electricity statistics raw tables of each station into the automatic report folder, overwriting the previous reports or backing up the previous reports. The Chinese characters in the name should remain unchanged, and the year and month will be automatically obtained.

[0028] 2. Open the process robot software and start running the process.

[0029] 3. Select the reporting type in the pop-up window.

[0030] 4. If an error occurs during the robot's data collection process, a notification will be sent and disappear automatically without requiring any clicking. The program will skip the current report and automatically collect data from the next report.

[0031] 5. The robot will automatically summarize the successfully captured report data into the daily data table.

[0032] 6. After the data for the day is summarized, a pop-up window will remind you whether the data has been checked. You can check and modify the data before clicking "Confirm". Clicking "Cancel" will stop the process and it will not continue.

[0033] 7. Automatically log in to the new energy power production management system, automatically recognize the verification code, and automatically retry if the recognition fails until successful.

[0034] 8. The system will automatically redirect to the Power Plant Business Management -> Business Data Reporting page. Enter the data collection name, select the power plant name and the non-reporting status, click Query, and then click the report link in the query results.

[0035] 9. On the opened reporting page, automatically fill in the data and click save.

[0036] 10. During the reporting process, the system will fill in "Yes" for the reporting results of the reported stations in the summary table to avoid duplicate reporting.

[0037] 11. After the process is completed, please check whether all the station data for the day has been reported in the summary table. If there are any omissions, you can run the program again.

[0038] Using this automatic data entry workflow design method, the following functions were implemented: 1. Configure the site type selection process. Site types include photovoltaic sites, wind power sites, and other sites. When the process starts, the program will automatically pop up a site type selection box, waiting for the user to select. The program will receive the site type selection result and execute different subsequent data reporting processes according to different site types.

[0039] 2. Configure the automatic folder creation process. Daily battery data needs to be placed in different folders, distinguished by year and month. The program will automatically determine whether the folder for the current day exists. If it does not exist, it will automatically create the folder.

[0040] 3. Configure the automatic reading steps of the power plant information configuration table. The power plant information configuration table includes the capacity and configuration data of photovoltaic and wind power, as well as the account and password of the power production management system and the person filling in the form. The program will select the corresponding power plant information configuration table according to the different power plants reported. This mode is convenient for future power plant expansion.

[0041] 4. Configure the station reporting result steps. The reporting result includes success or failure. After each station reports, the program will automatically write the reporting result to the table. If the program is interrupted, the next time the program is executed, it can continue from the interrupted step.

[0042] 5. Configure the data verification step. When the process reaches this step, the program will pause and wait for manual verification of the data. After that, the program will receive instructions to continue or terminate early and proceed to the next step.

[0043] 6. Configure error retry and maximum number of retries. If an error occurs during program execution, it will automatically retry. When the maximum number of retries is reached, the program will terminate and will not continue execution.

[0044] The program uses the following technologies to automate process execution: 1. Screen capture technology, including capturing software and browser elements; 2. Workflow technology can automatically execute processes according to pre-defined rules and logic; 3. Data processing techniques, including data acquisition, type conversion, list and set processing, date and time processing, and mathematical calculations; 4. Software integration technology, including operations on Excel, Word, PDF, email, and databases.

[0045] In this embodiment, process initialization is performed to configure the process execution environment; source data to be reported is obtained, and the source data is processed and summarized to obtain data to be reported, including electricity data of new energy power plants; robotic process automation software is started, and data reporting operation is performed in the new energy power production management system according to the data to be reported; during the data reporting operation, anomaly handling and anomaly notification are performed, which solves the technical problems in related technologies that can only manually collect data and import and export data from Excel spreadsheets, which is cumbersome, inefficient, and prone to errors during collection and transportation, and whose accuracy cannot be guaranteed. This realizes automatic filling of electricity data and improves work efficiency and accuracy.

[0046] Secondly, embodiments of this application also provide an automatic data filling device for a new energy power production management system.

[0047] In one embodiment, reference is made to Figure 2 , Figure 2 This is a functional module diagram of an embodiment of the automatic data filling device for the new energy power production management system of this application. Figure 2 As shown, the automatic data entry device for the new energy power production management system includes: Initialization module 10 is used to perform process initialization, which is used to configure the process execution environment; The acquisition module 20 is used to acquire the source data to be reported, process and summarize the source data to obtain the data to be reported, including the power generation data of the new energy power station. The reporting module 30 is used to perform data reporting operations in the new energy power production management system based on the data to be reported using robotic process automation software. The exception handling and notification module 40 is used to perform exception handling and exception notification during the data reporting operation.

[0048] Furthermore, in one embodiment, the initialization module 10 is used for: Close all WPS spreadsheet files; Assign values ​​to global variables; Determine if a month folder and a day folder with a specified structure exist; Determine whether the source data needs to be scraped.

[0049] Furthermore, in one embodiment, the acquisition module 20 is used for: Retrieve source data records for a specified date from the source data table; The source data records are processed according to the reporting requirements of the new energy power production management system. The processed data is summarized into the daily data to be reported record table; Additionally, a pop-up window reminds the user to check the summarized data.

[0050] Furthermore, in one embodiment, the automatic data filling device of the new energy power production management system further includes a new module for: Start the robotic process automation software and access the new energy power production management system in a browser; In addition, the robotic process automation software is started to automatically log in to the new energy power production management system. The automatic login includes automatically recognizing the verification code. If the recognition is incorrect, it will automatically retry until successful.

[0051] Furthermore, in one embodiment, the automatic data filling device of the new energy power production management system further includes a new module for: The robotic process automation software is launched and automatically redirects to the preset business data reporting page; Input preset query conditions, which include data collection name, power plant name, and unreported status; Also, click the query button and then click the report link in the query results.

[0052] Furthermore, in one embodiment, the reporting module 30 is used for: Start the robotic process automation software and automatically fill in the data to be reported on the opened reporting page; Click the save button; In addition, based on the reported results, the reporting status is marked in the daily pending data record table.

[0053] Furthermore, in one embodiment, the exception handling and notification module 40 is used for: When an exception occurs during process execution, the exception information is recorded; Close all WPS spreadsheet files; Retry within the maximum number of retries; If the number of retries exceeds the maximum number of attempts, the process will be terminated and the exception information will be recorded.

[0054] The functions of each module in the above-mentioned automatic data filling device for the new energy power production management system correspond to the steps in the above-mentioned automatic data filling method embodiment for the new energy power production management system. Their functions and implementation processes will not be described in detail here.

[0055] Thirdly, embodiments of this application provide an automatic data entry device for a new energy power production management system. The automatic data entry device for the new energy power production management system can be a personal computer (PC), a laptop computer, a server, or other devices with data processing capabilities.

[0056] Reference Figure 3 , Figure 3 This is a schematic diagram of the hardware structure of the automatic data reporting device for the new energy power production management system involved in the embodiments of this application. In this embodiment, the automatic data reporting device for the new energy power production management system may include a processor, a memory, a communication interface, and a communication bus.

[0057] The communication bus can be of any type and is used to interconnect the processor, memory, and communication interface.

[0058] The communication interface includes input / output (I / O) interfaces, physical interfaces, and logical interfaces. These interfaces enable interconnection of internal components within the automatic data reporting equipment of the new energy power production management system, as well as interfaces for interconnection between the automatic data reporting equipment and other devices (such as other computing devices or user equipment). Physical interfaces can be Ethernet interfaces, fiber optic interfaces, ATM interfaces, etc.; user equipment can be displays, keyboards, etc.

[0059] Memory can be various types of storage media, such as random access memory (RAM), read-only memory (ROM), non-volatile RAM (NVRAM), flash memory, optical storage, hard disk, programmable ROM (PROM), erasable PROM (EPROM), electrically erasable PROM (EEPROM), etc.

[0060] The processor can be a general-purpose processor, which can call the automatic data filling program of the new energy power production management system stored in the memory and execute the automatic data filling method of the new energy power production management system provided in the embodiments of this application. For example, the general-purpose processor can be a central processing unit (CPU). The method executed when the automatic data filling program of the new energy power production management system is called can refer to the various embodiments of the automatic data filling method of the new energy power production management system of this application, and will not be repeated here.

[0061] Those skilled in the art will understand that Figure 3 The hardware structure shown does not constitute a limitation of this application and may include more or fewer components than shown, or combine certain components, or have different component arrangements.

[0062] Fourthly, embodiments of this application also provide a computer-readable storage medium.

[0063] The present application stores an automatic data filling program for a new energy power production management system on a computer-readable storage medium, wherein when the automatic data filling program for the new energy power production management system is executed by a processor, it implements the steps of the automatic data filling method for the new energy power production management system as described above.

[0064] The method implemented when the automatic data filling program of the new energy power production management system is executed can be referred to in the various embodiments of the automatic data filling method of the new energy power production management system of this application, and will not be repeated here.

[0065] It should be noted that the sequence numbers of the embodiments in this application are for descriptive purposes only and do not represent the superiority or inferiority of the embodiments.

[0066] The terms "comprising" and "having," and any variations thereof, in the specification, claims, and accompanying drawings of this application are intended to cover non-exclusive inclusion. For example, a process, method, system, product, or apparatus that includes a series of steps or units is not limited to the listed steps or units, but may optionally include steps or units not listed, or may optionally include other steps or units inherent to such process, method, product, or apparatus. The terms "first," "second," and "third," etc., are used to distinguish different objects, etc., and do not indicate a sequence, nor do they limit "first," "second," and "third" to different types.

[0067] In the description of the embodiments of this application, terms such as "exemplary," "for example," or "for instance" are used to indicate examples, illustrations, or explanations. Any embodiment or design described as "exemplary," "for example," or "for instance" in the embodiments of this application should not be construed as being more preferred or advantageous than other embodiments or designs. Specifically, the use of terms such as "exemplary," "for example," or "for instance" is intended to present the relevant concepts in a concrete manner.

[0068] In the description of the embodiments of this application, unless otherwise stated, " / " means "or". For example, A / B can mean A or B. The "and / or" in the text is merely a description of the relationship between related objects, indicating that there can be three relationships. For example, A and / or B can mean: A exists alone, A and B exist simultaneously, and B exists alone. In addition, in the description of the embodiments of this application, "multiple" means two or more.

[0069] In some processes described in the embodiments of this application, multiple operations or steps are included in a specific order. However, it should be understood that these operations or steps may not be executed in the order they appear in the embodiments of this application, or they may be executed in parallel. The sequence number of the operation is only used to distinguish different operations, and the sequence number itself does not represent any execution order. In addition, these processes may include more or fewer operations, and these operations or steps may be executed sequentially or in parallel, and these operations or steps may be combined.

[0070] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus necessary general-purpose hardware platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) as described above, and includes several instructions to cause a terminal device to execute the methods described in the various embodiments of this application.

[0071] The above are merely preferred embodiments of this application and do not limit the patent scope of this application. Any equivalent structural or procedural transformations made using the content of this application's specification and drawings, or direct or indirect applications in other related technical fields, are similarly included within the patent protection scope of this application.

Claims

1. A method for automatically filling in data in a new energy power production management system, characterized in that, include: Execution process initialization, which is used to configure the process execution environment; The source data to be reported is obtained, and the source data is processed and summarized to obtain the data to be reported, which includes the power generation data of the new energy power station. Start the robotic process automation software and, based on the data to be reported, perform a data reporting operation in the new energy power production management system. During the data reporting process, exception handling and exception notification are performed.

2. The automatic data filling method for the new energy power production management system as described in claim 1, characterized in that, The execution flow initialization includes: Close all WPS spreadsheet files; Assign values ​​to global variables; Determine if a month folder and a day folder with a specified structure exist; Determine whether the source data needs to be scraped.

3. The automatic data filling method for the new energy power production management system as described in claim 1, characterized in that, The process of acquiring the source data to be reported, and processing and summarizing the source data, includes: Retrieve source data records for a specified date from the source data table; The source data records are processed according to the reporting requirements of the new energy power production management system. The processed data is summarized into the daily data to be reported record table; Additionally, a pop-up window reminds the user to check the summarized data.

4. The automatic data filling method for the new energy power production management system as described in claim 1, characterized in that, After starting the robotic process automation software, the following is also included: Start the robotic process automation software and access the new energy power production management system in a browser; In addition, the robotic process automation software is started to automatically log in to the new energy power production management system. The automatic login includes automatically recognizing the verification code. If the recognition fails, it will automatically retry until successful.

5. The automatic data filling method for the new energy power production management system as described in claim 4, characterized in that, After starting the robotic process automation software, the following is also included: The robotic process automation software is launched and automatically redirects to the preset business data reporting page; Input preset query conditions, which include data collection name, power plant name, and unreported status; Also, click the query button and then click the report link in the query results.

6. The automatic data filling method for the new energy power production management system as described in claim 5, characterized in that, The data reporting operation performed in the new energy power production management system includes: Start the robotic process automation software and automatically fill in the data to be reported on the opened reporting page; Click the save button; In addition, based on the reported results, the reporting status is marked in the daily pending data record table.

7. The automatic data filling method for the new energy power production management system as described in claim 1, characterized in that, The exception handling and exception notification include: When an exception occurs during process execution, the exception information is recorded; Close all WPS spreadsheet files; Retry within the maximum number of retries; If the number of retries exceeds the maximum number of attempts, the process will be terminated and the exception information will be recorded.

8. An automatic data filling device for a new energy power production management system, characterized in that, The automatic data entry device of the new energy power production management system includes: An initialization module is used to perform process initialization, which is used to configure the process execution environment. The acquisition module is used to acquire the source data to be reported, process and summarize the source data to obtain the data to be reported, including the power generation data of the new energy power station. The reporting module is used to perform data reporting operations in the new energy power production management system based on the data to be reported using robotic process automation software. An exception handling and notification module is used to handle exceptions and provide exception notifications during the data reporting operation.

9. An automatic data entry device for a new energy power production management system, characterized in that, The automatic data filling device of the new energy power production management system includes a processor, a memory, and an automatic data filling program of the new energy power production management system stored in the memory and executable by the processor. When the automatic data filling program of the new energy power production management system is executed by the processor, it implements the steps of the automatic data filling method of the new energy power production management system as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores an automatic data filling program for a new energy power production management system, wherein when the automatic data filling program for the new energy power production management system is executed by a processor, it implements the steps of the automatic data filling method for the new energy power production management system as described in any one of claims 1 to 7.

Images