A file processing method, device and computer equipment

Abstract

The present invention discloses a file processing method, device and computer equipment, which relates to the field of financial technology and is used to provide a new processing method for fund files to improve the accuracy of processing fund files. The method includes: determining a fund file to be converted; reading transaction record data in the fund file, wherein the transaction record data includes M sub-transaction data spliced ​​in a predetermined order, each of the M sub-transaction data includes field data of N fields, and the field name of each field in the N fields is different; according to the typesetting format of the EXCEL file, the N fields of each sub-transaction data are divided into N columns and the column identifier of the column is set according to the field name of the field corresponding to each column for EXCEL typesetting, so as to obtain a first typesetting result for the transaction record data; according to the first typesetting result, an EXCEL file corresponding to the fund file is generated.

Description

Technical Field

[0001] The present invention relates to the technical field of financial technology (Fintech), and in particular to a file processing method, device and computer equipment. Background Art

[0002] In the existing technology, with the continuous development of science and technology, more and more technologies are applied in the financial field, and the traditional financial industry is gradually transforming to financial technology. Specifically, when recording data, the current fund files must meet the open fund business data exchange protocol of the central data exchange platform, that is, each transaction data in the data file of the fund file is a fixed-length message, including multiple field parameters.

[0003] However, if you need to view or modify the data file, relying solely on manual positioning to view the value corresponding to a field or to modify the value of the field is not only inefficient but also prone to errors.

[0004] It can be seen that the existing technology has problems of low processing efficiency and poor accuracy when processing fund documents. Summary of the invention

[0005] The embodiments of the present invention provide a file processing method, device and computer equipment, which are used to provide a new processing method for fund files, so as to improve the accuracy of processing fund files and improve the efficiency of file processing.

[0006] In a first aspect, a file processing method is provided, the method comprising:

[0007] Identify the fund documents to be converted;

[0008] Reading the transaction record data in the fund file, wherein the transaction record data includes M pieces of sub-transaction data spliced ​​in a predetermined order, each piece of the M pieces of sub-transaction data includes field data of N fields, each field name of the N fields is different, and M and N are both integers greater than or equal to 1;

[0009] According to the typesetting format of the EXCEL file, the N fields of each sub-transaction data are divided into N columns, and the column identifier of each column is set according to the field name of the field corresponding to the column to perform EXCEL typesetting, so as to obtain a first typesetting result for the transaction record data;

[0010] According to the first typesetting result, an EXCEL file corresponding to the fund file is generated.

[0011] In the above technical scheme, the transaction record data composed of M rows and N fields in the fund file is divided into N columns according to the N fields of each sub-transaction data and the column identifier of the column is set according to the field name of the field corresponding to each column for EXCEL typeset to realize the division of different fields in each sub-transaction record data, so that users can clearly know the field content in each sub-transaction record data, thereby improving the accuracy of processing fund files.

[0012] In an optional implementation manner, the method further includes:

[0013] Translating the field names of the N fields in a second language different from the first language to obtain N field identifiers expressed in the second language, wherein the field names of the N fields in the first typesetting result are expressed in the first language;

[0014] According to the manner of correspondingly setting the field identifier and the column identifier for representing the same field name, respectively setting the N field identifiers represented in the second language to correspond to the N column identifiers in the first typesetting result to form a column for typesetting, so as to obtain a second typesetting result for the N fields;

[0015] Then, according to the first typesetting result, an EXCEL file corresponding to the fund file is generated, including:

[0016] An EXCEL file corresponding to the fund file is generated according to the first typesetting result and the second typesetting result.

[0017] In the above technical solution, the field names of N fields are translated into a second language different from the first language, and the N field identifiers represented by the second language are respectively set to one column corresponding to the N column identifiers in the first typesetting result for typesetting. In this way, users who are accustomed to reading in different languages ​​can directly obtain the meaning of the field names, reducing user operations and thus improving user experience.

[0018] In an optional implementation manner, obtaining a second layout result for the N sub-segments includes:

[0019] Determine a bit number identifier corresponding to each field according to the number of bits occupied by each field in the N fields;

[0020] The digit identifier of each field is arranged correspondingly with the field identifier or column identifier corresponding to the field to obtain the field digit arrangement result;

[0021] The second layout result is updated according to the field digit layout result.

[0022] In the above technical solution, the digit identifier corresponding to each field is determined, and then the digit identifier of each field is laid out correspondingly with the field identifier or column identifier corresponding to the field to obtain the field digit layout result. That is to say, the user can see an EXCEL file showing the digit identifiers of N fields. When the user needs to check whether the field digits comply with the protocol requirements, he can directly determine it based on the digit identifiers of the N fields displayed, thereby improving the processing efficiency of fund files.

[0023] In an optional implementation manner, the method further includes:

[0024] Determining fixed file description data in the fund file, wherein the fixed file description data includes data of the same type included in all fund files represented by a financial data protocol adopted by the fund file;

[0025] According to the typesetting format of the fixed file description data in the fund file, performing EXCEL typesetting on the fixed file description data to obtain a third typesetting result for the fixed file description data;

[0026] Then, according to the first typesetting result, an EXCEL file corresponding to the fund file is generated, including:

[0027] An EXCEL file corresponding to the fund file is generated according to the first typesetting result and the third typesetting result.

[0028] In the above technical solution, the fixed file description data in the fund file is typeset, and then combined with the first typesetting result to generate an EXCEL file corresponding to the fund file. In this way, the generated EXCEL file corresponds to the fund file, and users can accurately obtain all the data content of the fund file through the EXCEL file, thereby improving the user experience.

[0029] In an optional implementation manner, after generating the EXCEL file corresponding to the fund file, the method further includes:

[0030] Receiving an editing operation on the EXCEL file;

[0031] According to the editing operation, determining a response result of the edited data in the EXCEL file to the editing operation;

