CN117078211A

CN117078211A - Data processing method, device and server for backup file

Info

Publication number: CN117078211A
Application number: CN202311118064.7A
Authority: CN
Inventors: 王帅; 周迪强; 刘志东; 黄波
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2023-08-31
Filing date: 2023-08-31
Publication date: 2023-11-17

Abstract

The specification provides a data processing method, a device and a server for a report file, which can be used in the technical field of artificial intelligence. Under the condition that the current meeting of the preset target backup conditions is determined, the server inquires the configuration file and obtains an initial file of the current time period; determining a matched target backup rule from the configuration file; processing the initial file according to the target backup rule to obtain a target backup file meeting the backup requirement; logging in a target backup page according to the target backup rule; the report uploading element in the target report page is obtained; constructing a target backup action instruction sequence of a backup uploading flow of a target backup page according to a target backup rule and a backup uploading element; based on rpa program, through executing the target backup action instruction sequence, simulating backup operation of a user based on a target backup page, and automatically uploading the target backup file in the current time period to a target backup object through a target data interface according to a specified mode.

Description

Data processing method, device and server for backup file

Technical Field

The specification belongs to the technical field of artificial intelligence, and particularly relates to a data processing method, device and server for a report file.

Background

In the field of financial business, financial institutions often need to periodically upload certain designated business data files to a regulatory agency according to relevant regulatory requirements.

Based on the existing methods, most of staff relying on financial institutions are required to manually prepare the related business data files, and then manually upload the business data files to corresponding supervision institutions through a designated system or web page report according to a designated mode. When the method is implemented, the problems that the workload of staff is large, the overall processing efficiency is low, errors easily occur in the reporting and uploading process and the like exist often.

In view of the above problems, no effective solution has been proposed at present.

Disclosure of Invention

The specification provides a data processing method, a device and a server for reporting and preparing files, which can accurately and automatically upload reporting and preparing related data files, effectively lighten the workload of a user side, improve the overall processing efficiency and reduce errors in the reporting and preparing process.

The specification provides a data processing method for a report file, which comprises the following steps:

under the condition that the current meeting of the preset target backup conditions is determined, acquiring an initial file of the current time period by inquiring the configuration file; the initial file at least carries an object identifier of the targeted target backup object and a file type identifier of the initial file;

Determining a matched target backup rule from the configuration file according to the object identification of the target backup object and the file type identification of the initial file;

according to the target backup rule, carrying out corresponding processing treatment on the initial file to obtain a target backup file in the current time period meeting the backup requirement;

logging in a target backup page according to the target backup rule; the report uploading element in the target report page is obtained; the target data interface is at least arranged in the target report page and used for uploading the target report file to the target report object;

constructing a target backup action instruction sequence of a backup uploading flow of a target backup page according to a target backup rule and the backup uploading element;

based on rpa program, through executing the target backup action instruction sequence, simulating the backup operation of the user based on the target backup page, so as to upload the target backup file in the current time period to the target backup object through the target data interface in a specified mode.

In one embodiment, obtaining the initial file of the current time period by querying the configuration file includes:

inquiring a configuration file to obtain ftp information; wherein, the ftp information at least includes: ip address, port identification, storage path;

Accessing a designated ftp directory according to the ftp information; detecting whether an initial file meeting the requirement in the current time period exists in the ftp directory;

and downloading the initial file under the condition that the initial file meeting the current time period is determined to exist in the ftp target record.

In one embodiment, after detecting whether there is an initial file in the ftp directory for the current time period that is satisfactory, the method further comprises:

and generating an ending instruction for ending the backup task of the current time period under the condition that the initial file of the current time period meeting the requirements does not exist in the ftp directory.

In one embodiment, according to a target backup rule, performing corresponding processing on the initial file, including:

and carrying out one or more of the following processing treatments on the initial file according to the target backup rule:

detecting whether the number of lines in the initial file is larger than a preset line number threshold value according to a target backup rule; splitting an initial file into a plurality of subfiles under the condition that the number of lines in the initial file is determined to be larger than a preset line number threshold; the number of lines in the subfiles is smaller than or equal to a preset line number threshold;

detecting whether a text field in an initial file accords with a report rule or not according to a target report rule; correcting the text field in the initial file under the condition that the text field in the initial file is determined to be not in accordance with the backup standard;

Detecting whether redundant data items exist in the initial file according to the target backup rule; in the event that it is determined that a redundant data item exists in the initial file, the redundant data item in the initial file is deleted.

In one embodiment, logging in a target backup page according to a target backup rule includes:

determining a target backup page corresponding to the target backup object according to the target backup rule; obtaining a target access link of a target backup page;

acquiring preset login data aiming at a target backup page; the preset login data at least comprise login account aiming at the target backup page and ciphertext data of a login password corresponding to the login account;

accessing the target backup page according to the target access link of the target backup page; and logging in the target backup page by using preset login data.

In one embodiment, logging in the target backup page with preset login data includes:

invoking a preset auxiliary login plug-in to decrypt ciphertext data of a login password in a trusted execution environment of a server to obtain a corresponding login password; wherein, the preset auxiliary login plug-in is internally provided with a corresponding decryption key;

Based on rpa program, simulating the user to input corresponding login account and login password in the target backup page so as to log in the target backup page.

In one embodiment, obtaining a backup upload element in a target backup page includes:

acquiring source code data of a target backup page;

and according to the target backup rule, searching the backup uploading field of the source code data of the target backup page to obtain backup uploading elements in the target backup page.

In one embodiment, according to a target backup rule and the backup uploading element, a target backup action instruction sequence of a backup uploading process of a target backup page is constructed, including:

screening matched preset action instructions from a preset action instruction set according to the report uploading elements to serve as initial action instructions; wherein, the preset action instruction set stores a plurality of preset action instructions aiming at pages;

filling a corresponding initial action instruction by utilizing a report backup uploading element according to a target report backup rule to obtain a target action instruction;

and combining the target action instructions according to the target backup rule to obtain a target backup action instruction sequence of a backup uploading flow of the target backup page.

In one embodiment, in a case that a preset action instruction matching with the backup upload element is not screened from a preset action instruction set, the method further includes:

generating a generation request for an action instruction; the generation request of the action instruction at least carries a corresponding report uploading element;

sending the generation request of the action instruction to an operation and maintenance terminal;

receiving an action instruction fed back by the operation and maintenance terminal; and storing the action instruction into a preset action instruction set.

In one embodiment, after logging in the target backup page according to the target backup rule, the method further comprises:

acquiring and generating a check page switching action instruction according to the check page elements in the target report page;

switching to a corresponding target check page by executing a check page switching action instruction; the target check page at least comprises the report state of the uploaded target report file;

acquiring a report check element in a target check page;

constructing a target check action instruction sequence of the report check of the target check page according to the target report rule and the report check element;

Based on rpa program, by executing the target checking action instruction sequence, the checking operation of the user based on the target checking page is simulated to acquire the report state information of the target report file which is uploaded currently.

In one embodiment, after obtaining the backup status information of the target backup file that has been currently uploaded, the method further comprises:

detecting whether the backup state of the uploaded target backup file is abnormal or not according to the backup state information of the currently uploaded target backup file;

under the condition that the report state of the uploaded target report file is abnormal, acquiring the file identification of the abnormal file and the current report state information of the abnormal file;

generating and feeding back an abnormal standby prompt to the user terminal; the abnormal backup prompt at least carries the file identification of the abnormal file and the current backup state information of the abnormal file.

In one embodiment, the method further comprises:

receiving file backup update information issued by a target backup object;

processing the file report update information by using a preset semantic recognition model to obtain a corresponding semantic recognition result;

and updating the configuration file according to the semantic recognition result.

The specification also provides a data processing device for the newspaper file, which comprises:

the acquisition module is used for acquiring an initial file of the current time period by inquiring the configuration file under the condition that the current preset target backup condition is determined to be met; the initial file at least carries an object identifier of the targeted target backup object and a file type identifier of the initial file;

the determining module is used for determining a matched target backup rule from the configuration file according to the object identification of the target backup object and the file type identification of the initial file;

the processing module is used for carrying out corresponding processing treatment on the initial file according to the target backup rule to obtain a target backup file in the current time period which meets the backup requirement;

the login module is used for logging in the target backup page according to the target backup rule; the report uploading element in the target report page is obtained; the target data interface is at least arranged in the target report page and used for uploading the target report file to the target report object;

the construction module is used for constructing a target backup action instruction sequence of a backup uploading flow of a target backup page according to a target backup rule and the backup uploading element;

And the operation module is used for simulating the backup operation of a user based on the target backup page by executing the target backup action instruction sequence based on the rpa program so as to upload the target backup file in the current time period to the target backup object through the target data interface in a specified mode.

The present disclosure also provides a server comprising a processor and a memory for storing processor-executable instructions, which when executed by the processor implement the steps associated with a data processing method for the backing file.

The present specification also provides a computer readable storage medium having stored thereon computer instructions which when executed by a processor perform the steps of: under the condition that the current meeting of the preset target backup conditions is determined, acquiring an initial file of the current time period by inquiring the configuration file; the initial file at least carries an object identifier of the targeted target backup object and a file type identifier of the initial file; determining a matched target backup rule from the configuration file according to the object identification of the target backup object and the file type identification of the initial file; according to the target backup rule, carrying out corresponding processing treatment on the initial file to obtain a target backup file in the current time period meeting the backup requirement; logging in a target backup page according to the target backup rule; the report uploading element in the target report page is obtained; the target data interface is at least arranged in the target report page and used for uploading the target report file to the target report object; constructing a target backup action instruction sequence of a backup uploading flow of a target backup page according to a target backup rule and the backup uploading element; based on rpa program, through executing the target backup action instruction sequence, simulating the backup operation of the user based on the target backup page, so as to upload the target backup file in the current time period to the target backup object through the target data interface in a specified mode.

Based on the data processing method, the device and the server of the backup file provided by the specification, under the condition that the preset target backup condition is met currently, the server can acquire the initial file of the current time period by inquiring the configuration file; determining a matched target backup rule from the configuration file; processing the initial file according to the target backup rule to obtain a target backup file in the current time period meeting the backup requirement; logging in a target backup page according to the target backup rule; the report uploading element in the target report page is obtained; then, according to the target backup rule and the backup uploading element, constructing a target backup action instruction sequence of the backup uploading flow of the target backup page; based on rpa program, through executing the target backup action instruction sequence, the control robot simulates backup operation of a user based on a target backup page, and automatically uploads the target backup file in the current time period to the target backup object through a target data interface of the target backup page in a specified mode. Therefore, the report and backup uploading of the related data files of the target report and backup object can be accurately and automatically realized by introducing and utilizing the rpa technology, the workload of a user side is effectively reduced, the overall processing efficiency is improved, and errors in the report and backup process are reduced.

Drawings

In order to more clearly illustrate the embodiments of the present disclosure, the drawings that are required for the embodiments will be briefly described below, and the drawings described below are only some embodiments described in the present disclosure, and other drawings may be obtained according to these drawings without inventive effort for a person of ordinary skill in the art.

FIG. 1 is a flow chart of a method for processing data of a backup file according to an embodiment of the present disclosure;

FIG. 2 is a schematic diagram of one embodiment of a data processing method for a backing file according to the embodiments of the present disclosure, in one example scenario;

FIG. 3 is a schematic diagram of one embodiment of a data processing method for a backing file according to the embodiments of the present disclosure, in one example scenario;

FIG. 4 is a schematic diagram of one embodiment of a data processing method for a backing file according to the embodiments of the present disclosure, in one example scenario;

FIG. 5 is a schematic diagram of one embodiment of a data processing method for a backing file according to the embodiments of the present disclosure, in one example scenario;

FIG. 6 is a schematic diagram of one embodiment of a data processing method for a backing file according to embodiments of the present disclosure, in one example scenario;

FIG. 7 is a schematic diagram of one embodiment of a data processing method for a backing file according to the embodiments of the present disclosure, in one example scenario;

FIG. 8 is a schematic diagram of the structural composition of a server provided in one embodiment of the present disclosure;

FIG. 9 is a schematic structural diagram of a data processing device for a report file according to an embodiment of the present disclosure;

fig. 10 is a schematic diagram of an embodiment of a data processing method of a backup file according to the embodiment of the present disclosure, in an example of a scenario.

Detailed Description

In order to make the technical solutions in the present specification better understood by those skilled in the art, the technical solutions in the embodiments of the present specification will be clearly and completely described below with reference to the drawings in the embodiments of the present specification, and it is obvious that the described embodiments are only some embodiments of the present specification, not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are intended to be within the scope of the present disclosure.

The information data related to the user in the present specification is obtained and used under the condition that the user knows and agrees. And the acquisition, the use, the storage and the like of the information data meet the relevant legal requirements.

Referring to fig. 1, an embodiment of the present disclosure provides a method for processing data of a backup file. The method is particularly applied to the server side. In particular implementations, the method may include the following:

s101: under the condition that the current meeting of the preset target backup conditions is determined, acquiring an initial file of the current time period by inquiring the configuration file; the initial file at least carries an object identifier of the targeted target backup object and a file type identifier of the initial file;

s102: determining a matched target backup rule from the configuration file according to the object identification of the target backup object and the file type identification of the initial file;

s103: according to the target backup rule, carrying out corresponding processing treatment on the initial file to obtain a target backup file in the current time period meeting the backup requirement;

s104: logging in a target backup page according to the target backup rule; the report uploading element in the target report page is obtained; the target data interface is at least arranged in the target report page and used for uploading the target report file to the target report object;

s105: constructing a target backup action instruction sequence of a backup uploading flow of a target backup page according to a target backup rule and the backup uploading element;

S106: based on rpa program, through executing the target backup action instruction sequence, simulating the backup operation of the user based on the target backup page, so as to upload the target backup file in the current time period to the target backup object through the target data interface in a specified mode.

Based on the above embodiment, the server may automatically detect whether a preset target backup condition is satisfied, and trigger to automatically obtain an initial file in a current time period when it is determined that the preset target backup condition is satisfied; determining a target backup object corresponding to the initial file and a target backup rule matched with the file type of the initial file; furthermore, according to the target backup rule, a target backup page corresponding to the target backup object can be automatically logged in; the report backup uploading elements related to the report backup uploading flow in the target report backup page are acquired; then, constructing a target backup action instruction sequence of a backup uploading flow of the target backup page according to the target backup rule and the backup uploading element; and then the virtual robot is controlled to simulate the backup operation based on the target backup page by executing the target backup action instruction sequence based on the rpa program, so that the target backup file in the current time period is automatically uploaded to the target backup object through the target data interface according to a specified mode. Therefore, the report and backup uploading of the related data files can be accurately and automatically realized, the workload of a user side is effectively reduced, the overall processing efficiency is improved, and errors in the report and backup process are reduced.

In some embodiments, referring to fig. 2, the method for processing data of the backup file may be specifically applied to a server side. The server may be specifically deployed on a cloud service platform of a financial institution (for example, XX bank).

Specifically, the server (or cloud server) may be further connected to a user terminal held by a server (which may be abbreviated as a central server) of a data center of the financial institution, a server (which may be abbreviated as a target server) of a target report object, and a worker (which may be abbreviated as a user later) responsible for reporting the relevant data file in the financial institution.

The target object may be specifically understood as a target object that needs to be reported by a financial institution for a related data file. Specifically, the target report object may be a supervision organization, for example, a silver-guard authority, an audit authority, an foreign exchange administration, or other relevant institutions having supervision responsibilities on financial institutions. In addition, the target report object may be other related institutions having association relationship with the financial institutions besides the supervision institutions, for example, a partner having cooperation relationship with the financial institutions and requiring periodic auditing and monitoring of specified businesses of the financial institutions according to cooperation protocols.

The server may specifically include a background server capable of implementing functions such as data transmission and data processing. Specifically, the server may be, for example, an electronic device having data operation, storage function and network interaction function. Alternatively, the server may be a software program running in the electronic device that provides support for data processing, storage, and network interactions. In the present embodiment, the number of servers is not particularly limited. The server may be one server, several servers, or a server cluster formed by several servers.

The user terminal specifically may include a front end capable of implementing functions such as data acquisition and data transmission. Specifically, the user terminal may be, for example, an electronic device such as a desktop computer, a tablet computer, a notebook computer, a smart phone, and the like. Alternatively, the user terminal may be a software application capable of running in the electronic device.

In specific implementation, according to a preset protocol rule, a central server of a financial institution can collect and summarize service data to be reported (for example, opening data and updating data of a bank personal settlement account) uploaded by each branch of the financial institution (for example, each branch of a bank) according to requirements every preset time period (for example, every day); the business data are arranged and utilized according to basic report requirements of the target report objects, and an initial file corresponding to the preset time period is generated; and storing the initial file under a corresponding directory according to a corresponding storage rule.

And the user can initiate a backup triggering instruction for the current time period to the cloud server through the user terminal every preset time period so as to trigger the backup task meeting the preset target backup condition for the current time period. Of course, the cloud server can also be automatically set to start timing after completing the backup every time, and after detecting that the accumulated duration reaches the preset time period, the cloud server determines that the preset target backup condition is met, and automatically triggers the backup task for the current time period.

Specifically, under the condition that the preset target report condition is met, firstly, the cloud server can acquire and access the corresponding catalogue according to the corresponding ftp information by inquiring the preset configuration file, and downloads the initial file in the current time period. The cloud server may then determine a matching target backup rule from among a plurality of preset backup rules contained in the configuration file. And the cloud server can correspondingly process the initial file according to the target backup rule to obtain the target backup file to be backed up in the current time period meeting the backup requirement of the target backup object.

Further, the cloud server may determine a target backup page corresponding to the target backup object according to the target backup rule, and obtain a target access link (for example, url address) of the target backup page, and preset login data for the target backup; and accessing the target report page based on the target access link, and logging in the target report page by a preset auxiliary login plug-in a safe mode based on preset login data so as to avoid the leakage of related information in the preset login data.

After logging in the target backup page, the cloud server can firstly acquire the source code data of the target backup page; searching a backup uploading field of source code data of a target backup page according to a target backup rule to acquire backup uploading elements in the target backup page; then automatically constructing and obtaining a target backup action instruction sequence of a backup uploading flow of a target backup page according to a target backup rule and the backup uploading element; and the cloud server can control the corresponding automatic virtual robot to simulate the backup operation of a human user based on the target backup page by executing the target backup action instruction sequence based on the rpa program, and automatically upload the target backup file in the current time period to the target backup object through the target data interface according to a specified mode. Meanwhile, the cloud server monitors and collects uploading results of the target backup page aiming at the currently uploaded target backup file through the robot; generating a corresponding uploading result prompt about whether the uploading of the target backup file is successful or not according to the uploading result; and timely feeding back the uploading result prompt to the user terminal.

Among them, rpa (Robotic process automation, robot flow automation) may specifically refer to a business process automation technology based on software robots and Artificial Intelligence (AI). The rpa program can be understood as an automation program based on rpa technology, which is capable of automatically realizing related data processing instead of a human user by controlling an automation robot to simulate a manual operation of the human user on a computer or the like.

Therefore, the report and backup uploading of the related data files can be accurately and automatically realized by introducing and effectively utilizing rpa programs, the workload of a user side is reduced, the overall processing efficiency is improved, and errors in the report and backup process are reduced.

In some embodiments, for more complex backup scenarios, the target backup object may include a plurality of different target backup objects. Accordingly, the target backup file may include a plurality of target backup files of different file types for different target backup objects. The file type of the target backup file is determined according to the data content of the related service data to be backed up contained in the target backup file.

The configuration file can be specifically obtained by collecting and integrating the report specification and the report requirement of different report objects aiming at different types of files in advance and combining the report rules and the storage rules in the financial institutions. Specifically, the configuration file at least includes a storage rule of a report file and a preset report rule corresponding to different types of report files of different report objects. In addition, the configuration file may further include storage information (for example, related ftp information) when the corresponding initial file is stored based on the storage rule, and the like.

The preset provisioning rule may specifically include provisioning requirements based on data content, such as data content, data format, and total data amount of the provisioning document, and provisioning requirements based on operation modes, such as provisioning flow, provisioning time, and provisioning medium of the provisioning document. Specifically, each preset report rule at least corresponds to a report file type of a report object.

Before specific implementation, the preset report rule can be constructed and obtained according to the following mode: collecting a large number of history backup records and history backup files of different types of backup files aiming at different backup objects, and the backup standard files of the different backup objects which are externally disclosed; dividing a large number of history backup records and history backup files into a plurality of data sets; each data group corresponds to a backup file type of a backup object, and each data group comprises a plurality of history backup records and history backup files of the same type of backup files aiming at the same backup object; clustering historical backup records and historical backup files contained in the multiple data sets respectively to obtain multiple initial backup rules according to common characteristics (including common characteristics on data content and common characteristics on operation modes) of backup of the same type backup files aiming at the same backup object; wherein, the initial backup rule is a backup file type of a backup object respectively; dividing the plurality of initial reporting rules into a plurality of rule groups; wherein, each rule group corresponds to a report object; respectively detecting the accuracy of a plurality of initial backup rules in a rule group corresponding to the backup object by taking the externally disclosed backup standard file of different backup objects as a reference standard, and determining the initial backup rules passing the accuracy detection as preset backup rules; and for the initial backup rule which fails to pass the accuracy detection, carrying out targeted adjustment according to the corresponding backup standard file, and determining the adjusted backup rule as a preset backup rule.

In some embodiments, referring to fig. 3, the obtaining the initial file of the current time period by querying the configuration file may include the following when the implementation is performed:

s1: inquiring a configuration file to obtain ftp information; wherein, the ftp information at least includes: ip address, port identification, storage path;

s2: accessing a designated ftp directory according to the ftp information; detecting whether an initial file meeting the requirement in the current time period exists in the ftp directory;

s3: and downloading the initial file under the condition that the initial file meeting the current time period is determined to exist in the ftp target record.

Based on the above embodiment, the server may automatically and efficiently obtain the initial file of the current time period according to the configuration file.

Wherein, the initial file at least contains the relevant service data to be reported. For example, the opening data of the bank personal settlement account of the user a, the cancellation data of the bank personal settlement account of the user B, and the like. However, the relevant service data contained in the initial file may not meet the backup requirement of the target backup object. In addition, the initial file may further include other service data that need not be reported to the target reporting object.

The initial file of the current time period meeting the requirements may specifically refer to an initial file corresponding to the current time period based on a corresponding storage rule in the configuration file.

Among these, the ftp (File Transfer Protocol ) is a standard set of protocols for file transfer over a network. The ftp information may be specifically understood as storage information based on ftp, and may at least include: ip address, port identification, storage path, etc. are associated with the storage of the initial file.

