Method, device, electronic device and storage medium for associating received emails with work orders

Abstract

The present disclosure provides a method, device, electronic device and storage medium for associating received emails with work orders, the method comprising: obtaining received emails to be processed; determining whether the recipient mailbox of the received emails to be processed includes a fault reporting mailbox; if the recipient mailbox includes a fault reporting mailbox, determining whether at least one recipient mailbox included in the work order email association table includes the sender mailbox of the received emails to be processed; if at least one recipient mailbox includes the sender mailbox, determining whether the email subject of the received emails to be processed includes one or more email subjects in at least one email subject; if the email subject of the received emails to be processed includes one or more email subjects in at least one email subject, adding the email-related content of the received emails to be processed and the first work order number to the work order email association table. In this way, the association relationship between the work order and the email can be automatically established, which is conducive to improving the efficiency of work order processing.

Description

Background Art

[0002] After-sales troubleshooting is an important part of the field of operational technology. Usually, when a customer discovers a product failure, they will generate a corresponding work order based on the failure and send a fault reporting email to the supplier involved in the product in order to obtain the supplier's help.

[0003] In related technologies, after a customer discovers a product failure, a work order corresponding to the failure is generated and the work order is handed over to manual processing. After receiving the work order, the work order processing personnel send a fault reporting email to the product supplier and monitor the email exchanges with the supplier in order to obtain the supplier's feedback email in a timely manner, and then process the work order according to the help in the email.

[0004] The work order handlers monitor the email exchanges with suppliers in real time during the process of processing work orders. They need to frequently search for reply emails from suppliers among the received emails, which wastes their time and energy and results in low work order processing efficiency.

[0005] It should be noted that the information disclosed in the above background technology section is only used to enhance the understanding of the background of the present disclosure, and therefore may include information that does not constitute the prior art known to ordinary technicians in the field. Summary of the invention

[0006] The present disclosure provides a method, device, electronic device and storage medium for associating received emails with work orders, which at least to a certain extent overcome the problem of low work order processing efficiency caused by the need for work order processing personnel to frequently pay attention to mailboxes in related technologies.

[0007] Other features and advantages of the present disclosure will become apparent from the following detailed description, or may be learned in part by the practice of the present disclosure.

[0008] According to one aspect of the present disclosure, a method for associating received emails with work orders is provided, including: obtaining received emails to be processed; determining whether the recipient mailbox of the received emails to be processed includes a fault reporting mailbox; in a case where the recipient mailbox includes the fault reporting mailbox, determining whether at least one recipient mailbox included in a work order email association table includes the sender mailbox of the received email to be processed; in a case where the at least one recipient mailbox includes the sender mailbox, determining whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject, the at least one email subject includes the email subject corresponding to the target recipient mailbox in the work order email association table, the target recipient mailbox is the recipient mailbox in the at least one recipient mailbox that is the same as the sender mailbox; in a case where the email subject of the received email to be processed includes one or more email subjects in the at least one email subject, adding the email-related content of the received email to be processed and a first work order number to the work order email association table, the first work order number being the work order number corresponding to the one or more email subjects.

[0009] In one embodiment of the present disclosure, it also includes: in a case where the email subject of the received email to be processed does not include the email subject in the at least one email subject, determining whether the email content of the received email to be processed includes one or more email contents in the at least one email content, and the at least one email content includes the email content corresponding to the target recipient mailbox in the work order email association table; in a case where the email content of the received email to be processed includes one or more email contents in the at least one email content, adding the email-related content of the received email to be processed and a second work order number to the work order email association table, and the second work order number is the work order number corresponding to the one or more email contents.

[0010] In one embodiment of the present disclosure, determining whether the email content of the received email to be processed includes one or more email contents in at least one email content includes: formatting the email content of the received email to be processed to obtain the email text to be processed; formatting each email content in the at least one email content to obtain the email text corresponding to each email content; and determining whether the email text to be processed includes one or more email texts in the at least one email text.

[0011] In one embodiment of the present disclosure, it also includes: when the email text to be processed does not include the email text in at least one email text, determining the similarity between each email text and the email text to be processed to obtain at least one similarity value; determining whether the maximum similarity value among the at least one similarity value is greater than a similarity threshold; when the maximum similarity value is greater than the similarity threshold, adding the email-related content and the third work order number of the received email to be processed to the work order email association table, wherein the third work order number is the work order number corresponding to the maximum similarity value.

[0012] In one embodiment of the present disclosure, determining the similarity between each email text and the email text to be processed to obtain at least one similarity value includes: calculating the similarity between each email text and the email text to be processed according to the sequence matcher SequenceMatcher in the difflib module of Python to obtain the at least one similarity value; or calculating the distance between each email text and the email text to be processed according to the edit distance algorithm to obtain the at least one similarity value.

[0013] In one embodiment of the present disclosure, obtaining received emails to be processed includes: obtaining received emails whose email identification ID is greater than an ID threshold from the fault reporting mailbox to obtain received emails to be processed; and using the maximum email ID among the email IDs of the received emails to be processed as a new ID threshold.

[0014] In one embodiment of the present disclosure, it also includes: obtaining the work order to be processed; determining the mailbox to be reported corresponding to the work order to be processed; using the report mailbox as the sender's mailbox, generating and sending a report email corresponding to the work order to be processed to the mailbox to be reported; adding the work order number of the work order to be processed and the email-related content of the report email to the work order email association table.

[0015] According to another aspect of the present disclosure, a device for associating received emails with work orders is provided, including: an acquisition module for acquiring received emails to be processed; a determination module for determining whether the recipient mailbox of the received email to be processed includes a fault reporting mailbox; the determination module is also used to determine whether at least one recipient mailbox included in the work order email association table includes the sender mailbox of the received email to be processed when the recipient mailbox includes the fault reporting mailbox; the determination module is also used to determine whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject when the at least one recipient mailbox includes the sender mailbox, the at least one email subject includes the email subject corresponding to the target recipient mailbox in the work order email association table, the target recipient mailbox is the recipient mailbox in the at least one recipient mailbox that is the same as the sender mailbox; an adding module is used to add the email-related content and the first work order number of the received email to be processed to the work order email association table when the email subject of the received email to be processed includes one or more email subjects in the at least one email subject. The first work order number is the work order number corresponding to the one or more email subjects.

[0016] In one embodiment of the present disclosure, the determination module is further used to determine whether the email content of the received email to be processed includes one or more email contents of at least one email content, when the email subject of the received email to be processed does not include the email subject of the at least one email subject, and the at least one email content includes the email content corresponding to the target recipient's mailbox in the work order email association table; the adding module is further used to add the email-related content and the second work order number of the received email to be processed to the work order email association table, when the email content of the received email to be processed includes one or more email contents of the at least one email content, and the second work order number is the work order number corresponding to the one or more email contents.

[0017] In one embodiment of the present disclosure, the determination module is used to format the email content of the received email to be processed to obtain the email text to be processed; format each email content in the at least one email content to obtain the email text corresponding to each email content; and determine whether the email text to be processed includes one or more email texts in the at least one email text.

[0018] In one embodiment of the present disclosure, the determination module is further used to determine the similarity between each email text and the email text to be processed to obtain at least one similarity value when the email text to be processed does not include the email text in at least one email text; the determination module is further used to determine whether the maximum similarity value among the at least one similarity value is greater than a similarity threshold; the adding module is further used to add the email-related content and the third work order number of the received email to be processed to the work order email association table when the maximum similarity value is greater than the similarity threshold, and the third work order number is the work order number corresponding to the maximum similarity value.

[0019] In one embodiment of the present disclosure, the determination module is used to calculate the similarity between each email text and the email text to be processed according to the sequence matcher SequenceMatcher in the difflib module of Python to obtain the at least one similarity value; or, calculate the distance between each email text and the email text to be processed according to the edit distance algorithm to obtain the at least one similarity value.

[0020] In one embodiment of the present disclosure, the acquisition module is used to obtain received emails whose email identification ID is greater than an ID threshold from the fault reporting mailbox to obtain received emails to be processed; and the maximum email ID among the email IDs of the received emails to be processed is used as the new ID threshold.

[0021] In one embodiment of the present disclosure, the acquisition module is also used to acquire the work order to be processed; the determination module is also used to determine the mailbox to be reported corresponding to the work order to be processed; the device also includes: a generation and sending module, which is used to use the report mailbox as the sender's mailbox, generate and send a report email corresponding to the work order to be processed to the mailbox to be reported; the adding module is also used to add the work order number of the work order to be processed and the email-related content of the report email to the work order email association table.

[0022] According to another aspect of the present disclosure, there is provided an electronic device, comprising: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to execute any of the above-mentioned methods for associating received emails with work orders by executing the executable instructions.

[0023] According to another aspect of the present disclosure, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, any of the above-mentioned methods for associating received emails with work orders is implemented.

[0024] According to another aspect of the present disclosure, a computer program product is provided, the computer program product comprising a computer program or computer instructions, the computer program or the computer instructions being loaded and executed by a processor so as to enable a computer to implement any of the above-mentioned methods for associating received emails with work orders.

[0025] The technical solution provided by the embodiments of the present disclosure includes at least the following beneficial effects:

[0026] The technical solution provided by the embodiment of the present disclosure determines whether the received mail to be processed is a reply mail from the supplier to the fault reporting mail by determining whether the recipient mailbox of the received mail to be processed includes the fault reporting mail, determining whether at least one recipient mailbox included in the work order mail association table includes the sender mailbox of the received mail to be processed, and determining whether the mail subject of the received mail to be processed includes one or more mail subjects in at least one mail subject. In the case where it is determined that the recipient mailbox of the received mail to be processed includes the fault reporting mail, at least one recipient mailbox includes the sender mailbox of the received mail to be processed, and the mail subject of the received mail to be processed includes one or more mail subjects in at least one mail subject, it is determined that the received mail to be processed is a reply mail from the supplier to the fault reporting mail. Then, the mail-related content of the received mail to be processed and the first work order number corresponding to the one or more mail subjects are added to the work order mail association table. In this way, the association relationship between the work order and the mail can be automatically established, so that the reply mail of the supplier can be found through the work order number, avoiding the need for the work order processing personnel to frequently search for the reply mail of the supplier from multiple received mails, which is conducive to improving the work order processing efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] The accompanying drawings herein are incorporated into the specification and constitute a part of the specification, illustrate embodiments consistent with the present disclosure, and together with the specification are used to explain the principles of the present disclosure. Obviously, the accompanying drawings described below are only some embodiments of the present disclosure, and for ordinary technicians in this field, other accompanying drawings can be obtained based on these accompanying drawings without creative work.

[0028] Figure 1 A schematic diagram showing a system for associating received emails with work orders in one embodiment of the present disclosure is shown;

[0029] Figure 2 A flow chart of a method for associating received emails with work orders in one embodiment of the present disclosure is shown;

[0030] Figure 3 A flow chart of a method for associating received emails with work orders in one embodiment of the present disclosure is shown;

[0031] Figure 4A flow chart of a method for associating received emails with work orders in one embodiment of the present disclosure is shown;

[0032] Figure 5 A flow chart of a method for associating received emails with work orders in one embodiment of the present disclosure is shown;

[0033] Figure 6 A schematic diagram of a device for associating received emails with work orders in one embodiment of the present disclosure is shown;

[0034] Figure 7 A structural block diagram of an electronic device in one embodiment of the present disclosure is shown. DETAILED DESCRIPTION

[0035] Example embodiments will now be described more fully with reference to the accompanying drawings. However, example embodiments can be implemented in a variety of forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that the disclosure will be more comprehensive and complete and to fully convey the concepts of the example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.

[0036] In addition, the accompanying drawings are only schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the figures represent the same or similar parts, and their repeated description will be omitted. Some of the block diagrams shown in the accompanying drawings are functional entities and do not necessarily correspond to physically or logically independent entities. These functional entities can be implemented in software form, or implemented in one or more hardware modules or integrated circuits, or implemented in different networks and / or processor devices and / or microcontroller devices.

[0037] It should be understood that the various steps described in the method embodiments of the present disclosure may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this respect.

[0038] It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0039] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0040] Figure 1A schematic diagram of a system for associating received emails with work orders in an embodiment of the present disclosure is shown. The system can apply the method for associating received emails with work orders or the device for associating received emails with work orders in various embodiments of the present disclosure.

[0041] like Figure 1 As shown, the received email associated work order system may include: a customer device 101 and a supplier device 102 .

[0042] Among them, the customer device 101 can send emails to the supplier mailbox of the supplier device 102 through the fault reporting mailbox, and the customer device 101 can also receive emails sent by the supplier device 102 through the supplier mailbox through the fault reporting mailbox.

[0043] The client device 101 can obtain the pending work order, automatically generate a fault report email according to the pending work order, and send the fault report email to the pending fault report email (supplier email) corresponding to the pending work order. Afterwards, the client device 101 can add the email-related content of the fault report email and the work order number of the pending work order to the work order email association table.

[0044] The client device 101 can log in to the fault reporting mailbox at set intervals, read the newly received pending received emails, and determine whether the pending received emails are the supplier's reply emails to the fault reporting emails or related emails (the correspondence emails corresponding to the fault reporting emails). The client device 101 can also add the email-related content of the pending received emails and the corresponding work order number to the work order email association table when determining that the pending received emails are the supplier's reply emails to the fault reporting emails or related emails. The work order email association table records the work order number and the email-related content of the corresponding fault reporting email, as well as the work order number and the email-related content of the related emails.

[0045] In one embodiment, the client device 101 can determine whether the received email to be processed is a reply email to the fault report email or a reply email to a related email based on the recipient, sender and email subject of the received email to be processed.

[0046] In another embodiment, the client device 101 can determine whether the received email to be processed is a reply email to the fault report email or a reply email to a related email based on the recipient, sender, email subject and email content of the received email to be processed.

[0047] The client device 101 and the provider device 102 are connected to each other through a network, which may be a wired network or a wireless network.

[0048] Optionally, the wireless network or wired network described above uses standard communication technology and / or protocol. The network is usually the Internet, but it can also be any network, including but not limited to a local area network (LAN), a metropolitan area network (MAN), a wide area network (WAN), a mobile, wired or wireless network, a dedicated network or any combination of a virtual private network). In some embodiments, technologies and / or formats including Hyper Text Mark-up Language (HTML), Extensible Markup Language (XML), etc. are used to represent data exchanged through the network. In addition, conventional encryption technologies such as Secure Socket Layer (SSL), Transport Layer Security (TLS), Virtual Private Network (VPN), Internet Protocol Security (IPsec) can also be used to encrypt all or some links. In other embodiments, customized and / or dedicated data communication technologies can also be used to replace or supplement the above data communication technologies.

[0049] Both the customer device 101 and the provider device 102 may be various electronic devices, including but not limited to smart phones, tablet computers, laptop computers, desktop computers, wearable devices, etc.

[0050] Both the client device 101 and the provider device 102 can be servers that provide various services. The server can be an independent physical server, a server cluster or a distributed system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN (Content Delivery Network), and big data and artificial intelligence platforms.

[0051] Those skilled in the art will know that Figure 1 The number of the supplier devices 102 in the figure is only for illustration, and any number of supplier devices may be provided according to actual needs, which is not limited in the embodiment of the present disclosure.

[0052] The present exemplary implementation is described in detail below with reference to the accompanying drawings and embodiments.

[0053] In an embodiment of the present disclosure, a method for associating a received email with a work order is provided, and the method can be executed by any electronic device with computing and processing capabilities. For example, the electronic device is a client device.

[0054] Figure 2 A flow chart of a method for associating received emails with work orders in one embodiment of the present disclosure is shown as follows: Figure 2 As shown, the method for associating received emails with work orders provided in the embodiment of the present disclosure includes the following S201 to S205.

[0055] S201, obtaining received emails to be processed.

[0056] Among them, the received mails to be processed are mails received by the fault reporting mailbox, and the mails have not been identified as fault reporting mails or reply mails to related mails. Among them, the fault reporting mails are mails sent from the fault reporting mailbox to the supplier mailbox to report product failures. Related mails are mails between the fault reporting mailbox and the supplier mailbox, which are replied one or more times based on the fault reporting mails.

[0057] In one embodiment, each received email corresponds to an email ID (identifier). For example, the email ID of a certain email is 65535. In one embodiment, obtaining received emails to be processed may include: obtaining received emails whose email IDs are greater than an ID threshold from the fault reporting mailbox to obtain received emails to be processed; and using the maximum email ID among the email IDs of the received emails to be processed as the new ID threshold. By using the maximum email ID among the email IDs corresponding to the received emails to be processed obtained last time as the ID threshold, when obtaining the received emails to be processed this time, obtaining the received emails whose email IDs are greater than the ID threshold as the received emails to be processed can avoid repeated acquisition of received emails, thereby avoiding wasting computing resources by performing subsequent processing based on the repeatedly obtained received emails.

[0058] In another embodiment, received emails whose receiving time is later than the latest receiving time may also be obtained, where the latest receiving time is the latest receiving time among the receiving times corresponding to the received emails to be processed obtained last time, thereby avoiding repeated acquisition of the same received email.

[0059] In one embodiment, the client device obtains the pending received emails from the fault reporting mailbox once every set time interval, and performs subsequent processing based on the obtained pending received emails. The embodiment of the present disclosure does not limit the specific value of the set time. For example, the set time is 5 minutes.

[0060] The disclosed embodiment does not limit how to obtain the pending received emails from the fault reporting mailbox once at a set interval. For example, the Scheduled (a timed project under Spring Boot) of Spring Boot (a framework for application development) can be used to obtain the pending received emails from the fault reporting mailbox once at a set interval.

[0061] The received emails to be processed may be reply emails to the problem reporting emails or related emails, or emails unrelated to the problem reporting emails or related emails.

[0062] S202, determining whether the recipient mailboxes of the received mails to be processed include a fault reporting mailbox.

[0063] The recipient mailboxes of the received mails to be processed may include multiple mailboxes or one mailbox, which is not limited in the embodiments of the present disclosure.

[0064] If the number of received emails to be processed obtained in S201 is one or more, the client device can use Spring Boot's Async (an asynchronous project under Spring Boot) to implement asynchronous multi-threading to simultaneously process multiple received emails to be processed, thereby improving the processing efficiency of the received emails to be processed.

[0065] Among them, the client device stores a fault reporting mailbox, and the client device can directly use the fault reporting mailbox to perform judgment operations or other operations. For example, the fault reporting mailbox is used to identify whether the recipient mailbox of a certain email includes a fault reporting mailbox. The disclosed embodiment does not limit how to determine whether the recipient mailbox of the received email to be processed includes a fault reporting mailbox. For example, StringUtils (a string tool) of Java (a computer language) can be used to determine whether the recipient mailbox of the received email to be processed includes a fault reporting mailbox.

