CN101149737A - Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word - Google Patents
Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word Download PDFInfo
- Publication number
- CN101149737A CN101149737A CNA2007100743521A CN200710074352A CN101149737A CN 101149737 A CN101149737 A CN 101149737A CN A2007100743521 A CNA2007100743521 A CN A2007100743521A CN 200710074352 A CN200710074352 A CN 200710074352A CN 101149737 A CN101149737 A CN 101149737A
- Authority
- CN
- China
- Prior art keywords
- list
- database
- automatically
- data table
- web
- 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
- 238000000034 method Methods 0.000 title claims abstract description 24
- 230000008676 import Effects 0.000 claims description 6
- 230000015572 biosynthetic process Effects 0.000 claims description 2
- 238000000151 deposition Methods 0.000 claims 1
- 238000004321 preservation Methods 0.000 claims 1
- 238000012216 screening Methods 0.000 claims 1
- 230000002195 synergetic effect Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000011159 matrix material Substances 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method to rapid set up the web table list and automatically builds the corresponding datasheet in the database through Microsoft Word. Software users do not need to do cumbersome design of table list with professional web development tools or other software, can quickly establish the web table list and database applications according to word tables, and thereby make the complicated and professional work become very easy.
Description
Technical field
The software user need not carry out loaded down with trivial details list design in the web of specialty developing instrument or other software, the application that can fast set up web list and database according to the word form, thus with complexity loaded down with trivial details and also professional extremely strong work become very easy.
Technical background
The synergetic office work platform is that a company information is handled and the set of managing.In platform, list is the core of all functions module, it simultaneously also is the data carrier in the operation flow, medium long shot synergetic office work platform can be (Word files) such as the various worksheets in the routine work, professional cards a masterplate simply, is converted into the Web list and stores in the system database by shirtsleeve operation.Thereby the management table that is difficult to retrieve in numerous PC at random is converted into classification and storage, and Web list that be easy to retrieve, high safety is realized office with no paper at all, is the digitized embodiment of office automation.The more important thing is, packet that can't query statistic in the original list is dressed up the data that can carry out data mining, analytic statistics.All page elements and pattern all generate by the mode of What You See Is What You Get on the list, it is the design of interpolation one by one by field that traditional list produces and generates process, repeat to set up field and form needed page elements, again by the online html editing machine of other third parties design pattern, revise repeatedly then and adjust the page elements position, and form a list that meets demand, traditional approach has to carry out a plurality of necessary steps, program is loaded down with trivial details, duplicates the situation that can not get qualified list in the operating process easily.At this problem, purpose of the present invention just is based on the dynamic list generation technique of template engine, and a kind of method of directly setting up the web list fast by Microsoft Word and create the corresponding data table automatically in database is provided.With complexity loaded down with trivial details and also professional extremely strong work become very easy.Help increasing work efficiency, cost saves time.
Summary of the invention
The invention discloses and a kind ofly set up the web list fast and automatically in database, set up the method for corresponding data table by Microsoft Word.The software user need not carry out loaded down with trivial details list design in the web of specialty developing instrument or other software, the application that can fast set up web list and database according to the word form, thus with complexity loaded down with trivial details and also professional extremely strong work become very easy.
The present invention is achieved by the following technical solutions, make the word file, save as garbled webpage format, enter the synergetic office work platform, newly-increased list in master meter list definition basic setup, after filling in the list essential information, preserve, import front garbled webpage format word form by the list template, compiling, form the initial table single model, again by basic, advanced property setting to field, final formation can be edited the list of use.
Description of drawings
Fig. 1 operational flowchart of the present invention
Fig. 2 makes the word file
Fig. 3 is the word garbled webpage format that saves File As
Fig. 4 is newly-increased definition list in system
Fig. 5 sets up the essential information of list
Fig. 6 preserves the essential information of list
Fig. 7 browses the importing list by this locality in the list template
Fig. 8 selects garbled webpage format file
Fig. 9 compiles list
Figure 10 compiles success
Figure 11 field base attribute is provided with
Figure 12 preserves setting
Figure 13 field advanced property is provided with
Figure 14 preserves setting
The preview of Figure 15 list
Embodiment
As shown in Figure 1:
Step 1 is for making the word file
Step 2 is for to save as garbled webpage format with the word file
Step 3 is newly-increased definition list
Step 4 is for filling in the list essential information
Step 5 is for preserving the essential information of list
Step 6 is for to browse the importing list by this locality in the list template
Step 7 saves as garbled webpage format file for selecting in the local file
Step 8 is for clicking " compiling " button compiling list
Step 9 is for successfully compiling list
Step 11 is for preserving the setting of base attribute
Step 12 is for carrying out the advanced property setting of field
Step 13 is for preserving the setting of advanced property
Step 14 is the preview of list
As shown in Figure 2, make the word file, at first draw the word form, then according to demand to related symbol, form, the function of form definition list individual character section.Each symbol can only account for a character, promptly must be under English state when using the symbol definition field incoming symbol.
The symbol of field, form, function are summarized as follows:
1, the using form of symbol [] is [field name], and its function is a define field, must be provided with in independent cell;
2, the using form of { } () is { field name } (numeral), and its function is define field and number of characters, and the number of characters in () must be filled in.If the advanced property of field will be set to edit list, check tabulation or editor's grid.Then this field must be with character [] definition, and can not define the width that this field of the numeral of () lining shows with ();
3, using form is a title name, and its function is the title of definition list, and behind the import system, form is: black matrix, No. four.
As shown in Figure 3, save as garbled webpage format.
As shown in Figure 4, in the definition of master meter list, click " increasing newly " button, newly-increased definition list.
As shown in Figure 5, fill in the list essential information, title, version number, classification etc.
As shown in Figure 6, preserve the list essential information, determine to preserve successfully.
As shown in Figure 7, in the list template, import list, click " browsing ", browse local file.
As shown in Figure 8, select through garbled webpage format behind Fig. 3.
As shown in Figure 9, the compiling list, the mark in the automatic program identification word file, and form the list template.
As shown in figure 10, determine to compile successfully.
As shown in figure 11, carry out the setting of field base attribute, data type in the base attribute and precision are provided with, wherein data type comprises: character string, integer, floating number, fixed precision, the amount of money, date, big text.Wherein dtd is as follows:
1. character string is the most common, is used to write down relatively shorter Word message;
2. this field of integer representation can only typing integer data, and this type can participate in the data computation in the list;
3. but floating number is represented this field typing integer or little logarithmic data, generally is used for currency, the amount of money, and this type can participate in the data computation in the list;
4. fixed precision is represented the figure place of this field fixed integer or decimal, and this type can participate in the data computation in the list;
5. the amount of money represents that the data of this field are amount of money type, and this type can participate in the data computation in the list;
6. the date represents that this field is a date format, and this type can not participate in the data computation in the list;
7. big text is specifically designed to the typing of big section literal, and this type can not participate in the data computation in the list.Accuracy value is represented the number of characters that this field can the typing content.When the data type of field was fixed precision, the form of accuracy value should be: total bit keeps scale; As: the numerical value in the precision is 7,2 o'clock, represents that the integral part of data in this field can not be greater than 5, and scale keeps 2.Explanation of field is represented this field is done a little notes, helps to understand the purposes of this field.
As shown in figure 12, preserve the base attribute setting, determine to preserve successfully.
As shown in figure 13, carry out the advanced property setting of field, the field advanced property is forgiven the setting of control type to field, control parameter, default value, checking function, display format, alignment thereof.Data type has all defined data type for each field when this attribute of definition list individual character segment base.Can not revise herein; It is described below:
1, the control type is the main foundation of control field characteristic, should understand each field content to be expressed in the list earlier before definition, and the control type effect that can reach.According to the difference of the data type of field, alternative control type is also different.The control type have " standard input frame, multiple-line entry box, read-only input frame, drop-down data dictionary, only select combobox, can import combobox, drop-down tables of data, eject that tables of data is selected, Radio Dan Xuan-laterally, Radio Dan Xuan-vertically, automatic numbering, append suggestion, result of calculation, picture, web page contents, annex, notify the people, Word editing machine, Excel editing machine, relevant list rreturn value, edit list, check tabulation, edit grid, date ".
2, the control parameter mainly is the parameter that the control type is set.In the control type, select " multiple-line entry box " as us, just must be in the control parameter integer more than the typing 2 or 2, control the space size of importing of this field.
3, default value list is shown in the selected default value content of the automatic generation of system's meeting when opening list, need not typing, selects.
The most frequently used default value has following several:
Current date, login people name, login people department, login people account number, login people post, login people job number etc.
4, whether the data of checking function representation checking user input are legal, and provide corresponding prompt.
5, display format is primarily aimed at the setting of figure place after the order and amount of money radix point before and after the date.
6, alignment thereof, the field name position in list mainly contains left-justify, Right Aligns and justified.
As shown in figure 14, preserve the setting of field advanced property, and confirm to preserve.
As shown in figure 15, the preview list after test, can come into operation.
Claims (16)
1. method of setting up the web list fast by Microsoft Word and automatically in database, setting up the corresponding data table, the software user need not carry out loaded down with trivial details list design in the web of specialty developing instrument or other software, the application that can set up web list and database according to the word form fast, thereby with complexity loaded down with trivial details and also professional extremely strong work become very easy, it is characterized in that, the user sets up the Word file in Microsoft Word, and according to certain regular mark need typing in the web list that generates data, save as garbled webpage by Word then, and this webpage compiled as template, mark in the automatic program identification word file, and with these marks as Database field automatically generated data table.
2. this system method of generating the web list automatically and setting up tables of data automatically comprises following steps at least.
1. make the word file.
2. depositing the word file in addition is garbled webpage, the select File menu-＞save as webpage-＞in the dialog box that ejects, select to preserve type and be: garbled webpage (
*.htm;
*.html)-＞determine that preserving file is XXX.html.
3. the establishment of list, open standard menu-＞the list flow definition-＞master meter list definition, click " increase " button, the establishment list.
4. enter basic setup-＞the list attribute in, title and other essential informations of filling in list.
5. click " preservation " button, confirm to preserve.
6. basic setup-＞the list template, import list, click the Browse button.
7. the ejection select File is selected garbled webpage format file in the step 2.
8. click " compiling ", list is compiled.
9. ejection prompting frame, click OK determines that list compiles successfully.
10. basic setup-＞the field base attribute, " data type ", " explanation of field " and " precision " are set.
11. preserve the setting of field base attribute.
12. basic setup-＞the field advanced property, to the setting of the control type of field, control parameter, default value, checking function, display format, alignment thereof.
13. preserve the setting of field advanced property
14. the formation list, preview.
3. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table, it is characterized in that in the step 1, draw the web form, make the word file by Microsoft Word by Microsoft Word.
4. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table by Microsoft Word, it is characterized in that in the step 2, the word file is saved as the webpage format that can screen, and purpose is the fair surplus code in the webpage is removed.
5. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table, it is characterized in that clicking in the step 3 " increase " button establishment list by Microsoft Word.
6. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table by Microsoft Word, it is characterized in that in the step 4, by the basic setup of list attribute, import form name, set up the essential information of list.
7. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table, it is characterized in that in the step 5, confirm that the essential information of list is preserved by Microsoft Word.
8. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table, it is characterized in that in the step 6, from the list template, click " browsing ", open local file by Microsoft Word.
9. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table, it is characterized in that in the step 7 the screening webpage format after selecting to deposit in addition in the step 2 by Microsoft Word.
10. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table by Microsoft Word, it is characterized in that in the step 8, click " compiling ", the mark in the automatic program identification word file, and form the list template.
11. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table by Microsoft Word, it is characterized in that in the step 9, confirm that list is compiled into merit.
12. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table by Microsoft Word, it is characterized in that in the step 10, data type in the base attribute and precision are provided with, and wherein data type comprises: character string, integer, floating number, fixed precision, the amount of money, date, big text.
13. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table by Microsoft Word, it is characterized in that in the step 11, preserve base attribute setting to field.
14. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table by Microsoft Word, it is characterized in that in the step 12, the field advanced property is a definition form fields attribute most important part, and the field advanced property is forgiven the setting of control type to field, control parameter, default value, checking function, display format, alignment thereof.
15. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table by Microsoft Word, it is characterized in that in the step 13, preserve advanced property setting to field.
16. as claimed in claim 1ly set up the web list fast and automatically in database, set up the method for corresponding data table by Microsoft Word, it is characterized in that in the step 14, by the attribute setting of the list in the step 6, can carry out preview, test and determine after come into operation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100743521A CN101149737A (en) | 2007-05-10 | 2007-05-10 | Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100743521A CN101149737A (en) | 2007-05-10 | 2007-05-10 | Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101149737A true CN101149737A (en) | 2008-03-26 |
Family
ID=39250266
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007100743521A Pending CN101149737A (en) | 2007-05-10 | 2007-05-10 | Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101149737A (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN103136173A (en) * | 2011-11-29 | 2013-06-05 | 北京建龙重工集团有限公司 | Method converting mass word or excel format form documents into webpages |
| CN104090768A (en) * | 2014-07-18 | 2014-10-08 | 武汉市科尔创新软件技术有限公司 | Automatic intelligent smart phone form generating system and method |
| CN104331854A (en) * | 2014-11-21 | 2015-02-04 | 浙江和仁科技股份有限公司 | Implementation technique for form editor of nursing record documents |
| CN104598455A (en) * | 2013-10-31 | 2015-05-06 | 南京思润软件有限公司 | Method for realizing single-key replacement exhibition of form on the basis of B/S architecture system |
| CN105718473A (en) * | 2014-12-05 | 2016-06-29 | 成都复晓科技有限公司 | Data modeling method |
| CN107862112A (en) * | 2017-10-24 | 2018-03-30 | 中国昆仑工程有限公司 | Element material programming count and method for drafting suitable for AutoCAD floor plans |
| CN107895047A (en) * | 2017-12-04 | 2018-04-10 | 山东浪潮通软信息科技有限公司 | A kind of list lead-in and lead-out method and device |
| CN108205744A (en) * | 2016-12-19 | 2018-06-26 | 成都鼎桥通信技术有限公司 | The implementation method and device of work process flow list |
| CN109284292A (en) * | 2018-09-28 | 2019-01-29 | 广东电网有限责任公司 | A method for generating a mobile work form, a generating system and a related device |
| CN111222066A (en) * | 2019-12-31 | 2020-06-02 | 航天信息股份有限公司广州航天软件分公司 | A drop-down component system and method for event processing and search |
| CN112001157A (en) * | 2020-08-26 | 2020-11-27 | 湖北盈帆数据技术有限公司 | Online design method and device for webpage data form |
-
2007
- 2007-05-10 CN CNA2007100743521A patent/CN101149737A/en active Pending
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| CN103136173A (en) * | 2011-11-29 | 2013-06-05 | 北京建龙重工集团有限公司 | Method converting mass word or excel format form documents into webpages |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN102779040B (en) * | 2012-06-21 | 2015-11-18 | 东莞市微模式软件有限公司 | A kind of method and apparatus generating customizing form |
| CN104598455A (en) * | 2013-10-31 | 2015-05-06 | 南京思润软件有限公司 | Method for realizing single-key replacement exhibition of form on the basis of B/S architecture system |
| CN104090768A (en) * | 2014-07-18 | 2014-10-08 | 武汉市科尔创新软件技术有限公司 | Automatic intelligent smart phone form generating system and method |
| CN104331854A (en) * | 2014-11-21 | 2015-02-04 | 浙江和仁科技股份有限公司 | Implementation technique for form editor of nursing record documents |
| CN105718473A (en) * | 2014-12-05 | 2016-06-29 | 成都复晓科技有限公司 | Data modeling method |
| CN105718473B (en) * | 2014-12-05 | 2019-01-25 | 成都复晓科技有限公司 | A kind of method of data modeling |
| CN108205744A (en) * | 2016-12-19 | 2018-06-26 | 成都鼎桥通信技术有限公司 | The implementation method and device of work process flow list |
| CN107862112A (en) * | 2017-10-24 | 2018-03-30 | 中国昆仑工程有限公司 | Element material programming count and method for drafting suitable for AutoCAD floor plans |
| CN107895047A (en) * | 2017-12-04 | 2018-04-10 | 山东浪潮通软信息科技有限公司 | A kind of list lead-in and lead-out method and device |
| CN109284292A (en) * | 2018-09-28 | 2019-01-29 | 广东电网有限责任公司 | A method for generating a mobile work form, a generating system and a related device |
| CN111222066A (en) * | 2019-12-31 | 2020-06-02 | 航天信息股份有限公司广州航天软件分公司 | A drop-down component system and method for event processing and search |
| CN112001157A (en) * | 2020-08-26 | 2020-11-27 | 湖北盈帆数据技术有限公司 | Online design method and device for webpage data form |
| CN112001157B (en) * | 2020-08-26 | 2021-07-27 | 湖北盈帆数据技术有限公司 | Online design method and device for webpage data form |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101149737A (en) | Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word | |
| US11210456B2 (en) | Method relating to preparation of a report | |
| CN108427556B (en) | Form design analysis method and system | |
| CN101122899B (en) | Report generation method and device | |
| CN110738037B (en) | Method, apparatus, device and storage medium for automatically generating electronic form | |
| US20040221233A1 (en) | Systems and methods for report design and generation | |
| CN110543303B (en) | Visual service platform | |
| CN107886439A (en) | Insurance products development approach, device, equipment and computer-readable recording medium | |
| CN103593456B (en) | Worksheet self-defining method for designing and device | |
| CN109657215A (en) | Document structure tree method, equipment, storage medium and device based on template | |
| CN102339314A (en) | An XML-based cross-terminal data form description and presentation method | |
| CN111145051A (en) | Method and device for generating arbitration electronic document | |
| CN107544808A (en) | The generation method and device of a kind of web form | |
| CN102779118A (en) | Paper typesetting method and system | |
| CN106469140A (en) | A kind of report generating system and its method | |
| CN106339363A (en) | PPT report making method and device | |
| CN110321539A (en) | A kind of special equipment supervising platform report tool | |
| CN101968782B (en) | Sample report conversion method and system based on bank system | |
| CN105630747A (en) | Inspection report specialization system and method applied to special device industry | |
| CN101038583B (en) | Gold report generating and generating method thereof | |
| CN104378362B (en) | For carrying out the method and device of message interface conversion | |
| CN113050934A (en) | Form driving intelligent development method, device and storage medium | |
| CN102043769A (en) | Method and device for editing documents | |
| CN105630761A (en) | Method and device for manipulating formulas | |
| KR100902193B1 (en) | Report generation system, method and system for providing customized report on search results, and storage media |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C57 | Notification of unclear or unknown address | ||
| DD01 | Delivery of document by public notice |
Addressee: Liao Yihong Document name: Notification of Passing Examination on Formalities |
|
| C57 | Notification of unclear or unknown address | ||
| DD01 | Delivery of document by public notice |
Addressee: Liao Yihong Document name: the First Notification of an Office Action |
|
| C57 | Notification of unclear or unknown address | ||
| DD01 | Delivery of document by public notice |
Addressee: Liao Yihong Document name: Deemed as a notice of withdrawal (Trial) |
|
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20080326 |