In particular implementations, a server (e.g., a central server) responsible for preparing the initial file may store the corresponding initial file based on the corresponding ftp information according to the configuration file, based on the corresponding storage rules, using the ftp protocol described above.

Specifically, the central server may store the initial file in a corresponding specified ftp directory in the blockchain according to the configuration file and based on the corresponding storage rule by using the ftp protocol.

Specifically, for example, for an initial file in a current time period to be stored, the central server may first enter into a corresponding specified ftp directory according to ftp information corresponding to the initial file in the configuration file; creating a subdirectory corresponding to the current time period according to the time information of the current time period corresponding to the initial file in the directory; and storing the initial file into the subdirectory.

Correspondingly, in the implementation, the server can determine an access path aiming at the specified ftp directory according to the ftp information; accessing to a designated ftp directory according to the access path; searching the subdirectory corresponding to the current time period in the catalogue; and detects whether the subdirectory is currently empty. Under the condition that the sub-directory is detected to be empty currently, the fact that the backup file needing backup is not available in the current time period can be determined, and then the backup task can be ended. In contrast, in the case where it is detected that the sub-directory has an initial file, the initial file is downloaded as an initial file for the current time period.

When in specific downloading, the server can use the self identity secret key as a downloading certificate to download the initial file; and saving the initial file to a local cache. The initial file may be a table, a document, ppt, or the like containing relevant service data to be reported.

In some embodiments, after detecting whether an initial file of the current time period meeting the requirements exists in the ftp directory, the method may further include the following when implemented:

Based on the above embodiment, the server may further automatically determine whether a backup file for reporting the target backup object exists in the current time period by detecting whether an initial file of the current time period meeting the requirement exists in the ftp directory. Under the condition that the initial file does not exist in the current time period, the server can generate a corresponding ending instruction to automatically end the backup task; meanwhile, corresponding report task ending prompt information can be generated; and sending the report task ending prompt information to the user terminal so as to prompt the user that the report task is automatically ended because no file needing report exists.

In some embodiments, according to the target backup rule, the processing of the initial file may include: and carrying out one or more of the following processing treatments on the initial file according to the target backup rule:

detecting whether redundant data items exist in the initial file according to the target backup rule; in the case where it is determined that the redundant data item exists in the initial file, the redundant data item or the like in the initial file is deleted.

The redundant data item may be specifically understood as data that is contained in the initial file and does not need to be reported to the target backup object based on the backup specification and the requirement of the target backup object.

Based on the above embodiment, the server may automatically perform corresponding processing on the initial file according to the target backup rule to obtain the target backup file meeting the backup requirement of the target backup object.

In some embodiments, when the initial file is split into a plurality of subfiles during implementation, the server further names the split subfiles separately according to a target backup rule; and adds the association identification with the previous sub-file in the name of the sub-file. Therefore, the connection relationship among the split sub-files is clear and accurate, and the problems of overlapping, confusion and the like among the sub-files are avoided.

In a specific implementation, the detecting whether the text field in the initial file meets the report specification may include: detecting whether the fonts and the word sizes of text fields in an initial file accord with the backup report standard according to the target backup report rule; detecting whether the format of a text field in an initial file accords with the report specification; detecting whether the spacing between text fields in the original file meets the stock specifications, and the like.

In some embodiments, the logging on the target backup page according to the target backup rule may include the following when implemented:

s1: determining a target backup page corresponding to the target backup object according to the target backup rule; obtaining a target access link of a target backup page;

s2: acquiring preset login data aiming at a target backup page; the preset login data at least comprise login account aiming at the target backup page and ciphertext data of a login password corresponding to the login account;

s3: accessing the target backup page according to the target access link of the target backup page; and logging in the target backup page by using preset login data.

The login account and the login password corresponding to the login account are specifically provided for a financial institution to which the server belongs in advance for use by a target report object according to corresponding protocol rules.

Based on the above embodiment, the server may acquire and utilize preset login data according to the target backup rule, simulate the login operation of the human user, and automatically log in the target backup page.

In some embodiments, referring to fig. 4, the above-mentioned logging in the target backup page by using the preset logging data may include the following when implemented:

s1: invoking a preset auxiliary login plug-in to decrypt ciphertext data of a login password in a trusted execution environment of a server to obtain a corresponding login password; wherein, the preset auxiliary login plug-in is internally provided with a corresponding decryption key;

s2: based on rpa program, simulating the user to input corresponding login account and login password in the target backup page so as to log in the target backup page.

Wherein, the auxiliary login plug-in is at least internally provided with a decryption key corresponding to ciphertext data of a login password; furthermore, the preset auxiliary login plug-in is also embedded with a decryption program supporting the automatic decryption operation of the related ciphertext data by using the built-in decryption key. In order to avoid revealing the login password, the decryption key is not disclosed outside.

Based on the embodiment, the corresponding login password can be obtained by automatically decrypting by calling the preset auxiliary login plug-in, so that the user can be simulated to input the corresponding login account and the corresponding login password in the target backup page based on the rpa program, the target backup page can be automatically and safely logged in, the login password is effectively prevented from being revealed, and the login data security is protected.

The trusted execution environment may specifically include an environment area with a higher security level (for example, a security level meeting a preset security requirement) in the server. Specifically, the trusted execution environment may be a hardware area partitioned from the server by a hardware configuration or the like, and isolated from a relatively open environment area (e.g., rich Execution Environment, REE, etc.) that is commonly used.

In this scenario example, the trusted execution environment (Trust Execution Environment, TEE) may run a complete operating system, which may be understood as Secure World in the server. Unlike Normal World (e.g., REE in a server), the memory space of the trusted execution environment is typically relatively small, e.g., perhaps only 100MB. In the server, only part of data with higher security requirements will be processed in the TEE; most of the data is processed on Normal World, such as REE. Of course, the above listed trusted execution environments are only one illustrative type. In particular, according to a specific application scenario and a specific situation of the server, other areas with higher security levels in the third server may be selected to replace the trusted execution environment.

In the implementation, the server can also control the virtual robot to use the login account and the login password in the trusted execution environment through corresponding instruction sentences based on the rpa program so as to simulate the user to input the corresponding login account and the login password in the target backup page to log in the target backup page. Thereby the risk of revealing the login password can be further reduced.

In some embodiments, when the login of the target backup page is attempted in the above manner and a login abnormality occurs (for example, the login fails, or after the login account and the login password are input, the login does not normally jump to the target backup page, etc.), the login can be stopped first, and then the above manner is repeated for re-login; under the condition that repeated preset times are detected to be still abnormal in login, the login is abandoned, and warning information of abnormal login is generated; and the warning information is timely sent to the user terminal so that the user can check manually.

In some embodiments, before logging in the target backup page using the preset login data, the method further comprises: adding the target access link of the target backup page into a trusted site list of the server; meanwhile, the subsequent login operation is performed in an IE compatible mode.

In some embodiments, after uploading the target backup file of the current time period to the target backup object through the target data interface in a specified manner, the server may further control the virtual robot to monitor feedback data of the target backup page after the uploading of the target backup file (for example, a prompt box that the target backup page pops up for the uploaded target backup file) by executing a corresponding monitoring action instruction based on the rpa program; and collecting and acquiring the feedback data. The server can determine whether the uploading of the target backup file is successful according to the feedback data; generating a corresponding uploading result prompt about whether the uploading of the target backup file is successful; and timely sending the uploading result prompt to the user terminal.

In some embodiments, the obtaining a backup upload element in the target backup page may include the following when implemented:

s1: acquiring source code data of a target backup page;

s2: and according to the target backup rule, searching the backup uploading field of the source code data of the target backup page to obtain backup uploading elements in the target backup page.

