CN114024955A - 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
- CN114024955A CN114024955A CN202111283652.7A CN202111283652A CN114024955A CN 114024955 A CN114024955 A CN 114024955A CN 202111283652 A CN202111283652 A CN 202111283652A CN 114024955 A CN114024955 A CN 114024955A
- Authority
- CN
- China
- Prior art keywords
- file
- uploaded
- uploading
- target website
- target
- 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.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 21
- 238000000034 method Methods 0.000 claims abstract description 56
- 230000008569 process Effects 0.000 claims description 27
- 239000000463 material Substances 0.000 claims description 24
- 238000012015 optical character recognition Methods 0.000 claims description 22
- 238000012545 processing Methods 0.000 claims description 16
- 238000012795 verification Methods 0.000 claims description 16
- 238000004590 computer program Methods 0.000 claims description 7
- 230000003287 optical effect Effects 0.000 claims description 4
- 238000013473 artificial intelligence Methods 0.000 description 29
- 241000282414 Homo sapiens Species 0.000 description 10
- 230000005856 abnormality Effects 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 238000003058 natural language processing Methods 0.000 description 5
- 230000000694 effects Effects 0.000 description 4
- 238000004801 process automation Methods 0.000 description 4
- 230000008901 benefit Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 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
- 230000003993 interaction Effects 0.000 description 1
- 230000002452 interceptive effect Effects 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
- 239000000126 substance Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012549 training Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
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 target website is determined not to store the file to be uploaded, acquiring the file to be uploaded, and sequentially uploading each file to be uploaded to the target website according to corresponding uploading path information; and S3, for any file which is successfully uploaded, filling file information corresponding to the file in a webpage operation interface of the target website. By adopting the technical scheme, the problem of low file uploading efficiency manually is solved.
Description
Technical Field
The embodiment of the invention relates to the technical field of flow automation, in particular to a file processing method, a file processing device, file processing equipment and a file processing medium based on RPA and AI.
Background
RPA (robot Process Automation) simulates human operations on a computer through specific "robot software" and automatically executes Process tasks according to rules.
AI (Artificial Intelligence) is a new technical science for studying and developing 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 be operated without high IT level, and business personnel who do not know programming can also develop the flow; non-invasively, the RPA can simulate human operation without opening the interface with a software system. 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 limitation of the traditional RPA is overcome by the deep fusion of the RPA and the AI, and the RPA + AI is a Hand work + Head work, which greatly changes the value of the labor force.
Currently, uploading of enterprise file data is usually performed manually. Especially for some learning materials, after the trainees finish the learning material courseware, the trainees need to log in the learning website to upload the corresponding materials. Generally, the learning materials to be uploaded are a plurality of files, which is completely a repetitive mechanical labor. If the network is abnormal, uploading failure of learning materials, especially video files with large data volume, can be easily caused. If the uploading fails, the uploading operation needs to be executed again manually, and the efficiency is low.
Disclosure of Invention
The embodiment of the invention provides a file processing method, a file processing device, file processing equipment and a file processing medium based on RPA and AI, which are used for overcoming 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 target website is determined not to store the file to be uploaded, acquiring the file to be uploaded, and sequentially uploading each file to be uploaded to the target website according to corresponding uploading path information;
and S3, for any file which is successfully uploaded, filling file information corresponding to the 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, calling an Optical Character Recognition (OCR) component to recognize the configuration file table to obtain the content of each cell in the configuration file table and the position information of each cell in the table;
s12, determining file information and uploading path information of the file to be uploaded from the content of each cell;
correspondingly, the S2 specifically includes:
and 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 and a login password of a target website, and inputting the login account 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 set folder of the target website;
and S23, moving the files in the set folder to the corresponding target folder for storage according to the uploading path information.
Optionally, the method further includes:
and S24, for any one file in the set folders, if the 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 includes:
s4, in the process of logging in the target website, if the verification code is detected to exist, performing optical character OCR recognition on the verification code, and inputting the recognition result into the verification code filling part of the login dialog box.
Optionally, the method further includes:
and S5, in the file uploading process, if the prompt message of file uploading failure is detected or the prompt message of file uploading success is not detected within the set time, quitting the target website, and executing the re-login of the target website and the file uploading operation.
Optionally, the file to be uploaded is learning material; correspondingly, the method further comprises the following steps:
determining a target user concerning 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 apparatus based on RPA and AI, including:
a configuration file 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, and sequentially uploading the files to be uploaded to the target website according to corresponding uploading path information;
a file information filling module configured to: and for any file which is successfully uploaded, filling file information corresponding to the 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, calling an Optical Character Recognition (OCR) component to recognize the configuration file table to obtain the content of each cell in the configuration file table and the position information of each cell in the table;
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 sequence of the positions of the files to be uploaded in the table and the corresponding uploading path information.
Optionally, the file uploading module includes:
a website login unit configured to: acquiring a login account and a login password of a target website, and inputting the login account and the login password into a login dialog box of the target website to login the target website;
a file upload unit configured to: if the target website does not store the file to be uploaded, acquiring the file to be uploaded, and uploading the file to be uploaded to a set folder of the target website;
and the file moving unit is configured to move the files in the set folder to the corresponding target folder for storage according to the uploading path information.
Optionally, the apparatus further comprises:
a target folder creation unit configured to: and for any 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 comprises:
a passcode 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 the verification code filling part of the login dialog box.
Optionally, the apparatus further comprises:
a re-upload module configured to: in the file uploading process, if the prompt message of file uploading failure is detected or the prompt message of file uploading success is not detected within the set time, the target website is quitted, and the target website is re-logged in and the file uploading operation is executed.
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 concerning the type of the learning material according to the browsing record of the user;
a messaging module configured to: and sending the prompt information of successful uploading of the learning materials to the target user.
In a third aspect, an embodiment of the present invention further provides a computing device, including:
a memory storing executable program code;
a processor coupled with the memory;
the processor calls the executable program codes stored in the memory to execute the RPA and AI based file processing method provided by any embodiment of the invention.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the RPA and AI-based file processing method provided in 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 manpower to execute the file uploading operation, a large amount of manpower resources and time resources are saved. After the file is uploaded successfully, the RPA robot can fill in a file description corresponding to the file in a webpage operation interface of a target website, so that a user can clearly and intuitively know basic information of the file without opening the file, and convenience is provided for the user.
The innovation points of the embodiment of the invention comprise:
1. the RPA robot replaces manpower to read the file information and the uploading path information of the files to be uploaded from the configuration file table, and uploads the files to be uploaded to the target website in sequence according to the corresponding uploading path information, so that a large amount 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 configuration file table is in a PDF format or a picture format, the PRA robot can call an OCR component to recognize the configuration file table to obtain the content and row and column information of each cell in the configuration file table. Compared with a mode of manually inquiring the information of the file to be uploaded from the configuration file table, the embodiment of the invention adopts a mode of combining the RPA and the AI, thereby saving a large amount of human resources and improving the efficiency of uploading the file, and is one of the innovative points of the embodiment of the invention.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1a is a flowchart of a document processing method based on RPA and AI according to an embodiment of the present invention;
fig. 1b is an effect screenshot of a RPA robot filling a document description in a target website according to an embodiment of the present invention;
fig. 2a is a flowchart of a document processing method based on RPA and AI according to a second embodiment of the present invention;
fig. 2b is a screenshot of a process effect of an RPA robot built on a process automation platform according to a second embodiment of the present invention;
fig. 3 is a block diagram of a file processing apparatus based on RPA and AI according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a computing device according to a fourth embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without inventive effort based on the embodiments of the present invention, are within the scope of the present invention.
It is to be noted that the terms "comprises" and "comprising" and any variations thereof in the embodiments and drawings of the present invention 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 steps or elements listed, but may alternatively 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 of a file to be uploaded and upload path information. The file information includes a file name, a file number, a file label, a file introduction, and the like. And when the RPA robot executes file uploading operation, uploading the file according to the configuration file table.
In the description of the embodiment of the present invention, the "target website" is a website configured on the server side and accessible to the user. The server refers to a business system backend with file uploading requirements.
In the description of the embodiment of the present invention, the "client" is a front end of the service system having a file uploading requirement, and the "client" may be application software corresponding to the service system or a browser, so that the RPA robot can access 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 can upload the file to the target folder of the target website according to the uploading path information.
In the description of the embodiments of the present invention, the term "conversation robot" broadly refers to a computer program capable of conversational interaction with a human being through voice or text.
In the description of the embodiments of the present invention, the term "knowledge corpus" is a structured set formed by a plurality of knowledge points in a business field.
In order to clearly and clearly explain the contents of the embodiments of the present invention, the following briefly introduces the basic operation principle of the embodiments of the present invention.
Robot Process Automation (RPA) is a Process task that simulates human operations on a computer through specific robot software and automatically executes according to rules.
Ai (intellectual intelligence) is an english abbreviation for artificial intelligence, which is a new technical science for studying and developing theories, methods, techniques and application systems for simulating, extending and expanding human intelligence. The AI technique used in the embodiment of the present invention includes an OCR (Optical Character Recognition) technique and an NLP (Natural Language Processing) technique. In this embodiment, an OCR technology may be used to identify a configuration file table in a PDF format or 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.
At present, the uploading operation of document data, such as the uploading operation of training data, is completely performed manually. After logging in the learning website to upload the corresponding data, the user needs to fill in the data description. If network abnormality and system abnormality occur, the uploading operation and the data filling operation are still performed from the beginning, which wastes time and labor. In order to solve the above problem, in the solution provided in the embodiment of the present invention, an RPA robot replaces manual operation, and the RPA robot uploads each file to be uploaded to a target website according to upload path information of the file to be uploaded in a configuration file table. And after each file is uploaded successfully, filling a file description of the file in a webpage operation interface of the target website. And if a network fault occurs in the uploading process, the RPA robot re-executes the uploading operation of the file. The file uploading method and the file uploading device improve the file uploading efficiency and save a large amount of human resources and time resources.
The embodiment of the invention discloses a file processing method, a file processing device, file processing equipment and a file processing medium based on RPA and AI. The following are detailed below.
Example one
Fig. 1a is a flowchart of a document processing method based on RPA and AI according to an embodiment of the present invention, which can be applied in an application scenario of uploading various document materials to a target website, typically in a scenario of uploading learning materials to a learning platform. The user can upload, browse and download the files stored in the target website through the private account. The target website can also be a sharing website for storing sharing files. Different users can log in the shared website through the same account number, browse and download the content of the website. The RPA and AI-based file processing method provided in this embodiment may be implemented by an RPA and AI-based file processing apparatus, which may be implemented in a software and/or hardware manner. As shown in fig. 1a, the method comprises:
and S110, reading a configuration file table.
The configuration file table can be used as a data description of the file to be uploaded, and the configuration file table comprises file information and uploading path information of the file to be uploaded. The file information includes a file name, a file number, a file label, a file introduction, and the like. The configuration file may be written by the relevant personnel and stored in a locally specified 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 spreadsheet software) document. The RPA robot may read the document contents of the document directly according to the table format of the document, for example, left-right format, or top-bottom format. Specifically, table 1 below is a configuration file table of a learning file. As shown in table 1 below, the table is a table file in a top-bottom format, i.e. a first row header, i.e. attribute information of the file, and a specific file content, i.e. attribute value, starting from a second row. The RPA robot can read the file information and the 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 uploading the file to be uploaded to the target website.
Illustratively, if the configuration file table is a file in a PDF (Portable Document Format) Format or a picture Format, the RPA robot may call an OCR component to identify the configuration file table, obtain content of each cell in the configuration file table and location information of each cell in the table, that is, a row-column index, and extract file information and upload path information of a file to be uploaded from the content of each cell.
TABLE 1 learning materials configuration document Table
And S120, 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.
In this embodiment, the RPA robot may log in the 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 has the file to be uploaded stored therein, the file to be uploaded is not executed, and the file in the configuration file table may be marked to remind a file manager that the file has been 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 set folder. The local storage address of the file to be uploaded can be set in the 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 creating a flow block corresponding to the RPA robot, a flow block for opening a local setting folder may also be created, so that when the RPA robot executes the content of the flow block, the RPA robot obtains the file to be uploaded by opening the local setting folder.
After the files to be uploaded are obtained, the files can be sequentially uploaded to a target website according to the file path information corresponding to each uploaded file. The uploading sequence of the files to be uploaded can be executed according to the sequence of the positions of the files in the configuration file table. Specifically, each time an prestored file to be uploaded is read from the configuration file table, the RPA robot executes the operation of acquiring and uploading the file.
In this embodiment, after each file to be uploaded is successfully uploaded, the website page pops up a message prompt box indicating that the file is successfully uploaded. Of course, if the file uploading fails, the website page may also pop up a message prompt box indicating that the file uploading fails. The RPA robot can determine whether the file is uploaded successfully by recognizing the prompt information in the prompt box. Specifically, the RPA robot can identify the prompt message in the message frame by a semantic recognition or keyword matching method in the NLP technology to determine whether the file is uploaded successfully.
And S130, for any file which is successfully uploaded, filling file information corresponding to the file in a webpage operation interface of the target website.
In this embodiment, for any file that is successfully uploaded, 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 a 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 a screenshot of an effect of filling a document description on a target website by the RPA robot according to an embodiment of the present invention. As shown in fig. 1b, the document information to be filled in includes document title, course number, course directory, standard hour, document label, document brief introduction, etc. The RPA robot can read the file information of each file from the configuration file table and fill in the target website.
According to the technical scheme provided by the embodiment, 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 manpower to execute the file uploading operation, a large amount of manpower resources and time resources are saved. After the file is uploaded successfully, the RPA robot can fill in a file description corresponding to the file in a webpage operation interface of a target website, so that a user can clearly and intuitively know basic information of the file without opening the file, and convenience is provided for the user.
Example two
Fig. 2a is a flowchart of a document processing method based on RPA and AI according to a second embodiment of the present invention, where in this embodiment, on the basis of the foregoing embodiment, details are performed on a login process of a target website, a specific process of uploading a document, and a process of a user accessing the target website and clicking the document after uploading the document, as shown in fig. 2a, the method according to this embodiment includes:
s210, reading the configuration file table to obtain file information and uploading path information of the file to be uploaded.
S220, obtaining a login account and a login password of the target website, and inputting the login account and the login password into a login dialog box of the target website to login the target website.
In this embodiment, in the process of logging in the target website, if the verification code is detected to exist, an OCR technology may be used to identify the picture where the verification code is located, and the identification result is input to the verification code filling place of the login dialog box.
And S230, if the target website does not store the file to be uploaded, acquiring the file to be uploaded, and uploading the file to be uploaded to a set folder of the target website.
In this embodiment, the set folder may serve as a transfer station for storing the files to be uploaded, and is used to temporarily store the files to be uploaded, so that the files can be classified and stored subsequently according to the file types of the files.
S240, for any file in the set folders, if the target folder corresponding to the file type of the file does not exist in the file directory of the target website, the corresponding target folder is created in the target website according to the file type, and the target folder is added into the file directory.
For example, the file information of the configuration file table usually contains the file type of the file to be uploaded. 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 a storage address of the file on the target website, the address can reflect a hierarchical relationship between folders of the target website, and the last level in the hierarchical relationship represents a specific file name and a specific file format, such as "organization architecture/company introduction/company profile", "teaching video/basic course video/language video/composition enhanced video. avi", or "cloud classroom video upload \ video path \ multi-flow collaboration.wmv" as shown in table 1 above.
For example, the RPA robot may obtain a file type of the file to be uploaded by parsing the file path information, where the file type is usually a file name of a folder in which the file is located, for example, a type corresponding to the file to be uploaded is "language video" and a type corresponding to the file to be uploaded is "company introduction".
Particularly, if the RPA robot cannot analyze the file type from the file path information, the file name of the file can be semantically identified by the NLP technology to obtain the file type of the file.
In this embodiment, after the file type of the file to be uploaded is determined, 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 the classified storage of the file. In particular, the target folder may be named by the file type of the file. After the target folder is created, the target folder may be added to the file directory by refreshing the web interface of the target website.
And S250, moving the files in the set folder to the corresponding target folder for storage according to the uploading path information.
And S260, in the file uploading process, if the prompt message of file uploading failure is detected or the prompt message of file uploading success is not detected within the set time, quitting the target website, and re-logging the target website and uploading the file.
As can be understood by those skilled in the art, during the file uploading process, a network anomaly or a target website system anomaly may occur. The occurrence of the above situation will cause the file to be unable to be uploaded to the target website normally. Under the above circumstances, the web interface usually presents a prompt message indicating that the file uploading fails, or cannot display a prompt message indicating that the file uploading succeeds within a set time, for example, 2 minutes. And if the RPA robot identifies that prompt information of file uploading failure exists or cannot obtain the prompt information of file uploading success within set time, determining that the file uploading failure exists.
For example, in the above case, the RPA robot may wait for the network to recover to normal by continuously refreshing the web page, and may re-execute the file uploading operation after the network recovers to normal.
For example, the RPA robot may also exit the target website and may re-perform the login and file upload operations of the target website.
The embodiment is arranged in such a way that the RPA robot replaces manual work to repeatedly execute the file uploading operation under the condition of network abnormality or target website system abnormality, thereby saving human resources and a large amount of time,
the following describes the contents provided in this embodiment in detail, taking the video information of which the file to be uploaded is the learning material as an example. Fig. 2b is a screenshot of a process effect of an RPA robot built on a process automation platform according to the second embodiment of the present invention. As shown in fig. 2b, after each time the RPA robot performs the uploading operation of the video information, it determines whether there is an abnormality in the uploading process, that is, it detects whether the prompt message indicating that the uploading has failed is received or determines whether the prompt message indicating that the uploading has succeeded is not received within a set time. And if the abnormality does not occur, determining that the uploading of the video information is successful.
Furthermore, the database of the target website stores the attention conditions of different students to various learning material types. The RPA robot can determine a target user concerning the type of the learning material according to the browsing record of the user on each folder of the target website, such as the click rate, and can send the prompt message that the learning material is uploaded successfully to the target user, so that the target user can be reminded to watch the concerned video information. According to the method, the situation that whether the file concerned by the target website is uploaded or not is inquired by manually logging in the target website is replaced, great convenience is provided for the operation of a user, and the user experience is improved.
In this embodiment, the target website may also be a shared storage space, for example, a shared space of enterprise office software, or a cloud space used by an enterprise application. Correspondingly, the file to be uploaded can be file data for the employees of the enterprise to view or download, such as technical file data, product data or learning data.
Under the application scene, after uploading the file to be uploaded to the target website, the RPA robot can acquire the file names and the links of all the files in the target website and can add the file names and the links of all the files to the knowledge corpus of the conversation robot. The interactive robot is a computer program that can interact with human beings through voice or text, and can be installed in common office software. By means of the arrangement, the problem that manual updating of the knowledge corpus of the conversation robot is time-consuming and labor-consuming is solved, and the problem is one of innovation points of the embodiment of the invention.
After the RPA robot is used for updating the knowledge corpus of the phone robot, the conversation robot can automatically send the link corresponding to the latest file to the user in the process that the user inquires the file through the conversation robot, so that the operation of manually logging in a target website to search for 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, which is input by a user, if a link corresponding to an answer of the question sentence does not exist in the knowledge corpus of the conversation robot, directory information of the query sentence can be returned to the user, and the user can click a relevant option in the directory information according to actual requirements. The dialogue robot can return the file names and the links of the corresponding folders to the user according to the clicking operation of the user, so that the user can access the file names and the links. The advantage of setting up like this is, under the condition that the dialogue robot can not give user's quiz sentence answer, provide more selections for the user, promote user experience.
According to the technical scheme provided by the embodiment, in the file uploading process, 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, the corresponding target folder is created in the target website according to the file type. By the arrangement, the files to be uploaded can be conveniently classified and stored. In addition, after uploading the file to be uploaded to the target website, the RPA robot can acquire the file names and the links of all the files in the target website and add the file names and the links of all the files to the knowledge corpus of the conversation robot, so that the problem that the manual updating 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 apparatus based on RPA and AI according to a third embodiment of the present invention, and as shown in fig. 3, the apparatus includes: a configuration file reading module 310, a file uploading module 320 and a file information filling module 330; wherein the content of the first and second substances,
a configuration file 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 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 corresponding uploading path information;
a file information filling module 330 configured to: and for any file which is successfully uploaded, filling file information corresponding to the 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, calling an Optical Character Recognition (OCR) component to recognize the configuration file table to obtain the content of each cell in the configuration file table and the position information of each cell in the table;
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 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 and a login password of a target website, and inputting the login account and the login password into a login dialog box of the target website to login the target website;
a file upload unit configured to: if the target website does not store the file to be uploaded, acquiring the file to be uploaded, and uploading the file to be uploaded to a set folder of the target website;
and the file moving unit is configured to move the files in the set folder to the corresponding target folder for storage according to the uploading path information.
Optionally, the apparatus further comprises:
a target folder creation unit configured to: and for any 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 comprises:
a passcode 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 the verification code filling part of the login dialog box.
Optionally, the apparatus further comprises:
a re-upload module configured to: in the file uploading process, if the prompt message of file uploading failure is detected or the prompt message of file uploading success is not detected within the set time, the target website is quitted, and the target website is re-logged in and the file uploading operation is executed.
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 concerning the type of the learning material according to the browsing record of the user;
a messaging 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 corresponding functional modules and beneficial effects of the execution method. For details of the document processing method based on RPA and AI provided in any embodiment of the present invention, reference may be made to the technical details not described in detail in the above embodiments.
Example four
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 in which executable program code is stored;
a processor 702 coupled to the memory 701;
the processor 702 calls the executable program code stored in the memory 701 to execute the RPA and AI-based file processing method 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 a 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 above-mentioned processes do not imply an inevitable order of execution, and the execution order of the processes should be determined by their functions and inherent logic, and should not constitute any limitation on the implementation process 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 can be determined. It should also be understood, however, that determining B from a does not mean determining B from a alone, but may also be determined from a and/or other information.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated units, if implemented as software functional units and sold or used as a stand-alone product, may be stored in a computer accessible memory. Based on such understanding, the technical solution of the present invention, which is a part of or contributes to the prior art in essence, or all or part of the technical solution, can be embodied in the form of a software product, which is stored in a memory and includes several requests for causing a computer device (which may be a personal computer, a server, a network device, or the like, and may specifically be a processor in the computer device) to execute part or all of the steps of the above-described method of each embodiment of the present invention.
It will be understood by those skilled in the art that all or part of the steps in the methods of the embodiments described above may be implemented by hardware instructions of a program, and the program may be stored in a computer-readable storage medium, where the storage medium includes Read-Only Memory (ROM), Random Access Memory (RAM), Programmable Read-Only Memory (PROM), 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 (CD-ROM), or other Memory, such as a magnetic disk, or a combination thereof, A tape memory, or any other medium readable by a computer that can be used to carry or store data.
Those of ordinary skill in the art will understand that: the figures are merely schematic representations of one embodiment, and the blocks or flow diagrams in the figures are not necessarily required to practice the present invention.
Those of ordinary skill in the art will understand that: modules in the devices in the embodiments may be distributed in the devices in the embodiments according to the description of the embodiments, or may be located in one or more devices different from the embodiments with corresponding changes. The modules of the above embodiments may be combined into one module, or further split into multiple sub-modules.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present 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 solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (13)
1. A 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 file to be uploaded, acquiring the file to be uploaded, and sequentially uploading each file to be uploaded to the target website according to corresponding uploading path information;
and S3, for any file which is successfully uploaded, filling file information corresponding to the file in a webpage operation interface of the target website.
2. The method according to claim 1, wherein the S1 includes:
s11, if the configuration file table is in a portable document PDF format or a picture format, calling an Optical Character Recognition (OCR) component to recognize the configuration file table to obtain the content of each cell in the configuration file table and the position information of each cell in the table;
s12, determining file information and uploading path information of the file to be uploaded from the content of each cell;
correspondingly, the S2 specifically includes:
and 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 the S2 specifically includes:
s21, acquiring a login account and a login password of a target website, and inputting the login account 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 set folder of the target website;
and S23, moving the files in the set folder to the corresponding target folder for storage according to the uploading path information.
4. The method of claim 3, further comprising:
and S24, for any one file in the set folders, if the 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. The method of claim 3, further comprising:
s4, in the process of logging in the target website, if the verification code is detected to exist, performing optical character OCR recognition on the verification code, and inputting the recognition result into the verification code filling part of the login dialog box.
6. The method of claim 3, further comprising:
and S5, in the file uploading process, if the prompt message of file uploading failure is detected or the prompt message of file uploading success is not detected within the set time, quitting the target website, and executing the re-login of the target website and the file uploading operation.
7. The method according to claim 1, wherein the document to be uploaded is a learning material; correspondingly, the method further comprises the following steps:
determining a target user concerning 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 file processing apparatus based on RPA and AI, comprising:
a configuration file 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, and sequentially uploading the files to be uploaded to the target website according to corresponding uploading path information;
a file information filling module configured to: and for any file which is successfully uploaded, filling file information corresponding to the file in a webpage operation interface of the target website.
9. The apparatus of claim 8, wherein the configuration file reading module comprises:
an identification unit configured to: if the configuration file table is in a portable document PDF format or a picture format, calling an Optical Character Recognition (OCR) component to recognize the configuration file table to obtain the content of each cell in the configuration file table and the position information of each cell in the table;
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 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 and a login password of a target website, and inputting the login account and the login password into a login dialog box of the target website to login the target website;
a file upload unit configured to: if the target website does not store the file to be uploaded, acquiring the file to be uploaded, and uploading the file to be uploaded to a set folder of the target website;
and the file moving unit is configured to move the files in the set folder to the corresponding target folder for storage according to the uploading path information.
11. The apparatus of claim 10, further comprising:
a target folder creation unit configured to: and for any 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, wherein the computing device comprises:
one or more processors;
a storage device for storing 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 one of claims 1-7.
13. A computer-readable storage medium on which a computer program is stored, the program, when executed by a processor, implementing the RPA and AI-based file processing method according to any one of claims 1 to 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 true CN114024955A (en) | 2022-02-08 |
| CN114024955B 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) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117573243A (en) * | 2024-01-17 | 2024-02-20 | 杭州实在智能科技有限公司 | RPA file operation and management method and system for information creation system |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140344892A1 (en) * | 2012-04-28 | 2014-11-20 | Guangzhou Ucweb Computer Technology Co., Ltd | Cloud-storage-based file processing method and system |
| 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) |
-
2021
- 2021-11-01 CN CN202111283652.7A patent/CN114024955B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140344892A1 (en) * | 2012-04-28 | 2014-11-20 | Guangzhou Ucweb Computer Technology Co., Ltd | Cloud-storage-based file processing method and system |
| 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 |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117573243A (en) * | 2024-01-17 | 2024-02-20 | 杭州实在智能科技有限公司 | RPA file operation and management method and system for information creation system |
| CN117573243B (en) * | 2024-01-17 | 2024-05-10 | 杭州实在智能科技有限公司 | RPA file operation and management method and system for information creation system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114024955B (en) | 2024-03-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8346563B1 (en) | System and methods for delivering advanced natural language interaction applications | |
| US10410219B1 (en) | Providing automatic self-support responses | |
| US11163936B2 (en) | Interactive virtual conversation interface systems and methods | |
| US11663255B2 (en) | Automatic collaboration between distinct responsive devices | |
| CN107180029A (en) | A kind of information processing method and device based on consultation service | |
| CN106202085A (en) | The method of information search, device and electronic equipment is carried out according to particular topic | |
| US20210141820A1 (en) | Omnichannel virtual assistant using artificial intelligence | |
| US11557219B2 (en) | Generating and rating user assessments | |
| US11188193B2 (en) | Method and system for generating a prioritized list | |
| CN112653798A (en) | Intelligent customer service voice response method and device, computer equipment and storage medium | |
| US20210150486A1 (en) | Dynamic determination of job requirements and candidate assessment | |
| CN115803734A (en) | Natural language enrichment using action interpretation | |
| CN114024955A (en) | File processing method, device, equipment and medium based on RPA and AI | |
| US20230409294A1 (en) | Adaptive user interfacing | |
| CN117648422A (en) | Question-answer prompt system, question-answer prompt, library construction and model training method and device | |
| US11526567B2 (en) | Contextualizing searches in a collaborative session | |
| US20220244847A1 (en) | Intelligent Keyboard | |
| US20230177631A1 (en) | Automatically enhancing content items through identifying relationships | |
| US11989261B2 (en) | Answering questions with artificial intelligence using tabular data | |
| KR102391447B1 (en) | Method and Apparatus for Providing Hybrid Intelligent Customer Consultation | |
| CN110895924B (en) | Method and device for reading document content aloud, electronic equipment and readable storage medium | |
| CN111984781A (en) | Automated summarization of bias minimization | |
| Sankar et al. | The Applied AI and Natural Language Processing Workshop: Explore practical ways to transform your simple projects into powerful intelligent applications | |
| US11314785B2 (en) | Automatic visualization and inquiry generation | |
| US20240119854A1 (en) | Method for Automatically Converting a Text string to an Interactive Video Experience |
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 |