[0032] Performing a validity check on the response result according to the data attributes of the edited data; wherein the data attributes include the number of bits occupied by the data and / or the data retention level;

[0033] If the check fails, the response to the editing operation is canceled.

[0034] In the above technical solution, an editing operation (such as a modification operation) for an EXCEL file can be received, and then according to the editing operation, the response result of the edited data in the EXCEL file to the editing operation can be determined, so that the legitimacy of the response result can be checked according to the data attributes of the edited data, that is, when the user edits the EXCEL file, the user edited data can be checked to improve the accuracy of the file processing. When the check fails, the response to the editing operation can be revoked, that is, the illegal editing of the user can be blocked during the editing operation to determine the legitimacy of the edited data.

[0035] In an optional implementation manner, the method further includes:

[0036] Determine an EXCEL file to be converted, wherein the EXCEL file to be converted is an EXCEL file converted according to the fund file;

[0037] Performing typesetting conversion on the EXCEL file to be converted according to the typesetting format of the fund file to obtain a fourth typesetting result;

[0038] According to the fourth typesetting result, a fund file corresponding to the EXCEL file to be converted is generated.

[0039] In the above technical solution, the EXCEL file converted from the fund file can also be processed, that is, the EXCEL file to be converted is typeset according to the typesetting format of the fund file, and then a fund file corresponding to the EXCEL file to be converted is generated. In other words, the converted EXCEL file can be converted to a fund file, which is convenient for the user to process the transaction record data of the fund file in the EXCEL file, and then the processed EXCEL file is converted to a fund file to improve the user experience.

[0040] In an optional implementation manner, the method further includes:

[0041] In the process of converting the EXCEL file to be converted into the corresponding fund file, the key data is subjected to a legality check; wherein the key data includes at least one of the field length, the number of parameters, and the number of data rows;

[0042] When the key data passes the legality check, the conversion from the EXCEL file to be converted to the corresponding fund file will continue.

[0043] In the above technical solution, the key data can also be checked for legitimacy during the process of converting the EXCEL file to be converted into the corresponding fund file, thereby further ensuring the legitimacy of the fund file converted from the EXCEL file and improving the accuracy of file processing.

[0044] In a second aspect, the present application provides a file processing device, the device comprising:

[0045] A first determination module, used to determine the fund file to be converted;

[0046] a reading module, configured to read the transaction record data in the fund file, wherein the transaction record data includes M pieces of sub-transaction data spliced ​​in a predetermined order, each piece of the M pieces of sub-transaction data includes field data of N fields, each field name of the N fields is different, and M and N are both integers greater than or equal to 1;

[0047] A first typesetting module, for dividing the N fields of each sub-transaction data into N columns according to the typesetting format of the EXCEL file and setting the column identifier of each column according to the field name of the field corresponding to each column for EXCEL typesetting, so as to obtain a first typesetting result for the transaction record data;

[0048] The first processing module is used to generate an EXCEL file corresponding to the fund file according to the first typesetting result.

[0049] In an optional implementation manner, the device further includes a second determining module, configured to:

[0050] Translating the field names of the N fields in a second language different from the first language to obtain N field identifiers expressed in the second language, wherein the field names of the N fields in the first typesetting result are expressed in the first language;

[0051] The device further includes a second typesetting module, which is used to: according to the manner in which the field identifiers and column identifiers used to represent the same field name are correspondingly set, respectively set the N field identifiers represented in the second language to correspond to the N column identifiers in the first typesetting result to form a column for typesetting, so as to obtain a second typesetting result for the N fields;

[0052] The device also includes a second processing module, which is used to generate an EXCEL file corresponding to the fund file according to the first typesetting result and the second typesetting result.

[0053] In an optional implementation manner, the second determining module is further configured to:

[0054] Determine a bit number identifier corresponding to each field according to the number of bits occupied by each field in the N fields;

[0055] The second typesetting module is used to typeset the digit identifier of each field in correspondence with the field identifier or column identifier corresponding to the field, so as to obtain a field digit typesetting result;

[0056] The second layout result is updated according to the field digit layout result.

[0057] In an optional implementation manner, the device further includes a third determining module, configured to:

[0058] Determining fixed file description data in the fund file, wherein the fixed file description data includes data of the same type included in all fund files represented by a financial data protocol adopted by the fund file;

[0059] The device further comprises a third typesetting module, which is used to: perform EXCEL typesetting on the fixed file description data according to the typesetting format of the fixed file description data in the fund file, so as to obtain a third typesetting result for the fixed file description data;

[0060] The device also includes a third processing module, which is used to generate an EXCEL file corresponding to the fund file according to the first typesetting result and the third typesetting result.

[0061] In an optional implementation manner, the device further comprises a verification module, which is used, after generating an EXCEL file corresponding to the fund file, to:

[0062] Receiving an editing operation on the EXCEL file;

[0063] According to the editing operation, determining a response result of the edited data in the EXCEL file to the editing operation;

[0064] Performing a validity check on the response result according to the data attributes of the edited data; wherein the data attributes include the number of bits occupied by the data and / or the data retention level;

[0065] If the check fails, the response to the editing operation is canceled.

[0066] In an optional implementation manner, the device further includes a conversion module, configured to:

[0067] Determine an EXCEL file to be converted, wherein the EXCEL file to be converted is an EXCEL file converted according to the fund file;

[0068] Performing typesetting conversion on the EXCEL file to be converted according to the typesetting format of the fund file to obtain a fourth typesetting result;

[0069] According to the fourth typesetting result, a fund file corresponding to the EXCEL file to be converted is generated.

[0070] In an optional implementation manner, the verification module is further used to:

[0071] In the process of converting the EXCEL file to be converted into the corresponding fund file, the key data is subjected to a legality check; wherein the key data includes at least one of the field length, the number of parameters, and the number of data rows;

[0072] The conversion module is further used for:

[0073] When the key data passes the legality check, the conversion from the EXCEL file to be converted to the corresponding fund file will continue.

[0074] The beneficial effects of the above-mentioned second aspect and each embodiment of the second aspect can refer to the beneficial effects of the above-mentioned first aspect and each embodiment of the first aspect, and will not be repeated here.

[0075] According to a third aspect, a computer device is provided, the computer device comprising:

[0076] A memory for storing program instructions;

[0077] The processor is used to call the program instructions stored in the memory and execute the steps included in any one of the methods in the first aspect according to the obtained program instructions.

[0078] According to a fourth aspect, a storage medium is provided, wherein the storage medium stores computer-executable instructions, wherein the computer-executable instructions are used to enable a computer to execute the steps included in any one of the methods in the first aspect.

[0079] These and other aspects of the present application will become more clearly understood in the description of the following embodiments. BRIEF DESCRIPTION OF THE DRAWINGS

[0080] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying any creative work.

[0081] Figure 1 A schematic diagram of the content of a data file in a fund file in an embodiment of the present application;

[0082] Figure 2 A schematic diagram of the data content in the data file in the fund file in the embodiment of the present application;

[0083] Figure 3 This is a schematic diagram of the interface of the modifier in the embodiment of the present application;

[0084] Figure 4 This is a schematic diagram of an interface for selecting to open a ZIP file in an embodiment of the present application;

[0085] Figure 5 This is a schematic diagram of an EXCLE file in an embodiment of the present application;

[0086] Figure 6 This is a flow chart of a method for converting an EXCLE file into a fund file in an embodiment of the present application;

[0087] Figure 7 A flowchart of a file processing method in an embodiment of the present application;

[0088] Figure 8 This is a schematic diagram of the arrangement of data contents of a data file in a fund file in an embodiment of the present application;

[0089] Fig. 9 Another schematic diagram of the arrangement of data contents of a data file in a fund file in an embodiment of the present application;

[0090] Fig.10 is a structural block diagram of a file processing device in an embodiment of the present application;

[0091] Fig.11 A schematic diagram of the structure of a computer device in an embodiment of the present application;

[0092] Fig.12 Schematic diagram of another structure of the computer device in the embodiment of the present application. DETAILED DESCRIPTION

[0093] In order to make the purpose, technical scheme and advantages of the present application clearer, the technical scheme in the embodiment of the present application will be clearly and completely described below in conjunction with the drawings in the embodiment of the present application. Obviously, the described embodiment is only a part of the embodiment of the present application, rather than all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without making creative work are within the scope of protection of the present application. In the absence of conflict, the embodiments in the present application and the features in the embodiments can be combined with each other arbitrarily. In addition, although the logical order is shown in the flow chart, in some cases, the steps shown or described can be performed in an order different from that here.

[0094] In order to facilitate understanding of the technical solution provided by the embodiments of the present application, some of the terms used in the embodiments of the present application are explained here:

[0095] 1. Central Data Exchange Platform Open-End Fund Business Data Exchange Agreement: This agreement specifies the data format, data definition and data content used when exchanging data between institutions in asset management product (including but not limited to public funds, non-public funds, collective asset management plans, etc., referred to as "funds" in this text) related businesses.

[0096] 2. Fund files: Files that comply with the data exchange protocol specifications for open-end fund business on the central data exchange platform are referred to as fund files, including data index files and data files. The naming rule for data index files is "OFI / OFJ / OFS / OFK / OFC" + "_" + file creator code + "_" + file recipient code + "_" + date (YYYYMMDD) + ".TXT", and its content is a list of data files. The naming rule for data files is: "OFD" + "_" + file creator code + "_" + file recipient code + "_" + date (YYYYMMDD) + "_" + two-digit file type code + ".TXT" and the content is the data exchanged between institutions.

[0097] 3. Graphical User Interface (GUI): refers to a computer operation user interface that uses graphics to display. Graphical User Interface is an interface display format for communication between people and computers, allowing users to use input devices such as a mouse to manipulate icons or menu options on the screen to select commands, call files, start programs, or perform other daily tasks.

[0098] 4. Tkinter interface: Interface to Python's standard Tk GUI toolkit.

[0099] In addition, in the embodiments of the present application, "multiple" can mean at least two, for example, two, three or more, and the embodiments of the present application are not limited. The term "and / or" herein is merely a description of the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can mean: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " herein, unless otherwise specified, generally indicates that the associated objects before and after are in an "or" relationship.

[0100] In order to better understand the technical solution provided by the embodiments of the present application, the technical background of the embodiments of the present application is first introduced below.

[0101] In the prior art, see Figure 1 , Figure 1 The data file in the existing transaction fund file is a schematic diagram. The data file in the fund file consists of 1 line of file start identifier, namely OFDCFDAT, and 8 lines of fixed fields. The fixed fields include the version number of the central data exchange platform open-end fund business data exchange protocol, the information creator code, the information recipient code, the data date, the file transfer sequence mark, the file type, the sender, and the recipient, namely Figure 1 21, 03, 918, 20170106, 999, 04, 03, 918, the number of fields in one row is n, that is Figure 1 116 in the nth row, the field names are Figure 1 App Sheet SerialNo, Transaction Cfm Date, Currency Type, Confirmed Vol, Confirmed Amount, FundCode, Large Rede mption Flag( Figure 1 Only 8 field names are shown), and the number of rows (m) of 1 row of data content is 8, and m rows of data content is 8 rows of data content ( Figure 1 Only part of the data content is shown) and one line of file end marker, namely OFDCFEND.

[0102] See also Figure 2 , Figure 2 for Figure 1 The data content of the data file in the trading fund file shown in the figure shows that the first data content and the second data content both include multiple characters. If only manual viewing or file processing is relied upon, errors are likely to occur.

