File conversion method and device

A file conversion and file technology, applied in finance or other fields, can solve the problems of deletion, simple rules, prone to errors, etc., to achieve the effect of reducing the conversion error rate and liberating manpower

Pending Publication Date: 2022-08-09
BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • File conversion method and device
  • File conversion method and device
  • File conversion method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] In order to make the purposes, technical solutions and advantages of the embodiments of the present invention clearer, the embodiments of the present invention will be further described in detail below with reference to the accompanying drawings. Here, the exemplary embodiments of the present invention and their descriptions are used to explain the present invention, but not to limit the present invention. It should be noted that the embodiments in the present application and the features in the embodiments may be arbitrarily ordered with each other unless there is a conflict.

[0025] The "first", "second", ... etc. used in this document do not specifically refer to the order or order, nor are they used to limit the present invention, but are only used to distinguish elements described in the same technical terms or operate.

[0026] As used herein, "comprising," "including," "having," "containing," and the like, are open-ended terms, meaning including but not limited...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/11G06F40/16
CPCG06F16/116G06F40/16
Inventor 赵奇
Owner BANK OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap