CN108874866A - Data import management method, apparatus, mobile terminal and storage medium - Google Patents
Data import management method, apparatus, mobile terminal and storage medium Download PDFInfo
- Publication number
- CN108874866A CN108874866A CN201810363680.1A CN201810363680A CN108874866A CN 108874866 A CN108874866 A CN 108874866A CN 201810363680 A CN201810363680 A CN 201810363680A CN 108874866 A CN108874866 A CN 108874866A
- Authority
- CN
- China
- Prior art keywords
- data
- interface
- allocation list
- verification
- import
- 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.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Stored Programmes (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Field is imported the present invention relates to Excel more particularly to data import management method, apparatus, mobile terminal and storage medium.A kind of data importing management method, generates interface by allocation list and generates allocation list, the configuration information in allocation list is arranged；Front end setting one where generating interface in allocation list generates interface verification rule interface arranged side by side with allocation list, for generating verification rule or importing previously prepared verification rule；Front-end interface where generating interface in allocation list is utilized with the account for importing permission, imports tables of data.The importing for importing table is realized by prefabri cation configuration table, without redeploying；It realizes the control for importing permission, avoids importing ineligible data by temporarily storing and verifying, improve and import efficiency.
Description
Technical field
The present invention relates to field of computer technology more particularly to data to import management method, apparatus, mobile terminal and storage
Medium.
Background technique
In house prosperity transaction institute system in each newly-increased data, the reality of the mode in system is often directed into Excel tables of data
Existing data increase, and before importing data, need to import template in advance to import mould every time to adapt to the architectural difference of each tables of data
When plate, require to implement steps for importing again using import feature, system is also required to redeploy primary backstage template, and again
Multiple development, the upload including Excel table, response and reading link require to carry out the redevelopment of function code.When certain
When a Excel tables of data to be imported is needed to increase, be deleted, changing gauge outfit, it is also necessary to background function code is modified, further, since every time
Import feature newly developed needs to write a large amount of backstage code, causes to be easy to produce hidden loophole.The process needs of importing stop
Machine deployment, it is time-consuming and laborious.
Therefore, accordingly, the technical program proposes a kind of data importing management method, is weighed with realizing to importing
The control of limit and to Excel import feature manage concentratedly, it is easy to operate.
Summary of the invention
Present invention aims at proposing that a kind of data import management method, apparatus, mobile terminal and storage medium, to solve
Shortcoming in above-mentioned background technique.Traditional Excel table imports upload, response and the reading for needing to repeat Excel table
The development of links such as take, it is time-consuming and laborious；Need to redeploy backstage template and modification backstage when increasing, delete, changing Excel gauge outfit
Code needs shutdown operation；Modification needs to change more backstage code every time, is easy to produce hidden loophole.
To achieve the goals above, the present invention provides the following technical solutions：
A kind of data importing management method, the management method, specific step is as follows：S1：Interface is generated by allocation list
Allocation list is generated, the configuration information in allocation list is set；S2：Front end setting one and allocation list where generating interface in allocation list
Interface verification rule interface arranged side by side is generated, for generating verification rule or importing previously prepared verification rule；S3：Matching
It sets the front-end interface where table generates interface to utilize with the account for importing permission, imports tables of data.
The step S1 includes in one of the embodiments,：S101：Call scripting language creation one for generating data
The allocation list of template is imported, the allocation list is connect with database, is generated data and is imported template, imports data to template and be stored in
In database；S102：Call scripting language to add configuration feature, the configuration feature include data import template query function,
Data import the newly-increased of template and delete function；S103：The layout of planning default display list interface in allocation list, including mould
The interface display title of plate, template title in the database, validity switch, remark information, creation time, modification time,
Operation switch for editing template；S104：The new of template basic information is imported for data to be arranged based on allocation list creation one
Increase and import template operation interface, interior layout imports each input entrance of template basic information for generating data；S105：Base
In the edit model interface of the corresponding any template of allocation list creation, default interface is laid out each data column of the corresponding template,
Any data column are correspondingly provided at least two column basis fields；S106：Based on edit model interface creating one for newly-increased or
Edit the column editing interface of data column.
The step S2 includes in one of the embodiments,：S201：It is developed and is generated in system front end using scripting language
One verifies regular configuration interface, the verification rule with database association, in the verification rule deposit database through being generated by it
In list, the default display interfaces for verifying regular configuration interface, which shows, have been imported or generated verification is regular, any generation
Verification rule in default display interfaces be equipped with one with its one-to-one Operation switch group, for check regular details or
Carry out rule editing；S202：Deployment verification rule upload and download function, can pass through and download function on the regular configuration interface of verification
Verification rule can be convenient for off-line editing after exporting in the form of independent script file in database, it can also be by uploading function
Can, the good verification rule of preparatory off-line editing is imported in the verification list of rules into database；S203：Matched based on verification rule
The one newly-increased interface of verification rule of interface development generation is set, it is interior to be laid out verification description, rule type and verify three projects of rule.
The step S3 includes in one of the embodiments,：S301：In system front end, one authority distribution interface is set,
It is assigned after existing account binding in the permission and a certain system imported data to and imports permission, makes it that can operate importing number
According to；S302：According to the corresponding importing template of the tables of data to be imported of generation, generated in the database for storing data to be imported
Each field and corresponding table；S303：One data are set in system front end and import interface comprising one imports entrance, passes through
It imports entrance and selectes and be recorded in an import operation by tables of data import system, and by result is imported after a tables of data to be imported
As a result record information list and one imports log information, carries out in next step, needing to download if importing failure if importing successfully
The import operation result record information list post analysis failure cause is imported again after elimination problem；S304：It is set in system front end
It sets an importing data and checks interface, for from transferring the system of having been introduced into database and be stored in the data in database, and press
According to the data column in template be presented in front end page for import operation person or other have and check that permission person checks.
The column basis field of any data column includes in one of the embodiments,：Column name, database column name
Title, column serial number, column type, train value are long, train value sentence empty, column whether effectively, column verification ID, operation.
Verification rule field information corresponding in the database has verification ID, verification in one of the embodiments,
Description, rule type, verification condition, regular entity, rule creation time, the state of validity label.
The planning mode of the allocation list is in one of the embodiments,：It is pre-prepared to Excel tables of data to be imported
6 allocation lists, including allocation list 1 to 6 are stored in Chinese and English title and data table id that information includes tables of data in allocation list 1；
Chinese and English title, gauge outfit serial number and the data table id of tables of data gauge outfit are added in allocation list 2；ID, school are verified in allocation list 3
The description of the condition and verification tested；The import operation person privileges configuration information in allocation list 4；Log note is imported in allocation list 5
Record information；Import operation result records information in allocation list 6.
Based on the same technical idea, the present invention also provides a kind of data to import managing device, and the managing device includes
It generates configuration table unit, setting verification rules unit and imports data cell.
The generation configures table unit, generates allocation list for generating interface by allocation list, matching in allocation list is arranged
Confidence breath；The setting verifies rules unit, generates for the front end setting one where generating interface in allocation list with allocation list
Interface verification rule interface arranged side by side, for generating verification rule or importing previously prepared verification rule；The importing number
According to unit, utilizes for the front-end interface where generating interface in allocation list with the account for importing permission, import tables of data.
Based on the same technical idea, the present invention also provides a kind of mobile terminal, the mobile terminal, including：
Touch-sensitive display；
Memory；
One or more processors；
One or more of processors are configurable for the step of executing above-mentioned management method.
Based on the same technical idea, the present invention also provides a kind of storage medium for being stored with computer-readable instruction, institutes
When stating computer-readable instruction and being executed by one or more processors, so that one or more processors execute above-mentioned management method
The step of.
Above-mentioned data import management method, apparatus, mobile terminal and storage medium, logical in the front end for the system that data import
It crosses configuration interface and generates allocation list corresponding with Excel tables of data to be imported, storage Excel number to be imported in the allocation list
According to the corresponding configuration information of table, data generate the importing template of the data format in corresponding data table by allocation list before importing,
Have the data in the tables of data of its regulation data format according to its importing；Before where the allocation list of generation generation interface
The one verification rule configuration interface arranged side by side with it of end setting, for generating or importing previously prepared verification rule, any school
The corresponding one verification ID of generation of rule is tested, after the verification rule application, according to the rule condition and corresponding execution being arranged inside
It acts and the data column that data import in template is verified, it is ensured that data are listed in availability when data import, and prevent data
The setting mistake of column leads to the problem of unexpected when data being caused to import；It utilizes in front end and is imported with the account for importing permission
Tables of data.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention
Limitation.
Fig. 1 is whole implementation flow chart in one embodiment of the invention；
Fig. 2 is allocation list product process figure in one embodiment of the invention；
Fig. 3 is that setting verifies regular flow chart in one embodiment of the invention；
Fig. 4 is to import data flowchart in one embodiment of the invention；
Fig. 5 is the structural framing figure of managing device in one embodiment of the invention；
Fig. 6 is the embodiment schematic block diagram of mobile terminal part-structure provided in an embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
Specifically, as shown in Figure 1, the present invention provides a kind of technical solution：
A kind of data importing management method, the management method, specific step is as follows：
S1：Interface is generated by allocation list and generates allocation list, and the configuration information in allocation list is set.
The front end of the system of importing generates allocation list corresponding with Excel tables of data to be imported by configuration interface, should
The storage corresponding configuration information of Excel tables of data to be imported in allocation list, data import preceding by the corresponding number of allocation list generation
According to the importing template of the data format in table, have the data in the tables of data of its regulation data format according to its importing.
S2：Front end setting one where generating interface in allocation list generates interface verification rule circle arranged side by side with allocation list
Face, for generating verification rule or importing previously prepared verification rule.
Allocation list generate interface where front end be arranged a verification rule configuration interface arranged side by side with it, for generation or
Person imports previously prepared verification rule, and any verification rule is corresponding to generate a verification ID, after the verification rule application, according to
The rule condition being arranged inside and corresponding execution movement verify the data column that data import in template, it is ensured that data column
Availability when data import, the setting mistake for preventing data from arranging lead to the problem of unexpected when data being caused to import.
S3：Front-end interface where generating interface in allocation list is utilized with the account for importing permission, imports tables of data.
It utilizes in system front end with the account for importing permission, corresponding tables of data is imported into the house prosperity transaction system.
The present embodiment is acted according to the rule condition and execution that are arranged in verification rule to data by introducing verification rule
Column are verified, it is ensured that data are listed in availability when data import, when the setting mistake for preventing data from arranging causes data to import
It leads to the problem of unexpected.After there is the account for importing permission to import tables of data, data procedures are imported without shutting down portion
Administration, importing is simple and convenient, time saving and energy saving.
Specifically, as shown in Fig. 2, generating configuration template in the step S1 includes step S101 to step S106：
S101：Scripting language creation one is called to import the allocation list of template, the allocation list and data for generating data
Library connection generates data and imports template, imports data to template and be stored in database profession.
The scripting language is otherwise known as the language or dynamic language of enlarging, is a kind of programming language, soft for controlling
Part application program, script usually with text (such as ASCII) preservation, are only explained or are compiled when called；Pass through the script
Language creates an allocation list, and the allocation list of generation is imported in database, for storing and using.
S102：Scripting language is called to add configuration feature, the configuration feature includes that data import template query function, number
According to the newly-increased and deletion function of importing template.
Corresponding configuration feature is disposed in allocation list by scripting language, the data import template query function and are used for
Data to be imported are inquired, by inquiring data to be imported in the system where generating interface in allocation list, realization will be certain
Data accurately import in Excel table；The data import the newly-increased of template and delete function for realizing any newly-increased list
Or delete list, realize the control increased and decreased list ranks quantity.
S103：The layout of planning default display list interface, interface display title, template including template in allocation list
Title in the database, remark information, creation time, modification time, is opened for the operation of editing template validity switch
It closes.
The Operation switch includes modification, creation column, downloads template, uploads template；Wherein, template switching and downloading are uploaded
Template switching is used to generate allocation list the data being stored in database profession after interface generates and imports template in the form of unique file
Export imports database, is modified and is updated offline convenient for being detached from database；Modification switch is for existing template
In list of items edited；Creation column switch is with carrying out existing template newly to add operation, so that one item data of increase arranges,
A field in corresponding tables of data to be imported.
S104：Newly-increased importing template operation circle of template basic information is imported for data to be arranged based on allocation list creation one
Face, interior layout import each input entrance of template basic information for generating data.
The newly-increased importing template operation interface of a data is developed, imports template basic information for data to be arranged, i.e., for giving birth to
My each input entrance of template basic information is imported at data, including：Creation column, creation row, downloads template, upload template,
Inquire data, newly-increased row or column, delete row or column etc..
S105：Based on the edit model interface of the corresponding any template of allocation list creation, default interface is laid out the corresponding mould
Each data of plate arrange, and any data column are correspondingly provided at least two column basis fields.
Any data column column basis field include：Column name, database column title, column serial number, column type, train value be long,
Train value sentences whether empty, column are effective, arrange verification ID, operation.
S106：It is used to increase newly or edit the column editing interface of data column based on edit model interface creating one.
The newly-increased data column editing interface that perhaps editor's data arrange is for increasing newly, deleting or compiling to editor's data list
Volume.
The present embodiment, which passes through, calls scripting language to create allocation list, add configuration feature, planning interface layout, newly-increased importing
Template operation interface, drawing template establishment editing interface and column editing interface function, in order to when importing template, without portion again
Backstage template is affixed one's name to, is uploaded without overlapping development, the function code of response and reading link.Deployment through this embodiment, directly
Connect can increase to template and deletion, to operations such as settings of data column, there is very high flexibility and practicability.
Specifically, as shown in figure 3, verifying data packet in step S2 includes step S201 to step S203：
S201：One, which is generated, in system front end exploitation using scripting language verifies regular configuration interface, and database association,
In verification list of rules in verification rule deposit database through being generated by it, the default for verifying regular configuration interface shows boundary
Face show imported or generated verification rule, the verification rule of any generation in default display interfaces be equipped with one and its
One-to-one Operation switch group, for checking regular details or carrying out rule editing.
The regular configuration interface of the verification, for generating the verification rule of verification data, the verification being stored in database profession
In list of rules, the verification rule of any generation is equipped with one and its one-to-one Operation switch group in default display interfaces,
For checking the regular details of verification and being edited to verification rule.
S202：Deployment verification rule uploads and download function on verifying regular configuration interface, can will by download function
Verification rule from database in the form of independent script file export after be convenient for off-line editing, can also by upload function,
The good verification rule of preparatory off-line editing is imported in the verification list of rules into database.
Off-line editing is carried out to verification rule, is stored in database profession, is used to inquire later；It can be by downloading function
Verification rule can be downloaded from database and be come out, off-line editing be carried out, in being uploaded to database, or by editing in advance
Good verification rule, is uploaded in database, for the verification to data.
S203：Generate a newly-increased interface of verification rule based on regular configuration interface exploitation is verified, in layout verification description,
Rule type and regular three projects of verification.
Wherein, verification described project is used to show this verification rule in the default interface for verifying regular configuration interface
Effect；Rule type project is used to show the classification letter of this verification rule in the default interface for verifying regular configuration interface
Breath；Verification rule items are used to define the execution condition of verification rule and corresponding execute movement.
Any verification rule is corresponding with following field information in the database：Verify ID, verification description, Regularia
Type, verification condition, regular entity, rule creation time, the state of validity label；Wherein, the state of validity label is for indicating
Whether the rule is applied, be boolean's Value Data, when either step 1) generate template at least one data arrange application
The rule, then otherwise it is false that the corresponding the state of validity of the rule, which is labeled as true value, and the application of rule is used
Increasing regular application field in data column, numerical value is 0 or by the verification ID of application rule, when regular application field is 0,
Any verification rule is not applied in expression, is otherwise the corresponding verification rule of the application verification ID equal with numerical value.
The present embodiment checks the editor of regular details and rule by verifying regular configuration interface, and disposes verification rule
It uploads and download function, user intuitively can dispose and use verification rule, it is ensured that pass through the school of verification rule when data import
It tests, realizes the availability of data.
Specifically, importing list data in step S3 as shown in Figure 4 includes step S301 to step S304：
S301：System front end be arranged an authority distribution interface, the permission imported data to it is existing in a certain system
It is assigned after account binding and imports permission, makes it that can operate importing data.
Authority distribution operation can be by preparing operator's privileges configuration information table in advance, and sets in authority distribution interface
The importing entrance for importing operator's privileges configuration information table is set, assigns the more accurate operating right of operator to facilitate.
S302：According to the corresponding importing template of the tables of data to be imported of generation, generated in the database for storing wait lead
Enter data each field and corresponding table.
Template is imported according to the data of generation, field and table are generated in the database, for storing data to be imported.
S303：One data are set in system front end and import interface comprising one imports entrance, by importing entrance selected one
By in tables of data import system after tables of data to be imported, and an import operation result record information list is recorded in by result is imported
Import log information with one, next step carried out as imported successfully if, need to download if importing unsuccessfully as described in import operation knot
Fruit record information list post analysis failure cause is imported again after elimination problem.
The data import interface, are equipped with a data and import entrance, for data to be imported to be imported entrance by data
It is directed into system, for storing wait lead such as data, when importing data into Excel, by inquiring in the system
The data of storage realize importing of the corresponding data in Excel table.
S304：Interface is checked in one importing data of system front end setting, for transferring the system of having been introduced into from database
And be stored in the data in database, and according in template data column be presented in front end page for import operation person or other
Have and checks that permission person checks.
The importing data query interface, for being led in enquiry form after data to be imported are directed into Excel table
Whether the data entered are correct.
The present embodiment assigns a certain account by authority distribution interface and preset operator's privileges configuration information table and imports
Permission imports interface by setting data, so that the operator having permission is imported interface by data and imports data to Excel
In, check that interface supplies the operator with permission to transfer and check the data imported by importing data, above by permission
Realize the mode that data are imported and checked, it can be ensured that the reliability that data import avoids the invasion of invalid data.
In one embodiment, the column basis field of any data column includes：Column name, database column title, column serial number,
Column type, train value are long, train value sentences whether empty, column are effective, arrange verification ID, operation.
The basic field that the data column of the present embodiment include is more as far as possible, then verifies in verification rule to data column
When, it more can ensure that the availability of data column, the setting mistake for preventing data from arranging generates unpredictable ask when data being caused to import
Topic.
In one embodiment, verification rule field information corresponding in the database have verification ID, verification description,
Rule type, verification condition, regular entity, rule creation time, the state of validity label.
The present embodiment enumerates the corresponding in the database field information of verification rule, can ensure that the data of importing into
When row verification, the data of importing are subjected to one-to-one correspondence verification, ineligible data column are identified, are also convenient for having
The operator of permission checks the state of rule and data column.
In one embodiment, the planning mode of the allocation list is：6 pre-prepared to Excel tables of data to be imported
Allocation list, including allocation list 1 to 6 are stored in Chinese and English title and data table id that information includes tables of data in allocation list 1；?
Chinese and English title, gauge outfit serial number and the data table id of tables of data gauge outfit are added in allocation list 2；ID, verification are verified in allocation list 3
Condition and verification description；The import operation person privileges configuration information in allocation list 4；Log recording is imported in allocation list 5
Information；Import operation result records information in allocation list 6.
The present embodiment is all protected institute of the invention configuration in need and check information by prefabricated 6 allocation lists
Deposit, calling when importing for follow-up data is verified and is checked, above-mentioned design, effectively prevent some Excel importing need to increase,
When deleting, changing gauge outfit, the problem of redeploying backstage template and modify backstage code.
Based on the same technical idea, the present invention also provides a kind of data to import managing device, as shown in figure 5, the management
Device includes generating configuration table unit, setting verification rules unit and importing data cell.
The generation configures table unit, generates allocation list for generating interface by allocation list, matching in allocation list is arranged
Confidence breath；
The setting verifies rules unit, generates for the front end setting one where generating interface in allocation list with allocation list
Interface verification rule interface arranged side by side, for generating verification rule or importing previously prepared verification rule；
The importing data cell is utilized for the front-end interface where generating interface in allocation list with importing permission
Account imports tables of data.
Based on the same technical idea, the present invention also very provides a kind of mobile terminal, for realizing across mobile application data
The method for importing management, as shown in fig. 6, for ease of description, illustrating only related to the embodiment of the present invention 20 part, specifically
What technical detail did not disclosed, please refer to present invention method part.The terminal can be include mobile phone, tablet computer, PDA
(Personal Digital Assistant, personal digital assistant), POS (Point of Sales, point-of-sale terminal), vehicle mounted electric
Any terminal device such as brain, by taking mobile terminal is mobile phone as an example：
Fig. 6 shows the block diagram of the part-structure of mobile phone relevant to mobile terminal provided in an embodiment of the present invention.Ginseng
Fig. 6 is examined, mobile phone includes：Baseband processing unit 410, memory 420, input unit 430, display unit 440, sensor 450, sound
The portions such as frequency circuit 460, Wireless Fidelity (Wireless Fidelity, WiFi) unit 470, processor 480 and power supply 490
Part.It will be understood by those skilled in the art that handset structure shown in Fig. 6 does not constitute the restriction to mobile phone, it may include ratio
More or fewer components are illustrated, certain components or different component layouts are perhaps combined.
Baseband processing unit 410 can be used for synthesizing the baseband signal that will emit, or carry out to the baseband signal received
Decoding.Specifically, being exactly that audio signal is compiled into the base band code for emitting when emitting；When reception, the base band received
Code is interpreted as audio signal.Meanwhile being also responsible for address information (cell-phone number, station address), text information (news in brief text, website
Text), the compiling of pictorial information (multimedia message).
Memory 420 can be used for storing software program and unit, and processor 480 is stored in memory 420 by operation
Software program and unit, thereby executing the various function application and data processing of mobile phone.Memory 420 can mainly include
Storing program area and storage data area, wherein storing program area can application journey needed for storage program area, at least one function
Sequence (such as sound-playing function, image player function etc.) etc.；Storage data area can be stored to be created according to using for mobile phone
Data (such as audio data, phone directory etc.) etc..It, can be in addition, memory 420 may include high-speed random access memory
Including nonvolatile memory, for example, at least a disk memory, flush memory device or other volatile solid-states
Part.
Input unit 430 can be used for receiving the number or character information of input, and generate with the user setting of mobile phone with
And the related key signals input of function control.Specifically, input unit 430 may include that touch panel 431 and other inputs are set
Standby 432.Touch panel 431, also referred to as touch screen, collect user on it or nearby touch operation (such as user use
The operation of any suitable object or attachment such as finger, stylus on touch panel 431 or near touch panel 431), and root
Corresponding attachment device is driven according to preset formula.Optionally, touch panel 431 may include touch detecting apparatus and touch
Two parts of controller.Wherein, the touch orientation of touch detecting apparatus detection user, and touch operation bring signal is detected,
Transmit a signal to touch controller；Touch controller receives touch information from touch detecting apparatus, and is converted into touching
Point coordinate, then gives processor 480, and can receive order that processor 480 is sent and be executed.Furthermore, it is possible to using electricity
The multiple types such as resistive, condenser type, infrared ray and surface acoustic wave realize touch panel 431.In addition to touch panel 431, input
Unit 430 can also include other input equipments 432.Specifically, other input equipments 432 can include but is not limited to secondary or physical bond
One of disk, function key (such as volume control button, switch key etc.), trace ball, mouse, operating stick etc. are a variety of.
Display unit 440 can be used for showing information input by user or be supplied to user information and mobile phone it is various
Menu.Display unit 440 may include display panel 441, optionally, can use liquid crystal display (Liquid Crystal
Display, LCD), the forms such as Organic Light Emitting Diode (Organic Light-Emitting Diode, OLED) it is aobvious to configure
Show panel 441.Further, touch panel 431 can cover display panel 441, when touch panel 431 detect it is on it or attached
After close touch operation, processor 480 is sent to determine the type of touch event, is followed by subsequent processing device 480 according to touch event
Type corresponding visual output is provided on display panel 441.Although in Fig. 6, touch panel 431 and display panel 441
It is that the input and input function of mobile phone are realized as two independent components, but in some embodiments it is possible to by touch-control
Panel 431 and display panel 441 are integrated and that realizes mobile phone output and input function.
Mobile phone may also include at least one sensor 450, such as optical sensor, motion sensor and other sensors.
Specifically, optical sensor may include ambient light sensor and proximity sensor, wherein ambient light sensor can be according to ambient light
Light and shade adjust the brightness of display panel 441, proximity sensor can close display panel 441 when mobile phone is moved in one's ear
And/or backlight.As a kind of motion sensor, accelerometer sensor can detect (generally three axis) acceleration in all directions
Size, can detect that size and the direction of gravity when static, can be used to identify the application of mobile phone posture, (for example horizontal/vertical screen is cut
Change, dependent game, magnetometer pose calibrating), Vibration identification correlation function (such as pedometer, tap) etc.；May be used also as mobile phone
The other sensors such as gyroscope, barometer, hygrometer, thermometer, the infrared sensor of configuration, details are not described herein.
Voicefrequency circuit 460, loudspeaker 461, microphone 462 can provide the audio interface between user and mobile phone.Audio-frequency electric
Electric signal after the audio data received conversion can be transferred to loudspeaker 461, be converted to sound by loudspeaker 461 by road 460
Signal output；On the other hand, the voice signal of collection is converted to electric signal by microphone 462, is turned after being received by voicefrequency circuit 460
It is changed to audio data, then by after the processing of audio data output processor 480, such as another mobile phone is sent to through RF circuit 410,
Or audio data is exported to memory 420 to be further processed.
WiFi belongs to short range wireless transmission technology, and mobile phone can help user's transceiver electronics postal by WiFi unit 470
Part, browsing webpage and access streaming video etc., it provides wireless broadband internet access for user.Although Fig. 6 is shown
WiFi unit 470, but it is understood that, and it is not belonging to must be configured into for mobile phone, it can according to need do not changing completely
Become in the range of the essence of invention and omits.
Processor 480 is the control centre of mobile phone, using the various pieces of various interfaces and connection whole mobile phone, is led to
It crosses operation or executes the software program or unit being stored in memory 420, and call the number being stored in memory 420
According to, execute mobile phone various functions and processing data, thus to mobile phone carry out integral monitoring.Optionally, processor 480 may include
One or more processing units；Preferably, processor 480 can integrate application processor and modem processor, wherein application
The main processing operation system of processor, user interface and application program etc., modem processor mainly handles wireless communication.It can
With understanding, above-mentioned modem processor can not also be integrated into processor 480.
Mobile phone further includes the power supply 490 (such as battery) powered to all parts, it is preferred that power supply can pass through power supply pipe
Reason system and processor 480 are logically contiguous, to realize management charging, electric discharge and power managed by power-supply management system
Etc. functions.
Although being not shown, mobile phone can also include camera, bluetooth unit etc., and details are not described herein.
In embodiments of the present invention, processor 480 included by the terminal can execute data in above-described embodiment and import
The step of management method.
Based on the same technical idea, the present invention also provides a kind of storage medium for being stored with computer-readable instruction, institutes
When stating computer-readable instruction and being executed by one or more processors, so that one or more processors execute in above-described embodiment
The step of management method, the management process include：Allocation list is generated by configuration interface, is arranged in allocation list and matches confidence
Breath；Front end setting one where generating interface in allocation list generates interface verification rule interface arranged side by side with allocation list, for giving birth to
At verification rule or import previously prepared verification rule；Front-end interface where generating interface in allocation list, which utilizes to have, to be led
Enter the account of permission, imports tables of data.
Those of ordinary skill in the art will appreciate that all or part of the steps in the various methods of above-described embodiment is can
It is completed with instructing relevant hardware by program, which can be stored in a computer readable storage medium, storage
Medium may include：Read-only memory (ROM, Read Only Memory), random access memory (RAM, Random
Access Memory), disk or CD etc..
Those of ordinary skill in the art will appreciate that implement the method for the above embodiments be can be with
Relevant hardware is instructed to complete by program, the program can store in a kind of computer readable storage medium, on
Stating the storage medium mentioned can be read-only memory, disk or CD etc..
Some exemplary embodiments of the invention above described embodiment only expresses, the description thereof is more specific and detailed, but
It cannot be construed as a limitation to the scope of the present invention.It should be pointed out that for the ordinary skill people of this field
For member, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to of the invention
Protection scope.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (10)
1. a kind of data import management method, which is characterized in that the management method includes：
S1：Interface is generated by allocation list and generates allocation list, and the configuration information in allocation list is set；
S2：Front end setting one where generating interface in allocation list generates interface verification rule interface arranged side by side with allocation list, uses
In generating, verification is regular or the previously prepared verification rule of importing；
S3：Front-end interface where generating interface in allocation list is utilized with the account for importing permission, imports tables of data.
2. a kind of data according to claim 1 import management method, which is characterized in that the step S1 includes：
S101：Scripting language creation one is called to import the allocation list of template for generating data, the allocation list and database connect
It connects, generates data and import template, import data to template and be stored in database profession；
S102：Scripting language is called to add configuration feature, the configuration feature includes that data import template query function, data are led
Enter the newly-increased of template and deletes function；
S103：The layout of planning default display list interface in allocation list, interface display title, template including template are in number
According in library title, validity switch, remark information, creation time, modification time, for the Operation switch of editing template；
S104：The newly-increased importing template operation interface of template basic information is imported for data to be arranged based on allocation list creation one,
Layout imports each input entrance of template basic information for generating data in it；
S105：Based on the edit model interface of the corresponding any template of allocation list creation, default interface is laid out the corresponding template
Each data column, any data column are correspondingly provided at least two column basis fields；
S106：It is used to increase newly or edit the column editing interface of data column based on edit model interface creating one.
3. a kind of data according to claim 1 import management method, which is characterized in that the step S2 includes：
S201：One, which is generated, in system front end exploitation using scripting language verifies regular configuration interface, and database association, via
In verification list of rules in its verification rule deposit database generated, the default display interfaces for verifying regular configuration interface are aobvious
Show imported or generated verification rule, the verification rule of any generation in default display interfaces be equipped with one with its one by one
Corresponding Operation switch group, for checking regular details or carrying out rule editing；
S202：Deployment verification rule upload and download function on the regular configuration interface of verification are advised verification by download function
Then be convenient for off-line editing after exporting in the form of independent script file in database, or by upload function, import in advance from
The verification rule that line edits is in the verification list of rules into database；
S203：The one newly-increased interface of verification rule of generation is developed based on regular configuration interface is verified, it is interior to be laid out verification description, rule
Type and regular three projects of verification.
4. a kind of data according to claim 1 import management method, which is characterized in that the step S3 includes：
S301：In system front end, one authority distribution interface, existing account in the permission imported data to and a certain system are set
It is assigned after binding and imports permission, makes it that can operate importing data；
S302：According to the corresponding importing template of the tables of data to be imported of generation, generated in the database for storing number to be imported
According to each field and corresponding table；
S303：One data are set in system front end and import interface comprising one imports entrance, by importing entrance selected one wait lead
By in tables of data import system after the tables of data entered, and an import operation result record information list and one are recorded in by result is imported
Import log information, carried out as imported successfully if in next step, need to download if importing fails as described in import operation result remember
Information table post analysis failure cause is recorded, is imported again after elimination problem；
S304：Interface is checked in one importing data of system front end setting, for transferring the system of having been introduced into from database and depositing
Enter the data in database, and according to the data column in template be presented in front end page for import operation person or other have
Check that permission person checks.
5. a kind of data according to claim 2 import management method, which is characterized in that the column base word of any data column
Section include：Column name, database column title, column serial number, column type, train value are long, train value sentence empty, column whether effectively, column verification ID,
Operation.
6. a kind of data according to claim 1 import management method, which is characterized in that the verification rule is in database
In corresponding field information have verification ID, verification description, rule type, verification condition, rule entity, the rule creation time, have
Effect property status indication.
7. a kind of data according to claim 1 import management method, which is characterized in that the planning mode of the allocation list
For：To pre-prepared 6 allocation lists of Excel tables of data to be imported, including allocation list 1 to 6, packet is stored in allocation list 1
Include the Chinese and English title and data table id of tables of data；Chinese and English title, the gauge outfit serial number of tables of data gauge outfit are added in allocation list 2
With data table id；Verification ID, the condition of verification and the description of verification are imported in allocation list 3；The import operation person in allocation list 4
Privileges configuration information；Log information is imported in allocation list 5；Import operation result records information in allocation list 6.
8. a kind of data import managing device, which is characterized in that the managing device includes generating configuration table unit, setting verification
Rules unit and importing data cell：
The generation configures table unit, generates allocation list for generating interface by allocation list, is arranged in allocation list and matches confidence
Breath；
The setting verifies rules unit, generates interface with allocation list for the front end setting one where generating interface in allocation list
Verification rule interface arranged side by side, for generating verification rule or importing previously prepared verification rule；
The importing data cell is utilized for the front-end interface where generating interface in allocation list with the account for importing permission
Number, import tables of data.
9. a kind of mobile terminal, which is characterized in that including：
Touch-sensitive display；
Memory；
One or more processors；
One or more of processors are configurable for executing the management method as described in any one of claims 1 to 7
Step.
10. a kind of storage medium for being stored with computer-readable instruction, the computer-readable instruction is handled by one or more
When device executes, so that one or more processors are executed as described in any one of claims 1 to 7 the step of management method.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810363680.1A CN108874866A (en) | 2018-04-22 | 2018-04-22 | Data import management method, apparatus, mobile terminal and storage medium |
| PCT/CN2018/104730 WO2019205415A1 (en) | 2018-04-22 | 2018-09-08 | Data import management method and apparatus, mobile terminal and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810363680.1A CN108874866A (en) | 2018-04-22 | 2018-04-22 | Data import management method, apparatus, mobile terminal and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108874866A true CN108874866A (en) | 2018-11-23 |
Family
ID=64327095
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810363680.1A Withdrawn CN108874866A (en) | 2018-04-22 | 2018-04-22 | Data import management method, apparatus, mobile terminal and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN108874866A (en) |
| WO (1) | WO2019205415A1 (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109685669A (en) * | 2018-12-11 | 2019-04-26 | 北京量子保科技有限公司 | A kind of policy information data processing method and system |
| CN110046452A (en) * | 2019-04-25 | 2019-07-23 | 北京世冠金洋科技发展有限公司 | A kind of data/address bus management method, device and electronic equipment |
| CN110147402A (en) * | 2019-05-22 | 2019-08-20 | 北大方正集团有限公司 | Excel file introduction method and equipment, deriving method and equipment |
| CN110958292A (en) * | 2019-09-17 | 2020-04-03 | 平安银行股份有限公司 | File uploading method, electronic device, computer equipment and storage medium |
| CN110968997A (en) * | 2019-12-03 | 2020-04-07 | 广联达科技股份有限公司 | Strong controllable document generation method and device, storage medium and electronic equipment |
| CN110990396A (en) * | 2019-10-12 | 2020-04-10 | 贝壳技术有限公司 | Data storage method, device and storage medium |
| CN111414739A (en) * | 2020-02-27 | 2020-07-14 | 北京中亦安图科技股份有限公司 | Excel data entry component, entry method and device |
| CN113792017A (en) * | 2021-11-17 | 2021-12-14 | 中建电子商务有限责任公司 | Method and system for checking template content imported into excel |
| CN115905269A (en) * | 2023-01-06 | 2023-04-04 | 深圳市明源云科技有限公司 | Data import method, system, device and storage medium |
| CN116150142A (en) * | 2023-04-14 | 2023-05-23 | 成都数联云算科技有限公司 | Method, device, medium, equipment and product for field verification and rule obtaining thereof |
Families Citing this family (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159985B (en) * | 2019-12-24 | 2024-01-26 | 平安养老保险股份有限公司 | Data deriving method, apparatus, computer device and computer readable storage medium |
| CN111476009A (en) * | 2020-03-23 | 2020-07-31 | 一汽奔腾轿车有限公司 | New car tax declaration configuration information consistency verification system |
| CN111581210A (en) * | 2020-04-30 | 2020-08-25 | 深圳壹账通智能科技有限公司 | Data importing method and system |
| CN111539049B (en) * | 2020-05-15 | 2024-02-09 | 中国电子科技集团公司第十四研究所 | Intelligent assembly system and method for electronic equipment |
| CN111639120B (en) * | 2020-06-05 | 2023-08-18 | 中国建设银行股份有限公司 | Method, device and equipment for imaging architecture view and readable storage medium |
| CN111767704B (en) * | 2020-06-30 | 2024-01-26 | 浪潮通用软件有限公司 | Excel form template generation method and device |
| CN112182016A (en) * | 2020-09-30 | 2021-01-05 | 中国民航信息网络股份有限公司 | Automatic checking method for higher point check and related system |
| CN112861495A (en) * | 2020-11-24 | 2021-05-28 | 辽宁振兴银行股份有限公司 | Method for generating impala SQL statement based on Excel template file |
| CN112783859B (en) * | 2021-01-08 | 2023-03-07 | 河北志晟信息技术股份有限公司 | Lightweight concurrent migration method for database |
| CN113177035A (en) * | 2021-04-13 | 2021-07-27 | 南京波轩信息科技有限公司 | Electromagnetic spectrum database system based on radio spectrum data management platform |
| CN113517048A (en) * | 2021-07-12 | 2021-10-19 | 挂号网（杭州）科技有限公司 | Medical record data verification method and device, electronic equipment and storage medium |
| CN114691274A (en) * | 2022-03-31 | 2022-07-01 | 中国建设银行股份有限公司 | Data processing method, device, equipment, medium and product |
| CN115422280B (en) * | 2022-11-04 | 2023-02-14 | 杭州西湖新基建数字技术有限公司 | Interface method for increasing, deleting and modifying data of uncertain data structure |
| CN115759516B (en) * | 2022-11-21 | 2023-08-29 | 成都博智云创科技有限公司 | Basic procedure management method based on data center system |
| CN115860677B (en) * | 2022-12-12 | 2024-03-22 | 中量工程咨询有限公司 | Component engineering quantity data processing method, system, equipment and storage medium |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317974B (en) * | 2014-11-21 | 2017-07-11 | 武汉理工大学 | Multi-source data introduction method in a kind of ERP system of restructural |
| CN106156209A (en) * | 2015-04-23 | 2016-11-23 | 中兴通讯股份有限公司 | Data processing method and device |
| CN106991100B (en) * | 2016-01-21 | 2021-10-01 | 北京京东尚科信息技术有限公司 | Data import method and device |
| CN106874484A (en) * | 2017-02-20 | 2017-06-20 | 济南浪潮高新科技投资发展有限公司 | The method and device that a kind of data are imported |
| CN107247767B (en) * | 2017-06-05 | 2020-08-04 | 浪潮通用软件有限公司 | Method and device for importing formatted data file into database |
-
2018
- 2018-04-22 CN CN201810363680.1A patent/CN108874866A/en not_active Withdrawn
- 2018-09-08 WO PCT/CN2018/104730 patent/WO2019205415A1/en active Application Filing
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109685669A (en) * | 2018-12-11 | 2019-04-26 | 北京量子保科技有限公司 | A kind of policy information data processing method and system |
| CN110046452A (en) * | 2019-04-25 | 2019-07-23 | 北京世冠金洋科技发展有限公司 | A kind of data/address bus management method, device and electronic equipment |
| CN110147402A (en) * | 2019-05-22 | 2019-08-20 | 北大方正集团有限公司 | Excel file introduction method and equipment, deriving method and equipment |
| CN110958292A (en) * | 2019-09-17 | 2020-04-03 | 平安银行股份有限公司 | File uploading method, electronic device, computer equipment and storage medium |
| CN110990396A (en) * | 2019-10-12 | 2020-04-10 | 贝壳技术有限公司 | Data storage method, device and storage medium |
| CN110990396B (en) * | 2019-10-12 | 2024-02-27 | 贝壳技术有限公司 | Data storage method, device and storage medium |
| CN110968997B (en) * | 2019-12-03 | 2023-07-21 | 广联达科技股份有限公司 | Strong controllable document generation method and device, storage medium and electronic equipment |
| CN110968997A (en) * | 2019-12-03 | 2020-04-07 | 广联达科技股份有限公司 | Strong controllable document generation method and device, storage medium and electronic equipment |
| CN111414739A (en) * | 2020-02-27 | 2020-07-14 | 北京中亦安图科技股份有限公司 | Excel data entry component, entry method and device |
| CN111414739B (en) * | 2020-02-27 | 2023-04-14 | 北京中亦安图科技股份有限公司 | Excel data entry component, entry method and device |
| CN113792017A (en) * | 2021-11-17 | 2021-12-14 | 中建电子商务有限责任公司 | Method and system for checking template content imported into excel |
| CN115905269A (en) * | 2023-01-06 | 2023-04-04 | 深圳市明源云科技有限公司 | Data import method, system, device and storage medium |
| CN116150142A (en) * | 2023-04-14 | 2023-05-23 | 成都数联云算科技有限公司 | Method, device, medium, equipment and product for field verification and rule obtaining thereof |
| CN116150142B (en) * | 2023-04-14 | 2023-06-27 | 成都数联云算科技有限公司 | Method, device, medium, equipment and product for field verification and rule obtaining thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2019205415A1 (en) | 2019-10-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108874866A (en) | Data import management method, apparatus, mobile terminal and storage medium | |
| CN1790326B (en) | System for synchronizing natural language input element and graphical user interface | |
| CN104969165B (en) | Time input based on gesture | |
| CN108055569A (en) | Direct broadcasting room barrage sending method, device and corresponding terminal | |
| CN106815316A (en) | Method, device and mobile terminal that content of pages is shared | |
| CN109582579A (en) | Applied program testing method, device, electronic equipment and storage medium | |
| CN106104528A (en) | Begin a project for screen and select and the method based on model of disambiguation | |
| CN108345543A (en) | A kind of data processing method, device, equipment and storage medium | |
| CN105847325B (en) | The adjustment method and device of applications client | |
| CN106227588A (en) | The creation method of a kind of multi-instance object, device and mobile terminal | |
| CN107402964A (en) | A kind of information recommendation method, server and terminal | |
| CN107329985A (en) | A kind of collecting method of the page, device and mobile terminal | |
| CN107545404A (en) | Bill based reminding method and device | |
| CN105677571A (en) | Device and method for testing software compatibility of mobile terminal | |
| CN105518604A (en) | Feedback for lasso selection | |
| CN110058850A (en) | A kind of development approach of application, device and storage medium | |
| CN112882630B (en) | Information configuration method and related product | |
| CN106484771B (en) | Different information file generated and application process, device | |
| CN107870666A (en) | A kind of terminal control method and terminal | |
| CN107908407A (en) | Compilation Method, device and terminal device | |
| CN108829430A (en) | Java Web project update method and relevant apparatus based on Eclipse and Tomcat | |
| CN108124016A (en) | A kind of method and apparatus for sending POST request | |
| CN108139895A (en) | Font font preview | |
| CN108073495A (en) | The localization method and device of application crash reason | |
| CN106909366A (en) | The method and device that a kind of widget shows |
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 | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20181123 |