A work order processing method and device based on RPA

Abstract

The present invention discloses a work order processing method and device based on RPA, the method comprising: after obtaining the user's account information, collecting the work order data required for the business based on the account information; adding the work order data to the preset table according to the preset field mapping table to obtain the edit work order; extracting the feature field from the edit work order, and determining the business type corresponding to the feature field; when the business type is dispatch processing, finding the dispatch location information corresponding to the edit work order, and sending the edit work order to the corresponding processing user account terminal according to the dispatch location information. The present invention can use RPA technology to automatically extract, edit and process information to reduce the time spent by business personnel on government work orders, save manpower for government processing, improve processing efficiency, and the entire process is intelligently processed, which can further improve the accuracy of processed data relative to manual processing.

Description

Background Art

[0002] With the development of the economy, various businesses are becoming increasingly busy. In order to effectively handle various businesses, users need to judge each field information in the work order in the business system and fill in the corresponding approval opinions when handling their corresponding businesses, and then distribute the business work order to the corresponding business processing agency for processing.

[0003] At present, the commonly used distribution method is for business personnel to verify and organize the various information on the system work order, and then manually edit it into the corresponding business request work order, and finally distribute the business request list to the corresponding business processing agency (for example, business personnel use user account information to extract the user's real-time social security processing request and basic processing work order information, and after judgment, transfer the social security work order processing work order editor to the Human Resources and Social Security Bureau for the Human Resources and Social Security Bureau to handle social security business for the user.).

[0004] However, the currently commonly used dispatch processing method has the following technical problems: manual dispatch of work orders is time-consuming, inefficient, and consumes a lot of human resources, has high human resource costs, and is prone to errors. The organization that receives the work order may not meet the actual needs of the user, resulting in business processing errors, extending the waiting time for users to handle business, and affecting the user experience. Summary of the invention

[0005] The present invention proposes a work order processing method and device based on RPA. The method can collect the information required for various work orders for users through an RPA robot, and automatically edit and distribute corresponding government work orders, which can not only improve the efficiency of business processing, but also improve the accuracy of processing information.

[0006] A first aspect of an embodiment of the present invention provides a work order processing method based on RPA, the method comprising: after obtaining user account information, collecting work order data required for the business based on the account information;

[0007] According to the preset field mapping table, the work order data is added to the preset table to obtain the edit work order;

[0008] Extracting a characteristic field from the editing work order, and determining a business type corresponding to the characteristic field;

[0009] When the business type is dispatch processing, the dispatch location information corresponding to the editing work order is searched, and the editing work order is sent to the corresponding processing user account terminal according to the dispatch location information.

[0010] In a possible implementation of the first aspect, the collecting work order data required for the service based on the account information includes:

[0011] Extracting the user's login account and login password from the account information;

[0012] Use page element positioning technology to determine the account input box and password input box in the business processing page;

[0013] Enter the login account into the account input box, and enter the login password into the password input box to log in to the user account;

[0014] Use OCR recognition technology to extract the work order data required for the business on the business processing page.

[0015] In a possible implementation manner of the first aspect, after the step of collecting work order data required for the service based on the account information, the method further includes:

[0016] Acquire multiple field data from the work order data;

[0017] Mapping and comparing each of the field data with a preset mapping relationship table;

[0018] When the mapping comparison results of each of the field data are the same, it is determined that the work order data meets the user business rule requirements;

[0019] If the mapping comparison result of at least one of the field data is different, it is determined that the work order data does not meet the user business rule requirements.

[0020] In a possible implementation manner of the first aspect, determining the service type corresponding to the characteristic field includes:

[0021] Finding a matching field that matches the characteristic field by using a page element positioning technology;

[0022] The business type is searched from the flow condition list preset by the user based on the matching field.

[0023] In a possible implementation manner of the first aspect, after the step of sending the editing work order to the corresponding processing user account terminal according to the dispatching location information, the method further includes:

[0024] If the editing work order is sent successfully, the RPA automatically edits and fills in the processing opinion form, and sends the processing opinion form to the corresponding processing user account terminal to prompt the user to complete the processing;

[0025] If the editing work order is not sent successfully, the user is prompted to manually review and send it manually.

[0026] In a possible implementation manner of the first aspect, after the step of sending the editing work order to the corresponding processing user account terminal according to the dispatching location information, the method further includes:

[0027] The work order data, the edited work order, the business type and the sending result of the edited work order are stored and recorded for user query.

[0028] A second aspect of an embodiment of the present invention provides a work order processing device based on RPA, the device comprising:

[0029] A collection module, used to collect work order data required for the business based on the account information after obtaining the user's account information;

[0030] An adding module, used to add the work order data to a preset table according to a preset field mapping table to obtain an edited work order;

[0031] An extraction and determination module, used to extract characteristic fields from the editing work order and determine the business type corresponding to the characteristic fields;

[0032] The dispatch module is used to search for the dispatch location information corresponding to the editing work order when the business type is dispatch processing, and send the editing work order to the corresponding user account terminal according to the dispatch location information.

[0033] In a possible implementation manner of the second aspect, the acquisition module is further used to:

[0034] Extracting the user's login account and login password from the account information;

[0035] Use page element positioning technology to determine the account input box and password input box in the business processing page;

[0036] Enter the login account into the account input box, and enter the login password into the password input box to log in to the user account;

[0037] Use OCR recognition technology to extract the work order data required for the business on the business processing page.

[0038] Compared with the prior art, the embodiment of the present invention provides a work order processing method and device based on RPA, which has the beneficial effect that: the present invention can use RPA technology to automatically log in to the user account, and then can automatically obtain and determine the work order data through RPA to edit the work order data into the corresponding edited work order and extract the corresponding feature fields, and then determine whether the data meets the distribution requirements through the feature fields. When the field data meets the distribution requirements, accurate positioning and distribution are performed to reduce the time spent by business personnel on government work orders, save government processing manpower, improve processing efficiency, and the entire process is intelligently processed, which can further improve the accuracy of processed data compared to manual processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] Figure 1 It is a flowchart of a work order processing method based on RPA provided by an embodiment of the present invention;

[0040] Figure 2 It is a structural diagram of an RPA-based work order processing device provided in one embodiment of the present invention. DETAILED DESCRIPTION

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

[0042] The currently commonly used dispatch processing method has the following technical problems: manual dispatch of work orders is time-consuming, inefficient, and consumes a lot of human resources. In addition, manual dispatch is prone to errors, and the receiving work order organization may not meet the actual needs of the user, resulting in business processing errors, extending the waiting time for users to handle business, and affecting the user experience.

[0043] In order to solve the above problems, an RPA-based work order processing method provided in an embodiment of the present application will be introduced and explained in detail through the following specific embodiments.

[0044] In one embodiment, the method may be applicable to an RPA software robot.

[0045] Reference Figure 1 , which shows a flow chart of a work order processing method based on RPA provided by an embodiment of the present invention.

[0046] As an example, the RPA-based work order processing method may include:

[0047] S11. After obtaining the user's account information, collect work order data required for the business based on the account information.

[0048] The account information may include the user's account information, password information, business requirement information, identity information, etc.

[0049] In order to accurately extract the work order data required by the user, as an example, step S11 may include the following sub-steps:

[0050] Sub-step S111: extracting the user's login account and login password from the account information.

[0051] Specifically, the login account is the personal account information of the user who processes the dispatch service. The login password is the password of the personal account of the user who processes the dispatch service.

[0052] For example, when a user performs an order dispatching business, the login account is the personal account information assigned to the user in the order dispatching business department, such as a mobile phone number, and the login password is the user's account password.

[0053] Sub-step S112: using page element positioning technology to respectively determine the account input box and the password input box in the business processing page.

[0054] In one embodiment, the account input box and the password input box can be respectively determined on the login page for handling business by using the page element positioning technology.

[0055] In the specific implementation, the business requirement information can be determined from the personal account information, and the login page of the business requirement can be transferred based on the business requirement information, and then the page element positioning technology is used to respectively determine the account input box and the password input box in the login page.

[0056] Sub-step S113: input the login account into the account input box, and input the login password into the password input box to log in to the user account.

[0057] Sub-step S114: extracting the work order data required for the business on the business processing page through OCR recognition technology.

[0058] After entering the login account and password, the user account is automatically logged in so that the login page can display various user data.

[0059] Next, you can use OCR recognition technology to extract the work order data required for the business on the page.

[0060] In specific implementation, the data type to be identified can be determined from the business demand information, and then the data matching the data type can be found based on the OCR recognition technology to extract the corresponding work order data.

[0061] In order to further improve the accuracy of extracted data and avoid extraction errors, in one embodiment, after step S11, the method may further include:

[0062] S21. Acquire multiple field data from the work order data.

[0063] Specifically, the work order data may be split into fields to obtain multiple field information.

[0064] In one embodiment, the work order fields may be split according to field types.

[0065] S22: Map and compare each field information with a preset mapping relationship table.

[0066] Optionally, the user may pre-set multiple field rules and aggregate the multiple field rules to obtain a mapping relationship table.

[0067] Each field can be compared one by one with multiple field rules in the mapping relationship table. If the extracted field is the same as at least one field rule, the extracted field mapping comparison result is determined to be the same; conversely, if the extracted field is not the same as any field rule, the extracted field mapping comparison result is determined to be different.

[0068] For example, if one of the fields is "help" and the work order title is "salary" issue, and the mapping rule table indicates that the work order involving "salary" issue is transferred to "Human Resources and Social Security Bureau", then the extracted field "help" is matched with "Human Resources and Social Security Bureau" in the mapping rule table, and the output result is "Human Resources and Social Security Bureau".

[0069] S23. When the mapping comparison results of each field data are the same, it is determined that the work order data meets the user business rule requirements.

[0070] S24. If the mapping comparison result of at least one of the field data is different, it is determined that the work order data does not meet the user business rule requirements.

[0071] By automatically comparing and mapping each field data in the work order data with the mapping relationship table, it is possible to determine whether the work order data conforms to the rules provided by the user in advance, so as to avoid subsequent processing errors and improve data processing efficiency.

[0072] S12. Add the work order data to the preset table according to the preset field mapping table to obtain the edited work order.

[0073] In an optional embodiment, the work order data may also be split into multiple field data, and then each field data is added to a preset table according to a field mapping table, thereby obtaining an editing work order.

[0074] The field mapping table may be generated by editing according to the types of each field box in the preset table.

[0075] Specifically, the user may record the type of each field box in the preset form in advance, and finally edit the type sets of multiple field boxes into a field mapping table.

[0076] S13: extracting a characteristic field from the editing work order, and determining a business type corresponding to the characteristic field.

[0077] Optionally, the feature field may be feature information in the work order data.

[0078] For example, it can be the data of each field in the editing work order, the title of the editing work order, the number of data in the editing work order, etc.

[0079] Based on the feature field, the work order type corresponding to the feature field is determined, so that the business that the user wants to handle by generating this editing work order can be determined.

[0080] The business type may be the type of unit that handles the business.

[0081] In order to accurately determine the service type, in one embodiment, step S13 may include the following sub-steps:

[0082] Sub-step S131: searching for a matching field that matches the characteristic field by using a page element positioning technology.

[0083] Specifically, the user can pre-search rules, for example, search for titles, search for quantity types, search for data quantities, etc.

[0084] According to the search rules pre-set by the user, the page element positioning technology can be used to search for fields matching the feature fields from the editing work order.

[0085] For example, if the characteristic field is unemployment registration renewal, the four characters "unemployment registration" can be found in the title of the editing work order, and the corresponding matching field can be determined to be matched.

[0086] Sub-step S132: searching for the business type from the flow condition list preset by the user based on the matching field.

[0087] The preset flow condition list may be a business processing type table preset by a user, and the preset flow condition list may include multiple business processing types.

[0088] For example, the type corresponding to social security consultation is dispatched, and the type corresponding to administrative efficiency complaints is internal.

[0089] After the matching field is determined, the corresponding processing type can be searched from the preset flow condition list based on the matching field to obtain the corresponding business type.

[0090] S14: When the business type is dispatch processing, search for dispatch location information corresponding to the editing work order, and send the editing work order to the corresponding processing user account terminal according to the dispatch location information.

[0091] Continuing with the above example, if the business type is determined to be social security consultation, then its business type can be determined to be dispatching. The full name of the Human Resources and Social Security Bureau can be directly searched in the dispatching edit field to obtain the corresponding dispatching agency information. Finally, the work order can be sent to the account of the Human Resources and Social Security Bureau according to the dispatching agency name. The work order can then be sent to the corresponding salesperson through the Human Resources and Social Security Bureau account, so that the salesperson can perform the corresponding social security processing operations.

[0092] In an optional embodiment, in order to promptly notify the user of the progress of the current business handling, the method may further include:

[0093] S15. If the work order is successfully transferred, the RPA automatically edits and fills in the processing opinion form, and sends the processing opinion form to the corresponding processing user account terminal to prompt the user to complete the processing.

[0094] S16. If the editing work order is not successfully transferred, the RPA automatically edits and fills in the prompt opinion form, and sends the prompt opinion form to the corresponding processing user account terminal to prompt the user not to process it.

[0095] Specifically, a preset time may be waited to determine whether a feedback signal from the processing server is received. If a feedback signal is received, it may be determined that the editing work order is sent successfully. Otherwise, it may be determined that the editing work order is not sent successfully.

[0096] When the editing work order is sent successfully, the corresponding processing opinion form can be edited according to the user's preset template and sent to the preset processing user account terminal to prompt the user to complete the processing; if the editing work order is not sent successfully, the corresponding prompt opinion form can also be edited according to the user's preset template and sent to the preset processing user account terminal to prompt the user that the processing failed.

[0097] In order to allow the user to query the entire processing process, in one embodiment, the method may further include:

[0098] S17. Storing and recording the work order data, the edited work order, the service type and the sending result of the edited work order for user query.

[0099] After obtaining the work order data, editing the work order, the business type and the sending result of the editing work order, each data can be stored and recorded separately.

[0100] When users need to query various data, they can call the RPA robot through their user terminal to query and obtain various data, so as to facilitate the user to conduct corresponding review.

[0101] In this embodiment, an embodiment of the present invention provides a work order processing method based on RPA, which has the beneficial effects of: the present invention can use RPA technology to automatically log in to a user account, and then can automatically obtain and determine the work order data through RPA to edit the work order data into a corresponding edited work order and extract the corresponding feature fields, and then determine whether the data meets the distribution requirements through the feature fields. When the field data meets the distribution requirements, accurate positioning and distribution are performed to reduce the time spent by business personnel on government work orders, save manpower for government processing, and improve processing efficiency. The entire process is intelligently processed, which can further improve the accuracy of processed data compared to manual processing.

[0102] The embodiment of the present invention also provides a work order processing device based on RPA, see Figure 2 , showing a structural schematic diagram of an RPA-based work order processing device provided by an embodiment of the present invention.

[0103] Wherein, as an example, the RPA-based work order processing device may include:

[0104] The collection module 201 is used to collect the work order data required for the business based on the account information after obtaining the user's account information;

[0105] An adding module 202, used to add the work order data to a preset table according to a preset field mapping table to obtain an edited work order;

[0106] The extraction and determination module 203 is used to extract the characteristic field from the editing work order and determine the business type corresponding to the characteristic field;

[0107] The dispatch module 204 is used to search for the dispatch location information corresponding to the editing work order when the business type is dispatch processing, and send the editing work order to the corresponding processing user account terminal according to the dispatch location information.

[0108] Optionally, the acquisition module is further used for:

[0109] Extracting the user's login account and login password from the account information;

[0110] Use page element positioning technology to determine the account input box and password input box in the business processing page;

[0111] Enter the login account into the account input box, and enter the login password into the password input box to log in to the user account;

[0112] Use OCR recognition technology to extract the work order data required for the business on the business processing page.

[0113] Optionally, the device further comprises:

[0114] An acquisition module, used to acquire multiple field data from the work order data;

[0115] A comparison module, used for mapping and comparing each of the field data with a preset mapping relationship table;

[0116] A same comparison module is used to determine that the work order data meets the user's business rule requirements when the mapping comparison results of each field data are the same;

[0117] The comparison difference module is used to determine that the work order data does not meet the user business rule requirements if the mapping comparison result of at least one of the field data is different.

[0118] Optionally, the extraction and determination module is further used for:

[0119] Finding a matching field that matches the characteristic field by using a page element positioning technology;

[0120] The business type is searched from a flow condition list preset by the user based on the matching field.

[0121] Optionally, the device further comprises:

[0122] The sending success module is used to automatically edit and fill in the processing opinion form through RPA if the editing work order is sent successfully, and send the processing opinion form to the corresponding processing user account terminal to prompt the user to complete the processing;

[0123] The sending failure module is used to automatically edit and fill in the prompt opinion form through RPA if the editing work order is not sent successfully, and send the prompt opinion form to the corresponding processing user account terminal to prompt the user not to process it.

[0124] Optionally, the method further comprises:

[0125] The storage and recording module is used to store and record the work order data, the edited work order, the business type and the sending result of the edited work order for user query.

[0126] Those skilled in the art can clearly understand that, for the sake of convenience and brevity of description, the specific working process of the device described above can refer to the corresponding process in the aforementioned method embodiment, and will not be repeated here.

[0127] Furthermore, an embodiment of the present application also provides an electronic device, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, the RPA-based work order processing method as described in the above embodiment is implemented.

[0128] Furthermore, an embodiment of the present application also provides a computer-readable storage medium, which stores computer-executable instructions, and the computer-executable instructions are used to enable a computer to execute the RPA-based work order processing method as described in the above embodiment.

[0129] The above is a preferred embodiment of the present invention. It should be pointed out that a person skilled in the art can make several improvements and modifications without departing from the principle of the present invention. These improvements and modifications are also considered to be within the scope of protection of the present invention.

Claims

1. A work order processing method based on RPA, characterized in that: The method comprises: After obtaining the user's account information, collect the work order data required for the business based on the account information; According to the preset field mapping table, the work order data is added to the preset table to obtain the edit work order; Extracting a characteristic field from the editing work order, and determining a business type corresponding to the characteristic field; When the business type is dispatch processing, searching for dispatch location information corresponding to the editing work order, and sending the editing work order to the corresponding processing user account terminal according to the dispatch location information; The work order data required for the business based on the account information collection includes: Extracting the user's login account and login password from the account information; Use page element positioning technology to determine the account input box and password input box in the business processing page; Enter the login account into the account input box, and enter the login password into the password input box to log in to the user account; Use OCR recognition technology to extract the work order data required for the business on the business processing page; After the step of collecting the work order data required for the business based on the account information, the method further includes: Acquire multiple field data from the work order data; Mapping and comparing each of the field data with a preset mapping relationship table; When the mapping comparison results of each of the field data are the same, it is determined that the work order data meets the user business rule requirements; If the mapping comparison result of at least one of the field data is different, it is determined that the work order data does not meet the user business rule requirements.

2. The work order processing method based on RPA according to claim 1, characterized in that: The determining the service type corresponding to the characteristic field includes: Finding a matching field that matches the characteristic field by using a page element positioning technology; The business type is searched from the flow condition list preset by the user based on the matching field.

3. The work order processing method based on RPA according to claim 1, characterized in that: After the step of sending the editing work order to the corresponding processing user account terminal according to the distribution location information, the method further includes: If the editing work order is sent successfully, the RPA automatically edits and fills in the processing opinion form, and sends the processing opinion form to the corresponding processing user account terminal to prompt the user to complete the processing; If the editing work order is not sent successfully, the user is prompted to manually review and send it manually.

4. The work order processing method based on RPA according to claim 1, characterized in that: After the step of sending the editing work order to the corresponding processing user account terminal according to the distribution location information, the method further includes: The work order data, the edited work order, the business type and the sending result of the edited work order are stored and recorded for user query.

5. A work order processing device based on RPA, characterized in that: The device comprises: A collection module, used to collect work order data required for the business based on the account information after obtaining the user's account information; An adding module, used to add the work order data to a preset table according to a preset field mapping table to obtain an edited work order; An extraction and determination module, used to extract characteristic fields from the editing work order and determine the business type corresponding to the characteristic fields; A dispatching module, configured to search for dispatching location information corresponding to the editing work order when the business type is dispatching processing, and send the editing work order to a corresponding processing user account terminal according to the dispatching location information; The acquisition module is also used for: Extracting the user's login account and login password from the account information; Use page element positioning technology to determine the account input box and password input box in the business processing page; Enter the login account into the account input box, and enter the login password into the password input box to log in to the user account; Use OCR recognition technology to extract the work order data required for the business on the business processing page; The device also includes: An acquisition module, used to acquire multiple field data from the work order data; A comparison module, used for mapping and comparing each of the field data with a preset mapping relationship table; A comparison module for determining that the work order data meets the user's business rule requirements when the mapping comparison results of each field data are the same; The comparison difference module is used to determine that the work order data does not meet the user business rule requirements if the mapping comparison result of at least one of the field data is different.

6. An electronic device comprising: A memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, the RPA-based work order processing method according to any one of claims 1 to 4 is implemented.

7. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, and the computer-executable instructions are used to enable a computer to execute the RPA-based work order processing method as described in any one of claims 1 to 4.

Images