CN109948132A - A kind of data of configuration template make a report on method and system - Google Patents

A kind of data of configuration template make a report on method and system Download PDF

Info

Publication number
CN109948132A
CN109948132A CN201910202563.1A CN201910202563A CN109948132A CN 109948132 A CN109948132 A CN 109948132A CN 201910202563 A CN201910202563 A CN 201910202563A CN 109948132 A CN109948132 A CN 109948132A
Authority
CN
China
Prior art keywords
template
report
data
field
database
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
Application number
CN201910202563.1A
Other languages
Chinese (zh)
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.)
Space Cloud Network Technology Development LLC
Original Assignee
Space Cloud Network Technology Development LLC
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 Space Cloud Network Technology Development LLC filed Critical Space Cloud Network Technology Development LLC
Priority to CN201910202563.1A priority Critical patent/CN109948132A/en
Publication of CN109948132A publication Critical patent/CN109948132A/en
Pending legal-status Critical Current

Links

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The present invention relates to a kind of data of configuration template to make a report on method and system, which comprises template field configuration information is arranged according to Table Header information;Database table corresponding with template is created, the field of database table includes fixed field and the template field configuration information;In the first client New Report, the database table of creation is introduced, fills in report name, and is associated with corresponding template;User carries out data by template Table Header information and fills in the second client downloads template, then uploads spread-sheet data file, and the data wherein filled in are written in corresponding database table background server.This method makes a report on software without making a report on demand customized development for data accordingly, but each customized development is become general implementation and is configured, and reduces software customized development and maintenance cost.The present invention also provides a kind of systems based on the above method, have above-mentioned beneficial effect.

Description

