CN107895047A - A kind of list lead-in and lead-out method and device - Google Patents
A kind of list lead-in and lead-out method and device Download PDFInfo
- Publication number
- CN107895047A CN107895047A CN201711256978.4A CN201711256978A CN107895047A CN 107895047 A CN107895047 A CN 107895047A CN 201711256978 A CN201711256978 A CN 201711256978A CN 107895047 A CN107895047 A CN 107895047A
- Authority
- CN
- China
- Prior art keywords
- list
- rule
- extension
- imports
- exports
- 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 43
- 230000008676 import Effects 0.000 claims abstract description 271
- 238000012545 processing Methods 0.000 claims abstract description 36
- 238000013507 mapping Methods 0.000 claims description 16
- 230000001360 synchronised effect Effects 0.000 claims description 11
- 230000008569 process Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000010354 integration Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 238000001914 filtration Methods 0.000 description 3
- 238000013459 approach Methods 0.000 description 2
- 238000001514 detection method Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000003466 anti-cipated effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Small-Scale Networks (AREA)
Abstract
The invention provides a kind of list lead-in and lead-out method and device, this method to include：Basis corresponding to obtaining basic list and the underlying table list imports and exports rule；Increase at least one field newly on the basic list, obtain extension list；On the basis of importing and exporting rule on the basis, the rule that imports and exports of newly-increased at least one field is defined, obtains and imports and exports rule with the single-phase corresponding extension of the expansion table；Receive outside input import and export instruction after, according to it is described extension import and export rule to it is described extension list carry out importing and exporting processing.The device includes：Acquiring unit, form definition unit, regular definition unit and import and export unit.The program can improve the usage experience of user.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of list lead-in and lead-out method and device.
Background technology
Enterprise Resources Plan (Enterprise Resource Planning, ERP) system one kind is mainly directed towards manufacture row
Industry carries out physical resources, human resources, fund resources and the enterprise information management system of information resources integration integrated management, can
To provide the function of trans-regional, trans-departmental, even across company integration real time information.In ERP system, according to business demand user
It may need to customize personalized list, and realize importing and exporting for personalized list.
At present, when user needs to carry out personalized list to import and export, according to the self-defined personalized list of business demand, and
Define personalized list imports and exports specification, realizes importing and exporting for personalized list.
The method imported and exported for realizing personalized list at present, user need to redefine whole list, and again
The rule that imports and exports of whole list is defined, and defining whole table list and the whole rule that imports and exports needs to consume a longer time,
Cause the usage experience of user poor.
The content of the invention
The embodiments of the invention provide a kind of list lead-in and lead-out method and device, it is possible to increase the usage experience of user.
In a first aspect, the embodiments of the invention provide a kind of list lead-in and lead-out method, including：
Basis corresponding to obtaining basic list and the underlying table list imports and exports rule；
Increase at least one field newly on the basic list, obtain extension list；
On the basis of importing and exporting rule on the basis, rule is imported and exported to newly-increased at least one field
It is defined, obtains and import and export rule with the single-phase corresponding extension of the expansion table；
Receive outside input import and export instruction after, according to it is described extension import and export rule to the expansion table
Singly carry out importing and exporting processing.
Alternatively,
After the acquisition extension list, further comprise：Define the list dimension of the extension list；
After the acquisition imports and exports rule with the single-phase corresponding extension of the expansion table, further comprise：According to
The extension imports and exports data exchange bag corresponding to rule generation, and the data exchange bag is stored；
It is described according to it is described extension import and export rule to it is described extension list carry out importing and exporting processing, including：According to
The list dimension and the basis corresponding to the expansion table list import and export rule, search single-phase corresponding with the expansion table
The data exchange bag, by perform the data exchange bag to it is described extension list carry out importing and exporting processing.
Alternatively,
It is described import and export rule on the basis on the basis of, to importing and exporting for newly-increased at least one field
Rule is defined, and is obtained and is imported and exported rule with the single-phase corresponding extension of the expansion table, including：
The first of the newly-increased at least one field of definition imports and exports rule；
Judge whether to receive that the outside at least one undefined field included to the basic list is defined touches
Hair, wherein, the undefined field is that the basis imports and exports the field that rule is not related to；
If it is, defining the second of at least one undefined field according to the triggering of outside imports and exports rule, and
Regular, described first is imported and exported to the basis and imports and exports that regular and described second imports and exports rule and integrate, is obtained
Obtain the extension and import and export rule；
If not, being imported and exported to the basis, regular and described first imports and exports rule and integrates, described in acquisition
Extension imports and exports rule.
Alternatively,
After the acquisition imports and exports rule with the single-phase corresponding extension of the expansion table, further comprise：
After detecting that the basis imports and exports rule and is updated, arrived regular and synchronized is imported and exported described in after renewal
The extension is imported and exported in rule.
Alternatively,
The basic list includes：Original list or reference extension list, wherein,
The original list is the list being pre-created；
The extension list of quoting is newly-increased at least one on the original list or other described application extension lists
The list that field obtains.
Alternatively,
The basis, which imports and exports rule, to be included：ExportRange, derived field sequence, export filter condition, export mapping
Relation, position is imported, filter condition is imported and imports any one or more in mapping relations.
Alternatively,
The extension, which imports and exports rule, to be included：ExportRange, derived field sequence, export filter condition, export mapping
Relation, position is imported, filter condition is imported and imports any one or more in mapping relations.
Second aspect, the embodiment of the present invention additionally provide a kind of list and import and export device, including：Acquiring unit, list
Definition unit, regular definition unit and import and export unit；
The acquiring unit, rule is imported and exported for basis corresponding to obtaining basic list and the underlying table list；
The form definition unit, for increasing at least one word on the basic list that is obtained in the acquiring unit newly
Section, obtain extension list；
The regular definition unit, for importing and exporting the basis of rule on the basis that the acquiring unit obtains
On, the rule that imports and exports of at least one field increased newly to the form definition unit is defined, obtain with it is described
Extension imports and exports rule corresponding to expansion table is single-phase；
It is described to import and export unit, for receive outside input import and export instruction after, it is fixed according to the rule
The extension that adopted unit obtains imports and exports the extension list that rule obtains to the form definition unit and imported
Export is handled.
Alternatively,
The form definition unit, it is further used for defining the list dimension of the extension list；
The regular definition unit, it is further used for the data exchange according to corresponding to the extension imports and exports rule generation
Bag, and the data exchange bag is stored；
It is described to import and export unit, imported for the list dimension according to corresponding to the expansion table list and the basis
Derived rule, lookup and the single-phase corresponding data exchange bag of the expansion table, by performing the data exchange bag to institute
Extension list is stated to carry out importing and exporting processing.
Alternatively,
The regular definition unit, first for defining newly-increased at least one field imports and exports rule, and
Judge whether to receive the triggering that the outside at least one undefined field for including the basic list is defined, wherein,
The undefined field is that the basis imports and exports the field that rule is not related to, if it is, defining institute according to the triggering of outside
State the second of at least one undefined field and import and export rule, and regular, described first is imported and exported to the basis and is imported
Derived rule and described second imports and exports rule and integrated, and obtains the extension and imports and exports rule, otherwise to the base
Plinth imports and exports that regular and described first imports and exports rule and integrated, and obtains the extension and imports and exports rule.
Alternatively,
The list imports and exports device and further goes to include：Policy Updates unit；
The Policy Updates unit, for detecting that the basis imported and exported after rule is updated, after renewal
It is described to import and export the extension that regular and synchronized is got to the regular definition unit and import and export in rule.
List lead-in and lead-out method and device provided in an embodiment of the present invention, getting basic list and underlying table single pair
After the basis answered imports and exports rule, increase one or more fields newly on basic list and obtain extension list, imported on basis
On the basis of derived rule, the rule that imports and exports of newly-increased each field is defined, obtained single-phase corresponding with expansion table
Extension import and export rule, when receive outside after importing and exporting instruction, according to extension import and export rule to expansion table
Singly carry out importing and exporting processing.As can be seen here, user can be to obtain by increasing field on the basis of existing basic list
Required extension list, while import and export on existing basis and regular progress to be imported and exported to new field on the basis of rule
Definition can be used to import and export rule to the extension that extension list is imported and exported to obtain, and user need not redefine whole
Individual list and rule entirely is imported and exported, reduce workload when being imported and exported to list, so as to improve user
Usage experience.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are the present invention
Some embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis
These accompanying drawings obtain other accompanying drawings.
Fig. 1 is a kind of flow chart for list lead-in and lead-out method that one embodiment of the invention provides；
Fig. 2 is the flow chart for another list lead-in and lead-out method that one embodiment of the invention provides；
Fig. 3 is a kind of flow chart for list deriving method that one embodiment of the invention provides；
Fig. 4 is a kind of flow chart for list introduction method that one embodiment of the invention provides；
Fig. 5 is the schematic diagram of equipment where a kind of list that one embodiment of the invention provides imports and exports device；
Fig. 6 is the schematic diagram that a kind of list that one embodiment of the invention provides imports and exports device；
Fig. 7 is the schematic diagram that another list that one embodiment of the invention provides imports and exports device.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is
Part of the embodiment of the present invention, rather than whole embodiments, based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment obtained on the premise of creative work is not made, belongs to the scope of protection of the invention.
As shown in figure 1, the embodiments of the invention provide a kind of list lead-in and lead-out method, this method can include following step
Suddenly：
Step 101：Basis corresponding to obtaining basic list and the underlying table list imports and exports rule；
Step 102：Increase at least one field newly on the basic list, obtain extension list；
Step 103：On the basis of rule being imported and exported on the basis, the importing to newly-increased at least one field
Derived rule is defined, and is obtained and is imported and exported rule with the single-phase corresponding extension of the expansion table；
Step 104：Receive outside input import and export instruction after, according to it is described extension import and export rule to institute
Extension list is stated to carry out importing and exporting processing.
, should getting basic list and underlying table single pair the embodiments of the invention provide a kind of list lead-in and lead-out method
Basis import and export rule after, increase one or more fields newly on basic list and obtain extension lists, led on basis
Go out on the basis of rule, the rule that imports and exports of newly-increased each field is defined, obtain single-phase corresponding with expansion table
Extension imports and exports rule, and when receiving after importing and exporting instruction of outside, rule is imported and exported to extending list according to extension
Carry out importing and exporting processing.As can be seen here, user can be to obtain by increasing field on the basis of existing basic list
The extension list needed, while import and export on existing basis and the rule that imports and exports of new field to be determined on the basis of rule
Justice can be used to import and export rule to the extension that extension list is imported and exported to obtain, and user need not redefine entirely
List and rule entirely is imported and exported, reduce workload when being imported and exported to list, so as to improve user's
Usage experience.
Alternatively, as shown in figure 1,
First, after obtaining extension list in a step 102, the list dimension of extension list, list dimension can also be defined
Spend for recording the set membership between extension list and basic list.For example the reimbursement of list dimension is defined on basic list A
Type, definition extension list B dimension values are submitted an expense account for poor travelling expenses, increase Locality field newly on basic list A and obtain extension list B,
Subordinate's list of list A based on extension list B can be determined according to extension list B list dimension, i.e., basic list A is with expanding
It is set membership to open up list B.
Second, after acquisition extension imports and exports rule in step 103, can also be imported and exported according to the extension of acquisition
Data exchange bag corresponding to rule generation, and the data exchange bag to being generated stores.
List dimension based on above-mentioned definition extension list and after generating data exchange bag, according to extension in step 104
Import and export rule to extension list carry out importing and exporting processing when, list dimension and basis first according to corresponding to expansion table list
Rule, lookup and the single-phase corresponding data exchange bag of expansion table are imported and exported, by performing the data exchange bag found to expanding
Exhibition list carries out importing and exporting processing.
First, the data exchange bag according to corresponding to extension imports and exports rule generation, and data exchange bag is stored,
More easily rule can be imported and exported to extension to be managed.Secondly, needing that extension list is imported or exported
During processing, rule is imported and exported according to the list dimension of extension list and basis, it is single-phase right with expansion table quickly to find
The data exchange bag answered, by perform data exchange bag can be imported and exported according to extension rule to extension list imported or
Export is handled.
It should be noted that as shown in figure 1, according to the demand of user, obtained in step 102 after extension forces list, can not
The rule that imports and exports of newly-increased each field is defined.Correspondingly, instruction is imported and exported receive outside input
Afterwards, list dimension imports and exports rule searching with the presence or absence of single-phase corresponding with expansion table with basis according to corresponding to expansion table list
Extension imports and exports regular (data exchange bag), and extension list is led if it is present importing and exporting rule according to extension
Enter or export is handled, rule is imported to extension list or export is handled if it does not exist, then being imported and exported according to basis.When
According to basis import and export rule to extension list export when, extend list in increase newly each field will not be exported.
So, user can only define required extension list according to business demand, without importing and exporting rule to extension list
It is defined, to meet only to need to check demand of the list without exporting the user for importing list, improves the list and lead
Go out the applicability of method.
Alternatively, as shown in figure 1, step 103, which specifically can obtain extension in the following way, imports and exports rule：
S1：The first of the newly-increased each field of definition imports and exports rule；
S2：Judge whether to receive the triggering that the outside undefined field for including basic list is defined, wherein, not
It is to be included in basic list but basis imports and exports rule and the regular word being defined is not imported and exported to it to define field
Section, if it is, performing S3, otherwise perform S4；
S3：According to the triggering of outside, define the second of each undefined field and import and export rule, and basis is led
Go out rule, first import and export rule and second and import and export rule and integrated, obtain extension and import and export rule, Zhi Houjie
Beam current process；
S4：Rule and first is imported and exported to basis to import and export rule and integrate, and is obtained extension and is imported and exported rule.
Basis imports and exports the rule that imports and exports that rule defines basic list, but basis imports and exports rule and may do not had
Have and the regulation that imports and exports of all fields in basic list is defined, rule will not imported and not exported by basis in basic list
Then definition import and export rule each field be referred to as undefined field.New field obtains extension list in basic list
Afterwards, except can be defined to the rule that imports and exports of newly-increased each field, can also to one in basic list or
The rule that imports and exports of multiple undefined fields is defined, and most basis imports and exports leading for regular, each new field at last
The rules integration that imports and exports for entering derived rule and each undefined field by definition imports and exports rule for extension.
Specifically, when definition extension imports and exports rule, the basis under dimension where extending list first is led
It is copied next to go out rule, and replaces the basic basic model imported and exported in rule as the extended model of extension list, Ran Hou
Basis, which imports and exports rule each new field is defined below, imports and exports rule, can be with if there is undefined field
The rule that imports and exports of one or more undefined fields is defined, most basis imports and exports regular, each increase newly at last
The rules integration that imports and exports of each undefined field for importing and exporting rule and passing through definition of field imports and exports for extension
Rule.During defining extension and importing and exporting rule, by list filtering rule user can be facilitated to check below list
Definition imports and exports rule.
Alternatively, as shown in figure 1,
, will renewal if basis imports and exports rule and is updated after step 103 acquisition extension imports and exports rule
Basis afterwards imports and exports regular and synchronized and imported and exported to extension in rule.
Obtained because extension imports and exports rule in basic import and export on rule-based approach, when basis imports and exports rule
After being then updated, in order to guarantee according to extension import and export rule to extension list normally imported and exported, it is necessary to general
Basis after renewal imports and exports regular and synchronized and imported and exported to extension in rule.In addition, it is multiple extension import and export rule can
Same basis can be corresponded to and import and export rule, after importing and exporting Policy Updates on basis, basis is imported and exported into rule respectively
Be synchronized to it is each cause its extension to import and export in rule, without each extension is imported and exported rule and modified respectively,
Conveniently rule is imported and exported to extension to safeguard.
Alternatively, by basic list new field can obtain extension list, and basic list can be original
List quotes extension list.
Original list is the list being pre-created, and the content included by it is the shared content of various extension lists, generally
Can be that system is provided or defined by developer in itself.For example in employee information system, developer will include employee and believe
List based on the form definitions of Back ground Information field such as breath, date of birth and job number, in generation cell-phone fee expense report, poor travelling expenses
It is required for quoting the basic list during list such as expense report and hospitality expense expense report.
It is the list that new field obtains on original list or other reference extension lists to quote extension list, that is,
The extension list for quoting that extension list can be the list based on original list is said, or based on other extension lists
The extension list of list.
As can be seen here, list based on original table nonoculture can be defined extension list, can also will be defined complete
Into expansion table nonoculture based on list define new extension list.On the one hand, according to business demand select original list or
List defines new extension list based on suitable expansion table nonoculture, can further reduce the work of definition extension list
Amount, improve and carry out the efficiency that list imports and exports.On the other hand, it is base by the expansion table nonoculture of original list or defined completion
Plinth list, the needs of the self-defined personalized extension list of different user can be met, improve the list lead-in and lead-out method
Applicability.
Alternatively, basis imports and exports rule and can include ExportRange, derived field sequence, export filter condition, lead
Go out mapping relations, import position, import filter condition and import mapping relations in it is any one or more, extension imports and exports
Rule can also include ExportRange, derived field sequence, export filter condition, export mapping relations, import position, imported
It is any one or more in filter condition and importing mapping relations.
Basis imports and exports rule and extension imports and exports rule and may each comprise the portion imported in rule and derived rule
Divide or whole.
It is used rule when importing data into corresponding basic list or extension list to import rule, includes importing
Position, import filter condition and import part or all of in mapping relations.Import position and define importing data in underlying table
The position inserted in single or extension list, it is the rule that data to be imported are carried out with screening and filtering to import filter condition, and importing is reflected
It is by the rule for being partly or entirely mapped as basic list or extending data needed for list of importing data to penetrate relation.Such as
It is to be mapped as man by import in data 0 to import mapping relations, and female is mapped as by import in data 1.
Derived rule is used rule when being exported to corresponding basic list or extension list, including exports model
Enclose, be in derived field sequence, export filter condition and export mapping relations part or all of.ExportRange, which is used to limit, to be exported
The scope of data is exported when corresponding basic list or extension list, derived field is ordered as exporting corresponding basic list or expansion table
The rule to be sorted in list between each field, to underlying table when export filter condition corresponds to basic list or extension list for export
Rule that is single or extending form data progress screening and filtering, export mapping relations are that will correspond to basic list or extend in the middle part of list
Divide or total data is mapped as derived rule after other information.
Below after employee information export to be combed again exemplified by import system, to table provided in an embodiment of the present invention
Single lead-in and lead-out method is described in further detail, as shown in Fig. 2 this method may comprise steps of：
Step 201：Obtain basic list and the basis corresponding to basic list imports and exports rule.
In embodiments of the present invention, by developer's basic list defined in the corresponding maintenance of business, basic list is defined
Basis import and export rule, and generate imported and exported with defined basis it is regular to corresponding first data exchange bag.
For example, group X needs, by the data export excel in employee information, then to comb the data in excel
It is imported into again in system after reason.According to the triggering of developer, basic list A is defined, 4 words are included in basic list A
Section and 3 reserved fields, wherein 4 fields are respectively name, date of birth, job number, department, 3 reserved fields are used to implement
Personnel's new field is with self-defined personalized extension list.And definition imports and exports rule corresponding to basic list A basis
A, wherein it is all to export 4 fields included by basic list A that basis, which imports and exports regular A, from a left side in list is exported
Name, date of birth, job number, department are followed successively by right 4 fields.The data according to corresponding to basis imports and exports regular A generations
Exchange bag A.
Step 202：The new field on basic list, obtain extension list.
In embodiments of the present invention, personnel are implemented according to business demand, newly-increased one or more fields on basic list,
Extension list corresponding to obtaining, and define the list dimension of extension list.
For example, according to group X requirement, reimbursing travelling expenses list needs " place of going on business " field, and company under group X
A requirements need have different allowance standards according to different employee's types (formal employee and practice employee) to travel charge.According to
Company A implements the triggering of personnel, and the list dimension defined in basic list A submits an expense account type, definition extension list B list dimension
It is worth and is submitted an expense account for poor travelling expenses, addition " place of going on business " field, " employee's type " field and " subsidy " field, includes 7 so as to obtain
The extension list B of individual field.
Step 203：Rule definition is imported and exported according to basis and imports and exports rule corresponding to the extension of extension list.
In embodiments of the present invention, after extension list is obtained, give a definition correspondingly in list dimension corresponding to expansion table list
Extension import and export rule, first by the basis under list dimension import and export rule content it is copied come, and replace base
The basic model that plinth imports and exports rule is the extended model in extension list, then carries out the rule setting of personalization, obtains
Extension imports and exports rule.And the second data exchange bag according to corresponding to extension imports and exports rule generation.
For example, according to the triggering for implementing personnel, it is copied that basis corresponding to basic list A is imported and exported into regular A first
Come, then define the derived rule of " place of going on business " field and " employee's type " field, and define the importing rule of " subsidy " field
Then, most basis imports and exports regular A at last and the importing rule and derived rule of 3 new fields of definition are defined as extension and led
Enter derived rule B, and the data exchange bag B according to corresponding to extension imports and exports regular B generations.
Step 204：According to instruction is imported and exported, extension list is carried out importing processing or export is handled.
In embodiments of the present invention, after the instruction of the importing from outside or export instruction is received, obtain corresponding
Extension imports and exports rule, and extension list is carried out importing processing or export is handled.Specifically, export processing is as shown in figure 3, lead
It is as shown in Figure 4 to enter processing.
As shown in figure 3, extension list is derived journey and may include steps of：
Step 301：List export instruction is received, list dimension is obtained and basis imports and exports rule.
In embodiments of the present invention, after list export instruction is received, acquisition to be exported table corresponding to expansion table list
Single dimension and basis import and export rule.
For example, after receiving for extension list B export instruction, list dimension report corresponding to extension list B is obtained
Pin type and extension import and export regular B.
Step 302：Rule judgment is imported and exported according to list dimension and basis to import and export with the presence or absence of corresponding extension
Rule, if it is, performing step 303, otherwise perform step 304.
In embodiments of the present invention, rule is imported and exported according to the list dimension got and basis, if it is determined that
Be present corresponding extension and import and export rule in derived extension list, then imported and exported according to corresponding extension regular to be led
The extension list gone out carries out export processing, correspondingly performs step 303；If it is determined that derived extension list is wanted to be not present pair
The extension answered imports and exports rule, then the basis corresponding to imports and exports rule to wanting derived extension list to export
Processing, correspondingly perform step 304.
For example, if the extension for not having definition extension list B in step 203 imports and exports regular B, receiving for expanding
When opening up list B export instruction, step 304 is correspondingly performed；If extension list B expansion is equally defined in phase step 203
Exhibition imports and exports regular B, when receiving the export instruction for extension list B, correspondingly performs step 303.
Step 303：Perform extension and import and export data exchange bag corresponding to rule, and perform step 305.
In embodiments of the present invention, perform according to list dimension and basis import and export that rule searching arrives with extending list
Corresponding data exchange bag, export processing is carried out to extension list, performs step 305 afterwards.
For example, performing data exchange bag B, export processing is carried out to extension list B, 7 fields that extension list B is included
All export, then perform step 305.
Step 304：Perform basis and import and export data exchange bag corresponding to rule.
In embodiments of the present invention, perform to be exported the data exchange that basis corresponding to expansion table list imports and exports rule
Bag, export processing is carried out to extension list.
For example, perform data exchange bag A, to extension list B carry out export processing, by extend list B include name, go out
4 raw days, job number, department field export.
Step 305：Derived list is generated into data file and downloaded.
For example, by derived extension list generation excel files, then it is downloaded for implementation personnel.
As shown in figure 4, extension list importing process may include steps of：
Step 401：Receive list and import instruction, obtain list dimension and basis imports and exports rule.
In embodiments of the present invention, after receiving list and importing instruction, acquisition to be imported table corresponding to expansion table list
Single dimension and basis import and export rule.
For example, after receiving for extension list B importing instruction, list dimension report corresponding to extension list B is obtained
Pin type and extension import and export regular B.
Step 402：Rule judgment is imported and exported according to list dimension and basis to import and export with the presence or absence of corresponding extension
Rule, if it is, performing step 403, otherwise perform step 404.
In embodiments of the present invention, rule is imported and exported according to the list dimension got and basis, if it is determined that
Be present corresponding extension and import and export rule in the extension list of importing, then imported and exported according to corresponding extension regular to be led
The extension list entered carries out importing processing, correspondingly performs step 403；If it is determined that it is to be imported extension list be not present pair
The extension answered imports and exports rule, then the basis corresponding to imports and exports rule and extension list to be imported is imported
Processing, correspondingly perform step 404.
For example, if the extension for not having definition extension list B in step 203 imports and exports regular B, receiving for expanding
When opening up list B importing instruction, step 404 is correspondingly performed；If extension list B expansion is equally defined in phase step 203
Exhibition imports and exports regular B, when receiving the importing instruction for extension list B, correspondingly performs step 403.
Step 403：Perform extension and import and export data exchange bag corresponding to rule, and perform step 405.
In embodiments of the present invention, it is right when extension list to be imported, which has corresponding extension, imports and exports rule
The file to be uploaded is detected, and is performed after detection passes through with to be imported the single-phase corresponding data exchange bag of expansion table,
Extension list is imported to the data for including the file to be uploaded, performs step 405 afterwards.
For example, performing data exchange bag B, importing processing is carried out to extension list B, file to be uploaded included each
The subsidy of employee is imported into extension list B under " subsidy " field, then performs step 405.
Step 404：Perform basis and import and export data exchange bag corresponding to rule.
In embodiments of the present invention, when corresponding extension, which is not present, in extension list to be imported imports and exports rule,
Obtain and import and export regular corresponding data exchange bag with basis, the file to be uploaded is detected, passed through in detection
Perform afterwards and import and export regular corresponding data exchange bag with basis, the data that the file to be uploaded is included are imported
Extend list.
For example, performing data exchange bag A, extension list B is carried out leading processing, each zooid that file to be uploaded is included
The subsidy of work is imported into extension list B under the field reserved.
Step 405：Refresh extension list, complete to import.
It should be noted that in embodiments of the present invention, import and export rule for basis and extension imports and exports rule
With following constraint：
A：Basis imports and exports rules/extensions and imports and exports the corresponding data exchange bag of rule, is imported deleting basis
Derived rule/extension needs to delete corresponding data exchange bag while importing and exporting rule；
B：Basis, which imports and exports rule and defined according to different dimensions, can extend different extensions and import and export rule, i.e.,
One basis, which is imported and exported under rule, may have multiple extensions to import and export rule.
C：Basis is imported and exported in rule after importing and exporting the content modification of rule, it is necessary to be synchronized to all extensions,
It need not extend and import and export the modification of rule one by one.
D：When definition extension imports and exports rule, modification basis is not allowed to import and export the content defined in rule,
Extension, which imports and exports rule, can only edit expansible content.
E：Expanded basis, which imports and exports rule, not to be allowed to delete.
As shown in Figure 5, Figure 6, the embodiments of the invention provide a kind of list to import and export device.Device embodiment can lead to
Software realization is crossed, can also be realized by way of hardware or software and hardware combining.For hardware view, as shown in figure 5, being
A kind of hardware structure diagram of equipment where list provided in an embodiment of the present invention imports and exports device, except the processing shown in Fig. 5
Outside device, internal memory, network interface and nonvolatile memory, the equipment in embodiment where device can also generally include
Other hardware, such as it is responsible for the forwarding chip of processing message.Exemplified by implemented in software, as shown in fig. 6, being anticipated as a logic
Device in justice, it is to be read corresponding computer program instructions in nonvolatile memory by the CPU of equipment where it
Operation is formed in internal memory.The list that the present embodiment provides imports and exports device, including：Acquiring unit 601, form definition unit
602nd, regular definition unit 603 and unit 604 is imported and exported；
Acquiring unit 601, rule is imported and exported for basis corresponding to obtaining basic list and underlying table list；
Form definition unit 602, for increasing at least one field on the basic list that is obtained in acquiring unit 601 newly, obtain
List must be extended；
Regular definition unit 603, on the basis of importing and exporting rule on the basis that acquiring unit 601 obtains, to table
The rule that imports and exports of the newly-increased at least one field of single definition unit 602 is defined, and is obtained single-phase corresponding with expansion table
Extension imports and exports rule；
Import and export unit 604, for receive outside input import and export instruction after, according to regular definition unit
603 extensions obtained import and export the extension list that rule obtains to form definition unit 602 and carry out importing and exporting processing.
Alternatively, on the basis of list imports and exports device shown in Fig. 6,
Form definition unit 602, it is further used for the list dimension of definition extension list；
Regular definition unit 603, it is further used for the data exchange bag according to corresponding to extension imports and exports rule generation, and
Data exchange bag is stored；
Unit 604 is imported and exported, rule is imported and exported for list dimension and basis according to corresponding to expansion table list, is searched
With the single-phase corresponding data exchange bag of expansion table, extension list is carried out importing and exporting processing by performing data exchange bag.
Alternatively, on the basis of list imports and exports device shown in Fig. 6,
Regular definition unit 603, rule is imported and exported for defining the first of newly-increased at least one field, and judgement is
It is no to receive the outside triggering being defined at least one undefined field that basic list includes, wherein, undefined field
Based on import and export the field that is not related to of rule, if it is, defining at least one undefined field according to the triggering of outside
Second imports and exports rule, and rule is imported and exported to basis, first rule is imported and exported and second imports and exports regular progress
Integrate, obtain extension and import and export rule, rule and first is otherwise imported and exported to basis and imports and exports rule and integrates, is obtained
It must extend and import and export rule.
Alternatively, on the basis of list imports and exports device shown in Fig. 6, as shown in fig. 7, the list imports and exports device
It can also include：Policy Updates unit 705；
Policy Updates unit 705, for detecting that basis imported and exported after rule is updated, the importing after renewal is led
Go out the extension that regular and synchronized is got to regular definition unit 603 to import and export in rule.
The contents such as the information exchange between each unit, implementation procedure in said apparatus, due to implementing with the inventive method
Example is based on same design, and particular content can be found in the narration in the inventive method embodiment, and here is omitted.
The embodiment of the present invention additionally provides a kind of computer-readable recording medium, including execute instruction, when the processor of storage control is held
During the row execute instruction, the storage control performs the list lead-in and lead-out method that above-mentioned each embodiment provides.
The embodiment of the present invention additionally provides a kind of storage control, including：Processor, memory and bus；
The memory is used to store execute instruction, and the processor is connected with the memory by the bus, when
During the storage control operation, the execute instruction of memory storage described in the computing device, so that the storage
Controller performs the list lead-in and lead-out method that above-mentioned each embodiment provides.
In summary, the list lead-in and lead-out method and device that each embodiment of the present invention provides, at least have has as follows
Beneficial effect：
1st, in embodiments of the present invention, the basis corresponding to get basic list and underlying table list imports and exports rule
Afterwards, one or more fields are increased newly on basic list and obtain extension list, on the basis of importing and exporting rule on basis, to new
The rule that imports and exports of each field increased is defined, and is obtained and is imported and exported rule with the single-phase corresponding extension of expansion table, when
Receive outside import and export instruction after, according to extension import and export rule to extension list carry out importing and exporting processing.By
This is visible, user by increase on the basis of existing basic list field can with the extension list needed for obtaining, while
Existing basis imports and exports and the rule that imports and exports of new field is defined and can be used for pair with obtaining on the basis of rule
The extension that extension list is imported and exported imports and exports rule, and user need not redefine whole list and entirely import and export
Rule, reduce workload when being imported and exported to list, so as to improve the usage experience of user.
2nd, in embodiments of the present invention, the data exchange bag according to corresponding to extension imports and exports rule generation, and by data
Exchange bag to be stored, rule more easily can be imported and exported to extension and be managed.Needing to carry out extension list
When importing or exporting processing, rule is imported and exported according to the list dimension of extension list and basis, quickly can find and expand
The corresponding data exchange bag of list is opened up, rule can be imported and exported according to extension to extending list by performing data exchange bag
Imported or export is handled.
3rd, in embodiments of the present invention, it is to import and export to obtain on rule-based approach on basis because extension imports and exports rule
, after basis, which imports and exports rule, to be updated, in order to guarantee to import and export rule to extension list progress according to extension
Normal import and export is imported and exported in rule, it is necessary to which the basis after renewal is imported and exported into regular and synchronized to extension.It is in addition, multiple
Extension, which imports and exports rule and may correspond to same basis, imports and exports rule, after importing and exporting Policy Updates on basis, by base
Plinth import and export rule be synchronized to respectively it is each cause its extension to import and export in rule, without respectively to it is each extension import
Derived rule is modified, and conveniently importing and exporting rule to extension safeguards.
4th, in embodiments of the present invention, list based on original table nonoculture can be defined extension list, can also incited somebody to action
List defines new extension list based on the expansion table nonoculture of defined completion.On the one hand, selected according to business demand
List defines new extension list based on original list or suitable expansion table nonoculture, can further reduce definition extension
The workload of list, improve and carry out the efficiency that list imports and exports.On the other hand, by original list or the extension of defined completion
List based on list, the needs of the self-defined personalized extension list of different user can be met, improve list importing
The applicability of deriving method.
It should be noted that herein, such as first and second etc relational terms are used merely to an entity
Or operation makes a distinction with another entity or operation, and not necessarily require or imply and exist between these entities or operation
Any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant be intended to it is non-
It is exclusive to include, so that process, method, article or equipment including a series of elements not only include those key elements,
But also the other element including being not expressly set out, or also include solid by this process, method, article or equipment
Some key elements.In the absence of more restrictions, by sentence " including the key element that a 〃 〃 " is limited, it is not excluded that
Other identical factor in the process including the key element, method, article or equipment also be present.
One of ordinary skill in the art will appreciate that：Realizing all or part of step of above method embodiment can pass through
Programmed instruction related hardware is completed, and foregoing program can be stored in computer-readable storage medium, the program
Upon execution, the step of execution includes above method embodiment；And foregoing storage medium includes：ROM, RAM, magnetic disc or light
Disk etc. is various can be with the medium of store program codes.
It is last it should be noted that：Presently preferred embodiments of the present invention is the foregoing is only, is merely to illustrate the skill of the present invention
Art scheme, is not intended to limit the scope of the present invention.Any modification for being made within the spirit and principles of the invention,
Equivalent substitution, improvement etc., are all contained in protection scope of the present invention.
Claims (10)
- A kind of 1. list lead-in and lead-out method, it is characterised in that including：Basis corresponding to obtaining basic list and the underlying table list imports and exports rule；Increase at least one field newly on the basic list, obtain extension list；On the basis of importing and exporting rule on the basis, regular progress is imported and exported to newly-increased at least one field Definition, obtain and import and export rule with the single-phase corresponding extension of the expansion table；Receive outside input import and export instruction after, according to it is described extension import and export rule to it is described extension list enter Row imports and exports processing.
- 2. according to the method for claim 1, it is characterised in thatAfter the acquisition extension list, further comprise：Define the list dimension of the extension list；After the acquisition imports and exports rule with the single-phase corresponding extension of the expansion table, further comprise：According to described Extension imports and exports data exchange bag corresponding to rule generation, and the data exchange bag is stored；It is described according to it is described extension import and export rule to it is described extension list carry out importing and exporting processing, including：According to described The list dimension and the basis corresponding to expansion table list import and export rule, search and the single-phase corresponding institute of the expansion table Data exchange bag is stated, the extension list is carried out importing and exporting processing by performing the data exchange bag.
- 3. according to the method for claim 1, it is characterised in that it is described import and export rule on the basis on the basis of, The rule that imports and exports of newly-increased at least one field is defined, obtained and the single-phase corresponding extension of the expansion table Rule is imported and exported, including：The first of the newly-increased at least one field of definition imports and exports rule；Judge whether to receive the triggering that the outside at least one undefined field for including the basic list is defined, its In, the undefined field is that the basis imports and exports the field that rule is not related to；If it is, defining the second of at least one undefined field according to the triggering of outside imports and exports rule, and to institute State basis and import and export regular, described first and import and export that regular and described second imports and exports rule and integrated, obtain institute State extension and import and export rule；If not, being imported and exported to the basis, regular and described first imports and exports rule and integrates, and obtains the extension Import and export rule.
- 4. according to the method for claim 1, it is characterised in that in the acquisition and the single-phase corresponding extension of the expansion table After importing and exporting rule, further comprise：After detecting that the basis imports and exports rule and is updated, regular and synchronized will be imported and exported described in after renewal to described Extension is imported and exported in rule.
- 5. according to any described method in Claims 1-4, it is characterised in thatThe basic list includes：Original list or reference extension list, wherein,The original list is the list being pre-created；The extension list of quoting is to increase at least one field newly on the original list or other described application extension lists The list of acquisition.
- 6. according to any described method in Claims 1-4, it is characterised in thatThe basis, which imports and exports rule, to be included：ExportRange, derived field sequence, export filter condition, export mapping relations, Position is imported, filter condition is imported and imports any one or more in mapping relations；And/orThe extension, which imports and exports rule, to be included：ExportRange, derived field sequence, export filter condition, export mapping relations, Position is imported, filter condition is imported and imports any one or more in mapping relations.
- 7. a kind of list imports and exports device, it is characterised in that including：Acquiring unit, form definition unit, regular definition unit With import and export unit；The acquiring unit, rule is imported and exported for basis corresponding to obtaining basic list and the underlying table list；The form definition unit, for increasing at least one field on the basic list that is obtained in the acquiring unit newly, Obtain extension list；The regular definition unit, it is right on the basis of importing and exporting rule on the basis that the acquiring unit obtains The rule that imports and exports of the newly-increased at least one field of the form definition unit is defined, and is obtained and the expansion table Extension imports and exports rule corresponding to single-phase；It is described to import and export unit, for receive outside input import and export instruction after, it is single according to the rule definition The extension that member obtains imports and exports the extension list that rule obtains to the form definition unit and imported and exported Processing.
- 8. device according to claim 7, it is characterised in thatThe form definition unit, it is further used for defining the list dimension of the extension list；The regular definition unit, it is further used for the data exchange bag according to corresponding to the extension imports and exports rule generation, And the data exchange bag is stored；It is described to import and export unit, imported and exported for the list dimension and the basis according to corresponding to the expansion table list Rule, lookup and the single-phase corresponding data exchange bag of the expansion table, by performing the data exchange bag to the expansion Exhibition list carries out importing and exporting processing.
- 9. device according to claim 7, it is characterised in thatThe regular definition unit, first for defining newly-increased at least one field imports and exports rule, and judges Whether triggering that the outside at least one undefined field that to the basic list includes be defined is received, wherein, it is described Undefined field is that the basis imports and exports the field that rule is not related to, if it is, according to the triggering of outside definition extremely The second of a few undefined field imports and exports rule, and regular, described first is imported and exported to the basis and is imported and exported It is regular and described second imports and exports rule and integrated, obtain the extension and import and export rule, otherwise the basis is led Enter derived rule and described first to import and export rule and integrated, obtain the extension and import and export rule.
- 10. device according to claim 7, it is characterised in that further go to include：Policy Updates unit；The Policy Updates unit, for detecting that the basis imported and exported after rule is updated, described in after renewal The extension that regular and synchronized is got to the regular definition unit is imported and exported to import and export in rule.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711256978.4A CN107895047A (en) | 2017-12-04 | 2017-12-04 | A kind of list lead-in and lead-out method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711256978.4A CN107895047A (en) | 2017-12-04 | 2017-12-04 | A kind of list lead-in and lead-out method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107895047A true CN107895047A (en) | 2018-04-10 |
Family
ID=61807257
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711256978.4A Pending CN107895047A (en) | 2017-12-04 | 2017-12-04 | A kind of list lead-in and lead-out method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107895047A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101149737A (en) * | 2007-05-10 | 2008-03-26 | 廖义洪 | Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word |
| US20090259986A1 (en) * | 2008-04-14 | 2009-10-15 | International Business Machines Corporation | Class selectable design sharing |
| CN105808375A (en) * | 2014-12-31 | 2016-07-27 | 航天信息软件技术有限公司 | Data import method and device |
| CN106095837A (en) * | 2016-06-01 | 2016-11-09 | 杭州中奥科技有限公司 | It is applicable to data system and the data processing method of industrial and commercial all kinds of business |
| CN106354513A (en) * | 2016-09-13 | 2017-01-25 | 济南浪潮高新科技投资发展有限公司 | Layered development method for form |
-
2017
- 2017-12-04 CN CN201711256978.4A patent/CN107895047A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101149737A (en) * | 2007-05-10 | 2008-03-26 | 廖义洪 | Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word |
| US20090259986A1 (en) * | 2008-04-14 | 2009-10-15 | International Business Machines Corporation | Class selectable design sharing |
| CN105808375A (en) * | 2014-12-31 | 2016-07-27 | 航天信息软件技术有限公司 | Data import method and device |
| CN106095837A (en) * | 2016-06-01 | 2016-11-09 | 杭州中奥科技有限公司 | It is applicable to data system and the data processing method of industrial and commercial all kinds of business |
| CN106354513A (en) * | 2016-09-13 | 2017-01-25 | 济南浪潮高新科技投资发展有限公司 | Layered development method for form |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8340995B2 (en) | Method and system of using artifacts to identify elements of a component business model | |
| US20140129268A1 (en) | Role discovery using privilege cluster analysis | |
| US20090006315A1 (en) | Structured method for schema matching using multiple levels of ontologies | |
| CN104662535A (en) | Mapping entities in data models | |
| CN110083623A (en) | A kind of business rule generation method and device | |
| JP2017531241A (en) | High speed railway vehicle rapid design method and system | |
| CN106022568A (en) | Workflow processing method and apparatus | |
| CN106126540A (en) | Data base access system and access method thereof | |
| CN106844514A (en) | A kind of page makeup method and terminal | |
| CN108280562A (en) | A kind of method of specification electric power enterprise data resource | |
| CN105096033B (en) | It is a kind of that the method and apparatus of decision information are provided | |
| CN107644317A (en) | A kind of service enabler based on multi-level two-way circulation control | |
| CN103984554B (en) | The generation method and device of Software for Design document | |
| CN106250110A (en) | Set up the method and device of model | |
| CN111061679A (en) | Method and system for rapid configuration of technological innovation policy based on rete and drools rules | |
| CN107741845A (en) | A kind of generation method and device of self defined class example | |
| Alebrahim et al. | Optimizing functional and quality requirements according to stakeholders’ goals | |
| Horvath | New methods on the way to intelligent modeling in computer integrated engineering | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| CN107895047A (en) | A kind of list lead-in and lead-out method and device | |
| CN110377620A (en) | A kind of material searching method, computer and storage medium based on BOM tool | |
| CN109976719A (en) | A kind of design method of management system, electronic equipment, storage medium and platform | |
| US20140149186A1 (en) | Method and system of using artifacts to identify elements of a component business model | |
| CN109145545A (en) | A kind of processing method and processing device of user's operation | |
| Coyne et al. | Role engineering: Methods and standards |
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 |
Application publication date: 20180410 |
|
| RJ01 | Rejection of invention patent application after publication |