WO2020029388A1

WO2020029388A1 - File transmission method, system, computer device and storage medium

Info

Publication number: WO2020029388A1
Application number: PCT/CN2018/106693
Authority: WO
Inventors: 李琦; 刘琼; 谢云
Original assignee: 平安科技（深圳）有限公司
Priority date: 2018-08-07
Filing date: 2018-09-20
Publication date: 2020-02-13
Also published as: CN109040252A; CN109040252B

Abstract

The present application relates to the technical field of data processing, in particular to a file transmission method, a system, a computer device and a storage medium. The method comprises: acquiring a file lookup directory table, which comprises a plurality of file paths and a data extraction rule, creating files in target paths corresponding to the file paths at regular intervals, renaming the files with a file rename name, accessing a database according to the file paths, extracting data information according to data fields in the data extraction rule, and storing the data information in the files; establishing a connection with a remote server at regular intervals through SFTP client software of a client, and transmitting the files stored in the target paths to the remote server. The present application can accurately classify the files by re-extracting the data, renaming and sorting the files, and can implement the remote automatic secure transmission of the files with the remote server by deploying the SFTP client software.

Description

File transmission method, system, computer equipment and storage medium

This application claims priority from a Chinese patent application filed with the Chinese Patent Office on August 08, 2018, with application number 201810891980.7, and the invention name is "File Transfer Method, System, Computer Equipment, and Storage Medium", the entire contents of which are incorporated by reference. In this application.

Technical field

The present application relates to the field of data processing technologies, and in particular, to a file transmission method, system, computer device, and storage medium.

Background technique

The application on the client generates a large number of files every day, such as the most common log files. Among the many files, part of the data is what the remote server wants to obtain. After the remote server establishes a connection with the client, if you manually find the data and upload the file, obviously the workload is very heavy. If the file is automatically uploaded to the remote server by automatically finding the file, when the file size is large, the client cannot determine which data is required by the remote server, and all files may be uploaded to the remote server, which may cause the remote server to receive it. A lot of unwanted data. If multiple clients upload a large number of files to a remote server at the same time, it is also prone to network congestion, which puts pressure on transferring files.

Summary of the invention

In view of this, it is necessary to provide a file transmission method, system, computer device, and storage medium for the problem that a large number of files generated by clients cannot be accurately located and searched and transmitted to a remote server.

A file transfer method includes:

Obtaining a file search directory table, where the file search directory table is stored in a client database, the file search directory table includes a plurality of file paths and data extraction rules, and each of the file paths corresponds to one of the data extraction rules, The data extraction rule includes a data field to be extracted, a file renaming name, and a target path;

Periodically create a file in the target path corresponding to the file path, rename the file with the file rename name, access the database according to the file path, and extract data from the data extraction rule Field to extract data information, and save the data information in the file, and sequentially generate the files for several of the file paths;

By presetting a secure file transfer protocol SFTP client software on the client to periodically establish a connection with a remote server, the file stored in the target path is sent to the remote server.

A file transfer system includes:

The obtaining unit is configured to obtain a file search directory table, where the file search directory table is stored in a client database, and the file search directory table includes a plurality of file paths and data extraction rules, and each of the file paths corresponds to an The data extraction rule, which includes a data field to be extracted, a file renaming name, and a target path;

A file generating unit is set to periodically create a file in the target path corresponding to the file path, rename the file with the file rename name, access the database according to the file path, and use the file path The data field in the data extraction rule extracts data information, saves the data information in the file, and sequentially generates the files for several of the file paths;

The sending unit is configured to periodically establish a connection with a remote server through a preset secure file transfer protocol SFTP client software on the client, and send the file stored in the target path to the remote server.

A computer device includes a memory and a processor. The memory stores computer-readable instructions. When the computer-readable instructions are executed by the processor, the processor causes the processor to perform the following steps:

A storage medium storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the following steps:

The above file transmission method, device, computer equipment and storage medium include obtaining a file search directory table, the file search directory table is stored in a client database, and the file search directory table includes a number of file paths and data extraction rules, each of which corresponds to a file path A data extraction rule. The data extraction rule includes the data fields to be extracted, the file renaming name, and the target path. The file is periodically created in the target path corresponding to the file path, and the file is renamed by the file renaming name. Access the database, use the data fields in the data extraction rules to extract the data information, and save the data information in the file, and generate files for several file paths in sequence; by presetting the secure file transfer protocol SFTP client software on the client with the remote server Establish a connection and send the file stored in the destination path to the remote server. The present application can accurately classify files by re-extracting data, renaming and sorting files, and by deploying SFTP client software, the purpose of remote and automatic file transmission with remote servers can be achieved.

BRIEF DESCRIPTION OF THE DRAWINGS

Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the detailed description of the preferred embodiments below. The drawings are only for the purpose of illustrating preferred embodiments and are not to be considered as limiting the present application.

FIG. 1 is a flowchart of a file transmission method according to an embodiment of the present application;

FIG. 2 is a flowchart of step S1 in an embodiment; FIG.

3 is a flowchart of step S2 in an embodiment;

4 is a flowchart of step S3 in an embodiment;

5 is a structural diagram of a file transmission system according to an embodiment of the present application;

FIG. 6 is a structural diagram of a file generating unit in one embodiment.

detailed description

In order to make the purpose, technical solution, and advantages of the present application clearer, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the application, and are not used to limit the application.

Those skilled in the art will understand that, unless specifically stated otherwise, the singular forms "a", "an", "the" and "the" may include plural forms. It should be further understood that the word "comprising" used in the specification of the present application refers to the presence of the described features, integers, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, Integers, steps, operations, elements, components, and / or groups thereof.

FIG. 1 is a flowchart of a file transmission method according to an embodiment of the present application. As shown in FIG. 1, a file transmission method includes the following steps:

Step S1, obtaining a file search directory table: obtaining a file search directory table, the file search directory table is stored in a client database, and the file search directory table includes a number of file paths and data extraction rules, and each file path corresponds to a data extraction rule The data extraction rules include the data fields to be extracted, the file renaming name, and the target path.

In this step, a file search directory table is preset in the client's database. The file search directory table contains a number of file paths. Each file path can access files or data in the database. Each file path also corresponds to a file path. Data extraction rules, such as which data fields in the file or data need to be extracted after accessing the file or data in the database, the file name of the new file to be renamed, the path location of the new file to be generated in the database, etc. .

Step S2, generate a file: periodically create a file in a target path corresponding to the file path, rename the file with a file rename name, access the database according to the file path, extract data information from the data fields in the data extraction rule, and save the data The information is saved in a file, and files are sequentially generated for several file paths.

When generating a file, first obtain a file path, create a file in the target path in the data extraction rule corresponding to this file path, rename the created file with the file rename name, and generate the corresponding file path file. Access the database according to this file path, obtain the data fields that need to be extracted in the data extraction rules corresponding to this file path, extract the data information, and store the extracted data information in the file generated above to complete the file generation process of this file path. Because the file search directory table contains several file paths, corresponding files are generated in sequence for each file path, that is, one file is generated in the target path corresponding to each file path.

The timing in this step is to select a certain time, such as sequentially generating files from 9:00 in the morning. In order to avoid system pressure on the client when the client processes data, the time can also be set to 9 in the evening. 0:00 and other non-working hours, automatically generate several files.

Step S3: Send the file: The SFTP client software, which is a preset secure file transfer protocol on the client, is used to periodically establish a connection with the remote server, and send the file stored in the target path to the remote server.

SFTP is the abbreviation of Secure File Transfer and Protocol, which is a secure file transfer protocol that can provide a secure network encryption method for transferring files. SFTP is part of SSH and is a secure way to transfer files to a server. Usually, the SSH software package contains the secure file information transmission subsystem of SFTP. SFTP itself does not have a separate daemon process. It uses the SSHD process to complete the corresponding connection and reply operations. SFTP uses encryption to transmit authentication information and data. Therefore, using SFTP in this step is very secure. When the SFTP client software establishes a connection with a remote server, there are two connection methods, one is to use the SFTP client software to connect to the remote server IP, and the other is to log in to the remote server first and then enable the SFTP function. This step uses the SFTP client software to connect to the remote server, periodically establishes a connection with the remote server, and sends the file stored in the target path to the remote server.

In this embodiment, after several files required by the remote server are generated through the file path and data extraction rules, the SFTP client software is used to periodically establish a connection with the remote server, and the generated files are sent to the remote server at regular intervals to ensure that the remote server receives the received packets at regular intervals. The data in the file is the required data, avoiding receiving many unnecessary data, and avoiding the problem of network congestion caused by the client uploading a large number of files. The method of transferring files through SFTP can not only achieve the purpose of automatically uploading files, but also ensure that the uploaded files are safe and reliable.

In an embodiment, as shown in FIG. 2, before obtaining the file search directory table, the method includes:

Step S101, preset input interface and file search directory table: preset input interface and file search directory table on the client, and set file path search button, file path field, data field, file rename name field and target path in the input interface Field.

Step S102, storing field information: after obtaining the field information input in the entry interface, storing the field information in a file search directory table.

As the file sent by the client to the remote server may increase the data, this step is to increase the file through the input interface. Fill in the file path, the data fields to be extracted, the file renaming name, and the target path in the input interface. Get the data, generate a new file and send it to the remote server. The entry interface can also be set to modify and delete related functions, in order to modify and delete the saved dry file path and data extraction rules in the file search directory table, increasing the flexibility of this step.

In one embodiment, as shown in FIG. 3, step S2 includes:

In step S201, a file is created: a preset java timed task is called, a file is sequentially created in a target path corresponding to the file path, and the file is renamed with the current timestamp and the file is renamed.

When renaming a file, the file renaming name can be preset with different names. For example, if the file path indicates a fund ranking file, when extracting data fields from the fund ranking file, the file renaming name can be defined as FundRank, the file name when renaming the file in this step is FundRank20180719134209. If the file path indicates a wealth management product ranking file, when extracting data fields from the wealth management product ranking file, the file renaming name can be defined as FinPrdRank, and the file name when renaming the file in this step is FinPrdRank20180719134209.

Step S202: Save the data information: According to the file path, extract the data field corresponding to the file path from the database, set the data field to the data information, and then store the data information in the file.

If the file path indicates a fund ranking file, according to the file path, data fields are extracted from the fund ranking file, and the data information corresponding to the data field is stored in the file generated in step S201.

Step S203, sorting: place the files in the target path, and sort the file names in descending order in chronological order.

After the file is generated regularly, multiple files will be generated in a certain target path. For example, the file path indicates the fund ranking file. When the file rename name can be defined as FundRank, the file name is generated on July 18 as FundRank20180718134128 The file, FundRank20180719134209 was generated on July 19. This step sorts all the files in a target path in chronological order in descending order to ensure that the first generated file is the most recently generated file, and the file is sent to the remote in the future. When the server, get the first file.

Step S204, traverse the file path: according to the java timed task, traverse several file paths, and sequentially generate files in the target path corresponding to the file path.

Because the file search directory table contains several file paths, it is possible to ensure that all the file paths correspond to the latest file by traversing.

In this embodiment, a number of files are generated periodically by invoking a Java timed task, which can achieve the purpose of automatically capturing data by the client and automatically generating required files.

In one embodiment, step S3 includes: calling the SFTP client software preset on the client, periodically establishing a connection with the remote server, reading the file in the target path, and sending the file to the remote server through the SFTP client software. As shown in FIG. 4, it specifically includes the following steps:

In step S301, the parameters are automatically set: obtaining the user name and password of the SFTP client software, calling the SFTP client software, and automatically setting the file sending port number and the IP address of the remote server.

The user name, password file sending port number, and remote server IP address of the SFTP client software can be preset in a form or file. This step obtains this information from the preset form or file and calls the SFTP client software. Automatically set file sending port number and IP address of remote server. The file sending port number of the SFTP client software is 22 by default.

In step S302, a connection is established: a shell script is invoked, and the user name, password, port number, and IP address are used as parameters of the SFTP client software, and the SFTP client software is used to periodically establish a connection with the remote server.

Shell scripting is both a command language and a programming language. Shell scripts are put into a file with various commands in advance, which is a program file that is convenient for one-time execution. Shell scripts are more powerful than batch processing under Windows and more efficient than programs edited with other programming programs. This step uses a shell script to periodically establish a connection between the SFTP client software and a remote server.

In step S303, the file is sent: the newly generated files in the target path are sequentially read and sent to the remote server.

This step reads the files in several target paths in the client, reads the newly generated files, and sends the newly generated files to the remote server. In this step, you can also use a shell script to automatically upload files.

The file transmission method of the present application accesses data information in a database through a file path in a file search directory table, generates a file and renames a file through a data extraction rule, and stores the data information in a newly generated file. After accessing the data information corresponding to all file paths and generating several files, the SFTP client software periodically establishes a connection with the remote server and sends the newly generated files to the remote server. The method of the present application does not need to manually find a file uploaded to a remote server. Because the data information in the file is the designated data, it avoids the problem that the remote server receives many unnecessary data. In addition, the SFTP client software is used for regular sending to avoid network congestion caused by multiple clients uploading a large number of files at the same time. And use SFTP client software to send, can ensure the safe and stable sending of files.

In one embodiment, a file transfer system is proposed, as shown in FIG. 5, and includes the following units:

The obtaining unit is configured to obtain a file search directory table. The file search directory table is stored in the client's database. The file search directory table includes several file paths and data extraction rules. Each file path corresponds to a data extraction rule and a data extraction rule. Including the data fields to be extracted, the file renaming name, and the target path;

Generate a file unit, set it to periodically create a file in the target path corresponding to the file path, rename the file with the file rename name, access the database by the file path, extract data information from the data fields in the data extraction rule, and save the data Information is stored in files, and files are generated for several file paths in sequence;

The sending unit is configured to periodically establish a connection with the remote server through a preset secure file transfer protocol SFTP client software on the client, and send the file stored in the target path to the remote server.

In one embodiment, it further includes a storage file search directory table unit, which is configured to preset the input interface and the file search directory table on the client, and set a file path search button, a file path field, a data field, and a file rename name in the input interface. Field and target path field. After obtaining the field information entered in the entry interface, store the field information in the file search directory table.

In one embodiment, as shown in FIG. 6, generating a file unit includes:

Create a file module, set to call a preset java timed task, create files in the target path corresponding to the file path in turn, and rename the file with the file rename name plus the current timestamp;

Save data information module, set to extract the data field corresponding to the file path from the database, set the data field to data information, and store the data information in the file;

Sorting module, set to sort files in the target path, and sort file names in descending order according to chronological order;

The traversal module is set to traverse several file paths according to the java timed task, and sequentially generate files in the target path corresponding to the file path.

In one embodiment, the sending unit is further configured to call the SFTP client software preset on the client, periodically establish a connection with the remote server, read the file in the target path, and send the file to the remote server through the SFTP client software .

In one embodiment, the sending unit is further configured to obtain the user name and password of the SFTP client software, invoke the SFTP client software, automatically set the file sending port number, the IP address of the remote server, and invoke a shell script with the user name and password. , Port number, and IP address are used as parameters of the SFTP client software. The SFTP client software is used to periodically establish a connection with the remote server. The newly generated files in the target path are sequentially read and sent to the remote server.

In one embodiment, a computer device is provided, which includes a memory and a processor. The memory stores computer-readable instructions, and when the computer-readable instructions are executed by the processor, the processor is caused to implement the foregoing when the computer-readable instructions are executed. The steps in the file transfer method in the embodiment.

In one embodiment, a storage medium storing computer-readable instructions is provided. When the computer-readable instructions are executed by one or more processors, the one or more processors are caused to execute the file transfer method in the foregoing embodiments. Steps. The storage medium may be a non-volatile storage medium.

A person of ordinary skill in the art may understand that all or part of the steps in the various methods of the foregoing embodiments may be implemented by a program instructing related hardware. The program may be stored in a computer-readable storage medium. The storage medium may include: Read-only memory (ROM, Read Only Memory), random access memory (RAM, Random Access Memory), magnetic disks or optical disks, etc.

The technical features of the embodiments described above can be arbitrarily combined. In order to simplify the description, all possible combinations of the technical features in the above embodiments have not been described. However, as long as there is no contradiction in the combination of these technical features, It should be considered as the scope described in this specification.

The above-mentioned embodiments only express some exemplary embodiments of the present application, and their descriptions are more specific and detailed, but cannot be understood as a limitation on the scope of the patent of the present application. It should be noted that, for those of ordinary skill in the art, without departing from the concept of the present application, several modifications and improvements can be made, which all belong to the protection scope of the present application. Therefore, the protection scope of this application patent shall be subject to the appended claims.

Claims

A file transfer method includes:

Obtaining a file search directory table, where the file search directory table is stored in a client database, the file search directory table includes a plurality of file paths and data extraction rules, and each of the file paths corresponds to one of the data extraction rules, The data extraction rule includes a data field to be extracted, a file renaming name, and a target path;

Periodically create a file in the target path corresponding to the file path, rename the file with the file rename name, access the database according to the file path, and extract data from the data extraction rule Field to extract data information, and save the data information in the file, and sequentially generate the files for several of the file paths;

By presetting a secure file transfer protocol SFTP client software on the client to periodically establish a connection with a remote server, the file stored in the target path is sent to the remote server.
The file transfer method according to claim 1, wherein before the obtaining a file to search a directory table, comprises:

Presetting an entry interface and a file search directory table in the client, and setting a file path search button, a file path field, a data field, a file rename name field, and a target path field in the input interface;

