Unlock instant, AI-driven research and patent intelligence for your innovation.

Intelligent solution for conversion between enterprise data

A technology of enterprise data and solutions, which is applied in the field of application scenarios for conversion between enterprise data, can solve problems such as waste of manpower and low efficiency of report generation, and achieve the effects of fewer program bugs, agile and rapid development, and saving development costs

Inactive Publication Date: 2018-11-06
SHANDONG INSPUR GENESOFT INFORMATION TECH CO LTD
View PDF5 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Generating various management reports often requires business personnel to export the data of different systems, and then use the corresponding office software to summarize and compile the reports, which not only leads to low efficiency of report generation, but also wastes manpower

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

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Intelligent solution for conversion between enterprise data
  • Intelligent solution for conversion between enterprise data
  • Intelligent solution for conversion between enterprise data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0031] An intelligent solution for the conversion between enterprise data. The workflow of intelligent conversion between enterprise data is as follows: figure 1 As shown, the content includes:

[0032] Establish a data storage location information table, and record the data storage location information of each system report, such as figure 2 Shown

[0033] Establish a data corresponding information configuration table, and record the corresponding relationship information of each system report, such as image 3 Shown

[0034] Read the data storage location information table and the data corresponding information table, read and analyze the data of the source report, and then convert the target report data according to the data corresponding relationship according to the data corresponding information;

[0035] Data import and export use RPA program to quickly establish, according to the standardized process of each system data export, use RPA software to quickly establish report dat...

Embodiment 2

[0037] The core pseudo code of cell data conversion processing type is as follows:

[0038] / / filePath is the path of the data corresponding information configuration table

[0039] FileStream sr = new FileStream(filePath, FileMode.OpenOrCreate,FileAccess.Read);

[0040] DataTable fileDt =getDataTable(SheetName + "^A~Z~2", sr,true); / / Data storage location information

[0041] / / path is the path of the data corresponding information configuration table

[0042] FileStream sr = new FileStream(Path, FileMode.OpenOrCreate,FileAccess.Read);

[0043] DataTable dt =getDataTable(SheetName + "^A~Z~2", sr,true); / / data corresponding information

[0044] foreach (DataRow dr in dt.Rows) / / / traverse all rows

[0045] {

[0046] If(dr["RData_Type"].ToString()=="area")

[0047] {

[0048] ReadCell(fileDt.Select("Src_SystemNo='FromSys'")(0).Item("Value").ToString,dr["RData_Range"].ToString());

[0049] WriteCell(fileDt.Select("Src_SystemNo='ToSys'")(0).Item("Value").ToString,dr["RData_Range"].ToString());

[...

Embodiment 3

[0053] The core pseudo code of the data area data conversion processing type is as follows:

[0054] foreach (DataRow dr in dt.Rows) / / / traverse all rows

[0055] {

[0056] If(dr["RData_Type"].ToString()=="area")

[0057] {

[0058] DataTable FromDt =getDataTable(SheetName + "^A~Z~2", sr,true); / / read the source data table

[0059] Int Index=1;

[0060] do / / / traverse all lines to get the start line

[0061] {

[0062] Celldata=ReadCell(fileDt.Select("Src_SystemNo='FromSys'")(0).Item("Value").ToString,dr["RData_Range"].ToString());

[0063] Index = index+1;

[0064] }

[0065] while(Celldata!= getStartFlag (dr["RData_Range"].ToString()))

[0066] startIndex=index;

[0067] do / / / Traverse all the lines to get the end line

[0068] {

[0069] Celldata=ReadCell(fileDt.Select("Src_SystemNo='FromSys'")(0).Item("Value").ToString,dr["RData_Range"].ToString());

[0070] Index = index+1;

[0071] }

[0072] while(Celldata!= getEndFlag (dr["RData_Range"].ToString()))

[0073] endIndex=index;

[0074] range=get...

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 an intelligent solution for conversion between enterprise data. The method comprises the following steps of: establishing a data storage position information table and recordingreport data storage position information of involved systems; establishing a data corresponding table, teasing and recording a corresponding relationship of the report data according to different business meanings and sources of the report data in the systems, and recording the corresponding relationship among the data into the data corresponding table; and completing data conversion through different conversion processes according to the teased corresponding relationship among the report data and different types corresponding to the data. According to the solution, conversion among multipletypes of report data, such as data conversion among fixed tables, variable tables and hybrid tables, is supported on the basis of Excel; an RPA technology is applied to report data obtaining and report data filling; and compared with the prior art, the solution has the characteristics of being fewer in data conversion program BUGs, free in third-party software vendor cooperation, rapid in development and easy for non-professional personnel, and saving the interface development cost.

Description

Technical field [0001] The present invention relates to the technical field of business intelligence analysis (BI), in particular to application scenarios of conversion between enterprise data, and an intelligent solution method for conversion between enterprise data. Background technique [0002] With the improvement of modern enterprise informatization and the awareness of refined management, various management reports have emerged in the process of enterprise management. Because enterprise information software is often not provided by the same software vendor, it exists in the entire enterprise Various data islands. Generating various management reports often requires business personnel to export data from different systems, and then summarize and compile reports through corresponding office software. This not only leads to low efficiency of report generation, but also a waste of manpower. Summary of the invention [0003] In order to solve the above technical problems, the pr...

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
IPC IPC(8): G06F17/30G06F17/24
CPCG06F40/18
Inventor 李冉冉马娟王涛威简闻
Owner SHANDONG INSPUR GENESOFT INFORMATION TECH CO LTD