Work report arrangement method and device and medium

Abstract

The invention discloses a work report arrangement method and device and a medium. The method comprises the following steps: acquiring unread work report mails by using imagplib, and sorting the unread work report mails according to dates; an email library of a mail parser is adopted to parse the text, the filtering signature and the forwarding content of the unread work report mail so as to obtain effective unread work report information; a chapter identifier is adopted, a preset chapter title in the effective unread work report information is subjected to regular matching, and the content of each chapter is obtained; performing key sentence extraction on the content of each chapter by using a domain entity recognition model constructed by a natural language understanding technology to obtain key sentences of the content of each chapter; and writing the key sentences into a pre-designed Excel work report template according to the content of each chapter to obtain work report archiving information.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and more particularly, to a method, device and medium for organizing work reports. Background Art

[0002] Weekly work reports, which include work plans, summaries, and responses to supervisors, are applicable to a variety of organizations, including companies, departments, teams, social groups, and project teams. They are one of the most common organizational management methods. For example, within a team, weekly reports require a dedicated person to transcribe key content, record important details, and archive them. This is labor-intensive and can lead to technical inefficiencies. Summary of the Invention

[0003] In view of the deficiencies in the prior art, the present invention provides a method, device and medium for organizing work reports.

[0004] According to one aspect of the present invention, a method for collating a work report is provided, comprising:

[0005] Use imaplib to obtain unread work report emails and sort them by date;

[0006] Use the email parser's email library to parse the body of the unread work report email, filter the signature and forwarding content to obtain valid unread work report information;

[0007] Use chapter identifier to match the preset chapter titles in the valid unread work report information with regular expressions to obtain the content of each chapter;

[0008] The domain entity recognition model built using natural language understanding technology is used to extract key sentences from the content of each chapter to obtain the key sentences of each chapter;

[0009] The key sentences of each chapter content are written into the pre-designed Excel work report template to obtain the work report archiving information.

[0010] Optionally, preset chapter titles include: current work, next plan, and existing problems.

[0011] Optionally, a domain entity recognition model built using natural language understanding technology is used to extract key sentences from the content of each chapter to obtain key sentences of the content of each chapter, including:

[0012] Use custom rules to filter irrelevant content in each chapter to obtain the valid content of each chapter;

[0013] An entity recognition model is used to identify key sentences in the effective content of each chapter, including time, project, and progress keywords. A Fine-tune BERT classifier is used to determine the content type of each key sentence.

[0014] Optionally, the Excel work report template includes fields such as date, project name, current progress, risk item, person in charge, and any combination of project managers.

[0015] Optionally, it also includes: setting an automatic reminder function to notify the corresponding person in charge of the work report archiving information.

[0016] According to another aspect of the present invention, there is provided a device for collating work reports, comprising:

[0017] The acquisition module is used to use imaplib to obtain unread work report emails and sort the unread work report emails by date;

[0018] The parsing module is used to parse the body of the unread work report email using the email parser's email library, filter the signature and forwarding content, and obtain valid unread work report information;

[0019] A matching module is used to use a chapter identifier to match the preset chapter titles in the valid unread work report information with regular expressions to obtain the content of each chapter;

[0020] The extraction module is used to extract key sentences from the content of each chapter using a domain entity recognition model built using natural language understanding technology to obtain the key sentences of each chapter;

[0021] The writing module is used to write the pre-designed Excel work report template according to the key sentences of the content of each chapter to obtain the work report archiving information.

[0022] According to another aspect of the present invention, a computer-readable storage medium is provided, wherein the storage medium stores a computer program, and the computer program is used to execute the method according to any one of the above aspects of the present invention.

[0023] According to another aspect of the present invention, an electronic device is provided, comprising: a processor; a memory for storing instructions executable by the processor; and the processor for reading the executable instructions from the memory and executing the instructions to implement the method described in any one of the above aspects of the present invention.

[0024] Therefore, advanced natural language processing technology can better understand the context and semantics of weekly reports, extracting key information and themes rather than simply matching keywords. This reduces labor costs. Through code execution, only a few minutes of code execution and acceptance are required per person each week, improving execution efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] A more complete understanding of exemplary embodiments of the present invention may be obtained by referring to the following drawings:

[0026] Figure 1 is a flow chart of a method for organizing work reports provided by an exemplary embodiment of the present invention;

[0027] Figure 2 It is a structural diagram of a device for organizing work reports provided by an exemplary embodiment of the present invention;

[0028] Figure 3 This is a structure of an electronic device provided by an exemplary embodiment of the present invention. DETAILED DESCRIPTION

[0029] Below, the exemplary embodiments according to the present invention will be described in detail with reference to the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all the embodiments of the present invention, and it should be understood that the present invention is not limited to the exemplary embodiments described herein.

[0030] It should be noted that the relative arrangement of components and steps, the numerical expressions and numerical values ​​set forth in these embodiments do not limit the scope of the present invention unless specifically stated otherwise.

[0031] Those skilled in the art will understand that the terms "first" and "second" in the embodiments of the present invention are only used to distinguish different steps, devices or modules, and neither represent any specific technical meaning nor indicate the necessary logical order between them.

[0032] It should also be understood that, in the embodiments of the present invention, “a plurality of” may refer to two or more than two, and “at least one” may refer to one, two or more than two.

[0033] It should also be understood that any component, data or structure mentioned in the embodiments of the present invention can generally be understood as one or more, unless explicitly limited or otherwise indicated in the context.

[0034] In addition, the term "and / or" in this invention merely describes an association relationship between related objects, indicating that three possible relationships exist. For example, A and / or B can represent: A exists alone, A and B exist simultaneously, and B exists alone. Furthermore, the character " / " in this invention generally indicates that the related objects are in an "or" relationship.

[0035] It should also be understood that the description of the various embodiments of the present invention focuses on the differences between the various embodiments, and the same or similar aspects thereof can be referenced with each other. For the sake of brevity, they will not be described one by one.

[0036] At the same time, it should be understood that for the convenience of description, the sizes of the various parts shown in the drawings are not drawn according to the actual proportional relationship.

[0037] The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way intended to limit the invention, its application, or uses.

[0038] Technologies, methods, and equipment known to ordinary technicians in the relevant art may not be discussed in detail, but where appropriate, the technologies, methods, and equipment should be considered part of the specification.

[0039] It should be noted that like reference numerals and letters refer to like items in the following figures, and therefore, once an item is defined in one figure, it need not be further discussed in subsequent figures.

[0040] Embodiments of the present invention can be applied to electronic devices such as terminal devices, computer systems, and servers, and can operate in conjunction with numerous other general-purpose or specialized computing system environments or configurations. Examples of well-known terminal devices, computing systems, environments, and / or configurations suitable for use with terminal devices, computer systems, servers, and other electronic devices include, but are not limited to, personal computer systems, server computer systems, thin clients, thick clients, handheld or laptop devices, microprocessor-based systems, set-top boxes, programmable consumer electronics, network personal computers, minicomputer systems, mainframe computer systems, and distributed cloud computing technology environments including any of the above.

[0041] Electronic devices such as terminal devices, computer systems, and servers can be described in the general context of computer system-executable instructions (such as program modules) executed by a computer system. Generally, program modules can include routines, programs, object programs, components, logic, data structures, etc., which perform specific tasks or implement specific abstract data types. Computer systems / servers can be implemented in a distributed cloud computing environment, where tasks are performed by remote processing devices linked via a communication network. In a distributed cloud computing environment, program modules can be located on local or remote computing system storage media, including storage devices.

[0042] Exemplary Methods

[0043] Figure 1 This is a flow chart of a method for organizing work reports provided by an exemplary embodiment of the present invention. This embodiment can be applied to electronic devices, such as Figure 1 As shown, the method 100 for arranging a work report includes the following steps:

[0044] Step 101: Use imaplib to obtain unread work report emails and sort the unread work report emails by date;

[0045] Step 102: using the email library of the email parser to parse the body of the unread work report email, filtering the signature and forwarding content to obtain valid unread work report information;

[0046] Step 103: Using a chapter identifier, a regular expression is used to match the preset chapter titles in the valid unread work report information to obtain the content of each chapter;

