Electric power official document circulation automatic control system and method based on collaborative office platform

By designing an automatic control system for power document circulation on the collaborative office platform, the shortcomings in power document circulation automation are solved, and automatic reception, intelligent monitoring, timely reminders and report generation of official documents are realized, and the circulation efficiency and accuracy are improved.

CN119887130APending Publication Date: 2025-04-25STATE GRID HEBEI ELECTRIC POWER CO LTD +1
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411828805.5
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-12-12
Publication Date
2025-04-25

AI Technical Summary

Technical Problem

The existing collaborative office platform has shortcomings in the automation of power document circulation, including the lack of automatic reception and registration mechanism, the insensible timeout monitoring and reminder functions, and the need for manual operation in status tracking and report generation, which cannot reflect the latest status of official documents in real time.

Method used

An automatic control system for power document circulation based on a collaborative office platform is designed, including a power document receiving unit, a classification unit, a ledger unit, a timeout reminder unit and a report generation unit. Through automatic login, automatic receipt of official documents, classification, recording, monitoring and reminder, the automatic document circulation is realized.

Benefits of technology

Through automation technology, the processing time of official documents is significantly shortened, the work efficiency is improved, human errors are reduced, the accuracy and timeliness of official document information are ensured, and the transparency and management efficiency of official document circulation are enhanced through real-time status tracking and automatic report generation.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119887130A_ABST
    Figure CN119887130A_ABST
Patent Text Reader

Abstract

The invention discloses an electric power official document circulation automatic control system and method based on a collaborative office platform, and the system comprises an electric power official document receiving unit which is used for automatically receiving an electric power official document from a collaborative office platform part; the electric power official document classification unit is used for classifying the electric power official documents according to an electric power official document classification standard and marking the classified electric power official documents according to categories; the electric power official document ledger unit is used for establishing and maintaining an official document ledger database and automatically recording a category mark, a title, an incoming document unit, a document receiving time, a document receiving number and a document word size of each official document; the overtime reminding unit is used for regularly checking an official document processing state in the official document ledger database, identifying an overtime official document and sending an urging short message to an overtime person through the collaborative office platform; the report generation unit is used for automatically generating and providing an official document processing report, and the content of the report comprises the total official document receiving number up to the specific time point, the number of official documents being processed and the number of overtime official documents.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of collaborative office technology, and more specifically to an automatic control system and method for power document circulation based on a collaborative office platform. Background Art

[0002] In the operation of power enterprises, power documents are an important tool for communication within and between organizations. The circulation efficiency and management quality of power documents directly affect the speed of decision-making and the efficiency of execution. The traditional circulation of power documents relies on manual operations, including the receipt, registration, approval, and archiving of power documents. These links are not only time-consuming and labor-intensive, but also prone to errors. With the development of information technology, many power companies have begun to adopt collaborative office platforms to manage the circulation of documents in order to improve efficiency and accuracy.

[0003] The publication number is CN113407502A, and the name is a data flow classification management method and system, which includes file identification and operation information extraction, file flow identification and analysis on the server side, and early warning steps. The present invention effectively helps enterprises manage the knowledge product files in the enterprise, prevents files from being sent out by remote control programs, and prevents important knowledge product files from being sent out to the Internet. Enterprises can effectively view the flow of files in real time and conduct standardized management.

[0004] The publication number is CN110727568A, and the name is a multi-source log data processing system and method in a cloud environment. The log source input module of the system of the present invention provides the function of multi-source log access; the data preprocessing module provides the data classification function; the data processing module provides the log processing plug-in management function; the data storage module provides the back-end data storage management function. The present invention labels the text log data stream through a two-dimensional vector; edits the plugin_playbook.yml file, defines the log data stream processing link, and determines the processing order of the log between different plugins; scans and loads all plugins in the plugins directory; parses the plugin_playbook.yml file, constructs a complete data stream parsing link, and the original log file is sequentially and stepwisely transmitted to different plug-ins for processing according to the link identifier.

[0005] However, the existing collaborative office platform still has shortcomings in the automation of power document circulation. For example, the process of receiving and registering power documents still requires manual intervention and lacks an effective automatic trigger mechanism; the timeout monitoring and reminder functions in the power document processing process are not intelligent enough, resulting in the possibility that emergency documents may not be processed in time; in addition, the status tracking and report generation of power document circulation usually require manual operation, which cannot reflect the latest status of power documents in real time.

[0006] Therefore, how to provide an automatic control system and method for the circulation of power documents based on a collaborative office platform, and realize the automatic reception, intelligent monitoring, timely reminders and report generation of power documents through automation technology, thereby greatly improving the efficiency and accuracy of power document circulation, reducing human errors, and ensuring the timeliness and security of power document processing is a problem that technical personnel in this field urgently need to solve. Summary of the invention

[0007] In view of this, the present invention provides an automatic control system and method for the circulation of electric power documents based on a collaborative office platform, aiming to solve the technical problems that the reception and registration process of documents still requires manual intervention and lacks an effective automatic triggering mechanism; the timeout monitoring and reminder functions in the process of processing electric power documents are not intelligent enough, resulting in the possibility that emergency documents may not be processed in time; in addition, the status tracking and report generation of electric power document circulation usually require manual operation, and cannot reflect the latest status of electric power documents in real time.

[0008] In order to achieve the above object, the present invention adopts the following technical solution:

[0009] An automatic control system for power document circulation based on a collaborative office platform, characterized by comprising:

[0010] The power document receiving unit is used to automatically receive power documents from the "document management - document receipt management - document receipt registration - receiving Internet documents" section of the collaborative office platform;

[0011] The electric power official document classification unit is used to classify the electric power official documents according to the electric power official document classification standard, and mark the classified electric power official documents according to the category;

[0012] The power document record unit is used to establish and maintain a document record database, automatically recording the category mark, title, source unit, receipt time, receipt number, file number, processing link, link processing personnel, and link start time of each document;

[0013] The overtime reminder unit is used to regularly check the document processing status in the document ledger database, identify overdue documents, and automatically send reminder text messages to overdue personnel through the collaborative office platform;

[0014] The report generation unit is used to automatically generate and provide a document processing report, the report content includes the total number of documents received as of a specific time point, the number of documents being processed, and the number of timed documents.

[0015] Furthermore, an automatic login unit is provided for automatically filling in the account number and password of the clerk account and logging into the collaborative office platform, and the automatic login unit includes: a credential management unit, a webpage navigation unit, a form filling unit, a login trigger unit, a session verification unit and an error handling unit;

[0016] The credential management unit is used to store and retrieve the account number and password of the clerical account, the web navigation unit is used to automatically open the web page interface of the collaborative office platform, the form filling unit is used to automatically fill in the login form in the web page interface, and enter the stored account number and password, the login trigger unit is used to simulate the user submission behavior and trigger the login process, the session verification unit is used to confirm whether the login operation is successful and ensure that the session with the collaborative office platform has been established, and the error handling unit is used to execute a predetermined error handling strategy when an error is encountered during the login process, such as retrying the login or recording error information.

[0017] Furthermore, the document receiving unit includes: a webpage content recognition unit, an action triggering unit, a dialog processing unit, a data extraction unit, a data formatting unit and an error detection unit;

[0018] The web page content recognition unit is used to identify the "official document management-received document management-received document registration-receiving Internet official documents" part in the collaborative office platform; the action trigger unit is used to automatically perform a click operation to select the "receive Internet official documents" option; the dialog box processing unit is used to process the dialog box that pops up when receiving official documents, including automatically entering the necessary password and confirming the operation; the data extraction unit is used to extract detailed information of official documents from the collaborative office platform, including the source unit, receipt number, file size, file title, and receipt date; the data formatting unit is used to convert the extracted official document information into a predetermined format for storage in the official document ledger database; the error detection unit is used to detect errors that may occur in the process of receiving official documents, such as data extraction failure or network delay, and execute a predetermined error handling strategy.

[0019] Furthermore, the electric power document classification unit includes: an identification and classification unit, an intelligent label unit, an encryption unit and a classification standard setting unit;

[0020] The identification and classification unit is used to automatically identify and classify uploaded power documents, and classify them into corresponding categories according to their content and format; the intelligent label unit is used to extract keywords and topics through natural language processing technology, and automatically label power documents with classification tags; the encryption unit is used to encrypt the confidentiality level of different categories of power documents; the classification standard setting unit is used to set document classification standards, including guidance documents, notification letters, contract agreements, technical specifications and engineering design documents, construction drawings and acceptance reports, operation and maintenance manuals, substation dispatch instructions and accident reports.

[0021] Furthermore, the document ledger database includes: a database management unit, a data model, a data entry interface unit, a data update unit, a query processing unit, a report production unit and a data backup unit;

[0022] The database management unit is used to create and manage the data structure of the official document ledger. The data model includes a sub-library of official documents being processed and a sub-library of official documents that have been processed. The data records stored in each sub-library include the official document title, the source unit, the time of receipt, the document number, the file size, and detailed information of up to eight processing links. The detailed information of each link includes the processing personnel and the start time of the link. The data entry interface unit is used to receive official document information from the data extractor and enter the information into the corresponding official document sub-library. The data update unit is used to update the corresponding records in the database when the processing status of the official document changes. The query processing unit is used to respond to query requests from other modules of the system, retrieve and return specific official document records. The report generation unit is used to generate an official document processing report based on the official document records in the database. The data backup unit is used to regularly back up the information in the official document ledger database to ensure the security and recoverability of the data.

[0023] Further, the timeout reminder unit includes: a timing unit, a state monitoring unit, a time analysis unit, a timeout identification unit, a notification generation unit, a communication interface unit, a feedback receiving unit and an exception handling unit;

[0024] The timing unit is used to automatically trigger the timeout check process at a predetermined time interval; the status monitoring unit is used to monitor the document processing status recorded in the document ledger database; the time analysis unit is used to compare the start time of each processing link with the current time to determine whether there is a timeout; the timeout identification unit is used to mark the timeout status on the corresponding record in the document ledger database when a timeout is detected; the notification generation unit is used to generate a reminder text message or notification, the content of which includes detailed information of the timed document and the timed-out person; the communication interface unit is used to send a reminder text message or notification to the timed-out person through the collaborative office platform or the external communication network; the feedback receiving unit is used to receive the response of the timed-out person to the reminder text message or notification, and update the processing status in the document ledger database; the exception handling unit is used to execute a predetermined exception handling strategy when the reminder fails to be sent or no feedback is received, such as retrying to send, recording a log or notifying an administrator.

