CN101452441A - Electronic table general-purpose data parsing and leading-in method - Google Patents
Electronic table general-purpose data parsing and leading-in method Download PDFInfo
- Publication number
- CN101452441A CN101452441A CNA2008102377558A CN200810237755A CN101452441A CN 101452441 A CN101452441 A CN 101452441A CN A2008102377558 A CNA2008102377558 A CN A2008102377558A CN 200810237755 A CN200810237755 A CN 200810237755A CN 101452441 A CN101452441 A CN 101452441A
- Authority
- CN
- China
- Prior art keywords
- model
- row
- data
- key
- name
- 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 19
- 230000008676 import Effects 0.000 claims description 21
- 238000013507 mapping Methods 0.000 claims description 7
- 238000012423 maintenance Methods 0.000 claims description 4
- 239000002674 ointment Substances 0.000 claims description 4
- 230000009977 dual effect Effects 0.000 claims description 3
- 239000000463 material Substances 0.000 abstract description 2
- 238000007405 data analysis Methods 0.000 abstract 4
- 239000004615 ingredient Substances 0.000 description 4
- 244000201986 Cassia tora Species 0.000 description 2
- 235000014552 Cassia tora Nutrition 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000004088 simulation Methods 0.000 description 1
Abstract
The invention discloses a method for analyzing and importing general data of an electronic form, which aims to solve the problems of the data analysis and importing of declaration materials such as applications and reports which take the electronic form as a carrier, and realize the universality of analytical and importing logic by abstracting a data analysis and importing model of the electronic form and establishing the data analysis and importing model inside a template file of the electronic form. The method comprises: (1) the data analysis and importing model; (2) a data positioning mode; (3) representation modes of primary and external keys; (4) a judgment rule of effective record of a multi-row table; (5) the processing of an enumeration value; and (6) the safety of the model. The adoption of the method can realize the self-explanation of data of the electronic form, improve the reusability and maintainability of the analytical and importing logic, and reduce workload of repeating coding during the hard coding of the analytical and importing logic.
Description
Technical field
The present invention relates to built-in parsing importing model in electrical form, by being based upon the parsing and the importing of the generic logic realization spread-sheet data on the model.
Background technology
Electrical form is present the most frequently used office software, is mainly used in application, reports in the business scenario such as form, and the modal form that represents is exactly application form, form.
Electrical form is exactly structuring as the carrier biggest advantage of carrying data, by the accurate visit data of this locator meams of ranks sequence number, validity check, built-in programming expansion make its simulation application interface and interface logic really, and powerful statistics, analytic function also are the main causes that the clerical workforce has a preference for electrical form.
At present, government's professional application form, form of industry permission mostly provides template (template of other document form can be converted into spreadsheet) with the form of electrical form, for the consideration of saving the typing workload, also for fear of the people for makeing mistakes, the user often requires can import the declaration data that the administrative counterpart provides in business, realize the importing of declaration data, this declaration data is exactly as carrier with electrical form usually.
Spread-sheet data imports according to target that difference can be divided into two kinds, and a kind of is that the data based mapping relations in the electrical form are imported in the table of database correspondence, and another kind is that the data in the electrical form are filled up in the interface input domain of application system.
Realize the importing of declaration data in the electrical form, realization thinking routinely, will be with the application form templating, set up the corresponding relation of data item and database table column (or application system interface input domain) in the template then, according to corresponding relation, resolve the data in the application form, write database or be backfilling into the page.
The corresponding relation of data item and database table column in the template (or application system interface input domain) all is to be placed on the application system end usually, or is solidificated in the importing logic, or makes configurable corresponding tables in system.The 1st kind of mode reusability is the poorest, and workload is big; Though the 2nd kind of mode had bigger improvement than the 1st kind of mode, maintainability is bad, in case template changes, corresponding relation will reconfigure in the application system.
Use for reference the thinking of the 2nd kind of implementation, we change an angle, building in the electronic form template in the mapping relations of data item and database table column (or application system interface input domain), give the characteristic of template self-explanatory, importing logic then just can make general, if template changes, only need interior established model in the adjustment template in change just can be finished the renewal of mapping relations.
Summary of the invention
Technical matters to be solved by this invention provides the general parsing and leading-in method of a kind of spread-sheet data, solve with the electrical form data parsing and the importing of the declaration materials such as application form, report that are carrier with a kind of universal method, by take out spread-sheet data resolve to import model and in be built in the electronic form template file, realize resolving the versatility that imports logic, utilize modeled thinking, realize the self-explanatory of spread-sheet data, improve and resolve reusability, the maintainability that imports logic, reduce the repeated encoding workload of resolving when importing the logic hard coded.
Method of the present invention: comprise that the parsing of (one) spread-sheet data imports model; (2) data locking mode; (3) the expression mode of main external key; (4) judgment rule of the effective record of multirow table; (5) processing of enumerated value; (6) security of model; Wherein:
(1) spread-sheet data is resolved and is imported model, it is requirement according to data importing, with the content map in the electrical form is table and row in the database, resolves the core content that imports model and is made up of table model, row model and enumerated value model, the mapping of enumerated value models treated key assignments;
(2) data locking mode
Data locking in the electrical form is pressed three grades of modes: book-worksheet-zone;
The zone is cell, or one group of continuous unit lattice on two dimension, further navigates to wherein certain cell in the later case again, also to further locate by the ranks sequence number, to the dual mode of having quoted in zone:
(1) address: adopt the ranks sequence number, mode comprises: A1 ， $B$4, A1:B4;
(2) name zone:, use this title to quote when quoting for the appointed area name;
Resolve the location that imports model, comprise the position of locating analytic model and in resolving the importing model, want the resolution areas location; Wherein:
1) resolve the importing model orientation: be to adopt the mode in name zone to quote, follow following rule:
(1) core content of analytic model comprises table model and row model, adopts an independent worksheet to deposit, and this worksheet is unified called after " ShtDataConf ";
(2) the name zone is appointed as in the data area unification of table model, and name is called " DataConfTable ";
(3) specify or name voluntarily in the unified name zone of using of the row model that each table is corresponding in the table model, and this title is set to the value of " the row model is quoted " row in the corresponding tables model; All row models are put together up and down side by side;
(4) resolve the enumerated value model that imports model and adopt an independent worksheet to deposit, this worksheet is unified called after " ShtEnumerate ", unified the leaving in the name zone of 2 row multirows of key-value pair set of each enumerated value, and title is specified voluntarily;
2) resolution areas location: use " source work table name ", " source region domain name ", " the source region row sequence number " of row model to come integrated positioning by the zone that will resolve in the electrical form, be the single file table, the data that resolve are only used " source work table name ", " source region domain name " location;
(3) the expression mode of main external key
(1) rule
1) relation of master-salve table is usually specified by " master meter name " unit in the table model;
2) master meter must come from the table front in table model, that is to say that the model that will guarantee master meter gives parsing earlier;
3) Biao major key is by in the respective column model " major key whether " specify;
4) Biao external key is by in the respective column model " external key whether " specify;
5) major key can be in cell clear and definite assignment, also can generate automatically, when automatically generating, this is listed in, and " column data type " element value is " key assignments .n " in the model, and the value of " source work table name ", " source region domain name ", " source region row sequence number " element is left in the basket;
6) external key can be in cell clear and definite assignment, also can use the Major key of corresponding master meter, the Major key of corresponding master meter should be preferentially used in suggestion.When external key when the row model is not specified accurately resolution areas, will use the Major key of corresponding master meter;
7) major key is combination during major key, and the relative order of respective column must be consistent in the relative order that major key is listed as in the row model and the external key;
Main external key correspondence when (2) master meter is the multirow table
Two elements are arranged in the row model, " whether virtual major key ", " whether virtual external key ", in the multirow table " whether virtual major key " for the row of "Yes" and its from table " whether virtual external key " for there is adduction relationship in the train value of "Yes", whether " virtual external key " is must be able to find in the respective column of "Yes" for the value of the row of "Yes" at master meter " whether virtual major key " from table;
(3) virtual major key is combination during major key, and the relative order of respective column must be consistent in the relative order that virtual major key is listed as in the row model and the virtual external key;
(4) judgment rule of the effective record of multirow table
" row type " is the table of " multirow table ", analytic model give tacit consent to " source region row sequence number " in its row model be " 1 " classify the sign row as, when resolving detailed line data, run into this train value for the 1st time and think that effective record has run through when empty, stop to resolve this multirow table;
(5) processing of enumerated value
Electrical form provides the drop-down list function of similar application program interface, and data validity and a sequence by the appointed area realize drop-down list;
Enumerated value is placed in the zone of one two row, the 1st row are deposited the value of actual storage, the 2nd row are deposited the interface display text, and the 2nd row that then will be wherein offer the data validity function of appointed area as sequence, by the anti-enumerated value of looking into sequence are drawn actual enumerated value again during parsing;
The enumerated value zone is for the ease of identification, and regulation is named as prefix with " ENUM_ ";
Enumerated values all in the electrical form are to leaving in the sequence sets in the worksheet, and this worksheet is unified called after " shtEnumerate ";
(6) security of model
The maintenance of model should be responsible for by the template file provider, adopts electrical form to realize the protection of self, or two Sheet that model is positioned at is hidden or password protected be set.
Beneficial effect of the present invention has following advantage:
Spread-sheet data is resolved to import in the model and is built in the electronic form document, makes spread-sheet data have the characteristic of self-explanatory, and the hard coded importing logic with respect to model-free has reduced the repeated encoding workload, with respect to leading of model and data separating
(1) goes into mechanism, avoided extra mapping and logical process, guarantee to resolve the succinct, general of importing logic.
(2) spread-sheet data is resolved the data processing that imports model supports master-salve table pattern, has solved how to set up problem related between table in electrical form, becomes the model that really meets service application reality.Data after resolving according to model both can directly generate the SQL statement of analog service reality, can be filled up to the interface input domain of appointment again.
(3) spread-sheet data is resolved the processing mode that imports enumerated value in the model and has further been solved the realistic problem in the service application, has increased the availability of model.
Embodiment
Method of the present invention is made up of following several partial contents:
(1) spread-sheet data is resolved and is imported model;
(2) data locking mode;
(3) the expression mode of main external key;
(4) judgment rule of the effective record of multirow table
(5) processing of enumerated value;
(6) security of model;
Below explanation respectively.
(1) spread-sheet data is resolved and is imported model
Requirement according to data importing, content in the electrical form finally is mapped as table and row in the database, and therefore, the core content of analytic model also is made up of two parts: table model, row model, in addition, analytic model provides an enumerated value model to handle the key assignments mapping.
1. table model
| Sequence number | Model element | Explanation |
| 1 | Serial number | The sequence number that is equivalent to tables of data, no practical significance. |
| 2 | The database table name | The title of identification database table. |
| 3 | The row type | The capable type of tables of data, value is: 1. single file table: promptly 0 or 1 record only can appear in this table in current electronic form file; 2. multirow table: promptly should table in current electronic form file, can occur 0,1 or many records; |
| 4 | The row model is quoted | Quoting of this database table respective column model definition. |
| 5 | The master meter name | If this database table be in the table model certain table from the table, the value of this element be the correspondence the master meter title. |
2. row model
| Sequence number | Chinese | Explanation |
| 1 | Serial number | The sequence number that is equivalent to the data tabular, no practical significance. |
| 2 | The database column name | The title of identification database tabular. |
| 3 | The tabular sequence number | The sequence number in table of identification database tabular (reservation) as expanding |
| 4 | Interface tab name | Tab name on the sign application system interface (be used for " interface input domain name " and be combined into can unique position application system interface input domain title) |
| 5 | Interface input domain name | Input domain name on the sign application system interface. |
| 6 | Major key whether | Whether these row are major key (or its ingredient).Value is: be, not. |
| 7 | External key whether | Whether these row are external key (or its ingredient).Value is: be, not. |
| 8 | Virtual major key whether | Whether these row are virtual major key (or its ingredient).Value is: be, not. |
| This key is for separating Cassia tora multirow table and its from quoting the identified problems of corresponding relation between the table.If identical with the virtual Major key of certain row of its master meter (multirow table), then there is master slave relation between the record from the virtual external key of table. | ||
| 9 | Whether quote detailed key | Whether these row are virtual external key (or its ingredient).Value is: be, not.This key is for separating Cassia tora multirow table and its from quoting the identified problems of corresponding relation between the table.If identical with the virtual Major key of certain row of its master meter (multirow table), then there is master slave relation between the record from the virtual external key of table. |
| 10 | The column data type | The data type of this data tabular, data type has: 1. text; 2. date; 3. integer; 4. enumerate; 5. key assignments .n (16 system random codes, n is a code length); 6. constant; The column data type can be expanded according to actual needs. |
| 11 | Whether can be empty | Value is: be, not. |
| 12 | Source work table name | This row respective value place work table name.If " the row type " of corresponding tables model is " single file table ", can locatees the corresponding value of these row according to " source work table name " and " source region domain name "." row type " if of corresponding tables model be " the multirow table ", read the value of this row correspondence according to " source work table name ", " source region domain name ", " source region row sequence number " circulation. |
| 13 | The source region domain name | This row respective value " source region " name in " source work table name ". |
| 14 | Source region row sequence number | The row sequence number of this row respective value " source region " the inside in " source work table name ". |
| 15 | Enumerated value | If current column data type is " enumerating ", deposit enumerated value to (reservation) as expanding |
| 16 | Lead-in type | Processing mode when these row import, value is: 1. 2. interface (the backfill data are to the interface) 3. all (import data to databases, the data of backfill simultaneously are to interfaces) of database (import data to database) |
3. enumerated value model
| Sequence number | Model element | Explanation |
| 1 | Key | The actual part that writes database in the enumerated value |
| 2 | Value | The part that is used for interface display in the enumerated value |
(2) data locking mode
Data locking in the electrical form is pressed three grades of modes: book-worksheet-zone.
The zone may be a cell, also may be one group of continuous unit lattice on two dimension, if further navigate to wherein certain cell in the later case again, also will further locate by the ranks sequence number.
The dual mode of having quoted to the zone:
1. address
Adopt this mode of ranks sequence number, for example: A1 ， $B$4, A1:B4.
2. name is regional
For the appointed area name, use this title to quote when quoting, for example: be A1:B4 called after " thisarea ", can take when quoting to use " thisarea ".The name zone has certain dirigibility.
Analytic model equally also relates to the location, and the one, how to locate the position of analytic model, the one, in analytic model, how to locate the zone that will resolve.
1. analytic model is located
The position of analytic model adopts the mode in name zone to quote, and follows following rule:
1) core content of analytic model (table model, row model) adopts an independent worksheet to deposit, and this worksheet is unified called after " ShtDataConf ";
2) the unified name zone of being appointed as, the data area of table model (not containing header line), name is called " DataConfTable ";
3) (name voluntarily) specified in the unified name zone of using of the row model (not containing header line) that each table is corresponding in the table model, and this title is set to the value of " the row model is quoted " row in the corresponding tables model; Generally all row models can be put together up and down side by side.
4) the enumerated value model of analytic model adopts an independent worksheet to deposit, and this worksheet is unified called after " ShtEnumerate ", unified the leaving in the name zone of 2 row multirows of key-value pair set of each enumerated value, and title is specified voluntarily;
2. resolution areas is located
The zone that will resolve in the electrical form uses " source work table name ", " source region domain name ", " the source region row sequence number " of row model to come integrated positioning, if the single file table, the data that resolve only use " source work table name ", " source region domain name " to locate.
(3) the expression mode of main external key
1. regular
1) relation of master-salve table is usually specified by " master meter name " unit in the table model.
2) master meter must come from the table front in table model, that is to say that the model that will guarantee master meter gives parsing earlier.
3) Biao major key is by in the respective column model " major key whether " specify.
4) Biao external key is by in the respective column model " external key whether " specify.
5) major key can be in cell clear and definite assignment, also can generate automatically (that is to say this is listed in the electrical form can not exist), when generating automatically, this is listed in the model " column data type " element value and is " key assignments .n ", and the value of " source work table name ", " source region domain name ", " source region row sequence number " element is left in the basket.
6) external key can be in cell clear and definite assignment, also can use the Major key of corresponding master meter, the Major key of corresponding master meter should be preferentially used in suggestion.When external key when the row model is not specified accurately resolution areas, will use the Major key of corresponding master meter.
7) major key is combination during major key, and the relative order of respective column must be consistent in the relative order that major key is listed as in the row model and the external key.
2. the main external key correspondence when master meter is the multirow table
When the external key from table is quoted Major key in the master meter automatically, " the row type " of master meter is if " single file table " handled than being easier to, because have only a Major key, but " the row type " of master meter is " multirow table ", because have a plurality of Major keys, deal with regard to relative complex.
Two elements are arranged in the row model, " whether virtual major key ", " whether virtual external key ", whether " virtual major key " should exist adduction relationship for the row of "Yes" (being called virtual major key) and its from table " whether virtual external key " for the row of "Yes" (being called virtual external key) value in the multirow table, that is to say that " whether virtual external key " must be able to be found in the respective column of "Yes" at master meter " whether virtual major key " for the value of the row of "Yes" from table.
Take above-mentioned this mode to handle to be because difficult performance is a situation about generating automatically from the major key of table and main external key corresponding relation, especially master meter between it when master meter is multirow in electrical form.At this time, the row (or row group) of just getting energy unique identification current line in the master meter are as virtual major key, " whether virtual major key " element value of respective column model is made as "Yes", if the virtual primary key column of master meter is lacking respective column from table, then added, as virtual foreign key column, and virtual external key " whether virtual external key " element value in the row model is made as "Yes".
Virtual major key is combination during major key, and the relative order of respective column must be consistent in the relative order that virtual major key is listed as in the row model and the virtual external key.
(4) judgment rule of the effective record of multirow table
When in electrical form, setting up the application form template, fill in the content of how many row at uncertain meeting, tend to reserve multirow (generally being the maximum number of lines that to predict), but when actual filling in, often can not fill in so multirow, so just need to determine detailed row is to which end.
" row type " is the table of " multirow table ", analytic model give tacit consent to " source region row sequence number " in its row model be " 1 " classify the sign row as, when resolving detailed line data, run into this train value for the 1st time and think that effective record has run through when empty, stop to resolve this multirow table.
(5) processing of enumerated value
Electrical form can provide the drop-down list function of similar application program interface, is that the data validity by the appointed area realizes, at this moment is by providing a sequence to realize drop-down list.
The content of drop-down list content displayed and actual storage is often inequality in the application program, is to adopt the mode of enumerated value to handle.And can't realize in the electrical form that the value of choosing is different with storing value, generally be flexible the realization.
Enumerated value is placed in the zone of one two row, the 1st row are deposited the value of actual storage, the 2nd row are deposited the interface display text, and the 2nd row that then will be wherein offer the data validity function of appointed area as sequence, by the anti-enumerated value of looking into sequence are drawn actual enumerated value again during parsing.
The enumerated value zone is for the ease of identification, and regulation is named as prefix with " ENUM_ ".
Enumerated values all in the electrical form are convenient to maintenance and management to leaving in the sequence sets in the worksheet.This worksheet is unified called after " shtEnumerate ";
(6) security of model
The maintenance of model should be responsible for by the template file provider, model directly should be exposed to the person of making a report on, and this can cause model by the person's of making a report on mistake editor, causes model to be made mistakes, and can't realize the correct parsing of spread-sheet data.
At this problem, adopt the defencive function of electrical form self to realize, two Sheet that model is positioned at hide or are protected (not allowing not make authorized user by cryptographic check directly edits).
Claims (7)
1. electronic table general-purpose data parsing and leading-in method, it is characterized in that, solving with the electrical form with a kind of universal method is the application form of carrier, the data parsing and the importing of report, by take out spread-sheet data resolve to import model and in be built in the electronic form template file, realize resolving the versatility that imports logic, method comprises that the parsing of (one) spread-sheet data imports model; (2) data locking mode; (3) the expression mode of main external key; (4) judgment rule of the effective record of multirow table; (5) processing of enumerated value; (6) security of model.
2, method according to claim 1, it is characterized in that, spread-sheet data is resolved and is imported model, it is requirement according to data importing, with the content map in the electrical form is table and row in the database, resolve the core content that imports model and form, the mapping of enumerated value models treated key assignments by table model, row model and enumerated value model.
3, method according to claim 1 is characterized in that, the data locking mode is as follows:
Data locking in the electrical form is pressed three grades of modes: book-worksheet-zone;
The zone is cell, or one group of continuous unit lattice on two dimension, further navigates to wherein certain cell in the later case again, also to further locate by the ranks sequence number, to the dual mode of having quoted in zone:
(1) address: adopt the ranks sequence number, mode comprises: A1 ， $B$4, A1:B4;
(2) name zone:, use this title to quote when quoting for the appointed area name;
Resolve the location that imports model, comprise the position of locating analytic model and in resolving the importing model, want the resolution areas location; Wherein:
1) resolve the importing model orientation: be to adopt the mode in name zone to quote, follow following rule:
(1) core content of analytic model comprises table model and row model, adopts an independent worksheet to deposit, and this worksheet is unified called after " ShtDataConf ";
(2) the name zone is appointed as in the data area unification of table model, and name is called " DataConfTable ";
(3) specify or name voluntarily in the unified name zone of using of the row model that each table is corresponding in the table model, and this title is set to the value of " the row model is quoted " row in the corresponding tables model; All row models are put together up and down side by side;
(4) resolve the enumerated value model that imports model and adopt an independent worksheet to deposit, this worksheet is unified called after " ShtEnumerate ", unified the leaving in the name zone of 2 row multirows of key-value pair set of each enumerated value, and title is specified voluntarily;
2) resolution areas location: use " source work table name ", " source region domain name ", " the source region row sequence number " of row model to come integrated positioning by the zone that will resolve in the electrical form, be the single file table, the data that resolve are only used " source work table name ", " source region domain name " location;
4, method according to claim 1 is characterized in that, the expression mode of main external key is as follows:
(1) rule
1) relation of master-salve table is usually specified by " master meter name " unit in the table model;
2) master meter must come from the table front in table model, that is to say that the model that will guarantee master meter gives parsing earlier;
3) Biao major key is by in the respective column model " major key whether " specify;
4) Biao external key is by in the respective column model " external key whether " specify;
5) major key can be in cell clear and definite assignment, also can generate automatically, when automatically generating, this is listed in, and " column data type " element value is " key assignments .n " in the model, and the value of " source work table name ", " source region domain name ", " source region row sequence number " element is left in the basket;
6) external key can be in cell clear and definite assignment, also can use the Major key of corresponding master meter, the Major key of corresponding master meter should be preferentially used in suggestion.When external key when the row model is not specified accurately resolution areas, will use the Major key of corresponding master meter;
7) major key is combination during major key, and the relative order of respective column must be consistent in the relative order that major key is listed as in the row model and the external key;
Main external key correspondence when (2) master meter is the multirow table
Two elements are arranged in the row model, " whether virtual major key ", " whether virtual external key ", in the multirow table " whether virtual major key " for the row of "Yes" and its from table " whether virtual external key " for there is adduction relationship in the train value of "Yes", whether " virtual external key " is must be able to find in the respective column of "Yes" for the value of the row of "Yes" at master meter " whether virtual major key " from table;
(3) virtual major key is combination during major key, and the relative order of respective column must be consistent in the relative order that virtual major key is listed as in the row model and the virtual external key;
5, method according to claim 1 is characterized in that, the judgment rule that the multirow table effectively writes down is as follows:
" row type " is the table of " multirow table ", analytic model give tacit consent to " source region row sequence number " in its row model be " 1 " classify the sign row as, when resolving detailed line data, run into this train value for the 1st time and think that effective record has run through when empty, stop to resolve this multirow table;
6, method according to claim 1 is characterized in that, the disposal route of enumerated value is as follows:
Electrical form provides the drop-down list function of similar application program interface, and data validity and a sequence by the appointed area realize drop-down list;
Enumerated value is placed in the zone of one two row, the 1st row are deposited the value of actual storage, the 2nd row are deposited the interface display text, and the 2nd row that then will be wherein offer the data validity function of appointed area as sequence, by the anti-enumerated value of looking into sequence are drawn actual enumerated value again during parsing;
The enumerated value zone is for the ease of identification, and regulation is named as prefix with " ENUM_ ";
Enumerated values all in the electrical form are to leaving in the sequence sets in the worksheet, and this worksheet is unified called after " shtEnumerate ";
7, method according to claim 1 is characterized in that, the security measures of model is as follows:
The maintenance of model should be responsible for by the template file provider, adopts electrical form to realize the protection of self, or two Sheet that model is positioned at is hidden or password protected be set.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008102377558A CN101452441A (en) | 2008-12-05 | 2008-12-05 | Electronic table general-purpose data parsing and leading-in method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008102377558A CN101452441A (en) | 2008-12-05 | 2008-12-05 | Electronic table general-purpose data parsing and leading-in method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101452441A true CN101452441A (en) | 2009-06-10 |
Family
ID=40734679
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2008102377558A Pending CN101452441A (en) | 2008-12-05 | 2008-12-05 | Electronic table general-purpose data parsing and leading-in method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101452441A (en) |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101866364A (en) * | 2010-06-22 | 2010-10-20 | 用友软件股份有限公司 | Data lead-in method and device |
| CN101901269A (en) * | 2010-08-04 | 2010-12-01 | 国电南瑞科技股份有限公司 | Real-time library foreign key reference and display method |
| CN102024039A (en) * | 2010-12-01 | 2011-04-20 | 北京神州泰岳软件股份有限公司 | Form generating method based on electric operation maintenance system (EOMS) |
| CN102567457A (en) * | 2010-11-02 | 2012-07-11 | 微软公司 | Object model to key-value data model mapping |
| CN102819539A (en) * | 2011-09-28 | 2012-12-12 | 金蝶软件（中国）有限公司 | Repaid data type-in method and system |
| CN102841899A (en) * | 2011-06-23 | 2012-12-26 | 深圳市金蝶友商电子商务服务有限公司 | Method for installing template files |
| CN102968468A (en) * | 2011-11-11 | 2013-03-13 | 微软公司 | Structured modeling of data in electronic spreadsheet |
| CN103077183A (en) * | 2012-12-14 | 2013-05-01 | 北京普泽天玑数据技术有限公司 | Data importing method and system for distributed sequence list |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN104536998A (en) * | 2014-12-15 | 2015-04-22 | 浪潮通用软件有限公司 | Data import method and device |
| CN105760450A (en) * | 2016-02-04 | 2016-07-13 | 浪潮通用软件有限公司 | Form file analyzing method and device |
| CN104142910B (en) * | 2013-05-10 | 2017-04-12 | 非凡互联（北京）传媒科技有限公司 | Air flow velocity data format conversion system and method |
| CN106796585A (en) * | 2014-09-10 | 2017-05-31 | 起元技术有限责任公司 | Condition verification rule |
| CN108268462A (en) * | 2016-12-30 | 2018-07-10 | 广东精点数据科技股份有限公司 | A kind of data quality checking system of relation integraity |
| CN109189849A (en) * | 2018-10-16 | 2019-01-11 | 浪潮天元通信信息系统有限公司 | A kind of standardization, the data entry method of procedure and system |
| CN109739923A (en) * | 2019-04-03 | 2019-05-10 | 深圳市沃易科技有限公司 | A kind of method and system that data import |
| CN110209882A (en) * | 2018-02-11 | 2019-09-06 | 鼎复数据科技(北京)有限公司 | A kind of quick mapping method for text mark |
| CN113051321A (en) * | 2019-12-26 | 2021-06-29 | 航天信息股份有限公司 | Data import method, device, equipment and storage medium |
-
2008
- 2008-12-05 CN CNA2008102377558A patent/CN101452441A/en active Pending
Cited By (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101866364B (en) * | 2010-06-22 | 2011-12-07 | 用友软件股份有限公司 | Data lead-in method and device |
| CN101866364A (en) * | 2010-06-22 | 2010-10-20 | 用友软件股份有限公司 | Data lead-in method and device |
| CN101901269A (en) * | 2010-08-04 | 2010-12-01 | 国电南瑞科技股份有限公司 | Real-time library foreign key reference and display method |
| CN102567457A (en) * | 2010-11-02 | 2012-07-11 | 微软公司 | Object model to key-value data model mapping |
| CN102024039A (en) * | 2010-12-01 | 2011-04-20 | 北京神州泰岳软件股份有限公司 | Form generating method based on electric operation maintenance system (EOMS) |
| CN102024039B (en) * | 2010-12-01 | 2012-09-05 | 北京神州泰岳软件股份有限公司 | Form generating method based on electric operation maintenance system (EOMS) |
| CN102841899B (en) * | 2011-06-23 | 2015-02-18 | 深圳市金蝶友商电子商务服务有限公司 | Method for installing template files |
| CN102841899A (en) * | 2011-06-23 | 2012-12-26 | 深圳市金蝶友商电子商务服务有限公司 | Method for installing template files |
| CN102819539A (en) * | 2011-09-28 | 2012-12-12 | 金蝶软件（中国）有限公司 | Repaid data type-in method and system |
| CN102819539B (en) * | 2011-09-28 | 2015-12-16 | 金蝶软件（中国）有限公司 | The method and system of data Rapid input |
| CN102968468A (en) * | 2011-11-11 | 2013-03-13 | 微软公司 | Structured modeling of data in electronic spreadsheet |
| CN103077183B (en) * | 2012-12-14 | 2017-11-17 | 北京普泽创智数据技术有限公司 | A kind of data lead-in method and its system of distributed sequence list |
| CN103077183A (en) * | 2012-12-14 | 2013-05-01 | 北京普泽天玑数据技术有限公司 | Data importing method and system for distributed sequence list |
| CN104142910B (en) * | 2013-05-10 | 2017-04-12 | 非凡互联（北京）传媒科技有限公司 | Air flow velocity data format conversion system and method |
| CN106796585A (en) * | 2014-09-10 | 2017-05-31 | 起元技术有限责任公司 | Condition verification rule |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN104317974B (en) * | 2014-11-21 | 2017-07-11 | 武汉理工大学 | Multi-source data introduction method in a kind of ERP system of restructural |
| CN104536998A (en) * | 2014-12-15 | 2015-04-22 | 浪潮通用软件有限公司 | Data import method and device |
| CN105760450A (en) * | 2016-02-04 | 2016-07-13 | 浪潮通用软件有限公司 | Form file analyzing method and device |
| CN108268462A (en) * | 2016-12-30 | 2018-07-10 | 广东精点数据科技股份有限公司 | A kind of data quality checking system of relation integraity |
| CN110209882A (en) * | 2018-02-11 | 2019-09-06 | 鼎复数据科技(北京)有限公司 | A kind of quick mapping method for text mark |
| CN109189849A (en) * | 2018-10-16 | 2019-01-11 | 浪潮天元通信信息系统有限公司 | A kind of standardization, the data entry method of procedure and system |
| CN109739923A (en) * | 2019-04-03 | 2019-05-10 | 深圳市沃易科技有限公司 | A kind of method and system that data import |
| CN113051321A (en) * | 2019-12-26 | 2021-06-29 | 航天信息股份有限公司 | Data import method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101452441A (en) | Electronic table general-purpose data parsing and leading-in method | |
| JP4563189B2 (en) | Database management system and database management method | |
| US6684222B1 (en) | Method and system for translating data associated with a relational database | |
| US7673282B2 (en) | Enterprise information unification | |
| CN108228817A (en) | Data processing method, device and system | |
| CN102929664A (en) | Conventional data exchange method based on XSD structure | |
| CN100565453C (en) | A kind of field basic business platform and construction method thereof based on member | |
| CN101084494A (en) | User interfaces for data integration systems | |
| Lenz | Modeling interorganizational workflows with XML nets | |
| CN111462327A (en) | Three-dimensional modeling software three-dimensional inspection model unstructured data analysis method | |
| CN104361139A (en) | Data importing device and method | |
| JP2007149096A (en) | Data element naming system and method | |
| CN100550020C (en) | A kind of method and apparatus that is used to solve the Chinese software issue of supporting multilanguage | |
| CN112948427B (en) | Data query method, device, equipment and storage medium | |
| CN109472446B (en) | BIM model-based engineering budget estimate planning method | |
| CN112612794A (en) | Auxiliary generation method and device of relational database, computer equipment and storage medium | |
| CN107239923B (en) | Method and device for generating material application form | |
| Krogstie | Capturing enterprise data integration challenges using a semiotic data quality framework | |
| US20100293450A1 (en) | System and method for simulating discrete financial forecast calculations | |
| CN114706915A (en) | Method for building BOM information from PLM system by EDA software | |
| CN105550176A (en) | Basic mapping method for relational database and XML | |
| CN115344631A (en) | Enterprise data management platform | |
| CN110826151B (en) | Electric automobile model design method | |
| CN105426176B (en) | A kind of figure converting system model checking method based on Information hiding | |
| TWI522824B (en) | Method for generating form validation program and corresponding form interface from result set metadata |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20090610 |