CN104331468A - Excel verification lead-in system and method - Google Patents
Excel verification lead-in system and method Download PDFInfo
- Publication number
- CN104331468A CN104331468A CN201410606793.1A CN201410606793A CN104331468A CN 104331468 A CN104331468 A CN 104331468A CN 201410606793 A CN201410606793 A CN 201410606793A CN 104331468 A CN104331468 A CN 104331468A
- Authority
- CN
- China
- Prior art keywords
- data
- excel
- xml
- module
- file
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/006—Identification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/93—Document management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Quality & Reliability (AREA)
- Business, Economics & Management (AREA)
- General Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an Excel verification lead-in system. The Excel verification lead-in system comprises a file uploading module, an Xml data verification module, a file lead-in storage module and a front-end preview module, wherein the file uploading module is used for uploading an Excel file to a background server and judging whether the type of the uploaded file conforms to the uploading rule or not; the Xml data verification module is used for verifying the data legality in the uploaded file according to an Xml configuration parameter, recording the verified illegal error data information into a temporary file and recording the verified legal correct data in a temporary database table; the file lead-in storage module is used for leading and storing the data verified by the Xml data verification module into a formal database table; the front-end preview module is used for displaying a verification result of the Xml data verification module on a front end. The invention also provides an Excel verification lead-in method. The Excel verification lead-in system and method have beneficial effects that an application software system adopting the Excel verification lead-in system and method is convenient and simple to maintain.
Description
Technical field
The present invention relates to data processing field, particularly relate to a kind of checking import system and method for Excel file.
Background technology
Along with the develop rapidly of software engineering, in application software system, software users often needs that Excel file is imported application software system and processes, and existing application software system is when processing Excel and importing, all will judge features such as the correctness of data, rationality, the judgement of current most of application software system is verified one by one often by the mode of hard coded.
But the business demand adopting hard coded mode to verify that the application software system maintainability of Excel file is poor, often kind different all will carry out the rationality that hard coded goes verification msg, makes application software system difficult in maintenance, loaded down with trivial details.
Summary of the invention
The problem that lead-in mode makes application software system difficult in maintenance, loaded down with trivial details is verified in order to solve existing Excel, the invention provides a kind of Excel and verify import system and method, adopt this kind of Excel to verify convenient, the simple advantage of the maintenance of the application software system of import system and method.
The embodiment of the present invention provides a kind of Excel to verify import system, comprising: files passe module, uploads rule for Excel file being uploaded to background server and judging whether upload file type meets; Xml Data Verification module, for according to the data validation in Xml configuration parameter checking upload file, will be recorded in temporary file by the illegal misdata information of checking, and be recorded in volatile data base table by the legal correct data by checking; File import preserve module, for by the data importing verified by Xml Data Verification module and be saved in actual data storehouse table; Front end previewing module, for the result at front end display Xml Data Verification module.
In above-described embodiment, described front end previewing module is used for showing the concrete error situation of illegal misdata information and legal correct data information in front end.
In above-described embodiment, described Xml Data Verification module is also for after having verified the data validation in upload file, according to the main foreign key relationship of valid data in Xml configuration information update volatile data base table, verify the uniqueness of this valid data, and mark repeating data and non-repeating data respectively.
In above-described embodiment, described file imports preserves module for being directed through the not repeating data of Xml Data Verification module legitimate verification, and the not repeating data by Xml Data Verification module legitimate verification is saved in actual data storehouse table.
In above-described embodiment, described front end previewing module is used for showing the not repeating data information in the concrete error situation of illegal misdata information and valid data and repeating data information in front end.
The embodiment of the present invention also provides a kind of, and Excel verifies introduction method, comprises step: upload Excel file to background server, judges whether upload file type meets and uploads rule, and upload file type that and if only if meets when uploading rule carries out following steps; According to the data validation in Xml configuration parameter checking upload file, will be recorded in temporary file by the illegal misdata information of checking, and the legal correct data by checking is recorded in volatile data base table; By the data importing verified by Xml Data Verification module and be saved in actual data storehouse table; At the result of front end display Xml Data Verification module.
In above-described embodiment, described " the result at front end display Xml Data Verification module " refers to the concrete error situation and legal correct data information that show illegal misdata information in front end.
In above-described embodiment, after described " data validation according in Xml configuration parameter checking upload file ", before " by the data importing verified by Xml Data Verification module and be saved in actual data storehouse table ", also comprise the step of " according to the main foreign key relationship of valid data in Xml configuration information update volatile data base table; verify the uniqueness of this valid data, and mark repeating data and non-repeating data respectively ".
In above-described embodiment, described " by the data importing verified by Xml Data Verification module and be saved in actual data storehouse table " refers to the not repeating data being directed through Xml Data Verification module legitimate verification, and the not repeating data by Xml Data Verification module legitimate verification is saved in actual data storehouse table.
In above-described embodiment, described " the result at front end display Xml Data Verification module " refers to and to show not repeating data information in the concrete error situation of illegal misdata information and valid data and repeating data information in front end.
Above-mentioned Excel of the present invention verifies import system and method, and the mode that can be configured by Xml is verified uploading data, without the need to carrying out hard coded in program code, safeguards convenient.And need only to need to be configured corresponding Xml file to revise when change proof rule, without the need to changing program internal code, more without the need to issuing web site again.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is the functional block diagram verifying import system according to a kind of Excel of the embodiment of the present invention.
Fig. 2 is the FB(flow block) verifying introduction method according to a kind of Excel of the embodiment of the present invention.
Fig. 3 is the FB(flow block) verifying introduction method according to a kind of preferred Excel of the embodiment of the present invention.
Embodiment
Below in conjunction with the drawings and specific embodiments, more detailed description is further done to technical scheme of the present invention.Obviously, described embodiment is only a part of embodiment of the present invention, instead of whole embodiments.Based on the embodiment in the present invention, the every other embodiment that those of ordinary skill in the art obtain under the prerequisite of not making creative work, all should belong to the scope of protection of the invention.
Fig. 1 is the functional block diagram verifying import system according to a kind of Excel of the embodiment of the present invention.This Excel verifies that import system comprises files passe module 11, Xml Data Verification module 12, file importing preservation module 13 and front end previewing module 14.
This files passe module 11, uploads rule for Excel file being uploaded to background server and judging whether upload file type meets.
This Xml Data Verification module 12, for verifying the data validation in upload file according to Xml configuration parameter, will be recorded in temporary file by the illegal misdata information of checking, and the legal correct data by checking is recorded in volatile data base table;
This file import preserve module 13, for by the data importing verified by Xml Data Verification module 12 and be saved in actual data storehouse table;
This front end previewing module 14, for the result at front end display Xml Data Verification module 12.In the present embodiment, this front end previewing module with 14 in showing the concrete error situation of illegal misdata information and legal correct data information in front end.
Preferably, described Xml Data Verification module 12 is also for after having verified the data validation in upload file, according to the main foreign key relationship of valid data in Xml configuration information update volatile data base table, verify the uniqueness of this valid data, and mark repeating data and non-repeating data respectively.Accordingly, in this case, described file imports preserves module 13 for being directed through the not repeating data of Xml Data Verification module 12 legitimate verification, and the not repeating data by Xml Data Verification module 12 legitimate verification is saved in actual data storehouse table.Further corresponding, described front end previewing module 14 is for showing not repeating data information in the concrete error situation of illegal misdata information and valid data and repeating data information in front end.
Fig. 2 is the FB(flow block) verifying introduction method according to a kind of Excel of the embodiment of the present invention, and this Excel verifies that introduction method comprises step:
Upload Excel file to background server, judge whether upload file type meets and upload rule, upload file type that and if only if meets when uploading rule carries out following steps;
According to the data validation in Xml configuration parameter checking upload file, will be recorded in temporary file by the illegal misdata information of checking, and the legal correct data by checking is recorded in volatile data base table;
By the data importing verified by Xml Data Verification module and be saved in actual data storehouse table;
At the result of front end display Xml Data Verification module.In the present embodiment, described " the result at front end display Xml Data Verification module " refers to the concrete error situation and legal correct data information that show illegal misdata information in front end.
See Fig. 3, preferably, after described " data validation according in Xml configuration parameter checking upload file ", before " by the data importing verified by Xml Data Verification module and be saved in actual data storehouse table ", also comprise the step of " according to the main foreign key relationship of valid data in Xml configuration information update volatile data base table; verify the uniqueness of this valid data, and mark repeating data and non-repeating data respectively ".Accordingly, described " by the data importing verified by Xml Data Verification module and be saved in actual data storehouse table " refers to the not repeating data being directed through Xml Data Verification module legitimate verification, and the not repeating data by Xml Data Verification module legitimate verification is saved in actual data storehouse table.Further corresponding, described " the result at front end display Xml Data Verification module " refers to and to show not repeating data information in the concrete error situation of illegal misdata information and valid data and repeating data information in front end.
Advantageously, described Excel verifies import system and method, and the mode that can be configured by Xml is verified uploading data, without the need to carrying out hard coded in program code, safeguards convenient.And need only to need to be configured corresponding Xml file to revise when change proof rule, without the need to changing program internal code, more without the need to issuing web site again.
The above disclosed preferred embodiment be only in the embodiment of the present invention, certainly can not limit the interest field of the present invention, therefore according to the equivalent variations that the claims in the present invention are done, still belong to the scope that the present invention is contained with this.
Claims (10)
1. Excel verifies an import system, comprising:
Files passe module, uploads rule for Excel file being uploaded to background server and judging whether upload file type meets;
Xml Data Verification module, for according to the data validation in Xml configuration parameter checking upload file, will be recorded in temporary file by the illegal misdata information of checking, and be recorded in volatile data base table by the legal correct data by checking;
File import preserve module, for by the data importing verified by Xml Data Verification module and be saved in actual data storehouse table;
Front end previewing module, for the result at front end display Xml Data Verification module.
2. Excel as claimed in claim 1 verifies import system, it is characterized in that, described front end previewing module is used for showing the concrete error situation of illegal misdata information and legal correct data information in front end.
3. Excel as claimed in claim 1 verifies import system, it is characterized in that, described Xml Data Verification module is also for after having verified the data validation in upload file, according to the main foreign key relationship of valid data in Xml configuration information update volatile data base table, verify the uniqueness of this valid data, and mark repeating data and non-repeating data respectively.
4. Excel as claimed in claim 3 verifies import system, it is characterized in that, described file imports preserves module for being directed through the not repeating data of Xml Data Verification module legitimate verification, and the not repeating data by Xml Data Verification module legitimate verification is saved in actual data storehouse table.
5. Excel as claimed in claim 4 verifies import system, it is characterized in that, described front end previewing module is used for showing the not repeating data information in the concrete error situation of illegal misdata information and valid data and repeating data information in front end.
6. Excel verifies an introduction method, comprises step:
Upload Excel file to background server, judge whether upload file type meets and upload rule, upload file type that and if only if meets when uploading rule carries out following steps;
According to the data validation in Xml configuration parameter checking upload file, will be recorded in temporary file by the illegal misdata information of checking, and the legal correct data by checking is recorded in volatile data base table;
By the data importing verified by Xml Data Verification module and be saved in actual data storehouse table;
At the result of front end display Xml Data Verification module.
7. Excel as claimed in claim 6 verifies import system, it is characterized in that, described " the result at front end display Xml Data Verification module " refers to the concrete error situation and legal correct data information that show illegal misdata information in front end.
8. Excel as claimed in claim 6 verifies import system, it is characterized in that, after described " data validation according in Xml configuration parameter checking upload file ", before " by the data importing verified by Xml Data Verification module and be saved in actual data storehouse table ", also comprise the step of " according to the main foreign key relationship of valid data in Xml configuration information update volatile data base table; verify the uniqueness of this valid data, and mark repeating data and non-repeating data respectively ".
9. Excel as claimed in claim 8 verifies import system, it is characterized in that, described " by the data importing verified by Xml Data Verification module and be saved in actual data storehouse table " refers to the not repeating data being directed through Xml Data Verification module legitimate verification, and the not repeating data by Xml Data Verification module legitimate verification is saved in actual data storehouse table.
10. Excel as claimed in claim 9 verifies import system, it is characterized in that, described " the result at front end display Xml Data Verification module " refers to and to show not repeating data information in the concrete error situation of illegal misdata information and valid data and repeating data information in front end.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410606793.1A CN104331468A (en) | 2014-10-31 | 2014-10-31 | Excel verification lead-in system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410606793.1A CN104331468A (en) | 2014-10-31 | 2014-10-31 | Excel verification lead-in system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104331468A true CN104331468A (en) | 2015-02-04 |
Family
ID=52406195
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410606793.1A Pending CN104331468A (en) | 2014-10-31 | 2014-10-31 | Excel verification lead-in system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104331468A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106250472A (en) * | 2016-07-29 | 2016-12-21 | 广州仕邦人力资源有限公司 | A kind of EXCEL data lead-in method |
| CN107085590A (en) * | 2017-01-23 | 2017-08-22 | 山东浪潮商用系统有限公司 | A kind of Excel data import systems based on multithreading |
| CN107291809A (en) * | 2017-05-17 | 2017-10-24 | 四川新网银行股份有限公司 | The document management method and device of a kind of open platform |
| CN107798128A (en) * | 2017-11-14 | 2018-03-13 | 泰康保险集团股份有限公司 | Data lead-in method, device, medium and electronic equipment |
| CN107844467A (en) * | 2016-09-21 | 2018-03-27 | 北京京东尚科信息技术有限公司 | A kind of electrical form verification method and device |
| CN109359282A (en) * | 2018-09-25 | 2019-02-19 | 北京海数宝科技有限公司 | Listings data introduction method, device, computer equipment and storage medium |
| CN109446257A (en) * | 2018-10-18 | 2019-03-08 | 浪潮软件集团有限公司 | Method and device for importing excel file data into database |
| CN109960697A (en) * | 2019-03-28 | 2019-07-02 | 北京致远互联软件股份有限公司 | System introducing method, apparatus and realization device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103617045A (en) * | 2013-12-12 | 2014-03-05 | 用友软件股份有限公司 | Plug-in development system and method based on user-defined Excel function |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
| US20140149470A1 (en) * | 2012-11-27 | 2014-05-29 | Sandeep Rawal | Systems and methods for storing and populating forms |
-
2014
- 2014-10-31 CN CN201410606793.1A patent/CN104331468A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140149470A1 (en) * | 2012-11-27 | 2014-05-29 | Sandeep Rawal | Systems and methods for storing and populating forms |
| CN103617045A (en) * | 2013-12-12 | 2014-03-05 | 用友软件股份有限公司 | Plug-in development system and method based on user-defined Excel function |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106250472A (en) * | 2016-07-29 | 2016-12-21 | 广州仕邦人力资源有限公司 | A kind of EXCEL data lead-in method |
| CN107844467A (en) * | 2016-09-21 | 2018-03-27 | 北京京东尚科信息技术有限公司 | A kind of electrical form verification method and device |
| CN107085590A (en) * | 2017-01-23 | 2017-08-22 | 山东浪潮商用系统有限公司 | A kind of Excel data import systems based on multithreading |
| CN107291809A (en) * | 2017-05-17 | 2017-10-24 | 四川新网银行股份有限公司 | The document management method and device of a kind of open platform |
| CN107291809B (en) * | 2017-05-17 | 2019-09-03 | 四川新网银行股份有限公司 | A kind of document management method and device of open platform |
| CN107798128A (en) * | 2017-11-14 | 2018-03-13 | 泰康保险集团股份有限公司 | Data lead-in method, device, medium and electronic equipment |
| CN109359282A (en) * | 2018-09-25 | 2019-02-19 | 北京海数宝科技有限公司 | Listings data introduction method, device, computer equipment and storage medium |
| CN109446257A (en) * | 2018-10-18 | 2019-03-08 | 浪潮软件集团有限公司 | Method and device for importing excel file data into database |
| CN109960697A (en) * | 2019-03-28 | 2019-07-02 | 北京致远互联软件股份有限公司 | System introducing method, apparatus and realization device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104331468A (en) | Excel verification lead-in system and method | |
| CN102685727B (en) | Method for transmitting and operating application program, system for operating application program, server and terminal | |
| WO2017036228A1 (en) | Method and apparatus for implementing system upgrading | |
| Lah et al. | Technology-as-a-service playbook: How to grow a profitable subscription business | |
| CN105243715A (en) | Dynamic two-dimensional bar code based automatic registration method and system for district visiting users | |
| CN103701922B (en) | The method and system of the application security deployment of PAAS platforms | |
| JP2011523749A (en) | Method for providing service based on tag information, and corresponding tag and tag reader | |
| CN103561040A (en) | File downloading method and system | |
| CN106155661B (en) | Control access method and device | |
| EP3570576B1 (en) | Method for the generation of personalized profile package data in integrated circuit cards, corresponding system and computer program product | |
| CN110147410B (en) | Data verification method, system, device and equipment in block chain type account book | |
| CN112689979A (en) | Article identity management method, terminal, micro-processing unit, identification equipment and system | |
| US20090007261A1 (en) | Receiving data in a data store in a server computer system | |
| CN110958292A (en) | File uploading method, electronic device, computer equipment and storage medium | |
| CN104468457A (en) | User logging-in method based on unified user system and registering method | |
| CN105550601A (en) | File integrity verification method and file integrity verification apparatus based on virtualization platform | |
| CN104680041A (en) | Off-line software license validation method | |
| CN104111919A (en) | Certificate compilation method for measuring and testing service system | |
| CN110248356B (en) | Information acquisition method and device | |
| CN109934590B (en) | Block chain-based data processing method and device, electronic equipment and medium | |
| CN104424426A (en) | Verification method and verification device | |
| CN108090364B (en) | Method and system for positioning data leakage source | |
| CN111833059B (en) | Data asset management method in data bank and data bank system | |
| CN105117427A (en) | Certificate management system based on two-dimensional code | |
| CN104935555A (en) | Client certificate authentication method, server, client and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150204 |