[0025] Further, the document processing report module includes: a data aggregation unit, a report template generation unit, a report filling unit, a date and time processing unit, a report formatting unit, a report export unit, a report distribution unit, a report archiving unit and a user feedback collection unit;

[0026] The data aggregation unit is used to collect data related to document processing from the document ledger database, including the number of documents received, the number of documents being processed, and the number of documents that have timed out. The report template generation unit is used to generate a template for a document processing report according to a predefined report format. The report filling unit is used to fill the collected data into the report template to generate complete report content. The date and time processing unit is used to obtain and format the specific date and time of report generation to ensure the timeliness of the report. The report formatting unit is used to format the generated report, including text typesetting, chart insertion and page layout. The report export unit is used to export the generated report into different formats, such as PDF, Word or Excel, for easy distribution and archiving. The report distribution unit is used to automatically distribute the generated report to a predetermined recipient, such as a system administrator, a department head or a relevant person. The report archiving unit is used to archive the generated report to a specified storage location, including a local storage or a cloud storage service, for easy query and analysis of historical records. The user feedback collection unit is used to collect user feedback on the report to facilitate continuous improvement of the report content and format.

[0027] A method for automatically controlling the circulation of electric power documents based on a collaborative office platform comprises the following steps:

[0028] S1. Load the preset clerical account credentials and ensure that the credentials are securely stored in the encrypted database; configure the target URL to point to the login page of the collaborative office platform and automatically open the page, initialize the official document ledger database, including creating sub-databases of official documents being processed and completed, and design a data model to store detailed information of official documents;

[0029] S2, automatically fill in the login form, including the username and password fields, submit the login form to trigger the login process, establish and maintain a session with the collaborative office platform after successful login, monitor the login process, capture and handle any errors or exceptions, and execute predetermined policies such as retrying login or logging error information;

[0030] S3. Use text matching or HTML element positioning technology to identify the part of the collaborative office platform used to receive official documents, simulate user click operations, select the "Receive Internet Official Documents" option, process the dialog box that pops up when receiving official documents, automatically enter the password and confirm the operation, extract detailed information of the official document from the collaborative office platform, such as the source unit, receipt number, etc., convert the extracted official document information into a predetermined format, and store it in the official document ledger database.

[0031] Furthermore, it also includes document record maintenance, monitoring and reminders:

[0032] Update records in the official document ledger database to reflect the latest processing status of official documents, respond to query requests from other modules of the system, and retrieve and return specific official document records.

[0033] The timeout check process is triggered at the preset time interval, the document processing status recorded in the document ledger database is monitored, and the start time of each processing link is compared with the current time to determine whether there is a timeout. When a timeout is detected, a reminder SMS or notification is generated, and the reminder SMS or notification is sent to the timeout personnel through the collaborative office platform. The response of the timeout personnel to the reminder SMS or notification is received, and the processing status in the document ledger database is updated. When the reminder fails or no feedback is received, the predetermined exception handling strategy is executed.

[0034] Furthermore, it also includes report generation and distribution:

[0035] Collect data related to document processing from the document ledger database, create a template for the document processing report, fill the data into the template, obtain and format the specific date and time of report generation, format the generated report, including text typesetting, chart insertion and page layout, export the generated report to different formats, automatically distribute the generated report to the predetermined recipients, and archive the generated report to the specified storage location.

[0036] The above technical solution includes at least the following technical effects:

[0037] It can be known from the above technical solutions that the present invention discloses an automatic control system and method for the circulation of electric power documents based on a collaborative office platform. Compared with the prior art, the present invention reduces the need for manual intervention through automatic login and document reception, significantly shortens the time for document processing, and improves overall work efficiency. The automated process reduces the links of manual input and operation, reduces the error rate caused by human errors, and ensures the accuracy of document information. The timeout reminder unit can promptly identify timed documents and automatically send reminder notices to ensure the timeliness of document processing and avoid the impact caused by delays. The establishment and maintenance of the document ledger database realizes the systematic management of the entire process of document circulation, which is convenient for data query and statistical analysis. The processing status and operation records of all documents can be traced back, which enhances the transparency of document circulation and facilitates supervision and decision-making by management. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying creative work.

[0039] Figure 1 The present invention is a schematic structural diagram of an automatic control system for power document circulation based on a collaborative office platform.

[0040] Figure 2 The present invention is a flowchart of an automatic control method for power document circulation based on a collaborative office platform. DETAILED DESCRIPTION

[0041] The technical solutions in the embodiments of the present invention are described clearly and completely below. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0042] See attached Figure 1-2The embodiment of the present invention discloses an automatic control system for the circulation of electric power documents based on a collaborative office platform, including: an electric power document receiving unit, used for automatically receiving electric power documents from the "document management-receiving document management-receiving document registration-receiving Internet documents" part of the collaborative office platform; an electric power document classification unit, used for classifying electric power documents according to the electric power document classification standard, and marking the classified electric power documents according to the category; an electric power document ledger unit, used for establishing and maintaining an official document ledger database, automatically recording the category mark, title, source unit, receiving time, receiving number, file font size, processing link, link processing personnel, and link start time of each document; a timeout reminder unit, used for regularly checking the document processing status in the official document ledger database, identifying timed documents, and automatically sending reminder text messages to timed personnel through the collaborative office platform; a report generation unit, used for automatically generating and providing an official document processing report, the report content includes the total number of documents received as of a specific time point, the number of documents being processed, and the number of timed documents.

[0043] In order to further optimize the above technical solution, an automatic login unit is also provided, which is used to automatically fill in the account number and password of the clerical account and log in to the collaborative office platform. The automatic login unit includes: a credential management unit, a web navigation unit, a form filling unit, a login trigger unit, a session verification unit and an error handling unit; the credential management unit is used to store and retrieve the account number and password of the clerical account, the web navigation unit is used to automatically open the web interface of the collaborative office platform, the form filling unit is used to automatically fill in the login form in the web interface, and input the stored account number and password, the login trigger unit is used to simulate the user submission behavior and trigger the login process, the session verification unit is used to confirm whether the login operation is successful and ensure that the session with the collaborative office platform has been established, and the error handling unit is used to execute a predetermined error handling strategy when an error is encountered during the login process, such as retrying the login or recording error information.

[0044] To further optimize the above technical solution, the official document receiving unit includes: a web page content recognition unit, an action triggering unit, a dialog processing unit, a data extraction unit, a data formatting unit and an error detection unit; the web page content recognition unit is used to identify the "official document management-receiving document management-receiving document registration-receiving Internet official documents" part in the collaborative office platform; the action triggering unit is used to automatically perform a click operation to select the "receiving Internet official documents" option, the dialog processing unit is used to process the dialog box that pops up when receiving official documents, including automatically entering the necessary password and confirming the operation, the data extraction unit is used to extract detailed information of the official document from the collaborative office platform, including the source unit, receipt number, file size, file title, and receipt date, the data formatting unit is used to convert the extracted official document information into a predetermined format for storage in the official document ledger database, and the error detection unit is used to detect errors that may occur in the official document reception process, such as data extraction failure or network delay, and execute a predetermined error handling strategy.

[0045] To further optimize the above technical solution, the electric power document classification unit includes: an identification and classification unit, an intelligent label unit, an encryption unit and a classification standard setting unit; the identification and classification unit is used to automatically identify and classify uploaded electric power documents, and classify them into corresponding categories according to their content and format; the intelligent label unit is used to extract keywords and topics through natural language processing technology, and automatically classify electric power documents; the encryption unit is used to encrypt the confidentiality level of different categories of electric power documents; the classification standard setting unit is used to set document classification standards, including guidance documents, notification letters, contract agreements, technical specifications and engineering design documents, construction drawings and acceptance reports, operation and maintenance manuals, substation dispatching instructions and accident reports.

[0046] To further optimize the above technical solution, the official document ledger database includes: a database management unit, a data model, a data entry interface unit, a data update unit, a query processing unit, a report production unit and a data backup unit; the database management unit is used to create and manage the data structure of the official document ledger, the data model includes the official document sub-library being processed and the official document sub-library that has been processed, the data records stored in each sub-library include the official document title, the letter unit, the document receipt time, the document receipt number, the file font size, and detailed information of up to eight processing links, the detailed information of each link includes the processing personnel and the start time of the link, the data entry interface unit is used to receive the official document information from the data extractor and enter the information into the corresponding official document sub-library, the data update unit is used to update the corresponding records in the database when the processing status of the official document changes, the query processing unit is used to respond to query requests from other modules of the system, retrieve and return specific official document records, the report generation unit is used to generate official document processing reports based on the official document records in the database, and the data backup unit is used to regularly back up the information in the official document ledger database to ensure the security and recoverability of the data.

[0047] To further optimize the above technical solution, the timeout reminder unit includes: a timing unit, a state monitoring unit, a time analysis unit, a timeout identification unit, a notification generating unit, a communication interface unit, a feedback receiving unit and an exception handling unit; the timing unit is used to automatically trigger the timeout check process according to a predetermined time interval; the state monitoring unit is used to monitor the document processing status recorded in the document ledger database; the time analysis unit is used to compare the start time of each processing link with the current time to determine whether it is a timeout; the timeout identification unit is used to mark the timeout status on the corresponding record in the document ledger database when a timeout is detected; the notification generating unit is used to generate a reminder SMS or notification, the content of which includes detailed information of the timeout document and the timeout personnel; the communication interface unit is used to send a reminder SMS or notification to the timeout personnel through the collaborative office platform or the external communication network; the feedback receiving unit is used to receive the response of the timeout personnel to the reminder SMS or notification, and update the processing status in the document ledger database; the exception handling unit is used to execute a predetermined exception handling strategy when the reminder fails to be sent or no feedback is received, such as retrying to send, recording a log or notifying an administrator.

[0048] To further optimize the above technical solution, the document processing report module includes: a data aggregation unit, a report template generation unit, a report filling unit, a date and time processing unit, a report formatting unit, a report export unit, a report distribution unit, a report archiving unit and a user feedback collection unit; the data aggregation unit is used to collect data related to document processing from the document ledger database, including the number of documents received, the number of documents being processed and the number of documents overdue; the report template generation unit is used to generate a template for the document processing report according to a predefined report format; the report filling unit is used to fill the collected data into the report template to generate a complete report content; the date and time processing unit is used to obtain and format the report generation; The specific date and time of the report are used to ensure the timeliness of the report. The report formatting unit is used to format the generated report, including text typesetting, chart insertion and page layout. The report exporting unit is used to export the generated report into different formats, such as PDF, Word or Excel, for easy distribution and archiving. The report distribution unit is used to automatically distribute the generated report to the predetermined recipients, such as system administrators, department heads or relevant personnel. The report archiving unit is used to archive the generated report to the specified storage location, including local storage or cloud storage service, for easy query and analysis of historical records. The user feedback collection unit is used to collect user feedback on the report to facilitate continuous improvement of the report content and format.

[0049] A method for automatically controlling the circulation of electric power documents based on a collaborative office platform comprises the following steps:

[0050] S1. Load the preset clerical account credentials and ensure that the credentials are securely stored in the encrypted database; configure the target URL to point to the login page of the collaborative office platform and automatically open the page, initialize the official document ledger database, including creating sub-databases of official documents being processed and completed, and design a data model to store detailed information of official documents;

[0051] S2, automatically fill in the login form, including the username and password fields, submit the login form to trigger the login process, establish and maintain a session with the collaborative office platform after successful login, monitor the login process, capture and handle any errors or exceptions, and execute predetermined policies such as retrying login or logging error information;

[0052] S3. Use text matching or HTML element positioning technology to identify the part of the collaborative office platform used to receive official documents, simulate user click operations, select the "Receive Internet Official Documents" option, process the dialog box that pops up when receiving official documents, automatically enter the password and confirm the operation, extract detailed information of the official document from the collaborative office platform, such as the source unit, receipt number, etc., convert the extracted official document information into a predetermined format, and store it in the official document ledger database.

[0053] It also includes document ledger maintenance, monitoring and reminders: updating records in the document ledger database to reflect the latest processing status of documents, responding to query requests from other modules of the system, and retrieving and returning specific document records. The timeout check process is triggered at a predetermined time interval, monitoring the document processing status recorded in the document ledger database, comparing the start time of each processing link with the current time to determine whether it has timed out, and generating reminder text messages or notifications when a timeout is detected, sending reminder text messages or notifications to the timeout personnel through the collaborative office platform, receiving the timeout personnel's response to the reminder text messages or notifications, and updating the processing status in the document ledger database. When the reminder fails or no feedback is received, the predetermined exception handling strategy is executed.

[0054] To further optimize the above technical solution, it also includes report generation and distribution: collecting data related to document processing from the document ledger database, creating a template for the document processing report, and filling the data into the template, obtaining and formatting the specific date and time of report generation, formatting the generated report, including text typesetting, chart insertion and page layout, exporting the generated report to different formats, automatically distributing the generated report to the predetermined recipients, and archiving the generated report to a designated storage location.

[0055] This system aims to improve the efficiency and accuracy of document circulation through automation technology. The system automatically logs into the collaborative office platform, automatically receives documents, maintains document records, monitors document processing status, and generates document processing reports.

[0056] System composition

[0057] The system consists of the following modules:

[0058] Automatic login unit: automatically fill in the account number and password of the clerk account and log in to the collaborative office platform.

[0059] Official document receiving unit: automatically receives official documents from the collaborative office platform.

[0060] Official document ledger unit: establish and maintain an official document ledger database to record detailed information of official documents.

[0061] Timeout reminder unit: regularly check the document processing status, identify timed documents, and send reminder text messages.

[0062] Report generation unit: automatically generate document processing reports.

[0063] Detailed implementation steps

[0064] Step 1: System Initialization

[0065] System Configuration:

[0066] Deploy the automatic control system on the server and configure the system parameters, including database connection information, URL of the collaborative office platform, credential storage path of the clerical account, etc.

[0067] Configuration file example:

[0068]

[0069] Credentials Management:

[0070] The credential management unit loads the credentials of the clerical account from the secure encrypted storage. These credentials include the user name and password, which are used to log in to the collaborative office platform.

[0071] Encrypted storage example:

[0072]

[0073] Database initialization:

[0074] The database management unit creates and initializes the document ledger database, sets the data model and index to optimize query performance. Database table structure example:

[0075]

[0076] Step 2: Automatic login operation

[0077] Website navigation:

[0078] The webpage navigation unit uses a preset URL to access the login page of the collaborative office platform.

[0079] Sample code:

[0080]

[0081] Form filling:

[0082] The form filler unit automatically fills the login form with username and password.

[0083] Sample code:

[0084]

[0085] Login trigger:

[0086] The login trigger unit simulates the user clicking the login button and submitting a login request.

[0087] Sample code:

[0088] def submit_login_form(driver):

[0089] login_button=driver.find_element_by_name("login")

[0090] login_button.click()

[0091] Session Authentication:

[0092] The session verification unit checks the returned response to confirm whether the session is successfully established.

[0093] Sample code:

[0094]

[0095] Exception handling:

[0096] If the login fails, the error handling unit will retry the login or record the error information to the log file. Sample code:

[0097]

[0098]

[0099] Step 3: Document receiving operation

[0100] Web content identification:

[0101] The web page content recognition unit uses text matching or HTML element positioning technology to identify the part of the collaborative office platform used to receive official documents.

[0102] Sample code:

[0103] def identify_document_section(driver):

[0104] document_section=driver.find_element_by_xpath(" / / section[@id='document-receive']")

[0105] return document_section

[0106] Action trigger:

[0107] The action trigger unit simulates a user click operation and selects the "Receive Internet Official Documents" option.

[0108] Sample code:

[0109] def trigger_receive_document(driver):

[0110] receive_button=driver.find_element_by_name("receive_internet_document")

[0111] receive_button.click()

[0112] Dialog box handling:

[0113] The dialog processing unit processes the dialog box that pops up when receiving official documents, automatically enters the password and confirms the operation.

[0114] Sample code:

[0115]

[0116] Data extraction:

[0117] The data extraction unit extracts detailed information of official documents from the collaborative office platform, including the source unit, receipt number, etc.

[0118] Sample code:

[0119]

[0120]

[0121] Data formatting:

[0122] The data formatting unit converts the extracted information into a predetermined format and stores it in the official document ledger database.

[0123] Sample code:

[0124]

[0125] Classification standards for power documents:

[0126] According to the characteristics of the power industry, we can divide official documents into the following categories:

[0127] Guidance documents: including power development plans, policies and regulations, technical standards and other documents issued by government departments. Notices: used to convey information and issue instructions, such as power supply notices, cooperation notices, etc.

[0128] Contract and agreement documents: legal documents that determine cooperative relationships and stipulate rights and responsibilities, such as electricity contracts, procurement agreements, etc. Technical specifications and engineering design documents: specific requirements for power engineering design, construction, acceptance, etc. Construction drawings and acceptance reports: record the detailed design plan and acceptance results of power engineering.

[0129] Operation and maintenance manual and substation dispatch instructions: guide the operation and maintenance of power equipment and the safe operation of the power grid.

[0130] Accident report: record the causes, processes and lessons of power accidents to improve the safety of power projects.

[0131] Step 4: Document ledger maintenance

[0132] Database Management:

[0133] The database management unit is responsible for creating and managing the data structure of the official document ledger.

[0134] Sample code:

[0135]

[0136] Data Entry:

[0137] The data entry interface unit enters the extracted document information into the corresponding document sub-database. Sample code:

[0138]

[0139]

[0140] Data update:

[0141] The data updating unit updates the corresponding records in the database when the processing status of the document changes.

[0142] Sample code:

[0143]

[0144] Query Processing:

[0145] The query processing unit responds to query requests from other modules of the system, retrieves and returns specific official document records. Sample code:

[0146]

[0147]

[0148] Report Generation:

[0149] The report generating unit generates an official document processing report according to the official document records in the database.

[0150] Sample code:

[0151]

[0152] Data backup:

[0153] The data backup unit regularly backs up the information in the official document ledger database to ensure the security and recoverability of the data. Example code:

[0154]

[0155] Step 5: Timeout Monitoring and Reminder

[0156] Timed Check:

[0157] The timed unit triggers the timeout check process at a predetermined time interval.

[0158] Example code:

[0159]

[0160] Status Monitoring:

[0161] The status monitoring unit monitors the processing status of official documents recorded in the official document ledger database.

[0162] Example code:

[0163]

[0164] Time Analysis:

[0165] The time analysis unit compares the start time of each processing step with the current time to determine whether it is overdue. Example code:

[0166] def is_overdue(document):

[0167] return document['start_time']+timedelta(hours=48)<datetime.now() Overdue Indicator:

[0168] The overdue indicator unit marks the overdue status in the database when an overdue situation is detected.

[0169] Example code:

[0170] def mark_overdue(document_id):

[0171] update_document_status(document_id,'Overdue')

[0172] Notification Generation:

[0173] The notification generation unit generates reminder text messages or notifications, including the detailed information of the overdue official documents and the overdue personnel.

[0174] Example code:

[0175]

[0176] Communication interface:

[0177] The communication interface unit sends reminder text messages or notifications to overdue personnel through the collaborative office platform or external communication network.

[0178] Sample code:

[0179] def send_notification(message,recipient):

[0180] #Assuming an emails SMTP server is configured for sending

[0181] send_email(recipient,"Overdue Document Notification",message)

[0182] Feedback received:

[0183] The feedback receiving unit receives the response of the overdue personnel to the reminder SMS or notification, and updates the processing status in the official document ledger database.

[0184] Sample code:

[0185] def update_document_status_based_on_feedback(document_id,new_status):

[0186] update_document_status(document_id,new_status)

[0187] Exception handling:

[0188] The exception handling unit executes a predetermined exception handling strategy when sending reminders fails or no feedback is received.

[0189] Sample code:

[0190] def handle_notification_failure(document_id):

[0191] log_error(f"Failed to send notification for document{document_id}")

[0192] retry_sending_notification(document_id)

[0193] Step 6: Report Generation and Distribution

[0194] Data Aggregation:

[0195] The data aggregation unit collects data related to official document processing from the official document ledger database.

[0196] Sample code:

[0197]

[0198]

[0199] Report template generation:

[0200] The report template generation unit creates a template for the document processing report.

[0201] Sample code:

[0202]

[0203] Report Population:

[0204] The report filling unit fills the collected data into the report template.

[0205] Sample code:

[0206]

[0207] Date and time handling:

[0208] The date and time processing unit obtains and formats the specific date and time of report generation.

[0209] Sample code:

[0210] def format_report_date():

[0211] return datetime.now().strftime("%Y-%m-%d%H:%M:%S")

[0212] Report formatting:

[0213] The report formatting unit formats the generated report.

[0214] Sample code:

[0215] def format_report(report):

[0216] report.add_footer(f"Generated on:{format_report_date()}")

[0217] return report

[0218] Report Export:

[0219] The report export unit exports the generated reports into different formats.

[0220] Sample code:

[0221] def export_report(report,format='PDF'):

[0222] return report.export(format)

[0223] Report Distribution:

[0224] The report distribution unit automatically distributes the generated report to the predetermined recipients.

[0225] Sample code:

[0226] def distribute_report(report,recipients):

[0227] for recipient in recipients:

[0228] send_email(recipient,"Document Processing Report",report)

[0229] Report Archives:

[0230] The report archiving unit archives the generated report to a specified storage location.

[0231] Sample code:

[0232] def save_report(report):

[0233] with open("report.pdf","wb")as f:

[0234] f.write(report.export('PDF'))

[0235] User feedback collection:

[0236] The user feedback collection unit collects user feedback on the report to facilitate continuous improvement of the report content and format. Sample code:

[0237]

[0238]

[0239] The automatic control system and method for power document circulation based on the collaborative office platform designed according to the present invention can provide an efficient and automated document processing solution for organizations, thereby improving office efficiency, reducing human errors, and ensuring timely monitoring and response to any delays in document processing. In addition, the automatically generated document processing report provides valuable data support for management, helping them to better monitor and optimize the document circulation process.

[0240] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.

[0241] The above description of the disclosed embodiments enables one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to the embodiments shown herein, but rather to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. An automatic control system for power document circulation based on a collaborative office platform, characterized in that: include: The power document receiving unit is used to automatically receive power documents from the "document management - document receipt management - document receipt registration - receiving Internet documents" section of the collaborative office platform; The electric power official document classification unit is used to classify the electric power official documents according to the electric power official document classification standard, and mark the classified electric power official documents according to the category; The power document record unit is used to establish and maintain a document record database, automatically recording the category mark, title, source unit, receipt time, receipt number, file number, processing link, link processing personnel, and link start time of each document; The overtime reminder unit is used to regularly check the document processing status in the document ledger database, identify overdue documents, and automatically send reminder text messages to overdue personnel through the collaborative office platform; The report generation unit is used to automatically generate and provide a document processing report, the report content includes the total number of documents received as of a specific time point, the number of documents being processed, and the number of timed documents.

2. According to claim 1, an automatic control system for power document circulation based on a collaborative office platform is characterized in that: An automatic login unit is also provided for automatically filling in the account and password of the clerk account and logging into the collaborative office platform. The automatic login unit includes: a credential management unit, a webpage navigation unit, a form filling unit, a login trigger unit, a session verification unit and an error handling unit; The credential management unit is used to store and retrieve the account number and password of the clerical account, the web navigation unit is used to automatically open the web page interface of the collaborative office platform, the form filling unit is used to automatically fill in the login form in the web page interface, and enter the stored account number and password, the login trigger unit is used to simulate the user submission behavior and trigger the login process, the session verification unit is used to confirm whether the login operation is successful and ensure that the session with the collaborative office platform has been established, and the error handling unit is used to execute a predetermined error handling strategy when an error is encountered during the login process, including retrying the login or recording error information.

3. According to the collaborative office platform-based automatic control system for power document circulation according to claim 1, it is characterized in that: The document receiving unit includes: a webpage content recognition unit, an action triggering unit, a dialog processing unit, a data extraction unit, a data formatting unit and an error detection unit; The web page content recognition unit is used to identify the "official document management-received document management-received document registration-receiving Internet official documents" part in the collaborative office platform; the action trigger unit is used to automatically perform a click operation to select the "receive Internet official documents" option; the dialog box processing unit is used to process the dialog box that pops up when receiving official documents, including automatically entering the necessary password and confirming the operation; the data extraction unit is used to extract detailed information of official documents from the collaborative office platform, including the source unit, receipt number, file size, file title, and receipt date; the data formatting unit is used to convert the extracted official document information into a predetermined format; the error detection unit is used to detect errors that may occur in the process of receiving official documents, including data extraction failure or network delay, and execute a predetermined error handling strategy.

4. According to the collaborative office platform-based automatic control system for power document circulation according to claim 1, it is characterized in that: The power document classification unit includes: identification and classification unit, intelligent label unit, encryption unit and classification standard setting unit; The identification and classification unit is used to automatically identify and classify uploaded power documents, and classify them into corresponding categories according to their content and format; the intelligent label unit is used to extract keywords and topics through natural language processing technology, and automatically label power documents with classification tags; the encryption unit is used to encrypt the confidentiality level of different categories of power documents; the classification standard setting unit is used to set document classification standards, including guidance documents, notification letters, contract agreements, technical specifications and engineering design documents, construction drawings and acceptance reports, operation and maintenance manuals, substation dispatch instructions and accident reports.

