CN107766313B - A kind of introduction method and its terminal of data list - Google Patents
A kind of introduction method and its terminal of data list Download PDFInfo
- Publication number
- CN107766313B CN107766313B CN201710979300.2A CN201710979300A CN107766313B CN 107766313 B CN107766313 B CN 107766313B CN 201710979300 A CN201710979300 A CN 201710979300A CN 107766313 B CN107766313 B CN 107766313B
- Authority
- CN
- China
- Prior art keywords
- list
- column
- columns
- data
- data list
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention is suitable for technical field of data processing, provides the introduction method and its terminal of a kind of data list, comprising: obtains the data list to be imported that user terminal is sent;Current matching columns N is obtained, and is matched in the gauge outfit of standard list template from the gauge outfit that N is arranged arbitrarily is extracted in the column of the non-successful match of data list;The gauge outfit of any N column successful match in the gauge outfit of standard list template if it does not exist, then as the current matching columns after subtracting one for the numerical value of N;The gauge outfit of any N column successful match in the gauge outfit of standard list template if it exists, then the N column of successful match in data list are directed respectively into standard list template in corresponding column, and determine current matching columns according to the columns of successful match non-in data list.The present invention, solves available data list leading-in technique, and server needs in the data list listings format and standard list template is completely the same can just carry out import operation, the lower problem of serious forgiveness.
Description
Technical field
The invention belongs to technical field of data processing more particularly to the introduction methods and its terminal of a kind of data list.
Background technique
As various file carries out electronization, user is in routine work and life, it is often necessary to will be local
Data list imported into server, so that relevant information is integrated, analyzed and is counted in the future, therefore how quasi-
Data list, which really is imported into server, is particularly important.And available data list leading-in technique, server receive user
When data list to be imported, needs in the data list listings format and standard list template is completely the same can just be led
Enter operation, if user because personal use is accustomed to, by the location swap of column certain in table, or is inserted into original column and increases newly
Column or delete original column, server will be unable to identify, be determined as mistake table, to upload or import failure, serious forgiveness
It is lower.
Summary of the invention
In view of this, the embodiment of the invention provides a kind of introduction method of data list and its terminal, it is existing to solve
Data list leading-in technique, when server receives user's data list to be imported, need in the data list listings format with
Standard list template is completely the same can just to carry out import operation, if user is because personal use is accustomed to, by column certain in table
Location swap, or be inserted into original column newly-increased column or delete original column, server will be unable to identify, be determined as mistake
Accidentally table, to upload or import failure, the lower problem of serious forgiveness.
The first aspect of the embodiment of the present invention provides a kind of introduction method of data list, the importing of the data list
Method includes:
Obtain the data list to be imported that user terminal is sent;
Current matching columns N is obtained, and arbitrarily extracts the gauge outfit of N column from the column of the non-successful match of the data list
It is matched in the gauge outfit of standard list template, columns and institute of the initial value of the matching columns N for the data list
State the smaller value in the columns of standard list template;
If in the data list there is no any N column gauge outfit matched in the gauge outfit of the standard list template at
Function, then as the current matching columns after subtracting one for the numerical value of N;
If in the data list there are any N column gauge outfit in the gauge outfit of the standard list template successful match,
Then the N column of successful match in the data list are directed respectively into the standard list template in corresponding column, and according to institute
The columns for stating non-successful match in data list determines the current matching columns;
Return execute it is described obtain current matching columns N, and from the non-successful match of data list to be imported
The gauge outfit that N column are arbitrarily extracted in column carries out matched operation in the gauge outfit of the standard list template, until the numerical value of N is kept to
Zero.
The second aspect of the embodiment of the present invention provides a kind of terminal device, including memory, processor and is stored in
In the memory and the computer program that can run on the processor, when the processor executes the computer program
It performs the steps of
Obtain the data list to be imported that user terminal is sent;
Current matching columns N is obtained, and arbitrarily extracts the gauge outfit of N column from the column of the non-successful match of the data list
It is matched in the gauge outfit of standard list template, columns and institute of the initial value of the matching columns N for the data list
State the smaller value in the columns of standard list template;
If in the data list there is no any N column gauge outfit matched in the gauge outfit of the standard list template at
Function, then as the current matching columns after subtracting one for the numerical value of N;
If in the data list there are any N column gauge outfit in the gauge outfit of the standard list template successful match,
Then the N column of successful match in the data list are directed respectively into the standard list template in corresponding column, and according to institute
The columns for stating non-successful match in data list determines the current matching columns;
Return execute it is described obtain current matching columns N, and from the non-successful match of data list to be imported
The gauge outfit that N column are arbitrarily extracted in column carries out matched operation in the gauge outfit of the standard list template, until the numerical value of N is kept to
Zero.
The third aspect of the embodiment of the present invention provides a kind of computer readable storage medium, the computer-readable storage
Media storage has computer program, and the computer program performs the steps of when being executed by processor
Obtain the data list to be imported that user terminal is sent;
Current matching columns N is obtained, and arbitrarily extracts the gauge outfit of N column from the column of the non-successful match of the data list
It is matched in the gauge outfit of standard list template, columns and institute of the initial value of the matching columns N for the data list
State the smaller value in the columns of standard list template;
If in the data list there is no any N column gauge outfit matched in the gauge outfit of the standard list template at
Function, then as the current matching columns after subtracting one for the numerical value of N;
If in the data list there are any N column gauge outfit in the gauge outfit of the standard list template successful match,
Then the N column of successful match in the data list are directed respectively into the standard list template in corresponding column, and according to institute
The columns for stating non-successful match in data list determines the current matching columns;
Return execute it is described obtain current matching columns N, and from the non-successful match of data list to be imported
The gauge outfit that N column are arbitrarily extracted in column carries out matched operation in the gauge outfit of the standard list template, until the numerical value of N is kept to
Zero.
The introduction method and its terminal for implementing a kind of data list provided in an embodiment of the present invention have the advantages that
The embodiment of the present invention is after the data list to be imported for receiving user terminal transmission, then according to data list
The columns of columns and standard list template determines current matching columns N, and the table of N column is arbitrarily extracted from data list
Head is matched with the gauge outfit of standard list template, is imported into standard list template in corresponding column if successful match, and
Current matching columns N is adjusted, the N column for extracting non-successful match again are matched with standard list template;Conversely, if matching
Failure then reduces the numerical value of N, returns and executes the step of extracting matching, to realize the matched process of loop nesting, data are arranged
Corresponding content is imported into standard list template in table.Compared with existing data list leading-in technique, the embodiment of the present invention
In even if data list to be imported respectively arrange between relative position modified, terminal device also can be from data list to be imported
In gradually extract the column of respective numbers and matched one by one with the gauge outfit in standard list template, can't be because of table between the two
The sequence of head is inconsistent and is identified as error listing, the serious forgiveness of importing process is improved, to improve data importing
Efficiency and user operating experience.
Detailed description of the invention
It to describe the technical solutions in the embodiments of the present invention more clearly, below will be to embodiment or description of the prior art
Needed in attached drawing be briefly described, it should be apparent that, the accompanying drawings in the following description is only of the invention some
Embodiment for those of ordinary skill in the art without any creative labor, can also be according to these
Attached drawing obtains other attached drawings.
Fig. 1 is a kind of implementation flow chart of the introduction method for data list that first embodiment of the invention provides;
Fig. 2 is the specific implementation flow of the introduction method S104 for data list that second embodiment of the invention provides a kind of
Figure;
Fig. 3 is a kind of specific implementation flow chart of the introduction method for data list that third embodiment of the invention provides;
Fig. 4 is the specific implementation flow of the introduction method S101 for data list that fourth embodiment of the invention provides a kind of
Figure;
Fig. 5 is a kind of structural block diagram of the importing terminal for data list that one embodiment of the invention provides;
Fig. 6 is a kind of schematic diagram for terminal device that one embodiment of the invention provides.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
The embodiment of the present invention is after the data list to be imported for receiving user terminal transmission, then according to data list
The columns of columns and standard list template determines current matching columns N, and the table of N column is arbitrarily extracted from data list
Head is matched with the gauge outfit of standard list template, is imported into standard list template in corresponding column if successful match, and
Current matching columns N is adjusted, the N column for extracting non-successful match again are matched with standard list template;Conversely, if matching
Failure then reduces the numerical value of N, returns and executes the step of extracting matching, to realize the matched process of loop nesting, data are arranged
Corresponding content is imported into standard list template in table, solves available data list leading-in technique, and server receives user
When data list to be imported, needs in the data list listings format and standard list template is completely the same can just be led
Enter operation, if user because personal use is accustomed to, by the location swap of column certain in table, or is inserted into original column and increases newly
Column or delete original column, server will be unable to identify, be determined as mistake table, to upload or import failure, serious forgiveness
Lower problem.
In embodiments of the present invention, the executing subject of process is the terminal device for being equipped with the importing program of data list,
Terminal device includes the terminals such as mobile phone, computer equipment, tablet computer, server, and particularly, which is specially a number
According to library, saved for receiving the data list of each user terminal uploads and being directed into local storage.Fig. 1 is shown
The implementation flow chart of the introduction method for the data list that first embodiment of the invention provides, details are as follows:
In S101, the data list to be imported that user terminal is sent is obtained.
In the present embodiment, user imports request by generating data in local user terminal, then passes through communication network
Network is connected with terminal device provided in this embodiment, and sends data to terminal device and import request.Specifically, user is by opening
The client that the dynamic data list being set in user terminal imports, to realize the operation for sending data and importing request.User is whole
It holds when the client for detecting that data list imports is activated, a data will be generated and import request instruction, and be sent to end
End equipment, to establish communication connection and to inform that terminal user needs to carry out data import operation.
In the present embodiment, after the data that terminal device determines that response user terminal is initiated import request, one will be returned
A data list acquisition instruction, user terminal is after receiving the data list acquisition instruction, then from document queue to be sent
In, data list to be imported is sent to terminal device, terminal device then executes after receiving data list to be imported
The relevant operation of S102.
Optionally, in the present embodiment, it includes user right, terminal device in request that the data that user terminal is sent, which import,
Receive user transmission data import request after, by extract it includes user right, may then determine whether to respond the number
It is requested according to importing.Further, the data that user sends import request and also identify comprising object listing, are used to indicate required importing
Object listing.Therefore, terminal device can also be by the corresponding use for importing permission and data importing request includes of object listing
Family permission is matched, and determines whether the user has the permission for importing data to the object listing.By above-mentioned means, pass through
User right authenticates import operation, can avoid illegal user's malice and uploads data, improves the safety of terminal device.
In S102, current matching columns N is obtained, and arbitrarily extract from the column of the non-successful match of the data list
The gauge outfit of N column is matched in the gauge outfit of standard list template, and the initial value of the matching columns N is the data list
Smaller value in columns and the columns of the standard list template.
In the present embodiment, terminal device will determine after the data list to be imported for receiving user terminal transmission
The corresponding standard list template of the data list, and identify the columns that the data list includes.The column for including according to data list
Several and standard list template columns chooses in the two a lesser columns value as current and matches the initial of columns N
Numerical value.Illustratively, if data list to be imported includes 8 column, and standard list template includes 9 column, the then current matching
The initial value of columns N is 8.Specifically, if the columns of data list is identical as the columns of standard list template, it can use the two and appoint
It anticipates an initial value as N.
In the present embodiment, terminal device is after the initial value for determining current matching columns N, then according to the matching columns
N arbitrarily extracts the gauge outfit of N column from data list to be imported, it is matched with the gauge outfit in standard list template, after
And determine that N is listed in standard list template with the presence or absence of corresponding column in data list.Specifically, terminal device is in data list
Middle extraction N column, are listed in the sequence in data list according to N, form a gauge outfit, and will appoint in the gauge outfit and standard list template
The gauge outfit of meaning N column composition is matched, and is determined whether two gauge outfits are identical, if the two is identical, is determined successful match, executes
The relevant operation of S104;Conversely, being determined as that it fails to match if two gauge outfits are not identical, and continue and standard list template
In other N column composition gauge outfit matched.If it fails to match for the gauge outfit of any N column composition in data list, then from
Other N column datas are extracted in data list and form another gauge outfit, and are repeated the above steps, until traversal chooses all N columns
The step of can not being matched to corresponding gauge outfit in standard list template according to the gauge outfit of composition, then execute S103.
Illustratively, the concrete operations process in S102 is illustrated with following example.Referring to shown in table 1 and table 2, table 1
For the standard list template that one embodiment of the invention provides, table 2 is the data list to be imported of user terminal uploads.Firstly,
Terminal device will determine the initial value of current matching columns N, due to two after the data list for receiving user terminal transmission
The columns for including in a list is 9, and therefore, the initial value of N is 9.Then, terminal device extracts 9 columns from data list
According to, and according to the sequence of 9 column data in data list, as [serial number, name, age, gender, identity card insure class
Not, it insures the date, the time limit of insuring, insured amount], a gauge outfit is formed, and matched with the gauge outfit in standard form, due to
The gauge outfit quantity of 9 column compositions in standard form is one, i.e., [serial number, name, gender, age, identity card, coverage are thrown
Protect date, the time limit of insuring, insured amount], two gauge outfits are not identical, therefore jump to the relevant operation for executing S103, will work as
Preceding matching columns N subtracts 1, i.e., N value is 8, and returns to the relevant operation for executing S102.At this point, terminal device can be from data list
Middle extractionThe column of group form gauge outfit, and obtained gauge outfit is matched with the gauge outfit in standard list template, due to standard
The sequence respectively arranged in list template is fixed, therefore the quantity for the gauge outfit being made of in standard list template 8 column is 2, i.e.,
In data listGroup gauge outfit respectively with [serial number, name, gender, age, identity card, coverage are insured the date, are insured
The time limit] and [name, gender, age, identity card, coverage are insured the date, the time limit of insuring, insured amount] the two tables
Head is matched, and executes corresponding step operation according to matching result.
Serial number | Name | Gender | Age | Identification card number | Coverage | It insures the date | It insures the time limit | Insured amount |
1 | Zhang San | X | X | X | X | X | X | X |
2 | Li Si | X | X | X | X | X | X | X |
3 | Sun Wu | X | X | X | X | X | X | X |
4 | Guo Jing | X | X | X | X | X | X | X |
5 | Wang Qiang | X | X | X | X | X | X | X |
6 | He Xiao | X | X | X | X | X | X | X |
… | … | … | … | … | … | … | … | … |
Table 1
Serial number | Name | Age | Gender | Identification card number | Coverage | It insures the date | It insures the time limit | Insured amount |
1 | Zhang San | X | X | X | X | X | X | X |
2 | Li Si | X | X | X | X | X | X | X |
3 | Sun Wu | X | X | X | X | X | X | X |
4 | Guo Jing | X | X | X | X | X | X | X |
5 | Wang Qiang | X | X | X | X | X | X | X |
6 | He Xiao | X | X | X | X | X | X | X |
… | … | … | … | … | … | … | … | … |
Table 2
Optionally, in the present embodiment, the initial value of the N can be arranged in user according to actual needs.If the N value is greater than data
The smaller value, then is identified as the initial value of N by the smaller value in the columns of list and the columns of standard list template.Particularly,
When the initial value of N be 1 when, terminal device will every time extract data list in 1 column, by the gauge outfit of the column one by one with standard list
Each column in template are matched.Referring to shown in Tables 1 and 2, terminal device extracts [serial number] column from data list, with standard
Each column in list template are matched, and after successful match, then execute the relevant operation of S104, then extract next column data and carry out
Matching, i.e. [name] arrange, and repeat above-mentioned steps, match correspondence until being respectively listed in standard list template in data list
Column.
In the present embodiment, according to the use habit of user, even if user becomes the sequence respectively arranged in data list
More, position adjustment only also generally is carried out to certain column or a few column, i.e., most column are according to standard list in list
Sequence in template is ranked up, in view of this, the present embodiment is during matched, directly the gauge outfit that constitutes of extraction N column with
Standard list template is matched, and the probability for capableing of successful match with standard list template is larger, therefore need to only be executed a small amount of
Matching operation can then complete data import operation, and directly set 1 for N, carry out one by one with gauge outfit each in data list template
Matched mode is compared, and matched number is greatly reduced, and improves matched efficiency.
In S103, if gauge outfit of the gauge outfit in the standard list template of any N column is not present in the data list
Middle successful match, then as the current matching columns after subtracting one for the numerical value of N.
In the present embodiment, due to the relative position between each column at the extraction be it is fixed, and in former data list
Relative position be it is identical, as an example with table 2, no matter how the value of N changes, in extracting the gauge outfit that arranges of N, parameter
[insured amount] corresponding column are inevitable after the column of parameter [identity card], if therefore terminal device according to current matching columns
The gauge outfit for any N column composition that N is extracted from data list can not be with the gauge outfit successful match of standard list template, then it represents that
The column that each gauge outfit formed necessarily includes sequence error are arranged with N in data list, therefore current matching will be gradually reduced and arranged
The value of number N, so as in certain extraction operation, in the gauge outfit that is made of N column the sequence of each parameter in standard list template
Gauge outfit is consistent.
In the present embodiment, terminal device gauge outfit of any N column composition in determining data list can not be arranged in standard
Successful match in the gauge outfit of table template then executes the operation of S103, subtracts 1 for the numerical value of current matching columns N, and return to execution
The operation of S102 step.At this point, terminal device before jumping to the operation of S102, can also judge the value of N, if the value of N
The step of reducing to 0, then jumping to S105.
In S104, if there are the gauge outfits of any N column in the gauge outfit of the standard list template in the data list
The N column of successful match in the data list are then directed respectively into the standard list template in corresponding column by successful match,
And the current matching columns is determined according to the columns of successful match non-in the data list.
It in the present embodiment, can be in standard list mould if the gauge outfit for the N column composition that terminal device is obtained in certain extraction
It is matched to corresponding gauge outfit in plate, then is identified as currently extracting by the column for including in the gauge outfit matched in standard list template
N arrange corresponding column, therefore the N of extraction can be arranged included data and be directed respectively into corresponding column in standard list template
It is interior, to complete data import operation.
1 | 2 | 3 | 4 | 5 | 6 |
Serial number | Name | Age | Gender | Identification card number | Coverage |
1 | Zhang San | X | X | X | X |
2 | Li Si | X | X | X | X |
3 | Sun Wu | X | X | X | X |
4 | Guo Jing | X | X | X | X |
5 | Wang Qiang | X | X | X | X |
6 | He Xiao | X | X | X | X |
… | … | … | … | … | … |
Table 3
A | B | C | D | E | F |
Serial number | Name | Gender | Age | Identification card number | Coverage |
1 | Zhang San | X | X | X | X |
2 | Li Si | X | X | X | X |
3 | Sun Wu | X | X | X | X |
4 | Guo Jing | X | X | X | X |
5 | Wang Qiang | X | X | X | X |
6 | He Xiao | X | X | X | X |
… | … | … | … | … | … |
Table 4
Specifically, in the present embodiment, terminal device can be each column of successful match in data list after successful match
It is associated with a corresponding column number in standard list template.Referring to shown in table 3 and table 4, table 3 is that another embodiment of the present invention mentions
The standard list template of confession, wherein the first row is used to indicate the column number of the list, Fig. 4 be another embodiment of the present invention provides
Data list, wherein the first row is used to indicate the column number of the list.If in certain matching process, terminal device identifies data column
The gender column and standard list template matching in table then establish the incidence relation such as C-4, to indicate the column pair of the C in data list
It should be arranged in the 4th in standard list template.Preferably, in the present embodiment, if the numerical value of N is greater than or equal to 2, standard can be arranged
Matched starting column number and termination column number, the N currently extracted as data list arrange corresponding column number in table template.Such as
Current list of matches number is 3, and the gauge outfit that certain 3 column extracted from data list is constituted is [gender, identification card number, insurance
Type], it is matched with the 4th to 6 column in standard list template, therefore the associated column number of the gauge outfit is (4,6).
In the present embodiment, terminal device determine in data list N column in standard list template N arrange match into
After the completion of function and importing, then it will arrange to demarcate from standard list template with the N of successful match and, as without matched
Column, i.e., in matching operation next time, terminal device is no longer by the N column in data list and successful match in standard list template
Column matched, certainly, N that terminal device is extracted from data list column are also the column of non-successful match.
In the present embodiment, terminal device determines current matching columns N, and jump for according to the columns of non-successful match
Turn the relevant operation of execution S105.
Optionally, the minimum value that the columns that is connected is chosen in the column of terminal device never successful match is arranged as current matching
The value of number N.As shown in table 5, the list in left side is the list before successful match, and the list on right side is the list after successful match,
Wherein C is classified as the column of successful match.As it can be seen that after successful match, in remaining column, connected column be respectively the column of AB two and
DEF tri- is arranged, and connected numerical value is respectively 2 and 3, therefore sets 2 for N value.
Table 5
In S105, return execute it is described obtain current matching columns N, and not from the data list to be imported
Matched operation is carried out in the gauge outfit of the standard list template with the gauge outfit for arbitrarily extracting N column in successful column, until N
Numerical value is kept to zero.
In the present embodiment, terminal device will determine first whether current N value has already decreased to 0, if so, indicating to follow
Ring matching process has finished, then stops to recycle;If the N value is non-zero, then it represents that still include non-successful match in data list
Column, and single-row matching is not carried out yet, therefore will return to the operation for executing S102.
Above as can be seen that a kind of introduction method of data list provided in an embodiment of the present invention is receiving user terminal
After the data list to be imported sent, then according to the columns of data list and the columns of standard list template, determine current
Matching columns N, and the gauge outfit for arbitrarily extracting from data list N column is matched with the gauge outfit of standard list template, if
It is then imported into standard list template in corresponding column with success, and adjusts current matching columns N, extracted do not match into again
The N column of function are matched with standard list template;Conversely, reducing the numerical value of N if it fails to match, it is matched to return to execution extraction
Content corresponding in data list is imported into standard list template by step to realize the matched process of loop nesting.With
Existing data list leading-in technique is compared, in the embodiment of the present invention data list to be imported respectively arrange between relative position be
Just it is modified, terminal device also can be from the column and standard list template for gradually extracting respective numbers in data list to be imported
Gauge outfit matched one by one, can't because of gauge outfit between the two sequence it is inconsistent and be identified as error listing, mention
The high serious forgiveness of importing process, to improve the efficiency of data importing and the operating experience of user.
Fig. 2 shows the specific implementation streams of the introduction method S103 of data list of second embodiment of the invention offer a kind of
Cheng Tu.It is shown in Figure 2, relative to embodiment described in Fig. 1, a kind of introduction method S103 of data list provided in this embodiment
Further comprising the steps of, details are as follows:
Further, the columns according to successful match non-in the data list determines the current matching column
Number, comprising:
In S201, if the columns of non-successful match is greater than or equal to N in the data list, keep described current
It is constant to match columns.
In the present embodiment, terminal device is after successful match, by the columns of successful match non-in statistical data list, and
Compare the columns of current non-successful match and the current size matched between columns N.If the columns of non-successful match is less than and works as
Preceding matching columns N, then execute the relevant operation of S202;Conversely, being executed if the columns of non-successful match is greater than or equal to N
The relevant operation of S201.
In the present embodiment, since the columns of non-successful match is greater than or equal to N, then it represents that remain to never successful match
It extracts N column in column to be matched with standard list template, terminal device will keep the numerical value of current matching columns N not at this time
Become, and returns to the relevant operation of S102.
In S202, if the columns of non-successful match is less than N in the data list, by the column of the non-successful match
Number is determined as the current matching columns.
In the present embodiment, the columns of terminal device non-successful match in determining data list is less than N, then it represents that the column
It can not extract in table and be matched with the sufficient amount of column of N value with the column of normal data template, at this point, not matched column will be counted
Number, using the columns numerical value as current matching columns.
Optionally, in the present embodiment, terminal device also will acquire the columns M of non-successful match in standard list template,
If the M value is less than the columns of non-successful match in data list and is less than N, using the M value as current matching columns.Due to
In the data list that user uploads the actual columns for including possibly more than standard list template columns, therefore in successful match
Afterwards, even if the columns of non-successful match be not less than N, but in standard list template can matched columns it is less, at this time should will
Numerical value of the M value as current matching columns N in standard list template.
In embodiments of the present invention, it after the column of terminal device matching a part, is adjusted by not matched columns current
Matching columns cause matching operation abnormal to avoid columns the case where the being unsatisfactory for current columns generation extracted, reduce
Matched efficiency.
Fig. 3 shows a kind of specific implementation flow of the introduction method of data list of third embodiment of the invention offer
Figure.Shown in Figure 3, relative to embodiment described in Fig. 1, a kind of introduction method of data list provided in this embodiment further includes
Following steps, details are as follows:
Further, the introduction method of the data list further include:
In S301, if being included in the standard list template in the data list matched can not arrange, in institute
State created in standard list template in the data list can not the equal column of matched columns, and can not be matched described in general
Column are directed into the newly-built column of the standard list template.
In the present embodiment, user may be added to certain column to carry out data during editing data list
Analysis is assisted, such as on the right side for the column that parameter is [date of birth], one column parameter of addition is the column at [age], directly calculates this
The current age of objects of statistics, without user according to date of birth manual calculations, to facilitate user to divide data list
Analysis.But due to above-mentioned user voluntarily increased column, corresponding column can not be matched in standard list template, therefore can not be direct
It is imported, may be decreased user to the analysis efficiency of data if direct delete.Therefore, terminal device then obtain can not
With successful column, and its corresponding columns is counted, and increases the columns quantity obtained with above-mentioned statistics newly in standard list template
Identical column are imported into the newly-increased column of standard list template to will be unable to matched column.
Optionally, in the present embodiment, work as since the data imported in standard list template are not only corresponding to user
The data list to be imported of preceding upload, but the data that may be imported comprising multiple users, therefore terminal device will be unable to root
According to the position that matched can not be listed in data list, be inserted into newly-increased column in standard list template, but list most
Right side create respective numbers column, and by corresponding parameter name mark with each data in, as shown in table 6, so as to user determine
Newly add the meaning of middle data.
Serial number | Name | Gender | Date of birth | Identification card number | Coverage | Newly-increased 1 | Newly-increased 2 |
1 | Zhang San | X | X | X | X | 13 (ages) | … |
2 | Li Si | X | X | X | X | 22 (ages) | … |
3 | Sun Wu | X | X | X | X | 17 (ages) | … |
4 | Guo Jing | X | X | X | X | 6 (ages) | … |
5 | Wang Qiang | X | X | X | X | 90 (ages) | … |
6 | He Xiao | X | X | X | X | 56 (ages) | … |
… | … | … | … | … | … | … | … |
Table 6
In embodiments of the present invention, by increasing the column of respective numbers newly, and the content in data list imported into newly-increased
Column in, so as to which the content of the customized column of user can be also stored in the standard list template of database, improve
The operability of user also provides personalized setting demand for each user, meets different reading habits.
Further, as another embodiment of the present invention, the introduction method of the data list further include:
In S3021, if there are the column for not importing data in the standard list template, transmission list missing information is extremely
The user terminal.
In the present embodiment, there are in detecting standard list template the column for not importing data in terminal device, then it represents that
The case where there are list missings in the data list that user terminal is sent, possible user is during editor in certain column
Appearance is deleted, therefore does not have that matching column can be found in data list.In this case, terminal device will be according to not
The column of data are imported, list missing information are generated, and the list missing information is sent to user terminal, so that user is to the column
The content of table is supplemented.
In the present embodiment, the table formed in list missing information comprising not importing the column of data in standard list template
Head, the content of parameter supplemented needed for being determined according to the gauge outfit for including in the list missing information so as to user.
It in S3022, receives the supplementary data that the user terminal is returned according to the list missing information and arranges, and by institute
It states supplementary data column and is directed into the column for not importing data in the standard list template.
In the present embodiment, user generates corresponding supplementary data according to list missing information and arranges, wherein the supplement
Data column correspond to the column for not importing data in standard list template.Terminal device is in the supplement number for receiving user terminal return
After column, the data that supplementary data arranges imported into standard list template and do not import number by can be by S102~S105 the step of
According to column in.
Optionally, in the present embodiment, user terminal can also return to upload and complete instruction, i.e., expression user does not return again to
Supplementary data column.Terminal device can not carry out data filling to the column for not importing data after receiving upload and completing instruction, with
Just user is added operation to the contents of the section in the future;Can also be according to preset content, such as fill character " sky " or character
" missing " etc. is filled in the column for not importing data into standard list template.
In embodiments of the present invention, by, with the presence or absence of the column for not importing data, reminding and using in criterion list template
Family uploads supplementary data column, to complete the operation of data importing, avoids for because of inadvertent, and forgets corresponding data
It is uploaded to database, improves the accuracy of upload operation.
Fig. 4 shows the specific implementation stream of the introduction method S101 of data list of fourth embodiment of the invention offer a kind of
Cheng Tu.It is shown in Figure 4, relative to embodiment described in Fig. 1 to Fig. 3, a kind of importing side of data list provided in this embodiment
The data list to be imported that acquisition user terminal described in method is sent includes also S401~S403, and details are as follows:
In S401, the file type of the data list to be imported is identified.
In the present embodiment, terminal device will identify that the data list is corresponding after receiving data list to be imported
File type.Specifically, terminal device is subsequent by identifying the file in the data list, determines that the data list is corresponding
File type.
Optionally, in the present embodiment, terminal device can also judge whether data list to be imported has encrypted, according to
Encryption situation determines the need for carrying out data importing.It is uploaded by that may make an appointment between user terminal and terminal device
File need to carry out cryptographic operation by unified key, if terminal device is detecting the data list to be imported at this time
There is no encrypted by preset key, then it represents that the data list is invalid data list, therefore can be not responding to this and lead
Enter operation.Conversely, if terminal device detects that the data list is encrypted by preset key, then it represents that the data list
For valid data list, the relevant operation of S402 is then executed.
In S402, if the file type with it is preset can lead-in type match, according to preset file corruption school
Checking method determines whether the data list to be imported damages.
In the present embodiment, be preset with the file type that can be imported in terminal device, i.e., it is above-mentioned preset to import class
Type.Illustratively, it is data list that user, which is imported, then this can lead-in type file type also should be comprising data arrange
The type of table, such as Excel file, Word file;Preferably, terminal device can also extract image by image recognition technology
Data list in file, i.e. image file type may be can lead-in type.As it can be seen that terminal device has according to itself
Function, pre-generate it is corresponding can lead-in type then judge this document after obtaining the file type of data list
Type whether belong to terminal device can lead-in type if so, being identified as matching execute the relevant operation of S402;Conversely, if
This document type be not belonging to can lead-in type, then be identified as mismatching, do not return to file type exception information to user terminal or not
The import operation is responded.
In the present embodiment, whether terminal device determines the data list also by preset file corruption checking algorithm
To damage file.Wherein, it is whether complete and readable to be specifically used for verification data listing file for this document damage checking algorithm;It is excellent
Whether selection of land can be also used in verification data list including messy code data.
In S403, if the data list to be imported executes the current matching columns N of the acquisition without damage,
And it is carried out in the gauge outfit of standard list template from the gauge outfit that N is arranged arbitrarily is extracted in the column of the non-successful match of the data list
The operation matched.
In the present embodiment, if terminal device determines that data list without damage, that is, indicates the number by file verification algorithm
Readable and complete according to list, this moment executes the relevant operation of S403, that is, enters the import operation of input list;If terminal device
It determines that the data list damages, then sends file exception information to user terminal, so that user terminal uploads correct number again
According to list.
In embodiments of the present invention, terminal device verifies data list in advance, determine the data list whether be can
The data list of importing improves the success rate of import operation so that the file by mistake be avoided to carry out matching import operation, and
And it avoids carrying out unnecessary import operation.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process
Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
Fig. 5 shows a kind of structural block diagram of the importing terminal of data list of one embodiment of the invention offer, the data
The each unit that the importing terminal of list includes is used to execute each step in the corresponding embodiment of Fig. 1.Referring specifically to Fig. 1 and figure
Associated description in embodiment corresponding to 1.For ease of description, only the parts related to this embodiment are shown.
Referring to Fig. 5, the importing terminal of the data list includes:
Data list transmission unit 51 to be imported, with the data list to be imported for obtaining user terminal transmission;
Data list matching unit 52, for obtaining current matching columns N, and from the non-successful match of the data list
Column in arbitrarily extract N column gauge outfit matched in the gauge outfit of standard list template, it is described matching columns N initial value be
Smaller value in the columns of the data list and the columns of the standard list template;
It fails to match cycling element 53, if the gauge outfit for any N column to be not present in the data list is in the standard
Successful match in the gauge outfit of list template, then as the current matching columns after subtracting one for the numerical value of N;
Successful match cycling element 54, if for there are the gauge outfits of any N column to arrange in the standard in the data list
The N column of successful match in the data list are then directed respectively into the standard list mould by successful match in the gauge outfit of table template
In plate in corresponding column, and the current matching columns is determined according to the columns of successful match non-in the data list;
Matching operation return unit 55, for return execute it is described obtain current matching columns N, and from described to be imported
The non-successful match of data list column in arbitrarily extract N column gauge outfit matched in the gauge outfit of the standard list template
Operation, until the numerical value of N is kept to zero.
Optionally, the successful match cycling element 54 includes:
Coupling number columns value holding unit, if the columns for non-successful match in the data list is greater than or equal to N,
Then keep the current matching columns constant;
Coupling number columns value adjustment unit, if the columns for non-successful match in the data list is less than N, by institute
The columns for stating non-successful match is determined as the current matching columns.
Optionally, the gatherer of the data list further include:
Data list increases unit newly, if can not match for being included in the standard list template in the data list
Column, then created in the standard list template in the data list can not the equal column of matched columns, and by institute
It states matched not arranging and be directed into the newly-built column of the standard list template.
Optionally, the gatherer of the data list further include:
List missing information transmission unit, if being sent out for there are the column for not importing data in the standard list template
Send list missing information to the user terminal;
Supplementary data column import unit, the supplement returned for receiving the user terminal according to the list missing information
Data column, and supplementary data column are directed into the column for not importing data in the standard list template.
Optionally, the data list transmission unit 51 to be imported includes:
File type recognition unit, for identification file type of the data list to be imported;
File corruption verification unit, if for the file type with it is preset can lead-in type match, basis preset
File corruption checking algorithm determine whether the data list to be imported damages;
File imports confirmation unit, if executing described obtain currently without damage for the data list to be imported
Matching columns N, and arbitrarily extract from the column of the non-successful match of the data list gauge outfit of N column in standard list template
Matched operation is carried out in gauge outfit.
Therefore, the importing terminal of data category provided in an embodiment of the present invention can equally be sent receiving user terminal
Data list to be imported after, then according to the columns of data list and the columns of standard list template, determine current
With columns N, and the gauge outfit for arbitrarily extracting from data list N column is matched with the gauge outfit of standard list template, if match at
Function is then imported into standard list template in corresponding column, and adjusts current matching columns N, extracts non-successful match again
N column are matched with standard list template;Conversely, reducing the numerical value of N if it fails to match, returns to execute and extract matched step
Suddenly, to realize the matched process of loop nesting, content corresponding in data list is imported into standard list template.With it is existing
Some data list leading-in techniques are compared, even if data list to be imported in the embodiment of the present invention respectively arrange between relative position
It is modified, terminal device also can be from the column and standard list template for gradually extracting respective numbers in data list to be imported
Gauge outfit is matched one by one, can't because of gauge outfit between the two sequence it is inconsistent and be identified as error listing, improve
The serious forgiveness of importing process, to improve the efficiency of data importing and the operating experience of user.
Fig. 6 be another embodiment of the present invention provides a kind of terminal device schematic diagram.As shown in fig. 6, the embodiment
Terminal device 6 includes: processor 60, memory 61 and is stored in the memory 61 and can transport on the processor 60
Capable computer program 62, such as the importing program of data list.The processor 60 executes real when the computer program 62
Step in the introduction method embodiment of existing above-mentioned each data list, such as S101 shown in FIG. 1 to S105.Alternatively, described
Processor 60 realizes the function of each unit in above-mentioned each Installation practice when executing the computer program 62, such as shown in Fig. 5
51 to 55 function of module.
Illustratively, the computer program 62 can be divided into one or more units, one or more of
Unit is stored in the memory 61, and is executed by the processor 60, to complete the present invention.One or more of lists
Member can be the series of computation machine program instruction section that can complete specific function, and the instruction segment is for describing the computer journey
Implementation procedure of the sequence 62 in the terminal device 6.For example, the computer program 62 can be divided into data column to be imported
Table transmission unit, data list matching unit, it fails to match, and cycling element, successful match cycling element and matching operation return
Unit, each unit concrete function are as follows:
Data list transmission unit to be imported, with the data list to be imported for obtaining user terminal transmission;
Data list matching unit, for obtaining current matching columns N, and from the non-successful match of the data list
The gauge outfit that N column are arbitrarily extracted in column is matched in the gauge outfit of standard list template, and the initial value of the matching columns N is institute
State the smaller value in the columns of data list and the columns of the standard list template;
It fails to match cycling element, if the gauge outfit for any N column to be not present in the data list is arranged in the standard
Successful match in the gauge outfit of table template, then as the current matching columns after subtracting one for the numerical value of N;
Successful match cycling element, if for there are the gauge outfits of any N column in the standard list in the data list
The N column of successful match in the data list are then directed respectively into the standard list template by successful match in the gauge outfit of template
In in corresponding column, and the current matching columns is determined according to the columns of successful match non-in the data list;
Matching operation return unit, for return execute it is described obtain current matching columns N, and from described to be imported
Arbitrarily extracted in the column of the non-successful match of data list N column gauge outfit carried out in the gauge outfit of the standard list template it is matched
Operation, until the numerical value of N is kept to zero.
The terminal device 6 can be the calculating such as desktop PC, notebook, palm PC and cloud server and set
It is standby.The terminal device may include, but be not limited only to, processor 60, memory 61.It will be understood by those skilled in the art that Fig. 6
The only example of terminal device 6 does not constitute the restriction to terminal device 6, may include than illustrating more or fewer portions
Part perhaps combines certain components or different components, such as the terminal device can also include input-output equipment, net
Network access device, bus etc..
Alleged processor 60 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor is also possible to any conventional processor
Deng.
The memory 61 can be the internal storage unit of the terminal device 6, such as the hard disk or interior of terminal device 6
It deposits.The memory 61 is also possible to the External memory equipment of the terminal device 6, such as be equipped on the terminal device 6
Plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card dodge
Deposit card (Flash Card) etc..Further, the memory 61 can also both include the storage inside list of the terminal device 6
Member also includes External memory equipment.The memory 61 is for storing needed for the computer program and the terminal device
Other programs and data.The memory 61 can be also used for temporarily storing the data that has exported or will export.
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each function
Can unit, module division progress for example, in practical application, can according to need and by above-mentioned function distribution by different
Functional unit, module are completed, i.e., the internal structure of described device is divided into different functional unit or module, more than completing
The all or part of function of description.Each functional unit in embodiment, module can integrate in one processing unit, can also
To be that each unit physically exists alone, can also be integrated in one unit with two or more units, it is above-mentioned integrated
Unit both can take the form of hardware realization, can also realize in the form of software functional units.In addition, each function list
Member, the specific name of module are also only for convenience of distinguishing each other, the protection scope being not intended to limit this application.Above system
The specific work process of middle unit, module, can refer to corresponding processes in the foregoing method embodiment, and details are not described herein.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, is not described in detail or remembers in some embodiment
The part of load may refer to the associated description of other embodiments.
Those of ordinary skill in the art may be aware that list described in conjunction with the examples disclosed in the embodiments of the present disclosure
Member and algorithm steps can be realized with the combination of electronic hardware or computer software and electronic hardware.These functions are actually
It is implemented in hardware or software, the specific application and design constraint depending on technical solution.Professional technician
Each specific application can be used different methods to achieve the described function, but this realization is it is not considered that exceed
The scope of the present invention.
In embodiment provided by the present invention, it should be understood that disclosed device/terminal device and method, it can be with
It realizes by another way.For example, device described above/terminal device embodiment is only schematical, for example, institute
The division of module or unit is stated, only a kind of logical function partition, there may be another division manner in actual implementation, such as
Multiple units or components can be combined or can be integrated into another system, or some features can be ignored or not executed.Separately
A bit, shown or discussed mutual coupling or direct-coupling or communication connection can be through some interfaces, device
Or the INDIRECT COUPLING or communication connection of unit, it can be electrical property, mechanical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated module/unit be realized in the form of SFU software functional unit and as independent product sale or
In use, can store in a computer readable storage medium.Based on this understanding, the present invention realizes above-mentioned implementation
All or part of the process in example method, can also instruct relevant hardware to complete, the meter by computer program
Calculation machine program can be stored in a computer readable storage medium, the computer program when being executed by processor, it can be achieved that on
The step of stating each embodiment of the method.Wherein, the computer program includes computer program code, the computer program
Code can be source code form, object identification code form, executable file or certain intermediate forms etc..Computer-readable Jie
Matter may include: can carry the computer program code any entity or device, recording medium, USB flash disk, mobile hard disk,
Magnetic disk, CD, computer storage, read-only memory (ROM, Read-Only Memory), random access memory (RAM,
Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It should be noted that described
The content that computer-readable medium includes can carry out increasing appropriate according to the requirement made laws in jurisdiction with patent practice
Subtract, such as does not include electric carrier signal and electricity according to legislation and patent practice, computer-readable medium in certain jurisdictions
Believe signal.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations;Although referring to aforementioned reality
Applying example, invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each
Technical solution documented by embodiment is modified or equivalent replacement of some of the technical features;And these are modified
Or replacement, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (6)
1. a kind of introduction method of data list characterized by comprising
Obtain the data list to be imported that user terminal is sent;
Current matching columns N is obtained, and arbitrarily extracts the gauge outfit that N is arranged from the column of the non-successful match of the data list and is marking
It is matched in the gauge outfit of quasi- list template, the initial value of the matching columns N is the columns and the mark of the data list
Smaller value in the columns of quasi- list template;
If in the data list there is no any N column gauge outfit in the gauge outfit of the standard list template successful match,
As the current matching columns after subtracting one for the numerical value of N;
If in the data list there are any N column gauge outfit in the gauge outfit of the standard list template successful match, will
The N column of successful match are directed respectively into the standard list template in corresponding column in the data list, and according to the number
The current matching columns is determined according to the columns of successful match non-in list;
It returns and executes the current matching columns N of the acquisition, and from the column of the non-successful match of data list to be imported
Any gauge outfit for extracting N column carries out matched operation in the gauge outfit of the standard list template, until the numerical value of N is kept to zero;
If being included in the standard list template in the data list matched can not arrange, in the standard list template
In create in the data list can not the equal column of matched columns, and described matched can not arrange is directed into the mark
In the newly-built column of quasi- list template;
If there is the column for not importing data, transmission list missing information to the user terminal in the standard list template;
It receives the user terminal to be arranged according to the supplementary data that the list missing information returns, and supplementary data column is led
Enter into the standard list template not importing the column of data.
2. introduction method according to claim 1, which is characterized in that described according to successful match non-in the data list
Columns determine the current matching columns, comprising:
If the columns of non-successful match is greater than or equal to N in the data list, keep the current matching columns constant;
If the columns of non-successful match is less than N in the data list, the columns of the non-successful match is determined as described
Current matching columns.
3. introduction method according to claim 1 or 2, which is characterized in that described to obtain the to be imported of user terminal transmission
Data list, comprising:
Identify the file type of the data list to be imported;
If the file type with it is preset can lead-in type match, according to preset file corruption checking algorithm determine described in
Whether data list to be imported damages;
If the data list to be imported executes the current matching columns N of the acquisition without damage, and arranges from the data
The gauge outfit that N column are arbitrarily extracted in the column of the non-successful match of table carries out matched operation in the gauge outfit of standard list template.
4. a kind of for importing the terminal device of data list, which is characterized in that the terminal device includes memory, processor
And the computer program that can be run in the memory and on the processor is stored, the processor executes the meter
Following steps are realized when calculation machine program:
Obtain the data list to be imported that user terminal is sent;
Current matching columns N is obtained, and arbitrarily extracts the gauge outfit that N is arranged from the column of the non-successful match of the data list and is marking
It is matched in the gauge outfit of quasi- list template, the initial value of the matching columns N is the columns and the mark of the data list
Smaller value in the columns of quasi- list template;
If in the data list there is no any N column gauge outfit in the gauge outfit of the standard list template successful match,
As the current matching columns after subtracting one for the numerical value of N;
If in the data list there are any N column gauge outfit in the gauge outfit of the standard list template successful match, will
The N column of successful match are directed respectively into the standard list template in corresponding column in the data list, and according to the number
The current matching columns is determined according to the columns of successful match non-in list;
It returns and executes the current matching columns N of the acquisition, and from the column of the non-successful match of data list to be imported
Any gauge outfit for extracting N column carries out matched operation in the gauge outfit of the standard list template, until the numerical value of N is kept to zero;
If being included in the standard list template in the data list matched can not arrange, in the standard list template
In create in the data list can not the equal column of matched columns, and described matched can not arrange is directed into the mark
In the newly-built column of quasi- list template;
If there is the column for not importing data, transmission list missing information to the user terminal in the standard list template;
It receives the user terminal to be arranged according to the supplementary data that the list missing information returns, and supplementary data column is led
Enter into the standard list template not importing the column of data.
5. terminal device according to claim 4, which is characterized in that described according to successful match non-in the data list
Columns determine the current matching columns, comprising:
If the columns of non-successful match is greater than or equal to N in the data list, keep the current matching columns constant;
If the columns of non-successful match is less than N in the data list, the columns of the non-successful match is determined as described
Current matching columns.
6. a kind of for importing the computer readable storage medium of data list, the computer-readable recording medium storage has meter
Calculation machine program, which is characterized in that realized as described in any one of claims 1 to 3 when the computer program is executed by processor
The step of method.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710979300.2A CN107766313B (en) | 2017-10-19 | 2017-10-19 | A kind of introduction method and its terminal of data list |
PCT/CN2017/113572 WO2019075864A1 (en) | 2017-10-19 | 2017-11-29 | Importing method for data list, and terminal therefor |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710979300.2A CN107766313B (en) | 2017-10-19 | 2017-10-19 | A kind of introduction method and its terminal of data list |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107766313A CN107766313A (en) | 2018-03-06 |
CN107766313B true CN107766313B (en) | 2019-05-07 |
Family
ID=61268942
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710979300.2A Active CN107766313B (en) | 2017-10-19 | 2017-10-19 | A kind of introduction method and its terminal of data list |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN107766313B (en) |
WO (1) | WO2019075864A1 (en) |
Families Citing this family (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109542962B (en) * | 2018-10-26 | 2021-04-06 | 北京海数宝科技有限公司 | Data processing method, data processing device, computer equipment and storage medium |
CN110515951B (en) * | 2019-08-27 | 2020-05-08 | 云汉芯城(上海)互联网科技股份有限公司 | BOM standardization method and system, electronic device and storage medium |
CN111090975B (en) * | 2019-12-10 | 2024-04-19 | 金蝶软件(中国)有限公司 | Data printing method, data processing system and computer storage medium |
CN112541790A (en) * | 2020-12-15 | 2021-03-23 | 建信金融科技有限责任公司 | Method and device for maintaining evaluation data |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7130851B1 (en) * | 2003-05-12 | 2006-10-31 | Microsoft Corporation | System and method for maintaining and displaying user ordered lists |
CN104077053A (en) * | 2014-06-30 | 2014-10-01 | 珠海市君天电子科技有限公司 | Terminal information operating method and device and mobile terminal |
CN104809143A (en) * | 2014-01-29 | 2015-07-29 | 西门子公司 | Method and device for implanting table information into information base |
CN106294821A (en) * | 2016-08-16 | 2017-01-04 | 广州地铁设计研究院有限公司 | A kind of BIM model verification method |
CN106933899A (en) * | 2015-12-30 | 2017-07-07 | 远光软件股份有限公司 | Form processing method and device |
Family Cites Families (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7054509B2 (en) * | 2000-10-21 | 2006-05-30 | Cardiff Software, Inc. | Determining form identification through the spatial relationship of input data |
CN103020089A (en) * | 2011-09-27 | 2013-04-03 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for importing data in EXCEL file to database |
US9848068B2 (en) * | 2013-04-16 | 2017-12-19 | Telefonaktiebolaget L M Ericsson (Publ) | Method for providing a parser to extract information from fields of a data packet header |
CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
CN105824940A (en) * | 2016-03-17 | 2016-08-03 | 深圳市永兴元科技有限公司 | Method and device for importing data |
-
2017
- 2017-10-19 CN CN201710979300.2A patent/CN107766313B/en active Active
- 2017-11-29 WO PCT/CN2017/113572 patent/WO2019075864A1/en active Application Filing
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7130851B1 (en) * | 2003-05-12 | 2006-10-31 | Microsoft Corporation | System and method for maintaining and displaying user ordered lists |
CN104809143A (en) * | 2014-01-29 | 2015-07-29 | 西门子公司 | Method and device for implanting table information into information base |
CN104077053A (en) * | 2014-06-30 | 2014-10-01 | 珠海市君天电子科技有限公司 | Terminal information operating method and device and mobile terminal |
CN106933899A (en) * | 2015-12-30 | 2017-07-07 | 远光软件股份有限公司 | Form processing method and device |
CN106294821A (en) * | 2016-08-16 | 2017-01-04 | 广州地铁设计研究院有限公司 | A kind of BIM model verification method |
Non-Patent Citations (2)
Title |
---|
An Attribute Assurance Framework to Define and Match Trust in Identity Attributes;Ivonne Thomas 等;《2011 IEEE International Conference on Web Services》;20110709;第580-587页 |
利用ADOstream实现office文档向SQL server数据表字段的直接导入导出;李明 等;《北京化工大学学报(自然科学版)》;20030430;第30卷(第2期);第105-107页 |
Also Published As
Publication number | Publication date |
---|---|
CN107766313A (en) | 2018-03-06 |
WO2019075864A1 (en) | 2019-04-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107766313B (en) | A kind of introduction method and its terminal of data list | |
CN113688006B (en) | Log data verification method and device | |
CN104391934B (en) | Data verification method and device | |
CN109474578B (en) | Message checking method, device, computer equipment and storage medium | |
CN110275861A (en) | Date storage method and device, storage medium, electronic device | |
CN110597511B (en) | Page automatic generation method, system, terminal equipment and storage medium | |
CN109614336A (en) | A kind of generation method and equipment of test script | |
CN104301875B (en) | SMS processing and device | |
CN110263145A (en) | A kind of electronic contract signature method and electronic contract sign equipment | |
CN108255602A (en) | Task combined method and terminal device | |
CN107798579A (en) | The generation method and its terminal of a kind of document of agreement | |
CN110515951A (en) | A kind of BOM standardized method, system and electronic equipment and storage medium | |
CN107564204A (en) | A kind of wholesale withdrawal method and atm device | |
CN107895105A (en) | A kind of cipher processing method, terminal device and computer-readable recording medium | |
CN108664628A (en) | A kind of deriving method and equipment of data | |
CN107528912A (en) | A kind of automatic method, system and relevant apparatus for realizing distributing real time system | |
CN114090671A (en) | Data import method and device, electronic equipment and storage medium | |
CN105824926A (en) | Method for dynamically selecting and calling external system interface | |
CN107423395A (en) | Navigation data processing system | |
CN111475494A (en) | Mass data processing method, system, terminal and storage medium | |
CN106502977B (en) | A kind of sheet disposal method and form system based on B/S framework | |
CN107229853A (en) | Law enforcement information method for uploading, terminal and computer-readable recording medium | |
CN107786308B (en) | Data transmission method and terminal device | |
CN111275436A (en) | Method and terminal for processing information | |
CN107533468A (en) | For cloud and the scalability bundle of suite of devices |
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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |