CN110660461B - Cross-platform medical data information uploading system based on artificial intelligence - Google Patents

Abstract

The present invention relates to a cross-platform medical data information upload system based on artificial intelligence, comprising a database system, an artificial intelligence robot and a login reporting system, the database system comprising a HIS system, target files and target web pages; the artificial intelligence robot It includes reading data module, data processing module, login module, filling data module, judging module and sending mail module. The invention has the advantages of realizing data transfer between two systems without interfaces; multiple ways of collecting data; reducing the workload of reporting personnel and reducing the error rate of reporting; it imitates manual operation, does not belong to crawler technology, and will not be seized.

Description

A cross-platform medical data information upload system based on artificial intelligence

technical field

The invention relates to the technical field of medical data acquisition, in particular to an artificial intelligence-based cross-platform medical data information upload system.

Background technique

At present, the professional-related medical quality information data of each hospital is usually carried out in the form of paper filling, mail reporting or research. It is difficult to collect information through paper or mail reporting, and it is necessary to arrange special personnel to sort and enter the data in order to carry out effective analysis and utilization. Since the medical quality control indicators of each specialty are different, and the medical specialties set up by each hospital are also different, it is difficult for the network system to collect data to cover all hospitals and all specialties, which is not conducive to the effective management and utilization of the data of each specialty.

At present, the use of artificial intelligence for data upload has the following problems. When reading data, the data source needs to open a port to read the data. In this way, if the developer of the data source system is unwilling to open the port or needs a large amount of money to develop , This will slow down the development process and increase the cost. At present, there is a background method for reporting data to the reporting system. This method will be detected by the background of the reporting system as an inhuman operation, and the IP will be blocked.

Contents of the invention

In order to solve the above problems, the present invention provides an artificial intelligence-based cross-platform medical data information uploading system.

In order to solve the above technical problems, the technical solution provided by the present invention is: a cross-platform medical data information upload system based on artificial intelligence, including a database system, an artificial intelligence robot, and a login reporting system. The original data system includes HIS system, The target file and the target webpage; the target file refers to the file containing the target data, and the target data refers to the data that we need to read and report.

The artificial intelligence robot includes a data reading module, a data processing module, a login module, a data filling module, a judgment module, and a mail sending module;

The login reporting system links the login module.

There are many ways for artificial intelligence robots to obtain data. They can read data from the database of the HIS system, read data from Excel tables, and obtain data from web pages. According to different situations, set different reading methods to obtain the target. Data, the data reading module includes: reading data from the HIS system is to give the path to the artificial intelligence robot, and the artificial intelligence robot automatically queries the database file of the path and imports it, screens out the target data, and stores it in the artificial intelligence robot;

To read data from the target file is to call the path and name, and call the createoleobject function of Delphi to get an ole object, and use this object to call the interface of the target file to operate the target file;

Reading data from the target webpage is by looking for characteristic attributes, such as id, name, and css, so as to locate. After the location is set, the target data can be obtained.

The AI robot described supports text replacement, pattern-based replacement, case conversion, removing spaces, removing non-printing characters, creating strings, getting substrings, searching strings, inserting or extracting special characters, string operations operate;

Supports the use of JavaScript to perform custom string conversion processing operations;

Support the extraction, conversion, and formatting operations of digital data;

Supports arithmetic operations (supports almost all mathematical operators), rounding, taking maximum/minimum values, etc.;

Support the operation of the function of number format pattern application (such as specifying decimal and thousand separators, specifying the number of decimal places);

Support extraction, conversion, calculation and formatting operations of date/time type data;

Support extracting date or time elements from date type data (such as obtaining the year, day or hour of the date);

Support 12-hour or 24-hour non-stop operation;

Support the time zone operation that can be set to work when extracting date and time;

Support convenient date operation processing (such as modifying a date or calculating the time between two dates);

Support operations such as obtaining the current date, time, week, etc. at any point in robot processing;

Support for formatting date/time data manipulation in various ways;

Support automatic extraction of date/time data from the website and calculate or display its quasi-date/time data operation of "3 hours ago" or "2 days ago";

Support HTML format data extraction and conversion operations;

Support for any of the processing capabilities listed above for "strings" generally applies to HTML manipulation as well;

Supports removing all types of specific HTML tag operations in a given HTML string;

Support counting the number of special tags in HTML strings;

Support data conversion operations based on logical rules;

Support logical structure operations that can realize an unlimited number of if-then/else;

Support other conversion processing capability operations;

Artificial intelligence robots can convert various types of data (such as the conversion between strings and dates);

Artificial intelligence robots can generate random numbers;

The artificial intelligence robot can calculate and input the MD5 check code of the data, and the robot data can be exported;

Send mail through the SMTP server, and dynamically generate the content and recipients of the mail;

AI bots can send emails with attachments;

AI bots can read and write files in the file system;

Artificial intelligence robots can simulate human filling in forms in web pages, and can dynamically process page input elements;

Artificial intelligence robots can dynamically traverse drop-down boxes and radio button groups;

AI robots can write data to text files in various formats, including XML, JSON, CSV, etc.;

The described data filling module is for positioning the mouse by the api interface SetCursorPos function of windows in the target file;

Send the event of pressing the left button and releasing the mouse through the api interface mouse_event of windows, and the right button is the same as the left button;

Send some character information through the api interface keybd_event of windows, use it to open the website and enter the corresponding page that needs to fill in the data; then fill in the data inside the artificial intelligence robot in a one-to-one correspondence. Compared with the existing technology, the virtual keyboard and mouse are operated in a simulated manual way, rather than the background login operation, so that the system will not be reported to the system to detect abnormal operations and be blocked.

The sending email module is to call the email library in python to complete the corresponding function, and then let Pascal call it. The effect achieved is: when the robot runs perfectly, an email will be sent to the user, and if it fails to run perfectly, a warning will also be sent to the user, so that the user will know whether the robot is running completely.

The configuration of the artificial intelligence robot includes:

If the access to the website page times out, the robot can make multiple attempts, and can be set to wait for a specified period of time between attempts before proceeding;

By default, the artificial intelligence robot does not load the URL of the advertising content, which can be turned on or off through configuration;

AI robots can be configured not to load certain URLs that match specific URL patterns;

Artificial intelligence robots can be configured to only load certain URLs that match specific URL patterns;

It is possible to configure whether the artificial intelligence robot ignores the CSS style sheet;

You can configure whether the artificial intelligence robot loads the Frame framework;

It is possible to configure whether the artificial intelligence robot allows metadata redirection;

It is possible to configure whether the artificial intelligence robot ignores JavaScript events;

AI bots can optionally ignore any errors encountered (such as missing or invalid JavaScript scripts) when loading a page.

The present invention has the advantages of: 1. Data transmission between two systems without interfaces can be realized;

2. Multiple ways to collect data;

3. Reduce the workload of reporting personnel and reduce the reporting error rate;

4. It imitates manual operation, does not belong to crawler technology, and will not be seized;

5. Data automatic transcription;

6. Automatically report data to the corresponding system.

Description of drawings

FIG. 1 is a block diagram of an artificial intelligence-based cross-platform medical data information uploading system in the present invention.

Fig. 2 is an operation flowchart of an artificial intelligence robot of an artificial intelligence-based cross-platform medical data information uploading system according to the present invention.

Fig. 3 is an operation flowchart of an embodiment of an artificial intelligence-based cross-platform medical data information uploading system of the present invention.

Detailed ways

The present invention will be described in further detail below in conjunction with the accompanying drawings.

A cross-platform medical data information upload system based on artificial intelligence, including a database system, an artificial intelligence robot, and a login reporting system. The original data system includes a HIS system, a target file, and a target web page;

The artificial intelligence robot includes a data reading module, a data processing module, a login module, a data filling module, a judgment module, and a mail sending module;

The login reporting system links the login module.

The data reading module includes: reading data from the HIS system is to give the path to the artificial intelligence robot, and the artificial intelligence robot automatically queries the database file of the path and imports it, screens out the target data, and stores it in the artificial intelligence robot;

To read data from the target file, call the path and name, and call Pascal's createoleobject function to obtain an ole object, and use this object to call the interface of the target file to operate the target file;

Reading data from the target webpage is by looking for characteristic attributes, such as id, name, and css, so as to locate. After the location is set, the target data can be obtained.

The AI robot described supports text replacement, pattern-based replacement, case conversion, removing spaces, removing non-printing characters, creating strings, getting substrings, searching strings, inserting or extracting special characters, string operations operate;

Supports the use of JavaScript to perform custom string conversion processing operations;

Support the extraction, conversion, and formatting operations of digital data;

Supports arithmetic operations (supports almost all mathematical operators), rounding, taking maximum/minimum values, etc.;

Support the operation of the function of number format pattern application (such as specifying decimal and thousand separators, specifying the number of decimal places);

Support extraction, conversion, calculation and formatting operations of date/time type data;

Support extracting date or time elements from date type data (such as obtaining the year, day or hour of the date);

Support 12-hour or 24-hour non-stop operation;

Support the time zone operation that can be set to work when extracting date and time;

Support convenient date operation processing (such as modifying a date or calculating the time between two dates);

Support operations such as obtaining the current date, time, week, etc. at any point in robot processing;

Support for formatting date/time data manipulation in various ways;

Support automatic extraction of date/time data from the website and calculate or display its quasi-date/time data operation of "3 hours ago" or "2 days ago";

Support HTML format data extraction and conversion operations;

Support for any of the processing capabilities listed above for "strings" generally applies to HTML manipulation as well;

Supports removing all types of specific HTML tag operations in a given HTML string;

Support counting the number of special tags in HTML strings;

Support data conversion operations based on logical rules;

Support logical structure operations that can realize an unlimited number of if-then/else;

Support other conversion processing capability operations;

Artificial intelligence robots can convert various types of data (such as the conversion between strings and dates);

Artificial intelligence robots can generate random numbers;

The artificial intelligence robot can calculate and input the MD5 check code of the data, and the robot data can be exported;

Send mail through the SMTP server, and dynamically generate the content and recipients of the mail;

AI bots can send emails with attachments;

AI bots can read and write files in the file system,;

Artificial intelligence robots can simulate human filling in forms in web pages, and can dynamically process page input elements;

Artificial intelligence robots can dynamically traverse drop-down boxes and radio button groups;

AI robots can write data to text files in various formats, including XML, JSON, CSV, etc.;

The described data filling module is for positioning the mouse by the api interface SetCursorPos function of windows in the target file;

Send the event of pressing the left button and releasing the mouse through the api interface mouse_event of windows, and the right button is the same as the left button;

Send some character information through the api interface keybd_event of windows, use it to open the website and enter the corresponding page that needs to fill in the data; then fill in the data inside the artificial intelligence robot in a one-to-one correspondence.

The sending email module is to call the email library in python to complete the corresponding function, and then let Pascal call it.

The configuration of described artificial intelligence robot comprises:

If the access to the website page times out, the robot can make multiple attempts, and can be set to wait for a specified period of time between attempts before proceeding;

By default, the artificial intelligence robot does not load the URL of the advertising content, which can be turned on or off through configuration;

AI robots can be configured not to load certain URLs that match specific URL patterns;

Artificial intelligence robots can be configured to only load certain URLs that match specific URL patterns;

It is possible to configure whether the artificial intelligence robot ignores the CSS style sheet;

You can configure whether the artificial intelligence robot loads the Frame framework;

It is possible to configure whether the artificial intelligence robot allows metadata redirection;

It is possible to configure whether the artificial intelligence robot ignores JavaScript events;

AI bots can optionally ignore any errors encountered (such as missing or invalid JavaScript scripts) when loading a page.

Specific examples:

This embodiment discloses an application method based on an artificial intelligence-based cross-platform medical data information uploading system in an actual situation, which can simulate the repetitive operations of the staff on the PC. The repetitive operations of the staff on the PC include, reading Data, data processing and data reporting, as shown in Figure 3, the flow chart, the main data source of the staff is to export the Excel form from the data source system, and the artificial intelligence robot is set to read the Excel form with a specific name from a certain path. Get target data.

The specific operation is as follows:

1. Start segment: start running the robot;

2. Image positioning segment: judge whether to open the reporting system page, if it is judged to be, it can continue to proceed;

3. Rename fragments in batches: uniformly name the Excel that needs to be read, so that it is convenient to find the target file that needs to read data;

4. Read the Excel file fragment: read the target file to obtain the target data;

5. Execute the function fragment: process the target function to obtain the data that needs to be reported;

6. Enter the year and judge the branch fragment: it is to divide the processed information into years and months for judgment, so as to choose which year and which month to enter the reporting page;

7. Click to view, click to create a new segment: Here we will judge whether it is the first time to enter this reporting page; if yes, a new report page form will be created, if not, check it in time;

8. Fill in the data fragments: fill in the processed data into the reporting page in strict accordance with the corresponding relationship;

9. End Fragment: End the robot.

