CN109992585A - Data lead-in method for office management system - Google Patents
Data lead-in method for office management system Download PDFInfo
- Publication number
- CN109992585A CN109992585A CN201910256859.1A CN201910256859A CN109992585A CN 109992585 A CN109992585 A CN 109992585A CN 201910256859 A CN201910256859 A CN 201910256859A CN 109992585 A CN109992585 A CN 109992585A
- Authority
- CN
- China
- Prior art keywords
- data
- imported
- field
- lead
- management system
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of data lead-in method for office management system comprising following steps: choosing data file to be imported and determines the target storage template of data to be imported；Data to be imported are parsed to obtain data to be loaded according to the format of the data file to be imported；The field in the data to be loaded is chosen as data source field according to business demand, to the field in target storage template is added, delete operation obtains datum target field, and determine the mapping relations of the data source field and the datum target field；Field in the data to be loaded is verified, the data to be loaded are imported in office management system after verification is qualified and obtain target storing data.Provided by the present invention for the data lead-in method of office management system, intelligent, the demand of flexible adaptation user is split and merged, the data for needing to import can be passed to according to their own needs, realization user is customized.
Description
Technical field
The invention belongs to data management field more particularly to a kind of data lead-in methods for office management system.
Background technique
When we establish a database, want different dispersion data preparations to wherein, due to user's logarithm
It does not know much have less understanding according to structure into needing a mode to realize the operation basic data of user flexibility, and according to the business need of itself
It wants, realizes that data are shown, the demand that thus data import is come into being.The data leading-in technique of early stage, being primarily upon data is
The success of no and business association realizes that lead-in mode is also relatively simple, without comprehensively verification adaptation custom feature, it is having even
Be added verification also can not in real time back-checking as a result, and to import result classify, cannot achieve boss's table association, can not
Realize that big data quantity imports, the data import feature that some companies release writes structure in the dust both for the business of our company
Coinage section and data verification mode are unable to satisfy changeable user demand, and later period client traffic changes, and it is even more impossible to flexibly adapt to
User demand changes introduction method.
Summary of the invention
The object of the present invention is to provide a kind of data lead-in methods for office management system, and provide and will be described later
These purposes and other advantages.
It is a further object to provide a kind of data lead-in method for office management system, splits and merge
Intelligence, the demand of flexible adaptation user can be passed to the data for needing to import according to their own needs, realize that user makes by oneself
Justice.
Technical solution of the present invention:
Data lead-in method for office management system comprising following steps:
It chooses data file to be imported and determines the target storage template of data to be imported；
Data to be imported are parsed to obtain data to be loaded according to the format of the data file to be imported；
The field in the data to be loaded is chosen as data source field according to business demand, and the target is stored
Field in template is added, delete operation obtains datum target field, and determines the data source field and the number
According to the mapping relations of aiming field；
Field in the data to be loaded is verified, the data to be loaded are imported into office pipe after verification is qualified
Target storing data is obtained in reason system.
Preferably, in the data lead-in method for office management system, the mapping relations include data
Source field and the respective value of datum target field, corresponding position and corresponding format.
Preferably, in the data lead-in method for office management system, the data file to be imported
Format is Excel, csv, word, json or xml.
Preferably, described to be verified as to number to be loaded in the data lead-in method for office management system
The type and length of field in are verified.
Preferably, in the data lead-in method for office management system, when verifying unqualified, school is recorded
Result and suggestion for revision are tested, is modified after the corresponding relationship again into verification.
Preferably, in the data lead-in method for office management system, according to the data text to be imported
The format of part carries out parsing to the data to be imported
When the format of data file to be imported is Excel, the first behavior field title in data to be imported is defaulted, the
The corresponding numerical value of two behaviors；
When the format of data file to be imported is json, traversal json string obtains corresponding key and value to obtain
Corresponding value.
Preferably, in the data lead-in method for office management system, according to the data text to be imported
The format selection of part is realized that class is parsed to obtain the data to be loaded to the data to be imported and is stored in Java container.
The invention has the following advantages:
Traditional lead-in mode is excessively single, multiple format can not be supported to import, data lead-in mode provided by the invention
Compatible a plurality of types of lead-in modes；
Traditional lead-in mode technology correspond to platform when realizing single, cannot achieve multiple platform data free switchings,
Invention realizes field auto-initiation when realizing, can satisfy the data free switching between different platform, without considering
The suitability of field can need to carry out field adjustment according to business, and it is more convenient efficiently to realize cross-platform transfer data；
Traditional lead-in mode can be slow in big data quantity, and the present invention can be imported with Real-time Feedback as a result, and will lead
The result entered is recorded in real time in log list, and user, which can download, checks the reason of data can not import, and facilitates arrangement data
It is imported with the later period, close to project demands.
Further advantage, target and feature of the invention will be partially reflected by the following instructions, and part will also be by this
The research and practice of invention and be understood by the person skilled in the art.
Detailed description of the invention
Fig. 1 is the workflow provided by the present invention for one embodiment of the data lead-in method of office management system
Figure；
Fig. 2 is the data importing provided by the present invention for one embodiment of the data lead-in method of office management system
Interface；
Fig. 3 is to make benefit film showing by oneself provided by the present invention for one embodiment of the data lead-in method of office management system
Penetrate field interface；
Fig. 4 leads for the customized of one embodiment of the data lead-in method provided by the present invention for office management system
Enter regular interface；
Fig. 5 is the importing process provided by the present invention for one embodiment of the data lead-in method of office management system
And result interface.
Specific embodiment
Present invention will be described in further detail below with reference to the accompanying drawings, to enable those skilled in the art referring to specification text
Word can be implemented accordingly.
It should be appreciated that such as " having ", "comprising" and " comprising " term used herein do not allot one or more
The presence or addition of a other elements or combinations thereof.
Data leading-in technique, which implements, mainly faces three problems: first is that lead-in mode is uncertain, traditional importing
Scheme is imported using single type, such as using Excel mode, and CSV mode imports, and word mode imports, with
Social development progress, technical level are constantly reformed, this single lead-in mode be increasingly difficult to be to meet public demand
Solution this problem, we specially pass through market and customer surveys, summarize user demand, devise compatible all mainstreams and lead
The scheme for entering mode has newly increased the importing of json format, and self defined interface realizes that class mode imports, and such user can be according to certainly
Oneself demand is passed to the data to be imported；Second is that guiding structure is single, traditional lead-in mode imports word in data and object library
Duan Wufa matching, in order to solve this problem, will often write the field name and type extremely imported, and require in the database
User imports data according to dead agreement has been write, and for the user not known to project, this mode is just shown very
Not intelligence, gold and lead-in mode will avoid this set pattern sanctified by usage, all importing fields, user can make by oneself
Justice, the data met the requirements can specify corresponding relationship to import in database, and correspond to the data of title, I
Can reduce the probability of error so that on auto-associating, such user can more save worry, it is more intelligent convenient；Third is that verification side
Formula does not correspond to, and traditional verification mode presence cannot be verified deeply, it is difficult to cope with user and verify the changeable situation of rule, for requiring
The regular demand of field conversion, does not know where to begin even more, when our gold import exploitation with data, just considers the above demand, special
The setting of column relationship map is increased, source column rule setting is imported, imports storage rule setting, imports notice setting come more than solving
Problem is arranged by column relationship map, and user can specify the corresponding relationship of field in the column and database oneself to be imported, and looks for
To you the other half is belonged to, by importing source column rule, user can solve the fields such as male, female and be stored as 0,1 in the database
The problem of Deng identifying, by importing storage rule setting, the verification rule of field is can be set in user, and certain field length cannot
Greater than how many, certain field must be character type, and certain field must be cell-phone number etc., and the design of these closeness to life is
Be not it is very tall and big upper, by importing notice setting, user can understand in time data and meet situation, meet according further to data
Situation does the processing of next step, can hang data up when being unsatisfactory for, import again after modification, these functions are all within
In the importing notification rule that you are arranged, in importing process, you can also see importing state in real time, import successfully how many
Data, the data for importing failure can all be recorded in error logging document, can download and check, without having to worry about can lose important letter
Breath.
Problem to be solved of the present invention has:
First is that the diversified problem of lead-in mode, Major Difficulties are how to realize dynamic acquisition data, how to be compatible with more
Kind mode imports；
Second is that needing to solve the problems, such as that importing process data structure is diversified.Major Difficulties are corresponding plurality of data structures
When Traversal Problem and data are inserted into the problem of corresponding field；
Third is that needing to solve verification and feedback in real time, many kinds of variable problem is verified.How real Major Difficulties are
When the Suresh Kumar and big data for now verifying rule import the problem of Real-time Feedback.
As shown in Figure 1, the present invention provides a kind of data lead-in method for office management system comprising following step
It is rapid:
It chooses data file to be imported and determines the target storage template of data to be imported；
Data to be imported are parsed to obtain data to be loaded according to the format of the data file to be imported；
The field in the data to be loaded is chosen as data source field according to business demand, and the target is stored
Field in template is added, delete operation obtains datum target field, and determines the data source field and the number
According to the mapping relations of aiming field；
Field in the data to be loaded is verified, the data to be loaded are imported into office pipe after verification is qualified
Target storing data is obtained in reason system.
It is described in one embodiment of the data lead-in method for office management system provided by the invention
Mapping relations include data source field and the respective value of datum target field, corresponding position and corresponding format.
It is described in one embodiment of the data lead-in method for office management system provided by the invention
The format of data file to be imported is Excel, csv, word, json or xml.
It is described in one embodiment of the data lead-in method for office management system provided by the invention
It is verified as verifying the type and length of the field in data to be loaded.
In one embodiment of the data lead-in method for office management system provided by the invention,
When verifying unqualified, check results and suggestion for revision are recorded, is modified after the corresponding relationship again into verification.?
In one embodiment of the data lead-in method for office management system provided by the invention,
Carrying out parsing to the data to be imported according to the format of the data file to be imported includes:
When the format of data file to be imported is Excel, the first behavior field title in data to be imported is defaulted, the
The corresponding numerical value of two behaviors；
When the format of data file to be imported is json, traversal json string obtains corresponding key and value to obtain
Corresponding value.
In one embodiment of the data lead-in method for office management system provided by the invention, according to
The format selection of the data file to be imported realizes that class parses the data to be imported to obtain the data to be loaded
It is stored in Java container.User uses data import feature, will be needed to arrange a data, the data first according to business
Comprising the key message in user's business function realized, user by the information preservation of arrangement Excel, csv, word,
In the files such as json, xml or in customized realization interface, data file path is then selected, importing is then executed and prepared
Journey, server end get data according to the strategy that user file selection imports, are put into Java container.
After the parsing of user's initialization data, it would be desirable to which the corresponding Database field of source data once, Yong Huke are set
It is arranged with being needed according to business, after being provided with, we will also see whether the storage of some data into data according to business
Needing corresponding conversion is the value needed in database, such as male, female may be to be identified as 0,1 in the database.In addition multiple row can
Becoming a column, such as commodity data and unit to import fusion mapping, we wish to be shown as a column in new database, this
We can be by the corresponding same new column of two column when a, otherwise we also may be implemented a column being split as multiple row.
Data importing be equally applicable be expert at turn column, column are changed one's profession etc. above modes.
Rule can be verified after the completion of user's mapping, when being easily introduced into, us is helped to find incongruent data, such as
It whether is mailbox format, cell-phone number verifying etc., finally, we also need to be arranged notification rule, how is the data of mistake
Processing etc., after the completion of operation, importing that we can perform the next step.
After data check is completed, we start to import data, we are provided with different storages according to business at this time
Journey is called for user, the different storing process of different calling services, executes data into traffic table, user can also be according to need
It wants oneself to branch out.
User logs on in gold and office system, enters data import feature main interface.As shown in Fig. 2, user can be with
According to demand, different data lead-in modes, and corresponding different data template are selected.File format can be csv/ herein
Xls/xlsx etc. can also realize that data object oneself can be defined according to customer service, very clever with user's self defined interface class
It is living, and user can also directly download corresponding template for the first time in use, if being unfamiliar with system, come according to template
Do data.
As shown in Figure 3 and Figure 4, user executes in data importing process, can be with customized different rule.User can be real
Existing customized map field imports data and carries out specially treated, imports rule setting, imports the utility functions such as notice setting.
During user imports, process and result that Real-time Feedback imports.As shown in figure 5, user can basis
Import as a result, the processing method performed the next step.It can choose to incorrect importing data, modify, then again
It imports.
Traditional lead-in mode is excessively single, multiple format can not be supported to import, data lead-in mode provided by the invention
Compatible a plurality of types of lead-in modes；
Traditional lead-in mode technology correspond to platform when realizing single, cannot achieve multiple platform data free switchings,
Invention realizes field auto-initiation when realizing, can satisfy the data free switching between different platform, without considering
The suitability of field can need to carry out field adjustment according to business, and it is more convenient efficiently to realize cross-platform transfer data；
Traditional lead-in mode can be slow in big data quantity, and the present invention can be imported with Real-time Feedback as a result, and will lead
The result entered is recorded in real time in log list, and user, which can download, checks the reason of data can not import, and facilitates arrangement data
It is imported with the later period, close to project demands.
By data import feature, we can convert specific function for some data quickly, eliminate many artificial
The time cost of typing, substantially increases accuracy rate, such as using original mode, 10,000 departments of user's typing or
The data of user need two days time, as soon as only needing key operation now, can import hundreds of thousands data, a few minutes can import
It completes, greatly improves work efficiency, save time cost, and we in manual entry, the probability that mistake occurs is non-
Chang great can effectively extract wrong data using the mode of importing, and the reason that points out faults, and facilitate user according to mistake
It modifies.In short, we can dispose a system quickly by this function, basic data is integrated, reality is greatly optimized
The progress applied.The technology has widely applied to numerous functions such as division management, user management, articles management, conference management
In practice.
Although the embodiments of the present invention have been disclosed as above, but its is not only in the description and the implementation listed
With it can be fully applied to various fields suitable for the present invention, for those skilled in the art, can be easily
Realize other modification, therefore without departing from the general concept defined in the claims and the equivalent scope, the present invention is simultaneously unlimited
In specific details and legend shown and described herein.
Claims (7)
1. being used for the data lead-in method of office management system, which comprises the following steps:
It chooses data file to be imported and determines the target storage template of data to be imported；
Data to be imported are parsed to obtain data to be loaded according to the format of the data file to be imported；
The field in the data to be loaded is chosen as data source field according to business demand, and template is stored to the target
In field be added, delete operation obtains datum target field, and determine the data source field and the data mesh
The mapping relations of marking-up section；
Field in the data to be loaded is verified, the data to be loaded are imported into office administration system after verification is qualified
Target storing data is obtained in system.
2. being used for the data lead-in method of office management system as described in claim 1, which is characterized in that the mapping relations
Including data source field and the respective value of datum target field, corresponding position and corresponding format.
3. being used for the data lead-in method of office management system as described in claim 1, which is characterized in that the number to be imported
Format according to file is Excel, csv, word, json or xml.
4. being used for the data lead-in method of office management system as described in claim 1, which is characterized in that described to be verified as pair
The type and length of field in data to be loaded are verified.
5. being used for the data lead-in method of office management system as claimed in claim 4, which is characterized in that unqualified when verifying
When, check results and suggestion for revision are recorded, is modified after the corresponding relationship again into verification.
6. being used for the data lead-in method of office management system as described in claim 1, which is characterized in that according to described wait lead
The format for entering data file carries out parsing to the data to be imported and includes:
When the format of data file to be imported is Excel, the first behavior field title in data to be imported, the second row are defaulted
For corresponding numerical value；
When the format of data file to be imported is json, traversal json string obtains corresponding key and value to obtain correspondence
Value.
7. being used for the data lead-in method of office management system as claimed in claim 6, which is characterized in that according to described wait lead
The format selection for entering data file is realized that class is parsed to obtain the data to be loaded to the data to be imported and is stored in
In Java container.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910256859.1A CN109992585A (en) | 2019-04-01 | 2019-04-01 | Data lead-in method for office management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910256859.1A CN109992585A (en) | 2019-04-01 | 2019-04-01 | Data lead-in method for office management system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109992585A true CN109992585A (en) | 2019-07-09 |
Family
ID=67131376
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910256859.1A Pending CN109992585A (en) | 2019-04-01 | 2019-04-01 | Data lead-in method for office management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109992585A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110728121A (en) * | 2019-09-17 | 2020-01-24 | 杭州安恒信息技术股份有限公司 | Data import system and method for realizing zero development based on existing interface |
| CN111104390A (en) * | 2019-11-08 | 2020-05-05 | 珠海金山网络游戏科技有限公司 | Method and system for merging and checking multiple CSV files |
| TWI767198B (en) * | 2020-03-17 | 2022-06-11 | 昕力資訊股份有限公司 | Computer program product and apparatus for controlling nodes with heterogeneous platforms |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102609483A (en) * | 2012-01-19 | 2012-07-25 | 北京神州数码思特奇信息技术股份有限公司 | General Excel import method based on configuration |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN104361139A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Data importing device and method |
| CN104536998A (en) * | 2014-12-15 | 2015-04-22 | 浪潮通用软件有限公司 | Data import method and device |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
| CN108595597A (en) * | 2018-04-19 | 2018-09-28 | 平安科技（深圳）有限公司 | Data lead-in method, device, computer equipment and storage medium |
-
2019
- 2019-04-01 CN CN201910256859.1A patent/CN109992585A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102609483A (en) * | 2012-01-19 | 2012-07-25 | 北京神州数码思特奇信息技术股份有限公司 | General Excel import method based on configuration |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN104361139A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Data importing device and method |
| CN104536998A (en) * | 2014-12-15 | 2015-04-22 | 浪潮通用软件有限公司 | Data import method and device |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
| CN108595597A (en) * | 2018-04-19 | 2018-09-28 | 平安科技（深圳）有限公司 | Data lead-in method, device, computer equipment and storage medium |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110728121A (en) * | 2019-09-17 | 2020-01-24 | 杭州安恒信息技术股份有限公司 | Data import system and method for realizing zero development based on existing interface |
| CN110728121B (en) * | 2019-09-17 | 2023-08-01 | 杭州安恒信息技术股份有限公司 | Data importing system and method for realizing zero development based on existing interface |
| CN111104390A (en) * | 2019-11-08 | 2020-05-05 | 珠海金山网络游戏科技有限公司 | Method and system for merging and checking multiple CSV files |
| TWI767198B (en) * | 2020-03-17 | 2022-06-11 | 昕力資訊股份有限公司 | Computer program product and apparatus for controlling nodes with heterogeneous platforms |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107370786B (en) | General information management system based on micro-service architecture | |
| Karnitis et al. | Migration of relational database to document-oriented database: structure denormalization and data transformation | |
| US8799251B2 (en) | Document templates for schema-based data transfer into and out of a data-based application | |
| US8918447B2 (en) | Methods, apparatus, systems and computer readable mediums for use in sharing information between entities | |
| US9582594B2 (en) | Method and system for centralized issue tracking | |
| US8666960B2 (en) | Schema-based data transfer between a data-based application and a document application | |
| CN105989150B (en) | A kind of data query method and device based on big data environment | |
| US9384182B2 (en) | Systems, methods and machine readable mediums for defining and executing new commands in a spreadsheet software application | |
| US20100217737A1 (en) | Method and system for business rules management | |
| US10089374B2 (en) | Meta model driven data base replication and synchronization | |
| CN109992585A (en) | Data lead-in method for office management system | |
| CA2802996A1 (en) | System and method for a computer based forms language | |
| EP1810131A2 (en) | Services oriented architecture for data integration services | |
| CN104461531B (en) | A kind of implementation method of reporting system SQL | |
| CN112463149B (en) | Software-defined satellite-oriented reusable code library construction method and device | |
| US20190310840A1 (en) | Efficient information storage and retrieval using subgraphs | |
| CN110941629B (en) | Metadata processing method, apparatus, device and computer readable storage medium | |
| CN106557307A (en) | The processing method and processing system of business datum | |
| CN108536718A (en) | A kind of method and system for the IT application in management realized based on input and output semantization | |
| CN114338855A (en) | Method for realizing parsing and generating HL7, FHIR standard and custom XML message | |
| CN107766519B (en) | Method for visually configuring data structure | |
| CN113536737A (en) | Material code generation method and device and electronic equipment | |
| CN110544092B (en) | Dynamic newly-added multi-type database data operation chaining method for block chain | |
| Shan et al. | Towards integrated service adaptation a new approach combining message and control flow adaptation | |
| US20060190476A1 (en) | Database storage system and associated method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190709 |