CN113805872B - E-commerce platform order logistics information acquisition method based on RPA robot - Google Patents
E-commerce platform order logistics information acquisition method based on RPA robot Download PDFInfo
- Publication number
- CN113805872B CN113805872B CN202111160133.1A CN202111160133A CN113805872B CN 113805872 B CN113805872 B CN 113805872B CN 202111160133 A CN202111160133 A CN 202111160133A CN 113805872 B CN113805872 B CN 113805872B
- Authority
- CN
- China
- Prior art keywords
- instruction
- information
- logistics
- order
- flow
- 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
- 238000000034 method Methods 0.000 title claims abstract description 51
- 230000008569 process Effects 0.000 claims description 15
- 238000005520 cutting process Methods 0.000 claims description 12
- 230000008676 import Effects 0.000 claims description 7
- 238000005316 response function Methods 0.000 claims description 5
- 238000012217 deletion Methods 0.000 claims description 4
- 230000037430 deletion Effects 0.000 claims description 4
- 230000009471 action Effects 0.000 claims description 3
- 230000001351 cycling effect Effects 0.000 claims description 3
- 239000003086 colorant Substances 0.000 claims 1
- 238000013461 design Methods 0.000 description 14
- 238000011161 development Methods 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000004801 process automation Methods 0.000 description 2
- 238000003860 storage Methods 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 239000002131 composite material Substances 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 239000011152 fibreglass Substances 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 238000004153 renaturation Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/32—Monitoring with visual or acoustical indication of the functioning of the machine
- G06F11/324—Display of status information
- G06F11/327—Alarm or error message display
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
- G06F11/3414—Workload generation, e.g. scripts, playback
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/083—Shipping
- G06Q10/0833—Tracking
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Economics (AREA)
- Software Systems (AREA)
- Quality & Reliability (AREA)
- General Business, Economics & Management (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Data Mining & Analysis (AREA)
- Marketing (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Computer Hardware Design (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Tourism & Hospitality (AREA)
- Operations Research (AREA)
- Computational Linguistics (AREA)
- Manipulator (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an E-commerce platform order logistics information acquisition method based on an RPA robot, which is used for acquiring order logistics information in an E-commerce platform through an RPA application flow, and comprises the following steps of S1, loading a dialogue box in the RPA robot, inputting a merchant account password in an account box of the dialogue box, and inputting order information and logistics analysis keywords in a data form of the dialogue box; s2, performing data deduplication and invalid data removal on the content in the data table; step S3, after entering a merchant background page according to the merchant account and the password, starting to operate an order logistics information acquisition flow: firstly, order information loaded by a data table is read, circulation order information data is traversed, order logistics information is searched in a merchant background according to the order information, the logistics information is classified according to logistics keyword information input by a user, and finally, the logistics information and classification results are output. The invention can improve the work efficiency of acquiring the logistics information in the electronic commerce platform.
Description
Technical Field
The invention relates to the technical field of RPA (remote procedure for assembly), in particular to an E-commerce platform order logistics information acquisition method based on an RPA robot.
Background
Robot process automation (Robotic Process Automation), RPA for short, is to simulate the operation of a human on a computer by robot software and automatically execute process tasks according to rules. Along with the increasing of enterprise information data, enterprises are promoted to rely on RPA greatly, and the RPA product can efficiently finish a large number of renaturation works by simulating the operation of people on a computer, can realize the processing of large-scale data with high quality, and greatly improves the office efficiency. However, for the user, there is still a relatively high technical threshold for the RPA process design, and a certain programming basis is needed to develop the design. At present, the RPA process design is usually required to be developed by a professional technician according to specific requirements, the connection between all sub-processes also needs to be manually configured by a user, the determination of each parameter also needs to be participated by the user, the professional degree requirement on the user is higher, the RPA process design is difficult to be carried out by a common technician or a process operator, and the application development of the RPA is greatly limited.
With the deep development of the Internet in China and the promotion of informatization construction of various industries, electronic commerce keeps growing at a high speed. The electronic commerce opens a new chapter of business relationship, people can purchase goods which are good for themselves without going out, and the electronic commerce is an empty word if no logistics exists. The logistics capability of a company directly influences the economic benefit of the company, and the timely acquisition of logistics information also becomes a necessary link of the work of each household appliance sub-business company. The current electronic commerce platforms are numerous, enterprises often need to spend a great deal of manpower for acquiring the logistics information of the electronic commerce orders in real time, and make related decisions according to the logistics state, so that an electronic commerce platform logistics information acquisition method based on the RPA robot is urgently needed. However, the conventional RPA development process is long, the adaptability to the multi-platform environment is poor, and the subsequent maintenance cost is high.
Disclosure of Invention
The invention aims to provide an E-commerce platform order logistics information acquisition method based on an RPA robot. According to the invention, a user can acquire the logistics information of the E-commerce platform through the RPA robot, so that the working efficiency can be improved, and the labor cost can be reduced.
In order to solve the technical problems, the technical scheme provided by the invention is as follows: an electronic commerce platform order logistics information acquisition method based on an RPA robot comprises the following steps:
setting up an RPA application flow in the RPA robot through instruction arrangement;
the order logistics information is acquired in the E-commerce platform through the RPA application flow, and the method comprises the following steps:
step S1, loading a dialog box in an RPA robot, inputting a merchant account password in an account box of the dialog box, and inputting order information and a logistics analysis keyword in a data form of the dialog box;
s2, performing data deduplication and invalid data removal on the content in the data table;
step S3, after entering a merchant background page according to the merchant account and the password, starting to operate an order logistics information acquisition flow: firstly, order information loaded by a data table is read, circulation order information data is traversed, order logistics information is searched in a merchant background according to the order information, the logistics information is classified according to logistics keyword information input by a user, and finally, the logistics information and classification results are output.
In the method for acquiring the order logistics information of the e-commerce platform based on the RPA robot, in the step S1, the unique number, the flag color and the remark information of the e-commerce platform to which the commodity belongs are input through manual input, copy and paste or Excel batch import;
the manual input is performed by double clicking on the table unit, and after an input cursor appears on the table unit, corresponding remark information is input;
the copy-paste is by pasting the copied content in the selected cell or by selecting copy Excel content,
the Excel batch import is to select an Excel file appointed for import through a pop-up file selection dialog box, select a Sheet page to be imported, and set whether the first row of content is needed to be used as a header.
In the foregoing method for acquiring order logistics information of an e-commerce platform based on an RPA robot, the process of performing data deduplication and invalid data removal on the data table in step S2 specifically includes:
s2.1, order information data and logistics keyword data input by a user are respectively read;
step S2.2, cycling the data acquired in step S2.1, and removing the data which are already appeared or are empty;
and step S2.3, rewriting the order information data processed in the step S2 into the column A of the dialog box, and storing the logistics keyword data in a global variable form.
In the foregoing method for acquiring order logistics information of e-commerce platform based on RPA robot, in step S3, a login website of each e-commerce platform merchant background is input and a web page is loaded, if loading fails or is overtime, the flow is terminated and an error reminder is popped up; if the loading is successful, automatically filling in platform merchant background login information to log in according to the account number and the password of the merchant background of the electronic commerce platform provided by the user, and if the login is unsuccessful, popping up a message prompt, and ending the subsequent steps of the step S3.
In the foregoing method for acquiring order logistics information of an e-commerce platform based on an RPA robot, the step S3 is executed to perform an order logistics information acquisition process, and the specific steps are as follows:
step S3.1, performing row circulation on the data table, and performing circulation traversal from the first row to the last row;
s3.2, circularly traversing to one row of data to acquire the order information of the row;
s3.3, sequentially opening logistics detail pages in a merchant background according to the circulated order numbers, acquiring logistics information and recording;
step S3.4, sorting the logistics information obtained in the step S3.3 by using the logistics keywords in the circulation data table, thereby completing the acquisition and sorting of the logistics information of the order at one time, and then entering the next circulation;
and step S3.5, outputting the logistics information and the classification result after the circulation is finished.
The order logistics information acquisition method of the e-commerce platform based on the RPA robot comprises the steps of instruction addition, instruction editing and instruction folding;
the instruction adding is to add the instructions in the instruction set list into a flow designer of the RPA robot;
the instruction editing is to edit the instruction added into the flow designer;
the instruction folding is to fold the instructions with specified positions and quantity in the flow designer, and add comments to improve the management efficiency of the flow instructions.
The method for acquiring the order logistics information of the e-commerce platform based on the RPA robot comprises the following specific implementation steps of:
a1, detecting a new instruction by the flow designer, judging a new instruction adding mode, and executing a step A2 if the new instruction adding mode is a dragging mode; if the mode is the double-click mode, executing the step A3;
a2, detecting a mode of adding the drag, acquiring a coordinate position of the drag of the mouse, and obtaining an optimal instruction placement position according to the coordinate;
a3, detecting a double-click adding mode, acquiring the position of the selected flow in the current flow designer, and setting the position of the newly added instruction as the selected position plus one;
a4, after determining the position of the added instruction, inserting a new instruction into the designated position of the instruction list of the flow designer, and refreshing the instruction list;
a5, detecting whether the added instruction has parameters to be configured, if not, completing the addition; if so, step S6 is performed.
And A6, popping up a parameter configuration interface of the newly added instruction to complete parameter configuration.
In the aforementioned method for acquiring order logistics information of e-commerce platform based on RPA robot, in step A4, a new instruction is inserted into a designated position in an instruction list of a flow designer, specifically,
a4.1, detecting whether an instruction exists at the drag-and-drop coordinate, if not, directly adding the instruction to the latest position of the current flow designer list, and if so, executing the A4.2;
a4.2, calculating the relative coordinate of the current mouse position on the existing instruction interface, if the y coordinate of the relative coordinate is smaller than half of the height of the instruction interface, namely, the upper half section of the instruction interface is inserted into the front of the instruction, otherwise, executing A4.3;
a4.3, if the y coordinate of the relative coordinate is greater than or equal to half the height of the command interface, namely in the lower half of the command interface, inserting the command.
The method for acquiring the order logistics information of the e-commerce platform based on the RPA robot comprises the steps of instruction movement, instruction copying, instruction cutting, instruction pasting, instruction deleting, instruction canceling and instruction redoing;
the instruction movement is to move the instructions in the instruction set list into the flow designer or move the instructions in the flow designer so as to adjust the position sequence of the instructions;
the instruction copying is to acquire all currently selected instruction information, convert all instruction information into text content and store the text content into a clipboard of a platform;
the instruction cutting is to acquire all currently selected instruction information, convert all the instruction information into text content, store the text content into a cutting board and delete all the selected instructions;
the instruction pasting is to obtain instruction information from the cutting board and insert the instruction information into a designated position;
the instruction deletion is to delete all the currently selected instructions;
the instruction cancellation is to acquire each operation information of a user through a registration operation behavior response function, store the corresponding information into a cache list, acquire the last operation information from the cache list when cancellation operation is used, and restore the last operation information to a previous state;
the instruction redo is to save the action of the instruction undo operation to restore the user to the previous state of the instruction undo.
The method for acquiring the order logistics information of the e-commerce platform based on the RPA robot comprises the following steps of:
b1, judging whether the application main flow is currently running or in a pause state, and if so, stopping folding operation; if not, executing the step B2;
b2, acquiring a selected instruction list from a flow designer;
b3, detecting the length of the selected instruction list, and stopping the current operation if the length is 0; if the length is greater than 0, executing the step B4;
b4, acquiring a position serial number startIndex of the first instruction and a position serial number endIndex of the last instruction in the list;
b5, inserting a folding start instruction at a startIndex position; and inserting a folding end instruction at the position of endIndex+1 to finish instruction folding.
Compared with the prior art, the RPA application flow is built through instruction arrangement in the RPA robot, and a user can conveniently arrange the instructions to form building block type arrangement combination, so that the design of the RPA application flow is completed. The invention forms a whole RPA application flow by utilizing the arrangement combination formed by the instructions, and executes corresponding operation by the RPA application flow, thereby realizing the acquisition of logistics information in an e-commerce platform, simplifying manual operation, improving the working efficiency and saving the labor cost. In addition, the RPA application flow establishment of the invention can realize Low-Code (Low Code) and even No-Code (No Code) RPA products. The method further optimizes the steps of instruction arrangement, modularized design and flow debugging, so that a user can simply and conveniently carry out RPA application flow design, the difficulty of RPA application flow design is reduced, the handedness is improved, and the use of workers is facilitated. The invention also supports the calling of the Python script, and the user can independently carry out Python programming for the calling of the application flow, thereby greatly improving the expandability.
Drawings
Fig. 1 is a schematic diagram of an RPA robot of the present invention.
Detailed Description
The invention is further illustrated by the following examples and figures, which are not intended to be limiting.
Examples: an E-commerce platform order logistics information acquisition method based on an RPA robot is shown in fig. 1, and comprises the RPA robot, wherein the RPA robot comprises an instruction set, a flow designer, a result debugger, a flow manager, a global variable manager and a toolbar.
Instruction set 1 in fig. 1: the RPA storage management instruction is used for storing the RPA storage management instruction, and a user can select a required instruction to be added to the flow designer in a double-click or dragging mode to perform free design.
The flow designer 2 in fig. 1: and a visual RPA flow editing platform is provided for the user.
Result debugger 3 in fig. 1: for displaying program error information, log information, and other debug data.
The flow manager 4 in fig. 1: and managing RPA flow, python script and other flow files.
Global variable manager 5 in fig. 1: the global variables are managed.
Toolbar 6 of fig. 1: including flow orchestration and debugging functions.
The visual design of the RPA flow is carried out by utilizing an RPA robot, and the steps comprise:
1. the instruction arrangement is used for constructing an RPA application flow on the RPA robot to form an application main flow; the instruction arrangement comprises instruction addition, instruction editing and instruction folding;
the instruction adding is to add instruction installation and operation logic in an instruction set list to a flow designer, and the specific implementation is as follows:
a1, detecting a new instruction by the flow designer, judging a new instruction adding mode, and executing a step A2 if the new instruction adding mode is a dragging mode; if the mode is the double-click mode, executing the step A3;
a2, detecting a mode of adding the drag, acquiring a coordinate position of the drag of the mouse, and obtaining an optimal instruction placement position according to the coordinate;
a3, detecting a double-click adding mode, acquiring the position of the selected flow in the current flow designer, and setting the position of the newly added instruction as the selected position plus one; the flow designer is essentially a list container to which each instruction unit is added, in which there is definitely an order and number, i.e. a position, for example: if the currently selected instruction is in the third row, the newly added instruction of double clicking is automatically added to the fourth row, if the fourth row has the instruction, the original fourth row instruction and all subsequent instructions are moved backwards by one unit position, the newly added instruction is moved to the place, and the same is deleted, after deleting a certain instruction, all subsequent instructions of the instruction are brought together, and the vacancy is filled;
a4, after determining the position of the added instruction, inserting a new instruction into the designated position of the instruction list of the flow designer, and refreshing the instruction list; in particular to a method for manufacturing a glass fiber reinforced plastic composite,
a4.1, detecting whether an instruction exists at the drag-and-drop coordinate, if not, directly adding the instruction to the latest position (the last position, namely the first position when one instruction does not exist) of the current flow designer list, and if so, executing A4.2;
a4.2, calculating the relative coordinate of the current mouse position on the existing instruction interface, if the y coordinate of the relative coordinate is smaller than half of the height of the instruction interface (namely, the upper half section of the instruction interface), inserting the relative coordinate into the front of the instruction, otherwise, executing A4.3;
a4.3, if the y coordinate of the relative coordinate is greater than or equal to half the height of the instruction interface (i.e. in the lower half of the instruction interface), inserting the instruction into the back of the instruction;
a5, detecting whether the added instruction has parameters to be configured, if not, completing the addition; if so, step S6 is performed.
A6, popping up a parameter configuration interface of the newly added instruction to complete parameter configuration, and if clicking [ confirm ] in the parameter configuration, completing addition; if click [ cancel ], cancel the addition.
The instruction editing is to edit the instruction added into the flow designer; the instruction editing comprises instruction movement, instruction copying, instruction cutting, instruction pasting, instruction deleting, instruction withdrawing and instruction redoing;
the instruction movement is to move the instructions in the instruction set list into the flow designer or move the instructions in the flow designer so as to adjust the position sequence of the instructions;
the instruction copying is to acquire all currently selected instruction information, convert all instruction information into text content and store the text content into a clipboard of a platform;
the instruction cutting is to acquire all currently selected instruction information, convert all the instruction information into text content, store the text content into a cutting board and delete all the selected instructions;
the instruction pasting is to obtain instruction information from the cutting board and insert the instruction information into a designated position; the method comprises the steps of obtaining an instruction information list from an RPA robot clipboard, obtaining the position of the list which needs to be inserted currently, completing the instruction information list insertion operation, and refreshing a designer flow list.
The instruction deletion is to delete all the currently selected instructions; the method comprises the steps of obtaining all current selected instruction information, sorting an obtained instruction information list, deleting the ordered instruction information list from the back to the front, completing the deletion of all instructions, and refreshing the content of the current designer.
The instruction cancellation is to acquire each operation information of a user through a registration operation behavior response function, store the corresponding information into a cache list, acquire the last operation information from the cache list when cancellation operation is used, and restore the last operation information to a previous state; specifically comprises
And step Y1, creating a revocation operation information list and registering an operation behavior response function.
And step Y2, acquiring user operation information.
And step Y3, clearing the redo operation information list. And adding new operation information at the last node of the operation information revocation list.
And Y4, detecting whether the length of the revocation operation information list exceeds an upper limit, and deleting the first node information of the list if the length of the revocation operation information list exceeds the upper limit.
When the user uses the revocation operation, the implementation steps include:
step P1, calling a revocation function, detecting whether the length of a revocation information list is 0, and if so, returning to not perform any operation; if not, step S2 is performed.
And P2, popping up the last node of the revocation information list, and acquiring the node information.
And step P3, calling the revocation operation of the node.
And P4, adding the node information to the last node of the redo operation list.
The instruction redo operation depends on whether instruction undo is invoked, and the implementation steps include:
q1, detecting whether the length of the redo information list is 0, and if so, returning to the step of not performing any processing; if not, step S2 is performed.
Step Q1. detects if the redo information list length is 0, if so, returns without any processing; if not, step S2 is performed.
And step Q2, popping up the last node of the redo information list, and acquiring the node information.
Step Q3. invokes a redo operation of the node.
Step q4. Adding the node information to the last node of the revocation list.
The instruction redo is to save the action of the instruction undo operation to restore the user to the previous state of the instruction undo.
The instruction folding is to fold the instructions with specified positions and quantity in the flow designer, and add comments to improve the management efficiency of the flow instructions.
The instruction folding is specifically realized as follows:
b1, judging whether the application main flow is currently running or in a pause state, and if so, stopping folding operation; if not, executing the step B2;
b2, acquiring a selected instruction list from a flow designer;
b3, detecting the length of the selected instruction list, and stopping the current operation if the length is 0; if the length is greater than 0, executing the step B4;
b4, acquiring a position serial number startIndex of the first instruction and a position serial number endIndex of the last instruction in the list;
b5, inserting a folding start instruction at a startIndex position; and inserting a folding end instruction at the position of endIndex+1 to finish instruction folding.
And B6, refreshing the flow designer.
2. The modularized design is used for dividing the RPA application function into modules, packaging the modules into module sub-flows and calling the module sub-flows in the application main flow.
The modularized design comprises a sub-flow design, a sub-flow call and parameter transfer;
the sub-flow is designed to divide the RPA application function into modules and encapsulate the modules into module sub-flows, wherein the instruction arrangement in the module sub-flows is consistent with the application main flow, and therefore, the invention is not described in detail;
the sub-flow call is to call a module sub-flow in the application main flow, and specifically comprises the following steps:
and step H1, adding an instruction.
And step H2, configuring instruction parameters, and selecting a sub-flow to be called.
Parameter transmission, for the parameter transmission which is necessary for the inter-flow call, the invention provides a parameter list for each flow, which is used for configuring any type of input and output parameters, and specifically comprises the following steps:
and step L1, selecting a specified flow, opening a flow parameter interface, and creating flow parameters.
And step L2, modifying parameter names, parameter directions and parameter types, setting default values and parameter descriptions according to requirements, and storing flow parameters.
And step L3, opening an instruction configuration page calling the flow (calling flow), and automatically loading a configured parameter list on the page.
And step L4, setting various parameters on an instruction configuration page.
3. The process debugging is used for realizing the debugging of the running of the main process and the sub-process of the module, the process debugging is carried out by breakpoint debugging and single step debugging through a process debugger, so that the process debugging starts to run from any position instruction, and a process running log is displayed through a log system, and the method is concretely realized as follows:
and step Y1, starting a debugger, and storing all relevant data such as a current instruction, a flow variable and the like.
And step Y3, acquiring all breakpoint information and setting the breakpoint information into the debugger.
And step Y4, starting the running debugger and registering the debugging information response function.
And step Y5, when the breakpoint instruction is normally operated or the single-step operation is operated, acquiring instruction debugging information and outputting the instruction debugging information to the interface.
Running log: the log system supports displaying the general flow running log, calling the log output by the [ print log ] instruction and abnormal message log. When the log information is too much, the log information is supported to be emptied, and when the log needs to be exported, the log content is supported to be exported by one key.
The invention obtains order logistics information on an e-commerce platform through an RPA application flow, which mainly comprises five parts, namely inputting a merchant account password, an order number and a logistics analysis keyword, de-duplicating the input information, automatically logging in a merchant background, inquiring logistics information, classifying and outputting an operation result, wherein the operation platform is a Taobao, and the steps are as follows:
step S1, loading a dialog box in the RPA robot, inputting a merchant account password in an account box of the dialog box, and inputting order information and a logistics analysis keyword in a data table of the dialog box. The input mode supports manual input, copy-paste and Excel batch import.
The manual input is to input corresponding remark information after an input cursor appears in a table unit by double-clicking the table unit; if the copied text content is selected for pasting, pasting the copied content in the selected cell; if the Excel content is selected to be copied and pasted, obtaining Excel format content in the shear plate, and pasting corresponding cell data into corresponding cells of the data table according to the row-column cell format; if the Excel file is selected to be imported, a file selection dialog box is popped up, the Excel file designated to be imported is selected, a Sheet page to be imported is selected, whether the first row of content is required to be used as a table header or not is set, and the Excel content is loaded.
S2, performing data deduplication and invalid data removal on the content in the data table; the method comprises the steps of carrying out a first treatment on the surface of the In order to avoid repeated data acquisition, the invention provides a data deduplication function according to the efficiency maximization principle, and comprises the following specific steps:
s2.1, order information data and logistics keyword data input by a user are respectively read;
step S2.2, cycling the data acquired in step S2.1, and removing the data which are already appeared or are empty;
and step S2.3, rewriting the order information data processed in the step S2 into the column A of the dialog box, and storing the logistics keyword data in a global variable form.
S3, inputting login websites of the background of each e-commerce platform merchant and loading web pages, and if loading fails or is overtime, terminating the flow and popping up error reminding; if the loading is successful, automatically filling in platform merchant background login information to log in according to the account number and the password of the merchant background of the electronic commerce platform provided by the user, and if the login is unsuccessful, popping up a message prompt, and ending the subsequent steps. After the login is successful, entering a merchant background page according to a merchant account and a password, and starting to run an order logistics information acquisition flow: firstly, order information loaded by a data table is read, circulation order information data is traversed, order logistics information is searched in a merchant background according to the order information, the logistics information is classified according to logistics keyword information input by a user, and finally, the logistics information and classification results are output, and the method comprises the following specific steps:
step S3.1, performing row circulation on the data table, and performing circulation traversal from the first row to the last row;
s3.2, circularly traversing to one row of data to acquire the order information of the row;
s3.3, sequentially opening logistics detail pages in a merchant background according to the circulated order numbers, acquiring logistics information and recording; if the ' system busy ' webpage element is detected, the webpage element is shown to be opened by the order, the ' no order is checked ' is input in the sixth column of the current row of the form, the manual check is required ', the circulation is ignored, and the next circulation is carried out; if the webpage element of 'the order is not yet shipped' is detected, the order is not yet shipped, the 'not yet shipped' is recorded in the sixth column of the current row of the form, the current circulation is ignored, and the next circulation is carried out; if the webpage element without logistics dynamics is detected, the order is indicated that logistics information is not queried, the 'no logistics information' is recorded in the sixth column of the current row of the form, the current circulation is ignored, and the next circulation is performed; the record of no flow information or different logistics information is adopted, and for normal logistics details, order specific logistics information is obtained according to the content of a logistics detail page.
Step S3.4, sorting the logistics information obtained in the step S3.3 by using the logistics keywords in the circulation data table, thereby completing the acquisition and sorting of the logistics information of the order at one time, and then entering the next circulation;
and S3.5, outputting the logistics information and the classification result after the circulation is finished, and leading out the data as an Excel file by a user so as to form the acquisition of the logistics information of the E-commerce platform order.
In summary, according to the invention, the RPA application flow is built through instruction arrangement in the RPA robot, so that a user can conveniently arrange the instructions to form a building block type arrangement combination, thereby completing the design of the RPA application flow. The invention forms a whole RPA application flow by utilizing the arrangement combination formed by the instructions, and executes corresponding operation by the RPA application flow, thereby realizing automatic acquisition of logistics information in an e-commerce platform, simplifying manual operation, improving working efficiency and saving labor cost.
Claims (4)
1. An E-commerce platform order logistics information acquisition method based on an RPA robot is characterized by comprising the following steps of: comprising the following steps:
setting up an RPA application flow in the RPA robot through instruction arrangement;
the order logistics information is acquired in the E-commerce platform through the RPA application flow, and the method comprises the following steps:
step S1, loading a dialog box in an RPA robot, inputting a merchant account password in an account box of the dialog box, and inputting order information and a logistics analysis keyword in a data form of the dialog box;
s2, performing data deduplication and invalid data removal on the content in the data table;
step S3, after entering a merchant background page according to the merchant account and the password, starting to operate an order logistics information acquisition flow: firstly, order information loaded by a data table is read, circulation order information data is traversed, order logistics information is searched in a merchant background according to the order information, the logistics information is classified according to logistics keyword information input by a user, and finally, the logistics information and classification results are output;
in step S2, the process of performing data deduplication and invalid data removal on the data table specifically includes:
s2.1, order information data and logistics keyword data input by a user are respectively read;
step S2.2, cycling the data acquired in step S2.1, and removing the data which are already appeared or are empty;
step S2.3, rewriting the order information data processed in the step S2.2 into an A column of a data table, and storing the logistics keyword data in a global variable form;
step S3, an order logistics information acquisition flow is operated, and the specific steps are as follows:
step S3.1, performing row circulation on the data table, and performing circulation traversal from the first row to the last row;
s3.2, circularly traversing to one row of data to acquire the order information of the row;
s3.3, sequentially opening logistics detail pages in a merchant background according to the circulated order numbers, acquiring logistics information and recording;
step S3.4, sorting the logistics information obtained in the step S3.3 by using the logistics keywords in the circulation data table, thereby completing the acquisition and sorting of the logistics information of the order at one time, and then entering the next circulation;
s3.5, outputting the logistics information and the classification result after the circulation is finished;
the instruction arrangement comprises instruction addition, instruction editing and instruction folding;
the instruction adding is to add the instructions in the instruction set list into a flow designer of the RPA robot;
the instruction editing is to edit the instruction added into the flow designer;
the instruction folding is to fold the instructions with specified positions and quantity in the flow designer, and add comments to improve the management efficiency of the flow instructions;
the instruction addition is specifically realized as follows:
a1, detecting a new instruction by the flow designer, judging a new instruction adding mode, and executing a step A2 if the new instruction adding mode is a dragging mode; if the mode is the double-click mode, executing the step A3;
a2, detecting a mode of adding the drag, acquiring a coordinate position of the drag of the mouse, and obtaining an optimal instruction placement position according to the coordinate;
a3, detecting a double-click adding mode, acquiring the position of the selected flow in the current flow designer, and setting the position of the newly added instruction as the selected position plus one;
a4, after determining the position of the added instruction, inserting a new instruction into the designated position of the instruction list of the flow designer, and refreshing the instruction list;
a5, detecting whether the added instruction has parameters to be configured, if not, completing the addition; if yes, executing the step A6;
a6, popping up a parameter configuration interface of the newly added instruction to complete parameter configuration;
in step A4, a new instruction is inserted into the instruction list of the flow designer at a specified position, specifically,
a4.1, detecting whether an instruction exists at the drag-and-drop coordinate, if not, directly adding the instruction to the latest position of the current flow designer list, and if so, executing the A4.2;
a4.2, calculating the relative coordinate of the current mouse position on the existing instruction interface, if the y coordinate of the relative coordinate is smaller than half of the height of the instruction interface, namely, the upper half section of the instruction interface is inserted into the front of the instruction, otherwise, executing A4.3;
a4.3, if the y coordinate of the relative coordinate is greater than or equal to half of the height of the instruction interface, namely, the lower half section of the instruction interface, inserting the instruction into the rear of the instruction;
the instruction folding is specifically realized as follows:
b1, judging whether the application main flow is currently running or in a pause state, and if so, stopping folding operation; if not, executing the step B2;
b2, acquiring a selected instruction list from a flow designer;
b3, detecting the length of the selected instruction list, and stopping the current operation if the length is 0; if the length is greater than 0, executing the step B4;
b4, acquiring a position serial number startIndex of the first instruction and a position serial number endIndex of the last instruction in the list;
b5, inserting a folding start instruction at a startIndex position; and inserting a folding end instruction at the position of endIndex+1 to finish instruction folding.
2. The method for acquiring the order logistics information of the e-commerce platform based on the RPA robot according to claim 1, wherein the method comprises the following steps: in the step S1, inputting unique numbers, flag colors and remark information of an electronic commerce platform to which the commodity belongs through manual input, copy and paste or Excel batch import;
the manual input is performed by double clicking on the table unit, and after an input cursor appears on the table unit, corresponding remark information is input;
the copy-paste is by pasting the copied content in the selected cell or by selecting copy Excel content,
the Excel batch import is to select an Excel file appointed for import through a pop-up file selection dialog box, select a Sheet page to be imported, and set whether the first row of content is needed to be used as a header.
3. The method for acquiring the order logistics information of the e-commerce platform based on the RPA robot according to claim 1, wherein the method comprises the following steps: in step S3, inputting login websites of the background of each e-commerce platform merchant and loading a webpage, if the loading fails or is overtime, terminating the flow and popping up an error prompt; if the loading is successful, automatically filling in platform merchant background login information to log in according to the account number and the password of the merchant background of the electronic commerce platform provided by the user, and if the login is unsuccessful, popping up a message prompt, and ending the subsequent steps of the step S3.
4. The method for acquiring the order logistics information of the e-commerce platform based on the RPA robot according to claim 1, wherein the method comprises the following steps: the instruction editing comprises instruction movement, instruction copying, instruction cutting, instruction pasting, instruction deleting, instruction withdrawing and instruction redoing;
the instruction movement is to move the instructions in the instruction set list into the flow designer or move the instructions in the flow designer so as to adjust the position sequence of the instructions;
the instruction copying is to acquire all currently selected instruction information, convert all instruction information into text content and store the text content into a clipboard of a platform;
the instruction cutting is to acquire all currently selected instruction information, convert all the instruction information into text content, store the text content into a cutting board and delete all the selected instructions;
the instruction pasting is to obtain instruction information from the cutting board and insert the instruction information into a designated position;
the instruction deletion is to delete all the currently selected instructions;
the instruction cancellation is to acquire each operation information of a user through a registration operation behavior response function, store the corresponding information into a cache list, acquire the last operation information from the cache list when cancellation operation is used, and restore the last operation information to a previous state;
the instruction redo is to save the action of the instruction undo operation to restore the user to the previous state of the instruction undo.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111160133.1A CN113805872B (en) | 2021-09-30 | 2021-09-30 | E-commerce platform order logistics information acquisition method based on RPA robot |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111160133.1A CN113805872B (en) | 2021-09-30 | 2021-09-30 | E-commerce platform order logistics information acquisition method based on RPA robot |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113805872A CN113805872A (en) | 2021-12-17 |
| CN113805872B true CN113805872B (en) | 2024-02-02 |
Family
ID=78897186
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111160133.1A Active CN113805872B (en) | 2021-09-30 | 2021-09-30 | E-commerce platform order logistics information acquisition method based on RPA robot |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113805872B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111882265A (en) * | 2020-06-29 | 2020-11-03 | 深圳市法本信息技术股份有限公司 | Cross-border e-commerce automatic customs declaration method and automatic customs declaration robot |
| CN112036791A (en) * | 2020-08-20 | 2020-12-04 | 深圳市亿源通供应链管理有限公司 | Cross-platform logistics order filling method and device, terminal equipment and storage medium |
| CN112948204A (en) * | 2021-02-07 | 2021-06-11 | 上海汉询软件有限公司 | Data processing system based on DataRobot technology |
| KR20210082919A (en) * | 2019-12-26 | 2021-07-06 | 조상근 | Production and logistics ERP automation system by linking and using customer information |
| KR20210082921A (en) * | 2019-12-26 | 2021-07-06 | 조상근 | Method of set-up interconnection parameters of suppliers and customers for production and logistics ERP automation system |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11613008B2 (en) * | 2019-01-14 | 2023-03-28 | International Business Machines Corporation | Automating a process using robotic process automation code |
| US11082561B2 (en) * | 2019-12-13 | 2021-08-03 | UiPath, Inc. | System and method for providing contextual assistance for contact center applications |
-
2021
- 2021-09-30 CN CN202111160133.1A patent/CN113805872B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20210082919A (en) * | 2019-12-26 | 2021-07-06 | 조상근 | Production and logistics ERP automation system by linking and using customer information |
| KR20210082921A (en) * | 2019-12-26 | 2021-07-06 | 조상근 | Method of set-up interconnection parameters of suppliers and customers for production and logistics ERP automation system |
| CN111882265A (en) * | 2020-06-29 | 2020-11-03 | 深圳市法本信息技术股份有限公司 | Cross-border e-commerce automatic customs declaration method and automatic customs declaration robot |
| CN112036791A (en) * | 2020-08-20 | 2020-12-04 | 深圳市亿源通供应链管理有限公司 | Cross-platform logistics order filling method and device, terminal equipment and storage medium |
| CN112948204A (en) * | 2021-02-07 | 2021-06-11 | 上海汉询软件有限公司 | Data processing system based on DataRobot technology |
Non-Patent Citations (4)
| Title |
|---|
| Mac Sullivan等.The Digital Transformation of Logistics: Demystifying Impacts of the Fourth Industrial Revolution.The Institute of Electrical and Electronics Engineers,2021,第61-78页. * |
| Robotic Process Automation: A Scientific and Industrial Systematic Mapping Study;J. G. Enríquez等;IEEE Access;第8卷;第39113-39129页 * |
| RPA in Finance: supporting portfolio management : Applying a software robot in a portfolio optimization problem;Felipe C. Magrin Ortiz等;2020 15th Iberian Conference on Information Systems and Technologies (CISTI);第1-6页 * |
| 基于PLM的B公司产品研发流程管理改进研究;何恩琪;中国优秀硕士学位论文全文数据库 工程科技Ⅱ辑(第3期);C035-37 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113805872A (en) | 2021-12-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Bangsow | Tecnomatix plant simulation | |
| US8412741B2 (en) | Product network management system and method | |
| US6901407B2 (en) | System and method for updating project management scheduling charts | |
| US8626477B2 (en) | Spreadsheet-based graphical user interface for modeling of products using the systems engineering process | |
| EP1456769A1 (en) | System and process for gathering, recording and validating requirements for computer applications | |
| JP3194823B2 (en) | CAD library model creation device | |
| US8327320B2 (en) | Process model lean notation | |
| JP5745932B2 (en) | Method, program, and system for reflecting operation on object which is image of mapping in graph data | |
| CN113806114B (en) | Goods presentation page contraband word checking method based on RPA robot | |
| US20050119852A1 (en) | Semiconductor test data analysis system | |
| CN113741881B (en) | RPA visual flow design method | |
| JP2022093293A (en) | Online report preparation system using excel tool | |
| CN113805872B (en) | E-commerce platform order logistics information acquisition method based on RPA robot | |
| CN113885856A (en) | Trigger operation method based on RPA robot | |
| CN113741882B (en) | RPA graphical instruction design method | |
| CN113743066A (en) | E-commerce platform commodity remarking method based on RPA robot | |
| JP2007316681A (en) | Operation procedure creation support device | |
| US10896161B2 (en) | Integrated computing environment for managing and presenting design iterations | |
| CN116450246A (en) | Event stream configurable method based on state machine | |
| CN110333906B (en) | Method, system, device and storage medium for rapidly processing reserved equipment | |
| AU760395B2 (en) | Program reproducing method and device, and medium on which program for program reproduction recording | |
| Tann et al. | The collaboration modelling framework for ship structural design | |
| CN113190514B (en) | Method for inputting data into electronic document according to priority order | |
| US11726792B1 (en) | Methods and apparatus for automatically transforming software process recordings into dynamic automation scripts | |
| CN117687681B (en) | Version management method and system for low-code application |
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 |