CN114024955B - File processing method, device, equipment and medium based on RPA and AI - Google Patents
File processing method, device, equipment and medium based on RPA and AI Download PDFInfo
- Publication number
- CN114024955B CN114024955B CN202111283652.7A CN202111283652A CN114024955B CN 114024955 B CN114024955 B CN 114024955B CN 202111283652 A CN202111283652 A CN 202111283652A CN 114024955 B CN114024955 B CN 114024955B
- Authority
- CN
- China
- Prior art keywords
- file
- uploaded
- uploading
- target website
- files
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 21
- 238000000034 method Methods 0.000 claims abstract description 62
- 230000008569 process Effects 0.000 claims description 28
- 239000000463 material Substances 0.000 claims description 22
- 238000012015 optical character recognition Methods 0.000 claims description 22
- 238000003860 storage Methods 0.000 claims description 18
- 238000012795 verification Methods 0.000 claims description 18
- 238000012545 processing Methods 0.000 claims description 7
- 238000004590 computer program Methods 0.000 claims description 6
- 230000003287 optical effect Effects 0.000 claims description 5
- 238000013473 artificial intelligence Methods 0.000 description 31
- 238000005516 engineering process Methods 0.000 description 6
- 238000003058 natural language processing Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 238000004801 process automation Methods 0.000 description 5
- 230000002159 abnormal effect Effects 0.000 description 4
- 230000000694 effects Effects 0.000 description 4
- 230000005856 abnormality Effects 0.000 description 3
- 238000012549 training Methods 0.000 description 3
- 230000003993 interaction Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/06—Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The embodiment of the invention discloses a file processing method, a device, equipment and a medium based on RPA and AI, wherein the method comprises the following steps: s1, reading a configuration file table, wherein the configuration file table comprises file information of a file to be uploaded and uploading path information; s2, if the fact that the target website does not store the files to be uploaded is determined, acquiring the files to be uploaded, and sequentially uploading the files to be uploaded to the target website according to the corresponding uploading path information; s3, filling file information corresponding to any successfully uploaded file in a webpage operation interface of the target website. By adopting the technical scheme, the problem of low efficiency of manually uploading the file is solved.
Description
Technical Field
The embodiment of the invention relates to the technical field of process automation, in particular to a file processing method, device, equipment and medium based on RPA and AI.
Background
RPA (Robotic Process Automation, robot process automation) is a process task automatically executed on a regular basis by a specific "robot software" that simulates the operation of a human on a computer.
AI (Artificial Intelligence ) is a new technical science to study, develop theories, methods, techniques and application systems for simulating, extending and expanding human intelligence.
RPA has unique advantages: low code, non-intrusive. The low code means that the RPA can operate without a very high IT level, and business personnel without programming can develop the flow; non-intrusive means that the RPA can simulate human operation without a software system open interface. However, conventional RPA has certain limitations: can only be based on fixed rules and application scenarios are limited. With the continuous development of the AI technology, the limitations of the traditional RPA are overcome by the deep fusion of the RPA and the AI, and the values of the labor force are greatly changed by the RPA+AI=hand work+head work.
Currently, the uploading of enterprise documents is typically performed manually. In particular, for some learning materials, after the training staff makes the learning material courseware, the training staff needs to log in the learning website to upload the corresponding materials. Typically, the learning materials that need to be uploaded are multiple files, which is entirely a repetitive mechanical effort. If the network is abnormal, the failure of uploading the learning materials, especially the video files with large data volume, is easy to occur. If the uploading fails, the uploading operation needs to be manually re-executed, and the efficiency is low.
Disclosure of Invention
The embodiment of the invention provides a file processing method, device, equipment and medium based on RPA and AI, which are used for solving the problem of low efficiency of manually uploading files.
In a first aspect, the present invention provides a file processing method based on RPA and AI, including:
s1, reading a configuration file table, wherein the configuration file table comprises file information of a file to be uploaded and uploading path information;
s2, if the fact that the target website does not store the files to be uploaded is determined, acquiring the files to be uploaded, and sequentially uploading the files to be uploaded to the target website according to the corresponding uploading path information;
s3, filling file information corresponding to any successfully uploaded file in a webpage operation interface of the target website.
Optionally, the S1 includes:
s11, if the configuration file table is in a portable document PDF format or a picture format, an optical character recognition OCR component is called to recognize the configuration file table, and the content of each cell in the configuration file table and the position information of each cell in the table are obtained;
s12, determining file information and uploading path information of a file to be uploaded from the content of each cell;
Correspondingly, the step S2 specifically includes:
if the target website does not store the files to be uploaded, acquiring the files to be uploaded, and sequentially uploading the files to be uploaded to the target website according to the corresponding uploading path information according to the sequence of the positions of the files to be uploaded in the table.
Optionally, the S2 specifically includes:
s21, acquiring a login account number and a login password of a target website, and inputting the login account number and the login password into a login dialog box of the target website to login the target website;
s22, if the target website is determined not to store the file to be uploaded, acquiring the file to be uploaded, and uploading the file to be uploaded to a setting folder of the target website;
s23, moving the files in the setting folders to the corresponding target folders for storage according to the uploading path information.
Optionally, the method further comprises:
s24, for any one file in the set folders, if a target folder corresponding to the file type of the file does not exist in the file directory of the target website, creating the corresponding target folder in the target website according to the file type, and adding the target folder into the file directory.
Optionally, the method further comprises:
s4, in the process of logging in the target website, if the verification code is detected to exist, optical character OCR recognition is carried out on the verification code, and a recognition result is input into a verification code filling place of the login dialog box.
Optionally, the method further comprises:
s5, in the file uploading process, if prompt information of file uploading failure is detected or prompt information of file uploading success is not detected within a set time, the target website is withdrawn, and the re-login of the target website and the uploading operation of the file are executed.
Optionally, the file to be uploaded is learning material; correspondingly, the method further comprises the steps of:
determining a target user focusing on the type of the learning material according to the browsing record of the user;
and sending the prompt information of successful uploading of the learning materials to the target user.
In a second aspect, an embodiment of the present invention further provides a file processing device based on RPA and AI, including:
a profile reading module configured to: reading a configuration file table, wherein the configuration file table comprises file information of a file to be uploaded and uploading path information;
A file upload module configured to: if the target website is determined not to store the files to be uploaded, acquiring the files to be uploaded, and sequentially uploading the files to be uploaded to the target website according to the corresponding uploading path information;
the file information filling module is configured to: and filling file information corresponding to any successfully uploaded file in a webpage operation interface of the target website.
Optionally, the configuration file reading module includes:
an identification unit configured to: if the configuration file table is in a portable document PDF format or a picture format, an optical character recognition OCR component is called to recognize the configuration file table, so that the content of each cell in the configuration file table and the position information of each cell in the table are obtained;
an upload information determination unit configured to: determining file information and uploading path information of a file to be uploaded from the content of each cell;
correspondingly, the file uploading module is specifically configured to:
and acquiring the files to be uploaded, and sequentially uploading the files to be uploaded to a target website according to the corresponding uploading path information according to the sequence of the positions of the files to be uploaded in the table.
Optionally, the file uploading module includes:
a website login unit configured to: acquiring a login account number and a login password of a target website, and inputting the login account number and the login password into a login dialog box of the target website to login the target website;
a file uploading unit configured to: if the target website is determined not to store the file to be uploaded, acquiring the file to be uploaded, and uploading the file to be uploaded to a setting folder of the target website;
and the file moving unit is configured to move the files in the setting folders to the corresponding target folders for storage according to the uploading path information.
Optionally, the apparatus further includes:
a target folder creation unit configured to: for any one file in the set folders, if a target folder corresponding to the file type of the file does not exist in the file directory of the target website, creating a corresponding target folder in the target website according to the file type, and adding the target folder into the file directory.
Optionally, the apparatus further includes:
A verification code identification module configured to: and in the process of logging in the target website, if the verification code is detected to exist, performing optical character OCR (optical character recognition) on the verification code, and inputting a recognition result into a verification code filling place of the login dialog box.
Optionally, the apparatus further includes:
a re-upload module configured to: in the file uploading process, if the prompt information of file uploading failure is detected or the prompt information of file uploading success is not detected within a set time, the target website is withdrawn, the re-login of the target website is executed, and the file uploading operation is performed.
Optionally, the file to be uploaded is learning material; correspondingly, the device further comprises:
a target user determination module configured to: determining a target user focusing on the type of the learning material according to the browsing record of the user;
a message sending module configured to: and sending the prompt information of successful uploading of the learning materials to the target user.
In a third aspect, embodiments of the present invention also provide a computing device, including:
a memory storing executable program code;
a processor coupled to the memory;
The processor calls the executable program code stored in the memory to execute the file processing method based on RPA and AI provided by any embodiment of the invention.
In a fourth aspect, an embodiment of the present invention further provides a computer readable storage medium, where a computer program is stored, where the program when executed by a processor implements the RPA and AI-based file processing method provided by any embodiment of the present invention.
According to the technical scheme provided by the embodiment of the invention, the RPA robot can read the file information and the uploading path information of the files to be uploaded from the configuration file table, and sequentially upload the files to be uploaded to the target website according to the corresponding uploading path information. By adopting the RPA robot to replace manual operation to execute file uploading operation, a great deal of manpower resources and time resources are saved. After the file is successfully uploaded, the RPA robot can fill in the file description corresponding to the file in the webpage operation interface of the target website, so that the user can clearly and intuitively know the basic information of the file under the condition that the file is not opened, and convenience is provided for the user.
The innovation points of the embodiment of the invention include:
1. The RPA robot replaces manual work to read file information and uploading path information of the files to be uploaded from the configuration file table, and sequentially uploads the files to be uploaded to the target website according to the corresponding uploading path information, so that a great deal of manpower resources and time resources are saved, and the RPA robot is one of innovation points of the embodiment of the invention.
2. If the profile table is in PDF format or picture format, the PRA robot may invoke the OCR component to identify it, resulting in the content and rank information of each cell in the profile table. Compared with the mode of manually inquiring the information of the file to be uploaded from the configuration file table, the method adopts the mode of combining RPA and AI, saves a great amount of manpower resources, can improve the efficiency of file uploading, and is one of the innovation points of the embodiment of the invention.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1a is a flowchart of a file processing method based on RPA and AI according to a first embodiment of the invention;
fig. 1b is an effect screenshot of an RPA robot according to an embodiment of the present invention for filling a document description in a target website;
FIG. 2a is a flowchart of a file processing method based on RPA and AI according to a second embodiment of the invention;
fig. 2b is a flowchart effect screenshot of an RPA robot built on a flowchart automation platform according to a second embodiment of the present invention;
FIG. 3 is a block diagram of a file processing device based on RPA and AI according to a third embodiment of the invention;
fig. 4 is a schematic structural diagram of a computing device according to a fourth embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without any inventive effort, are intended to be within the scope of the invention.
It should be noted that the terms "comprising" and "having" and any variations thereof in the embodiments of the present invention and the accompanying drawings are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those listed steps or elements but may include other steps or elements not listed or inherent to such process, method, article, or apparatus.
In the description of the embodiment of the present invention, the "configuration file table" includes file information and upload path information of the file to be uploaded. The file information comprises file names, file numbers, file labels, file profiles and the like. When the RPA robot executes file uploading operation, uploading is carried out according to a configuration file table.
In the description of the embodiment of the present invention, the "target website" is a website configured at the server side and accessible to the user. The "server" refers to the back end of the service system with file uploading requirements.
In the description of the embodiment of the invention, the client is the front end of the service system with file uploading requirement, and can be application software corresponding to the service system or a browser, so that the RPA robot accesses a website of the service system through the browser.
In the description of the embodiment of the present invention, the "upload path information" is a storage address in the target website after the file to be uploaded is uploaded to the target website. The RPA robot may upload the file to the target folder of the target website according to the upload path information.
In the description of embodiments of the present invention, the term "conversational robot" refers broadly to a computer program capable of conversational interaction with a human being through speech or text.
In the description of the embodiments of the present invention, the term "knowledge corpus" is a structured collection formed by a number of knowledge points in a certain business domain.
In order to more clearly and clearly explain the contents of the embodiments of the present invention, the basic working principles of the embodiments of the present invention will be briefly described below.
Robot process automation (Robotic Process Automation), RPA for short, simulates the operation of a human on a computer by specific "robot software" and automatically executes process tasks according to rules.
AI (Artificial Intelligence) is an english abbreviation for artificial intelligence, which is a new technical science for studying, developing theories, methods, techniques and application systems for simulating, extending and expanding human intelligence. AI techniques used in embodiments of the present invention include OCR (Optical Character Recognition ) techniques and NLP (Natural Language Processing, natural language processing) techniques. In this embodiment, the OCR technology may be used to identify a PDF format or a profile table in a picture format, or may identify a picture in which a verification code is located in a web page. The file type of the file to be uploaded can be determined by adopting a semantic recognition algorithm in the NLP technology.
Currently, the uploading operation of document data, such as the uploading operation of training data, is completely completed manually. After logging in the learning website, the corresponding data is uploaded manually, and the data description is filled in. If network abnormality and system abnormality are encountered, the uploading operation and the filling data operation are performed from beginning, which is time-consuming and labor-consuming. In order to solve the above problems, according to the scheme provided by the embodiment of the invention, the RPA robot replaces manual operation, and uploads each file to be uploaded to the target website according to the uploading path information of the file to be uploaded in the configuration file table. And after each file is successfully uploaded, filling in a file description of the file in a webpage operation interface of the target website. If network failure occurs in the uploading process, the RPA robot will execute the uploading operation of the file again. The embodiment of the invention improves the file uploading efficiency and saves a great deal of manpower resources and time resources.
The embodiment of the invention discloses a file processing method, device, equipment and medium based on RPA and AI. The following will describe in detail.
Example 1
Fig. 1a is a flowchart of a file processing method based on RPA and AI according to an embodiment of the present invention, where the method may be applied to an application scenario of uploading various file data to a target website, typically, a scenario of uploading learning data to a learning platform. The user can upload, browse and download files stored in the target website through the private account. The target website can also be a sharing website for storing the sharing files. Different users can log in the shared website through the same account number, and browse and download the content of the website. The file processing method based on the RPA and the AI provided by the embodiment can be executed by a file processing device based on the RPA and the AI, the device can be realized by software and/or hardware, the technical scheme of the embodiment is executed by an RPA robot, the RPA robot can be carried on an UiBot Creator platform, and the UiBot Creator platform is a powerful robot production tool in a professional field and provides a good carrier for the robot. As shown in fig. 1a, the method comprises:
S110, reading the configuration file table.
The configuration file table can be used as a data description of the file to be uploaded, and comprises file information and uploading path information of the file to be uploaded. The file information comprises file names, file numbers, file labels, file profiles and the like. The configuration file may be written by the relevant personnel and stored in a locally designated folder. The RPA robot may read the contents of the profile table from the specified folder.
Illustratively, the profile table is typically an Excel (a type of spreadsheet software) document. The RPA robot may directly read the document content of the document according to the tabular format of the document, e.g., side-to-side format, or top-to-bottom format. Specifically, table 1 below is a profile table of learning files. As shown in table 1 below, the table is a table file in an up-down format, i.e., a first row, i.e., attribute information of the file, and starts from a second row to a specific file content, i.e., attribute value. The RPA robot can read out file information and uploading path information of the file to be uploaded according to the format of the table file. The uploading path information is a storage address of a file to be uploaded to a target website.
For example, if the profile table is a PDF (Portable Document Format ) format or a file in a picture format, the RPA robot may identify the profile table by invoking the OCR component to obtain the content of each cell in the profile table and the location information of each cell in the table, that is, a line index, and may extract the file information and the upload path information of the file to be uploaded from the content of each cell.
TABLE 1 learning material configuration file list
S120, if the fact that the target website does not store the files to be uploaded is determined, the files to be uploaded are obtained, and the files to be uploaded are uploaded to the target website in sequence according to the corresponding uploading path information.
In this embodiment, the RPA robot may log in to the target website through the login account and the login password of the target website, and may determine whether the website stores the file to be uploaded in the configuration file table.
For example, if it is determined that the target website already stores the file to be uploaded, the uploading operation is not performed on the file to be uploaded, and the file in the configuration file table may be marked to remind the file manager that the file is stored in the target website.
For example, if it is determined that the target website does not store the file to be uploaded, the file to be uploaded is obtained from a local setting folder. The local storage address of the file to be uploaded can be set in a configuration file table, and the RPA robot can acquire the file to be uploaded according to the local storage address in the table. Or when the flow block corresponding to the RPA robot is created, a flow block for opening the local setting folder can be created, so that the RPA robot can acquire the file to be uploaded by opening the local setting folder when executing the content of the flow block.
After the file to be uploaded is obtained, the file to be uploaded can be sequentially uploaded to a target website according to the file path information corresponding to each uploaded file. The uploading sequence of the file to be uploaded can be executed according to the sequence of the position of the file in the configuration file table. Specifically, when the RPA robot reads an unrecorded file to be uploaded from the configuration file table, the file acquiring and uploading operation is executed once.
In this embodiment, after each file to be uploaded is successfully uploaded, the website page pops up a message prompt box that the file is successfully uploaded. Of course, if the file uploading fails, the website page also pops up a message prompt box of the file uploading failure. The RPA robot can determine whether the file is successfully uploaded by identifying the prompt message in the prompt box. Specifically, the RPA robot can identify the prompt message in the message frame by using a semantic recognition or keyword matching method in the NLP technology, so as to determine whether the file is successfully uploaded.
S130, filling file information corresponding to any successfully uploaded file in a webpage operation interface of a target website.
In this embodiment, for any successfully uploaded file, after the file is successfully uploaded, the RPA robot needs to fill in a file description of the file in a web page operation interface of the target website, so that a user can know basic information of the file through the file description without opening a specific file.
Specifically, fig. 1b is an effect screenshot of the RPA robot according to the first embodiment of the present invention for filling in a document description at a target website. As shown in fig. 1b, the file information to be filled in includes file title, course number, course catalog, standard time of study, file label, file profile, etc. The RPA robot can read the file information of each file from the configuration file table and fill the file information into the target website.
According to the technical scheme provided by the embodiment, the RPA robot can read file information and uploading path information of the files to be uploaded from the configuration file table, and sequentially upload the files to be uploaded to the target website according to the corresponding uploading path information. By adopting the RPA robot to replace manual operation to execute file uploading operation, a great deal of manpower resources and time resources are saved. After the file is successfully uploaded, the RPA robot can fill in the file description corresponding to the file in the webpage operation interface of the target website, so that the user can clearly and intuitively know the basic information of the file under the condition that the file is not opened, and convenience is provided for the user.
Example two
Fig. 2a is a flowchart of a file processing method based on RPA and AI according to a second embodiment of the present invention, where, based on the foregoing embodiment, a login process of a target website, a specific process of uploading a file, and a process of clicking the file by a user accessing the target website after uploading the file are refined, as shown in fig. 2a, the method provided in this embodiment includes:
s210, reading the configuration file table to obtain file information and uploading path information of the file to be uploaded.
S220, acquiring a login account number and a login password of the target website, and inputting the login account number and the login password into a login dialog box of the target website to login the target website.
In this embodiment, if the presence of the verification code is detected during the process of logging in the target website, the OCR technology may be used to identify the picture in which the verification code is located, and the identification result is input to the verification code filling location of the login dialog.
And S230, if the target website is determined not to store the file to be uploaded, acquiring the file to be uploaded, and uploading the file to be uploaded to a setting folder of the target website.
In this embodiment, the setting folder may be used as a transfer station for storing files to be uploaded, so as to temporarily store each file to be uploaded, so that the files can be classified and stored according to file types of each file later.
S240, for any one file in the set folders, if a target folder corresponding to the file type of the file does not exist in the file directory of the target website, creating the corresponding target folder in the target website according to the file type, and adding the target folder into the file directory.
The file information of the profile table typically includes file types of files to be uploaded, for example. The RPA robot may read the file type of the file to be uploaded from the profile table.
In this embodiment, the file path information of the file to be uploaded is the storage address of the file in the target website, where the address can reflect the hierarchical relationship between folders in the target website, and the last level in the hierarchical relationship represents a specific file name and file format, for example, "organization architecture/company introduction/doc", "teaching video/basic lesson video/Chinese video/composition enhancement video.avi", or "cloud classroom video upload\video path\multiple process collaboration.wmv" as shown in table 1 above.
For example, the RPA robot may obtain the file type of the file to be uploaded by analyzing the file path information, which is usually the file name of the folder in which the file is located, for example, the type corresponding to the file to be uploaded is "chinese video" and the type corresponding to the file to be uploaded is "company introduction".
In particular, if the RPA robot cannot parse the file path information to obtain the file type, the file name of the file can be semantically identified by using the NLP technology to obtain the file type of the file.
In this embodiment, after determining the file type of the file to be uploaded, if it is detected that the target folder corresponding to the file type does not exist in the file directory of the target website, the corresponding target folder may be created in the target website according to the file type, so as to implement classified storage of the file. Specifically, the target folder may be named by the file type of the file. After creating the target folder, the target folder may be added to the file directory by refreshing the web interface of the target website.
S250, moving the files in the set folders to the corresponding target folders for storage according to the uploading path information.
And S260, in the process of uploading the file, if the prompt information of failure in uploading the file is detected or the prompt information of successful uploading of the file is not detected within a set time, the target website is exited, and the re-login of the target website and the uploading operation of the file are executed.
Those skilled in the art will appreciate that during the file uploading process, network anomalies or anomalies in the target website system may occur. The occurrence of the above situation will cause that the file cannot be uploaded to the target website normally. In the above case, the web interface usually presents a prompt message of failure in uploading the file, or the prompt message of successful uploading the file cannot be displayed within a set time, for example, 2 minutes. If the RPA robot recognizes that the prompt information of the file uploading failure exists or the prompt information of the file uploading success cannot be obtained in the set time, the file uploading failure is determined.
In the above case, the RPA robot may wait for the network to return to normal by continuously refreshing the web page, and may re-perform the uploading operation of the file after the network returns to normal.
For example, the RPA robot may also exit the target website and may re-perform the login of the target website and the uploading of the file.
The embodiment is arranged in such a way that the RPA robot replaces manual repeated file uploading operation under the condition of abnormal network or abnormal target website system, thereby saving manpower resources and a great deal of time,
Next, taking video information in which the file to be uploaded is learning material as an example, the contents provided in this embodiment will be described in detail. Fig. 2b is a flowchart effect screenshot of an RPA robot built on a flowchart automation platform according to a second embodiment of the present invention. As shown in fig. 2b, after each time of performing the uploading operation of the video information, the RPA robot determines whether the uploading process is abnormal, that is, whether the uploading failure prompt message is received or not is detected, or whether the uploading success prompt message is not received or not is determined within a set time. If no abnormality occurs, the video information is determined to be successfully uploaded.
Further, the database of the target website stores the attention of different students to each learning material type. The RPA robot can determine the target user focusing on the type of the learning materials according to the browsing records of the user on each folder of the target website, such as the click rate, and can send the prompt information of successful uploading of the learning materials to the target user, so that the target user can be reminded to watch the focused video information. The embodiment replaces the condition that whether the manually logged-in target website inquires whether the file concerned is uploaded or not, thereby providing great convenience for the operation of the user and improving the user experience.
In this embodiment, the target website may also be a shared storage space, for example, a shared space of office software of an enterprise, or a cloud space applied for use by the enterprise, and so on. Accordingly, the document to be uploaded may be document data, such as technical document data, product data or learning data, for viewing or downloading by the staff of the enterprise.
Under the application scenario, after uploading the file to be uploaded to the target website, the RPA robot can acquire the file names and links of all the files in the target website, and can add the file names and links of all the files to the knowledge corpus of the dialogue robot. The conversation robot is a computer program capable of performing conversation interaction with a human being through voice or text, and can be installed in common office software. By the arrangement, the problem that manual updating of the dialogue robot knowledge corpus is time-consuming and labor-consuming is solved, and the method is one of innovation points of the embodiment of the invention.
After the RPA robot is used for updating the knowledge corpus of the dialogue robot, the dialogue robot can automatically send the link corresponding to the latest file to the user in the process of inquiring the file by the dialogue robot, so that the operation of manually logging in a target website to search the file is avoided, the operation time is saved, and the working efficiency is improved.
For example, for a question sentence about a file to be queried input by a user, if a link of an answer corresponding to the question sentence does not exist in a knowledge corpus of the dialogue robot, directory information of the query sentence can be returned to the user, and the user can click on related options in the directory information according to actual requirements. The conversation robot can return file names and links thereof of the corresponding folders of the user according to clicking operation of the user so as to be accessed by the user. The method has the advantages that under the condition that the dialogue robot can not give answers to the question sentences of the user, more choices are provided for the user, and user experience is improved.
In the technical scheme provided by the embodiment, if the RPA robot determines that the target folder corresponding to the file type of the file to be uploaded does not exist in the file directory of the target website in the file uploading process, the corresponding target folder is created in the target website according to the file type. The setting is convenient for classifying and storing the files to be uploaded. In addition, after uploading the file to be uploaded to the target website, the RPA robot can acquire the file names and links of all the files in the target website, and can add the file names and links of all the files to the knowledge corpus of the conversation robot, so that the problem that the manual update of the knowledge corpus of the conversation robot is time-consuming and labor-consuming is solved.
Example III
Fig. 3 is a block diagram of a file processing device based on RPA and AI according to a third embodiment of the present invention, where, as shown in fig. 3, the device includes: a configuration file reading module 310, a file uploading module 320 and a file information filling module 330; wherein,
a profile reading module 310 configured to: reading a configuration file table, wherein the configuration file table comprises file information of a file to be uploaded and uploading path information;
a file upload module 320 configured to: if the target website is determined not to store the files to be uploaded, acquiring the files to be uploaded, and sequentially uploading the files to be uploaded to the target website according to the corresponding uploading path information;
the file information filling module 330 is configured to: and filling file information corresponding to any successfully uploaded file in a webpage operation interface of the target website.
Optionally, the configuration file reading module includes:
an identification unit configured to: if the configuration file table is in a portable document PDF format or a picture format, an optical character recognition OCR component is called to recognize the configuration file table, so that the content of each cell in the configuration file table and the position information of each cell in the table are obtained;
An upload information determination unit configured to: determining file information and uploading path information of a file to be uploaded from the content of each cell;
correspondingly, the file uploading module is specifically configured to:
if the target website does not store the files to be uploaded, acquiring the files to be uploaded, and sequentially uploading the files to be uploaded to the target website according to the corresponding uploading path information according to the sequence of the positions of the files to be uploaded in the table.
Optionally, the file uploading module includes:
a website login unit configured to: acquiring a login account number and a login password of a target website, and inputting the login account number and the login password into a login dialog box of the target website to login the target website;
a file uploading unit configured to: if the target website is determined not to store the file to be uploaded, acquiring the file to be uploaded, and uploading the file to be uploaded to a setting folder of the target website;
and the file moving unit is configured to move the files in the setting folders to the corresponding target folders for storage according to the uploading path information.
Optionally, the apparatus further includes:
a target folder creation unit configured to: for any one file in the set folders, if a target folder corresponding to the file type of the file does not exist in the file directory of the target website, creating a corresponding target folder in the target website according to the file type, and adding the target folder into the file directory.
Optionally, the apparatus further includes:
a verification code identification module configured to: and in the process of logging in the target website, if the verification code is detected to exist, performing optical character OCR (optical character recognition) on the verification code, and inputting a recognition result into a verification code filling place of the login dialog box.
Optionally, the apparatus further includes:
a re-upload module configured to: in the file uploading process, if the prompt information of file uploading failure is detected or the prompt information of file uploading success is not detected within a set time, the target website is withdrawn, the re-login of the target website is executed, and the file uploading operation is performed.
Optionally, the file to be uploaded is learning material; correspondingly, the device further comprises:
A target user determination module configured to: determining a target user focusing on the type of the learning material according to the browsing record of the user;
a message sending module configured to: and sending the prompt information of successful uploading of the learning materials to the target user.
The file processing device based on the RPA and the AI provided by the embodiment of the invention can execute the file processing method based on the RPA and the AI provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method. Technical details not described in detail in the above embodiments may be referred to the RPA and AI-based file processing method provided in any embodiment of the present invention.
Example IV
Referring to fig. 4, fig. 4 is a schematic structural diagram of a computing device according to a fourth embodiment of the present invention. As shown in fig. 4, the computing device may include:
a memory 701 storing executable program code;
a processor 702 coupled with the memory 701;
the processor 702 invokes executable program codes stored in the memory 701 to execute the file processing method based on RPA and AI according to any embodiment of the present invention.
The embodiment of the invention discloses a computer readable storage medium which stores a computer program, wherein the computer program enables a computer to execute the file processing method based on RPA and AI provided by any embodiment of the invention.
In various embodiments of the present invention, it should be understood that the sequence numbers of the foregoing processes do not imply that the execution sequences of the processes should be determined by the functions and internal logic of the processes, and should not be construed as limiting the implementation of the embodiments of the present invention.
In the embodiments provided herein, it should be understood that "B corresponding to a" means that B is associated with a from which B may be determined. It should also be understood that determining B from a does not mean determining B from a alone, but may also determine B from a and/or other information.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units described above, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer-accessible memory. Based on this understanding, the technical solution of the present invention, or a part contributing to the prior art or all or part of the technical solution, may be embodied in the form of a software product stored in a memory, comprising several requests for a computer device (which may be a personal computer, a server or a network device, etc., in particular may be a processor in a computer device) to execute some or all of the steps of the above-mentioned method of the various embodiments of the present invention.
Those of ordinary skill in the art will appreciate that all or part of the steps of the various methods of the above embodiments may be implemented by a program that instructs associated hardware, the program may be stored in a computer readable storage medium including Read-Only Memory (ROM), random access Memory (Random Access Memory, RAM), programmable Read-Only Memory (Programmable Read-Only Memory, PROM), erasable programmable Read-Only Memory (Erasable Programmable Read Only Memory, EPROM), one-time programmable Read-Only Memory (OTPROM), electrically erasable programmable Read-Only Memory (EEPROM), compact disc Read-Only Memory (Compact Disc Read-Only Memory, CD-ROM) or other optical disk Memory, magnetic disk Memory, tape Memory, or any other medium that can be used for carrying or storing data that is readable by a computer.
Those of ordinary skill in the art will appreciate that: the drawing is a schematic diagram of one embodiment and the modules or flows in the drawing are not necessarily required to practice the invention.
Those of ordinary skill in the art will appreciate that: the modules in the apparatus of the embodiments may be distributed in the apparatus of the embodiments according to the description of the embodiments, or may be located in one or more apparatuses different from the present embodiments with corresponding changes. The modules of the above embodiments may be combined into one module, or may be further split into a plurality of sub-modules.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some of the technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (13)
1. The file processing method based on RPA and AI is characterized by comprising the following steps:
s1, reading a configuration file table, wherein the configuration file table comprises file information of a file to be uploaded and uploading path information;
s2, if the target website is determined not to store the files to be uploaded, acquiring the files to be uploaded, sequentially uploading each file to be uploaded to the target website according to corresponding uploading path information, acquiring file names and links of all files in the target website after uploading the files to be uploaded to the target website, and adding the file names and links of all files to a knowledge corpus of a conversation robot so that the conversation robot can send links corresponding to the latest files to a user; in the process of inquiring a file by a dialogue robot, for a question sentence about the file to be inquired, which is input by a user, if a link of an answer corresponding to the question sentence does not exist in a knowledge corpus of the dialogue robot, the directory information of the query sentence is returned to the user, and the dialogue robot returns the file name of a folder corresponding to the user and the link thereof according to the click operation of the user on target information so as to be accessed by the user;
S3, filling file information corresponding to any successfully uploaded file in a webpage operation interface of the target website.
2. The method according to claim 1, wherein S1 comprises:
s11, if the configuration file table is in a portable document PDF format or a picture format, an optical character recognition OCR component is called to recognize the configuration file table, and the content of each cell in the configuration file table and the position information of each cell in the table are obtained;
s12, determining file information and uploading path information of a file to be uploaded from the content of each cell;
correspondingly, the step S2 specifically includes:
if the target website does not store the files to be uploaded, acquiring the files to be uploaded, and sequentially uploading the files to be uploaded to the target website according to the corresponding uploading path information according to the sequence of the positions of the files to be uploaded in the table.
3. The method according to claim 1, wherein S2 specifically comprises:
s21, acquiring a login account number and a login password of a target website, and inputting the login account number and the login password into a login dialog box of the target website to login the target website;
S22, if the target website is determined not to store the file to be uploaded, acquiring the file to be uploaded, and uploading the file to be uploaded to a setting folder of the target website;
s23, moving the files in the setting folders to the corresponding target folders for storage according to the uploading path information.
4. A method according to claim 3, characterized in that the method further comprises:
s24, for any one file in the set folders, if a target folder corresponding to the file type of the file does not exist in the file directory of the target website, creating the corresponding target folder in the target website according to the file type, and adding the target folder into the file directory.
5. A method according to claim 3, characterized in that the method further comprises:
s4, in the process of logging in the target website, if the verification code is detected to exist, optical character OCR recognition is carried out on the verification code, and a recognition result is input into a verification code filling place of the login dialog box.
6. A method according to claim 3, characterized in that the method further comprises:
S5, in the file uploading process, if prompt information of file uploading failure is detected or prompt information of file uploading success is not detected within a set time, the target website is withdrawn, and the re-login of the target website and the uploading operation of the file are executed.
7. The method of claim 1, wherein the file to be uploaded is learning material; correspondingly, the method further comprises the steps of:
determining a target user focusing on the type of the learning material according to the browsing record of the user;
and sending the prompt information of successful uploading of the learning materials to the target user.
8. A document processing apparatus based on RPA and AI, comprising:
a profile reading module configured to: reading a configuration file table, wherein the configuration file table comprises file information of a file to be uploaded and uploading path information;
a file upload module configured to: if the target website does not store the files to be uploaded, acquiring the files to be uploaded, sequentially uploading the files to be uploaded to the target website according to the corresponding uploading path information, acquiring file names and links of all files in the target website after uploading the files to be uploaded to the target website, and adding the file names and links of all files to a knowledge corpus of a conversation robot so that the conversation robot can send links corresponding to the latest files to a user; in the process of inquiring a file by a dialogue robot, for a question sentence about the file to be inquired, which is input by a user, if a link of an answer corresponding to the question sentence does not exist in a knowledge corpus of the dialogue robot, the directory information of the query sentence is returned to the user, and the dialogue robot returns the file name of a folder corresponding to the user and the link thereof according to the click operation of the user on target information so as to be accessed by the user;
The file information filling module is configured to: and filling file information corresponding to any successfully uploaded file in a webpage operation interface of the target website.
9. The apparatus of claim 8, wherein the profile reading module comprises:
an identification unit configured to: if the configuration file table is in a portable document PDF format or a picture format, an optical character recognition OCR component is called to recognize the configuration file table, so that the content of each cell in the configuration file table and the position information of each cell in the table are obtained;
an upload information determination unit configured to: determining file information and uploading path information of a file to be uploaded from the content of each cell;
correspondingly, the file uploading module is specifically configured to:
if the target website does not store the files to be uploaded, acquiring the files to be uploaded, and sequentially uploading the files to be uploaded to the target website according to the corresponding uploading path information according to the sequence of the positions of the files to be uploaded in the table.
10. The apparatus of claim 8, wherein the file upload module comprises:
A website login unit configured to: acquiring a login account number and a login password of a target website, and inputting the login account number and the login password into a login dialog box of the target website to login the target website;
a file uploading unit configured to: if the target website is determined not to store the file to be uploaded, acquiring the file to be uploaded, and uploading the file to be uploaded to a setting folder of the target website;
and the file moving unit is configured to move the files in the setting folders to the corresponding target folders for storage according to the uploading path information.
11. The apparatus of claim 10, wherein the apparatus further comprises:
a target folder creation unit configured to: for any one file in the set folders, if a target folder corresponding to the file type of the file does not exist in the file directory of the target website, creating a corresponding target folder in the target website according to the file type, and adding the target folder into the file directory.
12. A computing device, the computing device comprising:
One or more processors;
storage means for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the RPA and AI-based file processing method of any of claims 1-7.
13. A computer readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the RPA and AI-based file processing method according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111283652.7A CN114024955B (en) | 2021-11-01 | 2021-11-01 | File processing method, device, equipment and medium based on RPA and AI |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111283652.7A CN114024955B (en) | 2021-11-01 | 2021-11-01 | File processing method, device, equipment and medium based on RPA and AI |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114024955A CN114024955A (en) | 2022-02-08 |
| CN114024955B true CN114024955B (en) | 2024-03-12 |
Family
ID=80059236
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111283652.7A Active CN114024955B (en) | 2021-11-01 | 2021-11-01 | File processing method, device, equipment and medium based on RPA and AI |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114024955B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116016157A (en) * | 2022-12-02 | 2023-04-25 | 中盈优创资讯科技有限公司 | Excel-based configurable RPA website inspection method and device |
| CN117573243B (en) * | 2024-01-17 | 2024-05-10 | 杭州实在智能科技有限公司 | RPA file operation and management method and system for information creation system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110460668A (en) * | 2019-08-15 | 2019-11-15 | 深圳市盟天科技有限公司 | A kind of file uploading method, device, computer equipment and storage medium |
| CN110958292A (en) * | 2019-09-17 | 2020-04-03 | 平安银行股份有限公司 | File uploading method, electronic device, computer equipment and storage medium |
| CN111242577A (en) * | 2020-01-13 | 2020-06-05 | 中国建设银行股份有限公司 | RPA process automation robot deployment method and device and electronic equipment |
| CN111752900A (en) * | 2020-06-30 | 2020-10-09 | 北京来也网络科技有限公司 | File storage method, device, equipment and medium based on RPA and AI |
| WO2021003932A1 (en) * | 2019-07-05 | 2021-01-14 | 平安国际智慧城市科技股份有限公司 | File management method and apparatus, computer device and storage medium |
| CN112347042A (en) * | 2020-11-05 | 2021-02-09 | 中国平安人寿保险股份有限公司 | File uploading method and device, electronic equipment and storage medium |
| CN112668988A (en) * | 2019-10-15 | 2021-04-16 | 尤帕斯公司 | Media-to-workflow generation using Artificial Intelligence (AI) |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102685223A (en) * | 2012-04-28 | 2012-09-19 | 广州市动景计算机科技有限公司 | Cloud-storage-based file processing method and system |
-
2021
- 2021-11-01 CN CN202111283652.7A patent/CN114024955B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021003932A1 (en) * | 2019-07-05 | 2021-01-14 | 平安国际智慧城市科技股份有限公司 | File management method and apparatus, computer device and storage medium |
| CN110460668A (en) * | 2019-08-15 | 2019-11-15 | 深圳市盟天科技有限公司 | A kind of file uploading method, device, computer equipment and storage medium |
| CN110958292A (en) * | 2019-09-17 | 2020-04-03 | 平安银行股份有限公司 | File uploading method, electronic device, computer equipment and storage medium |
| CN112668988A (en) * | 2019-10-15 | 2021-04-16 | 尤帕斯公司 | Media-to-workflow generation using Artificial Intelligence (AI) |
| CN111242577A (en) * | 2020-01-13 | 2020-06-05 | 中国建设银行股份有限公司 | RPA process automation robot deployment method and device and electronic equipment |
| CN111752900A (en) * | 2020-06-30 | 2020-10-09 | 北京来也网络科技有限公司 | File storage method, device, equipment and medium based on RPA and AI |
| CN112347042A (en) * | 2020-11-05 | 2021-02-09 | 中国平安人寿保险股份有限公司 | File uploading method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114024955A (en) | 2022-02-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA3001800C (en) | Automated generation of narrative responses to data queries | |
| CN114024955B (en) | File processing method, device, equipment and medium based on RPA and AI | |
| US20130103391A1 (en) | Natural language processing for software commands | |
| US10235363B2 (en) | Instant translation of user interfaces of a web application | |
| US20150024351A1 (en) | System and Method for the Relevance-Based Categorizing and Near-Time Learning of Words | |
| US11663255B2 (en) | Automatic collaboration between distinct responsive devices | |
| CN102880683B (en) | The automatic network of a kind of feasibility study report generates system and the method for generation thereof | |
| US11557219B2 (en) | Generating and rating user assessments | |
| US11262978B1 (en) | Voice-adapted reformulation of web-based answers | |
| US20220309107A1 (en) | Self-supervision in table question answering | |
| CN112418875A (en) | Cross-platform tax intelligent customer service corpus migration method and device | |
| CN117725895A (en) | Document generation method, device, equipment and medium | |
| US11526567B2 (en) | Contextualizing searches in a collaborative session | |
| US20230177631A1 (en) | Automatically enhancing content items through identifying relationships | |
| US20230101339A1 (en) | Automatic response prediction | |
| WO2023100050A1 (en) | Conversational agent counterfactual simulation | |
| US11113081B2 (en) | Generating a video for an interactive session on a user interface | |
| Svetsky et al. | Universal IT Support Design for Engineering Education | |
| Sankar et al. | The Applied AI and Natural Language Processing Workshop: Explore practical ways to transform your simple projects into powerful intelligent applications | |
| CA2672630A1 (en) | Providing user assistance for a software application | |
| Warholm | Promoting Data Journalism with Purpose-Made Systems: A case study of the benefits of purpose-made data journalism systems among Norwegian Data Journalists | |
| Kabakchieva et al. | Big data approach and dimensions for educational industry | |
| US11314785B2 (en) | Automatic visualization and inquiry generation | |
| Hu et al. | Automatic language realization of remote training system for vocational education based on cloud computing | |
| US20230083444A1 (en) | Adjusting digital presentation material using machine learning models |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |