CN115099202A

CN115099202A - Report file processing method and device, intelligent device and storage medium

Info

Publication number: CN115099202A
Application number: CN202210731757.2A
Authority: CN
Inventors: 高源�
Original assignee: Ping An Bank Co Ltd
Current assignee: Ping An Bank Co Ltd
Priority date: 2022-06-25
Filing date: 2022-06-25
Publication date: 2022-09-23

Abstract

The embodiment of the application discloses a report file processing method, a report file processing device, intelligent equipment and a storage medium, wherein the report file to be checked and the type of the report file to be checked can be obtained; acquiring a configuration file matched with the type of the report file to be checked; analyzing the configuration file to obtain a format processing strategy and a file processing strategy in the configuration file; carrying out format processing on the report file to be subjected to accounting according to the format processing strategy to obtain a target report file to be subjected to accounting in a target format; performing data processing on the target report file to be subjected to accounting according to the file processing strategy to obtain target data in the target report file to be subjected to accounting; and performing accounting processing on the target data. The problem of low report file processing efficiency is solved, and the report file processing efficiency is improved.

Description

Report file processing method and device, intelligent device and storage medium

Technical Field

The application relates to the field of data processing, in particular to a method and a device for processing a report file, intelligent equipment and a storage medium.

Background

At present, the traditional business butt joint between banks and bank card switching clearing institutions is realized, the possible format types of clearing reports of different bank card switching clearing institutions are greatly different from those of each bank under different scenes, the clearing reports are mainly summarized and data in the reports are extracted by manpower at present, and then the extracted data are put into office software for data analysis so as to carry out subsequent data verification and accounting processing operations. In multiple scenes, when a large number of completely different report files are subjected to data extraction and data verification operation, a large amount of manpower is required to be invested, and the report file processing efficiency is low.

Disclosure of Invention

The embodiment of the application provides a report file processing method and device, an intelligent device and a storage medium, and can improve the report file processing efficiency.

In order to solve the above technical problem, an embodiment of the present application provides the following technical solutions:

the embodiment of the application provides a report file processing method, which comprises the following steps:

acquiring a report file to be checked and the type of the report file to be checked;

acquiring a configuration file matched with the type of the report file to be checked;

analyzing the configuration file to obtain a format processing strategy and a file processing strategy in the configuration file;

carrying out format processing on the report file to be subjected to accounting according to the format processing strategy to obtain a target report file to be subjected to accounting in a target format;

performing data processing on the target report file to be subjected to accounting according to the file processing strategy to obtain target data in the target report file to be subjected to accounting;

and performing accounting processing on the target data.

In one embodiment, the file processing policy includes a data positioning policy and a data modification policy, and the data processing of the target report file to be checked according to the file processing policy to obtain target data in the target report file to be checked includes:

performing data positioning on the target report file to be subjected to accounting according to the data positioning strategy to obtain a keyword of the target report file to be subjected to accounting;

and performing data correction on the keywords according to the data correction strategy to obtain target data in the target report file to be accounted.

In an embodiment, the performing data correction on the keyword according to the data correction policy to obtain target data in the target report file to be accounted includes:

acquiring data types of the keywords, wherein the data types comprise text types, date types and number types;

determining a data correction strategy according to the data type, wherein the data correction strategy comprises a text data correction strategy, a date data correction strategy and a digital data correction strategy;

performing data correction on the keywords of the text type according to the text data correction strategy to obtain target text data;

performing data correction on the keywords of the date type according to the date type data correction strategy to obtain target date type data;

performing data correction on the digital type key words according to the digital type data correction strategy to obtain target digital type data;

and generating target data in the report file to be checked according to the target text data, the target date data and the target digital data.

In an embodiment, the obtaining the configuration file matched with the type of the report file to be accounted includes:

acquiring the date of a report file to be checked;

determining whether the report file to be checked is required to be checked according to the date;

and when the report file to be checked is determined to be checked according to the date, acquiring a configuration file matched with the type of the report file to be checked.

In an embodiment, the determining whether the report file to be checked is required to be checked according to the date includes:

acquiring identification information of the report file to be checked;

determining the accounting conditions of the report file to be accounted according to the identification information;

judging whether the date meets the accounting condition;

and if the date meets the accounting condition, judging that the report file to be accounted needs to be accounted.

In an embodiment, after the performing data processing on the target report file to be checked according to the file processing policy to obtain target data in the target report file to be checked, the method includes:

generating a processing completion mark of the report file to be checked according to the identification information;

and outputting the processing completion prompt information of the report file to be checked according to the processing completion mark.

In an embodiment, the method further comprises:

judging whether the identification information of the report file to be checked is matched with a reference processing completion mark;

and if the identification information is matched with the reference processing completion mark, deleting the reference data obtained after data processing of the reference report file corresponding to the reference processing completion mark.

In an embodiment, the configuration file includes a data validity verification policy, and the performing accounting processing on the target data includes:

verifying whether the target data is valid or not according to the validity verification strategy;

and if the target data is valid, performing accounting processing on the target data.

According to an aspect of the present application, there is also provided a report file processing apparatus, including:

the first acquisition module is used for acquiring the report file to be checked and the type of the report file to be checked;

the second acquisition module is used for acquiring a configuration file matched with the type of the report file to be checked;

the analysis module is used for analyzing the configuration file to obtain a format processing strategy and a file processing strategy in the configuration file;

the format processing module is used for carrying out format processing on the report file to be subjected to accounting according to the format processing strategy to obtain a target report file to be subjected to accounting in a target format;

the data processing module is used for carrying out data processing on the target report file to be subjected to accounting according to the file processing strategy to obtain target data in the target report file to be subjected to accounting;

and the accounting module is used for performing accounting processing on the target data.

According to an aspect of the present application, there is further provided an intelligent device, including a processor and a memory, where the memory stores a computer program, and the processor executes any one of the report file processing methods provided by the embodiments of the present application when calling the computer program in the memory.

According to an aspect of the present application, a storage medium is further provided, where the storage medium is used to store a computer program, and the computer program is loaded by a processor to execute any one of the report file processing methods provided in the embodiments of the present application.

The method and the device for checking the report form can acquire the report form file to be checked and the type of the report form file to be checked; acquiring a configuration file matched with the type of the report file to be checked; analyzing the configuration file to obtain a format processing strategy and a file processing strategy in the configuration file; carrying out format processing on the report file to be subjected to accounting according to the format processing strategy to obtain a target report file to be subjected to accounting in a target format; performing data processing on the target report file to be subjected to accounting according to the file processing strategy to obtain target data in the target report file to be subjected to accounting; and performing accounting processing on the target data. Corresponding configuration files are configured for different types of report files, when the report files to be checked are obtained, the configuration files matched with the report files to be checked are obtained, format processing and data processing are carried out on the report to be checked based on the configuration files, target data capable of being checked are obtained, manual processing of the report files to be checked is not needed, and therefore processing efficiency of the report files is improved.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is a schematic flowchart of a report file processing method according to an embodiment of the present application;

FIG. 2 is a schematic view of a business processing flow corresponding to a configuration file in the report processing method of the present application;

FIG. 3 is another schematic flow chart diagram of a report processing method according to an embodiment of the present application;

FIG. 4 is a schematic diagram of a report file processing apparatus according to an embodiment of the present application;

fig. 5 is a schematic structural diagram of an intelligent device provided in an embodiment of the present application.

Detailed Description

The technical solutions in the embodiments of the present application will be described clearly and completely with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only some embodiments of the present application, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.

The embodiment of the application provides a report file processing method and device, intelligent equipment and a storage medium (namely a computer readable storage medium). The report file processing method may be applied to a report file processing apparatus, the report file processing apparatus may be specifically integrated in an intelligent device, the intelligent device may be in communication connection with a server or a terminal, the server may be an independent physical server, a server cluster or a distributed system formed by a plurality of physical servers, or a cloud server that provides basic cloud computing services such as cloud services, a cloud database, cloud computing, a cloud function, cloud storage, a Network service, cloud communication, middleware services, a domain name service, a security service, a Content Delivery Network (CDN), and a big data and artificial intelligence platform, but is not limited thereto. The server and the terminal may be directly or indirectly connected through wired or wireless communication, and the application is not limited herein. The terminal can be a mobile phone, a computer, household electrical appliance equipment, wearable equipment or the like.

The following are detailed below. It should be noted that the following description of the embodiments is not intended to limit the preferred order of the embodiments.

In this embodiment, a description will be given from the perspective of an intelligent device, please refer to fig. 1, where fig. 1 is a schematic flow diagram of a report file processing method according to an embodiment of the present application. The report file processing method can comprise the following steps:

s101, obtaining a report file to be checked and the type of the report file to be checked.

Wherein the to-be-checked statement file can be a clearing statement between a bank and a bank card transfer clearing institution, the clearing statement refers to an accounting statement of assets and liabilities designed by a clearing group in a company clearing process, the types of the to-be-checked statement can comprise text format txt type, Character Separated Values (CSV) type, XLS/XLSX toolform format and other types,

in this embodiment, the execution main body of the report File processing method may be an intelligent device, and the report to be checked may be manually uploaded to the intelligent device, or may be acquired by the intelligent device through a File Transfer Protocol Server (FTP).

For example, after generating the report file, the bank card transfer clearing mechanism sends the report file to the file transmission server, and the intelligent device obtains the report file to be checked from the file transmission server and obtains the type of the report file to be checked.

S102, obtaining a configuration file matched with the type of the report file to be checked.

It should be noted that, because various types and various service types may exist in the to-be-accounted report forms of different bank card transfer clearing organizations in different scenes, the service processing flow and the data processing policy for each report form file are also different, and thus, it is necessary to perform regular configuration on the service processing flow and the data policy of different types of to-be-accounted report form files to obtain the configuration file. The configuration file can be used for carrying out data processing on the report file to be subjected to accounting so as to obtain target data which can be subjected to accounting in the report file to be subjected to accounting. The configuration file may be configured in advance for different types of report files to be accounted, and stored in the intelligent device after being associated with the types of the report files to be accounted, or stored in advance in a server in communication connection with the intelligent device.

Referring to fig. 2 and fig. 2 are schematic diagrams of business processing flows corresponding to configuration files in the report processing method of the present application, where first, a to-be-accounted report file and a confirmed deduction fund in each channel need to be acquired, then, the to-be-accounted report file is analyzed to obtain target data, after the target data is obtained, an accounting subject is confirmed, a bookkeeping amount corresponding to the bookkeeping subject is confirmed, then, checking is performed on bookkeeping elements, then, data in the report file is processed through accounting, an accounting entry is formed, and finally, machine-based account hanging is performed, that is, after the account hanging record is completed, the original account hanging record is matched with a newly generated account selling flow. The accounting can include splitting principal, expense, income and the like, checking and alarming, matching subjects, amount of money and the like, and the standing book is hung and sold to include the association between the hung and sold standing books.

For example, the intelligent device may match the configuration file according to the type of the report file to be accounted, determine an acquisition path of the configuration file, and acquire the configuration file matched with the type of the report file to be accounted from the intelligent device locally or the server.

S103, analyzing the configuration file to obtain a format processing strategy and a file processing strategy in the configuration file.

The format processing strategy can be used for performing format processing on the report file to be subjected to accounting, and the file processing strategy can be used for performing data processing on the report file to be subjected to accounting.

For example, after the configuration file matched with the report file to be accounted is obtained, the intelligent device removes front and back blank symbols of the configuration file through a preset analysis function, and obtains a character string in the configuration file. The preset analysis function can be preset by self and is used for analyzing the configuration file, and the character string in the configuration file can comprise a format processing strategy and a file processing strategy aiming at the report file to be checked.

And S104, carrying out format processing on the report file to be subjected to format processing according to the format processing strategy to obtain a target report file to be subjected to format processing in a target format.

The format processing may be format conversion, and is used to convert the format of the report file to be checked into the target format, and the format processing modes of different types of report files to be checked may be the same or different. The target format may be the same as or different from the format of the report file to be checked.

For example, the target format may be a text format, and if the report file to be checked is of a text format type, the report file to be checked may be subjected to file interception, that is, invalid characters such as blank characters are removed, so that the target report file to be checked is obtained; if the report file to be audited is of the character segmentation value CSV type, the report file to be audited of the character segmentation value CSV type can be converted into a target report file to be audited of the text format type after being intercepted; if the report file to be checked is of an XLS/XLSX tool table type, the report file to be checked can be converted into a target report file to be checked of a text format type.

For example, the reflection principle of Java can be used inside the intelligent device, and the function of part of Java can be preset by abstracting the service flow. After a format processing strategy or a file processing strategy is acquired through a strategy in a configuration file, an operation thread in a virtual machine is dynamically investigated, the dynamic thread is reflected out, and the dynamic thread is called through the function of static. And the configuration and calling of the report file accounting business process at any time are realized.

S105, performing data processing on the target report file to be subjected to accounting according to the file processing strategy to obtain target data in the target report file to be subjected to accounting;

the file processing strategy can be to perform data processing on various original data in the report file to be subjected to accounting so as to obtain target data capable of being subjected to accounting.

For example, data positioning and data correction are performed on the target report file to be accounted according to a text processing strategy, so that target data capable of being accounted is generated.

And S106, performing accounting processing on the target data.

The accounting processing can comprise clearing processing, namely, clearing and settlement are carried out on the generated accounting statement during inter-bank transaction, wherein the clearing is the preparation of accounting for clearing by each bank, the clearing is the exchange of accounts among banks, the checking and the confirmation and the settlement position confirmation, and the settlement is the final fund transfer according to the settlement position.

For example, after the report file to be subjected to accounting is processed through the format processing policy and the file processing policy in the configuration file to obtain target data that can be accounted, the target data can be subjected to subsequent accounting processing.

Optionally, performing accounting processing on the target data may include: acquiring identification information of a report file to be accounted, and determining an accounting mode of target data according to the identification information; and performing accounting on the target data according to the accounting mode.

The identification information may be information such as a name of a report file to be checked, and the identification information may include a bank name corresponding to the report to be checked.

For example, if the bank name in the identification information is a bank associated with the intelligent device, the target data may be locally checked in the intelligent device, or the target data may be sent to a server connected to the intelligent device for checking; if the bank name in the identification information is not the bank associated with the intelligent device, the target data can be sent to the device matched with the bank corresponding to the identification information, so that the device matched with the bank corresponding to the identification information can perform accounting on the target data.

In the technical scheme provided by the embodiment, a report file to be checked and the type of the report file to be checked are obtained; acquiring a configuration file matched with the type of the report file to be checked; analyzing the configuration file to obtain a format processing strategy and a file processing strategy in the configuration file; performing format processing on the report file to be subjected to format calculation according to the format processing strategy to obtain a target report file to be subjected to format calculation in a target format; performing data processing on the target report file to be subjected to accounting according to the file processing strategy to obtain target data in the target report file to be subjected to accounting; and performing accounting processing on the target data. Corresponding configuration files are configured for different types of report files, when the report files to be checked are obtained, the configuration files matched with the report files to be checked are obtained, format processing and data processing are carried out on the report to be checked based on the configuration files, target data capable of being checked are obtained, manual processing of the report files to be checked is not needed, and therefore processing efficiency of the report files is improved.

Based on the above embodiment, the file processing policy includes a data positioning policy and a data correction policy, and the data processing is performed on the target to-be-checked report file according to the file processing policy to obtain target data in the target to-be-checked report file, and the method may include:

and S1, carrying out data positioning on the target report file to be checked according to the data positioning strategy to obtain the keywords of the target report file to be checked.

The data positioning strategy can be used for positioning the keywords in the target report file to be checked so as to obtain the keywords and the position coordinates of the keywords in the target report file to be checked. The keywords can be obtained by collecting data required to be manually checked in the checking experience of the report file by a user as keywords in advance, and the collected data are arranged in a database corresponding to the data positioning strategy, so that the data positioning strategy is used for positioning the keywords matched with the database in the target report file to be checked. The coordinate position can be the position of the keyword, such as the number of pages, the number of rows and the number of columns, in the target report file to be checked.

For example, the procedure for the data location policy may be as follows:

DirectRule＝"containsIgnoreCase&&&VSS-120&&&number::n###

containsIgnoreCase&&&FUNDS XFER ENTITY:&&&number::4###

containsIgnoreCase&&&TOTAL PURCHASE&&&number::19"。

wherein "directrile:" contisonegreno case & & & VSS-120& & number:: "n # ####" may be used to represent the location keyword "VSS-120", wherein "n # ##" is used to represent the search of the keyword "VSS-120" from the location n. "contacts ignorerecase & & FUNDS XFER ENTITY & & & number::4# ##" may be used to indicate that the keyword "FUNDS XFER ENTITY" is searched for from the 4 th row after the keyword "VSS-120" is searched for.

And S2, performing data correction on the keywords according to the data correction strategy to obtain target data in the target report file to be accounted.

The target data can be data which can be subjected to accounting in the target report file to be accounted, and the data correction can be data screening, data cleaning, data interception and the like on key words in the target report file to be accounted. And the data correction strategy is used for correcting the data of the corresponding key words in the target report file to be accounted, so as to obtain target data capable of being accounted.

For example, the procedure for the data correction strategy may be as follows

ReadRule＝"substring&&&70,,90###

trim&&&###

getPositiveByCR&&&###

deleteCurrencyThousandSep&&&"。

Wherein, "reading rule & &70," triggering & & & & & & & & & & & & & & & & & & & & & "", which may indicate intercepting a row of 70-90 characters in the target report file to be checked, may indicate filtering out invalid characters such as space characters in the target report file to be checked, "getposotivebycr & & & & #", which may indicate acquiring special characters such as a sign in a valid keyword, "deletecurrentrecorncrondsandSep & & & &" ", which may indicate removing an mil in a number, such as removing a comma" "," in "124, 566.99", thereby obtaining 124566.99.

In an embodiment, the data modification of the keyword according to the data modification policy to obtain the target data in the target report file to be accounted may include:

(1) and acquiring data types of the keywords, wherein the data types comprise a text type, a date type and a number type.

The data type of the keyword may include a text type, a date type, and a number type. The text type keywords may include characters in Chinese, English and other languages, the date type keywords may include time point keywords such as year, month, day, hour, minute and second, and may also include duration keywords, and the number type keywords may include number keywords such as money amount.

For example, after locating a keyword in a target report file to be accounted, the intelligent device obtains a data type of the keyword, where the data type of the keyword may be a date type if the keyword is "20 xx year 0x month 2x day x min", the data type of the keyword may be a text type if the keyword is "xxx materials of xxx limited company, and the data type of the keyword is" xx: 124, 566.99 meta ", then the data type for the keyword may be a numeric type.

(2) Determining a data correction strategy according to the data type, wherein the data correction strategy comprises a text data correction strategy, a date data correction strategy and a digital data correction strategy;

it can be understood that different data types correspond to different data correction strategies because different data types are different in processing method required for processing from the report file to be accounted to the target data which can be finally accounted.

(3) Performing data correction on the keywords of the text type according to a text data correction strategy to obtain target text data;

the target text class data is target data which can be subjected to accounting.

For example, if the keyword is text data, the data modification of the keyword may include deleting invalid characters such as a space and a quotation mark in the keyword, or translating the keyword from an original language text into a target language text, such as deleting invalid characters such as a space, a bracket, and a quotation mark in the keyword "xxx company xxx material'), and translating english" material "in the keyword into chinese" material ", to obtain the target text data" xxx company xxx material ".

(4) Performing data correction on the keywords of the date type according to a date type data correction strategy to obtain target date type data;

the target date data is target data that can be subjected to accounting.

For example, if the keyword is date-type data, the data correction of the keyword may include deleting invalid characters such as a space, a comma, and a quotation mark in the keyword, or unifying the format of the date-type keyword into a date in a target format, for example, deleting a space and a comma in the keyword "20 xx year 02.8, 3Pm23 min", changing the format of 02.6 to 02/06/d, and changing the format of 3Pm23min to 15/23, that is, finally obtaining the target date-type data "20 xx year 02/06/15/23".