A kind of data of configuration template make a report on method and system
Technical field
The present invention relates to data to make a report on technical field, and in particular, to a kind of data of configuration template make a report on method and are System.
Background technique
It is versatility demand that many companies can all face that data, which are made a report on,.In the prior art, it usually needs for different Data make a report on demand customized development, easily change however, making a report on demand due to data, cause to make a report on opening for software for this kind of data Hair and maintenance cost are high.
Summary of the invention
The technical problem to be solved by the present invention is to provide a kind of data of configuration template to make a report on method and system, can be realized nothing Customized development is needed, as long as implementing configuration, data can be easily carried out and make a report on.
The data that the present invention provides a kind of configuration template make a report on method, including
Step 1: configuration template
Template is electronic form file, provides Table Header information by user in template, implementation personnel are arranged according to Table Header information Template field configuration information;
Step 2: creation database table
Implementation personnel create database table corresponding with the template in the database, and the field of database table includes to fix Field and the template field configuration information, the fixed field include major key;
Step 3: configuration report
Implementation personnel are introduced into the database table created in step 2, fill in report name in the first client New Report, And corresponding template in associated steps 1;
Step 4: data are made a report on
The report that user makes a report on as needed in the second client downloads corresponding template;It is carried out by template Table Header information Data are filled in, and spread-sheet data file is formed;User uploads spread-sheet data file, and background server receives electronic watch After lattice data file, the data that will be filled in spread-sheet data file are written in corresponding database table.
Optionally, template field configuration information is arranged according to Table Header information in the step 1, be included in below Table Header information It is inserted into a line, inserts corresponding field name, while the field name as database table in step 2.
Optionally, the step 2 further include cannot duplicate field setting index to combination in database table.
Optionally, after the database table for implementing personnel's introducing creation in the step 3, cycle request is made a report on according to business and is set Set whether cycle information, the data that user reports on a second client can according to the cycle information classify list.
Optionally, the electronic form file can be Excel table, WPS table, the table based on Excel, be based on Any one of table of WPS.
The present invention also provides a kind of data of configuration template to make a report on system, comprising: the first client, background server and Second client;
The background server is used for,
Configuration template, template are electronic form file, provide Table Header information by user in template, implement personnel according to gauge outfit Template field configuration information is arranged in information;
Database table is created, implements personnel and creates database table corresponding with the template, database table in the database Field include fixed field and the template field configuration information, the fixed field include major key;
First client is used for,
Report is configured, implements personnel's New Report, is introduced into the database table created in background server, fills in report name Claim, and is associated with corresponding template in background server;
Second client is used for,
Data are made a report on, and the report that user makes a report on as needed in the second client downloads corresponding template;By template gauge outfit Information carries out data and fills in, and forms spread-sheet data file;User uploads spread-sheet data file, and background server receives To after spread-sheet data file, the data that will be filled in spread-sheet data file are written in corresponding database table.
Optionally, template field configuration information is arranged according to Table Header information in the background server, is included in gauge outfit letter A line is inserted into breath lower section, inserts corresponding field name, while the database table field name as creation.
Optionally, further including in the background server cannot duplicate field setting index to combination in database table.
Optionally, after the database table for implementing personnel's introducing creation in first client, the period is made a report on according to business It is required that setting whether cycle information, the data that user reports on a second client can according to the cycle information classify list.
Optionally, the electronic form file can be Excel table, WPS table, the table based on Excel, be based on Any one of table of WPS.
Technical solution provided by the invention has the advantages that through configuration template, creates corresponding to the template Database table, without making a report on demand customized development for data, but each customized development is become into general implementation Configuration, reduces software customized development and maintenance cost.
Detailed description of the invention
Fig. 1 is the flow chart of the method for the present invention;
Fig. 2~Fig. 3 is the oracle database table setting figure used in the present invention;
Fig. 4~Fig. 8 is schematic diagram of a scenario when implementing report configuration method provided by the invention;
Specific embodiment
Below in conjunction with attached drawing, detailed description of the preferred embodiments.It should be understood that this place is retouched The specific embodiment stated is merely to illustrate and explain the present invention, and is not intended to restrict the invention.
It is worth noting that description and claims of this specification and term " first " in above-mentioned attached drawing, " Two " etc. be to be used to distinguish similar objects, without being interpreted as specific sequence or precedence.
Fig. 1 is that a kind of data of configuration template provided in an embodiment of the present invention make a report on the flow chart of method, as shown in Figure 1, This method comprises:
Step 1: configuration template
Template is electronic form file, can be Excel table, WPS table, the table based on Excel, based on WPS's Any one of table.The present embodiment uses excel template.When establishing excel template, the first behavior user provides gauge outfit letter Breath;Remarks explanation of second behavior to Table Header information;The third line is the Database field name being arranged according to Table Header information, due to this Embodiment uses oracle database, and field name must be entirely capitalization ();It carries out since fourth line by user's filler According to program is to read data since fourth line to import, the word that the sequence of each field must be established with corresponding data table in template Section sequence consensus and number it is identical (except fixed field).
In the present embodiment Excel template, the excel file format of importing must be by excel2003 2,007 two versions The format of generation, version if it is 2007 or more or be WPS version file, when carrying out data preservation, it is necessary to be to want Selection generates: excel97-2003 format, program could be imported and be downloaded.
Step 2: creation database table
Must there are major key, upper successor, uplink time field in each newly-established tables of data, as shown in the table in detail:
Field Field type Field annotation
CGUID VARchar2(36) CGUID
CREATOR VARchar2(50) Upper successor
CREATETIME VARchar2(50) Uplink time
When establishing tables of data, all fields are related to being the types such as number, time, all unify to set type when establishing Be set to: VARCHAR2 (xxx), field length is configured according to actual content, because being all fields of Dynamic Matching, Type can only be all uniformly processed by character string.
The annotation and excel template field name for filling in each field are consistent, for the table letter when implementing personnel depaly The display of breath.Field annotates in Chinese character, should not be with spcial characters such as carriage return, line feed, and otherwise dynamic column can not show.
Database table naming rule: EXCE_USER_XXXX.Wherein EXCE_USER is prefix, and XXXX represents oneself business Table name, while when establishing field, in order to identical as the order of the field in Excel template, when newly-built, by Excel template It puts in order and is created.
It must be provided with the index value of the not field for sky, multiple fields can be once set simultaneously in an index.Setting After the completion, in implementing human interface, when obtaining this table, keyword message can be shown automatically, without carrying out again manually Modification, it is only necessary to which whether filter condition value arranges for modification.Keyword is mainly used for carrying out verifying use when data import, such as Fig. 2 institute Show.
In index bookmark, the field of required setting is selected in setting column, type column is chosen to: Unique。
If field that cannot be empty, it is necessary to which being configured to be sky, verified when for importing data.Such as Fig. 3 institute Show.
Step 3: configuration report
Implementation personnel carry out safeguarding the configuration of all report templates, upload user Tentative Study of Achievement of Manipulation on Excel template in the first client Function, main interface such as Fig. 4.In this interface, including data are newly-increased, modification, the operation such as delete, upload template, in table Including information have: the fields such as data table name, title, affiliated template, excel template, remarks, founder, creation time.
Data table name: being the title of tables of data in correspondence database.
Title: the Chinese annotation of corresponding data table.
Affiliated template: after logging in active user, the data filtered by further menu permission are carried out.Such as: manpower Resource, project management etc..
Excel template: for depositing the corresponding upload data template title of current report.In user interface, press Affiliated template rights are filtered.
After opening implementation personnel operation interface, [newly-increased] button is first clicked on, the newly-increased operation of data is carried out, at newly-increased interface In, then hand input-data table name, i.e. table name in correspondence database first are clicked acquisition button again, are carried out to this table Field information showed, obtain as shown in Figure 5.
After obtaining field data, the information such as List of input title, affiliated template.Field name, type in table, meaning Automatic filling.When whether key column is by establishing tables of data, filled automatically by the unique index value of setting, if mistake Filter condition is chosen whether by double-clicking drop-down manually, is saved after the completion.
Fig. 4 is returned to after preservation, chooses just now newly-increased record, and click and [upload template] button is after the completion of template uploads Template name can be filled back excel template in Fig. 4 automatically and arranged by system.
Step 4: data are made a report on
User operation, the interface such as carries out importing data, checks data, checks log, downloads template in the second client Such as Fig. 6.The left side Fig. 6 list data is according to currently logging in the permission of personnel, is condition according to affiliated template, is filtered out pair The excel template that the implementation personnel answered upload.The table on the right be according in implementation personnel's setting table whether filtered fields, be The automatic addition of system is upper: upper successor, uplink time, batch field carry out dynamic and show.
The electronic form template provided when user uses for the first time in Fig. 6 downloading implementation personnel;It is then filled out data.Then point Hit [uploading data] button in Fig. 6.Background server can judge that user uploads template and current selection report in the process It is template used whether consistent, judge whether matching field is arranged data, including length, type and unique constraints, error message Such as Fig. 7 is shown with log information.If importing successful system provides prompt, upload record information can be shown in Fig. 6, including upper Successor, uplink time etc..Data after upload can check, delete, as shown in Figure 8.
In addition, the present invention also provides the data of configuration template a kind of make a report on system, the system include the first client, after Platform server and the second client.Each section of the system can be realized each step of above-described embodiment, not repeat herein.
It can be seen that the method for the present invention from above the present embodiment and system be not necessarily to make a report on demand customized development phase for data That answers makes a report on software, but each customized development is become general implementation and is configured, and reduces software customized exploitation and dimension Protect cost.It is described the prefered embodiments of the present invention in detail above in conjunction with attached drawing, still, the present invention is not limited to above-mentioned implementations Detail in mode can carry out technical solution of the present invention a variety of simple within the scope of the technical concept of the present invention Modification, these simple variants all belong to the scope of protection of the present invention.

