CN110489398B - Method and system for transferring batch financial data of different financial systems - Google Patents
Method and system for transferring batch financial data of different financial systems Download PDFInfo
- Publication number
- CN110489398B CN110489398B CN201910747390.1A CN201910747390A CN110489398B CN 110489398 B CN110489398 B CN 110489398B CN 201910747390 A CN201910747390 A CN 201910747390A CN 110489398 B CN110489398 B CN 110489398B
- Authority
- CN
- China
- Prior art keywords
- data
- financial
- migrated
- financial system
- migration
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000013508 migration Methods 0.000 claims description 36
- 230000005012 migration Effects 0.000 claims description 36
- 230000008676 import Effects 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 4
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- 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/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE 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/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a system for transferring financial data in batches of different financial systems, which can automatically download data in different financial systems to be transferred, and automatically match, import and upload the data; the repeated and inefficient work that accounting of a billing company continuously logs in systems of different factories to finish data downloading and uploading to a new system is reduced; the accounting efficiency of the accounting company is improved; the financial data of the systems of different factories can be quickly migrated.
Description
Technical Field
The invention relates to the technical field of computers related to financial management, in particular to a method and a system for transferring batch financial data of different financial systems.
Background
Because of competing relationships between different financial software companies, manual downloading of financial data is typically only provided. If the account set and balance list, history credentials, report and other data are to be created from within the financial system of the financial software company, the data are migrated to a new financial system (if a different manufacturer) and only the data are re-entered on the new system. In this way, the accounting is repeated, a time-consuming and tedious operation.
Disclosure of Invention
The invention aims to solve the defects existing in the prior art.
In order to achieve the above purpose, the invention adopts the following technical scheme:
a method for bulk financial data migration for different financial systems, comprising the steps of:
s1: acquiring current enterprise information and account periods required to be downloaded by adopting a data interface;
s2: logging in the financial system to be migrated through the account number of the financial system to be migrated, and selecting a manufacturer corresponding to the financial system to be migrated;
s3: directly sending a request to a financial system to be migrated, and downloading data of a manufacturer to be migrated;
s4: assembling and compressing the data downloaded in the step S3;
s5: carrying out data automatic uploading on the data processed in the step S4 through an uploading interface;
s6: the migration main program decompresses the received data and automatically matches with an automatic matching template in the system;
s7: and warehousing the data successfully matched by the automatic matching template, and returning the data to a new financial system.
Furthermore, the method for transferring the batch financial data of the different financial systems further comprises a financial system for implementing the method for transferring the batch financial data of the different financial systems, wherein the financial system comprises a migration main program, and a data interface for acquiring enterprise information and needing to download account periods; the migration main program comprises the following steps: the method comprises the steps of logging in a logging-in module of a financial system to be migrated, directly sending a request to the financial system to be migrated, automatically downloading data of a manufacturer to be migrated, assembling and compressing the downloaded data, uploading an interface for assembling and compressing the data, decompressing the received data and automatically matching with an automatic matching template in the system, warehousing the successfully matched data of the automatic matching template, and returning the data to the module of the financial system.
S1: opening a migration main program, logging in a new financial system on line, and acquiring current enterprise information and account period required to be downloaded through an interface provided by the new financial system;
s2: logging in the financial system to be migrated through the account number of the financial system to be migrated, and selecting a manufacturer to be migrated;
s3: directly sending a request to a financial system to be migrated, and automatically downloading data of a manufacturer to be migrated;
s4: assembling and compressing the data downloaded in the step S3;
s5: carrying out data automatic uploading on the data processed in the step S4 through an uploading interface provided by a new financial system;
s6: the migration main program decompresses the received data and automatically matches with an automatic matching template in the system;
s7: and warehousing the data successfully matched by the automatic matching template, and returning the data to a new financial system.
Preferably, in step S1, after the current enterprise information is acquired, a step of checking and judging whether the acquired enterprise data is normal is further included.
Preferably, the request in step S3 includes a Post request and a Hook-Ajax request.
Preferably, different request modes are selected for different factories to be migrated, the download data is obtained by adopting a Post request mode preferentially, and if the download data cannot be obtained by the Post request, the download data is obtained by adopting a Hook-Ajax request mode.
Preferably, in the step S4, the downloaded data is uniformly compressed into a compressed file named by the name of the enterprise, and folders are created in the compressed file according to "year, month and day", and the downloaded form data is placed.
The invention also provides a system for batch financial data migration of different financial systems, which comprises a data acquisition unit, a data downloading unit, a data processing unit and a data receiving unit; the data acquisition unit is used for acquiring basic information in a new financial system; the data downloading unit is used for downloading data to be migrated in the financial system to be migrated; the data processing unit is used for assembling, compressing and arranging the downloaded data, and uploading the processed data to the data receiving unit; the data receiving unit is used for receiving the data uploaded by the data processing unit, matching the data with a pre-stored matching template in the system, warehousing the matched successful data, and finally transmitting the matched successful data back to the new financial system.
Further, the data downloading unit comprises a financial system login module to be migrated, a manufacturer selection module to be migrated and a downloading request sending module, wherein the financial system login module to be migrated is used for logging in a financial system to be migrated and providing a downloading source for the data downloading unit; the to-be-migrated manufacturer selection module is used for selecting to-be-migrated manufacturers needing to perform financial data migration; the download request sending module comprises a Post request mode and a Hook-Ajax request mode, and is used for obtaining download data.
Compared with the prior art, the invention has the beneficial effects that: the data in different financial systems to be migrated can be automatically downloaded, and automatically matched, imported and uploaded; the repeated and inefficient work that accounting of a billing company continuously logs in systems of different factories to finish data downloading and uploading to a new system is reduced; the accounting efficiency of the accounting company is improved; the financial data of the systems of different factories can be quickly migrated.
Drawings
FIG. 1 is a flow chart of a method of bulk financial data migration for different financial systems of the present invention.
FIG. 2 is a workflow diagram of a method of bulk financial data migration for a different financial system of the present invention.
FIG. 3 is a block diagram of a system for bulk financial data migration for a different financial system of the present invention.
Detailed Description
For a further understanding of the objects, construction, features, and functions of the invention, reference should be made to the following detailed description of the preferred embodiments.
Referring to FIGS. 1, 2 and 3 in combination, FIG. 1 is a flow chart of a method for bulk financial data migration for different financial systems according to the present invention; FIG. 2 is a block diagram of a system for bulk financial data migration for different financial systems in accordance with the present invention; FIG. 3 is a block diagram of a system for bulk financial data migration for a different financial system of the present invention.
As shown in FIGS. 1 and 2, a method for bulk financial data migration for different financial systems in accordance with one embodiment of the present invention includes the steps of:
s1: the migration main program is opened, a new financial system on line is logged in, basic information of the current enterprise, such as enterprise names and the like, and account periods needing to be downloaded are acquired through an interface provided by the new financial system, and the account period data is convenient to download; meanwhile, the data type balance table, the certificate and the like to be migrated are also required to be selected through the migration main program.
S2: logging in the financial system to be migrated through the login account number and the password of the financial system to be migrated, and selecting a manufacturer to be migrated;
s3: directly sending a request to a financial system to be migrated, and automatically downloading data of a manufacturer to be migrated; and adopting proper technology aiming at different financial systems to be migrated to download data of the type needing to be downloaded. By sending Post requests to the B/S architecture' S accounting system to be migrated, the download data (available to Post) is obtained. If the data cannot be acquired through the POST request, acquiring the data by adopting a Hook-Ajax request.
S4: assembling and compressing the data downloaded in the step S3; and carrying out data assembly on the downloaded data according to the interface constraint specification uploaded by the new financial system. The data assembly is as follows: in the file, a folder is created every year, month and day, and the downloaded Excel data is placed in the folder, for example: balance table xls et al. The folder is entirely compressed into a zip file named by the name of the business.
S5: and (3) carrying out data automation uploading on the data processed in the step S4 to a migration main program through an uploading interface provided by a new financial system.
S6: the migration main program decompresses the received data and automatically matches with an automatic matching template in the system. The data templates of different financial systems to be migrated are imported in advance in the migration main program, and the method is suitable for various financial systems on the market and is convenient for automatic matching after uploading data in the financial systems to be migrated.
S7: and warehousing the data successfully matched by the automatic matching template, and returning the data to a new financial system. And loading values in the matching templates into a new financial system, decompressing Excel Sheet data, reading corresponding row number values in the Excel Sheet, and performing regular matching on the values in the corresponding matching templates. If the values in all the rows and columns of the matching template can be matched with the values in the Excel Sheet table decompressed up, the Excel table is operated according to the preset matching template.
Preferably, in step S1, after the current enterprise information is obtained, it is checked and judged whether the obtained enterprise data is normal. If the data is normal, continuing to carry out the next step, and if the data is abnormal, feeding back error information to the migration main program.
Preferably, the request in step S3 includes a Post request and a Hook-Ajax request. The Post request mode has no data volume limitation, can send a large amount of data to the server, and has high efficiency, stability and reliability; the manner in which the Hook-Ajax request may be sent and retrieved only to the server. The Post request mode is preferably selected, and the data acquisition speed is high by adopting the Post request mode.
Preferably, different request modes are selected for different factories to be migrated, the download data is obtained by adopting a Post request mode preferentially, and if the download data cannot be obtained by the Post request, the download data is obtained by adopting a Hook-Ajax request mode.
Preferably, in the step S4, the downloaded data is uniformly compressed into a compressed file named by the name of the enterprise, and folders are created in the compressed file according to "year, month and day", and the downloaded form data is placed.
As shown in FIG. 3, the invention also provides a system for batch financial data migration of different financial systems, which comprises a data acquisition unit, a data downloading unit, a data processing unit and a data receiving unit; the data acquisition unit is used for acquiring basic information in a new financial system; the data downloading unit is used for downloading data to be migrated in the financial system to be migrated; the data processing unit is used for assembling, compressing and arranging the downloaded data, and uploading the processed data to the data receiving unit; the data receiving unit is used for receiving the data uploaded by the data processing unit, matching the data with a pre-stored matching template in the system, warehousing the matched successful data, and finally transmitting the matched successful data back to the new financial system.
When the system is applied, the data acquisition unit is connected with an interface provided by a new financial system to acquire basic information such as the name of an enterprise, and meanwhile, the accounting period is provided, so that the accounting period data can be conveniently downloaded; then, sending a request to download the data in the financial system to be migrated through a data downloading unit; then the downloaded data are assembled by the data processing unit according to the interface constraint specification uploaded by the new financial system, uniformly compressed into a compressed file named by the name of an enterprise, and then the processed data are uploaded through an uploading interface provided by the new financial system; the data receiving module decompresses the received data and automatically matches the data with a pre-stored matching template in the system, the successfully matched data is put in storage, and finally the put data is transmitted back to the new financial system, so that the migration of the data in the financial system to be migrated into the new financial system is completed.
Further, the data downloading unit comprises a financial system login module to be migrated, a manufacturer selection module to be migrated and a downloading request sending module, wherein the financial system login module to be migrated is used for logging in a financial system to be migrated and providing a downloading source for the data downloading unit; the to-be-migrated manufacturer selection module is used for selecting to-be-migrated manufacturers needing to perform financial data migration; the download request sending module comprises a Post request mode and a Hook-Ajax request mode, and is used for obtaining download data.
By the method and the system for transferring the batch data of different financial systems, the data in different financial systems to be transferred can be automatically downloaded, and automatically matched, imported and uploaded; the repeated and inefficient work that accounting of a billing company continuously logs in systems of different factories to finish data downloading and uploading to a new system is reduced; the accounting efficiency of the accounting company is improved; the financial data of the systems of different factories can be quickly migrated.
The invention has been described with respect to the above-described embodiments, however, the above-described embodiments are merely examples of practicing the invention. It should be noted that the disclosed embodiments do not limit the scope of the invention. On the contrary, the intention is to cover all modifications, equivalents, and alternatives falling within the spirit and scope of the invention.
Claims (6)
1. A method for batch financial data migration for different financial systems, characterized by: the method comprises the following steps:
s1: acquiring current enterprise information and account periods required to be downloaded by adopting a data interface;
s2: logging in the financial system to be migrated through the account number of the financial system to be migrated, and selecting a manufacturer corresponding to the financial system to be migrated;
s3: directly sending a request to a financial system to be migrated, and downloading data of a manufacturer to be migrated;
s4: assembling and compressing the data downloaded in the step S3;
s5: carrying out data automatic uploading on the data processed in the step S4 through an uploading interface;
s6: the migration main program decompresses the received data and automatically matches with an automatic matching template in the system;
s7: and warehousing the data successfully matched by the automatic matching template, and returning the data to a new financial system.
2. A method for bulk financial data migration for different financial systems as claimed in claim 1, wherein: the financial system also comprises a financial system for implementing the batch financial data migration method of different financial systems, wherein the financial system comprises a migration main program, a data interface for acquiring enterprise information and needing to download account periods; the migration main program comprises the following steps: logging in a logging module of a financial system to be migrated, directly sending a request to the financial system to be migrated, automatically downloading data of a manufacturer to be migrated, assembling and compressing the downloaded data, uploading an interface for assembling and compressing the data, decompressing the received data, automatically matching with an automatic matching template in the system, warehousing the data successfully matched with the automatic matching template, and returning the data to the module of the financial system;
s1: opening a migration main program, logging in a new financial system on line, and acquiring current enterprise information and account period required to be downloaded through an interface provided by the new financial system;
s2: logging in the financial system to be migrated through the account number of the financial system to be migrated, and selecting a manufacturer to be migrated;
s3: directly sending a request to a financial system to be migrated, and automatically downloading data of a manufacturer to be migrated;
s4: assembling and compressing the data downloaded in the step S3;
s5: carrying out data automatic uploading on the data processed in the step S4 through an uploading interface provided by a new financial system;
s6: the migration main program decompresses the received data and automatically matches with an automatic matching template in the system;
s7: and warehousing the data successfully matched by the automatic matching template, and returning the data to a new financial system.
3. A method for bulk financial data migration for different financial systems as claimed in claim 1, wherein: in step S1, after the current enterprise information is obtained, it is necessary to check and determine whether the obtained enterprise data is normal.
4. A method for bulk financial data migration for different financial systems as claimed in claim 1, wherein: the request in step S3 includes the manner of Post request and the manner of Hook-Ajax request.
5. A method for bulk financial data migration for different financial systems as recited in claim 4 wherein: different request modes are selected for different factories to be migrated, the download data is preferentially obtained in a Post request mode, and if the download data cannot be obtained through the Post request, the download data is obtained in a Hook-Ajax request mode.
6. A method for bulk financial data migration for different financial systems as claimed in claim 1, wherein: and S4, uniformly compressing the downloaded data into a compressed file named by the name of the enterprise, creating folders in the compressed file according to the year, month and day, and placing the downloaded form data.
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 CN110489398A (en) | 2019-11-22 |
| CN110489398B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111240714B (en) * | 2019-12-29 | 2024-01-05 | 云帐房网络科技有限公司 | Financial data initialization method and system based on template intelligent learning |
Citations (2)
| 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 |
-
2019
- 2019-08-14 CN CN201910747390.1A patent/CN110489398B/en active Active
Patent Citations (2)
| 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)
| Title |
|---|
| 基于IMS行政交换网的国家电网财务数据集中管理系统的设计与实现;邹谊等;《新型工业化》;20170420(第04期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110489398A (en) | 2019-11-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7661103B2 (en) | Apparatus, system, and method for decentralized data conversion | |
| US20200314083A1 (en) | Secure, cloud-based data collection tool | |
| CN113312064A (en) | Installation configuration method and device of physical machine and computer readable medium | |
| CN110489398B (en) | Method and system for transferring batch financial data of different financial systems | |
| CN111367982A (en) | Method and device for importing TRIRIGA basic data, computer equipment and storage medium | |
| US10609120B2 (en) | Customized, cloud-based data collection tool | |
| CN100498811C (en) | Method and system for information handling system custom image manufacture | |
| CN112508682A (en) | Method for automatically checking account by intelligent system | |
| 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 | |
| CN111723138A (en) | System and method for automatically acquiring data in simulated manual mode | |
| CN117575488A (en) | Production formula management method, system and device | |
| CN109063468A (en) | A kind of installation kit integrity verification and the method for reparation | |
| CN112565328B (en) | Automatic downloading and information binding tracing method for T-BOX certificate key file | |
| CN109525642B (en) | LIMS system client data automatic reporting method under user mechanism | |
| CN113127370A (en) | Report system smoking test method, RPA robot and system | |
| CN109977007B (en) | PLM (product development management) mold test management method and system | |
| CN109816342B (en) | Contract management method, contract management device, terminal and computer readable storage medium | |
| CN106354540A (en) | Terminal-spanning application program loading method and terminal-spanning application program loading system | |
| CN113239297A (en) | Message pushing method, system and storage medium | |
| CN112131131A (en) | Automatic interface testing framework system for pre-constructed domain name and request body | |
| CN117291370A (en) | Enterprise worker management system | |
| CN112819554B (en) | Service processing method and device based on page operation and computer equipment | |
| CN113485693B (en) | Interface configuration method, device, equipment and storage medium | |
| CN111507066B (en) | Method and system for uploading and loading files and analyzing and warehousing |
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 |