CN106469215A - Data lead-in method based on page end and system - Google Patents
Data lead-in method based on page end and system Download PDFInfo
- 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
Links
Classifications
-
- 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/95—Retrieval from the web
- G06F16/951—Indexing; Web crawling techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data 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
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.
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)
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)
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 |
-
2016
- 2016-09-06 CN CN201610806340.2A patent/CN106469215B/en active Active
Patent Citations (5)
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)
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 |