[0047] Step 104: extract key sentences from the contents of each chapter using a domain entity recognition model built using natural language understanding technology to obtain key sentences from the contents of each chapter;

[0048] Step 105: Write the key sentences of each chapter into a pre-designed Excel work report template to obtain work report archiving information.

[0049] Specifically, in response to the technical problems existing in the prior art, the present invention first identifies which part of the weekly report needs to be excerpted, and then extracts key content from this part.

[0050] Solution:

[0051] 1. Build a Python environment, install Anaconda+PyCharm, and create a virtual environment python3.8+.

[0052] 2. Install the core libraries: pip install pandas openpyxl nltk spacy transformers.

[0053] 3. Download the NLP model python-m spacy download zh_core_web_lg (Chinese semantic understanding model).

[0054] 4. Create the project structure: / config (configuration file), / data (original email), / output (generated report), main.py (main program).

[0055] 5. Configure the email link: Set the IMAP server address, email account password, and target email folder in config.json.

[0056] 6. Write an email retrieval module, use imaplib to get unread weekly emails, and sort them by date.

[0057] 7. Design an email parser, use the email library to parse the email body, and filter the signature / forwarded content.

[0058] 8. Build a chapter identifier and use regular expressions to match chapter titles such as "This week's work | Next week's plan | Existing problems".

[0059] 9. Develop the NLP processing layer (natural language understanding): use spacy for entity recognition, use the BERT model to extract key sentences, and use custom rules to filter irrelevant content.

[0060] 10. Use natural language understanding technology to build a domain entity recognition model. For each chapter: extract key sentences containing time / project / progress, and use the Fine-tune BERT classifier to determine the type of content in each paragraph.

[0061] 11. Design an Excel template that includes the following fields: date, project name, current progress, risk items, person in charge, and project manager.

[0062] 12. Implement data writing using openpyxl: automatically create weekly worksheets and archive by time dimension.

[0063] 13. Add automatic reminder, which will run automatically at 10 am every Monday and notify the corresponding person in charge by email.

[0064] Therefore, advanced natural language processing technology can better understand the context and semantics of weekly reports, extracting key information and themes rather than simply matching keywords. This reduces labor costs. Through code execution, only a few minutes of code execution and acceptance are required per person each week, improving execution efficiency.

[0065] Exemplary devices

[0066] Figure 2 FIG. 1 is a schematic diagram of a work report arrangement device according to an exemplary embodiment of the present invention. Figure 2 As shown, the apparatus 200 includes:

[0067] An acquisition module 210 is configured to use imaplib to acquire unread work report emails and sort the unread work report emails by date;

[0068] Parsing module 220, configured to parse the body of the unread work report email using the email library of the email parser, filter the signature and forwarding content, and obtain valid unread work report information;

[0069] Matching module 230, for using a chapter identifier to match preset chapter titles in the valid unread work report information with regular expressions to obtain the content of each chapter;

[0070] Extraction module 240, configured to extract key sentences from each chapter content using a domain entity recognition model built using natural language understanding technology to obtain key sentences from each chapter content;

[0071] The writing module 250 is used to write the key sentences of each chapter into a pre-designed Excel work report template to obtain work report archiving information.

[0072] Optionally, preset chapter titles include: current work, next plan, and existing problems.

[0073] Optionally, the extraction module 240 includes:

[0074] The filtering submodule is used to filter irrelevant content in each chapter using custom rules to obtain the valid content of each chapter;

[0075] The recognition submodule is used to use the entity recognition model to identify key sentences in the effective content of each chapter. The key sentences include time, project, and progress keywords, and the Fine-tune BERT classifier is used to determine the content type of each key sentence.

[0076] Optionally, the Excel work report template includes fields such as date, project name, current progress, risk item, person in charge, and any combination of project managers.

[0077] Optionally, the device 200 further includes: a setting module, configured to set an automatic reminder function to notify a corresponding person in charge of the work report archiving information.

[0078] Exemplary electronic devices

[0079] Figure 3 This is the structure of an electronic device provided by an exemplary embodiment of the present invention. Figure 3 As shown, the electronic device 30 includes one or more processors 31 and a memory 32 .

[0080] The processor 31 may be a central processing unit (CPU) or other forms of processing units having data processing capabilities and / or instruction execution capabilities, and may control other components in the electronic device to perform desired functions.

[0081] The memory 32 may include one or more computer program products, which may include various forms of computer-readable storage media, such as volatile memory and / or non-volatile memory. The volatile memory may, for example, include random access memory (RAM) and / or cache memory (cache), etc. The non-volatile memory may, for example, include read-only memory (ROM), a hard disk, a flash memory, etc. One or more computer program instructions may be stored on the computer-readable storage medium, and the processor 31 may execute the program instructions to implement the methods of the software programs of the various embodiments of the present invention described above and / or other desired functions. In one example, the electronic device may further include: an input device 33 and an output device 34, which are interconnected via a bus system and / or other forms of connection mechanisms (not shown).

[0082] In addition, the input device 33 may also include, for example, a keyboard, a mouse, and the like.

[0083] The output device 34 can output various information to the outside. The output device 34 can include, for example, a display, a speaker, a printer, a communication network and a remote output device connected thereto.

[0084] Of course, to simplify, Figure 3 Only some of the components related to the present invention in the electronic device are shown, and components such as a bus, an input / output interface, etc. are omitted. In addition, the electronic device may further include any other appropriate components according to specific application scenarios.

[0085] Exemplary computer program products and computer-readable storage media

[0086] In addition to the above-mentioned methods and devices, an embodiment of the present invention may also be a computer program product, which includes computer program instructions, which, when executed by a processor, enable the processor to perform the steps of the method according to various embodiments of the present invention described in the above "Exemplary Method" section of this specification.

[0087] The computer program product may be written in any combination of one or more programming languages ​​to implement the operations of embodiments of the present invention, including object-oriented programming languages ​​such as Java, C++, and conventional procedural programming languages ​​such as C or similar programming languages. The program code may be executed entirely on the user's computing device, partially on the user's computing device, as a stand-alone software package, partially on the user's computing device and partially on a remote computing device, or entirely on a remote computing device or server.

[0088] In addition, an embodiment of the present invention may also be a computer-readable storage medium having computer program instructions stored thereon, which, when executed by a processor, causes the processor to execute the steps of the method for information mining of historical change records according to various embodiments of the present invention described in the above "Exemplary Method" section of this specification.

[0089] The computer-readable storage medium can adopt any combination of one or more readable media. The readable medium can be a readable signal medium or a readable storage medium. The readable storage medium can, for example, include but is not limited to a system, system or device of electricity, magnetism, light, electromagnetic, infrared, or semiconductor, or any combination thereof. More specific examples (non-exhaustive list) of readable storage media include: an electrical connection with one or more wires, a portable disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof.

[0090] The basic principles of the present invention have been described above in conjunction with specific embodiments. However, it should be noted that the advantages, strengths, and effects mentioned in the present invention are merely illustrative and non-limiting, and should not be construed as necessarily possessed by each embodiment of the present invention. Furthermore, the specific details disclosed above are provided for illustrative purposes and to facilitate understanding, and are not intended to be limiting. These details do not necessarily limit the present invention to being implemented using these specific details.

[0091] Each embodiment in this specification is described in a progressive manner, with each embodiment focusing on its differences from the other embodiments. Reference can be made to the descriptions of the identical or similar parts between the various embodiments. For system embodiments, since they are essentially identical to the method embodiments, their description is relatively simple. For relevant parts, refer to the descriptions of the method embodiments.

[0092] The block diagrams of the devices, systems, equipment, and systems involved in the present invention are merely illustrative examples and are not intended to require or imply that they must be connected, arranged, or configured in the manner shown in the block diagrams. As will be appreciated by those skilled in the art, these devices, systems, equipment, and systems can be connected, arranged, or configured in any manner. Words such as "including," "comprising," "having," and the like are open-ended words, meaning "including but not limited to," and can be used interchangeably therewith. The words "or" and "and" used herein refer to the words "and / or" and can be used interchangeably therewith, unless the context clearly indicates otherwise. The word "such as" used herein refers to the phrase "such as but not limited to," and can be used interchangeably therewith.