The present invention and its implementations have been described above, and this description is not limiting. What is shown in the drawings is only one of the implementations of the present invention, and the actual structure is not limited thereto. All in all, if a person of ordinary skill in the art is inspired by it, and without departing from the inventive concept of the present invention, without creatively designing a structure and an embodiment similar to the technical solution, it shall fall within the scope of protection of the present invention.

Claims (3)

1. A cross-platform medical data information upload system based on artificial intelligence, comprising database system, artificial intelligence robot and login reporting system, is characterized in that: described database system comprises HIS system, target file and target webpage; The artificial intelligence robot includes a data reading module, a data processing module, a login module, a data filling module, a judgment module, and a mail sending module; The login reporting system link login module; The data reading module includes: reading data from the HIS system is to give the path to the artificial intelligence robot, and the artificial intelligence robot automatically queries the database file of the path and imports it, screens out the target data, and stores it in the artificial intelligence robot; To read data in a file, call the path and name, and call Delphi’s createoleobject function to obtain an ole object, and use this object to call the interface of the target file to operate the target file; read data from the target web page by looking for characteristic attributes , looking for feature attributes including id, name, css, so as to locate, after the location is set, the target data can be obtained; The described data filling module is for positioning the mouse by the api interface SetCursorPos function of windows in the target file; sending the mouse to press the left button and release the event by the api interface mouse_event of windows, and the right button is consistent with the left button; by the api interface keybd_event of windows Send character information, use it to open the website and enter the corresponding page that needs to fill in the data; then fill in the data inside the artificial intelligence robot in a one-to-one correspondence; The sending email module is to call the email library in python to complete the corresponding function, and then let Pascal call it. 2. A cross-platform medical data information upload system based on artificial intelligence according to claim 1, characterized in that: said artificial intelligence robot supports text replacement, pattern-based replacement, case conversion, deletion of spaces, deletion of Non-printing characters, creating strings, getting substrings, searching strings, inserting or extracting special characters, string operations; Supports the use of JavaScript to perform custom string conversion processing operations; Support the extraction, conversion, and formatting operations of digital data; Supports arithmetic operations, rounding, and maximum/minimum value operations; Operations that support digital format mode applications; Support extraction, conversion, calculation and formatting operations of date/time type data; Support extracting date or time elements from date type data; Support 12-hour or 24-hour non-stop operation; Support the time zone operation that can be set to work when extracting date and time; Support convenient date calculation and processing operations; Support to obtain the current date, time, and week operation at any point in the robot processing; Support for formatting date/time data manipulation in various ways; Support automatic extraction of date/time data from the website and calculate or display its "3 hours ago" or "2 days ago" date/time data operation; Support HTML format data extraction and conversion operations; Support any of the "string" processing capabilities listed above for HTML manipulation; Supports removing all types of specific HTML tag operations in a given HTML string; Support counting the number of special tags in HTML strings; Support data conversion operations based on logical rules; Support logical structure operations that can realize an unlimited number of if-then/else; Support other conversion processing capability operations; Artificial intelligence robots can convert various types of data; Artificial intelligence robots can generate random numbers; The artificial intelligence robot can calculate and input the MD5 check code of the data, and the robot data can be exported; Send mail through the SMTP server, and dynamically generate the content and recipients of the mail; AI bots can send emails with attachments; AI bots can read and write files in the file system; Artificial intelligence robots can simulate human filling in forms in web pages, and can dynamically process page input elements; Artificial intelligence robots can dynamically traverse drop-down boxes and radio button groups; AI robots can write data to text files in various formats, including XML, JSON, and CSV formats. 3. A kind of artificial intelligence-based cross-platform medical data information upload system according to claim 1, characterized in that: the configuration of the artificial intelligence robot comprises: If the access to the website page times out, the robot can make multiple attempts, and can be set to wait for a specified period of time between attempts before proceeding; By default, the artificial intelligence robot does not load the URL of the advertising content, which can be turned on or off through configuration; AI robots can be configured not to load certain URLs that match specific URL patterns; Artificial intelligence robots can be configured to only load certain URLs that match specific URL patterns; It is possible to configure whether the artificial intelligence robot ignores the CSS style sheet; You can configure whether the artificial intelligence robot loads the Frame framework; It is possible to configure whether the artificial intelligence robot allows metadata redirection; It is possible to configure whether the artificial intelligence robot ignores JavaScript events; AI bots can optionally ignore any errors encountered while loading a page.

Images