Based on the above embodiment, the server may automatically and accurately obtain the required backup upload element related to the backup upload flow from the currently logged target backup page.

The backup uploading element can be specifically understood as a page element related to a backup uploading process, which is triggered or used when a user transmits a backup file through manual operation in a target backup page. Specifically, for example, the upload date, the upload file type, the upload file selection input box, the confirmation upload, and the like in the target backup page. The backup upload field may specifically refer to a key value field corresponding to the backup upload element.

In some embodiments, referring to fig. 5, the above-mentioned construction of a target backup action instruction sequence related to a backup upload flow of a target backup page according to a target backup rule and the backup upload element may include the following when implemented:

s1: screening matched preset action instructions from a preset action instruction set according to the report uploading elements to serve as initial action instructions; wherein, the preset action instruction set stores a plurality of preset action instructions aiming at pages;

s2: filling a corresponding initial action instruction by utilizing a report backup uploading element according to a target report backup rule to obtain a target action instruction;

s3: and combining the target action instructions according to the target backup rule to obtain a target backup action instruction sequence of a backup uploading flow of the target backup page.

Based on the above embodiment, the server may accurately and automatically generate, according to the target backup rule, a target backup action command sequence for simulating user operation to implement a backup uploading process by using a corresponding preset action command and a backup uploading element.

The preset action instruction set may be a set of instruction units which are obtained by performing action decomposition on a large number of historical action instruction records aiming at web pages and then performing classification and arrangement and can cover most of operation actions based on the web pages. The preset action instruction set comprises a plurality of preset action instructions, and each preset action instruction corresponds to a basic action based on a webpage.

In specific implementation, according to the report and backup uploading element, basic actions corresponding to the report and backup uploading element can be determined by combining source code data of a target report and backup page; and finding out a preset action instruction corresponding to the basic action from a preset action instruction set.

In specific implementation, according to the target backup rule, the relevant characteristics of the target backup file to be uploaded are combined, and the uploading backup uploading element is utilized to fill relevant fields of the corresponding initial action instruction so as to obtain the corresponding target action instruction. Determining a specific report backup uploading flow based on the current target report backup page according to the target report backup rule and combining the source code data of the target report backup page; determining specific action steps according to the report and backup uploading flow; and combining the target action instructions in sequence based on the specific action steps to obtain a target backup action instruction sequence of a backup uploading flow of the target backup page.

In some embodiments, in a case that a preset action instruction matching with the backup upload element is not screened from a preset action instruction set, the method may further include the following when implemented:

s1: generating a generation request for an action instruction; the generation request of the action instruction at least carries a corresponding report uploading element;

s2: sending the generation request of the action instruction to an operation and maintenance terminal;

s3: receiving an action instruction fed back by the operation and maintenance terminal; and storing the action instruction into a preset action instruction set.

In the implementation process, the operation and maintenance terminal can display the generation request of the action instruction to operation and maintenance personnel so that the operation and maintenance personnel can manually write a corresponding new action instruction by combining with a specific report uploading element. And the operation and maintenance terminal receives and feeds back the action instruction to the server. On one hand, the server can directly use the action instruction to complete the generation of a subsequent target backup action instruction sequence; on the other hand, the action instruction can be further determined to be a newly added preset action instruction, and the preset action instruction and the corresponding report uploading element are stored in a preset action instruction set together after being associated, so that the preset action instruction set is updated, and the richness of the preset action instructions contained in the preset action instruction set is improved.

Based on the above embodiment, the server can continuously update the preset action instruction set in time, so that the updated preset action instruction set is more comprehensive, and further more diversified operations based on the webpage can be supported.

In some embodiments, after logging in the target backup page according to the target backup rule, referring to fig. 6, the method may further include the following when implemented:

s1: acquiring and generating a check page switching action instruction according to the check page elements in the target report page;

s2: switching to a corresponding target check page by executing a check page switching action instruction; the target check page at least comprises the report state of the uploaded target report file;

s3: acquiring a report check element in a target check page;

s4: constructing a target check action instruction sequence of the report check of the target check page according to the target report rule and the report check element;

s5: based on rpa program, by executing the target checking action instruction sequence, the checking operation of the user based on the target checking page is simulated to acquire the report state information of the target report file which is uploaded currently.

Based on the above embodiment, the server may further effectively use rpa technology, and by executing the target checking action instruction sequence, control the virtual robot to simulate the checking operation of the user based on the target checking page, and automatically implement the query and check on the report status of the currently uploaded target report file (for example, the target report file in the last time period, etc.), thereby further reducing the workload of the user side.

The above check page element may be specifically understood as a relevant page element that a user in the target backup page may trigger or use when switching from the target backup page to the corresponding target check page through manual operation. For example, a trigger icon for switching collation in the target page, a link to the target page, and the like.

In specific implementation, the server may obtain the check page element in the target backup page in a similar manner; generating a corresponding page switching action instruction based on the check page element; further, based on the rpa program, by executing the page switching action instruction, the virtual robot is controlled to simulate the page switching operation of the user so as to jump from the current target backup page to the corresponding target check page.

The backup checking element can be specifically understood as a page element related to a backup checking flow, which is triggered or used when a user queries the backup state of the backup file through manual operation in the target checking page. Specifically, for example, the target checks the file name in the page, the processing result state, the date, the page menu item, and the like.

In the specific implementation, the server can also acquire the backup check element in the target check page by referring to the acquisition mode of the backup uploading element in the target backup page; further, referring to the construction mode of the target backup action instruction sequence, the server may construct a target verification action instruction sequence of the backup verification about the target verification page according to the target backup rule and the backup verification element.

After the server obtains the backup state information of the currently uploaded target backup file by executing the target checking action instruction sequence, the backup state information of the currently uploaded target backup file can be timely fed back to the user terminal.

In some embodiments, after the cloud server logs in the target backup page, the cloud server may switch and jump to the target backup page first, based on rpa program, by executing a target backup action instruction sequence, simulate a user's backup operation based on the target backup page, so as to obtain backup status information of the currently uploaded target backup file; and determining the backup file which needs to be re-uploaded in case of failure in backup according to the backup state information of the currently uploaded target backup file, and recording the backup file as a re-reported file. And switching and jumping back to the target backup page, and simulating backup operation of a user based on the target backup page by executing a target backup action instruction sequence based on the rpa program so as to upload the target backup file and the re-backup file of the current time period to the target backup object together through the target data interface according to a designated mode.

In some embodiments, after obtaining the backup status information of the currently uploaded target backup file, referring to fig. 7, when the method is implemented, the method may further include the following:

s1: detecting whether the backup state of the uploaded target backup file is abnormal or not according to the backup state information of the currently uploaded target backup file;

s2: under the condition that the report state of the uploaded target report file is abnormal, acquiring the file identification of the abnormal file and the current report state information of the abnormal file;

s3: generating and feeding back an abnormal standby prompt to the user terminal; the abnormal backup prompt at least carries the file identification of the abnormal file and the current backup state information of the abnormal file.

Based on the embodiment, the server can automatically detect and find the abnormal file with abnormal report state, and timely feed back related abnormal report prompt to the user terminal, so that the user can timely check and process the abnormal file and eliminate the abnormal file.

In some embodiments, the method may further include the following when implemented:

s1: receiving file backup update information issued by a target backup object;

S2: processing the file report update information by using a preset semantic recognition model to obtain a corresponding semantic recognition result;

s3: and updating the configuration file according to the semantic recognition result.

Based on the above embodiment, the server may also obtain the file provisioning update information initiated by the target provisioning object at regular or irregular time, and timely refine the preset provisioning rule corresponding to the target provisioning object in the configuration file according to the latest provisioning specification and requirement of the target provisioning object, so that the configuration file and the specific preset provisioning rule used have higher accuracy.

