CN106469215A - Data lead-in method based on page end and system - Google Patents

Data lead-in method based on page end and system Download PDF

Info

Publication number
CN106469215A
CN106469215A CN201610806340.2A CN201610806340A CN106469215A CN 106469215 A CN106469215 A CN 106469215A CN 201610806340 A CN201610806340 A CN 201610806340A CN 106469215 A CN106469215 A CN 106469215A
Authority
CN
China
Prior art keywords
data
page end
project category
information
statistics information
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.)
Granted
Application number
CN201610806340.2A
Other languages
Chinese (zh)
Other versions
CN106469215B (en
Inventor
李志聪
陈勇辉
徐标民
肖瑶
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangzhou Shiyuan Electronics Thecnology Co Ltd
Guangzhou Shirui Electronics Co Ltd
Original Assignee
Guangzhou Shiyuan Electronics Thecnology Co Ltd
Guangzhou Shirui Electronics Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Guangzhou Shiyuan Electronics Thecnology Co Ltd, Guangzhou Shirui Electronics Co Ltd filed Critical Guangzhou Shiyuan Electronics Thecnology Co Ltd
Priority to CN201610806340.2A priority Critical patent/CN106469215B/en
Publication of CN106469215A publication Critical patent/CN106469215A/en
Application granted granted Critical
Publication of CN106469215B publication Critical patent/CN106469215B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/95Retrieval from the web
    • G06F16/951Indexing; Web crawling techniques
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database

Abstract

The present invention relates to a kind of data lead-in method based on page end and system, wherein method includes:User-defined electrical form is uploaded to page end, and project category is selected on page end;Wherein, described electrical form fills in each object of statistics information and its project category and the corresponding data message of each project category by unified row, column form;In page end is to this electrical form each object of statistics information and its in selected item classification corresponding data message be identified and capture;Object of statistics information according to identification and crawl and its corresponding importing data, are imported in the masterplate of page end by selected project category.The technology of the present invention, decrease the operating procedure of user and workload so as to import data simpler convenient, it is to avoid imports the phenomenon of the easy error of data.

Description

Data lead-in method based on page end and system
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of data lead-in method based on page end and be System.
Background technology
Data based on page end imports on the market at present, and it imports the flow process of data is usually that user downloads in page end Template, then again replicates school report and pastes in template, then on pass webpage back.
For example, the achievement analysis product based on page end, when importing performance statistics, user first downloads mould from page end Plate, then again replicates performance statistics and pastes in template, then on pass webpage back.
There is following defect in aforesaid way:
(1) user must edit a school report, workload is big, efficiency is low again according to template;
(2) user, during editing again, it is possible that artificial operational error, leads to error in data.
As can be seen here, existing data import plan, has that efficiency is low, easy error.
Content of the invention
Based on this it is necessary to be directed to above-mentioned technical problem, provide a kind of data lead-in method based on page end and system.
A kind of data lead-in method based on page end, including:
User-defined electrical form is uploaded to page end, and project category is selected on page end;Wherein, described Electrical form fills in each object of statistics information and its project category by unified row, column form and each project category is corresponding Data message;
In page end is to this electrical form each object of statistics information and its in selected item classification corresponding data Information is identified and captures;
Object of statistics information according to identification and crawl and its corresponding importing data, are imported to by selected project category In the masterplate of page end.
A kind of data import system based on page end, including:
Transmission module on list, for user-defined electrical form is uploaded to page end, and selects on page end Project category;Wherein, described electrical form by unified row, column form fill in each object of statistics information and its project category and The corresponding data message of each project category;
Data acquisition module, in page end to this electrical form in each object of statistics information and its in selected item In classification, corresponding data message is identified and captures;
Data import modul, for the object of statistics information according to identification and crawl and its corresponding importing data, by institute The project category of choosing imports in the masterplate of page end.
The above-mentioned data lead-in method based on page end and system, self-defining electronics user being uploaded based on page end Form carries out identification and the crawl of data message, can capture the spread-sheet data of different-format, decreases the operation of user Step and workload be so as to import data simpler convenient, it is to avoid imports the phenomenon of the easy error of data.
Brief description
Fig. 1 is the data lead-in method schematic flow sheet based on page end of an embodiment,;
The flow chart that Fig. 2 imports application example for data;
Fig. 3-9 is the schematic diagram of abnormal data;
Figure 10 is school report preview interface schematic diagram;
Figure 11 is the data import system structural representation based on page end of an embodiment.
Specific embodiment
With reference to Fig. 1, Fig. 1 is the data lead-in method schematic flow sheet based on page end of an embodiment, including:
Step S10:User-defined electrical form is uploaded to page end, and project category is selected on page end; Wherein, described electrical form fills in each object of statistics information and its project category and each project by unified row, column form The corresponding data message of classification;
During this, user need not download masterplate from page end, it is possible to use the electrical form of user-defined format fills in statistics Object information, project category and the corresponding data message of each project category etc.;Electrical form is filled out by unified row, column form Write, here, row, column fill substance direction can be selected according to practical situation.
, with a line record object of statistics, each project category taking Exel table as a example;The direction record object of statistics letter of nematic Breath and the corresponding data message of each project category.
In one embodiment, the step user-defined electrical form being uploaded to page end, can include as follows:
The file manager interface that calling system carries, uploads the electronic form file of default form;In upload procedure, When need change electronic form file, again upload after deletion.
Step S20:Each object of statistics information and its right in selected item classification in page end is to this electrical form The data message answered is identified and captures;
Here, being identified to the recorded content of electrical form in page end Background scheduling instrument and can capture.
In one embodiment, the step that corresponding data message is identified and captures, can include as follows:
On page end backstage, the lateral cell lattice data message of described electrical form is identified, obtains object of statistics letter The data message of the essential elements lattice of breath and project category;
According to the project category selecting on page end, from the project category of identification, filter out corresponding project category;
The data message of permutation under the essential elements lattice of object of statistics information and the project category of screening is captured, obtains To object of statistics information and its corresponding importing data.
, the essential elements lattice of the first row are identified, grab object of statistics information and item class taking Exel table as a example Other data message, by the longitudinal direction of Exel table, permutation identifies.Capture each column data information.
Further, think and fill in mistake to exclude, in the key to object of statistics information and the project category of screening After under cell, the data message of permutation is captured, can also include:
Each column data information is carried out with abnormality detection, searches abnormal data form position and carried by abnormal mark Show.
For abnormality detection, can be detected from multiple dimensions, including duplicate message detection, gaps and omissions infomation detection, spy Different character machining, the detection of object of statistics information matches etc..
For described object of statistics information, if including the item of information of multiple associations;Can be according to the data base couple on backstage Each item of information of object of statistics information carries out matching detection, determines the corresponding relation of each item of information.
Further, after abnormality detection, according to the exception modification operation of user, described electrical form is updated, And carry out abnormality detection to described object of statistics information and its data message again in the updated, until all changed extremely Become.
Step S30:Object of statistics information according to identification and crawl and its corresponding importing data, by selected item class Do not import in the masterplate of page end;
Page end backstage, using the importing data of crawl, imports in the masterplate of page end by selected project category, complete Become data importing process, importing process make use of User Defined electrical form to have regular feature it is achieved that the grabbing of data Take, changed between two kinds of masterplates, user need not carry out the duplication operation of list, improves operating efficiency, it is to avoid people Error for operation.
The application in achievement analysis product for the data lead-in method of present invention offer, corresponding reality presented below are provided Apply example.
In the examples below, described object of statistics information includes:Student number, name;Described project category includes examination section Mesh;Described data message includes fraction or achievement classification.
With reference to shown in Fig. 2, the flow chart that Fig. 2 imports application example for data, mainly include following process:
S1, user, after starting page end, clicks on default【Import achievement】Button, points out user to upload into by playing frame Achievement list, and the file of Exel form is imported in interface prompt user.
S2, user clicks on【Upload school report】Afterwards, transmitting file on the file manager interface of calling system, uploading rule can Setting several as follows:
(1) acquiescence only shows the file of Exel form;
(2) only allow to upload a file every time, such as need to change file, need user again to upload after deleting;
(3) forbid that user uploads file, then forbid【Upload school report】, button is set to Lycoperdon polymorphum Vitt to be pointed out.
Project category can include:Time, class, examination etc..
After school report is imported into, user passes through corresponding project category on default input frame labelling, for being imported into School report in filter out required for data.
The character rule of each project category is:Except " ()-_, " 4 outer symbols, forbid other special symbols;Work as input After frame is out of focus, judge the character rule of input frame, such as there is the character rule of mistake, then prompting " can not input except " ()-_ " it Outer special symbol.
S3, setting examination classification, project category can arrange multiple test subjects, for example:Chinese language, mathematics, English, physics, Chemistry, biology, history, politics, geography, science, computer, the fine arts, music, physical culture, morality or the like.Here can set Put background data base, when user selects, call the data of background data base.
S4, after uploading school report, user can screen the subject needing to import by selecting.
As user have selected the subject not having in school report, then increasing string does not have the subject data of achievement, and user is permissible Achievement, or the achievement deleting this string are rewritten in selection;As user does not select any subject, then will be default【Complete】Press Button is set to Lycoperdon polymorphum Vitt to be pointed out, and forbids that user enters next step operation.
S5, after the completion of upload, carries out the identification of key character row on page end backstage to the school report that user uploads and grabs Take, based on Exel table lateral cell lattice, first obtain essential elements lattice, for example:Student number, name, subject, then obtain corresponding pass The data message of key unit next permutation of lattice.
S6, after completing the crawl of character row, starts data is carried out abnormality detection on page end backstage, with reference to Fig. 3-9 institute Show, Fig. 3-9 is the schematic diagram of abnormal data, abnormal data is broadly divided into 3 big class:
(1) object of statistics information mismatches:
As an example, with reference to shown in Fig. 3, for the object of statistics information such as student number and name, according to the data on backstage Storehouse confirming both corresponding relations, such as name-student number mistake, corresponding unit lattice are designated exception, point out under hover state " name-student number mismatch ", can by the direct redirection of user, in page end Auto-matching by way of modify.
(2) information repeats:
1. student number and name repeat:
As an example, with reference to shown in Fig. 4, if there being two student numbers all the same with name in list, but at least one Section's achievement is different, then the student number of two and name identify exception simultaneously, points out " information repetition " under hover state;As imported In school report, there is a plurality of repeated data (name, student number, achievement are just the same), be then introduced only into one, filter duplicate message.
2. subject information repeats:
As an example, with reference to shown in Fig. 5, if in the electrical form importing, there are two Course in English and divide Number is all the same, then Intelligent Recognition only retains one of which, is then introduced in preview interface;
If in the form importing, it is the same to there are two Course in English, but fraction is different, then retain two fractions, And import to preview interface, and two Course in English are designated exception, point out " information repetition " under hover state;
(3) data formatting error:
1. no student number or no name:
As an example, with reference to shown in Fig. 6, if school report lacks student number or name, in editing interface, completion Number string, and it is designated mistake, prompting " student number is sky " under hover state;
2. information is sky:
As an example, with reference to shown in Fig. 7, if subject fraction is sky, cell is designated exception, hover shape " fraction please be input " is pointed out under state;
3. information does not meet form:
As an example, with reference to shown in Fig. 8, student number or name format error, then press " name-student number mismatches " place Reason;If student number and name, format error, cell mark is abnormal, points out " please input fraction " under hover state;
4. chosen and imported the subject not having in electrical form:
As an example, with reference to shown in Fig. 9, if lacking subject in school report, the subject of completion disappearance, and identify Cell is abnormal, points out " please input fraction " under hover state.
S7, after judging exception, forms new school report preview interface, identifies anomaly unit lattice, is easy to user's modification;Make For an example, with reference to shown in Figure 10, Figure 10 is school report preview interface schematic diagram, detecting after cell is modified, then Carry out the abnormal operation judging, then continue mark if any abnormal, then cancellation without exception is abnormal to be identified;
S8, when user clicks on【Preserve】During operation, import data message.
To sum up described in embodiment, the data lead-in method based on page end that the present invention provides, based on page end to importing Data grabber enters row operation, can capture the school report under different-format Excel table, thus decreasing user to import achievement data behaviour Make step, greatly reduce workload, allow importing school report to become more flexibly and fast;Simultaneously by sentencing to abnormal data Disconnected, from more various dimensions, data is contrasted and judged, can artificially fill in the mistake of data for user's exclusion, and can be utilized Back-end data, carries out " a key coupling " to key message in school report (as student number and name) unmatched exception, need not be again Verification modification manually, is easy to correct abnormal data.
With reference to Figure 11, Figure 11 is the data import system structural representation based on page end of an embodiment, including:
Transmission module 10 on list, for user-defined electrical form is uploaded to page end, and select on page end Select project category;Wherein, described electrical form fills in each object of statistics information and its project category by unified row, column form The corresponding data message with each project category;
Data acquisition module 20, in page end to this electrical form in each object of statistics information and its in selected item In mesh classification, corresponding data message is identified and captures;
Data import modul 30, for the object of statistics information according to identification and crawl and its corresponding importing data, presses Selected project category imports in the masterplate of page end.
The data import system based on page end of the present invention and the data lead-in method one based on page end of the present invention One is corresponding, all applicable in the technical characteristic of the embodiment elaboration of the above-mentioned data lead-in method based on page end and its advantage In the embodiment of the data import system based on page end, hereby give notice that.
Each technical characteristic of embodiment described above can arbitrarily be combined, for making description succinct, not to above-mentioned reality The all possible combination of each technical characteristic applied in example is all described, as long as however, the combination of these technical characteristics is not deposited In contradiction, all it is considered to be the scope of this specification record.
Embodiment described above only have expressed the several embodiments of the present invention, and its description is more concrete and detailed, but simultaneously Can not therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art Say, without departing from the inventive concept of the premise, some deformation can also be made and improve, these broadly fall into the protection of the present invention Scope.Therefore, the protection domain of patent of the present invention should be defined by claims.

Claims (10)

1. a kind of data lead-in method based on page end is it is characterised in that include:
User-defined electrical form is uploaded to page end, and project category is selected on page end;Wherein, described electronics Form fills in each object of statistics information and its project category and the corresponding data of each project category by unified row, column form Information;
In page end is to this electrical form each object of statistics information and its in selected item classification corresponding data message It is identified and capture;
Object of statistics information according to identification and crawl and its corresponding importing data, import to webpage by selected project category In the masterplate at end.
2. the data lead-in method based on page end according to claim 1 is it is characterised in that in page end to this electronics Each object of statistics information and its corresponding data message is identified and captures in selected item classification step in form Including:
On page end backstage, the lateral cell lattice data message of described electrical form is identified, obtain object of statistics information and The data message of the essential elements lattice of project category;
According to the project category selecting on page end, from the project category of identification, filter out corresponding project category;
The data message of permutation under the essential elements lattice of object of statistics information and the project category of screening is captured, is united Meter object information and its corresponding importing data.
3. the data lead-in method based on page end according to claim 2 is it is characterised in that to object of statistics information After being captured with the data message of permutation under the essential elements lattice of the project category of screening, also include:
Each column data information is carried out with abnormality detection, searches abnormal data form position and pointed out by abnormal mark.
4. the data lead-in method based on page end according to claim 1 is it is characterised in that by user-defined electricity The step that sub-table is uploaded to page end includes:
The file manager interface that calling system carries, uploads the electronic form file of default form;In upload procedure, when need During change electronic form file, again upload after deletion.
5. the data lead-in method based on page end according to claim 1 is it is characterised in that described abnormality detection includes Duplicate message detects, gaps and omissions infomation detection, spcial character detection or the detection of object of statistics information matches.
6. the data lead-in method based on page end according to claim 5 is it is characterised in that also include:
According to the exception modification operation of user, described electrical form is updated, and right to described statistics again in the updated Image information and its data message carry out abnormality detection.
7. the data lead-in method based on page end according to claim 6 is it is characterised in that described object of statistics information Item of information including multiple associations;
Data base according to backstage carries out matching detection to each item of information of object of statistics information, determines the right of each item of information Should be related to.
8. the data lead-in method based on page end according to claim 6 is it is characterised in that described electrical form is Exel table.
9. the data lead-in method based on page end according to any one of claim 1 to 8 is it is characterised in that described system Meter object information includes:Student number, name;Described project category includes test subject;Described data message includes fraction or achievement Classification.
10. a kind of data import system based on page end is it is characterised in that include:
Transmission module on list, for user-defined electrical form is uploaded to page end, and selects project on page end Classification;Wherein, described electrical form by unified row, column form fill in each object of statistics information and its project category and each The corresponding data message of project category;
Data acquisition module, in page end to this electrical form in each object of statistics information and its in selected item classification In corresponding data message be identified and capture;
Data import modul, for the object of statistics information according to identification and crawl and its corresponding importing data, by selected Project category imports in the masterplate of page end.
CN201610806340.2A 2016-09-06 2016-09-06 Data lead-in method and system based on page end Active CN106469215B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610806340.2A CN106469215B (en) 2016-09-06 2016-09-06 Data lead-in method and system based on page end

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610806340.2A CN106469215B (en) 2016-09-06 2016-09-06 Data lead-in method and system based on page end

Publications (2)

Publication Number Publication Date
CN106469215A true CN106469215A (en) 2017-03-01
CN106469215B CN106469215B (en) 2019-09-03

Family

ID=58230538

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610806340.2A Active CN106469215B (en) 2016-09-06 2016-09-06 Data lead-in method and system based on page end

Country Status (1)

Country Link
CN (1) CN106469215B (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107436956A (en) * 2017-09-12 2017-12-05 广州中软信息技术有限公司 Social security takes the transmission method of collection data, apparatus and system
CN107545443A (en) * 2017-07-16 2018-01-05 广州矽云信息科技有限公司 A kind of storage management method and system based on anti-counterfeiting information code
CN107633410A (en) * 2017-07-16 2018-01-26 广州矽云信息科技有限公司 A kind of error correction system and method for dual code anti-faking
CN108270875A (en) * 2018-02-24 2018-07-10 量化医学研究院(深圳)有限公司 A kind of data uploading method and front end processor
CN112289106A (en) * 2019-07-23 2021-01-29 伊利诺斯工具制品有限公司 Learning management system with shared welding training results
CN112699161A (en) * 2019-10-23 2021-04-23 上海磐门信息科技有限公司 Medical statistical system and method

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101976236A (en) * 2010-09-26 2011-02-16 用友软件股份有限公司 Method and device for importing floating row data through worksheet
CN102929855A (en) * 2012-09-27 2013-02-13 珠海金山办公软件有限公司 Method for exporting screening result from spreadsheet and terminal
CN103744943A (en) * 2013-12-31 2014-04-23 广东倍智人才管理咨询有限公司 Data inputting method applied to position evaluation system
CN104978333A (en) * 2014-04-08 2015-10-14 无锡兰霖网络科技有限公司 Automatic matching method based on Excel statistical form and web technology
CN105824940A (en) * 2016-03-17 2016-08-03 深圳市永兴元科技有限公司 Method and device for importing data

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101976236A (en) * 2010-09-26 2011-02-16 用友软件股份有限公司 Method and device for importing floating row data through worksheet
CN102929855A (en) * 2012-09-27 2013-02-13 珠海金山办公软件有限公司 Method for exporting screening result from spreadsheet and terminal
CN103744943A (en) * 2013-12-31 2014-04-23 广东倍智人才管理咨询有限公司 Data inputting method applied to position evaluation system
CN104978333A (en) * 2014-04-08 2015-10-14 无锡兰霖网络科技有限公司 Automatic matching method based on Excel statistical form and web technology
CN105824940A (en) * 2016-03-17 2016-08-03 深圳市永兴元科技有限公司 Method and device for importing data

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107545443A (en) * 2017-07-16 2018-01-05 广州矽云信息科技有限公司 A kind of storage management method and system based on anti-counterfeiting information code
CN107633410A (en) * 2017-07-16 2018-01-26 广州矽云信息科技有限公司 A kind of error correction system and method for dual code anti-faking
CN107633410B (en) * 2017-07-16 2021-02-19 广州矽云信息科技有限公司 Error correction system and method for double-code anti-counterfeiting
CN107436956A (en) * 2017-09-12 2017-12-05 广州中软信息技术有限公司 Social security takes the transmission method of collection data, apparatus and system
CN108270875A (en) * 2018-02-24 2018-07-10 量化医学研究院(深圳)有限公司 A kind of data uploading method and front end processor
CN108270875B (en) * 2018-02-24 2021-02-26 量化医学研究院(深圳)有限公司 Data uploading method and front-end processor
CN112289106A (en) * 2019-07-23 2021-01-29 伊利诺斯工具制品有限公司 Learning management system with shared welding training results
CN112699161A (en) * 2019-10-23 2021-04-23 上海磐门信息科技有限公司 Medical statistical system and method

Also Published As

Publication number Publication date
CN106469215B (en) 2019-09-03

Similar Documents

Publication Publication Date Title
CN106469215A (en) Data lead-in method based on page end and system
US10255439B2 (en) Threat modeling systems and related methods including compensating controls
EP2778929B1 (en) Test script generation system
CN106815185B (en) One kind investigating report automatic generation method and system on the spot
CN105138752B (en) Intelligent substation SCD file land parcel change trace differentiation compares and methods of exhibiting
CN106855902B (en) Method and system for automatically generating process flow
CN104679658A (en) Test method and test system for WEB pages
CN104899016B (en) Allocating stack Relation acquisition method and device
CN103079086A (en) Automatic testing system for set-top box
CN113688288B (en) Data association analysis method, device, computer equipment and storage medium
CN104298721B (en) A kind of arbitrarily a object split screen layout edit methods of the online courseware development based on Web
CN107451112B (en) Form tool data checking method, device, terminal equipment and storage medium
CN110263007A (en) A kind of file naming method, system and electronic equipment and storage medium
CN106599375A (en) P&ID-based seal point automatic identification system and method
CN109598228A (en) Paper document electronization is recorded to the method and system of filing
CN108255837A (en) A kind of SQL resolvers and method
CN105335246A (en) Method for automatically repairing program crash defect based on question-answer website analysis
CN104977525B (en) A kind of method of manual editing's flying probe file
CN107870827A (en) Data quality control method and device based on verification
CN103399848A (en) Engine test data standardized specific format leading-in processing method
CN103913672B (en) A kind of satellite low frequency interface automatization test system
CN107256311A (en) A kind of method for being checked in PCB design and deleting dangling via
CN107066438A (en) A kind of method for editing text and device, electronic equipment
CN106940648A (en) A kind of method, equipment and the test system of automatic loading test item
CN107943912A (en) A kind of response type Resource TOC data visualization management method, terminal and device

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant