Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data format conversion system, and method and system for batch loans information import

A format conversion and data technology, applied in the field of data processing, can solve problems such as wrong data format conversion, Excel file error reporting, conversion, etc., and achieve the effect of simplifying operation steps and avoiding compatibility problems

Inactive Publication Date: 2013-07-31
CHINA CONSTRUCTION BANK
View PDF5 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

And due to the different operating environments of VB macros, there are often problems that data format conversion cannot be performed
[0010] 2) In the Excel template of the client, the VB macro script focuses on data format conversion, and cannot pre-judge the validity of the data format, resulting in format conversion of wrong data, which requires the back-end PLSS system to check the format when loading
[0011] 3) The constraints of the VB macro operating environment require the client to install or update related libraries
Using the macro conversion function under offline conditions leads to frequent errors in Excel files, or even crashes

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
  • Data format conversion system, and method and system for batch loans information import
  • Data format conversion system, and method and system for batch loans information import
  • Data format conversion system, and method and system for batch loans information import

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In order to facilitate the understanding of various aspects, features and advantages of the technical solutions of the present invention, the present invention will be specifically described below in conjunction with the accompanying drawings. It should be understood that the various implementations described below are only for illustration, rather than limiting the protection scope of the present invention.

[0034] refer to figure 2 , illustrates a system for realizing format conversion of background data of a website according to an embodiment of the present invention. In this embodiment, the system includes:

[0035] Web server 102, is used for receiving the Excel file that the user submits by client browser 101;

[0036] The application server 103 communicates with the Web server 102, and includes a Perl-based format conversion module 400 for converting the data of the Excel file into text format data.

[0037] Among them, such as Figure 4 As shown, the Perl-...

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 data format conversion system, and a method and a system for batch loans information import. A system for achieving website background data format conversion comprises a Web server used for receiving Excel documents submitted by a user through a client browser, and an application server communicated with the Web server; and the application server comprises a format conversion module which is based on Perl and used for converting data of the Excel documents into text format data. By carrying out data format conversion uniformly on the application server at the rear end of a website, problems of character codes, new lines and the like caused by different versions of client operating systems and Office software mounted, as well as problem of incapability of running when the date of Excel data format is converted into VB macro, can be effectively avoided.

Description

technical field [0001] The present invention relates to data processing technology, and more specifically, relates to a system for realizing data format conversion in the background of a website and a method and system for importing loan information in batches using the system. Background technique [0002] With the development of information technology, China Construction Bank has established an "electronic trading platform for second-hand housing", called "Fang E Tong". Through "Fang e-Tong", customers can complete a series of processes such as loan application, loan management, loan disbursement, post-loan management and loan repayment online without leaving home. [0003] Since the personal loan sales service system (Personal Loan Sale System, PLSS, is a personal loan application and real estate marketing platform of China Construction Bank, which is used for users in the bank to enter real estate marketing product information and process customer loan application inform...

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): G06F17/22
Inventor 王伟邓玉周振邓梁周小伟李建华邓小茜张楠李友峰
Owner CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com