File conversion method and device

Abstract

The invention discloses a file conversion method and device which can be used in the financial field or other technical fields. The file conversion method comprises the following steps: searching a column conversion rule having a mapping relationship with a to-be-converted file in a preset mapping relationship table; processing each column of data of the to-be-converted file according to the column conversion rule to generate at least one column of target data; and according to the at least one column of target data, generating a file of a target structure corresponding to the to-be-converted file. The device is used for executing the method. According to the file conversion method and device provided by the embodiment of the invention, conversion among files of different structures is realized by utilizing a computer technology, compared with a current manual conversion method, manpower is liberated, the conversion error rate is also reduced, the column conversion rule can be configured according to requirements, and the conversion efficiency is improved. Compared with manual conversion, the method can adapt to complex conversion scenes.

Description

technical field [0001] The present invention relates to financial or other technical fields, in particular to a file conversion method and device. Background technique [0002] Batch file: the first line is the file description of each column of the file, starting from the second column, it is the record that conforms to the corresponding column format; for example, the commonly used Excel file. [0003] For a system or website, when processing batch files of a function, the structure of the batch file corresponding to the function is generally fixed. However, for the customers of the system or website, there may be multiple ways to generate batch files. For example, the system provides batch tools, batch files generated by the company's ERP system, etc. Due to differences in the systems of different companies, the original batch files provided by customers may vary. At this point, a problem arises, how to convert the original batch file into a file that can be parsed by t...

AI Technical Summary

Problems solved by technology

[0004] At present, customers generally convert files by manual / direct replacement offline. This conversion method has the following problems: 1. High error rate: Due to the variety of Excel cell formats, errors are prone to occur when performing manual operations, and It is not easy to identify, such as the end of the ID number is set to 0, the front 0 is deleted, etc.; 2. High cost: manual data column mapping requires more manpower and energy; if there is a problem in a certain line, the entire file will be unavailable , needs to be reworked; 3. The rules are single: the file conversion rules are simple, generally one-to-one conversion is performed, and many scenarios require secondary processing

Images