[0103] In view of this, the inventor of the present application has developed a modifier capable of converting fund files into EXCEL files, which can be applied to computer devices. The modifier uses the Python development language and the Tkinter interface, and is packaged into an exe executable file using Pyinstaller. In this way, users do not need to install Python and other development integrated environments, which greatly facilitates user use.

[0104] See also Figure 3 , is the GUI interface of the modifier in this application, which includes a tool log output area. Specifically, the tool log output area includes the time when the user uses the modifier and the specific content of the user's operation, which allows the user to quickly view the processing time and specific processing process of the fund file, so that the user can clearly know the processing process of the work content of the fund file. Further, the tool log output area also includes a file selection area and a function area, such as Figure 3Generate files, open xls files, open zip files, and switch file processing functions as shown in .

[0105] In the embodiment of the present application, the open xls file function and the open zip file function displayed in the aforementioned modifier GUI interface can directly obtain the corresponding files when the user uses these two functions. That is, the aforementioned two functions allow the user to open the already generated EXCLE file or fund file without double-clicking it in the file manager, but to open the corresponding file by clicking the functional button provided by the modifier, thereby reducing the user's operation steps and improving the processing efficiency of the fund files.

[0106] In the specific implementation process, when the user chooses to open the ZIP file function, please refer to Figure 4 In the GUI interface of the editor, multiple data files and data index files in the opened fund file can be displayed, and then the user can choose to open one of the data files, for example, Figure 4 As shown in the figure, you can open the OFD_03_918_20170106_04.TXT data file, and you can see the content of the data file. You can also see that the data content is displayed in a spliced ​​manner between fields, which makes it difficult for users to read and modify. After the user generates a file for the OFD_03_918_20170106_04.TXT data file that selects to open the fund file, see Figure 5 , Figure 5 This is the GUI interface diagram for converting the data file FD_03_918_20170106_04.TXT in the fund file into an EXCLE file.

[0107] In the embodiment of the present application, the switching processing file function displayed in the aforementioned modifier GUI interface, when the user uses this function, the user can easily and quickly switch between the two functions of "converting fund file to excel file" and "converting excel file to fund file", which reduces the user's operation steps, saves time, and improves the processing efficiency of fund files.

[0108] Further, in the specific implementation process, please refer to the process of using the modifier to process the fund file. Figure 6 , the specific steps are as follows:

[0109] Step 601: Obtain a selection operation for a fund file to be processed.

[0110] Step 602: According to the selection operation, convert the fund file to be processed into an EXLCE file.

[0111] Step 603: Obtain the processing operation of opening the xls file, and display the generated EX LCE file according to the processing operation.

[0112] Step 604: Obtain a modification or viewing operation for the displayed EXLCE file, and process the EXLCE file according to the modification or viewing operation to obtain a target EXLCE file.

[0113] Step 605: Obtain a conversion operation for the target EXLCE file, and convert the target EXLCE file into a target fund file.

[0114] Step 606: Obtain a check operation for the target fund file to check the generated fund file.

[0115] As mentioned above, users can use the modifier to convert the fund file into an EXLCE file, and then use the search, hide and other functions provided by EXLCE to quickly locate a field in the data file of the fund file, and then check or modify the field, and hide unnecessary fields. Furthermore, after modifying the value of a field in the EXLCE file, the switch processing file function of the modifier can be used again to convert the EXLCE file into a fund file.

[0116] The following is a detailed description of the implementation principle of this solution for converting the pending fund files into EXLCE files. Figure 7 , Figure 7 Flow chart of the file processing method in an embodiment of the present application.

[0117] Step 701: Determine the fund file to be converted.

[0118] Step 702: Read the transaction record data in the fund file, wherein the transaction record data includes M sub-transaction data spliced ​​in a predetermined order, each of the M sub-transaction data includes field data of N fields, the field name of each field in the N fields is different, and M and N are both integers greater than or equal to 1.

[0119] In an embodiment of the present application, the method proposed in the present application can be executed by the aforementioned modifier. Specifically, the user can click on the aforementioned fund file to determine the fund file to be converted.

[0120] When the modifier obtains an operation performed on a data file in a fund file, the modifier can obtain the data content in the data file. In the embodiment of the present application, for ease of description, the data content in the data file is referred to as transaction record data, wherein the transaction record data includes M sub-transaction data spliced ​​together in a predetermined order, each of the M sub-transaction data includes field data of N fields, and the field name of each of the N fields is different.

[0121] For example, Figure 8 As shown, the transaction record data includes 3 sub-transaction record data, namely the first sub-transaction record data, the second sub-transaction record data and the third sub-transaction record data, and the first sub-transaction record data, the second sub-transaction record data and the third sub-transaction record data respectively include field 1, field 2, field 3, field 4, field 5, field 6, field 7 and field 8. Please continue to refer to Figure 8 , the first sub-transaction record data is formed by splicing the data corresponding to field 1, field 2, field 3, field 4, field 5, field 6, field 7 and field 8 respectively. Further, the transaction record data can also be formed by splicing the first sub-transaction record data, the second sub-transaction record data and the third sub-transaction record data. In addition, Figure 8 The first sub-transaction record data, the first sub-transaction record data, the second sub-transaction record data and the third sub-transaction can be understood as the attached Figure 1 The data content in .

[0122] In actual applications, a predetermined identifier is included between each sub-transaction record data, wherein the predetermined identifier is used to separate the data between the sub-transaction record data. Specifically, the predetermined identifier can be a space, or it can be *, or of course, it can also be #, which is not limited in the embodiments of the present application.

[0123] For example, Fig. 9 As shown, the reservation mark is a space, and the transaction record data includes 3 sub-transaction record data, namely the first sub-transaction record data, the second sub-transaction record data and the third sub-transaction record data, and the first sub-transaction record data, the second sub-transaction record data and the third sub-transaction record data respectively include field 1, field 2, field 3, field 4 and field 5. Please continue to refer to Fig. 9, the first sub-transaction record data can also be formed by splicing the data corresponding to field 1, field 2, field 3, field 4, and field 5, respectively, and the second sub-transaction record data and the third sub-transaction record data are also formed by splicing the data corresponding to field 1, field 2, field 3, field 4, and field 5, respectively. There is a space between the first sub-transaction record data and the second sub-transaction record data, and there is a space between the second sub-transaction record data and the third sub-transaction record data. In this way, the first sub-transaction record data, the second sub-transaction record data, and the third sub-transaction record data can be clearly distinguished.

[0124] Step 703: Divide the N fields of each sub-transaction data into N columns according to the formatting format of the EXCEL file, and set the column identifier of each column according to the field name of the field corresponding to each column to perform EXCEL formatting, so as to obtain a first formatting result for the transaction record data;

[0125] In the embodiment of the present application, after reading the transaction record data in the fund file, the N fields of each sub-transaction data can be divided into N columns according to the typesetting format of the EXCEL file, and the column identifier of each column can be set according to the field name of the field corresponding to each column for EXCEL typesetting. In other words, the transaction record data is typeset in such a way that each field occupies one column and each sub-transaction data occupies one row, with each sub-transaction data having N fields originally spliced ​​and arranged.

[0126] In the specific implementation process, Figure 4 Taking the transaction record data shown as an example, the transaction record data is divided into rows and columns to layout the transaction record data according to the layout format of the EXCEL file. Specifically, each sub-transaction record data can be divided into columns according to the character length limit of each field in the N fields, so as to obtain the layout result. In other words, the display of the transaction record data is clearer through the division of rows and columns, so that the user can accurately know the content of each field, thereby enhancing the accuracy of the processing of the fund file.

[0127] Step 704: Generate an EXCEL file corresponding to the fund file according to the first typesetting result.

[0128] In an embodiment of the present application, an EXCEL file corresponding to the fund file can be generated by dividing the N fields of each sub-transaction data into N columns and setting the column identifier of each column according to the field name of the field corresponding to the column to obtain a first typesetting result through EXCEL typesetting.

[0129] That is to say, the field names included in the sub-transaction record data and the N columns of formatted sub-transaction record data are arranged correspondingly, and then the transaction record data is processed in the aforementioned manner, so as to generate an EXCEL file corresponding to the fund file.

[0130] For details, please see Figure 5 , the 13th line in the EXCEL file displays the field name, and lines 14-18 display the transaction record data of the fund file. With this display method, users can clearly determine the content of the field, so that they can accurately view and / or modify the field content, which improves the processing efficiency of the fund file.

[0131] Specifically, in a possible implementation, a target configuration file corresponding to the target fund file may also be determined, and the field name of each field may be determined from the target configuration file according to the field names of the N fields, and then the field names of the N fields may be translated into a second language different from the first language to obtain N field identifiers expressed in the second language, wherein the field names of the N fields in the first typesetting result are expressed in the first language; for example, the first language of the field name is English, and the second language may be Chinese, German, French, Portuguese or the like, that is, the N field identifiers expressed in the second language may be Chinese field identifiers or French field identifiers.

[0132] Then, according to the way that the field identifier and the column identifier used to represent the same field name are set correspondingly, the N field identifiers represented in the second language are respectively set correspondingly to the N column identifiers in the first typesetting result as one column for typesetting, thereby obtaining a second typesetting result for the N fields. Furthermore, an EXCEL file corresponding to the fund file can be generated according to the first typesetting result and the second typesetting result.

[0133] For example, see Figure 5 As shown, the field identifiers in the second language are converted into Chinese. In this way, users who are accustomed to using different languages ​​can clearly know the field names, thereby improving the user experience.

[0134] Specifically, in a possible implementation, the bit number identifier corresponding to each field can be determined based on the number of bits occupied by each field in the N fields, and then the bit number identifier of each field can be arranged in correspondence with the field identifier or column identifier corresponding to the field to obtain the field bit number layout result, and the second layout result can be updated based on the field bit number layout result.

[0135] Please continue to refer to Figure 5, where the field identifier of each field and the number of data bits of each field are in one column. This allows users to make targeted modifications and minimize the problem of inconsistency between the number of modified bits and protocol requirements.

[0136] Specifically, in a possible implementation, the fixed file description data in the fund file is determined, wherein the fixed file description data includes data of the same type included in all fund files represented by the financial data protocol adopted by the fund file, and specifically, the fixed file description data may include a file identifier, a fixed record, a field name, and a file end identifier. Then, according to the typesetting format of the fixed file description data in the fund file, the fixed file description data may be typeset in EXCEL to obtain a third typesetting result for the fixed file description data, so that an EXCEL file corresponding to the fund file may be generated according to the first typesetting result and the third typesetting result. Of course, in the specific implementation process, an EXCEL file corresponding to the fund file may also be generated according to the first typesetting result, the second typesetting result, and the third typesetting result.

[0137] In this way, the generated EXCEL file corresponds to the fund file. Users can accurately view all the data content of the fund file through the EXCEL file, thereby improving the user experience.

[0138] Specifically, in one possible implementation, when a user wishes to modify or view a fund file, the user can generate an EXCEL file corresponding to the fund file and then perform data modification operations in the EXCEL file. The computer device can receive the editing operation (such as modification) on the EXCEL file and then determine, based on the editing operation, the response result of the edited data in the EXCEL file to the editing operation.

[0139] Furthermore, after determining the response result of the edited data in the EXCEL file to the editing operation, the legitimacy of the response result can be checked based on the data attributes of the edited data; wherein the data attributes include the number of bits occupied by the data and / or the data retention level, and when the check fails, the response to the editing operation is revoked.

[0140] In the specific implementation process, when the user performs a modification operation on a field data in the transaction record data in the EXCEL file, the computer device can verify the field data according to the number of bits occupied by the data after determining the response result of the edited data in the EXCEL file to the editing operation. When the number of bits of the edited field data is different from the number of bits occupied by the field data (for example, the number of bits of the edited field data is greater than the number of bits occupied by the field, or the number of bits of the edited field data is less than the number of bits occupied by the field), it can be confirmed that the verification has failed, thereby revoking the response to the editing operation, that is, the user finds that the modified field data is not displayed in the GUI interface.

[0141] In the specific implementation process, the data retention level can represent whether the data can be deleted or not during file conversion. Specifically, considering that the fixed file description data in the fund file is fixed and unchanging data, the fixed file description data in the fund file can be determined as having a lower retention level (data that can be deleted), and the transaction record data can be determined as having a higher retention level (data that cannot be deleted).

[0142] When the data attribute of the edited data is fixed file description data, it is confirmed that the legitimacy check has passed; when the data attribute of the edited data is transaction record data, if it is determined that the number of fields of the edited data is different from the number of fields occupied by the data, for example, the number of fields of the edited data is greater than the number of fields occupied by the data, that is, the legitimacy check has not passed, the response to the editing operation can be revoked. In this way, the legitimacy of the transaction record data can be accurately ensured.

[0143] In the embodiment of the present application, when a user edits an EXCEL file, the user edited data can be verified to improve the accuracy of the processed file. If the verification fails, the response to the editing operation can be revoked, that is, the user's illegal editing is blocked during the editing operation to determine the legitimacy of the edited data.

[0144] Specifically, in a possible implementation, the EXCEL file converted from the fund file can also be converted into a fund file. Specifically, the EXCEL file to be converted can be determined, wherein the EXCEL file to be converted is the EXCEL file converted from the fund file. Then, according to the typesetting format of the fund file, the EXCEL file to be converted is typesetted and converted, and a fourth typesetting result can be obtained, so that a fund file corresponding to the EXCEL file to be converted is generated according to the fourth typesetting result.

[0145] In this way, the converted EXCEL file can be converted back into a fund file, making it convenient for the user to process the transaction record data of the fund file in the EXCEL file, and then convert the processed EXCEL file into a fund file to enhance the user experience.

[0146] Specifically, in a possible implementation, during the process of converting the EXCEL file to be converted into the corresponding fund file, a validity check can be performed on key data, wherein the key data includes at least one of the field length, the number of parameters, and the number of data rows. When the validity check of the key data passes, the conversion from the EXCEL file to be converted to the corresponding fund file can continue.

[0147] In an embodiment of the present application, the key data can also be checked for legitimacy during the process of converting the EXCEL file to be converted into the corresponding fund file, thereby further ensuring the legitimacy of the fund file converted from the EXCEL file and improving the accuracy of file processing.

[0148] Based on the same inventive concept, the embodiment of the present application provides a file processing device. The file processing device can be a hardware structure, a software module, or a hardware structure plus a software module. The file processing device can be implemented by a chip system, which can be composed of a chip or include a chip and other discrete devices. Fig.10 As shown, the file processing device in the embodiment of the present application includes:

[0149] The first determination module 1001 is used to determine the fund file to be converted;

[0150] A reading module 1002 is used to read the transaction record data in the fund file, wherein the transaction record data includes M pieces of sub-transaction data spliced ​​in a predetermined order, each piece of the M pieces of sub-transaction data includes field data of N fields, each field name of the N fields is different, and M and N are both integers greater than or equal to 1;

[0151] The first typesetting module 1003 is used to divide the N fields of each sub-transaction data into N columns according to the typesetting format of the EXCEL file and set the column identifier of each column according to the field name of the field corresponding to each column to perform EXCEL typesetting, so as to obtain a first typesetting result for the transaction record data;

[0152] The first processing module 1004 is used to generate an EXCEL file corresponding to the fund file according to the first typesetting result.

[0153] In an optional implementation manner, the file processing device further includes a second determining module, configured to:

[0154] Translating the field names of the N fields in a second language different from the first language to obtain N field identifiers expressed in the second language, wherein the field names of the N fields in the first typesetting result are expressed in the first language;

[0155] The file processing device further includes a second typesetting module, which is used to: according to the way that the field identifier and the column identifier used to represent the same field name are correspondingly set, respectively set the N field identifiers represented in the second language to correspond to the N column identifiers in the first typesetting result to form a column for typesetting, so as to obtain a second typesetting result for the N fields;

[0156] The file processing device also includes a second processing module, which is used to generate an EXCEL file corresponding to the fund file according to the first typesetting result and the second typesetting result.

[0157] In an optional implementation manner, the second determining module is further configured to:

[0158] According to the number of bits occupied by each field in the N fields, determine the bit identifier corresponding to each field;

[0159] The second typesetting module is used to typeset the digit identifier of each field in correspondence with the field identifier or column identifier corresponding to the field, so as to obtain a field digit typesetting result;

[0160] Update the second layout result according to the number of field digits.

[0161] In an optional implementation manner, the file processing device further includes a third determining module, configured to:

[0162] Determining fixed file description data in the fund file, wherein the fixed file description data includes data of the same type included in all fund files represented by the financial data protocol adopted by the fund file;

[0163] The file processing device further includes a third typesetting module, which is used to: perform EXCEL typesetting on the fixed file description data according to the typesetting format of the fixed file description data in the fund file, so as to obtain a third typesetting result for the fixed file description data;

[0164] The file processing device also includes a third processing module, which is used to generate an EXCEL file corresponding to the fund file according to the first typesetting result and the third typesetting result.

[0165] In an optional implementation, the file processing device further includes a verification module, which, after generating an EXCEL file corresponding to the fund file, is used to:

[0166] Receive editing operations for EXCEL files;

[0167] According to the editing operation, determine the response result of the edited data in the EXCEL file to the editing operation;

[0168] Performing a validity check on the response result according to the data attributes of the edited data; wherein the data attributes include the number of bits occupied by the data and / or the data retention level;

[0169] If the check fails, the response to the editing operation is canceled.

[0170] In an optional implementation manner, the file processing device further includes a conversion module, which is used to:

[0171] Determine the EXCEL file to be converted, wherein the EXCEL file to be converted is an EXCEL file converted according to the fund file;

[0172] According to the typesetting format of the fund file, the EXCEL file to be converted is typesetted and converted to obtain the fourth typesetting result;

[0173] Based on the fourth layout result, generate a fund file corresponding to the EXCEL file to be converted.

[0174] In an optional implementation manner, the verification module is further used to:

[0175] In the process of converting the EXCEL file to be converted into the corresponding fund file, the key data is checked for legitimacy; wherein the key data includes at least one of the field length, the number of parameters, and the number of data rows;

[0176] The conversion module is also used to:

[0177] When the key data passes the legality check, the conversion from the EXCEL file to be converted to the corresponding fund file will continue.

[0178] The division of modules in the embodiments of the present application is schematic and is only a logical function division. There may be other division methods in actual implementation. In addition, each functional module in each embodiment of the present application may be integrated into a processor, or may exist physically separately, or two or more modules may be integrated into one module. The above-mentioned integrated modules may be implemented in the form of hardware or in the form of software functional modules.

[0179] Based on the same inventive concept, the present application embodiment also provides a computer device. Fig.11As shown, the computer device in the embodiment of the present application includes at least one processor 1101, and a memory 1102 and a communication interface 1103 connected to the at least one processor 1101. The specific connection medium between the processor 1101 and the memory 1102 is not limited in the embodiment of the present application. Fig.11 In the example, the processor 1101 and the memory 1102 are connected via the bus 1100. Fig.11 The bus 1100 is represented by a bold line, and the connection between other components is only for schematic illustration and is not intended to be limiting. The bus 1100 can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Fig.11 Only one thick line is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0180] In the embodiment of the present application, the memory 1102 stores instructions that can be executed by at least one processor 1101. The at least one processor 1101 can execute the steps included in the aforementioned fault detection method by executing the instructions stored in the memory 1102.

[0181] Among them, the processor 1101 is the control center of the computer device, and can use various interfaces and lines to connect various parts of the entire fault detection device, and through running or executing instructions stored in the memory 1102 and calling data stored in the memory 1102, various functions of the computing device and processing data, so as to monitor the computing device as a whole. Optionally, the processor 1101 may include one or more processing units, and the processor 1101 may integrate an application processor and a modem processor, wherein the processor 1101 mainly processes the operating system, user interface, and application programs, and the modem processor mainly processes wireless communications. It is understandable that the above-mentioned modem processor may not be integrated into the processor 1101. In some embodiments, the processor 1101 and the memory 1102 may be implemented on the same chip, and in some embodiments, they may also be implemented separately on independent chips.

[0182] Processor 1101 may be a general-purpose processor, such as a central processing unit (CPU), a digital signal processor, an application-specific integrated circuit, a field programmable gate array or other programmable logic device, a discrete gate or transistor logic device, a discrete hardware component, and may implement or execute the methods, steps, and logic block diagrams disclosed in the embodiments of the present application. A general-purpose processor may be a microprocessor or any conventional processor, etc. The steps of the method disclosed in the embodiments of the present application may be directly embodied as being executed by a hardware processor, or may be executed by a combination of hardware and software modules in the processor.

[0183] Memory 1102, as a non-volatile computer-readable storage medium, can be used to store non-volatile software programs, non-volatile computer executable programs and modules. Memory 1102 may include at least one type of storage medium, such as flash memory, hard disk, multimedia card, card-type memory, random access memory (Random Access Memory, RAM), static random access memory (Static Random Access Memory, SRAM), programmable read-only memory (Programmable Read Only Memory, PROM), read-only memory (Read Only Memory, ROM), electrically erasable programmable read-only memory (Electrically Erasable Programmable Read-Only Memory, EEPROM), magnetic memory, disk, optical disk, etc. Memory 1102 is any other medium that can be used to carry or store a desired program code in the form of an instruction or data structure and can be accessed by a computer, but is not limited thereto. The memory 1102 in the embodiment of the present application can also be a circuit or any other device that can realize a storage function, for storing program instructions and / or data.

[0184] The communication interface 1103 is a transmission interface that can be used for communication, and data can be received or sent through the communication interface 1103 .

[0185] See also Fig.12 The computer device shown is a further structural diagram, which also includes a basic input / output system (I / O system) 1201 for helping to transmit information between various devices in the computer device, and a large-capacity storage device 1205 for storing an operating system 1202, application programs 1203 and other program modules 1204.

[0186] The basic input / output system 1201 includes a display 1206 for displaying information and an input device 1207 such as a mouse and a keyboard for user inputting information. The display 1206 and the input device 1207 are connected to the processor 1101 through the basic input / output system 1201 connected to the system bus 1100. The basic input / output system 1201 may also include an input / output controller for receiving and processing inputs from a plurality of other devices such as a keyboard, a mouse, or an electronic stylus. Similarly, the input / output controller also provides output to a display screen, a printer, or other types of output devices.

[0187] The mass storage device 1205 is connected to the processor 1101 through a mass storage controller (not shown) connected to the system bus 1100. The mass storage device 1205 and its associated computer readable medium provide non-volatile storage for the server package. That is, the mass storage device 1205 may include a computer readable medium (not shown) such as a hard disk or a CD-ROM drive.

