CN108595597A - Data lead-in method, device, computer equipment and storage medium - Google Patents
Data lead-in method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN108595597A CN108595597A CN201810355480.1A CN201810355480A CN108595597A CN 108595597 A CN108595597 A CN 108595597A CN 201810355480 A CN201810355480 A CN 201810355480A CN 108595597 A CN108595597 A CN 108595597A
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- template
- approval
- examination
- 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
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/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application involves a kind of data lead-in method, device, computer equipment and storage mediums.The method includes:It receives data and imports instruction, and obtain tables of data template corresponding with data importing instruction;Read data file to be imported corresponding with data importing instruction;It detects the order of the field in the data file to be imported and whether the order of the field in the tables of data template is identical, when identical, then the data in the data file to be imported are imported into the tables of data template;The data of importing are verified according to the verification rule in the tables of data template;When verifying failure, then the modification instruction for the data of verification failure is received, and modify to the data of verification failure according to the modification instruction;Verification is re-started until when modified data check is successful to modified data, then will verify successful data and store.Data can be improved using this method and import efficiency.
Description
Technical field
This application involves field of computer technology, more particularly to a kind of data lead-in method, device, computer equipment and
Storage medium.
Background technology
With the development of information technology, generally the business datum of user or key message etc. can be stored in database
In, in order to realize this function, in the process of development, engineer would generally in the database establish according to the business demand of user
One multiple tables of data, then user is by the tables of data input data, to realize data loading.
But under this kind of mode, need artificial inspection that the correctness of the business datum imported, efficiency is needed to reduce.
Invention content
Based on this, it is necessary in view of the above technical problems, provide a kind of data importing that can be improved data and import efficiency
Method, apparatus, computer equipment and storage medium.
A kind of data lead-in method, the method includes:
It receives data and imports instruction, and obtain tables of data template corresponding with data importing instruction;
Read data file to be imported corresponding with data importing instruction;
Detect order of the field in the data file to be imported and the order of the field in the tables of data template whether phase
Together, when identical, then the data in the data file to be imported are imported into the tables of data template;
The data of importing are verified according to the verification rule in the tables of data template;
When verifying failure, then the modification instruction for the data of verification failure is received, and according to modification instruction pair
The data of verification failure are modified;
Verification is re-started to modified data until when modified data check is successful, then will verify successfully number
According to being stored.
The reception data import instruction in one of the embodiments, and obtain corresponding with data importing instruction
Tables of data template, including:
The business series selection instruction of input is received, and corresponding business system is selected according to the business series selection instruction
Row;
It obtains and shows tables of data template corresponding with selected business series;
Receive the selection instruction for the tables of data template of input;
Corresponding tables of data template is obtained according to the selection instruction.
The method further includes in one of the embodiments,:
When the data of importing verify failure by the verification rule in tables of data template, then the data of verification failure are obtained
Corresponding data check rule;
Show the data check rule.
In one of the embodiments, it is described the data of importing are stored before, further include:
Judge whether selected tables of data template carries examination & approval mark;
When selected tables of data template carries examination & approval mark, examination & approval corresponding with the tables of data template are obtained
Chain;
The successful tables of data template of data check is sent in the examination & approval chain and currently examines the corresponding examination & approval of user eventually
It is examined at end;
Receive the current approval results that the current examination & approval terminal returns;
When the current approval results indicate that examination & approval pass through, then continue to obtain next examination & approval in selected examination & approval chain
Terminal, and the tables of data template is sent to next examination & approval terminal and is examined, until all in the examination & approval chain
The examination & approval of tables of data template described in the corresponding examination & approval terminal-pair of examination & approval user pass through.
The method further includes in one of the embodiments,:
When the current approval results indicate examination & approval not by when, then the data in the tables of data template are repaiied
Change;
Modified tables of data template is sent to current examination & approval terminal corresponding with the current approval results.
The method further includes in one of the embodiments,:
When the tables of data template generation for receiving input instructs, display data table template generation interface;
The data table name of selection is received by tables of data template generation interface;
Display field corresponding with selected data table name;
Receive the selection instruction for the field and the first verification rule for selected field of input;
Tables of data template is generated according to selected field and the first verification rule;
Tables of data corresponding with the data table name is obtained, and by first described in the data detection in the tables of data
Verification rule;
When the first verification rule verifies successfully, then the tables of data template is preserved.
Tables of data mould is being generated according to selected field and the first verification rule in one of the embodiments,
After plate, further include:
Authority configuration corresponding with the tables of data template instruction of input is received, and is matched according to authority configuration instruction
Set the permission of the tables of data template;
The acquisition and the corresponding tables of data template of data importing instruction, including:
Obtain user identifier corresponding with data importing instruction;
Judge whether the corresponding permission of the user identifier and the permission of the tables of data template match;
When the permission match of the corresponding permission of the user identifier and the tables of data template, then obtain and the data
It imports and instructs corresponding tables of data template.
A kind of data importing device, described device include:
First receiving module imports instruction for receiving data, and obtains data corresponding with data importing instruction
Table template;
Read module, for reading data file to be imported corresponding with data importing instruction;
Import modul, for detecting the order of the field in the data file to be imported and the word in the tables of data template
Whether Duan Shunxu is identical, when identical, then the data in the data file to be imported is imported into the tables of data template;
First correction verification module, for being verified to the data of importing according to the verification rule in the tables of data template;
First modified module, for when verifying failure, then receiving the modification instruction for the data of verification failure, and root
It modifies to the data of verification failure according to the modification instruction;
First memory module, for re-starting verification to modified data until the success of modified data check
When, then it will verify successful data and store.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing
The step of device realizes any of the above-described the method when executing the computer program.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor
The step of method described in any one of the above embodiments is realized when row.
Above-mentioned data lead-in method, device, computer equipment and storage medium, when terminal receives data importing instruction,
Tables of data template corresponding with data importing instruction is then got, and judges the order of the field in data file to be imported and data
Whether the order of the field in table template is identical, in the case of only identical, can just import the data in data file to be imported
The data of importing are verified automatically into tables of data template, and by the verification rule in tables of data template, are lost in verification
In the case of losing, also user is allowed to carry out data modification, and preserve the successful data of verification, not needed artificial inspection needs and lead
The correctness of the business datum entered, improves efficiency.
Description of the drawings
Fig. 1 is the application scenario diagram of data lead-in method in one embodiment;
Fig. 2 is the flow diagram of data lead-in method in one embodiment;
Fig. 3 is the schematic diagram at tables of data stencil-chosen interface in an embodiment;
Fig. 4 is the flow chart that step is examined in an embodiment;
Fig. 5 is the flow chart of the tables of data template generation step in an embodiment;
Fig. 6 is the schematic diagram at tables of data template generation interface in an embodiment;
Fig. 7 is the structure diagram of data importing device in one embodiment;
Fig. 8 is the internal structure chart of one embodiment Computer equipment.
Specific implementation mode
It is with reference to the accompanying drawings and embodiments, right in order to make the object, technical solution and advantage of the application be more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
Data lead-in method provided by the present application can be applied in application environment as shown in Figure 1.Wherein, user is whole
End is communicated with database and examination & approval terminal respectively by network.User terminal receives data input by user and imports instruction,
Tables of data template corresponding with data importing instruction is then got, and imports instruction according to data input by user and reads accordingly
Data file to be imported, whether detect order of the field in the data file to be imported and the order of the field in tables of data template
It is identical, under the premise of only identical, tables of data template can be just imported data to, just can guarantee importing the sequences of data just in this way
Really, and after importing data, the data of importing are verified by the verification rule in tables of data template, the number only imported
When according to verifying successfully, the successful data of the verification of importing can just be stored.Wherein, user terminal and examination & approval terminal can with but
It is not limited to various personal computers, laptop, smart mobile phone, tablet computer and portable wearable device.
In one embodiment, as shown in Fig. 2, providing a kind of data lead-in method, it is applied in Fig. 1 in this way
It illustrates, includes the following steps for user terminal:
S202:It receives data and imports instruction, and obtain tables of data template corresponding with data importing instruction.
Specifically, it is to be input to application terminal by user that data, which import instruction, is used to indicate application terminal and executes data
It can select the instruction of tables of data template that the instruction of importing action, the wherein data, which import instruction, to input number as user
When according to importing instruction, namely corresponding tables of data template is selected.
Tables of data template is to pre-establish for importing the templates of data, including field, data check rule etc.,
Tables of data template is used to store the data imported, and the data of importing are stored in the form of tables of data template into database,
To realize the storage of the data imported.
S204:Read data file to be imported corresponding with data importing instruction.
Specifically, data file to be imported is the file to be imported to the data storage in database, wherein can be csv
File, xls files, xlsx files.User can select data file to be imported on the subscriber terminal, to which user terminal can
To get the selected data file to be imported of user.
S206:It detects the order of the field in data file to be imported and whether the order of the field in tables of data template is identical,
When identical, then the data in data file to be imported are imported into tables of data template.
Specifically, it in order to ensure that sequence of the data in data template is constant, can detect in data file to be imported
Whether order of the field is identical as the order of the field in tables of data template, when only identical, can just allow data file to be imported
In data imported into tables of data template.When the order of the field in data file to be imported and the field in tables of data template are suitable
When sequence differs, error information can be exported to the interface of user terminal to prompt user to change the word in data file to be imported
The sequence of section.And optionally, the order of the field in the selected tables of data template of user can be shown to user by user terminal
On the display interface of terminal, to prompt the user on how to adjust the sequence of the field in data file to be imported.For example, can with
After family has selected tables of data template, i.e., the order of the field of selected tables of data template is shown to display circle of user terminal
Face, to which before user chooses data file to be imported, that is, the field treated in importing data film is adjusted, or may be used also
With after user terminal exports error information, then the order of the field of tables of data template is shown to the display interface of user terminal,
With for reference, and then it can accurately adjust the order of the field in data file to be imported.
S208:The data of importing are verified according to the verification rule in tables of data template.
Specifically, after the data in data file to be imported are imported into tables of data template by user terminal, can pass through
Verification rule in tables of data template verifies the data of importing, such as the verification of format check, content integrity, sql tables
Up to formula, regular expression, row processing or row processing etc..Wherein sql expression formulas, regular expression, row processing or row processing can be with
Operation rule including field, such as field A+ field B=fields C.
S210:When verifying failure, then the modification instruction for the data of verification failure is received, and according to modification instruction pair
The data of verification failure are modified.
Specifically, it is the data for changing verification failure that user terminal is input to by user that modification, which instructs, for example,
Directly the data of verification failure can be shown in the display interface of user terminal for user terminal or user terminal will own
Data be shown in the display interface of user terminal, and to verification failure data be labeled, such as mark it is red, increase it is bright etc.
To be distinguished with the successful data of verification, to which user can be directly obtained the data of verification failure, and modify.
In practical applications, with data file to be imported for csv files, for the non-xls files of tables of data template, the csv
The characteristics of file is only retention data but not retain format, it is assumed that a certain data in csv files are with 0 beginning, such as 001
Deng when importeding into xls files, due to the characteristic of xls files, with the data of 0 beginning, it will usually be deleted 0, therefore be
It avoids the occurrence of this kind, verification rule can be pre-set, i.e., the data are with 0 beginning, and with text in xls files
This pattern is shown, when it is not to start with 0 to detect data, is then reported an error, is changed manually by user and be input to tables of data
Data in template, or can be the data for applying for terminal active obtaining to display mistake, and will show the data of mistake
Form modifying be text style after, data are imported again, so that data are correctly shown.
S212:To modified data re-start verification until modified data check success when, then will verification at
The data of work(are stored.
Specifically, after user modifies to the data of verification failure, modified data are committed to user again
Terminal, user terminal verify modified data by the verification rule in tables of data template again, until all
Data check success, then will verify successful data and store.Optionally, abort mechanism can be arranged in user terminal, that is, works as
When user is more than preset value to the modification number of data, then directly refuse the importing of this data, such as user repaiies same data
It has been more than 5 times to change, then applies for the information that terminal output refusal data import, and can be arranged whithin a period of time, do not allow to use
Family imports data again.
Above-mentioned data lead-in method is then got corresponding with data importing instruction when terminal receives data importing instruction
Tables of data template, and judge the order of the field in data file to be imported and the order of the field in tables of data template whether phase
Together, in the case of only identical, the data in data file to be imported can just be imported into tables of data template, and pass through data
Verification rule in table template automatically verifies the data of importing, in the case where verifying failure, also user is allowed to carry out
Data modification, and the successful data of verification are preserved, the correctness that artificial inspection needs the business datum imported is not needed, is improved
Efficiency.
Above-mentioned steps S202 in one of the embodiments, receives data and imports instruction, and obtains and refer to data importing
Corresponding tables of data template is enabled, may include:The business series selection instruction of input is received, and according to business series selection instruction
Select corresponding business series;It obtains and shows tables of data template corresponding with selected business series;Receive the needle of input
To the selection instruction of tables of data template;Corresponding tables of data template is obtained according to selection instruction.
Specifically, business series selection instruction is the finger for selecting a business series that user inputs to user terminal
It enables, wherein business series is intended to indicate that type of service, such as may include life insurance, production danger, endowment insurance, other dangers etc..
It is the schematic diagram at tables of data stencil-chosen interface in an embodiment, tables of data stencil-chosen circle referring to Fig. 3, Fig. 3
Face includes business series selecting module, tables of data stencil-chosen module, data file selecting module to be imported and display module,
There are drop down buttons wherein in operation system selecting module, and user, which clicks drop down button, can get shown all business
Series, and one of them is chosen by click commands, after user chooses to one of business series, user terminal according to
The business series that family is chosen shows that corresponding tables of data template, one of business series may correspond to multiple tables of data templates.
There are drop down buttons in tables of data stencil-chosen module, and user, which clicks drop down button, can get shown all data
Table template, and one of tables of data template is chosen by click commands, after user chooses to one of tables of data template,
User terminal can be by selected tables of data template for displaying to display module.Optionally, user can also continue to by waiting leading
Enter data file selecting module and choose data file to be imported, wherein can be carried out by navigation button, chooses and arrive user terminal
The file of middle storage, and after user terminal gets the data file to be imported selected by user, it can also be by number to be imported
It is shown to display module according to file.
In above-described embodiment, selected tables of data template can be got by many more manipulations of user so that data
The selection of table template is more accurate.
Above-mentioned data lead-in method can also include in one of the embodiments,:When the data of importing pass through tables of data
When verification rule verification in template fails, then the corresponding data check rule of data of verification failure is obtained;Display data school
Test rule.
Specifically, when the data of importing are by the verification in the block rule verification failure of tables of data mould, user terminal can be with
Corresponding data check rule used by the data of verification failure is got, which is shown on interface,
To user when change the data, can according to verify rule modify, in order to user disposably by data modification just
Really, the modification efficiency of user can be improved in this way.Specifically, data check rule can correspond to the data for being shown to verification failure
Afterwards, there are one-to-one relationships etc. with data.Optionally, when within a preset range, several data verify failure, and corresponding phase
Same verification rule then can only show that a verification is regular.Optionally, in order to avoid verification rule occupies interface shape mistake
Greatly, verification rule can not exclusively be shown, when user is moved to by mouse at the verification rule, user terminal is
The verification rule is shown.
In above-described embodiment, the corresponding verification rule of data of verification failure is shown on user terminal so that user
It can be modified according to verification rule, in order to which user is disposably correct by data modification, repairing for user can be improved in this way
Change efficiency.
It is in one of the embodiments, the flow chart that step is examined in an embodiment, the examination & approval step refering to Fig. 4, Fig. 4
Can be executed before being stored the data of importing, which may include:
S402:Judge whether selected tables of data template carries examination & approval mark.
Specifically, examination & approval mark is intended to indicate that whether tables of data template needs the mark examined, when importeding into tables of data
When data in template are changed, then it may be examined, its purpose is to ensure that significant data is not divided illegally
Son is distorted.There are when data modification i.e. in tables of data template, then may be examined, wherein the side of flag bit can be passed through
Formula come identify selected tables of data template whether carry examination & approval mark.
S404:When selected tables of data template carries examination & approval mark, examination & approval corresponding with tables of data template are obtained
Chain.
Specifically, after the data of importing verify successfully after the modification, user terminal judges selected tables of data mould
Plate carries examination & approval mark, then gets the corresponding examination & approval chain of tables of data template, the wherein corresponding examination & approval chain of tables of data template can
With there are multiple, user terminal is chosen current online and minimum task amount examination & approval chain and is carried out to modified tables of data template
It examines, wherein total treating capacities that the current treating capacity of each examination & approval chain is equal to all examination & approval users in examination & approval chain are described more careful than upper
The quantity for criticizing the user in chain, to which the examination & approval chain that user can select currently processed amount minimum as needed is examined, with
Convenient for improving the efficiency of examination & approval.
S406:The successful tables of data template of data check is sent in examination & approval chain and currently examines the corresponding examination & approval of user eventually
It is examined at end.
Specifically, only the successful tables of data template of data check can just be examined by examining chain, that is, be imported when number
According in table template data exist change, and tables of data template carry examination & approval mark when, then need to the tables of data template into
Row examination & approval, therefore examination & approval chain is got, and tables of data template is sent to the corresponding examination & approval of current examination & approval user in examination & approval chain
Terminal is examined.Examination & approval user is examined by examining the data of terminal-pair modification, which is generally essence examination & approval, with
Preventing the data changed, there are loopholes etc..
S408:Receive the current approval results that current examination & approval terminal returns.
S410:When current approval results indicate that examination & approval pass through, then continue to obtain the lower first sentence in selected examination & approval chain
Terminal is criticized, and tables of data template is sent to next examination & approval terminal and is examined, until examination & approval user couple all in examination & approval chain
The examination & approval for the examination & approval terminal-pair tables of data template answered pass through.
Specifically, application terminal obtains the corresponding current examination & approval of current examination & approval user in the selected examination & approval chain of user eventually
End, and the tables of data template for importing data is sent to deserve before examination & approval terminal examine, it is current that application terminal receives this
It examines terminal and returns to current approval results, when current approval results indicate that examination & approval pass through, then continue to obtain next in examination & approval chain
The corresponding next examination & approval terminal of user is examined, and the tables of data template for importing data is sent to next examination & approval terminal and is carried out
Examination & approval, up to all examination & approval users examine completion to the tables of data template for importing data in the examination & approval chain.When examination & approval chain
In the examination & approval of the corresponding examination & approval terminal-pair tables of data template of all examination & approval users pass through, then the data of importing are deposited
Storage.When examine in chain exist examination & approval user it is corresponding examination & approval terminal-pair tables of data template examination & approval not by when, then will not will lead
The data entered are stored.
In above-described embodiment, is examined according to the examination & approval user in the examination & approval chain of user's selection, according to certain sequence, made
It must examine without any confusion.And when terminal will examine chain and be sent to application terminal, the current place of each examination & approval chain can also be provided
Reason amount, to which the examination & approval chain that user can select currently processed amount minimum as needed is examined, in order to improve examination & approval
Efficiency.
Above-mentioned data lead-in method can also include in one of the embodiments,:When current approval results indicate to examine
Not by when, then modify to the data in tables of data template;Modified tables of data template is sent to and is currently examined
As a result corresponding current examination & approval terminal.
Specifically, obstructed out-of-date when currently examining the current approval results mark examination & approval that terminal returns, apply for terminal log
It modifies again according to the data in table template, and resubmits the modified tables of data mould for importing data after the completion of modification
Plate, and apply for that terminal after the tables of data template for receiving the modified importing data resubmited, is got heavy with this
The current examination & approval terminal of the corresponding last time examination & approval of tables of data template for the modified importing data newly submitted, and will be after the modification
Importing data tables of data template be sent to deserve before examine terminal, so as to the primary examination & approval chain that avoids going further again, lead
Cause the waste of examination & approval resource.And optionally, after the tables of data template that currently examination & approval terminal gets modified importing data,
The modified tables of data template for importing data can be compared with the tables of data template of the importing data before modification, and compared
Different content after relatively, that is, the content changed is labeled, for example, mark it is red or highlighted etc., can be clear in order to examine user
The content of the modification for seeing user of Chu, to improve review efficiency.
In above-described embodiment, by modified tables of data template be sent to last time examination & approval not by current examination & approval terminal,
To which modified tables of data template need not walk an examination & approval chain again, review efficiency is improved, examination & approval resource has been saved.
The data lead-in method can also include a tables of data template generation step in one of the embodiments, refering to
Fig. 5, Fig. 5 are the flow chart of the tables of data template generation step in an embodiment, which may include:
S502:When the tables of data template generation for receiving input instructs, display data table template generation interface.
Specifically, it is the schematic diagram at tables of data template generation interface in an embodiment, the tables of data template referring to Fig. 6, Fig. 6
Interface is generated to include title bar, object window can be changed, object properties window, field window and template browser window, wherein
Title bar includes new buttons, save button, opens button, close button, imports button and export button.When application terminal
When receiving user's click template development button, that is, apply for that terminal receives the tables of data template generation instruction of input, application is eventually
End then shows the tables of data template generation interface.
S504:The data table name of selection is received by tables of data template generation interface.
Specifically, when applying for that terminal shows the tables of data template generation interface, user can be newly-built by clicking
Button realizes the function of newdata table template, and applies for that terminal after receiving user and clicking the instruction of new buttons, is shown
Show that selectable data table name, user select one from shown data table name.Such as user can first select number
According to library, then apply for that the data table name of the corresponding tables of data of database is shown that user is again from shown number by terminal
According to selection one in table name.
S506:Display field corresponding with selected data table name.
Specifically, it after applying for that terminal receives user's selected data table name, gets and the data table name
Corresponding field, i.e. all fields in the corresponding tables of data of data table name, and accessed field is shown to
Field window.
S508:Receive the selection instruction for field and the first verification rule for selected field of input.
Specifically, the field got is shown to field window by application terminal, to which user needs tables of data template
Field selected, and after selecting field, application terminal shows the attribute of the field of selection in field attribute window, and
The first verification rule corresponding with field input by user is shown at field window, which may include sql tables
Up to formula, regular expression, row processing and row processing etc..
S510:Tables of data template is generated according to selected field and the first verification rule.
Specifically, after user has input selected field and the first verification rule, application terminal is selected by
Field and the first verification rule generate tables of data template, the tables of data template of the generation can now to template window, for
User carries out preview.
S512:Tables of data corresponding with data table name is obtained, and rule are verified by the data detection first in tables of data
Then.
Specifically, application terminal obtains tables of data corresponding with data table name, and gets the data in tables of data, i.e.,
The data corresponding with the selected field of user in tables of data are got, so as to first according to those the first schools of data pair
Rule is tested to be verified.Such as when the first verification rule includes the verification rule of field A* field B=fields C, then apply for end
End can get corresponding first data of field A, corresponding second data of field B and the corresponding third data of field C, judge
First data are multiplied by whether the second data are equal to third data, when equal, then it represents that the first verification rule verifies successfully, when not
When equal, then it represents that the first verification rule verification failure.
S514:When the first verification rule verifies successfully, then tables of data template is preserved.
Specifically, when the first verification rule verifies successfully, then tables of data template can be preserved, tables of data template is being preserved
When, application terminal may determine that whether complete verification passes through the first verification rule, when the first non-complete verification of verification rule passes through
When, then judge whether the template name of tables of data template has been filled in, tables of data template is preserved if having filled in.Wherein tables of data
The preserving type of template can be identified with template name, and store under the register for the user for creating the template, so as to
In lookup.
In above-described embodiment, tables of data template can be both generated by simply operating, does not need complicated operation, is improved
Efficiency.
In one of the embodiments, according to selected field and the first verification rule generate tables of data template it
Afterwards, can also include:Authority configuration corresponding with the tables of data template instruction of input is received, and is instructed and is configured according to authority configuration
The permission of tables of data template.To obtain tables of data template corresponding with data importing instruction, may include:Acquisition is led with data
Enter and instructs corresponding user identifier;Judge whether the corresponding permission of user identifier matches with the permission of tables of data template;Work as user
When identifying permission match of the corresponding permission with tables of data template, then tables of data template corresponding with data importing instruction is obtained.
Specifically, when generating tables of data template, the authority configuration corresponding with tables of data template of input can also be received
Instruction, authority configuration instruction can be instruction for the access right of configuration data table template, for example, be arranged to only to
Family itself is as it can be seen that only user itself can be configured the tables of data template or be arranged to the use of certain rank
Family can get the tables of data template, and be configured to tables of data template.
May include obtaining to lead with data to get the step of importing instruction corresponding tables of data template with data
Enter and instructs corresponding user identifier;Judge whether the corresponding permission of user identifier matches with the permission of tables of data template, that is, judges
It whether there is user identifier corresponding with data importing instruction in the permitted user identifier for accessing user of tables of data template, when
When the permission match of the corresponding permission of user identifier and tables of data template, then tables of data mould corresponding with data importing instruction is obtained
Plate imports so as to continue data.
In above-described embodiment, when generating the tables of data template, the permission of the tables of data template, the data power of field are configured
Limit can allow user oneself to define visibility and setting of the user to data.When receiving data importing instruction, then obtain defeated
Enter the Permission Levels that data import the user of instruction, the step of tables of data template for obtaining data to be imported may include receiving
The mark of tables of data template input by user, judges whether the Permission Levels of user can get the tables of data template, if
It can be then to obtain the tables of data template of data to be imported, and shown, if it is not possible, then prompting user right insufficient, carry
The high safety of tables of data template.
It should be understood that although each step in the flow chart of Fig. 2, Fig. 4, Fig. 5 is shown successively according to the instruction of arrow
Show, but these steps are not the inevitable sequence indicated according to arrow to be executed successively.Unless expressly state otherwise herein, this
There is no stringent sequences to limit for the execution of a little steps, these steps can execute in other order.Moreover, Fig. 2, Fig. 4, figure
At least part step in 5 may include that either these sub-steps of multiple stages or stage be not necessarily for multiple sub-steps
It is to execute completion in synchronization, but can execute at different times, the execution sequence in these sub-steps or stage
It is not necessarily and carries out successively, but can be with other steps either at least part wheel in the sub-step of other steps or stage
Stream alternately executes.
In one embodiment, as shown in fig. 7, providing a kind of data importing device, including:First receiving module 100,
Read module 200, import modul 300, the first correction verification module 400, the first modified module 500 and the first memory module 600,
In:
First receiving module 100 imports instruction for receiving data, and obtains tables of data corresponding with data importing instruction
Template.
Read module 200, for reading data file to be imported corresponding with data importing instruction.
Import modul 300, it is suitable for detecting the order of the field in data file to be imported and the field in tables of data template
Whether sequence is identical, when identical, then the data in data file to be imported is imported into tables of data template.
First correction verification module 400, for being verified to the data of importing according to the verification rule in tables of data template.
First modified module 500, for when verifying failure, then receiving the modification instruction for the data of verification failure,
And it is modified to the data of verification failure according to modification instruction.
First memory module 600, for modified data re-start verification until modified data check at
When work(, then it will verify successful data and store.
The first receiving module 100 may include in one of the embodiments,:
First instruction reception unit, the business series selection instruction for receiving input, and referred to according to the selection of business series
It enables and selects corresponding business series.
First tables of data template acquiring unit, for obtaining and showing tables of data mould corresponding with selected business series
Plate.
Second instruction reception unit, the selection instruction for tables of data template for receiving input.
Selecting unit, for obtaining corresponding tables of data template according to selection instruction.
The data importing device can also include in one of the embodiments,:
Data check rule acquisition module, for being lost when the data imported are verified by the verification rule in tables of data template
When losing, then the corresponding data check rule of data of verification failure is obtained.
First display module, for display data verification rule.
The data importing device can also include in one of the embodiments,:
First judgment module, for judging whether selected tables of data template carries examination & approval mark.
Examine chain acquisition module, for when selected tables of data template carry examination & approval mark when, obtain and tables of data
The corresponding examination & approval chain of template.
Approval module currently examines user's correspondence for the successful tables of data template of data check to be sent in examination & approval chain
Examination & approval terminal examined.
Second receiving module, the current approval results returned for receiving current examination & approval terminal;When current approval results table
When showing that examination & approval pass through, then continue to obtain next examination & approval terminal in selected examination & approval chain, and tables of data template is sent to down
One examination & approval terminal is examined, until the examination & approval of the corresponding examination & approval terminal-pair tables of data template of examination & approval user all in examination & approval chain
Pass through.
The data importing device can also include in one of the embodiments,:
Second modified module, for when current approval results indicate examination & approval not by when, then to the number in tables of data template
According to modifying.
Sending module, for modified tables of data template to be sent to current examination & approval corresponding with current approval results eventually
End.
The data importing device can also include in one of the embodiments,:
Second display module, for when the tables of data template generation for receiving input instructs, display data table template to be given birth to
At interface.
Third receiving module, the data table name for receiving selection by tables of data template generation interface.
Third display module, for showing field corresponding with selected data table name.
4th receiving module, for receiving the selection instruction for field and be directed to selected field the of input
One verification rule.
Tables of data template generation module, for generating tables of data mould according to selected field and the first verification rule
Plate.
Second correction verification module is examined for obtaining tables of data corresponding with data table name, and by the data in tables of data
Test the first verification rule.
Second memory module, for when the first verification rule verifies successfully, then preserving tables of data template.
The data importing device can also include in one of the embodiments,:
Permission configuration module, authority configuration corresponding with the tables of data template instruction for receiving input, and according to permission
The permission of configuration-direct configuration data table template.
First receiving module 100 includes:
User identifier acquiring unit, for obtaining user identifier corresponding with data importing instruction.
First judging unit, for judging whether the corresponding permission of user identifier matches with the permission of tables of data template.
Second tables of data template acquiring unit, for the permission match when user identifier corresponding permission and tables of data template
When, then obtain tables of data template corresponding with data importing instruction.
Specific about data importing device limits the restriction that may refer to above for data lead-in method, herein not
It repeats again.Modules in above-mentioned data importing device can be realized fully or partially through software, hardware and combinations thereof.On
Stating each module can be embedded in or independently of in the processor in computer equipment, can also store in a software form in the form of hardware
In memory in computer equipment, the corresponding operation of the above modules is executed in order to which processor calls.
In one embodiment, a kind of computer equipment is provided, which can be terminal, internal structure
Figure can be as shown in Figure 8.The computer equipment includes the processor connected by system bus, memory, network interface, display
Screen and input unit.Wherein, the processor of the computer equipment is for providing calculating and control ability.The computer equipment is deposited
Reservoir includes non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system and computer journey
Sequence.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The network interface of machine equipment is used to communicate by network connection with external terminal.When the computer program is executed by processor with
Realize a kind of data lead-in method.The display screen of the computer equipment can be liquid crystal display or electric ink display screen,
The input unit of the computer equipment can be the touch layer covered on display screen, can also be to be arranged on computer equipment shell
Button, trace ball or Trackpad, can also be external keyboard, Trackpad or mouse etc..
It will be understood by those skilled in the art that structure shown in Fig. 8, is only tied with the relevant part of application scheme
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment
May include either combining certain components than more or fewer components as shown in the figure or being arranged with different components.
In one embodiment, a kind of computer equipment, including memory and processor are provided, which is stored with
Computer program, the processor realize following steps when executing computer program:It receives data and imports instruction, and acquisition and data
It imports and instructs corresponding tables of data template;Read data file to be imported corresponding with data importing instruction;Detect number to be imported
It is whether identical according to the order of the field in file and the order of the field in tables of data template, when identical, then by data to be imported text
Data in part are imported into tables of data template;The data of importing are verified according to the verification rule in tables of data template;
When verifying failure, then the modification instruction for the data of verification failure is received, and according to modification instruction to the number of verification failure
According to modifying;Verification is re-started until when modified data check is successful to modified data, then will be verified successfully
Data stored.
In one embodiment, processor executes the reception data realized when computer program and imports instruction, and obtains
The corresponding tables of data template of instruction is imported with data, may include:The business series selection instruction of input is received, and according to business
Serial selection instruction selects corresponding business series;It obtains and shows tables of data template corresponding with selected business series;
Receive the selection instruction for tables of data template of input;Corresponding tables of data template is obtained according to selection instruction.
In one embodiment, following steps are also realized when processor executes computer program:When the data of importing pass through
When verification rule verification in tables of data template fails, then the corresponding data check rule of data of verification failure is obtained;Display
Data check rule.
In one embodiment, processor executes the data by importing realized when computer program and carries out storing it
Before, can also include:Judge whether selected tables of data template carries examination & approval mark;When selected tables of data template is taken
When being identified with examination & approval, examination & approval chain corresponding with tables of data template is obtained;The successful tables of data template of data check is sent to
The corresponding examination & approval terminal of user is currently examined in examination & approval chain to examine;Receive the current examination & approval knot that current examination & approval terminal returns
Fruit;When current approval results indicate that examination & approval pass through, then continue to obtain next examination & approval terminal in selected examination & approval chain, and will
Tables of data template is sent to next examination & approval terminal and is examined, until the corresponding examination & approval terminal of examination & approval user all in examination & approval chain
The examination & approval of tables of data template are passed through.
In one embodiment, following steps are also realized when processor executes computer program:When current approval results table
Show examination & approval not by when, then modify to the data in tables of data template;Modified tables of data template is sent to and is worked as
The corresponding current examination & approval terminal of preceding approval results.
In one embodiment, following steps are also realized when processor executes computer program:When the number for receiving input
When being instructed according to table template generation, display data table template generation interface;The number of selection is received by tables of data template generation interface
According to table name;Display field corresponding with selected data table name;Receive the selection instruction and input for being directed to field
For the first verification rule of selected field;Tables of data mould is generated according to selected field and the first verification rule
Plate;Tables of data corresponding with data table name is obtained, and rule is verified by the data detection in tables of data first;When the first school
Rule is tested when verifying successfully, then preserves tables of data template.
In one embodiment, processor execute computer program when realized according to selected field and first
After verification rule generates tables of data template, can also include:The authority configuration corresponding with tables of data template for receiving input refers to
It enables, and instructs the permission of configuration data table template according to authority configuration;It is realized when executing computer program to processor
Tables of data template corresponding with data importing instruction is obtained, may include:Obtain user identifier corresponding with data importing instruction;
Judge whether the corresponding permission of user identifier matches with the permission of tables of data template;When the corresponding permission of user identifier and tables of data
When the permission match of template, then tables of data template corresponding with data importing instruction is obtained.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program realizes following steps when being executed by processor:It receives data and imports instruction, and obtain corresponding with data importing instruction
Tables of data template;Read data file to be imported corresponding with data importing instruction;Detect the field in data file to be imported
Whether sequence is identical as the order of the field in tables of data template, when identical, then imports the data in data file to be imported
Into tables of data template;The data of importing are verified according to the verification rule in tables of data template;When verifying failure, then
The modification instruction for the data of verification failure is received, and is modified to the data of verification failure according to modification instruction;To repairing
Data after changing re-start verification until when modified data check is successful, then will verify successful data and store.
In one embodiment, the reception data realized when computer program is executed by processor import instruction, and obtain
Tables of data template corresponding with data importing instruction is taken, may include:The business series selection instruction of input is received, and according to industry
The serial selection instruction of business selects corresponding business series;It obtains and shows tables of data mould corresponding with selected business series
Plate;Receive the selection instruction for tables of data template of input;Corresponding tables of data template is obtained according to selection instruction.
In one embodiment, following steps are also realized when computer program is executed by processor:When the data of importing are logical
When crossing the verification rule verification failure in tables of data template, then the corresponding data check rule of data of verification failure is obtained;It is aobvious
Show data check rule.
In one embodiment, the data by importing realized when computer program is executed by processor carry out storing it
Before, can also include:Judge whether selected tables of data template carries examination & approval mark;When selected tables of data template is taken
When being identified with examination & approval, examination & approval chain corresponding with tables of data template is obtained;The successful tables of data template of data check is sent to
The corresponding examination & approval terminal of user is currently examined in examination & approval chain to examine;Receive the current examination & approval knot that current examination & approval terminal returns
Fruit;When current approval results indicate that examination & approval pass through, then continue to obtain next examination & approval terminal in selected examination & approval chain, and will
Tables of data template is sent to next examination & approval terminal and is examined, until the corresponding examination & approval terminal of examination & approval user all in examination & approval chain
The examination & approval of tables of data template are passed through.
In one embodiment, following steps are also realized when computer program is executed by processor:When current approval results
Indicate examination & approval not by when, then modify to the data in tables of data template;By modified tables of data template be sent to
The corresponding current examination & approval terminal of current approval results.
In one embodiment, following steps are also realized when computer program is executed by processor:When receiving input
When tables of data template generation instructs, display data table template generation interface;Selection is received by tables of data template generation interface
Data table name;Display field corresponding with selected data table name;Receive the selection instruction for field and input
For selected field first verification rule;Tables of data mould is generated according to selected field and the first verification rule
Plate;Tables of data corresponding with data table name is obtained, and rule is verified by the data detection in tables of data first;When the first school
Rule is tested when verifying successfully, then preserves tables of data template.
In one embodiment, realized when computer program is executed by processor according to selected field and
After one verification rule generates tables of data template, can also include:Receive the authority configuration corresponding with tables of data template of input
Instruction, and according to the permission of authority configuration instruction configuration data table template;Institute is real when being executed by processor to computer program
Existing acquisition and data import the corresponding tables of data template of instruction, may include:Obtain user corresponding with data importing instruction
Mark;Judge whether the corresponding permission of user identifier matches with the permission of tables of data template;When the corresponding permission of user identifier with
When the permission match of tables of data template, then tables of data template corresponding with data importing instruction is obtained.
One of ordinary skill in the art will appreciate that realizing all or part of flow in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the flow of the embodiment of above-mentioned each method.Wherein,
Any reference to memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above example can be combined arbitrarily, to keep description succinct, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield is all considered to be the range of this specification record.
The several embodiments of the application above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, under the premise of not departing from the application design, various modifications and improvements can be made, these belong to the protection of the application
Range.Therefore, the protection domain of the application patent should be determined by the appended claims.
Claims (10)
1. a kind of data lead-in method, the method includes:
It receives data and imports instruction, and obtain tables of data template corresponding with data importing instruction;
Read data file to be imported corresponding with data importing instruction;
It detects the order of the field in the data file to be imported and whether the order of the field in the tables of data template is identical, when
When identical, then the data in the data file to be imported are imported into the tables of data template;
The data of importing are verified according to the verification rule in the tables of data template;
When verifying failure, then the modification instruction for the data of verification failure is received, and according to modification instruction to verification
The data of failure are modified;
To modified data re-start verification until modified data check success when, then will verify successful data into
Row storage.
2. according to the method described in claim 1, it is characterized in that, the reception data import instruction, and acquisition and the number
Corresponding tables of data template is instructed according to importing, including:
The business series selection instruction of input is received, and corresponding business series is selected according to the business series selection instruction;
It obtains and shows tables of data template corresponding with selected business series;
Receive the selection instruction for the tables of data template of input;
Corresponding tables of data template is obtained according to the selection instruction.
3. according to the method described in claim 1, it is characterized in that, the method further includes:
When the data of importing verify failure by the verification rule in tables of data template, then the data for obtaining verification failure correspond to
Data check rule;
Show the data check rule.
4. according to the method described in claims 1 to 3 any one, which is characterized in that described to store the data of importing
Before, further include:
Judge whether selected tables of data template carries examination & approval mark;
When selected tables of data template carries examination & approval mark, examination & approval chain corresponding with the tables of data template is obtained;
The successful tables of data template of data check is sent in the examination & approval chain currently examine the corresponding examination & approval terminal of user into
Row examination & approval;
Receive the current approval results that the current examination & approval terminal returns;
When the current approval results indicate that examination & approval pass through, then it is whole to continue the next examination & approval obtained in selected examination & approval chain
End, and the tables of data template is sent to next examination & approval terminal and is examined, until all in the examination & approval chain examine
The examination & approval for criticizing tables of data template described in the corresponding examination & approval terminal-pair of user pass through.
5. according to the method described in claim 4, it is characterized in that, the method further includes:
When the current approval results indicate examination & approval not by when, then modify to the data in the tables of data template;
Modified tables of data template is sent to current examination & approval terminal corresponding with the current approval results.
6. according to the method described in claims 1 to 3 any one, which is characterized in that the method further includes:
When the tables of data template generation for receiving input instructs, display data table template generation interface;
The data table name of selection is received by tables of data template generation interface;
Display field corresponding with selected data table name;
Receive the selection instruction for the field and the first verification rule for selected field of input;
Tables of data template is generated according to selected field and the first verification rule;
Tables of data corresponding with the data table name is obtained, and passes through the first verification described in the data detection in the tables of data
Rule;
When the first verification rule verifies successfully, then the tables of data template is preserved.
7. according to the method described in claim 6, it is characterized in that, being advised according to selected field and first verification
After then generating tables of data template, further include:
Authority configuration corresponding with the tables of data template instruction of input is received, and configuration institute is instructed according to the authority configuration
State the permission of tables of data template;
The acquisition and the corresponding tables of data template of data importing instruction, including:
Obtain user identifier corresponding with data importing instruction;
Judge whether the corresponding permission of the user identifier and the permission of the tables of data template match;
When the permission match of the corresponding permission of the user identifier and the tables of data template, then obtains and imported with the data
Instruct corresponding tables of data template.
8. a kind of data importing device, which is characterized in that described device includes:
First receiving module imports instruction for receiving data, and obtains tables of data mould corresponding with data importing instruction
Plate;
Read module, for reading data file to be imported corresponding with data importing instruction;
Import modul, it is suitable for detecting the order of the field in the data file to be imported and the field in the tables of data template
Whether sequence is identical, when identical, then the data in the data file to be imported is imported into the tables of data template;
First correction verification module, for being verified to the data of importing according to the verification rule in the tables of data template;
First modified module, for when verifying failure, then receiving the modification instruction for the data of verification failure, and according to institute
Modification instruction is stated to modify to the data of verification failure;
First memory module, for re-starting verification to modified data until when modified data check is successful, then
Successful data will be verified to store.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists
In when the processor executes the computer program the step of any one of realization claim 1 to 7 the method.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of method described in any one of claim 1 to 7 is realized when being executed by processor.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810355480.1A CN108595597A (en) | 2018-04-19 | 2018-04-19 | Data lead-in method, device, computer equipment and storage medium |
PCT/CN2018/095654 WO2019200757A1 (en) | 2018-04-19 | 2018-07-13 | Data importing method and apparatus, and computer device and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810355480.1A CN108595597A (en) | 2018-04-19 | 2018-04-19 | Data lead-in method, device, computer equipment and storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108595597A true CN108595597A (en) | 2018-09-28 |
Family
ID=63611321
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810355480.1A Pending CN108595597A (en) | 2018-04-19 | 2018-04-19 | Data lead-in method, device, computer equipment and storage medium |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN108595597A (en) |
WO (1) | WO2019200757A1 (en) |
Cited By (25)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109189849A (en) * | 2018-10-16 | 2019-01-11 | 浪潮天元通信信息系统有限公司 | A kind of standardization, the data entry method of procedure and system |
CN109388685A (en) * | 2018-10-23 | 2019-02-26 | 泰华智慧产业集团股份有限公司 | The method and apparatus that will plan that the spatial data that industry uses is put in storage |
CN109474578A (en) * | 2018-10-17 | 2019-03-15 | 平安健康保险股份有限公司 | Message method of calibration, device, computer equipment and storage medium |
CN109582668A (en) * | 2018-10-16 | 2019-04-05 | 深圳壹账通智能科技有限公司 | Service data management method, device, equipment and computer readable storage medium |
CN109635017A (en) * | 2018-10-16 | 2019-04-16 | 深圳壹账通智能科技有限公司 | Service data guiding method, device, equipment and computer readable storage medium |
CN109685669A (en) * | 2018-12-11 | 2019-04-26 | 北京量子保科技有限公司 | A kind of policy information data processing method and system |
CN109726244A (en) * | 2019-01-29 | 2019-05-07 | 北京中电普华信息技术有限公司 | Data lead-in method and device |
CN109785921A (en) * | 2018-12-03 | 2019-05-21 | 南方医科大学南方医院 | A kind of medical data input method, system, device and storage medium |
CN109992585A (en) * | 2019-04-01 | 2019-07-09 | 北京金和网络股份有限公司 | Data lead-in method for office management system |
CN111209324A (en) * | 2019-12-31 | 2020-05-29 | 航天信息股份有限公司 | Method and device for storing data, storage medium and electronic equipment |
CN111222070A (en) * | 2019-12-30 | 2020-06-02 | 深圳市五谷网络科技有限公司 | Data processing method, device, equipment and storage medium |
CN111274326A (en) * | 2018-12-04 | 2020-06-12 | 北京嘀嘀无限科技发展有限公司 | Feature data importing method, feature data managing and controlling method, feature data importing device, feature data managing and controlling device and electronic equipment |
CN111367982A (en) * | 2020-03-09 | 2020-07-03 | 深圳市万物云科技有限公司 | Method and device for importing TRIRIGA basic data, computer equipment and storage medium |
CN112102058A (en) * | 2020-09-27 | 2020-12-18 | 中国建设银行股份有限公司 | Management system parameter configuration method and device |
CN112162994A (en) * | 2020-09-08 | 2021-01-01 | 杭州涂鸦信息技术有限公司 | SQL (structured query language) generation method and system for system entry data |
CN112395266A (en) * | 2019-08-19 | 2021-02-23 | 中移(苏州)软件技术有限公司 | Data file processing method, first server and computer storage medium |
CN112836478A (en) * | 2020-11-09 | 2021-05-25 | 上海德拓信息技术股份有限公司 | Scattered data acquisition and application method |
CN113076285A (en) * | 2021-03-05 | 2021-07-06 | 上海明略人工智能(集团)有限公司 | Processing method and system for uploading data files |
CN113094345A (en) * | 2021-04-15 | 2021-07-09 | 浪潮通用软件有限公司 | Method and equipment for importing table data file |
CN113239019A (en) * | 2021-06-03 | 2021-08-10 | 锋泾(中国)建材集团有限公司 | Data migration method and system between ERP systems, electronic device and medium |
CN113360491A (en) * | 2021-06-30 | 2021-09-07 | 杭州数梦工场科技有限公司 | Data quality inspection method, data quality inspection device, electronic equipment and storage medium |
CN113642308A (en) * | 2021-08-30 | 2021-11-12 | 重庆允成互联网科技有限公司 | Data import method, system, equipment and storage medium based on data variability |
CN113821575A (en) * | 2021-09-30 | 2021-12-21 | 平安普惠企业管理有限公司 | Data checking method, device and equipment and computer storage medium |
CN115438024A (en) * | 2022-08-23 | 2022-12-06 | 光大环境科技(中国)有限公司 | Method, device and system for importing data into middle station, electronic equipment and storage medium |
CN115905269A (en) * | 2023-01-06 | 2023-04-04 | 深圳市明源云科技有限公司 | Data import method, system, device and storage medium |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113902267A (en) * | 2021-09-23 | 2022-01-07 | 携程旅游网络技术(上海)有限公司 | Method, system, electronic device and medium for managing schedule |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件(中国)有限公司 | Method and system for data inputting |
CN103631966A (en) * | 2013-12-18 | 2014-03-12 | 用友软件股份有限公司 | Configurable multiple-valued matching field analysis method |
CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
CN105989021A (en) * | 2015-01-29 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Document processing method and device |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107798030B (en) * | 2017-02-17 | 2020-07-03 | 平安科技(深圳)有限公司 | Splitting method and device of data table |
-
2018
- 2018-04-19 CN CN201810355480.1A patent/CN108595597A/en active Pending
- 2018-07-13 WO PCT/CN2018/095654 patent/WO2019200757A1/en active Application Filing
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件(中国)有限公司 | Method and system for data inputting |
CN103631966A (en) * | 2013-12-18 | 2014-03-12 | 用友软件股份有限公司 | Configurable multiple-valued matching field analysis method |
CN105989021A (en) * | 2015-01-29 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Document processing method and device |
CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
Cited By (30)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109582668A (en) * | 2018-10-16 | 2019-04-05 | 深圳壹账通智能科技有限公司 | Service data management method, device, equipment and computer readable storage medium |
CN109635017A (en) * | 2018-10-16 | 2019-04-16 | 深圳壹账通智能科技有限公司 | Service data guiding method, device, equipment and computer readable storage medium |
CN109189849A (en) * | 2018-10-16 | 2019-01-11 | 浪潮天元通信信息系统有限公司 | A kind of standardization, the data entry method of procedure and system |
CN109474578A (en) * | 2018-10-17 | 2019-03-15 | 平安健康保险股份有限公司 | Message method of calibration, device, computer equipment and storage medium |
CN109388685A (en) * | 2018-10-23 | 2019-02-26 | 泰华智慧产业集团股份有限公司 | The method and apparatus that will plan that the spatial data that industry uses is put in storage |
CN109785921A (en) * | 2018-12-03 | 2019-05-21 | 南方医科大学南方医院 | A kind of medical data input method, system, device and storage medium |
CN111274326A (en) * | 2018-12-04 | 2020-06-12 | 北京嘀嘀无限科技发展有限公司 | Feature data importing method, feature data managing and controlling method, feature data importing device, feature data managing and controlling device and electronic equipment |
CN109685669A (en) * | 2018-12-11 | 2019-04-26 | 北京量子保科技有限公司 | A kind of policy information data processing method and system |
CN109726244A (en) * | 2019-01-29 | 2019-05-07 | 北京中电普华信息技术有限公司 | Data lead-in method and device |
CN109992585A (en) * | 2019-04-01 | 2019-07-09 | 北京金和网络股份有限公司 | Data lead-in method for office management system |
CN112395266B (en) * | 2019-08-19 | 2022-12-13 | 中移(苏州)软件技术有限公司 | Data file processing method, first server and computer storage medium |
CN112395266A (en) * | 2019-08-19 | 2021-02-23 | 中移(苏州)软件技术有限公司 | Data file processing method, first server and computer storage medium |
CN111222070A (en) * | 2019-12-30 | 2020-06-02 | 深圳市五谷网络科技有限公司 | Data processing method, device, equipment and storage medium |
CN111209324A (en) * | 2019-12-31 | 2020-05-29 | 航天信息股份有限公司 | Method and device for storing data, storage medium and electronic equipment |
CN111209324B (en) * | 2019-12-31 | 2023-11-28 | 航天信息股份有限公司 | Method and device for storing data, storage medium and electronic equipment |
CN111367982A (en) * | 2020-03-09 | 2020-07-03 | 深圳市万物云科技有限公司 | Method and device for importing TRIRIGA basic data, computer equipment and storage medium |
CN111367982B (en) * | 2020-03-09 | 2023-08-25 | 深圳市万物云科技有限公司 | Method, device, computer equipment and storage medium for importing TRRIGA basic data |
CN112162994A (en) * | 2020-09-08 | 2021-01-01 | 杭州涂鸦信息技术有限公司 | SQL (structured query language) generation method and system for system entry data |
CN112102058A (en) * | 2020-09-27 | 2020-12-18 | 中国建设银行股份有限公司 | Management system parameter configuration method and device |
CN112836478A (en) * | 2020-11-09 | 2021-05-25 | 上海德拓信息技术股份有限公司 | Scattered data acquisition and application method |
CN113076285A (en) * | 2021-03-05 | 2021-07-06 | 上海明略人工智能(集团)有限公司 | Processing method and system for uploading data files |
CN113094345A (en) * | 2021-04-15 | 2021-07-09 | 浪潮通用软件有限公司 | Method and equipment for importing table data file |
CN113239019A (en) * | 2021-06-03 | 2021-08-10 | 锋泾(中国)建材集团有限公司 | Data migration method and system between ERP systems, electronic device and medium |
CN113360491A (en) * | 2021-06-30 | 2021-09-07 | 杭州数梦工场科技有限公司 | Data quality inspection method, data quality inspection device, electronic equipment and storage medium |
CN113360491B (en) * | 2021-06-30 | 2024-03-29 | 杭州数梦工场科技有限公司 | Data quality inspection method, device, electronic equipment and storage medium |
CN113642308A (en) * | 2021-08-30 | 2021-11-12 | 重庆允成互联网科技有限公司 | Data import method, system, equipment and storage medium based on data variability |
CN113821575A (en) * | 2021-09-30 | 2021-12-21 | 平安普惠企业管理有限公司 | Data checking method, device and equipment and computer storage medium |
CN113821575B (en) * | 2021-09-30 | 2024-04-12 | 李建 | Data checking method, device, equipment and computer storage medium |
CN115438024A (en) * | 2022-08-23 | 2022-12-06 | 光大环境科技(中国)有限公司 | Method, device and system for importing data into middle station, electronic equipment and storage medium |
CN115905269A (en) * | 2023-01-06 | 2023-04-04 | 深圳市明源云科技有限公司 | Data import method, system, device and storage medium |
Also Published As
Publication number | Publication date |
---|---|
WO2019200757A1 (en) | 2019-10-24 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108595597A (en) | Data lead-in method, device, computer equipment and storage medium | |
CN109308285A (en) | Database script management method, device, computer equipment and storage medium | |
CN106897348A (en) | A kind of data storage, data check, data source tracing method and equipment | |
CN110597730B (en) | Automatic test case generation method and system based on scene method | |
CN108319719A (en) | Database data method of calibration, device, computer equipment and storage medium | |
CN110458168A (en) | Processing method, device, computer equipment and the storage medium of vehicle detection report | |
CN109976957A (en) | Performance test methods, device and the computer equipment of librgw | |
CN110069297A (en) | Abnormality eliminating method, device, computer equipment and storage medium based on Spring MVC | |
CN109033150A (en) | Sensitive word verification method, device, computer equipment and storage medium | |
CN110135129A (en) | Code segment protection method, device, computer equipment and storage medium | |
CN109493048A (en) | Financial accounting method, apparatus, equipment and storage medium based on block chain | |
CN110209388A (en) | The generation method of applet file | |
CN110334303A (en) | Form validation method, device, computer equipment and storage medium | |
CN110471838A (en) | Method of calibration, device, computer equipment and the storage medium of test case | |
CN109543073A (en) | Enterprise's supply and marketing relation map generation method, device and computer equipment | |
CN108418797A (en) | Web access method, device, computer equipment and storage medium | |
CN108763888A (en) | Files on each of customers processing method, device, computer equipment and storage medium | |
CN109815126A (en) | Method for testing software, device, computer equipment and storage medium | |
CN106250755A (en) | For generating the method and device of identifying code | |
CN109669977A (en) | Data cut-in method, device, computer equipment and the storage medium of integration across database | |
CN109815127A (en) | Automatized script conversion method, device, computer equipment and storage medium | |
CN110334019A (en) | A kind of test method, device and readable storage medium storing program for executing | |
CN113448847B (en) | Test method and system | |
CN116329708A (en) | Gas pipeline welding process evaluation system, method and equipment and readable storage medium | |
CN112434505A (en) | Template generation method and device, computer equipment and storage medium |
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 |