CN110489398A - A kind of method and system of difference financial system batch financial data migration - Google Patents

A kind of method and system of difference financial system batch financial data migration Download PDF

Info

Publication number
CN110489398A
CN110489398A CN201910747390.1A CN201910747390A CN110489398A CN 110489398 A CN110489398 A CN 110489398A CN 201910747390 A CN201910747390 A CN 201910747390A CN 110489398 A CN110489398 A CN 110489398A
Authority
CN
China
Prior art keywords
data
migrated
financial system
financial
downloading
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.)
Granted
Application number
CN201910747390.1A
Other languages
Chinese (zh)
Other versions
CN110489398B (en
Inventor
李亚东
刘禄
窦友斌
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Nanjing Cloud Account Network Technology Co Ltd
Original Assignee
Nanjing Cloud Account Network Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Nanjing Cloud Account Network Technology Co Ltd filed Critical Nanjing Cloud Account Network Technology Co Ltd
Priority to CN201910747390.1A priority Critical patent/CN110489398B/en
Publication of CN110489398A publication Critical patent/CN110489398A/en
Application granted granted Critical
Publication of CN110489398B publication Critical patent/CN110489398B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/214Database migration support
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/125Finance or payroll
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

The present invention provides a kind of method and system of different financial system batch financial data migrations, can download the data in different financial systems to be migrated automatically, and carry out Auto-matching and import upload;Reduce the system for the continuous login different manufacturers of account corporate accounting and completes the inefficient work of repetition that data downloading is uploaded to new system again;Improve the efficiency for account corporate accounting;It can be realized the fast transferring of the financial data of the system of different manufacturers.

Description

A kind of method and system of difference financial system batch financial data migration
Technical field
The present invention relates to the relevant field of computer technology of financial management more particularly to a kind of different financial system batch wealth The method and system of business Data Migration.
Background technique
Due to there is the relationship of competition between different financial software companies, the general manually mode that only provides downloads finance Data.If it is desired to by the set of books of creation and balance sheet and history voucher, report out of this finance software company, family financial system The data such as table move on new financial system (if being different manufacturer), data are only re-typed in new system.This Sample, accounting are repeated, than relatively time-consuming uninteresting operation.
Summary of the invention
The purpose of the present invention is to solve disadvantages existing in the prior art, and propose.
To achieve the above object, present invention employs following technical solutions:
A kind of method of difference financial system batch financial data migration, comprising the following steps:
S1: using data-interface, gets current company information, and the account phase for needing to download;
S2: by the account of the financial system to be migrated of offer, financial system to be migrated is logged in, selects financial system corresponding Producer to be migrated;
S3: request is directly transmitted to financial system to be migrated, downloads the data of producer to be migrated;
S4: the data that S3 step is downloaded carry out assembled and compression;
S5: datamation upload is carried out to the data crossed through S4 step process by uploading interface;
S6: migration main program decompress and match with the Auto-matching template in system automatically to the data received;
S7: being put in storage the successful data of Auto-matching template matching, and by data back to new financial system.
Further, the method for the different financial system batch financial data migrations of the present invention, further includes implementing different finance The financial system of the method for system batch financial data migration, the financial system include migrating main program, obtain company information, need Download the data-interface of account phase;The main program of migrating includes: the log-in module for logging in financial system to be migrated, to be migrated Financial system directly transmit request, download the module of the data of producer to be migrated automatically, by the data of downloading carry out it is assembled and The module of compression uploads assembled and compressed data interface, the data received decompress and automatically with it is automatic in system Matching template carries out matched module, is put in storage to the successful data of Auto-matching template matching, and by data back to wealth The module of business system.
S1: opening migration main program, log in online new financial system, the interface provided by new financial system, Get current company information, and the account phase for needing to download;
S2: by the account of the financial system to be migrated of offer, financial system to be migrated is logged in, selects producer to be migrated;
S3: request is directly transmitted to financial system to be migrated, downloads the data of producer to be migrated automatically;
S4: the data that S3 step is downloaded carry out assembled and compression;
S5: the upload interface provided by new financial system carries out in datamation the data crossed through S4 step process It passes;
S6: migration main program decompress and match with the Auto-matching template in system automatically to the data received;
S7: being put in storage the successful data of Auto-matching template matching, and by data back to new financial system.
It preferably, further include the business data that verification judgement obtains after getting current company information in S1 step Whether normal step.
Preferably, the request in S3 step includes the mode of Post request and the mode of Hook-Ajax request.
Preferably, different request methods is selected for different producers to be migrated, the preferential side using Post request Formula obtains downloading data, if can not obtain downloading data by POST request, is obtained down by the way of Hook-Ajax request Carry data.
Preferably, the data of downloading are uniformly compressed into the compressed file named with enterprise name in S4 step, and compressed File is created by " date " in file, and places the list data of downloading.
The present invention also provides a kind of systems of different financial system batch financial data migrations, and the system comprises data to obtain Take unit, data download unit, data processing unit and data receipt unit;The data capture unit is new to obtain Essential information in financial system;The data download unit is to download the data to be migrated in financial system to be migrated; The data processing unit is arranged to carry out assembled and compression to the data of downloading, and treated data and will be uploaded to institute State data receipt unit;The data receipt unit to the data receiver that uploads the data processing unit and in system The matching template prestored is matched, and by matched successful data loading, finally returns to new financial system.
Further, the data download module includes financial system login module to be migrated, producer's selection to be migrated Module, and downloading request sending module, the financial system login module to be migrated is to log in finance system to be migrated System, provides loading source for data download unit;Producer's selecting module to be migrated is moved to select to need to carry out financial data The producer to be migrated moved;The mode of mode and Hook-Ajax request comprising Post request in the downloading request sending module, To obtain downloading data.
Compared with prior art, the invention has the benefit that different financial systems to be migrated can be downloaded automatically Interior data, and carry out Auto-matching and import upload;The system reduced for the continuous login different manufacturers of account corporate accounting is complete It is uploaded to the inefficient work of repetition of new system again at data downloading;Improve the efficiency for account corporate accounting;It can be realized not With the fast transferring of the financial data of the system of producer.
Detailed description of the invention
Fig. 1 is a kind of flow chart of the method for different financial system batch financial data migrations of the invention.
Fig. 2 is a kind of work flow diagram of the method for different financial system batch financial data migrations of the invention.
Fig. 3 is a kind of structural block diagram of the system of different financial system batch financial data migrations of the invention.
Specific embodiment
To make to have further understanding to the purpose of the present invention, construction, feature and its function, hereby cooperate embodiment detailed It is described as follows.
Incorporated by reference to referring to FIG. 1, FIG. 2 and FIG. 3, Fig. 1 is a kind of different financial system batch financial data migrations of the invention Method flow chart;Fig. 2 is a kind of structural block diagram of the system of different financial system batch financial data migrations of the invention; Fig. 3 is a kind of structural block diagram of the system of different financial system batch financial data migrations of the invention.
As depicted in figs. 1 and 2, the side of a kind of different financial system batch financial data migrations of one embodiment of the invention Method, comprising the following steps:
S1: opening migration main program, log in online new financial system, and the interface provided by new financial system obtains To current enterprise's essential information, such as enterprise name, and the account phase for needing to download, facilitate downloading account issue evidence;Meanwhile it is logical Crossing migration main program also needs to choose data type balance sheet and voucher etc. to be migrated.
S2: by the login account and password of the financial system to be migrated of offer, logging in financial system to be migrated, selection Producer to be migrated;
S3: request is directly transmitted to financial system to be migrated, downloads the data of producer to be migrated automatically;For different wait move The financial system of shifting uses suitable technology, and the data of downloading data type need to download.By to B/S framework wait move The financial system of shifting sends Post request, gets downloading data (can obtain for POST).If by POST request without Method obtains data, then uses Hook-Ajax request data.
S4: the data that S3 step is downloaded carry out assembled and compression;To the data of downloading, uploaded according to new financial system Interface constraints specification, it is assembled to carry out data.Data assembly is i.e.: be in file with date creation file one by one, it is inner The Excel data of downloading are placed in face, such as: balance sheet .xls etc..File is entirely compressed into the zip named with enterprise name File.
S5: the upload interface provided by new financial system carries out datamation to the data crossed through S4 step process It is uploaded to migration main program.
S6: migration main program the data received decompress and automatically with the Auto-matching template progress in system Match.The data template for having imported different financial systems to be migrated in migration main program in advance, is suitable for various wealth on the market Business system carries out Auto-matching after uploading convenient for the data in financial system to be migrated.
S7: being put in storage the successful data of Auto-matching template matching, and by data back to new financial system.It is right Value in matching template is all loaded into new financial system, the Excel list data that solution presses out, and reads Excel Correspondence row column number value in Sheet table, the value in Corresponding matching template carry out canonical matching.If all ranks of matching template In value, the value in the Excel Sheet table that solution presses out can be matched, this Excel table is just according to predetermined Matching template, operated.
Preferably, in S1 step, after getting current company information, need to check judge obtain business data whether Normally.If data normally if continue next step step, if the abnormal feedback error information of data to migration main program.
Preferably, the request in S3 step includes the mode of Post request and the mode of Hook-Ajax request.Post request Mode there is no data volume limitation, can to server send mass data, it is high-efficient and reliable and stable;Hook-Ajax request Mode can only be sent to server and fetch required data.The preferential mode for selecting Post request, using POST request Mode, obtain data speed it is fast.
Preferably, different request methods is selected for different producers to be migrated, the preferential side using Post request Formula obtains downloading data, if can not obtain downloading data by POST request, is obtained down by the way of Hook-Ajax request Carry data.
Preferably, the data of downloading are uniformly compressed into the compressed file named with enterprise name in S4 step, and compressed File is created by " date " in file, and places the list data of downloading.
As shown in figure 3, the present invention also provides a kind of system of different financial system batch financial data migrations, the system Including data capture unit, data download unit, data processing unit and data receipt unit;The data capture unit is used To obtain the essential information in new financial system;The data download unit to download in financial system to be migrated to Migrating data;The data processing unit is arranged to carry out assembled and compression to the data of downloading, and will treated data And it is uploaded to the data receipt unit;The data receipt unit is to the data receiver that uploads the data processing unit And it is matched with the matching template prestored in system, and by matched successful data loading, finally return to new finance System.
This system by data capture unit with the interface that new financial system provides in use, connect, acquisition first The basic informations such as the title of enterprise, while the account phase being provided, facilitate downloading account issue evidence;Then it is asked by the transmission of data download unit It asks and downloads the data in financial system to be migrated;Then utilize data processing unit by the data of downloading according to new The interface constraints specification that financial system uploads is carried out data assembly, is uniformly compressed into the compressed file named with enterprise name, so Treated, data get on the upload interface provided afterwards by new financial system;Data reception module will receive Data decompression simultaneously carries out Auto-matching with the matching template of pre-stored in system, and by the data loading of successful match, finally will Data back after storage gives new financial system, and the data completed in financial system to be migrated are moved to the interior to new financial system It moves.
Further, the data download module includes financial system login module to be migrated, producer's selection to be migrated Module, and downloading request sending module, the financial system login module to be migrated is to log in finance system to be migrated System, provides loading source for data download unit;Producer's selecting module to be migrated is moved to select to need to carry out financial data The producer to be migrated moved;The mode of mode and Hook-Ajax request comprising Post request in the downloading request sending module, To obtain downloading data.
From the above mentioned, the method and system of a kind of different financial system batch datas migrations of the invention, can it is automatic under The data in different financial systems to be migrated are carried, and carries out Auto-matching and imports upload;Reduce for account corporate accounting The inefficient work of the repetition that the continuous system completion data downloading for logging in different manufacturers is uploaded to new system again;It improves for account public affairs The efficiency of chief accountant's meter;It can be realized the fast transferring of the financial data of the system of different manufacturers.
The present invention is described by above-mentioned related embodiment, however above-described embodiment is only to implement example of the invention. It must be noted that the embodiment disclosed is not limiting as the scope of the present invention.On the contrary, do not depart from spirit of the invention and It is changed and retouched made by range, belongs to scope of patent protection of the invention.

Claims (8)

1. a kind of method of difference financial system batch financial data migration, it is characterised in that: the following steps are included:
S1: using data-interface, gets current company information, and the account phase for needing to download;
S2: by the account of the financial system to be migrated of offer, financial system to be migrated is logged in, selects financial system corresponding Producer to be migrated;
S3: request is directly transmitted to financial system to be migrated, downloads the data of producer to be migrated;
S4: the data that S3 step is downloaded carry out assembled and compression;
S5: datamation upload is carried out to the data crossed through S4 step process by uploading interface;
S6: migration main program decompress and match with the Auto-matching template in system automatically to the data received;
S7: being put in storage the successful data of Auto-matching template matching, and by data back to new financial system.
2. the method for difference financial system batch financial data migration as described in claim 1, it is characterised in that: further include reality The financial system of the method for different financial system batch financial data migrations is applied, which includes migrating main program, is obtained Company information, the data-interface for needing to download the account phase;It is described migrate main program include: log in financial system to be migrated log in mould Block directly transmits request to financial system to be migrated, downloads the module of the data of producer to be migrated automatically, by the data of downloading Carry out assembled and compression module, upload assembled and compressed data interface, to the data received carry out decompression and automatically be Auto-matching template in system carries out matched module, is put in storage to the successful data of Auto-matching template matching, and will count According to the module for passing back to financial system;
S1: opening migration main program, log in online new financial system, and the interface provided by new financial system obtains To current company information, and the account phase for needing to download;
S2: by the account of the financial system to be migrated of offer, financial system to be migrated is logged in, selects producer to be migrated;
S3: request is directly transmitted to financial system to be migrated, downloads the data of producer to be migrated automatically;
S4: the data that S3 step is downloaded carry out assembled and compression;
S5: the upload interface provided by new financial system carries out in datamation the data crossed through S4 step process It passes;
S6: migration main program decompress and match with the Auto-matching template in system automatically to the data received;
S7: being put in storage the successful data of Auto-matching template matching, and by data back to new financial system.
3. the method for difference financial system batch financial data migration as described in claim 1, it is characterised in that: in S1 step In, after getting current company information, it is whether normal that the business data for judging to obtain need to be checked.
4. the method for difference financial system batch financial data migration as described in claim 1, it is characterised in that: in S3 step Request include Post request mode and Hook-Ajax request mode.
5. the method for difference financial system batch financial data migration as claimed in claim 4, it is characterised in that: for difference Producer to be migrated select different request methods, preferentially using Post request by the way of obtain downloading data, if passing through POST request can not obtain downloading data, then obtain downloading data by the way of Hook-Ajax request.
6. the method for difference financial system batch financial data migration as described in claim 1, it is characterised in that: in S4 step The data of downloading are uniformly compressed into the compressed file named with enterprise name, and is earned every day in compressed file by days and builds file Folder, and place the list data of downloading.
7. a kind of system of difference financial system batch financial data migration, it is characterised in that: the system comprises data acquisitions Unit, data download unit, data processing unit and data receipt unit;The data capture unit is to obtain new wealth Essential information in business system;The data download unit is to download the data to be migrated in financial system to be migrated;Institute It states data processing unit to arrange to carry out assembled and compression to the data of downloading, and treated data and will be uploaded to described Data receipt unit;The data receipt unit to the data receiver that uploads the data processing unit and with it is pre- in system The matching template deposited is matched, and by matched successful data loading, finally returns to new financial system.
8. the method for difference financial system batch financial data migration as claimed in claim 7, it is characterised in that: the data Download module includes financial system login module to be migrated, producer's selecting module to be migrated, and downloading request sending module, The financial system login module to be migrated provides downloading to log in financial system to be migrated for data download unit Source;To be migrated producer of the producer's selecting module to be migrated to select to need to carry out financial data migration;The downloading is asked The mode comprising Post request in sending module and the mode of Hook-Ajax request are asked, to obtain downloading data.
CN201910747390.1A 2019-08-14 2019-08-14 Method and system for transferring batch financial data of different financial systems Active CN110489398B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910747390.1A CN110489398B (en) 2019-08-14 2019-08-14 Method and system for transferring batch financial data of different financial systems

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910747390.1A CN110489398B (en) 2019-08-14 2019-08-14 Method and system for transferring batch financial data of different financial systems

Publications (2)

Publication Number Publication Date
CN110489398A true CN110489398A (en) 2019-11-22
CN110489398B CN110489398B (en) 2023-12-15

Family

ID=68549863

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910747390.1A Active CN110489398B (en) 2019-08-14 2019-08-14 Method and system for transferring batch financial data of different financial systems

Country Status (1)

Country Link
CN (1) CN110489398B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111240714A (en) * 2019-12-29 2020-06-05 南京云帐房网络科技有限公司 Financial data initialization method and system based on template intelligent learning

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7584131B1 (en) * 2002-07-31 2009-09-01 Ameriprise Financial, Inc. Method for migrating financial and indicative plan data between computerized record keeping systems without a blackout period
CN107832371A (en) * 2017-10-27 2018-03-23 安徽经邦软件技术有限公司 A kind of Excel intelligent Matchings import system and method based on financial statement

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7584131B1 (en) * 2002-07-31 2009-09-01 Ameriprise Financial, Inc. Method for migrating financial and indicative plan data between computerized record keeping systems without a blackout period
CN107832371A (en) * 2017-10-27 2018-03-23 安徽经邦软件技术有限公司 A kind of Excel intelligent Matchings import system and method based on financial statement

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
邹谊等: "基于IMS行政交换网的国家电网财务数据集中管理系统的设计与实现", 《新型工业化》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111240714A (en) * 2019-12-29 2020-06-05 南京云帐房网络科技有限公司 Financial data initialization method and system based on template intelligent learning
CN111240714B (en) * 2019-12-29 2024-01-05 云帐房网络科技有限公司 Financial data initialization method and system based on template intelligent learning

Also Published As

Publication number Publication date
CN110489398B (en) 2023-12-15

Similar Documents

Publication Publication Date Title
CN110851356B (en) Selenium-based Web application automatic test framework and construction method and system thereof
CN105359102B (en) Advanced customer support service-advanced support cloud portal
WO2020192301A1 (en) Device parameter configuration method, apparatus and system, terminal device and computer-readable storage medium
US8510718B2 (en) Platform verification portal
US9087041B2 (en) Enterprise test system platform and associated method for interoperable test data management, test development, test libraries and test workflow management and automation
EP3115902B1 (en) Framework for automated testing of mobile apps
CN110659202A (en) Client automatic testing method and device
CN102209118A (en) Distributed mass data gathering method
CN113325810B (en) Automatic data interaction method
CN111245671B (en) Automatic integrated test system for ground test of satellite laser communication terminal
CN110489398A (en) A kind of method and system of difference financial system batch financial data migration
CN111444109B (en) Mobile terminal UI automatic test method and system
CN111723138B (en) System and method for automatically acquiring data in artificial simulation mode
CN112241625A (en) Method and system for automatically generating contract document based on java language
CN113868219A (en) Method and device for migrating account set data, electronic equipment and computer storage medium
CN113934710B (en) Data acquisition method and device
CN112015715A (en) Industrial Internet data management service testing method and system
CN109525642B (en) LIMS system client data automatic reporting method under user mechanism
CN113163014A (en) Data transmission method, server and data transmission system
CN112053132A (en) Host changing method and device
CN112416805A (en) Test management cloud platform and method
CN105955718A (en) Software customization method and system
CN111522779B (en) Configuration processing method for multi-system file interaction
CN110083589A (en) A kind of ability warehouse towards avionics system
CN111897710A (en) Timing task diagnosis method and device

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
CB02 Change of applicant information

Address after: 210000 10 / F, building D-1, Greenland window, Yuhuatai District, Nanjing City, Jiangsu Province

Applicant after: Cloud accounting room network technology Co.,Ltd.

Address before: 210000 10 / F, building D-1, Greenland window, Yuhuatai District, Nanjing City, Jiangsu Province

Applicant before: NANJING YUNZHANGFANG NETWORK TECHNOLOGY Co.,Ltd.

CB02 Change of applicant information
GR01 Patent grant
GR01 Patent grant