In some embodiments, in the implementation, the server may further detect a deletion condition of an initial file stored in the local cache at intervals of a preset time period, where the time distance between the initial file and the current time is greater than a preset time threshold; under the condition that the deletion condition is met, deleting the initial file from the local cache, so that the related initial file can be prevented from being leaked; on the other hand, the occupation of storage resources of the local cache can be reduced. The meeting of the deletion condition may specifically mean that, based on the backup status information of the target backup file that has been uploaded currently, it is determined that the backup of the target backup file corresponding to the initial file is successful, and no abnormality exists.

From the above, based on the data processing method of the backup file provided in the embodiment of the present disclosure, when determining that the preset target backup condition is currently satisfied, the server queries the configuration file to obtain the initial file of the current time period; determining a matched target backup rule from the configuration file; processing the initial file according to the target backup rule to obtain a target backup file meeting the backup requirement; logging in a target backup page according to the target backup rule; the report uploading element in the target report page is obtained; then, according to the target backup rule and the backup uploading element, constructing a target backup action instruction sequence of the backup uploading flow of the target backup page; based on rpa program, through executing the target backup action instruction sequence, simulating backup operation of a user based on a target backup page, and automatically uploading the target backup file in the current time period to a target backup object through a target data interface according to a specified mode. Therefore, the rpa technology can be introduced and effectively utilized to accurately and automatically upload the report and backup of the related data file, the workload of a user side is reduced, the overall processing efficiency is improved, and errors in the report and backup process are reduced.

The embodiment of the present disclosure further provides a server, and is shown in fig. 8. The server includes a network communication port 801, a processor 802, and a memory 803, which are connected by an internal cable, so that each structure may perform specific data interaction.

The network communication port 801 may be specifically configured to receive a backup trigger instruction of a current time period initiated by a user terminal.

The processor 802 may be specifically configured to determine that a preset target backup condition is currently met when a backup trigger instruction in a current time period is detected, and obtain an initial file in the current time period by querying a configuration file; the initial file at least carries an object identifier of the targeted target backup object and a file type identifier of the initial file; determining a matched target backup rule from the configuration file according to the object identification of the target backup object and the file type identification of the initial file; according to the target backup rule, carrying out corresponding processing treatment on the initial file to obtain a target backup file in the current time period meeting the backup requirement; logging in a target backup page according to the target backup rule; the report uploading element in the target report page is obtained; the target data interface is at least arranged in the target report page and used for uploading the target report file to the target report object; constructing a target backup action instruction sequence of a backup uploading flow of a target backup page according to a target backup rule and the backup uploading element; based on rpa program, through executing the target backup action instruction sequence, simulating the backup operation of the user based on the target backup page, so as to upload the target backup file in the current time period to the target backup object through the target data interface in a specified mode.

The memory 803 may be used for storing a corresponding program of instructions.

In this embodiment, the network communication port 801 may be a virtual port that binds with different communication protocols, so that different data may be sent or received. For example, the network communication port may be a port responsible for performing web data communication, a port responsible for performing FTP data communication, or a port responsible for performing mail data communication. The network communication port may also be an entity's communication interface or a communication chip. For example, it may be a wireless mobile network communication chip, such as GSM, CDMA, etc.; it may also be a Wifi chip; it may also be a bluetooth chip.

In this embodiment, the processor 802 may be implemented in any suitable manner. For example, the processor may take the form of, for example, a microprocessor or processor, and a computer-readable medium storing computer-readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), a programmable logic controller, and an embedded microcontroller, among others. The description is not intended to be limiting.

In this embodiment, the memory 803 may include a plurality of layers, and in a digital system, the memory may be any memory as long as it can hold binary data; in an integrated circuit, a circuit with a memory function without a physical form is also called a memory, such as a RAM, a FIFO, etc.; in the system, the storage device in physical form is also called a memory, such as a memory bank, a TF card, and the like.

The embodiments of the present specification also provide a computer readable storage medium of a data processing method based on the foregoing report file, where the computer readable storage medium stores computer program instructions that when executed implement: under the condition that the current meeting of the preset target backup conditions is determined, acquiring an initial file of the current time period by inquiring the configuration file; the initial file at least carries an object identifier of the targeted target backup object and a file type identifier of the initial file; determining a matched target backup rule from the configuration file according to the object identification of the target backup object and the file type identification of the initial file; according to the target backup rule, carrying out corresponding processing treatment on the initial file to obtain a target backup file in the current time period meeting the backup requirement; logging in a target backup page according to the target backup rule; the report uploading element in the target report page is obtained; the target data interface is at least arranged in the target report page and used for uploading the target report file to the target report object; constructing a target backup action instruction sequence of a backup uploading flow of a target backup page according to a target backup rule and the backup uploading element; based on rpa program, through executing the target backup action instruction sequence, simulating the backup operation of the user based on the target backup page, so as to upload the target backup file in the current time period to the target backup object through the target data interface in a specified mode.

In the present embodiment, the storage medium includes, but is not limited to, a random access Memory (Random Access Memory, RAM), a Read-Only Memory (ROM), a Cache (Cache), a Hard Disk (HDD), or a Memory Card (Memory Card). The memory may be used to store computer program instructions. The network communication unit may be an interface for performing network connection communication, which is set in accordance with a standard prescribed by a communication protocol.

In this embodiment, the functions and effects of the program instructions stored in the computer readable storage medium may be explained in comparison with other embodiments, and are not described herein.

Referring to fig. 9, on a software level, the embodiment of the present disclosure further provides a data processing device for a backup file, where the device may specifically include the following structural modules:

the acquiring module 901 may be specifically configured to acquire, by querying a configuration file, an initial file in a current time period when it is determined that a preset target backup condition is currently met; the initial file at least carries an object identifier of the targeted target backup object and a file type identifier of the initial file;

the determining module 902 may be specifically configured to determine, from the configuration file, a matching target backup rule according to an object identifier of the target backup object and a file type identifier of the initial file;

The processing module 903 may be specifically configured to perform corresponding processing on the initial file according to a target backup rule, so as to obtain a target backup file in a current time period that meets a backup requirement;

the login module 904 may be specifically configured to login to a target backup page according to a target backup rule; the report uploading element in the target report page is obtained; the target data interface is at least arranged in the target report page and used for uploading the target report file to the target report object;

the construction module 905 may be specifically configured to construct a target backup action instruction sequence related to a backup upload flow of the target backup page according to a target backup rule and the backup upload element;

the operation module 906 may be specifically configured to simulate, based on the rpa program, a backup operation of the user based on the target backup page by executing the target backup action command sequence, so as to upload the target backup file of the current time period to the target backup object through the target data interface in a specified manner.

In some embodiments, when the obtaining module 901 is specifically implemented, the initial file of the current time period may be obtained by querying the configuration file in the following manner: inquiring a configuration file to obtain ftp information; wherein, the ftp information at least includes: ip address, port identification, storage path; accessing a designated ftp directory according to the ftp information; detecting whether an initial file meeting the requirement in the current time period exists in the ftp directory; and downloading the initial file under the condition that the initial file meeting the current time period is determined to exist in the ftp target record.

In some embodiments, after detecting whether there is an initial file in the ftp directory for the current time period that is satisfactory, the apparatus may be further configured, when embodied, to: and generating an ending instruction for ending the backup task of the current time period under the condition that the initial file of the current time period meeting the requirements does not exist in the ftp directory.

In some embodiments, when the processing module 903 is specifically implemented, the corresponding processing may be performed on the initial file according to the target backup rule according to the following manner: and carrying out one or more of the following processing treatments on the initial file according to the target backup rule: detecting whether the number of lines in the initial file is larger than a preset line number threshold value according to a target backup rule; splitting an initial file into a plurality of subfiles under the condition that the number of lines in the initial file is determined to be larger than a preset line number threshold; the number of lines in the subfiles is smaller than or equal to a preset line number threshold; detecting whether a text field in an initial file accords with a report rule or not according to a target report rule; correcting the text field in the initial file under the condition that the text field in the initial file is determined to be not in accordance with the backup standard; detecting whether redundant data items exist in the initial file according to the target backup rule; in the event that it is determined that a redundant data item exists in the initial file, the redundant data item in the initial file is deleted.

In some embodiments, when the login module 904 is specifically implemented, the target backup page may be logged according to the target backup rule in the following manner: determining a target backup page corresponding to the target backup object according to the target backup rule; obtaining a target access link of a target backup page; acquiring preset login data aiming at a target backup page; the preset login data at least comprise login account aiming at the target backup page and ciphertext data of a login password corresponding to the login account; accessing the target backup page according to the target access link of the target backup page; and logging in the target backup page by using preset login data.

In some embodiments, when the login module 904 is specifically implemented, the target backup page may be logged in with preset login data in the following manner: invoking a preset auxiliary login plug-in to decrypt ciphertext data of a login password in a trusted execution environment of a server to obtain a corresponding login password; wherein, the preset auxiliary login plug-in is internally provided with a corresponding decryption key; based on rpa program, simulating the user to input corresponding login account and login password in the target backup page so as to log in the target backup page.

In some embodiments, when the login module 904 is specifically implemented, the backup upload element in the target backup page may be acquired as follows: acquiring source code data of a target backup page; and according to the target backup rule, searching the backup uploading field of the source code data of the target backup page to obtain backup uploading elements in the target backup page.

In some embodiments, when the above-mentioned construction module 905 is specifically implemented, a target backup action instruction sequence related to a backup upload flow of a target backup page may be constructed according to a target backup rule and the backup upload element in the following manner: screening matched preset action instructions from a preset action instruction set according to the report uploading elements to serve as initial action instructions; wherein, the preset action instruction set stores a plurality of preset action instructions aiming at pages; filling a corresponding initial action instruction by utilizing a report backup uploading element according to a target report backup rule to obtain a target action instruction; and combining the target action instructions according to the target backup rule to obtain a target backup action instruction sequence of a backup uploading flow of the target backup page.

In some embodiments, in a case that a preset action instruction matching with the backup upload element is not screened from a preset action instruction set, the apparatus may be further configured to, when implemented: generating a generation request for an action instruction; the generation request of the action instruction at least carries a corresponding report uploading element; sending the generation request of the action instruction to an operation and maintenance terminal; receiving an action instruction fed back by the operation and maintenance terminal; and storing the action instruction into a preset action instruction set.

In some embodiments, after logging in the target backup page according to the target backup rule, the apparatus may be further configured, when embodied, to: acquiring and generating a check page switching action instruction according to the check page elements in the target report page; switching to a corresponding target check page by executing a check page switching action instruction; the target check page at least comprises the report state of the uploaded target report file; acquiring a report check element in a target check page; constructing a target check action instruction sequence of the report check of the target check page according to the target report rule and the report check element; based on rpa program, by executing the target checking action instruction sequence, the checking operation of the user based on the target checking page is simulated to acquire the report state information of the target report file which is uploaded currently.

In some embodiments, after obtaining the backup status information of the currently uploaded target backup file, the apparatus may be further configured to: detecting whether the backup state of the uploaded target backup file is abnormal or not according to the backup state information of the currently uploaded target backup file; under the condition that the report state of the uploaded target report file is abnormal, acquiring the file identification of the abnormal file and the current report state information of the abnormal file; generating and feeding back an abnormal standby prompt to the user terminal; the abnormal backup prompt at least carries the file identification of the abnormal file and the current backup state information of the abnormal file.

In some embodiments, the apparatus, when embodied, may also be used to: receiving file backup update information issued by a target backup object; processing the file report update information by using a preset semantic recognition model to obtain a corresponding semantic recognition result; and updating the configuration file according to the semantic recognition result.

It should be noted that, the units, devices, or modules described in the above embodiments may be implemented by a computer chip or entity, or may be implemented by a product having a certain function. For convenience of description, the above devices are described as being functionally divided into various modules, respectively. Of course, when the present description is implemented, the functions of each module may be implemented in the same piece or pieces of software and/or hardware, or a module that implements the same function may be implemented by a plurality of sub-modules or a combination of sub-units, or the like. The above-described apparatus embodiments are merely illustrative, for example, the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.

From the above, the data processing device for reporting and backup files provided by the embodiments of the present specification can accurately and automatically upload reporting and backup of related data files by introducing and effectively using rpa technology, thereby reducing workload of a user side, improving overall processing efficiency, and reducing errors occurring in reporting and backup processes.

In a specific scenario example, the data processing method of the provisioning document provided in the present specification may be applied to implement automatic provisioning of a bank (for example, a target provisioning object) based on rpa to implement personal settlement account data (related data to be provisioned).

In this scenario example, according to the report specification and requirements of the a bank, the a bank account management system (e.g., target report page) reports the account opening information within 5 working days from the day of the individual bank settlement account opening; and reporting account change and withdrawal information to the bank account management system A within 2 working days after the date of changing and canceling the personal bank account. In principle, the bank opening the account should be determined according to the generic management principle. And opening the personal bank account through the counter channel, wherein the bank website which receives the opening application data is the opening bank. And opening an individual bank account through the self-service machine, wherein the bank website to which the self-service machine belongs is an account opening bank.

In the specific implementation, in order to realize automatic report of personal settlement account data to the bank a based on rpa, the following relevant components and key steps are specifically configured and used in conjunction with fig. 10.

(1) The configuration file contains ftp (e.g., ftp information); based on the configuration file, the file ip to be reported, the port identification, the path information, the login url (for example, the target access link), the login user name, the login password (encrypted) information of the bank settlement account management system A, and the maximum line number information (for example, the target report rule) of the single report file can be obtained.

(2) Automatically acquiring a file to be reported: reading ftp from the configuration file; and acquiring the file ip to be reported, the port identification and the path information based on the ftp, automatically logging in a corresponding ftp path in the background, finding out a T-2 date directory, judging whether the file exists in the date directory, if so, storing the file in a local directory (e.g. a local cache), and if not, sending an alarm mail.

(3) Automatically processing the file to be reported: and (2) after the obtained file in the step (2) is stored locally, automatically decompressing, matching the file name according to the keywords, analyzing the file content, splitting the file exceeding the maximum number of lines of a single backup file in the configuration file, and renaming the split file to prevent coverage.

(4) Automatically logging in a bank settlement account management system: reading the information of url, user name and password (encrypted) of the bank A settlement account management system from the configuration file, decrypting the password, and logging in the bank A settlement account management system; and judging the login state, if the login is abnormal, if the login is not automatic, the user does not jump to a page after normal login, or if the page has an clearly-erroneous information popup window, sending an alarm mail.

(5) Automatically uploading a file to be reported: according to the established business process, rpa is used for grabbing a backup process element (for example, a backup uploading element) of the A bank settlement account management system page, wherein the backup process element mainly comprises elements such as uploading date, uploading file type, uploading file selection input box and the like. In the rpa technology, the unique key value of the webpage source code is mainly used as an index, related elements are grabbed from the webpage, and follow-up related actions such as clicking the elements, setting element texts, selecting a drop-down frame, acquiring element contents and the like are realized, so that the operation of grabbing the elements is realized, and the function of simulating the actual operation of a user is realized. Specifically, the method mainly relates to capturing elements such as file names, uploading result states, dates, page menu items and the like. If an abnormality occurs, such as file uploading failure, date error, file name checking error and other error information popup windows, rpa can send an alarm mail by acquiring the content of the error information popup window.