Claims (10)

1. a kind of data of configuration template make a report on method characterized by comprising
Step 1: configuration template
Template is electronic form file, provides Table Header information by user in template, implements personnel according to Table Header information and template is arranged Field configuration information;
Step 2: creation database table
Implementation personnel create database table corresponding with the template in the database, and the field of database table includes fixed field With the template field configuration information, the fixed field includes major key;
Step 3: configuration report
Implementation personnel are introduced into the database table created in step 2 in the first client New Report, fill in report name, and close Join corresponding template in step 1;
Step 4: data are made a report on
The report that user makes a report on as needed in the second client downloads corresponding template;Data are carried out by template Table Header information It fills in, forms spread-sheet data file;User uploads spread-sheet data file, and background server receives electrical form number After file, the data that will be filled in spread-sheet data file are written in corresponding database table.
2. the method according to claim 1, wherein template field is arranged according to Table Header information in the step 1 Configuration information is included in below Table Header information and is inserted into a line, inserts corresponding field name, while as database in step 2 The field name of table.
3. the method according to claim 1, wherein the step 2 further includes cannot to combination in database table Duplicate field setting index.
4. the method according to claim 1, wherein implementing the database that personnel introduce creation in the step 3 After table, according to business make a report on cycle request setting whether cycle information, data that user reports on a second client can be according to should Cycle information classification lists.
5. method according to claim 1 to 4, which is characterized in that the electronic form file can be Any one of Excel table, WPS table, the table based on Excel, table based on WPS.
6. a kind of data of configuration template make a report on system characterized by comprising the first client, background server and second Client;
The background server is used for,
Configuration template, template are electronic form file, provide Table Header information by user in template, implement personnel according to Table Header information Template field configuration information is set;
Database table is created, implements personnel and creates database table corresponding with the template, the word of database table in the database Section includes fixed field and the template field configuration information, and the fixed field includes major key;
First client is used for,
Report is configured, implements personnel's New Report, is introduced into the database table created in background server, fills in report name, and It is associated with corresponding template in background server;
Second client is used for,
Data are made a report on, and the report that user makes a report on as needed in the second client downloads corresponding template;By template Table Header information It carries out data to fill in, forms spread-sheet data file;User uploads spread-sheet data file, and background server receives electricity After sub-table data file, the data that will be filled in spread-sheet data file are written in corresponding database table.
7. system according to claim 6, which is characterized in that template is arranged according to Table Header information in the background server Field configuration information is included in below Table Header information and is inserted into a line, inserts corresponding field name, while the data as creation Library literary name name section.
8. system according to claim 6, which is characterized in that further include to group in database table in the background server Closing cannot duplicate field setting index.
9. system according to claim 6, which is characterized in that implement the number that personnel introduce creation in first client After the table of library, according to business make a report on cycle request setting whether cycle information, data that user reports on a second client can root It is listed according to cycle information classification.
10. system according to any one of claims 6 to 9, which is characterized in that the electronic form file can be Any one of Excel table, WPS table, the table based on Excel, table based on WPS.
CN201910202563.1A 2019-03-18 2019-03-18 A kind of data of configuration template make a report on method and system Pending CN109948132A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910202563.1A CN109948132A (en) 2019-03-18 2019-03-18 A kind of data of configuration template make a report on method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910202563.1A CN109948132A (en) 2019-03-18 2019-03-18 A kind of data of configuration template make a report on method and system

