File conversion method, device and equipment

A document conversion, document technology

Pending Publication Date: 2021-07-09
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The types of data involved in financial excel reports are complex and changeable, and the requirements for xml files required by the regulatory requirements of various regions are also quite different, so it is difficult to directly use general conversion tools to convert each excel report into an xml file that meets the requirements of various regions
At present, the data in excel is basically taken out manually by relevant business personnel, and then converted into xml files by using general conversion tools. The conversion work is time-consuming, laborious and error-prone

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, device and equipment
  • File conversion method, device and equipment
  • File conversion method, device and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] In order to enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in one or more embodiments of this specification will be clearly and completely described below in conjunction with the drawings in one or more embodiments of this specification Obviously, the described embodiments are only some of the embodiments in the description, not all of them. Based on one or more embodiments in the description, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the embodiments of the description.

[0030] In an example application scenario of this specification, the file conversion method can be applied to a file conversion tool. The execution logic of the file conversion tool can be configured in the server or in the client. The client can be, for example, an intelligent terminal such as a computer or a service termin...

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 relates to the technical field of big data processing, and particularly discloses a file conversion method, device and equipment, and the method comprises the steps: obtaining a basic parameter table corresponding to a business data table, wherein the basic parameter table is determined based on position information and labeling information of labeling cells in a sample table corresponding to the business data table, and the annotation information at least comprises node parameters of xml nodes to which data corresponding to the annotation cells need to be filled; reading node parameters in the basic data table, and extracting data values corresponding to the read node parameters from a service data table based on the position information of the marked cells corresponding to the read node parameters; and filling the extracted data value into an xml node corresponding to the read node parameter in an xml tree structure to obtain a submitted xml file corresponding to the service data table. By utilizing each embodiment of the specification, the file conversion efficiency and accuracy can be greatly improved.

Description

technical field [0001] This specification relates to the technical field of big data processing, and in particular, relates to a file conversion method, device and equipment. Background technique [0002] Overseas branches of financial institutions usually need to regularly report some operational data to local regulatory authorities. The reported data is usually generated by the transaction, and is generated into an excel report through the internal reporting system, and then submitted to the local regulatory authority. At present, when regulatory requirements in some regions require data submission, in addition to submitting normal excel report data, data files in xml (Extensible Markup Language, Extensible Markup Language) format must also be submitted. The types of data involved in financial excel reports are complex and changeable, and the requirements for xml files required by the regulatory requirements of various regions are also quite different. Therefore, it is di...

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): G06F40/154G06F40/143G06F40/166
CPCG06F40/143G06F40/154G06F40/166
Inventor 郭邦姜俊萍崔希庆
Owner INDUSTRIAL AND COMMERCIAL 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