After obtaining the field information input in the entry interface, the field information is stored in the file search directory table.
The file transfer method according to claim 1, wherein the timing creates a file in the target path corresponding to the file path, renames the file with the file rename name, and presses the file Accessing the database via a path, extracting data information from a data field in the data extraction rule, and storing the data information in the file, and sequentially generating the files for several of the file paths include:

Calling a preset java timed task, sequentially creating the file in the target path corresponding to the file path, and renaming the file with the file renaming name plus the current timestamp;

Extracting a data field corresponding to the file path from the database according to the file path, setting the data field to data information, and storing the data information in the file;

Place the file in the target path, and sort the file names in descending order according to chronological order;

According to the java timed task, traverse several of the file paths, and sequentially generate the files in the target path corresponding to the file path.
The file transfer method according to claim 1, wherein the secure file transfer protocol SFTP client software preset on the client periodically establishes a connection with a remote server to store the file in the target path Sending to the remote server includes:

Calling the SFTP client software preset on the client, periodically establishing a connection with the remote server, reading a file in the target path, and sending the file to the remote server through the SFTP client software .
The file transfer method according to claim 4, wherein said sending said file to said remote server through said SFTP client software comprises:

Obtaining the user name and password of the SFTP client software, calling the SFTP client software, and automatically setting the file sending port number and the IP address of the remote server;

Invoking a shell script, using the user name, password, port number, and IP address as parameters of the SFTP client software, and establishing a connection with the remote server through the SFTP client software periodically;

The newly generated files in the target path are sequentially read and sent to the remote server.
A file transfer system includes:

The obtaining unit is configured to obtain a file search directory table, where the file search directory table is stored in a client database, and the file search directory table includes a plurality of file paths and data extraction rules, and each of the file paths corresponds to an The data extraction rule, which includes a data field to be extracted, a file renaming name, and a target path;

A file generating unit is set to periodically create a file in the target path corresponding to the file path, rename the file with the file rename name, access the database according to the file path, and use the file path The data field in the data extraction rule extracts data information, saves the data information in the file, and sequentially generates the files for several of the file paths;

The sending unit is configured to periodically establish a connection with a remote server through a preset secure file transfer protocol SFTP client software on the client, and send the file stored in the target path to the remote server.
The file transfer system according to claim 6, further comprising a file search directory table storage unit configured to preset the input interface and the file search directory table on the client, and set a file path search button in the input interface, The file path field, the data field, the file rename name field, and the target path field, after obtaining the field information entered in the entry interface, store the field information in the file lookup directory table.
The file transfer system according to claim 6, wherein the file generating unit comprises:

Create a file module, set to call a preset java timed task, sequentially create the file in the target path corresponding to the file path, and rename the file with the current timestamp and rename the file;

The data information saving module is configured to extract a data field corresponding to the file path from the database, and after the data field is set to data information, the data information is stored in the file;

A sorting module, configured to sort the files in the target path, and sort the file names in descending order according to chronological order;

The traversal module is configured to traverse several of the file paths according to the java timed task, and sequentially generate the files in the target path corresponding to the file path.
The file transfer system according to claim 6, wherein the sending unit is further configured to call the SFTP client software preset on the client, and periodically establish a connection with the remote server to read the target path The file is sent to the remote server through the SFTP client software.
The file transfer system according to claim 9, wherein the sending unit is further configured to obtain a user name and password of the SFTP client software, invoke the SFTP client software, and automatically set a file sending port number and a remote server. Call the shell script with the user name, password, port number, and IP address as parameters of the SFTP client software, periodically establish a connection with the remote server through the SFTP client software, and sequentially read The latest generated file in the target path is sent to the remote server.
A computer device includes a memory and a processor. The memory stores computer-readable instructions. When the computer-readable instructions are executed by the processor, the processor causes the processor to perform the following steps:

Obtaining a file search directory table, where the file search directory table is stored in a client database, the file search directory table includes a plurality of file paths and data extraction rules, and each of the file paths corresponds to one of the data extraction rules, The data extraction rule includes a data field to be extracted, a file renaming name, and a target path;

Periodically create a file in the target path corresponding to the file path, rename the file with the file rename name, access the database according to the file path, and extract data from the data extraction rule Field to extract data information, and save the data information in the file, and sequentially generate the files for several of the file paths;

By presetting a secure file transfer protocol SFTP client software on the client to periodically establish a connection with a remote server, the file stored in the target path is sent to the remote server.
The computer device according to claim 11, wherein before the obtaining a file to search a directory table, the processor is caused to perform the following steps:

Presetting an entry interface and a file search directory table in the client, and setting a file path search button, a file path field, a data field, a file rename name field, and a target path field in the input interface;

After obtaining the field information input in the entry interface, the field information is stored in the file search directory table.
The computer device according to claim 11, wherein the timing creates a file in the target path corresponding to the file path, renames the file with the file rename name, and presses the file path When accessing the database, extracting data information by using data fields in the data extraction rule, and storing the data information in the file, when sequentially generating the files for several of the file paths, the processor Perform the following steps:

Calling a preset java timed task, sequentially creating the file in the target path corresponding to the file path, and renaming the file with the file renaming name plus the current timestamp;

Extracting a data field corresponding to the file path from the database according to the file path, setting the data field to data information, and storing the data information in the file;

Place the file in the target path, and sort the file names in descending order according to chronological order;

According to the java timed task, traverse several of the file paths, and sequentially generate the files in the target path corresponding to the file path.
The computer device according to claim 11, wherein the secure file transfer protocol SFTP client software preset on the client establishes a connection with a remote server at regular intervals, and sends the file stored in the target path When given to the remote server, the processor is caused to perform the following steps:

Calling the SFTP client software preset on the client, periodically establishing a connection with the remote server, reading a file in the target path, and sending the file to the remote server through the SFTP client software .
The computer device according to claim 14, wherein when said sending said file to said remote server through said SFTP client software, causes said processor to perform the following steps:

Obtaining the user name and password of the SFTP client software, calling the SFTP client software, and automatically setting the file sending port number and the IP address of the remote server;

Invoking a shell script, using the user name, password, port number, and IP address as parameters of the SFTP client software, and establishing a connection with the remote server through the SFTP client software periodically;

The newly generated files in the target path are sequentially read and sent to the remote server.
A storage medium storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the following steps:

Obtaining a file search directory table, where the file search directory table is stored in a client database, the file search directory table includes a plurality of file paths and data extraction rules, and each of the file paths corresponds to one of the data extraction rules, The data extraction rule includes a data field to be extracted, a file renaming name, and a target path;

Periodically create a file in the target path corresponding to the file path, rename the file with the file rename name, access the database according to the file path, and extract data from the data extraction rule Field to extract data information, and save the data information in the file, and sequentially generate the files for several of the file paths;

By presetting a secure file transfer protocol SFTP client software on the client to periodically establish a connection with a remote server, the file stored in the target path is sent to the remote server.
The storage medium according to claim 16, wherein before the obtaining a file to search a directory table, one or more of the processors are caused to perform the following steps:

Presetting an entry interface and a file search directory table in the client, and setting a file path search button, a file path field, a data field, a file rename name field, and a target path field in the input interface;

After obtaining the field information input in the entry interface, the field information is stored in the file search directory table.
The storage medium according to claim 16, wherein the timing creates a file in the target path corresponding to the file path, renames the file with the file rename name, and presses the file path When accessing the database, extracting data information by using data fields in the data extraction rule, and storing the data information in the file, when sequentially generating the files for several of the file paths, one or more The processor performs the following steps:

Calling a preset java timed task, sequentially creating the file in the target path corresponding to the file path, and renaming the file with the file renaming name plus the current timestamp;

Extracting a data field corresponding to the file path from the database according to the file path, setting the data field to data information, and storing the data information in the file;

Place the file in the target path, and sort the file names in descending order according to chronological order;

According to the java timed task, traverse several of the file paths, and sequentially generate the files in the target path corresponding to the file path.
The storage medium according to claim 16, wherein the preset secure file transfer protocol SFTP client software on the client establishes a connection with a remote server at regular intervals, and sends the file stored in the target path When given to the remote server, one or more of the processors are caused to perform the following steps:

Calling the SFTP client software preset on the client, periodically establishing a connection with the remote server, reading a file in the target path, and sending the file to the remote server through the SFTP client software .
The storage medium according to claim 16, wherein when the file is sent to the remote server through the SFTP client software, one or more of the processors are caused to perform the following steps:

Obtaining the user name and password of the SFTP client software, calling the SFTP client software, and automatically setting the file sending port number and the IP address of the remote server;

Invoking a shell script, using the user name, password, port number, and IP address as parameters of the SFTP client software, and establishing a connection with the remote server through the SFTP client software periodically;

The newly generated files in the target path are sequentially read and sent to the remote server.