CN-121981098-A - Data docking method and device based on RPA tool and electronic equipment

CN121981098ACN 121981098 ACN121981098 ACN 121981098ACN-121981098-A

Abstract

The application discloses a data docking method, a device and electronic equipment based on an RPA tool, wherein the method comprises the steps of obtaining one or more medical projects of a target quality control platform to respectively correspond to an import template; the method comprises the steps of capturing a first data set from a data management platform by an RPA tool, controlling the RPA tool to match a plurality of first test items corresponding to one or more medical items with a plurality of second test items to determine the first test items corresponding to the second test items, controlling the RPA tool to fill item data of the second test items into an import template of the medical item of the first test item corresponding to each second test item to obtain import data corresponding to one or more medical items, and controlling the RPA tool to upload the import data corresponding to the one or more medical items to a target quality control platform. The application can improve the accuracy and efficiency of data butt joint between the data management platform and the target quality control platform.

Inventors

LIU MIN
CHEN YUEFU
GENG DAN
XU JING
YANG MIAO
Koh Yoshiaki
WEN ZHIQIANG
ZHANG CHENLI

Assignees

太原金域临床检验所有限公司

Dates

Publication Date: 20260505
Application Date: 20260126

Claims (10)

1. A method of data docking based on an RPA tool, the method comprising: acquiring an import template corresponding to one or more medical items of a target quality control platform, wherein the import template corresponding to each medical item comprises a plurality of first test items to be filled; Controlling a robot flow automation (RPA) tool to capture a first data set from a data management platform, wherein the first data set comprises project data corresponding to a plurality of second inspection projects respectively; controlling the RPA tool to match a plurality of first test items corresponding to the one or more medical items with a plurality of second test items, and determining the first test items corresponding to the plurality of second test items; controlling the RPA tool to fill item data of the plurality of second test items into an import template of medical items to which the first test items corresponding to the second test items belong respectively, so as to obtain import data corresponding to the one or more medical items respectively; And controlling the RPA tool to upload the imported data corresponding to the one or more medical projects to the target quality control platform.
2. The method of claim 1, wherein controlling the robotic flow automation RPA tool to grasp the first data set from the data management platform comprises: Obtaining organization structure information of a detection post; Controlling the RPA tool to access the data management platform; Controlling the RPA tool to identify a plurality of data expansion components corresponding to the organization architecture information in the data management platform, and triggering the plurality of data expansion components in sequence in a simulation operation mode so as to display one or more detection posts; controlling the RPA tool to identify the one or more detection posts; And controlling the RPA tool to trigger interface components corresponding to the detection posts in an analog operation mode, entering data display interfaces corresponding to the detection posts, and capturing item data corresponding to one or more second inspection items in the data display interfaces corresponding to the detection posts line by line.
3. The method of claim 1, wherein the item data of the second inspection item includes an item name and inspection result data; Before controlling the RPA tool to match a plurality of first test items to the plurality of second test items, the plurality of first test items corresponding to the one or more medical items, respectively, the method further comprises: Controlling the RPA tool to preprocess item data corresponding to the second test items respectively to obtain a second data set, wherein the preprocessing comprises removing the second test items with repeated item names and/or removing the second test items with repeated test result data; The controlling the RPA tool to match a plurality of first test items corresponding to the one or more medical items with the plurality of second test items, respectively, includes: controlling the RPA tool to match a plurality of first test items respectively corresponding to the one or more medical items with each second test item in the second data set.
4. A method according to claim 3, wherein the test result data of the second test item comprises one or more data items, and the number of data items of different second test items is the same; after the controlling the RPA tool performs preprocessing on item data corresponding to the second test items respectively to obtain a second data set, the method further includes: Controlling the RPA tool to count the first item number of a plurality of second test items in the second data set, and counting the second item number of a plurality of first test items in an import template corresponding to all medical items; Controlling the RPA tool to compare the first item number with the second item number, and if the first item number is smaller than the second item number, sending out first prompt information to prompt a user that the item number of a second check item in the second data set is incorrect; And/or the number of the groups of groups, Controlling the RPA tool to count the number of data items of the test result data corresponding to the second test items in the second data set, and if the number of data items of one or more second test items is determined to be smaller than the number threshold value, sending out second prompt information to prompt a user that the number of data items of the one or more second test items is insufficient.
5. A method according to claim 3, wherein prior to said controlling said RPA tool to match a plurality of first test items respectively corresponding to said one or more medical items with respective second test items in said second data set, said method further comprises: obtaining a standard project name list, wherein the standard project name list comprises project names corresponding to a plurality of third inspection projects respectively; Controlling the RPA tool to match the item names corresponding to the second checking items in the second data set with the item names corresponding to the third checking items respectively, and correcting the item names of the target second checking items according to the item names of the third checking items corresponding to the target second checking items to obtain corrected second data sets; The controlling the RPA tool to match a plurality of first check-up items respectively corresponding to the one or more medical items with each second check-up item in the second data set includes: Controlling the RPA tool to match a plurality of first test items respectively corresponding to the one or more medical items with each second test item in the modified second data set.
6. The method of claim 1, wherein the controlling the RPA tool to upload the imported data corresponding to the one or more medical items, respectively, to the target quality control platform comprises: Acquiring local storage paths corresponding to the one or more imported data respectively; controlling the RPA tool to access the target quality control platform; Controlling the RPA tool to search and enter a data input interface corresponding to a target medical item in the target quality control platform, wherein the target medical item is any one of the one or more medical items; Controlling the RPA tool to identify a first uploading component on a data input interface corresponding to the target medical item, triggering the first uploading component in a simulation operation mode, and displaying a data uploading window; controlling the RPA tool to input a target specimen local storage path of the imported data corresponding to the target medical project in the data uploading window; And controlling the RPA tool to identify a second uploading component in the data uploading window, and triggering the second uploading component in a simulation operation mode so as to read the imported data corresponding to the target medical item from the target local storage path and upload the imported data to a data input interface corresponding to the target medical item.
7. The method of claim 6, wherein after the controlling the RPA tool to upload the import data corresponding to the one or more medical items, respectively, to the target quality control platform, the method further comprises: Controlling the RPA tool to capture first item data at the target interface position in a data input interface corresponding to the target medical item according to a preset capture rule; controlling the RPA tool to extract second item data corresponding to the target interface position from the imported data corresponding to the target medical item; and controlling the RPA tool to compare the first project data with the second project data, and if the first project data is consistent with the second project data, determining that the uploading of the imported data corresponding to the target medical project is successful.
8. A data docking device based on RPA tools, comprising: the template acquisition module is used for acquiring an import template corresponding to one or more medical items of the target quality control platform respectively, wherein the import template corresponding to each medical item comprises a plurality of first test items to be filled; the data acquisition module is used for controlling the robot flow automation RPA tool to capture a first data set from the data management platform, wherein the first data set comprises project data corresponding to a plurality of second test projects respectively; The data matching module is used for controlling the RPA tool to match a plurality of first test items corresponding to the one or more medical items with a plurality of second test items and determining the first test items corresponding to the plurality of second test items; The data filling module is used for controlling the RPA tool to fill the item data of the plurality of second test items into the import templates of the medical items to which the first test items corresponding to the second test items belong respectively, so as to obtain the import data corresponding to the one or more medical items respectively; and the data docking module is used for controlling the RPA tool to upload the imported data corresponding to the one or more medical projects to the target quality control platform.
9. An electronic device comprising a memory and a processor, wherein the memory stores a computer program that, when executed by the processor, causes the processor to implement the method of any of claims 1-7.
10. A computer program product comprising a computer program which, when executed by a processor, causes the processor to carry out the method according to any one of claims 1 to 7.

Description

Data docking method and device based on RPA tool and electronic equipment Technical Field The application relates to the technical field of data processing, in particular to a data docking method and device based on an RPA tool and electronic equipment. Background At present, the requirements of patients for cross-regional and cross-medical institution consultation are increasing, the result mutual recognition work between the test result data of different medical institutions on the same test item is more important, and the test result data reflecting the self test level or diagnosis level of the institutions is a core precondition for realizing the cross-institution result mutual recognition. However, since data interfaces are not usually opened between data management platforms of different medical institutions, it is difficult to automatically upload test result data to a quality control (quality control) mechanism in a direct connection mode of the platforms, and the test result data of each medical institution lacks unified standards in terms of format standards and the like, the time and effort are consumed in a mode of manually inputting the test result data, and problems such as data omission and the like are easy to occur, so that the reliability of the test result data is questioned by the quality control mechanism, and popularization of mutual recognition of results is hindered. Therefore, how to efficiently and accurately perform data docking between data management platforms of different medical institutions to realize mutual recognition of results is one of the main problems that needs to be solved currently. Disclosure of Invention The embodiment of the application discloses a data docking method and device based on an RPA tool and electronic equipment, which can improve the accuracy and docking efficiency of data docking between a data management platform and a target quality control platform. The first aspect of the embodiment of the application discloses a data docking method based on an RPA tool, which comprises the following steps: acquiring an import template corresponding to one or more medical items of a target quality control platform, wherein the import template corresponding to each medical item comprises a plurality of first test items to be filled; Controlling a robot flow automation (RPA) tool to capture a first data set from a data management platform, wherein the first data set comprises project data corresponding to a plurality of second inspection projects respectively; controlling the RPA tool to match a plurality of first test items corresponding to the one or more medical items with a plurality of second test items, and determining the first test items corresponding to the plurality of second test items; controlling the RPA tool to fill item data of the plurality of second test items into an import template of medical items to which the first test items corresponding to the second test items belong respectively, so as to obtain import data corresponding to the one or more medical items respectively; And controlling the RPA tool to upload the imported data corresponding to the one or more medical projects to the target quality control platform. In some possible embodiments, the controlling the robotic flow automation RPA tool to grab the first data set from the data management platform comprises: Obtaining organization structure information of a detection post; Controlling the RPA tool to access the data management platform; Controlling the RPA tool to identify a plurality of data expansion components corresponding to the organization architecture information in the data management platform, and triggering the plurality of data expansion components in sequence in a simulation operation mode so as to display one or more detection posts; controlling the RPA tool to identify the one or more detection posts; And controlling the RPA tool to trigger interface components corresponding to the detection posts in an analog operation mode, entering data display interfaces corresponding to the detection posts, and capturing item data corresponding to one or more second inspection items in the data display interfaces corresponding to the detection posts line by line. In some possible embodiments, the item data of the second inspection item includes an item name and inspection result data; Before controlling the RPA tool to match a plurality of first test items to the plurality of second test items, the plurality of first test items corresponding to the one or more medical items, respectively, the method further comprises: Controlling the RPA tool to preprocess item data corresponding to the second test items respectively to obtain a second data set, wherein the preprocessing comprises removing the second test items with repeated item names and/or removing the second test items with repeated test result data; The controlling the RPA tool to match a plurality of first test items corresp