[0093] The method and system of the present invention may be implemented in many ways. For example, the method and system of the present invention may be implemented by software, hardware, firmware, or any combination of software, hardware, and firmware. The above sequence of steps for the method is for illustration only, and the steps of the method of the present invention are not limited to the sequence specifically described above, unless otherwise specified. In addition, in some embodiments, the present invention may also be implemented as a program recorded in a recording medium, which includes machine-readable instructions for implementing the method according to the present invention. Thus, the present invention also covers recording media that store programs for executing the method according to the present invention.

[0094] It should also be noted that, in the system, device and method of the present invention, each component or each step can be decomposed and / or recombined. These decompositions and / or recombinations should be regarded as equivalent schemes of the present invention. The above description of the disclosed aspects is provided to enable any technician in this field to make or use the present invention. Various modifications to these aspects will be very obvious to those skilled in the art, and the general principles defined here can be applied to other aspects without departing from the scope of the present invention. Therefore, the present invention is not intended to be limited to the aspects shown here, but according to the widest scope consistent with the principles disclosed here and novel features.

[0095] The above description has been provided for the purpose of illustration and description. Furthermore, this description is not intended to limit the embodiments of the present invention to the forms disclosed herein. Although a number of example aspects and embodiments have been discussed above, those skilled in the art will recognize certain variations, modifications, alterations, additions, and sub-combinations thereof.

Claims

1. A method for arranging a work report, characterized in that: include: Use imaplib to obtain unread work report emails and sort them by date; The email library of the email parser is used to parse the body of the unread work report email, filter the signature and forwarding content, and obtain valid unread work report information; Using a chapter identifier, using regular expressions to match preset chapter titles in the valid unread work report information to obtain the content of each chapter; The domain entity recognition model built using natural language understanding technology is used to extract key sentences from the content of each chapter to obtain the key sentences of each chapter; The key sentences of each chapter content are written into the pre-designed Excel work report template to obtain the work report archiving information.

2. The method according to claim 1, characterized in that The preset chapter titles include: current work, next period plan and existing problems.

3. The method according to claim 1, characterized in that The domain entity recognition model built using natural language understanding technology extracts key sentences from each chapter to obtain the key sentences of each chapter, including: Use custom rules to filter irrelevant content in each chapter to obtain the valid content of each chapter; An entity recognition model is used to identify key sentences in the effective content of each chapter, including time, project, and progress keywords, and a Fine-tune BERT classifier is used to determine the content type of each key sentence.

4. The method according to claim 1, wherein The Excel work report template includes fields: date, project name, current progress, risk items, person in charge and any combination of project managers.

5. The method according to claim 4, characterized in that Also includes: Set up an automatic reminder function to notify the corresponding person in charge of the work report archiving information.

6. A device for organizing work reports, characterized in that: include: The acquisition module is used to use imaplib to obtain unread work report emails and sort the unread work report emails by date; A parsing module, configured to parse the body of the unread work report email using an email parser's email library, filter the signature and forwarded content, and obtain valid unread work report information; A matching module, configured to use a chapter identifier to match preset chapter titles in the valid unread work report information with regular expressions to obtain the contents of each chapter; The extraction module is used to extract key sentences from the content of each chapter using a domain entity recognition model built using natural language understanding technology to obtain the key sentences of each chapter; The writing module is used to write the pre-designed Excel work report template according to the key sentences of the content of each chapter to obtain the work report archiving information.

7. The method according to claim 6, characterized in that The preset chapter titles include: current work, next period plan and existing problems.

8. The method according to claim 6, characterized in that Extraction modules, including: The filtering submodule is used to filter irrelevant content in each chapter using custom rules to obtain the valid content of each chapter; The recognition submodule is used to use the entity recognition model to identify key sentences in the effective content of each chapter, including time, project, and progress keywords, and use the Fine-tune BERT classifier to determine the content type of each key sentence.

9. A computer-readable storage medium, characterized in that The storage medium stores a computer program, and the computer program is used to execute the method according to any one of claims 1 to 5.

10. An electronic device, characterized in that: The electronic device comprises: processor; a memory for storing instructions executable by the processor; The processor is configured to read the executable instructions from the memory and execute the instructions to implement the method according to any one of claims 1 to 5.

Images