Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for processing data among systems by using Excel

An excel and data technology, applied in the field of data governance between systems through Excel, can solve problems such as difficult data conversion, achieve efficient data sorting, improve accuracy and work efficiency

Inactive Publication Date: 2011-04-13
INFORMATION & COMMNUNICATION BRANCH STATE GRID JIANGXI ELECTRIC POWER CO
View PDF0 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The method of data management between systems through Excel in the present invention provides an automatic conversion process in the form of an Excel plug-in to solve the problem of user data between systems Converting an exceptionally difficult problem,

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] Name explanation:

[0018] VSTO: Visual Studio Tools for Office;

[0019] Extraction @Source: data extraction;

[0020] Transformation: data conversion;

[0021] Verify: data verification;

[0022] Loading @Destination: Loading the source system;

[0023] The present invention includes four processes of system data conversion: extracting useful fields from the source data Excel table; converting codes in the data through conversion rules; verifying the converted data; generating new target data. Express the relationship between completed functions and application modules in the following form:

[0024] Define the following basic operations in Excel data governance scenario conversion:

[0025] F=(Swp, Mer, Split, Sort, Rep, Fact, Dist, Check) conversion function is a collection of these types of functions. Among them, Swp is an exchange function, which is a unary operation; Mer is a merge operation, and the entity a i and a j is merged and produces a i+j ;Split...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a method for processing data among systems by using Excel. the method comprises the following steps: performing various configurable data capturing on an Excel file exported out of a source system according to a parameter table rule by using a configuration parameter table; converting codes of the data according to a coding rule; and verifying the data through a verification rule. Therefore, the processing on data of a source system to become data in a target system format can be realized, the collecting workload of massively similar data can be reduced, and the data quality can be further improved effectively and quickly.

Description

technical field [0001] The invention relates to a method for managing data between systems through Excel. technical background [0002] With the rapid development of domestic informatization, there are more and more application systems in enterprises, and the data formats and codes of each system are inconsistent, which makes the data conversion between systems extremely difficult. During the conversion process, it is easy to generate Coding errors, low accuracy, and low work efficiency. Contents of the invention [0003] The purpose of the present invention is to propose a method for managing data between systems through Excel that can reduce the workload of arranging a large number of similar data, and further efficiently and rapidly improve data quality. [0004] The method of managing data between systems through Excel in the present invention provides an automated conversion process in the form of an Excel plug-in to solve the problem that users are extremely difficu...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 马勇周宇梁良陶振文
Owner INFORMATION & COMMNUNICATION BRANCH STATE GRID JIANGXI ELECTRIC POWER CO
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products