CN108959205A - A kind of method of ERP system export data fast transferring - Google Patents
A kind of method of ERP system export data fast transferring Download PDFInfo
- Publication number
- CN108959205A CN108959205A CN201810674236.1A CN201810674236A CN108959205A CN 108959205 A CN108959205 A CN 108959205A CN 201810674236 A CN201810674236 A CN 201810674236A CN 108959205 A CN108959205 A CN 108959205A
- Authority
- CN
- China
- Prior art keywords
- data
- source
- name
- migration
- lookup table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
- G06F40/157—Transformation using dictionaries or tables
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of method of ERP system export data fast transferring, including step A, step B, step C, step D herein；In step A, Data Migration parameter lookup table is edited, source list name, the source column name, target table name, target column name information of source file, file destination and required migration are described in a manner of table；Migration rules are stripped out in this way allow operator need to only understand data wherefrom copy where；In step B, program is extracted key from parameter list and is believed, in step C, traverses to the table of source file, and describes to carry out corresponding data update according to parameter lookup table；It in step D, is finished to all data processings, saves update as a result, closing data connection, exit the program, is i.e. completion entire operation process.It realizes through the above steps, it is intended to overcome data structure existing in the prior art above-mentioned to differ greatly, not have under the available situation of ready-made scheme, it might even be possible to which further expanding becomes the other data transference packages imported based on EXCEL.
Description
Technical field
The invention belongs to the data processing techniques in computer field, are specifically that a kind of ERP system export data are fast
The method of speed migration.
Background technique
User usually needs to tie up by Enterprise Resources Plan (Enterprise Resource Planning, ERP) system
A large amount of list is protected, when the information that business itself needs to safeguard is more, cured maintenance list will occur very on interface
The information for more needing to safeguard, is covered with the control for needing input data information on interface, and user needs to be sentenced according to the role of oneself
Disconnected, those are that he fills in, he does not have to fill in for those.If things go on like this, working efficiency will substantially reduce.There is many in leaf at present
The relevant application technology of ERP system.
It is found by retrieval, a kind of ERP system median surface layout of the disclosure of the invention of patent No. CN200910110678.4
Amending method, device and ERP system, the method includes the following steps: receiving the field identification for needing display field；According to member
Data information, control information and the field identification received generate corresponding control and are loaded into the corresponding position at interface.At this
In inventive embodiments, according to metadata information, control information and the field identification received, generates corresponding control and be loaded into
The corresponding position at interface realizes a kind of ERP system median surface layout modification method, does not need to redeploy ERP system, realize
Simply, and interface layout can be dynamically modified at runtime.
The disclosure of the invention of patent No. CN201410345716.5 is a kind of to upset based on timeslice, incremental analysis and at random skill
System data migration side fast intelligent Enterprise Resources Plan (Enterprise Resource Planning abbreviation ERP) of art
Method.Strategy of the centralized management system according to customization in this method, order transmission system progress data pick-up；Transmission system will take out
The data taken out are written in specific table, and tables of data is compressed；Centralized management system again transmits compressed tables of data
Into reception system, while reception system being ordered to decompress；Reception system is according to the order of centralized management system, by data decompression,
And write data into corresponding table according to strategy, complete Data Migration；Last centralized management system command sends system-kill
The tables of data generated before, and Free up Memory.
Patent No. CN201810107772.3 is including as follows the invention discloses data processing method between a kind of ERP system
Step: the communication request from client is received, client is summarized as by frequent customer or potential customers according to the type of the client；Work as visitor
When family is frequent customer, connection is established with client, obtains the purchase data of the client of storage, and corresponding according to purchase data-pushing
Product link；When client is potential customers, the account information of client input and storage are received, is established later with the client
Connection receives the purchase request of the client, is requested to generate purchase order according to purchase, purchase order is handled the purchase for the client
Buy data.
But the analysis found that, the Data Migration between existing ERP system new-old system is typically all to be provided by producer
Built-in method, for being counted between the version even different ERP producer of the too big version of difference in version or different series
According to migration, solution that on the market substantially just can be not general.
Summary of the invention
Therefore, in order to solve above-mentioned deficiency, the present invention provides a kind of side of ERP system export data fast transferring herein
Method；The present invention is directed to overcome data structure existing in the prior art above-mentioned to differ greatly, there are not the available feelings of ready-made scheme
Under border, it might even be possible to which further expanding becomes the other data transference packages imported based on EXCEL.
The invention is realized in this way a kind of method for constructing ERP system export data fast transferring, it is characterised in that:
The data processing method includes the following steps；Step A, step B, step C, step D；
In step A, Data Migration parameter lookup table is edited, source file, file destination are described in a manner of table and required is moved
The source list name of shifting, source column name, target table name, target column name information；Migration rules are stripped out in this way allow operator only
Need to understand data wherefrom copy where；
In step B, program extracts crucial letter from parameter list, this step again can B1, step B2 two be step by step step by step；
Wherein, step B1 analyzes source file and file destination information, carries out data connection creation；
Step B2 analyzes corresponding tables of data in source file and file destination, establishes Hash table respectively, storage table name, description,
Object data set is used for subsequent processing；
In step C, the table of source file is traversed, and describes to carry out corresponding data update according to parameter lookup table, this step
Rapid C1, step C2, step C3, the small step of step C4 tetra- step by step again；
Wherein, step C1 reads data line in source data；
Step C2 carries out data to target table (may be one-to-many) and increases newly, and C3 is waited to continue to operate；
Step C3 finds corresponding Hash table according to parameter lookup table, therefrom extracts object data set, updates corresponding field value；
Step C4 parameter lookup table has traversed, and the corresponding all update tables of data line are all to have handled, and carries out next line source
Data processing；
It in step D, is finished to all data processings, saves and update as a result, closing data connection, exits the program, is i.e. completion is entire
Operating process.
The present invention has the advantage that the present invention provides a kind of ERP system export data fast transferring by improving herein
Method, it is intended to overcome data structure existing in the prior art above-mentioned to differ greatly, do not there is the available situation of ready-made scheme
Under, it might even be possible to further expanding becomes the other data transference packages imported based on EXCEL.Data Migration only needs to handle official business in this way
Personnel can be handled, and be intervened without professional person, and programming automation processing data efficiency is as data volume deduction is in geometry times
Increase, a large amount of human costs can be saved for company.
Detailed description of the invention
Fig. 1 is the implementation process of ERP system export data quick migration method of the present invention.
Specific embodiment
Below in conjunction with attached drawing 1, the present invention is described in detail, and technical solution in the embodiment of the present invention carries out clear
Chu is fully described by, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.
Based on the embodiments of the present invention, obtained by those of ordinary skill in the art without making creative efforts all
Other embodiments shall fall within the protection scope of the present invention.
The present invention provides a kind of method that ERP system exports data fast transferring by improving herein, it is characterised in that: institute
Data processing method is stated to include the following steps；Step A, step B, step C, step D；
In step A, Data Migration parameter lookup table is edited, source file, file destination are described in a manner of table and required is moved
The information such as the source list name of shifting, source column name, target table name, target column name；Migration rules are stripped out in this way and allow operator
Only need to understand data wherefrom copy where；
In step B, program extracts crucial letter from parameter list, this step again can B1, step B2 two be step by step step by step；
Wherein, step B1 analyzes source file and file destination information, carries out data connection creation；
Step B2 analyzes corresponding tables of data in source file and file destination, establishes Hash table respectively, storage table name, description,
Object data set is used for subsequent processing；
In step C, the table of source file is traversed, and describes to carry out corresponding data update according to parameter lookup table, this step
Rapid C1, step C2, step C3, the small step of step C4 tetra- step by step again；
Wherein, step C1 reads data line in source data；
Step C2 carries out data to target table (may be one-to-many) and increases newly, and C3 is waited to continue to operate；
Step C3 finds corresponding Hash table according to parameter lookup table, therefrom extracts object data set, updates corresponding field value；
Step C4 parameter lookup table has traversed, and the corresponding all update tables of data line are all to have handled, and carries out next line source
Data processing；
It in step D, is finished to all data processings, saves and update as a result, closing data connection, exits the program, is i.e. completion is entire
Operating process.
The present invention provides a kind of method of ERP system export data fast transferring herein, realizes through the above steps, it is intended to
Overcome data structure existing in the prior art above-mentioned to differ greatly, do not have under the available situation of ready-made scheme, it might even be possible to
Further expanding becomes the other data transference packages imported based on EXCEL.Data Migration only needs office worker that can locate in this way
Reason is intervened without professional person, and programming automation processing data efficiency is deducted a percentage with data volume and increased again in geometry, can be public affairs
Department saves a large amount of human costs.In addition, this method is applicable not only to ERP Data Migration, if parameter lookup table is described it is clear,
All similar data migration tasks similar can all be handled.
The foregoing description of the disclosed embodiments enables those skilled in the art to implement or use the present invention.
Various modifications to these embodiments will be readily apparent to those skilled in the art, as defined herein
General Principle can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore, of the invention
It is not intended to be limited to the embodiments shown herein, and is to fit to and the principles and novel features disclosed herein phase one
The widest scope of cause.
Claims (1)
1. a kind of method of ERP system export data fast transferring, it is characterised in that: the data processing method include step A,
Step B, step C, step D；
In step A, Data Migration parameter lookup table is edited, source file, file destination are described in a manner of table and required is moved
The source list name of shifting, source column name, target table name, target column name information；Migration rules are stripped out in this way allow operator only
Need to understand data wherefrom copy where；
In step B, program extracts crucial letter from parameter list, this step again can B1, step B2 two be step by step step by step；
Wherein, step B1 analyzes source file and file destination information, carries out data connection creation；
Step B2 analyzes corresponding tables of data in source file and file destination, establishes Hash table respectively, storage table name, description,
Object data set is used for subsequent processing；
In step C, the table of source file is traversed, and describes to carry out corresponding data update according to parameter lookup table, this step
Rapid C1, step C2, step C3, the small step of step C4 tetra- step by step again；
Wherein, step C1 reads data line in source data；
Step C2 carries out data to target table (may be one-to-many) and increases newly, and C3 is waited to continue to operate；
Step C3 finds corresponding Hash table according to parameter lookup table, therefrom extracts object data set, updates corresponding field value；
Step C4 parameter lookup table has traversed, and the corresponding all update tables of data line are all to have handled, and carries out next line source
Data processing；
It in step D, is finished to all data processings, saves and update as a result, closing data connection, exits the program, is i.e. completion is entire
Operating process.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810674236.1A CN108959205A (en) | 2018-06-27 | 2018-06-27 | A kind of method of ERP system export data fast transferring |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810674236.1A CN108959205A (en) | 2018-06-27 | 2018-06-27 | A kind of method of ERP system export data fast transferring |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108959205A true CN108959205A (en) | 2018-12-07 |
Family
ID=64487197
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810674236.1A Pending CN108959205A (en) | 2018-06-27 | 2018-06-27 | A kind of method of ERP system export data fast transferring |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108959205A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111898351A (en) * | 2020-08-03 | 2020-11-06 | 上海嗨酷强供应链信息技术有限公司 | Automatic Excel data importing method and device based on Aviator, terminal equipment and storage medium |
| CN113409015A (en) * | 2021-06-21 | 2021-09-17 | 浙江省能源集团有限公司 | ERP system and use method of ERP system in double-activity deployment of double data centers |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103631907A (en) * | 2013-11-26 | 2014-03-12 | 中国科学院信息工程研究所 | Method and system for migrating relational data to HBbase |
| CN104408150A (en) * | 2014-12-03 | 2015-03-11 | 天津南大通用数据技术股份有限公司 | Data import/ export method and device adapted to a plurality of data formats of databases |
| CN104915362A (en) * | 2014-07-19 | 2015-09-16 | 国家电网公司 | Fast intelligent ERP system data migration scheme based on time slices, increment analysis and random disorganizing technology |
| CN106528811A (en) * | 2016-11-15 | 2017-03-22 | 国网浙江武义县供电公司 | Integrated data migration method for PMS |
| CN106776876A (en) * | 2016-11-29 | 2017-05-31 | 用友网络科技股份有限公司 | Data migration method and data mover system |
| CN107832465A (en) * | 2017-11-28 | 2018-03-23 | 清远市云商科技有限公司 | A kind of method for realizing data fast transferring |
-
2018
- 2018-06-27 CN CN201810674236.1A patent/CN108959205A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103631907A (en) * | 2013-11-26 | 2014-03-12 | 中国科学院信息工程研究所 | Method and system for migrating relational data to HBbase |
| CN104915362A (en) * | 2014-07-19 | 2015-09-16 | 国家电网公司 | Fast intelligent ERP system data migration scheme based on time slices, increment analysis and random disorganizing technology |
| CN104408150A (en) * | 2014-12-03 | 2015-03-11 | 天津南大通用数据技术股份有限公司 | Data import/ export method and device adapted to a plurality of data formats of databases |
| CN106528811A (en) * | 2016-11-15 | 2017-03-22 | 国网浙江武义县供电公司 | Integrated data migration method for PMS |
| CN106776876A (en) * | 2016-11-29 | 2017-05-31 | 用友网络科技股份有限公司 | Data migration method and data mover system |
| CN107832465A (en) * | 2017-11-28 | 2018-03-23 | 清远市云商科技有限公司 | A kind of method for realizing data fast transferring |
Non-Patent Citations (2)
| Title |
|---|
| 刘冰: "基于异构ERP系统的数据迁移技术应用研究", 《中国优秀博硕士学位论文全文数据库(硕士)信息科技辑》 * |
| 刘畅: "基于大数据技术的铁路运输企业ERP的应用研究", 《中国优秀博硕士学位论文全文数据库(硕士) 工程科技Ⅱ辑》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111898351A (en) * | 2020-08-03 | 2020-11-06 | 上海嗨酷强供应链信息技术有限公司 | Automatic Excel data importing method and device based on Aviator, terminal equipment and storage medium |
| CN111898351B (en) * | 2020-08-03 | 2021-06-22 | 汇链通供应链科技(上海)有限公司 | Automatic Excel data importing method and device based on Aviator, terminal equipment and storage medium |
| CN113409015A (en) * | 2021-06-21 | 2021-09-17 | 浙江省能源集团有限公司 | ERP system and use method of ERP system in double-activity deployment of double data centers |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6073111A (en) | Container materialization/dematerialization for reduced dataload and improved data-coherency in workflow-management systems | |
| US11381565B2 (en) | Hierarchical permissions model for case management | |
| US9170999B2 (en) | Method, system, and program product for transferring document attributes | |
| EP1868087B1 (en) | System and method for configuration application programs | |
| US8478789B2 (en) | Adapter architecture for mobile data system | |
| CN104216912A (en) | Method and device for achieving non-intrusive service form workflow | |
| CN106354833A (en) | Platform for achieving data management and sharing exchange on basis of B/S framework | |
| KR101944973B1 (en) | Method and system for sharing user-defined Enterprise Resource Planning function and computing system performing the same | |
| CN102087594A (en) | Management method and device for extension point and plugins | |
| CN107704597A (en) | Relevant database to Hive ETL script creation methods | |
| CN104346371A (en) | Business integration system report driven by in-memory database | |
| CN112306645A (en) | Transaction processing method, device, equipment, program and medium of Etheng virtual machine | |
| CN110490459A (en) | A kind of protocol managerial approach and device | |
| CN108959205A (en) | A kind of method of ERP system export data fast transferring | |
| CN112286643B (en) | Transaction processing method, device, equipment and medium for Ether house virtual machine | |
| US20030050886A1 (en) | Method and apparatus for managing the versioning of business objects using a state machine | |
| CN115169891B (en) | Method for realizing workflow engine comprising multi-start-point multi-branch flow | |
| US20010049712A1 (en) | Archiving in workflow management systems | |
| KR20180072889A (en) | Method for generating user-defined Enterprise Resource Planning function and computing system performing the same | |
| US20200126013A1 (en) | Microcomponents for data integration and methods thereof | |
| CN102467504B (en) | Design method of relational database-based workflow engine system | |
| KR20210039536A (en) | System and method for architect-developer collaboration using configuration management | |
| EP0872805A2 (en) | Container materialization/dematerialization for reduced dataload and improved data-coherency in workflow-management systems | |
| CN109582330A (en) | Data model upgrade method, device, equipment and readable storage medium storing program for executing | |
| TWI245202B (en) | Method for obtaining and releasing database access resource in information system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181207 |
|
| RJ01 | Rejection of invention patent application after publication |