A method of changing column data into database

Abstract

The invention discloses a method for importing change column data into a database. The specific implementation process is as follows: firstly, recognizing a column attribute of a data source, and setting corresponding rules and data conversion rules of a data source column and a database column in a classification way; performing data importing, importing a change column into the database, determining which column of the database that the data are stored according to a column correspondence rule, and determining values of data storage according to the data conversion rules; and finally, when storing, the data are read and saved by blocks, meanwhile, recording error information, and prompting once after saving, thereby facilitating users to correct multiple errors at a time. Compared with the prior art, the method for importing the change column data into the database provided by the invention uses the setting method to convert data of an Excel and other data sources into a database system, which effectively saves the workload and working time of data entry personnel, and rapidly and effectively imports complex data into a business system; and besides, the practicability is strong, the scope of application is wide, and the method has a very good popularization and application value.

Description

technical field [0001] The invention relates to the technical field of communication information, in particular to a method for importing variable column data into a database. Background technique [0002] With the popularization of information system applications, a lot of user data needs to be imported into the background database. For the convenience of filling, the customer will use the variable column method to fill in the data. As shown in a certain table: the first two columns are subject numbers and subject names, such as 5011 Total Development Cost, 5011-01 Land Acquisition and Demolition Compensation; each subsequent column is changing multi-title classification information, such as super high-rise, high-rise For residences and small high-rise buildings, the multiple titles are divided into amount, construction unit, saleable unit, etc. If such information is imported into the information system, users often need to sort it into fixed columns first, which is time...

AI Technical Summary

Problems solved by technology

If such information is imported into the information system, users often need to sort it into fixed columns first, which is time-consuming, laborious, and error-prone, especially when there are many data rows, the workload is huge

[0003] Based on this, a method for importing variable column data into the database is now provided, aiming to help solve the problem of converting variable column data from data sources such as Excel to the database system

Images