[0066] By determining whether the recipient of the pending received mail is a problem reporting mailbox, you can preliminarily filter out the reply mails that are not problem reporting mails or related mails in the pending received mails. If the recipient of the pending received mail does not include the problem reporting mailbox, you can determine that the pending received mail is not a reply mail from the supplier mailbox to the problem reporting mail or related mail. If the pending received mail is not a reply mail from the supplier mailbox to the problem reporting mail or related mail, you can stop processing the pending received mail, wait for a new pending received mail to be obtained, and then process the new pending received mail. After obtaining the pending received mail, first determine whether the recipient mailbox of the pending received mail includes the problem reporting mailbox, which can avoid wasting computing resources to a certain extent.

[0067] S203, when the recipient mailbox includes a fault reporting mailbox, determine whether at least one recipient mailbox included in the work order email association table includes the sender mailbox of the received email to be processed.

[0068] Among them, the recipient mailbox refers to the recipient mailbox of the received email to be processed; the work order email association table is a table pre-created in the customer device / database, and the columns of the work order email association table include: work order number, sender email, recipient email, email subject and email content, or, the columns of the work order email association table include: work order number, sender email, recipient email, email subject, email content and time (used to record the time of adding email-related content, and the email-related content includes the sender email, recipient email, email subject and email content of the email).

[0069] Taking the work order email association table as an example, the columns include: work order number, sender email, recipient email, email subject, email content and time, a work order email association table can be shown as Table 1.

[0070] Table 1

[0071] Work Order Number Sender's Email Recipient's Email Email Subject Email Content time Work Order No. 1 Fault reporting mailbox Supplier Email 1 Theme 1 Main text 1 T1 Work Order No. 2 Fault reporting mailbox Supplier Email 2 Theme 2 Main text 2 T2

[0072] In one embodiment, before using the work order email association table to perform S203, it also includes: obtaining the work order to be processed; determining the mailbox to be reported corresponding to the work order to be processed; using the report mailbox as the sender's mailbox, generating and sending the report email corresponding to the work order to be processed to the mailbox to be reported; adding the work order number of the work order to be processed and the email-related content of the report email to the work order email association table.

[0073] After a product failure occurs, the customer device can obtain the pending work order corresponding to the failure, and then find the correspondence between the product and supplier information based on the product information involved in the pending work order, and determine the mailbox to be reported (supplier mailbox). After querying the mailbox to be reported, the customer device uses the failure report mailbox as the sender mailbox, generates and sends a failure report email corresponding to the pending work order to the pending failure report mailbox, and then the customer device adds the work order number of the pending work order and the email-related content of the failure report email to the work order email association table. Therefore, if the pending received email is a reply email from the supplier mailbox to the failure report email or related emails, then at least one recipient mailbox in the work order email association table includes the sender mailbox of the pending received email. If the at least one recipient mailbox does not include the sender mailbox of the pending received email, it means that the pending received email is not a reply email from the supplier mailbox to the failure report email or related emails. Feedback to the failure report mailbox.

[0074] The disclosed embodiment does not limit how to determine whether at least one recipient mailbox included in the work order email association table includes the sender mailbox of the received email to be processed. For example, a SQL (Structured Query Language) fuzzy query method can be used to determine whether at least one recipient mailbox included in the work order email association table includes the sender mailbox of the received email to be processed.

[0075] In the case where the recipients of the received emails to be processed include the mailbox for reporting the problem, by further determining whether at least one recipient mailbox included in the work order email association table includes the sender mailbox of the received emails to be processed, when at least one recipient mailbox does not include the sender mailbox of the received emails to be processed, it can be determined that the received emails to be processed are not reply emails from the supplier mailbox to the fault reporting emails or related email feedback, and there is no need to perform subsequent processing on the received emails to be processed, thus avoiding the waste of computing resources and improving the utilization of computing resources. By combining the two steps S202 and S203, a large number of emails that are not related to the fault reporting emails can be screened out, greatly avoiding the waste of computing resources.

[0076] S204, when at least one recipient mailbox includes the sender mailbox, determine whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject, at least one email subject includes the email subject corresponding to the target recipient mailbox in the work order email association table, and the target recipient mailbox is the recipient mailbox in at least one recipient mailbox that is the same as the sender mailbox.

[0077] Among them, at least one recipient mailbox is a recipient mailbox included in the work order email association table, and the sender mailbox is the sender mailbox of the received email to be processed.

[0078] For example, a work order email association table can be shown as Table 2.

[0079] Table 2

[0080] Work Order Number Sender's Email Recipient's Email Email Subject Email Content time Work Order No. 1 Fault reporting mailbox Supplier Email 1 Theme 1 Main text 1 T1 Work Order No. 2 Fault reporting mailbox Supplier Email 2 Theme 2 Main text 2 T2 Work Order No. 2 Supplier Email 2 Fault reporting mailbox Theme 3 Text 3 T3 Work Order No. 2 Fault reporting mailbox Supplier Email 2 Theme 4 Text 4 T4 Work Order No. 1 Supplier Email 1 Fault reporting mailbox Theme 5 Text 5 T5 Work Order No. 2 Supplier Email 2 Fault reporting mailbox Theme 6 Text 6 T6

[0081] For example, if the sender's mailbox of the received email to be processed is supplier mailbox 2 in Table 2, the target recipient mailbox is the same mailbox as supplier mailbox 2 in the recipient mailbox column of the work order email association table. Accordingly, at least one email subject corresponding to the target recipient mailbox includes: subject 2 and subject 4.

[0082] In some embodiments, the client device automatically adds the mailbox-related content and the corresponding work order number of the relevant email fed back by the fault reporting mailbox to the supplier mailbox to the work order email association table. For example, in Table 2, the email corresponding to Topic 2 is the fault reporting email sent by the client device to the supplier mailbox 2 through the fault reporting mailbox, and the email corresponding to Topic 3 is the reply email of the supplier mailbox 2 to the fault reporting email. The email corresponding to Topic 4 is the reply email of the fault reporting mailbox to the relevant email corresponding to Topic 3, that is, the email corresponding to Topic 4 is the relevant email sent by the fault reporting mailbox to the supplier mailbox 2, and the client device can automatically add the email-related content and the work order number corresponding to Topic 4 to the work order email association table.

[0083] Usually, the subject format of the reply email is "RE: XXX", or "Reply: XXX". Among them, "XXX" is the subject of the replied email. Therefore, the email subject of the reply email usually includes the email subject of the replied email. If the received email to be processed is a reply email to a problem reporting email or a related email, then the email subject of the received email to be processed includes the email subject of the problem reporting email or the related email. In the case that the email subject of the received email to be processed includes one or more email subjects in at least one email subject, it can be determined that the received email to be processed is a reply email to the problem reporting email or the related email. For example, the email corresponding to subject 3 in Table 2 is a reply email to the email corresponding to subject 2, and the format of subject 3 can be "RE: Subject 2" or "Reply: Subject 2". Accordingly, subject 3 includes subject 2, and then it can be determined that the email corresponding to subject 3 is a reply email to the problem reporting email or the related email. For another example, the email corresponding to topic 6 in Table 2 is a reply email to the email corresponding to topic 4, and the email corresponding to topic 4 is a reply email to the email corresponding to topic 3, and the email corresponding to topic 3 is a reply email to the email corresponding to topic 2. Accordingly, topic 6 can include multiple email topics (topics 2-4), and then it can be determined that the email corresponding to topic 6 is a reply email to the fault reporting email or related emails.

[0084] The disclosed embodiment does not limit how to determine whether the subject of the received email to be processed includes one or more of the at least one email subject. For example, Java's StringUtils can be used to determine whether the subject of the received email to be processed includes one or more of the at least one email subject.

[0085] S205, when the email subject of the received email to be processed includes one or more email subjects in at least one email subject, add the email-related content of the received email to be processed and the first work order number to the work order email association table, where the first work order number is the work order number corresponding to the one or more email subjects.

[0086] Among them, the ticket number of one or more email subjects is the same.

[0087] The technical solution provided by the embodiment of the present disclosure determines whether the received mail to be processed is a reply mail from the supplier to the fault reporting mail by determining whether the recipient mailbox of the received mail to be processed includes the fault reporting mail, determining whether at least one recipient mailbox included in the work order mail association table includes the sender mailbox of the received mail to be processed, and determining whether the mail subject of the received mail to be processed includes one or more mail subjects in at least one mail subject. In the case where it is determined that the recipient mailbox of the received mail to be processed includes the fault reporting mail, at least one recipient mailbox includes the sender mailbox of the received mail to be processed, and the mail subject of the received mail to be processed includes one or more mail subjects in at least one mail subject, it is determined that the received mail to be processed is a reply mail from the supplier to the fault reporting mail. Then, the mail-related content of the received mail to be processed and the first work order number corresponding to the one or more mail subjects are added to the work order mail association table. In this way, the association relationship between the work order and the mail can be automatically established, so that the reply mail of the supplier can be found through the work order number, avoiding the need for the work order processing personnel to frequently search for the reply mail of the supplier from multiple received mails, which is conducive to improving the work order processing efficiency.

[0088] In another embodiment, the email subject of the received email to be processed may be modified. Therefore, after determining that the email subject of the received email to be processed does not include the email subject in at least one email subject, the received email to be processed needs to be further processed to determine whether the received email to be processed is a fault reporting email or a reply email to a related email.

[0089] like Figure 3 As shown, the method for associating received emails with work orders provided in the embodiment of the present disclosure also includes the following S301 to S302.

[0090] S301, when the email subject of the received email to be processed does not include the email subject in at least one email subject, determine whether the email content of the received email to be processed includes one or more email contents in at least one email content, and the at least one email content includes the email content corresponding to the target recipient mailbox in the work order email association table.

[0091] The target recipient's mailbox and Figure 2 The target recipient mailboxes in the corresponding embodiments are the same and will not be described in detail here.

[0092] A reply email usually includes the content of the replied email. If the received email to be processed is a reply email to a fault reporting email or a related email, the email content of the received email to be processed includes the email content of the fault reporting email or the related email. If the email content of the received email to be processed includes one or more email contents of the at least one email content, it can be determined that the received email to be processed is a reply email to the fault reporting email or the related email.

[0093] In one embodiment, determining whether the email content of the received email to be processed includes one or more email contents in at least one email content may include: formatting the email content of the received email to be processed to obtain the email text to be processed; formatting each email content in at least one email content to obtain the email text corresponding to each email content; and determining whether the email text to be processed includes one or more email texts in at least one email text.

[0094] The embodiments of the present disclosure do not limit how to format the email content to obtain the email text. For example, the non-text content such as the style in the email content of the received email to be processed can be removed by using the replace operation of the Java string, thereby completing the formatting and obtaining the email text to be processed, and the non-text content such as the style in each email content of at least one email content can be removed, thereby completing the formatting and obtaining the email text corresponding to each email content.

[0095] Afterwards, the Java string tool StringUtils is used to compare one by one whether there is a containment relationship between the email text to be processed and each email text.

[0096] By formatting the email content to obtain the email text, and then judging whether the email text to be processed includes one or more email texts in at least one email text according to the email text, the interference of non-text content such as the style of the email itself in the email content can be avoided, which is conducive to improving the accuracy of the judgment result. Among them, the non-text content such as the style can include: html (hypertext markup language) tags, css styles (Cascading Style Sheets, cascading style sheets), js (javascript, a scripting language) scripts and spaces, etc.

[0097] S302, when the email content of the received email to be processed includes one or more email contents in at least one email content, add the email-related content of the received email to be processed and the second work order number to the work order email association table, where the second work order number is the work order number corresponding to the one or more email contents.

[0098] The work order numbers corresponding to one or more email contents are the same work order number.

[0099] The technical solution provided by the embodiment of the present disclosure takes into account the possibility that the subject of the received email to be processed may be modified. Therefore, after determining that the subject of the received email to be processed does not include the subject of at least one email subject, it is further determined whether the email content of the received email to be processed includes one or more email contents of at least one email content, and if the email content of the received email to be processed includes one or more email contents of at least one email content, the email-related content of the received email to be processed and the second work order number are added to the work order email association table. This method reduces the possibility that the received email to be processed is mistakenly identified as a reply email that is not a fault reporting email or a related email.

[0100] In one embodiment, the process of determining whether the received mail to be processed is a fault reporting mail or a reply mail to a related mail by determining whether the mail content of the received mail to be processed includes one or more mail contents in at least one mail content can replace Figure 2 In a corresponding embodiment, the process of determining whether the received email to be processed is a fault reporting email or a reply email to a related email is carried out by determining whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject.

[0101] In another embodiment, the email content of the received email to be processed may also be modified. Therefore, when it is determined that the email text to be processed does not include the email text in at least one email text, the received email to be processed needs to be further processed to determine whether the received email to be processed is a fault reporting email or a reply email to a related email.

[0102] like Figure 4 As shown, the method for associating received emails with work orders provided in the embodiment of the present disclosure also includes the following S401 to S403.