5. The automatic control system for power document circulation based on collaborative office platform according to claim 1 is characterized in that: The document record database includes: a database management unit, a data model, a data entry interface unit, a data update unit, a query processing unit, a report production unit and a data backup unit; The database management unit is used to create and manage the data structure of the official document ledger. The data model includes a sub-library of official documents being processed and a sub-library of official documents that have been processed. The data records stored in each sub-library include the official document title, the source unit, the time of receipt, the document number, the file size, and detailed information of eight processing links. The detailed information of each link includes the processing personnel and the start time of the link. The data entry interface unit is used to receive official document information from the data extractor and enter the information into the corresponding official document sub-library. The data update unit is used to update the corresponding records in the database when the processing status of the official document changes. The query processing unit is used to respond to query requests from other modules of the system, retrieve and return specific official document records. The report generation unit is used to generate an official document processing report based on the official document records in the database. The data backup unit is used to regularly back up the information in the official document ledger database.

6. The automatic control system for power document circulation based on collaborative office platform according to claim 1 is characterized in that: The timeout reminder unit includes: a timing unit, a state monitoring unit, a time analysis unit, a timeout identification unit, a notification generation unit, a communication interface unit, a feedback receiving unit and an exception handling unit; The timing unit is used to automatically trigger the timeout check process at a predetermined time interval; the status monitoring unit is used to monitor the document processing status recorded in the document ledger database; the time analysis unit is used to compare the start time of each processing link with the current time to determine whether there is a timeout; the timeout identification unit is used to mark the timeout status on the corresponding record in the document ledger database when a timeout is detected; the notification generation unit is used to generate a reminder text message or notification, the content of which includes detailed information of the timed document and the timed-out person; the communication interface unit is used to send a reminder text message or notification to the timed-out person through the collaborative office platform or the external communication network; the feedback receiving unit is used to receive the response of the timed-out person to the reminder text message or notification, and update the processing status in the document ledger database; the exception handling unit is used to execute a predetermined exception handling strategy when the reminder fails to be sent or no feedback is received, including retrying to send, recording a log or notifying an administrator.

7. The automatic control system for power document circulation based on collaborative office platform according to claim 1 is characterized in that: The document processing report module includes: a data aggregation unit, a report template generation unit, a report filling unit, a date and time processing unit, a report formatting unit, a report export unit, a report distribution unit, a report archiving unit and a user feedback collection unit; The data aggregation unit is used to collect data related to document processing from the document ledger database, including the number of documents received, the number of documents being processed, and the number of documents overdue. The report template generation unit is used to generate a template for a document processing report according to a predefined report format. The report filling unit is used to fill the collected data into the report template to generate complete report content. The date and time processing unit is used to obtain and format the specific date and time of report generation to ensure the timeliness of the report. The report formatting unit is used to format the generated report, including text typesetting, chart insertion and page layout. The report export unit is used to export the generated report into different formats, including PDF, Word or Excel. The report distribution unit is used to automatically distribute the generated report to predetermined recipients, including system administrators, department heads or relevant personnel. The report archiving unit is used to archive the generated report to a specified storage location, including local storage or cloud storage service, to facilitate historical record query and analysis. The user feedback collection unit is used to collect user feedback on the report.

8. An automatic control method for power document circulation based on a collaborative office platform, based on any one of the automatic control systems for document circulation based on a collaborative office platform described in claims 1-7, characterized in that: The following steps are involved: S1. Load the preset clerical account credentials and ensure that the credentials are securely stored in the encrypted database; configure the target URL to point to the login page of the collaborative office platform and automatically open the page, initialize the official document ledger database, including creating sub-databases of official documents being processed and completed, and design a data model to store detailed information of official documents; S2, automatically fill in the login form, including the username and password fields, submit the login form to trigger the login process, establish and maintain a session with the collaborative office platform after successful login, monitor the login process, capture and handle any errors or exceptions, and execute predetermined policies such as retrying login or logging error information; S3. Use text matching or HTML element positioning technology to identify the part of the collaborative office platform used to receive official documents, simulate user click operations, select the "Receive Internet Official Documents" option, process the dialog box that pops up when receiving official documents, automatically enter the password and confirm the operation, extract detailed information of the official document from the collaborative office platform, including the source unit and receipt number, convert the extracted official document information into a predetermined format, and store it in the official document ledger database.

9. The method for automatic control of power document circulation based on collaborative office platform according to claim 8 is characterized in that: It also includes document record maintenance, monitoring and reminders: Update records in the official document database to reflect the latest processing status of official documents, respond to query requests from other modules of the system, and retrieve and return specific official document records; The timeout check process is triggered at the preset time interval, the document processing status recorded in the document ledger database is monitored, and the start time of each processing link is compared with the current time to determine whether there is a timeout. When a timeout is detected, a reminder SMS or notification is generated, and the reminder SMS or notification is sent to the timeout personnel through the collaborative office platform. The response of the timeout personnel to the reminder SMS or notification is received, and the processing status in the document ledger database is updated. When the reminder fails or no feedback is received, the predetermined exception handling strategy is executed.

10. The method for automatic control of power document circulation based on collaborative office platform according to claim 9 is characterized in that: Also includes report generation and distribution: Collect data related to document processing from the document ledger database, create a template for the document processing report, fill the data into the template, obtain and format the specific date and time of report generation, format the generated report, including text typesetting, chart insertion and page layout, export the generated report to different formats, automatically distribute the generated report to the predetermined recipients, and archive the generated report to the specified storage location.

Citation Information

Patent Citations

  • Multi-source log data processing system and method in cloud environment

    CN110727568A

  • Data circulation classification management method and system

    CN113407502A