Publications (1)

Publication Number Publication Date
CN109948132A true CN109948132A (en) 2019-06-28

Family

ID=67008908

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910202563.1A Pending CN109948132A (en) 2019-03-18 2019-03-18 A kind of data of configuration template make a report on method and system

Country Status (1)

Country Link
CN (1) CN109948132A (en)

Cited By (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110399420A (en) * 2019-07-30 2019-11-01 广州吉信网络科技开发有限公司 A kind of deriving method, electronic equipment and the medium of configurableization Excel format
CN110569241A (en) * 2019-07-26 2019-12-13 上海百检网络技术有限公司 application form processing method, server and user side
CN110636049A (en) * 2019-08-27 2019-12-31 南京理工大学 General message organization and transmission method for software communication interface
CN111143358A (en) * 2019-12-13 2020-05-12 航天信息股份有限公司 Report configuration method and system
CN111291302A (en) * 2020-03-20 2020-06-16 成都药王科技股份有限公司 Method for quickly creating active page
CN111476016A (en) * 2020-04-15 2020-07-31 北京思特奇信息技术股份有限公司 Template configuration method for package tariff in telecommunication industry
CN111597261A (en) * 2020-05-12 2020-08-28 广东巴金斯科技有限公司 Data declaration form making system, method and storage medium
CN111833981A (en) * 2020-04-30 2020-10-27 宁波市科技园区明天医网科技有限公司 Structured report making and compiling method
CN112464632A (en) * 2020-11-27 2021-03-09 四川科瑞软件有限责任公司 Form style dynamic storage and conversion method under excel report
CN112507672A (en) * 2020-12-23 2021-03-16 安徽航天信息有限公司 Payroll data acquisition method, device, system and storage medium
CN112749092A (en) * 2021-01-13 2021-05-04 叮当快药科技集团有限公司 Information processing method for managing software bugs
CN112836478A (en) * 2020-11-09 2021-05-25 上海德拓信息技术股份有限公司 Scattered data acquisition and application method
CN113011142A (en) * 2021-03-11 2021-06-22 南京信息职业技术学院 Excel document intelligent filling system and method based on RPA
CN113836864A (en) * 2021-08-26 2021-12-24 广西电网有限责任公司来宾供电局 Development work order content comparison method and system
CN114997808A (en) * 2021-12-19 2022-09-02 中国铁道科学研究院集团有限公司电子计算技术研究所 Railway construction scheduling brief generation method and system
CN115081416A (en) * 2022-08-23 2022-09-20 中科科界(北京)科技有限公司 Voting generation method and device based on file parsing transcoding and configuration

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140075279A1 (en) * 2012-09-13 2014-03-13 Samir Issa Data-Value Centered Programming
CN104239366A (en) * 2013-06-21 2014-12-24 苏州精易会信息技术有限公司 Spreadsheet data management method based on C/S mode
CN105893040A (en) * 2016-03-30 2016-08-24 南京信息工程大学 Variable statement generation method and system based on EXCEL templates
CN105956679A (en) * 2016-07-01 2016-09-21 邹春秋 Network booking tour guide service providing method

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140075279A1 (en) * 2012-09-13 2014-03-13 Samir Issa Data-Value Centered Programming
CN104239366A (en) * 2013-06-21 2014-12-24 苏州精易会信息技术有限公司 Spreadsheet data management method based on C/S mode
CN105893040A (en) * 2016-03-30 2016-08-24 南京信息工程大学 Variable statement generation method and system based on EXCEL templates
CN105956679A (en) * 2016-07-01 2016-09-21 邹春秋 Network booking tour guide service providing method

Cited By (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110569241A (en) * 2019-07-26 2019-12-13 上海百检网络技术有限公司 application form processing method, server and user side
CN110399420A (en) * 2019-07-30 2019-11-01 广州吉信网络科技开发有限公司 A kind of deriving method, electronic equipment and the medium of configurableization Excel format
CN110399420B (en) * 2019-07-30 2022-11-22 广州吉信网络科技开发有限公司 Export method, electronic equipment and medium of configurable Excel format
CN110636049A (en) * 2019-08-27 2019-12-31 南京理工大学 General message organization and transmission method for software communication interface
CN111143358A (en) * 2019-12-13 2020-05-12 航天信息股份有限公司 Report configuration method and system
CN111291302A (en) * 2020-03-20 2020-06-16 成都药王科技股份有限公司 Method for quickly creating active page
CN111476016A (en) * 2020-04-15 2020-07-31 北京思特奇信息技术股份有限公司 Template configuration method for package tariff in telecommunication industry
CN111833981A (en) * 2020-04-30 2020-10-27 宁波市科技园区明天医网科技有限公司 Structured report making and compiling method
CN111597261A (en) * 2020-05-12 2020-08-28 广东巴金斯科技有限公司 Data declaration form making system, method and storage medium
CN112836478A (en) * 2020-11-09 2021-05-25 上海德拓信息技术股份有限公司 Scattered data acquisition and application method
CN112464632A (en) * 2020-11-27 2021-03-09 四川科瑞软件有限责任公司 Form style dynamic storage and conversion method under excel report
CN112464632B (en) * 2020-11-27 2023-07-14 四川科瑞软件有限责任公司 Dynamic storage and conversion method for table style under excel report
CN112507672A (en) * 2020-12-23 2021-03-16 安徽航天信息有限公司 Payroll data acquisition method, device, system and storage medium
CN112749092A (en) * 2021-01-13 2021-05-04 叮当快药科技集团有限公司 Information processing method for managing software bugs
CN113011142A (en) * 2021-03-11 2021-06-22 南京信息职业技术学院 Excel document intelligent filling system and method based on RPA
CN113011142B (en) * 2021-03-11 2023-06-27 南京信息职业技术学院 Intelligent Excel document filling system and method based on RPA
CN113836864A (en) * 2021-08-26 2021-12-24 广西电网有限责任公司来宾供电局 Development work order content comparison method and system
CN114997808A (en) * 2021-12-19 2022-09-02 中国铁道科学研究院集团有限公司电子计算技术研究所 Railway construction scheduling brief generation method and system
CN115081416A (en) * 2022-08-23 2022-09-20 中科科界(北京)科技有限公司 Voting generation method and device based on file parsing transcoding and configuration

Similar Documents

Publication Publication Date Title
CN109948132A (en) A kind of data of configuration template make a report on method and system
CN109558575B (en) Online form editing method, online form editing device, computer equipment and storage medium
CN110196971A (en) Online document edit methods, device, terminal device and storage medium
JP4004825B2 (en) Information extraction and sharing device
US8271531B2 (en) Employee tracking system
DE60029567T2 (en) DIGITAL DATA MANAGEMENT AND IMAGE MANUFACTURING SYSTEM AND METHOD WITH SECURED DATA MARKING
CN111259006A (en) Universal distributed heterogeneous data integrated physical aggregation, organization, release and service method and system
CN107015804B (en) Method and system for rapidly developing project by configuring API
US20080313260A1 (en) Automated website generation
US10354080B2 (en) Facilitating offline or other contemporaneous editing of tabular data
US10817662B2 (en) Expert system for automation, data collection, validation and managed storage without programming and without deployment
CN111143358A (en) Report configuration method and system
EP2178033A1 (en) Populating a multi-relational enterprise social network with disparate source data
WO2003088032A1 (en) Data exchange method and system
CN102646039A (en) Software interface generating system and method based on extensible markup language (XML) Schema
US20100088351A1 (en) Import and merge of categorization schemas
CN105224544A (en) A kind of data editing method of database and device
CN105205757A (en) Android-based elective system
CN108536745A (en) Tables of data extracting method, terminal, equipment and storage medium based on Shell
CN106815366A (en) A kind of method and system of Mass production data
CN110008447A (en) The processing method and processing device of electrical form
CN109189849B (en) Standardized and streamlined data entry method and system
CN106845766A (en) Information collecting method
US20030163465A1 (en) Processing information about occurrences of multiple types of events in a consistent manner
CN110020414A (en) A kind of electronic contract document creation method, system

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20190628