[0103] S401: When the email text to be processed does not include email text in at least one email text, determine the similarity between each email text and the email text to be processed to obtain at least one similarity value.

[0104] The embodiments of the present disclosure do not limit the specific method used to determine the similarity between each email text and the email text to be processed. For example, the distance between each email text and the email text to be processed can be calculated according to the edit distance algorithm to obtain at least one similarity value. For another example, the similarity between each email text and the email text to be processed can be calculated according to the SequenceMatcher (a method for calculating text similarity) in the difflib module of Python to obtain at least one similarity value.

[0105] S402: Determine whether a maximum similarity value among at least one similarity value is greater than a similarity threshold.

[0106] The specific size of the similarity threshold is not limited in the embodiments of the present disclosure and can be set based on experience.

[0107] When the maximum similarity value is greater than the similarity threshold, it can be considered that the received email to be processed is a fault reporting email or a reply email to a related email.

[0108] S403, when the maximum similarity value is greater than the similarity threshold, the email-related content of the received email to be processed and the third work order number are added to the work order email association table, where the third work order number is the work order number corresponding to the maximum similarity value.

[0109] The work order number corresponding to the maximum similarity value refers to the work order number corresponding to the email content with the maximum similarity value in the work order email association table.

[0110] The technical solution provided by the embodiment of the present disclosure, when it is determined that the email text to be processed does not include the email text in at least one email text, further determines the similarity between the email text to be processed and each email text in at least one email text, obtains at least one similarity value, and judges whether the received email to be processed is a reply email to a fault reporting email or a related email based on the maximum similarity value in the at least one similarity value. This method further reduces the possibility of mistakenly identifying the received email to be processed as not being a reply email to a fault reporting email or a related email.

[0111] To facilitate understanding of the technical solution provided by the embodiments of the present disclosure, the following will summarize the above Figure 2 , Figure 3 and Figure 4 Corresponding embodiments, and combined Figure 5 To illustrate the technical solution provided by the embodiment of the present disclosure.

[0112] S501, monitor the fault reporting mailbox.

[0113] S502, reading received emails to be processed.

[0114] S503, determine whether the recipients of the received mails to be processed include a problem reporting mailbox. If the recipients of the received mails to be processed include a problem reporting mailbox, proceed to S504; if the recipients of the received mails to be processed do not include a problem reporting mailbox, proceed to S502.

[0115] S504, determine whether at least one recipient mailbox included in the work order email association table includes the sender mailbox of the received email to be processed. If at least one recipient mailbox includes the sender mailbox of the received email to be processed, perform S505; if at least one recipient mailbox does not include the sender mailbox of the received email to be processed, perform S502.

[0116] S505, determine whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject. If the email subject of the received email to be processed includes one or more email subjects in at least one email subject, proceed to S508; if the email subject of the received email to be processed does not include the email subject in at least one email subject, proceed to S506.

[0117] S506, determine whether the email content of the received email to be processed includes one or more email contents in at least one email content. If the email content of the received email to be processed includes one or more email contents in at least one email content, proceed to S508; if it is determined that the email content of the received email to be processed does not include the email content in at least one email content, proceed to S507.

[0118] S507, determine the similarity between each email text and the email text to be processed, obtain at least one similarity value, and determine whether the maximum similarity value among the at least one similarity value is greater than the similarity threshold. If the maximum similarity value is greater than the similarity threshold, proceed to S508; if the maximum similarity value is not greater than the similarity threshold, proceed to S502.

[0119] S508, adding the email-related content and the corresponding work order number of the received email to be processed to the work order email association table, and performing S502.

[0120] In one embodiment, the execution order of S503 and S504, and the execution order of S505 and S506 can be flexibly interchanged.

[0121] The specific implementation of S501-S508 and the meanings of the terms involved can be found in Figure 2 , Figure 3 and Figure 4 The description in the corresponding embodiments will not be repeated here.

[0122] Based on the same inventive concept, the disclosed embodiment also provides a device for associating received emails with work orders, as described in the following embodiment. Since the principle of solving the problem in the device embodiment is similar to that in the above method embodiment, the implementation of the device embodiment can refer to the implementation of the above method embodiment, and the repeated parts will not be repeated.

[0123] Figure 6 A schematic diagram of a device for associating received emails with work orders in one embodiment of the present disclosure is shown. Figure 6 As shown, the device includes: an acquisition module 601, which is used to acquire received emails to be processed; a determination module 602, which is used to determine whether the recipient mailbox of the received email to be processed includes a fault reporting mailbox; the determination module 602 is also used to determine whether at least one recipient mailbox included in the work order email association table includes the sender mailbox of the received email to be processed when the recipient mailbox includes the fault reporting mailbox; the determination module 602 is also used to determine whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject when at least one recipient mailbox includes the sender mailbox, and at least one email subject includes the email subject corresponding to the target recipient mailbox in the work order email association table, and the target recipient mailbox is a recipient mailbox in at least one recipient mailbox that is the same as the sender mailbox; an adding module 603 is used to add the email-related content and the first work order number of the received email to be processed to the work order email association table when the email subject of the received email to be processed includes one or more email subjects in at least one email subject, and the first work order number is the work order number corresponding to one or more email subjects.

[0124] In one embodiment of the present disclosure, the determination module 602 is also used to determine whether the email content of the received email to be processed includes one or more email contents in at least one email content, when the email subject of the received email to be processed does not include the email subject in at least one email subject, and the at least one email content includes the email content corresponding to the target recipient's mailbox in the work order email association table; the adding module 603 is also used to add the email-related content of the received email to be processed and the second work order number to the work order email association table, when the email content of the received email to be processed includes one or more email contents in at least one email content. The second work order number is the work order number corresponding to the one or more email contents.

[0125] In one embodiment of the present disclosure, the determination module 602 is used to format the email content of the received email to be processed to obtain the email text to be processed; format each email content in at least one email content to obtain the email text corresponding to each email content; and determine whether the email text to be processed includes one or more email texts in at least one email text.

[0126] In one embodiment of the present disclosure, the determination module 602 is further used to determine the similarity between each email text and the email text to be processed to obtain at least one similarity value when the email text to be processed does not include the email text in at least one email text; the determination module 602 is further used to determine whether the maximum similarity value in the at least one similarity value is greater than the similarity threshold; the adding module 603 is further used to add the email-related content and the third work order number of the received email to be processed to the work order email association table when the maximum similarity value is greater than the similarity threshold, and the third work order number is the work order number corresponding to the maximum similarity value.

[0127] In one embodiment of the present disclosure, the determination module 602 is used to calculate the similarity between each email text and the email text to be processed according to the sequence matcher SequenceMatcher in the difflib module of Python to obtain at least one similarity value; or, according to the edit distance algorithm, calculate the distance between each email text and the email text to be processed to obtain at least one similarity value.

[0128] In one embodiment of the present disclosure, the acquisition module 601 is used to obtain received emails whose email identification ID is greater than an ID threshold from the fault reporting mailbox to obtain received emails to be processed; and the maximum email ID among the email IDs of the received emails to be processed is used as the new ID threshold.

[0129] In one embodiment of the present disclosure, the acquisition module 601 is also used to acquire the work order to be processed; the determination module is also used to determine the mailbox to be reported corresponding to the work order to be processed; the device also includes: a generation and sending module 604, which is used to generate and send a fault report email corresponding to the work order to be processed to the mailbox to be reported using the fault report email as the sender's email; the adding module 603 is also used to add the work order number of the work order to be processed and the email-related content of the fault report email to the work order email association table.

[0130] The technical solution provided by the embodiment of the present disclosure determines whether the received mail to be processed is a reply mail from the supplier to the fault reporting mail by determining whether the recipient mailbox of the received mail to be processed includes the fault reporting mail, determining whether at least one recipient mailbox included in the work order mail association table includes the sender mailbox of the received mail to be processed, and determining whether the mail subject of the received mail to be processed includes one or more mail subjects in at least one mail subject. In the case where it is determined that the recipient mailbox of the received mail to be processed includes the fault reporting mail, at least one recipient mailbox includes the sender mailbox of the received mail to be processed, and the mail subject of the received mail to be processed includes one or more mail subjects in at least one mail subject, it is determined that the received mail to be processed is a reply mail from the supplier to the fault reporting mail. Then, the mail-related content of the received mail to be processed and the first work order number corresponding to the one or more mail subjects are added to the work order mail association table. In this way, the association relationship between the work order and the mail can be automatically established, so that the reply mail of the supplier can be found through the work order number, avoiding the need for the work order processing personnel to frequently search for the reply mail of the supplier from multiple received mails, which is conducive to improving the work order processing efficiency.

[0131] Those skilled in the art will appreciate that various aspects of the present disclosure may be implemented as systems, methods or program products. Therefore, various aspects of the present disclosure may be specifically implemented in the following forms, namely: complete hardware implementation, complete software implementation (including firmware, microcode, etc.), or a combination of hardware and software, which may be collectively referred to herein as "circuits", "modules" or "systems".

[0132] Refer to the following Figure 7 An electronic device 700 according to this embodiment of the present disclosure is described. Figure 7 The electronic device 700 shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0133] like Figure 7 As shown, the electronic device 700 is in the form of a general computing device. The components of the electronic device 700 may include but are not limited to: at least one processing unit 710, at least one storage unit 720, and a bus 730 connecting different system components (including the storage unit 720 and the processing unit 710).

[0134] The storage unit stores program codes, which can be executed by the processing unit 710, so that the processing unit 710 executes the steps according to various exemplary embodiments of the present disclosure described in the above “Specific Implementation Methods” section of this specification.

[0135] The storage unit 720 may include a readable medium in the form of a volatile storage unit, such as a random access storage unit (RAM) 7201 and / or a cache storage unit 7202 , and may further include a read-only storage unit (ROM) 7203 .

[0136] The storage unit 720 may also include a program / utility 7204 having a set (at least one) of program modules 7205, such program modules 7205 including but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment.

[0137] Bus 730 may represent one or more of several types of bus structures, including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or a local bus using any of a variety of bus architectures.

[0138] The electronic device 700 may also communicate with one or more external devices 740 (e.g., keyboards, pointing devices, Bluetooth devices, etc.), one or more devices that enable a user to interact with the electronic device 700, and / or any device that enables the electronic device 700 to communicate with one or more other computing devices (e.g., routers, modems, etc.). Such communication may be performed through an input / output (I / O) interface 750. Furthermore, the electronic device 700 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) through a network adapter 760. Figure 7 As shown, the network adapter 760 communicates with other modules of the electronic device 700 via the bus 730. It should be understood that, although not shown in the figure, other hardware and / or software modules can be used in conjunction with the electronic device 700, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0139] Through the description of the above implementation, it is easy for those skilled in the art to understand that the example implementation described here can be implemented by software, or by software combined with necessary hardware. Therefore, the technical solution according to the implementation of the present disclosure can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a USB flash drive, a mobile hard disk, etc.) or on a network, including several instructions to enable a computing device (which can be a personal computer, a server, a terminal device, or a network device, etc.) to execute the method according to the implementation of the present disclosure.

[0140] In an exemplary embodiment of the present disclosure, a computer-readable storage medium is also provided, which may be a readable signal medium or a readable storage medium. A program product capable of implementing the above-mentioned method of the present disclosure is stored thereon. In some possible implementations, various aspects of the present disclosure may also be implemented in the form of a program product, which includes a program code, and when the program product is run on a terminal device, the program code is used to cause the terminal device to execute the steps according to various exemplary implementations of the present disclosure described in the above “Specific Implementation Methods” section of this specification.

[0141] More specific examples of computer-readable storage media in the present disclosure may include, but are not limited to, an electrical connection having one or more conductors, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0142] In the present disclosure, a computer readable storage medium may include a data signal propagated in baseband or as part of a carrier wave, wherein a readable program code is carried. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. A readable signal medium may also be any readable medium other than a readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0143] Alternatively, the program code contained on the computer-readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wired, optical cable, RF, etc., or any suitable combination of the foregoing.

[0144] In a specific implementation, the program code for performing the operations of the present disclosure may be written in any combination of one or more programming languages, including object-oriented programming languages ​​such as Java, C++, etc., and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user computing device, partially on the user device, as a separate software package, partially on the user computing device and partially on a remote computing device, or entirely on a remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computing device (e.g., using an Internet service provider to connect through the Internet).

[0145] In an exemplary embodiment of the present disclosure, a computer program product is also provided, which includes a computer program or computer instructions, and the computer program or computer instructions are loaded and executed by a processor to enable a computer to implement the steps of various exemplary embodiments of the present disclosure described in the above "Specific Implementation" section of this specification.

[0146] It should be noted that, although several modules or units of the device for action execution are mentioned in the above detailed description, this division is not mandatory. In fact, according to the embodiments of the present disclosure, the features and functions of two or more modules or units described above can be embodied in one module or unit. On the contrary, the features and functions of one module or unit described above can be further divided into multiple modules or units to be embodied.

