CN107392560A - A kind of Excel list datas issue acquisition method and system based on internet - Google Patents
A kind of Excel list datas issue acquisition method and system based on internet Download PDFInfo
- Publication number
- CN107392560A CN107392560A CN201610339724.8A CN201610339724A CN107392560A CN 107392560 A CN107392560 A CN 107392560A CN 201610339724 A CN201610339724 A CN 201610339724A CN 107392560 A CN107392560 A CN 107392560A
- Authority
- CN
- China
- Prior art keywords
- data
- reporter
- row
- tables
- frame
- 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
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Storage Device Security (AREA)
Abstract
A kind of Excel list datas issue acquisition method and system based on internet.The method and system are by the tables of data of the importing server of list data, redesign is presented to the interaction table of the web form of reporter, interactive controls are inserted in the cell that need to be filled in, selected control is associated with which row of tables of data again, the form of interactive controls input data is set simultaneously, authentication control and its corresponding row are especially set.When reporter is by browser access interaction table, system can first ask reporter's input authentication information and arrange corresponding with authentication control compares line by line, and the row data than in will be sent to reporter and be safeguarded.It should be noted that addition and modification information are inputted in the interactive controls for the interaction table being previously mentioned, control can carry out format checking to the data made a report on.Each reporter obtains respective data and safeguarded, it is achieved thereby that the easily data interaction of networking.
Description
Technical field
It is more particularly to right the present invention relates to a kind of Excel list datas issue acquisition method and system based on internet
Check or method that reported data people carries out authentication and control of authority.
Background technology
Currently, the management of data highly relies on Excel electrical forms, the management of department of enterprises and institutions in routine office work
The Various types of data that person is collected into is more with the storage of Excel spreadsheets and management.These data are sometimes for being distributed to difference
Crowd checks, them to check, and corrects, supplement, i.e. the issue and collection of data.Current manager's majority is by these data text
Part, which is published in website or discussion group, to be shared, and so each recipient can download to all data, if some
Sensitive data, serious information leakage problem will be produced.On the reception of data, manager, which is substantially, notifies reporter will
Data are dealt into the mailbox specified or received using MSN, or even some is also utilizing USB flash disk transmission.Manager obtains one
Duplication is pasted after each and every one Excel file again and is aggregated into a new table, is downloaded, is opened, is selected, is replicated, is pasted these actions and do not know
Repeat how many times.Simultaneously, it more difficult to ensure the accuracy of reporter's reported data, such as the typing of identification card number, even if filling in a form
When it is carefully conscientious again, also inputed by mistake unavoidably when data volume is big, some managers make Excel masterplates to avoid the hair of such thing
It is raw, but the VBA shell scripts that stamp fabrication is used not are who wants that writing one section just writes one section.This traditional working way
It is time-consuming, laborious, it is accompanied by serious information leakage.Some certain special management systems can complete the network of certain class data
Change management, but its use range is limited, and is not easy accommodation, furthermore its high development cost and cycle also indicate that it is noble
It is exclusive.
The content of the invention
In order to solve the inconvenient problem that various Excel data publications are collected in routine office work.The invention provides one kind side
Just efficiently Excel list datas issue acquisition method and system, and data manager can be allowed simply to carry out Excel data
Distribution and collection.
The technical proposal for solving the technical problem of the invention is a kind of Excel list datas issue based on internet
Acquisition method and system, comprise the following steps：
A, data manager first creates a project, and this project includes two parts of tables of data and interaction table and (or is referred to as
Summary sheet and make a report on table).
B, the tables of data for importing Excel data forms in server database.
C, using a set of interaction table for being used to be presented to reporter of Table edit device design of web form, table style can
Follow one's inclinations design.(also can with Excel Software for Design it is good after upload to system server, the form that system can be parsed into web form enters
Row storage).
D, need to fill in a form the interactive controls set in the cell location insertion system that people fills in interaction table, interaction control
Part has authentication frame, text box, combobox, display box, dat frame, identity card frame, time frame, numerical frame, mailbox frame, phone
Frame etc..Interactive controls are specified to be associated with which row of tables of data, and the call format of input data simultaneously.It is wherein the most key
Be authentication frame setting, how which determine reporter can just have access to the data row oneself to be obtained in tables of data,
Authentication frame with and authentication process itself will be illustrated in next step.Design interaction table, interactive controls and the row completed
Corresponding relation, control input data call format these data are all stored in server database, in case taking.
E, the interaction table to complete can be issued in web site and access link.When reporter accesses this in a browser
During purpose interaction table, server may require that reporter carries out authentication, and verification process is as follows：When reporter asks to access,
Server can analyze the authentication frame control in interaction table, have several authentication frame controls just to automatically generate several input frames
It is sent to the browser of reporter, it is desirable to reporter's validation information.Reporter submits after filling in, and server can be submission
The associated row of authentication frame are compared line by line in information and date table, i.e., search whether current body be present in the column
Part checking information.If not finding this authentication information, represent that current reporter haves no right to access.If it find that matching
OK, server will be sent to all data rows that the match is successful reporter, and reporter's browser is these data rows to arrange
Sheet form is shown, completes authentication process itself.Following reporter's can is added to these data rows, modification and
The attended operations such as deletion.
F, the interaction table designed when reporter's addition, modification in meeting opening steps C, reporter fill in number in interactive controls
According to rear, system can carry out validity checking by default input data call format in step D, and incongruent fill in can be carried
Wake up.When submit knob after server can be handled accordingly in database.
G, the record that different reporters modification each authorizes, and additional new record, these operations can all act on service
Tables of data in device.Project administrator at any time can export as tables of data one Excel form document, do further management.
Brief description of the drawings
The invention will be further described with specific embodiment below in conjunction with the accompanying drawings.
Fig. 1 is present system structure chart.
Fig. 2 is that project of the present invention makes flow chart.
Fig. 3 is reporter of the present invention and server interaction flow chart.
Embodiment
The embodiment of the present invention is described in detail below in conjunction with the accompanying drawings.
As shown in figure 1, it is present system structure chart.The form of Graphic Center is tables of data, the data to be issued and is adopted
The data collected are all stored in this tables of data, and the row of this table are defined as text types, i.e., all data are all in a text form
Preserve, and arbitrarily long data can be held.
Ring-like part is the interaction table for carrying out data interaction with reporter, or to make a report on table.One project can be made
Make multiple interaction tables, different reporter colonies passes through different interaction table accesses and the different row, column data of operation data table.
What annular outside represented is all kinds of reporter colonies, and different reporter colonies passes through different interaction table and data
Table carries out data interaction.
Illustrate this figure：Tables of data is whole school's student information table, and password, student are accessed provided with class, the form master
Name, sex, birthday, several row of home address.Interaction table 1 can be designed as《Student information makes a report on table》, two bodies are inserted in table
Class is respectively associated in frame, student name two arranges for part checking, adds other controls and corresponds to the row such as sex, birthday, home address.Hand over
Mutual table 2 can be set to《Class's student information checks table》, class is respectively associated in two authentication frames of insertion in table, the form master visits
Ask that password two arranges, add other controls and correspond to the row such as student name, sex, birthday, home address.So student's can with
Interaction table 1 interacts, and inputs class and student name and carries out authentication and carrys out the personal information of inquiry maintenance, form master's can with
Interaction table 2 interacts, and inputs class and the form master accesses password and carries out the student information that authentication comes the full class of inquiry maintenance.
As shown in Fig. 2 it is that project of the present invention makes flow chart.Project system is broadly divided into two parts：Generate tables of data
With making interaction table.
Generation tables of data is exactly the tables of data for importing Excel data forms in server database.
The step of making interaction table first makes table sample, can import can also use system form editing machine to design as schemed.Add again
Add interactive controls, set control is associated with which row of tables of data afterwards, be exactly the source of control display data and submit data
Whereabouts, followed by set control input data form, such as numerical frame it is noted that decimal digits, maximum, minimum value, day
Phase frame is noted that the form on date.After one control has added, it is further continued for adding next control.Here it is it should be noted that general
Authentication frame is first set, and its importance can illustrate in figure 3.Preserved after being all provided with, system can incite somebody to action
This interaction table issues the link into website, is accessed for reporter.
If tables of data will also be interacted with the pattern do not expected with another kind of crowd, a set of interaction can be made again
Table.Such as the manager of student's student status information, a set of form on student's personal information can be first made, is interacted with each student,
Student is allowed to supplement the information such as personal identification number, nationality, guardian.Next a set of form can be made again to interact with the form master,
The form master is allowed to complete the examination ＆ verification of numbering and information in the class of full class student.
As shown in figure 3, it is the logical flow chart that reporter of the present invention accesses interaction table.
Reporter enters website by browser, opens the link of interaction table, and now server can be analyzed in interaction table
Authentication frame control, there are several authentication frame controls just to automatically generate the browser that several input frames are sent to reporter,
It is required that reporter's validation information.Reporter submits after filling in, and server can test identity in the information and date table of submission
The associated row of card frame are compared line by line, i.e., search whether current authentication information be present in the column.If no
This authentication information is found, represents that current reporter haves no right to access.If it find that matching row, server will be all
The data row that the match is successful is sent to reporter, and reporter's browser is shown these data rows with tabular form, completes
Authentication process itself.Following reporter's can is added, changes and deletes etc. attended operation to these data rows.
After reporter obtains the data of personal mandate, it can be added, change, deleting etc. and operate.Need to further illustrate
Be modification process, select the data row to be changed, point modification knob, can now open and make a report on table, system can be each columns
According to being filled into interactive controls associated with it.Reporter's can is modified to the data in control, control meeting during submission
Check whether input data meets the data format requirement of setting, it is incongruent to provide prompting.The data complied fully with can be sent
To server.Server completes modification operation in database.
Claims (3)
1. a kind of Excel list datas issue acquisition method and system based on internet, it is characterized in that：
A, the issue collection project of system is made up of two cores of tables of data and interaction table.
B, interaction table is the table forms of html, can be designed by the Table edit device of system web form, also can be existing
Excel forms import, what is particularly pointed out is that Table edit device can insert interactive controls in the cell of interaction table, and can be set
Put the control to associate with a row of tables of data, moreover it is possible to set the call format of input data.
C, the interactive controls mentioned in B include authentication frame, text box, list box, display box, dat frame, identity card frame, number
It is worth frame, time frame, phone frame, it is most important interaction frame to particularly point out authentication frame, and it there can be one or more, respectively
One row of associated data table, it decides the access distribution of tables of data, and before reporter accesses opening interaction table, system, which may require that, fills out
Journalist inputs every checking information, then each row that these information are associated with tables of data authentication frame respectively are compared line by line
Right, the row data that the match is successful will send reporter to, such as can not the match is successful, then illustrate current reporter without access right
Limit, it is impossible to be further continued for operating.
D, after reporter is verified, personal data are shown with tabular form in the server data table of acquirement, work as reporter
When changing certain a line, the interaction table mentioned in B can be ejected, each column data of this line can be shown to interactive controls associated with it
In, when reporter changes data in control, control can carry out form inspection according to the input data call format of its setting to data
Look into, it is undesirable to be prompted.
2. tables of data according to claim 1, it is characterized in that：Tables of data is the storage table in database, will for depositing
The data that reporter and reporter submit are distributed to, data manager can export data as Excel forms at any time and do further
Processing.
3. control according to claim 1 associates with a row of tables of data, it is characterized in that：Establish control and tables of data
The corresponding relation of one row, enables control to show data from the row or the data notification server for inserting control is write into its pass
Connection row, these corresponding relations, which are all stored in database, to be preserved.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610339724.8A CN107392560A (en) | 2016-05-16 | 2016-05-16 | A kind of Excel list datas issue acquisition method and system based on internet |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610339724.8A CN107392560A (en) | 2016-05-16 | 2016-05-16 | A kind of Excel list datas issue acquisition method and system based on internet |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107392560A true CN107392560A (en) | 2017-11-24 |
Family
ID=60338213
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610339724.8A Pending CN107392560A (en) | 2016-05-16 | 2016-05-16 | A kind of Excel list datas issue acquisition method and system based on internet |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107392560A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108897728A (en) * | 2018-06-27 | 2018-11-27 | 平安科技（深圳）有限公司 | Short message splicing processing method, device, computer equipment and storage medium |
| US10977213B2 (en) | 2018-10-10 | 2021-04-13 | International Business Machines Corporation | Maintaining file management systems using cognitive computing |
| CN112799564A (en) * | 2020-07-14 | 2021-05-14 | 珠海金山办公软件有限公司 | Method, device, electronic equipment and medium for inserting control in table |
| CN112965988A (en) * | 2021-02-20 | 2021-06-15 | 杭州品茗安控信息技术股份有限公司 | Data interaction method, device and equipment and computer readable storage medium |
| CN117762957A (en) * | 2023-12-01 | 2024-03-26 | 江苏荣泽信息科技股份有限公司 | Enterprise data intelligent management system based on table form realization |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101075254A (en) * | 2007-06-08 | 2007-11-21 | 北京神舟航天软件技术有限公司 | Autonomous access control method for row-level data of database table |
| CN102722533A (en) * | 2012-05-09 | 2012-10-10 | 浙江图讯科技有限公司 | Method and system for displaying and filling report |
| US20120297462A1 (en) * | 2005-03-16 | 2012-11-22 | Dt Labs, Llc | System, Method and Apparatus for Electronically Protecting Data and Digital Content |
| CN102902767A (en) * | 2012-09-25 | 2013-01-30 | 北京科东电力控制系统有限责任公司 | Method and system for rapidly creating forms |
| CN103955497A (en) * | 2014-04-21 | 2014-07-30 | 常州市珠峰网络科技有限公司 | Data collection summary method for customized table |
| CN104267949A (en) * | 2014-09-25 | 2015-01-07 | 成都国科海博信息技术股份有限公司 | Form designer and form design method |
-
2016
- 2016-05-16 CN CN201610339724.8A patent/CN107392560A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120297462A1 (en) * | 2005-03-16 | 2012-11-22 | Dt Labs, Llc | System, Method and Apparatus for Electronically Protecting Data and Digital Content |
| CN101075254A (en) * | 2007-06-08 | 2007-11-21 | 北京神舟航天软件技术有限公司 | Autonomous access control method for row-level data of database table |
| CN102722533A (en) * | 2012-05-09 | 2012-10-10 | 浙江图讯科技有限公司 | Method and system for displaying and filling report |
| CN102902767A (en) * | 2012-09-25 | 2013-01-30 | 北京科东电力控制系统有限责任公司 | Method and system for rapidly creating forms |
| CN103955497A (en) * | 2014-04-21 | 2014-07-30 | 常州市珠峰网络科技有限公司 | Data collection summary method for customized table |
| CN104267949A (en) * | 2014-09-25 | 2015-01-07 | 成都国科海博信息技术股份有限公司 | Form designer and form design method |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108897728A (en) * | 2018-06-27 | 2018-11-27 | 平安科技（深圳）有限公司 | Short message splicing processing method, device, computer equipment and storage medium |
| US10977213B2 (en) | 2018-10-10 | 2021-04-13 | International Business Machines Corporation | Maintaining file management systems using cognitive computing |
| CN112799564A (en) * | 2020-07-14 | 2021-05-14 | 珠海金山办公软件有限公司 | Method, device, electronic equipment and medium for inserting control in table |
| CN112965988A (en) * | 2021-02-20 | 2021-06-15 | 杭州品茗安控信息技术股份有限公司 | Data interaction method, device and equipment and computer readable storage medium |
| CN117762957A (en) * | 2023-12-01 | 2024-03-26 | 江苏荣泽信息科技股份有限公司 | Enterprise data intelligent management system based on table form realization |
| CN117762957B (en) * | 2023-12-01 | 2024-07-09 | 江苏荣泽信息科技股份有限公司 | Enterprise data intelligent management system based on table form realization |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109558575B (en) | Online form editing method, online form editing device, computer equipment and storage medium | |
| CN107392560A (en) | A kind of Excel list datas issue acquisition method and system based on internet | |
| CN107886439A (en) | Insurance products development approach, device, equipment and computer-readable recording medium | |
| CN104123227A (en) | Method for automatically generating testing cases | |
| CN111767095A (en) | Micro-service generation method and device, terminal equipment and storage medium | |
| CN107544808A (en) | The generation method and device of a kind of web form | |
| Ali et al. | A framework to implement data cleaning in enterprise data warehouse for robust data quality | |
| WO2019218597A1 (en) | Automatic construction method and system for table driven cloud-model software | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| CN110008447A (en) | The processing method and processing device of electrical form | |
| CN111367982B (en) | Method, device, computer equipment and storage medium for importing TRRIGA basic data | |
| CN115544183A (en) | Data visualization method and device, computer equipment and storage medium | |
| CN101976394A (en) | Data acquiring and counting system and method | |
| CN116541372A (en) | Data asset management method and system | |
| CN114385722A (en) | Interface attribute consistency checking method and device, electronic equipment and storage medium | |
| WO2021013057A1 (en) | Data management method and apparatus, and device and computer-readable storage medium | |
| CN109255587A (en) | A kind of cooperative processing method and device of operational data | |
| CN114547204A (en) | Data synchronization method and device, computer equipment and storage medium | |
| CN110737432A (en) | script aided design method and device based on root list | |
| US20210326368A1 (en) | Workflow-based dynamic data model and application generation | |
| CN117078181A (en) | Automatic method and system for power transaction business data processing flow | |
| CN115495452A (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN112800127B (en) | Data mining analysis method and device based on transaction bill | |
| CN109669936A (en) | A kind of mass data quality report generation method based on polymerization model | |
| CN115293685A (en) | Logistics order state tracking method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| DD01 | Delivery of document by public notice |
Addressee: Yang Guocheng Document name: Notification of Passing Preliminary Examination of the Application for Invention |
|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20171124 |
|
| WD01 | Invention patent application deemed withdrawn after publication |