(5) Performing data correction on the digital type key words according to a digital type data correction strategy to obtain target digital type data;

wherein, the target digital data is target data which can be accounted.

For example, if the keyword is numeric data, the data modification of the keyword may include deleting invalid characters such as spaces, commas, and quotations in the keyword, or acquiring and adding special signs such as signs in the numeric keyword, for example, deleting spaces and commas in the keyword "124, 566.99 yuan", detecting whether special signs such as signs exist before and after the keyword, and if a negative sign is detected, adding the negative sign to the keyword, thereby finally obtaining target numeric data "-124566.99 yuan".

(6) And generating target data in the report file to be checked according to the target text data, the target date data and the target digital data.

For example, the positions of the target text data, the target date data and the target digital data in the target report file to be checked are obtained, and the target text data, the target date data and the target digital data are spliced according to the position sequence to obtain the target data, or the target text data, the target date data and the target digital data are arranged and output as the target data according to a preset rule and an arrangement sequence.

In the embodiment, the intelligent device performs data positioning on the target report file to be checked according to the data positioning strategy to obtain the key words of the target report file to be checked; and performing data correction on the keywords according to the data correction strategy to obtain target data in the target report file to be accounted. And the data correction is carried out on the keywords of different types through different data correction strategies, so that the data in the report file to be checked can be processed more accurately, more accurate and qualified target data can be obtained for checking, and the accuracy of processing the report file is improved.

Based on the above embodiment, obtaining the configuration file matched with the type of the report file to be accounted may include:

s1, acquiring the date of the report file to be checked;

the date of the report file to be checked can be at least one of the generation date, the last checking date and the date to be checked of the report file to be checked. The date can be obtained from the identification information of the report file to be checked.

It should be noted that the report to be checked is not necessarily checked every day, and some reports are settled in the morning and at the end of the month, or may be checked once a week. Therefore, in this embodiment, when the report file to be subjected to accounting is acquired, whether accounting is currently required for the report file to be subjected to accounting can be determined according to the generation date, the last accounting date, the date to be subjected to accounting and the like of the report file to be subjected to accounting.

S2, determining whether the report file to be checked needs to be checked according to the date;

for example, if the current date is matched with the date to be accounted of the report file to be accounted, it is determined that the report file to be accounted needs to be accounted.

Optionally, determining whether the report file to be checked needs to be checked according to the date may include:

(1) acquiring identification information of a report file to be checked;

(2) determining the accounting conditions of the report file to be accounted according to the identification information;

the identification information may include a business name, a date, a bank name, and the like of the report file to be accounted. The accounting conditions corresponding to different businesses of different banks can be different.

For example, xx business of xx bank needs to be accounted every 7 days, then the accounting condition of the report file to be accounted is: and when the current date is the same as the date of the last accounting of the report file to be accounted plus the date to be accounted obtained seven days later, judging that the report file to be accounted needs accounting.

(3) Judging whether the date meets the accounting condition;

(4) and if the date meets the accounting condition, judging that the report file to be accounted needs to be accounted.

For example, whether the date to be accounted obtained by adding the date of the last accounting to the interval date in the accounting condition of the report file to be accounted is the same as the current date is judged, if so, the date of the report file to be accounted is judged to meet the accounting condition, and the report file to be accounted needs to be accounted.

And S3, acquiring a configuration file matched with the type of the report file to be checked when the report file to be checked is determined to be checked according to the date.

For example, when the current date is the same as the date of the last accounting of the report file to be accounted and the date to be accounted obtained after the interval date in the accounting condition is added, it is determined that the report file to be accounted needs accounting, and at this time, a configuration file matched with the type of the report file to be accounted can be obtained, and the report file to be accounted is accounted through the configuration file.

Based on the above embodiment, after performing data processing on the target report file to be checked according to the file processing policy to obtain target data in the target report file to be checked, the report file processing method may further include:

generating a processing completion mark of the report file to be checked according to the identification information; and outputting processing completion prompt information of the report file to be checked according to the processing completion mark.

For example, the processing completion flag may be obtained by splicing the character string "1" and the identification information of the report file to be checked. After detecting the processing completion mark of the report file to be checked, the intelligent device displays the processing completion prompt information of the report file to be checked on a display or outputs the processing completion prompt information of the report file to be checked on an alarm module.

Based on the above embodiment, the method further comprises:

s1, judging whether the identification information of the report file to be checked is matched with the reference processing completion mark;

it can be understood that the report file to be checked may be erroneous, for example, a certain bank uploads an erroneous reference report file, after the bank finds that the bank uploads a correct report file to be checked again, at this time, the reference report file may have already been subjected to data processing to obtain reference data that can be checked, but the check is not performed, at this time, it is determined whether a matching reference processing completion flag is stored in the intelligent device according to the identification information of the report file to be checked, to determine whether a file that is duplicated with the report file to be checked exists in the intelligent device, and if a file that is duplicated with the report file to be checked exists in the intelligent device, the reference data that is originally processed is deleted, and the report file to be checked is subjected to data processing.

For example, the identification information of the reference accounting report file may be "xxxyyyzzz", and the reference processing completion flag corresponding to the reference accounting report file may be "xxxyyyzzz-1", and the identification information of the report file to be accounted is obtained to determine whether the identification information of the report file to be accounted is matched with the reference processing completion flag.

And S2, if the identification information is matched with the reference processing completion mark, deleting the reference data obtained after data processing of the reference report file corresponding to the reference processing completion mark.

For example, the identification information of the reference accounting report file may be "xxxyyyzzz", the reference processing completion flag corresponding to the reference accounting report file may be "xxxyyyzzz-1", and if the identification information of the to-be-accounted report file is "xxxyyyzzz", it may be determined that the identification information of the to-be-accounted report file matches the reference processing completion flag, and at this time, the reference data corresponding to the reference report file may be deleted.

In this embodiment, the intelligent device determines whether the identification information of the report file to be checked is matched with the reference processing completion flag, so that when the report file is repeatedly uploaded or has an error, the reference data obtained by the previous repeated report file processing can be deleted, thereby avoiding repeated checking of the data or checking of the error data, and improving the accuracy of report file processing.

Based on any of the above embodiments, the configuration file may include a data validity verification policy, and the accounting processing on the target data may include:

verifying whether the target data is valid according to the validity verification strategy; and if the target data is valid, performing accounting processing on the target data.

The validity verification policy can be format verification and validity verification of text, date and numbers in the target data.

For example, if the validity verification policy specifies that the date must be a valid report file between 20xx year 01/month 01 and 20xx year 12/month 31, the target data is determined to be invalid if the date in the target data is not between 20xx year 01/month 01 and 20xx year 12/month 31, and the target data is determined to be valid if the date in the target data is between 20xx year 01/month 01 and 20xx year 12/month 31.

If the validity verification policy specifies that the amount of money for a certain item must be positive, the target data is determined to be invalid if the amount of money in the target data is negative, and the target data is determined to be valid if the amount of money in the target data is positive.

In the technical scheme provided by this embodiment, after the intelligent device processes the report file to be checked to obtain the target data, the target data is verified for validity, and then checking is performed, so that the accuracy of processing the report file is improved.

In an embodiment, referring to fig. 3, fig. 3 is another flow chart illustrating a report processing method in the present embodiment. The method includes the steps that firstly, the intelligent device can obtain a report file to be checked and the type of the report file to be checked from the intelligent device local or a server, wherein the report file to be checked can be transmitted to the intelligent device by a bank card clearance mechanism through FTP service or BFTS service, or pushed to the intelligent device by the bank card clearance mechanism through UEEP, or downloaded and uploaded to the intelligent device from the bank card clearance mechanism manually, the type of the report file to be checked can include format types, and the format types of the report file to be checked can include TXT, CSV, XLS/XLS and the like.

After the report file to be checked is obtained, the report file to be checked can be processed, and the processing can be performed through the configuration file of the report file to be checked. For example, a configuration file matched with the type of the report file to be accounted may be locally obtained from the intelligent device, where the configuration file may include a processing policy for the report file to be accounted, and the processing policy may include a format processing policy and a file processing policy, and therefore after the configuration file matched with the report file to be accounted is obtained, the configuration file needs to be analyzed to obtain the format processing policy and the file processing policy in the configuration file.

The report form file to be checked and calculated can be preprocessed through the configuration file, and the preprocessing comprises a file intercepting strategy, a format processing strategy, a rerun cleaning strategy and the like. For example, the file interception policy may be to remove invalid characters such as blank characters in the report file to be checked to obtain the target report file to be checked; the format processing strategy can be that the format processing is carried out on the report file to be checked through the format processing strategy to obtain a target report file to be checked in a target format; the rerun cleaning strategy can detect a processing completion mark of the past report file processing completion stored in the alarm module, judge whether a file which is duplicated with the report file to be accounted exists in the intelligent equipment or not based on the processing completion mark, delete reference data obtained by the original file which is duplicated and perform format processing on the report file to be accounted to obtain a target report file to be accounted if the file which is duplicated with the report file to be accounted exists in the intelligent equipment, thereby avoiding repeated accounting on data or accounting of wrong data, and improving the accuracy of report file processing.

After the target report file to be checked is obtained, data processing can be performed on the target report file to be checked according to a file processing strategy, wherein the file processing strategy can comprise a data positioning strategy and a data correction strategy, the data processing on the target report file to be checked can comprise the steps of performing text data positioning on the target report file to be checked to obtain a keyword, performing text data correction on the keyword to obtain text data, or performing date data correction to obtain date data, or performing digital data correction to obtain digital data, and splicing the date data, the digital data and the date data to obtain target data in the target report file to be checked. And then, carrying out accounting processing on the target data or sending the target data to an agent bank. Corresponding configuration files are configured for different types of report files, when the report files to be checked are obtained, the configuration files matched with the report files to be checked are obtained, format processing and data processing are carried out on the report to be checked based on the configuration files, target data capable of being checked are obtained, manual processing of the report files to be checked is not needed, and therefore processing efficiency of the report files is improved.