(6) Automatically checking the state of the reported file: according to the established business flow, rpa is used for checking the A bank settlement account management system page to grasp the state flow elements (for example, the check elements) of the reported file, wherein the state flow elements of the reported file mainly comprise the name of the uploaded file and the processing state content of the A bank of the uploaded file. In the rpa technology, the unique key value of the webpage source code is mainly used as an index, related elements are grabbed from the webpage, and follow-up related actions such as clicking the elements, setting element texts, selecting a drop-down frame, acquiring element contents and the like are realized, so that the operation of grabbing the elements is realized, and the function of simulating the actual operation of a user is realized. In the invention, the grabbing of elements such as file names, processing result states, dates, page menu items and the like is mainly involved. If abnormality occurs, such as failure in acquiring elements such as file name, processing result state, date, page menu item, etc., the processing result state is not processed, etc., rpa acquires abnormality information, and then sends alarm mail.

(7) Automatically sending a result mail: and according to the flow operation state, informing the corresponding addressees of the mail of the flow operation result, wherein the mail comprises normal or abnormal results.

(8) Automatically cleaning the reported file: and after the file is successfully uploaded, the reported file before T-7 days is automatically cleaned, so that secret leakage is prevented.

Based on the above-described related components and key steps, the following may be included when implemented.

S1: and judging whether the configuration file exists or not, if not, terminating the flow and sending an alarm mail.

S2: reading ftp information of the configuration file by using rpa, obtaining a file to be reported, and realizing automatic downloading of a personal settlement account file from a specified ftp directory; and judging whether the file exists or not, if so, judging the file according to the maximum line number information set by the configuration file, then processing, and if not, terminating the flow and sending an alarm mail.

S3: reading login information of a bank settlement account management system of a configuration file A by using rpa, decrypting the acquired password, logging in the bank settlement account management system of the A by using an account number provided by the bank A and the decrypted password (IE compatible mode, trusted website), reporting files after the previous processing (other- > data file reporting), selecting data file types (batch files of personal bank settlement accounts), browsing and uploading rpb-date-file name. Txt files, judging the reporting result, if the reporting result is normal, sending successful mails, and if the reporting flow is abnormal, sending alarm mails.

S4: and reading login information of the bank settlement account management system of the configuration file A by using rpa, decrypting the acquired password, and logging in the bank settlement account management system of the A by using an account number provided by the bank A and the decrypted password (IE compatible mode and trusted website). Entering report file management (other- > report file management), if the report backup flow is accepted, firstly clicking to cancel; inquiring report results, and selecting the type of the data file: the method comprises the steps of selecting a file uploading time range by a personal batch file, clicking and submitting, and checking the uploaded file processing state, wherein the processing state is as follows: processed and failure cause is empty, if yes, then success is indicated, and a successful mail is sent, if not, then failure is indicated, mail of failure result is sent to the contact person, and re-uploading is notified. :

s5: if the daily backup file is successfully uploaded, automatically starting a file cleaning process, and automatically deleting the backup file which is reported before T-7 days.

Based on the scene examples, the data processing method of the report and backup file provided by the specification is verified, the conventional system and the process are not changed by using rpa technology, the manual operation steps in the original scene implementation process are completely replaced, the four operations of file downloading, file processing, report and backup A bank and related personnel notification are combined, the process operation automation is realized, the daily repeatability of service personnel is replaced, the workload is high, the tedious and time-consuming work is avoided, various influences caused by misoperation are avoided, and the service personnel can concentrate on more meaningful work and create greater value in response to the requirements of general line science and technology for service load reduction and energization; the automatic operation is carried out every day, so that the problem of reporting and backup aging caused by untimely manual treatment on holidays is solved, and the labor cost is reduced.

Although the present description provides method operational steps as described in the examples or flowcharts, more or fewer operational steps may be included based on conventional or non-inventive means. The order of steps recited in the embodiments is merely one way of performing the order of steps and does not represent a unique order of execution. When implemented by an apparatus or client product in practice, the methods illustrated in the embodiments or figures may be performed sequentially or in parallel (e.g., in a parallel processor or multi-threaded processing environment, or even in a distributed data processing environment). The terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, it is not excluded that additional identical or equivalent elements may be present in a process, method, article, or apparatus that comprises a described element. The terms first, second, etc. are used to denote a name, but not any particular order.

Those skilled in the art will also appreciate that, in addition to implementing the controller in a pure computer readable program code, it is well possible to implement the same functionality by logically programming the method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers, etc. Such a controller can be regarded as a hardware component, and means for implementing various functions included therein can also be regarded as a structure within the hardware component. Or even means for achieving the various functions may be regarded as either software modules implementing the methods or structures within hardware components.

The description may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, classes, etc. that perform particular tasks or implement particular abstract data types. The specification may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer-readable storage media including memory storage devices.

From the above description of embodiments, it will be apparent to those skilled in the art that the present description may be implemented in software plus a necessary general hardware platform. Based on such understanding, the technical solutions of the present specification may be embodied essentially in the form of a software product, which may be stored in a storage medium, such as a ROM/RAM, a magnetic disk, an optical disk, etc., and include several instructions to cause a computer device (which may be a personal computer, a mobile terminal, a server, or a network device, etc.) to perform the methods described in the various embodiments or portions of the embodiments of the present specification.

Various embodiments in this specification are described in a progressive manner, and identical or similar parts are all provided for each embodiment, each embodiment focusing on differences from other embodiments. The specification is operational with numerous general purpose or special purpose computer system environments or configurations. For example: personal computers, server computers, hand-held or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set top boxes, programmable electronic devices, network PCs, minicomputers, mainframe computers, distributed computing environments that include any of the above systems or devices, and the like.

Although the present specification has been described by way of example, it will be appreciated by those skilled in the art that there are many variations and modifications to the specification without departing from the spirit of the specification, and it is intended that the appended claims encompass such variations and modifications as do not depart from the spirit of the specification.

Claims

1. The data processing method of the report file is characterized by comprising the following steps:

2. The method of claim 1, wherein obtaining the initial file for the current time period by querying the configuration file comprises:

3. The method of claim 2, wherein after detecting whether an initial file for a current time period is present in the ftp directory that meets the requirements, the method further comprises:

4. The method of claim 1, wherein the performing a corresponding processing on the initial file according to a target backup rule comprises:

5. The method of claim 1, wherein logging in the target backup page according to the target backup rules comprises:

6. The method of claim 5, wherein logging in the target backup page using the preset login data comprises:

7. The method of claim 1, wherein obtaining a backup upload element in the target backup page comprises:

acquiring source code data of a target backup page;

8. The method of claim 7, wherein constructing a target backup action instruction sequence for a backup upload flow for a target backup page based on a target backup rule and the backup upload element comprises:

9. The method of claim 8, wherein in the event that a preset action instruction matching the backup upload element is not screened from a preset action instruction set, the method further comprises:

10. The method of claim 1, wherein after logging in the target backing page according to the target backing rule, the method further comprises:

acquiring a report check element in a target check page;

11. The method of claim 10, wherein after obtaining backup status information of a currently uploaded target backup file, the method further comprises:

12. The method according to claim 1, wherein the method further comprises:

receiving file backup update information issued by a target backup object;

13. A data processing apparatus for reporting a file, comprising:

14. A server comprising a processor and a memory for storing processor-executable instructions, which when executed by the processor implement the steps of the method of any one of claims 1 to 12.

15. A computer readable storage medium, having stored thereon computer instructions which, when executed by a processor, implement the steps of the method of any of claims 1 to 12.