[0188] According to various embodiments of the present application, the computing device package can also be connected to a remote computer on the network through a network such as the Internet. That is, the computing device can be connected to the network 1208 through the communication interface 1103 connected to the system bus 1100, or the communication interface 1103 can be used to connect to other types of networks or remote computer systems (not shown).

[0189] Based on the same inventive concept, an embodiment of the present application also provides a computer-readable storage medium, which stores computer instructions. When the computer instructions are executed on a computer, the computer executes the steps of the aforementioned sequence marking method.

[0190] Based on the same inventive concept, the embodiment of the present application also provides a chip system, which includes a processor and may also include a memory, for implementing the steps of the aforementioned file processing method. The chip system may be composed of a chip, or may include a chip and other discrete devices.

[0191] In some possible implementations, various aspects of the file processing method provided in the embodiments of the present application may also be implemented in the form of a program product, which includes a program code. When the program product is run on a computer, the program code is used to enable the computer to execute the steps of the file processing method described above according to various exemplary embodiments of the present application.

[0192] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage and optical storage, etc.) that contain computer-usable program code.

[0193] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0194] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0195] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0196] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.

Claims

1. A file processing method, characterized in that: The method comprises: Identify the fund documents to be converted; Reading the transaction record data in the fund file, wherein the transaction record data includes M pieces of sub-transaction data spliced ​​in a predetermined order, each piece of the M pieces of sub-transaction data includes field data of N fields, each field name of the N fields is different, and M and N are both integers greater than or equal to 1; According to the typesetting format of the EXCEL file, according to the character length limit of each field in the N fields of each sub-transaction data, each sub-transaction data is divided into N columns, and a column identifier of the column is set according to the field name of the field corresponding to each column to perform EXCEL typesetting, so as to obtain a first typesetting result for the transaction record data; Determine a bit number identifier corresponding to each field according to the number of bits occupied by each field in the N fields; The digit identifier of each field is arranged correspondingly with the field identifier or column identifier corresponding to the field to obtain a field digit layout result; based on the first layout result and the field digit layout result, an EXCEL file corresponding to the fund file is generated.

2. The method according to claim 1, characterized in that The method further comprises: Translating the field names of the N fields in a second language different from the first language to obtain N field identifiers expressed in the second language, wherein the field names of the N fields in the first typesetting result are expressed in the first language; According to the manner of correspondingly setting the field identifier and the column identifier for representing the same field name, respectively setting the N field identifiers represented in the second language to correspond to the N column identifiers in the first typesetting result to form a column for typesetting, so as to obtain a second typesetting result for the N fields; Then, according to the first typesetting result, an EXCEL file corresponding to the fund file is generated, including: An EXCEL file corresponding to the fund file is generated according to the first typesetting result and the second typesetting result.

3. The method according to claim 1, characterized in that The method further comprises: Determining fixed file description data in the fund file, wherein the fixed file description data includes data of the same type included in all fund files represented by a financial data protocol adopted by the fund file; According to the typesetting format of the fixed file description data in the fund file, performing EXCEL typesetting on the fixed file description data to obtain a third typesetting result for the fixed file description data; Then, according to the first typesetting result, an EXCEL file corresponding to the fund file is generated, including: An EXCEL file corresponding to the fund file is generated according to the first typesetting result and the third typesetting result.

4. The method according to claim 1, characterized in that After generating the EXCEL file corresponding to the fund file, the method further includes: Receiving an editing operation on the EXCEL file; According to the editing operation, determining a response result of the edited data in the EXCEL file to the editing operation; Performing a validity check on the response result according to the data attributes of the edited data; wherein the data attributes include the number of bits occupied by the data and / or the data retention level; If the check fails, the response to the editing operation is canceled.

5. The method according to any one of claims 1 to 4, characterized in that: The method further comprises: Determine an EXCEL file to be converted, wherein the EXCEL file to be converted is an EXCEL file converted according to the fund file; Performing typesetting conversion on the EXCEL file to be converted according to the typesetting format of the fund file to obtain a fourth typesetting result; According to the fourth typesetting result, a fund file corresponding to the EXCEL file to be converted is generated.

6. The method according to claim 5, characterized in that The method further comprises: In the process of converting the EXCEL file to be converted into the corresponding fund file, the key data is subjected to a legality check; wherein the key data includes at least one of the field length, the number of parameters, and the number of data rows; When the key data passes the legality check, the conversion from the EXCEL file to be converted to the corresponding fund file will continue.

7. A file processing device, characterized in that: The device comprises: A first determination module, used to determine the fund file to be converted; a reading module, configured to read the transaction record data in the fund file, wherein the transaction record data includes M pieces of sub-transaction data spliced ​​in a predetermined order, each piece of the M pieces of sub-transaction data includes field data of N fields, each field name of the N fields is different, and M and N are both integers greater than or equal to 1; A first typesetting module is used to divide each sub-transaction data into N columns according to the typesetting format of the EXCEL file and according to the character length limit of each field in the N fields of each sub-transaction data, and to set the column identifier of the column according to the field name of the field corresponding to each column for EXCEL typesetting, so as to obtain a first typesetting result for the transaction record data; determine the digit identifier corresponding to each field according to the number of digits occupied by each field in the N fields; and typeset the digit identifier of each field in correspondence with the field identifier or column identifier corresponding to the field, so as to obtain a field digit typesetting result; The first processing module is used to generate an EXCEL file corresponding to the fund file according to the first typesetting result and the field digit typesetting result.

8. A computer device, characterized in that: The computer device comprises: A memory for storing program instructions; A processor is used to call the program instructions stored in the memory, and execute the steps included in any one of the methods described in claims 1-6 according to the obtained program instructions.

9. A storage medium, characterized in that: The storage medium stores computer-executable instructions, and the computer-executable instructions are used to enable a computer to execute the steps included in any one of the methods described in claims 1-6.

Images