In order to better implement the report file processing method provided by the embodiment of the present application, an embodiment of the present application further provides a device based on the report file processing method. The meaning of the nouns is the same as that in the report file processing method, and the specific implementation details can refer to the description in the method embodiment.

Referring to fig. 4, fig. 4 is a schematic structural diagram of a report file processing apparatus according to an embodiment of the present disclosure, wherein the report file processing apparatus 300 may include a first obtaining module 301, a second obtaining module 302, an analyzing module 303, a format processing module 304, a data processing module 305, an accounting module 306, and the like.

The first obtaining module 301 is configured to obtain a report file to be accounted and a type of the report file to be accounted;

the second obtaining module 302 is configured to obtain a configuration file matched with the type of the report file to be checked;

the analysis module 303 is configured to analyze the configuration file to obtain a format processing policy and a file processing policy in the configuration file;

the format processing module 304 is configured to perform format processing on the report file to be subjected to format accounting according to the format processing policy to obtain a target report file to be subjected to format accounting in a target format;

the data processing module 305 is configured to perform data processing on the target report file to be accounted according to the file processing policy, so as to obtain target data in the target report file to be accounted;

and the accounting module 306 is used for performing accounting processing on the target data.

Optionally, the report file processing apparatus 300 may further include:

the data positioning module is used for carrying out data positioning on the target report file to be checked according to the data positioning strategy to obtain a keyword of the target report file to be checked;

and the first data correction module is used for performing data correction on the keywords according to the data correction strategy to obtain target data in the target report file to be accounted.

The first acquisition module is used for acquiring the data types of the keywords, wherein the data types comprise text types, date types and number types;

the first determining module is used for determining a data correction strategy according to the data type, wherein the data correction strategy comprises a text data correction strategy, a date data correction strategy and a digital data correction strategy;

the second data correction module is used for performing data correction on the keywords of the text type according to the text data correction strategy to obtain target text data;

the third data correction module is used for performing data correction on the keywords of the date type according to the date type data correction strategy to obtain target date type data;

the fourth data correction module is used for performing data correction on the digital type key words according to the digital type data correction strategy to obtain target digital type data;

and the first generation module is used for generating target data in the report file to be checked according to the target text data, the target date data and the target digital data.

The second acquisition module is used for acquiring the date of the report file to be checked;

the second determination module is used for determining whether the report file to be checked needs to be checked according to the date;

and the third acquisition module is used for acquiring the configuration file matched with the type of the report file to be checked when the report file to be checked is determined to be checked according to the date.

The fourth acquisition module is used for acquiring the identification information of the report file to be checked;

the third determining module is used for determining the accounting conditions of the report file to be accounted according to the identification information;

the first judgment module is used for judging whether the date meets the accounting condition;

and the judging module is used for judging that the report file to be subjected to accounting needs to be accounted if the date meets the accounting condition.

The second generation module is used for generating a processing completion mark of the report file to be checked according to the identification information;

and the output module is used for outputting the processing completion prompt information of the report file to be accounted according to the processing completion mark.

The second judgment module is used for judging whether the identification information of the report file to be checked is matched with the reference processing completion mark;

and the deleting module is used for deleting the reference data obtained after the data processing is carried out on the reference report file corresponding to the reference processing completion mark if the identification information is matched with the reference processing completion mark.

The verification module is used for verifying whether the target data is valid according to the validity verification strategy;

and the accounting module is used for performing accounting processing on the target data if the target data is valid.

An embodiment of the present application further provides an intelligent device, where the intelligent device may be a terminal such as a mobile phone, and as shown in fig. 5, a schematic structural diagram of the intelligent device according to the embodiment of the present application is shown, specifically:

the smart device may include components such as a processor 401 of one or more processing cores, memory 402 of one or more computer-readable storage media, a power supply 403, and an input unit 404. Those skilled in the art will appreciate that the smart device architecture shown in FIG. 5 does not constitute a limitation of smart devices and may include more or fewer components than shown, or some components in combination, or a different arrangement of components. Wherein:

the processor 401 is a control center of the smart device, connects various parts of the entire smart device using various interfaces and lines, and performs various functions of the smart device and processes data by running or executing software programs and/or modules stored in the memory 402 and calling data stored in the memory 402, thereby performing overall monitoring of the smart device. Optionally, processor 401 may include one or more processing cores; preferably, the processor 401 may integrate an application processor, which mainly handles operating systems, user interfaces, application programs, etc., and a modem processor, which mainly handles wireless communications. It will be appreciated that the modem processor described above may not be integrated into the processor 401.

The memory 402 may be used to store software programs and modules, and the processor 401 executes various functional applications and data processing by operating the software programs and modules stored in the memory 402. The memory 402 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data created according to use of the smart device, and the like. Further, the memory 402 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid state storage device. Accordingly, the memory 402 may also include a memory controller to provide the processor 401 access to the memory 402.

The smart device further includes a power supply 403 for supplying power to the various components, and preferably, the power supply 403 may be logically connected to the processor 401 through a power management system, so as to implement functions of managing charging, discharging, and power consumption through the power management system. The power supply 403 may also include any component of one or more dc or ac power sources, recharging systems, power failure detection circuitry, power converters or inverters, power status indicators, and the like.

The smart device may also include an input unit 404, the input unit 404 being operable to receive input numeric or character information and to generate keyboard, mouse, joystick, optical or trackball signal inputs related to user settings and function control.

Although not shown, the smart device may further include a display unit and the like, which will not be described herein. Specifically, in this embodiment, the processor 401 in the smart device loads the executable file corresponding to the process of one or more application programs into the memory 402 according to the following instructions, and the processor 401 runs the application program stored in the memory 402, thereby implementing various functions as follows:

acquiring a report file to be checked and the type of the report file to be checked; acquiring a configuration file matched with the type of the report file to be checked; analyzing the configuration file to obtain a format processing strategy and a file processing strategy in the configuration file; carrying out format processing on the report file to be subjected to format accounting according to the format processing strategy to obtain a target report file to be subjected to format accounting in a target format; performing data processing on the target report file to be subjected to accounting according to the file processing strategy to obtain target data in the target report file to be subjected to accounting; and performing accounting processing on the target data. Corresponding configuration files are configured for different types of report files, when the report files to be checked are obtained, the configuration files matched with the report files to be checked are obtained, format processing and data processing are carried out on the report to be checked based on the configuration files, target data capable of being checked are obtained, manual processing of the report files to be checked is not needed, and therefore processing efficiency of the report files is improved.

In the above embodiments, the descriptions of the embodiments have respective emphasis, and parts that are not described in detail in a certain embodiment may refer to the above detailed description of the report file processing method, and are not described herein again.

According to an aspect of the application, a computer program product or computer program is provided, comprising computer instructions, the computer instructions being stored in a computer readable storage medium. The processor of the smart device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the smart device performs the method provided in the various alternative implementations in the above embodiments.

It will be understood by those skilled in the art that all or part of the steps in the methods of the above embodiments may be performed by computer instructions or by computer instructions controlling associated hardware, and the computer instructions may be stored in a storage medium and loaded and executed by a processor, and the storage medium is a computer-readable storage medium. To this end, the present application provides a storage medium, in which a computer program is stored, where the computer program may include computer instructions, and the computer program can be loaded by a processor to execute any one of the report file processing methods provided in the present application.

The above operations can be implemented in the foregoing embodiments, and are not described in detail herein.

Wherein the storage medium may include: read Only Memory (ROM), Random Access Memory (RAM), magnetic or optical disks, and the like.

As the computer instructions stored in the storage medium can execute any report file processing method provided in the embodiments of the present application, beneficial effects that can be achieved by any report file processing method provided in the embodiments of the present application can be achieved, which are detailed in the foregoing embodiments and will not be described herein again.

The method, the device, the intelligent device and the storage medium for processing the report files provided by the embodiment of the application are introduced in detail, a specific example is applied in the description to explain the principle and the implementation mode of the application, and the description of the embodiment is only used for helping to understand the method and the core idea of the application; meanwhile, for those skilled in the art, according to the idea of the present application, the specific implementation manner and the application scope may be changed, and in summary, the content of the present specification should not be construed as a limitation to the present application.

Claims

1. A report file processing method is characterized by comprising the following steps:

and performing accounting processing on the target data.

2. The report file processing method according to claim 1, wherein the file processing policy includes a data positioning policy and a data modification policy, and the data processing of the target report file to be accounted according to the file processing policy to obtain the target data in the target report file to be accounted comprises:

3. A report file processing method according to claim 2, wherein the data correction of the keyword according to the data correction policy to obtain the target data in the target report file to be accounted comprises:

carrying out data correction on the keywords of the digital type according to the digital data correction strategy to obtain target digital data;

4. The report file processing method according to claim 1, wherein the obtaining of the configuration file matched with the type of the report file to be accounted comprises:

acquiring the date of a report file to be checked;

5. The report file processing method according to claim 4, wherein said determining whether the report file to be audited needs to be audited according to the date comprises:

acquiring the identification information of the report file to be checked;

judging whether the date meets the accounting condition or not;

6. The report file processing method according to claim 5, wherein after performing data processing on the target report file to be checked according to the file processing policy to obtain target data in the target report file to be checked, the method comprises:

7. A report file processing method according to claim 6, said method further comprising:

8. A report file processing method according to any of claims 1-7, wherein said configuration file includes a data validity verification policy, and said performing accounting processing on said target data includes:

9. A report file processing apparatus, comprising:

the first acquisition module is used for acquiring the report file to be accounted and the type of the report file to be accounted;

the second acquisition module is used for acquiring a configuration file matched with the type of the report file to be accounted;

10. An intelligent device, characterized by comprising a processor and a memory, wherein the memory stores a computer program, and the processor executes the report file processing method according to any claim from 1 to 8 when calling the computer program in the memory.

11. A storage medium for storing a computer program to be loaded by a processor to execute the report file processing method according to any one of claims 1 to 8.