[0147] In addition, although the steps of the method in the present disclosure are described in a specific order in the drawings, this does not require or imply that the steps must be performed in this specific order, or that all the steps shown must be performed to achieve the desired results. Additionally or alternatively, some steps may be omitted, multiple steps may be combined into one step, and / or one step may be decomposed into multiple steps, etc.

[0148] Through the description of the above implementation, it is easy for those skilled in the art to understand that the example implementation described here can be implemented by software, or by software combined with necessary hardware. Therefore, the technical solution according to the implementation of the present disclosure can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a USB flash drive, a mobile hard disk, etc.) or on a network, including several instructions to enable a computing device (which can be a personal computer, a server, a mobile terminal, or a network device, etc.) to execute the method according to the implementation of the present disclosure.

[0149] Those skilled in the art will readily appreciate other embodiments of the present disclosure after considering the specification and practicing the invention disclosed herein. The present disclosure is intended to cover any variations, uses or adaptations of the present disclosure, which follow the general principles of the present disclosure and include common knowledge or customary technical means in the art that are not disclosed in the present disclosure. The description and examples are to be regarded as exemplary only, and the true scope of the present disclosure is indicated by the appended claims.

Claims

1. A method for associating a received email with a work order, characterized in that: include: Get the received emails to be processed; Determine whether the recipient mailboxes of the received mails to be processed include the error reporting mailbox; In the case where the recipient mailbox includes a fault reporting mailbox, determining whether at least one recipient mailbox included in the work order email association table includes a sender mailbox of the received email to be processed; In the case where the at least one recipient mailbox includes the sender mailbox, determining whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject, the at least one email subject includes an email subject corresponding to a target recipient mailbox in the work order email association table, the target recipient mailbox being a recipient mailbox in the at least one recipient mailbox that is the same as the sender mailbox; In a case where the email subject of the received email to be processed includes one or more email subjects of the at least one email subject, adding email-related content of the received email to be processed and a first work order number to the work order email association table, where the first work order number is the work order number corresponding to the one or more email subjects; Among them, the received emails to be processed include the emails that the mailbox to be reported sends back to the mailbox to be reported for the emails to be reported. The mailbox-related content and the corresponding work order number of the emails that the mailbox to be reported sends back to the mailbox to be reported are added to the work order email association table. In a case where the email subject of the received email to be processed does not include the email subject in the at least one email subject, determining whether the email content of the received email to be processed includes one or more email contents in the at least one email content includes: formatting the email content of the received email to be processed to obtain the email text to be processed; formatting each email content in the at least one email content to obtain the email text corresponding to each email content; and determining whether the email text to be processed includes one or more email texts in the at least one email text.

2. The method according to claim 1, characterized in that Also includes: The at least one email content includes the email content corresponding to the target recipient mailbox in the work order email association table; When the email content of the received email to be processed includes one or more email contents of the at least one email content, the email-related content of the received email to be processed and the second work order number are added to the work order email association table, and the second work order number is the work order number corresponding to the one or more email contents.

3. The method according to claim 1, characterized in that Also includes: In the case where the email text to be processed does not include the email text in at least one email text, determining the similarity between each email text and the email text to be processed to obtain at least one similarity value; determining whether a maximum similarity value among the at least one similarity value is greater than a similarity threshold; When the maximum similarity value is greater than the similarity threshold, the email-related content and the third work order number of the received email to be processed are added to the work order email association table, where the third work order number is the work order number corresponding to the maximum similarity value.

4. The method according to claim 3, characterized in that The determining of the similarity between each email text and the email text to be processed to obtain at least one similarity value includes: Calculate the similarity between each email text and the email text to be processed according to the sequence matcher SequenceMatcher in the difflib module of Python to obtain the at least one similarity value; Alternatively, the distance between each email text and the email text to be processed is calculated according to an edit distance algorithm to obtain the at least one similarity value.

5. The method according to claim 1, characterized in that: The step of obtaining received emails to be processed includes: Obtain received emails whose email identification ID is greater than the ID threshold from the fault reporting mailbox, and obtain received emails to be processed; The maximum email ID among the email IDs of the received emails to be processed is used as the new ID threshold.

6. The method according to any one of claims 1 to 5, characterized in that: Also includes: Get pending work orders; Determine the mailbox for reporting problems corresponding to the pending work orders; With the fault reporting mailbox as the sender's mailbox, a fault reporting email corresponding to the pending work order is generated and sent to the pending fault reporting mailbox; Add the work order number of the pending work order and the email-related content of the fault reporting email to the work order email association table.

7. A device for associating received emails with work orders, characterized in that: include: The acquisition module is used to obtain received emails to be processed; A determination module, used to determine whether the recipient mailboxes of the received mails to be processed include a fault reporting mailbox; The determination module is further configured to determine whether at least one recipient mailbox included in the work order email association table includes a sender mailbox of a received email to be processed when the recipient mailbox includes a fault reporting mailbox; The determination module is further configured to determine, when the at least one recipient mailbox includes the sender mailbox, whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject, the at least one email subject including an email subject corresponding to a target recipient mailbox in the work order email association table, the target recipient mailbox being a recipient mailbox in the at least one recipient mailbox that is the same as the sender mailbox; An adding module, configured to add the email-related content of the received email to be processed and a first work order number to the work order email association table when the email subject of the received email to be processed includes one or more email subjects of the at least one email subject, wherein the first work order number is the work order number corresponding to the one or more email subjects; Among them, the received emails to be processed include the emails that the mailbox to be reported sends back to the mailbox to be reported for the emails to be reported. The mailbox-related content and the corresponding work order number of the emails that the mailbox to be reported sends back to the mailbox to be reported are added to the work order email association table. The determination module is further used to determine whether the email content of the to-be-processed received email includes one or more email contents in at least one email content when the email subject of the to-be-processed received email does not include the email subject in the at least one email subject; format the email content of the to-be-processed received email to obtain the to-be-processed email text; format each email content in the at least one email content to obtain the email text corresponding to each email content; and determine whether the to-be-processed email text includes one or more email texts in the at least one email text.

8. An electronic device, characterized in that: include: processor; as well as A memory, configured to store executable instructions of the processor; The processor is configured to execute the method for associating a received email with a work order according to any one of claims 1 to 6 by executing the executable instructions.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method for associating received emails with work orders as described in any one of claims 1 to 8 is implemented.

Images