File analysis system and method

A file analysis and file technology, applied in transmission systems, electrical components, special data processing applications, etc., can solve problems such as limited scope, single function, and difficult data interaction, and achieve the effect of easy processing

Active Publication Date: 2012-04-04
北京首冠教育科技集团有限公司
View PDF4 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the SAP (Systems Applications and Products in Data Processing) system is introduced into the original application system, due to the difference in data format and data storage method, the data interaction between the SAP system and the original application system becomes difficult
To this end, the SAPPI (Process Integration, process integration) server provides some adapters, but these adapters are limited in type and have a single function, and there are many IT systems in the enterprise. For enterprises that use SAP PI to integrate various IT systems, use SAP The scope of PI integrated application system is limited
[0003] Sometimes SAP PI is required to read and process data from FTP files. The standard SAP PI file transfer adapter (File Sender Adapter) can only read and parse flat files (Flat File) that meet the SAP PI adapter requirements, such as XML files , but it can’t do anything about binary files with relatively complex formats, such as dbf, xls, and mdb files

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
  • File analysis system and method
  • File analysis system and method
  • File analysis system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0013] like figure 1 Shown is a structure diagram of a preferred embodiment of the file parsing system of the present invention. The file parsing system 10 runs in a file transfer adapter (File Sender Adapter) 4 contained in a Process Integration (PI) server 1 . The process integration server 1 further includes a remote function call adapter (remote function call adapter, RFC adapter) 5 . The process integration server 1 is connected to an FTP (File Transfer Protocol, file transfer protocol) server 2 through a network 6 for data transmission between the FTP server 2 and the SAP (Systems Applications and Products in Data Processing) system 3 . The network 6 may be the Internet (Internet) or an intranet (Intranet).

[0014] A plurality of FTP files are stored in the FTP server 2, and the types of the FTP files are MDB, DBF, XLS, TXT, CSV, etc. respectively. In this embodiment, the FTP server 2 can be set up in the procurement system, accounting system, bonded system, logistic...

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 relates to a file analysis method, which comprises the following steps of: reading a file and a file type parameter of the file from a file transfer protocol (FTP) server; judging whether the type of the file is one of textfile (TXT), comma separated values (CSV), meta database (MDB), database file (DBF) and Microsoft Excel (XLS) formats or not according to the file type parameter; when the type of the file is TXT or CSV, calling a JAVA algorithm to analyze TXT or CSV so as to generate an extensible markup language (XML) file; when the type of the file is MDB, calling the JAVA algorithm to analyze MDB so as to generate an XML file; when the type of the file is DBF, calling the JAVA algorithm to analyze DBF so as to generate an XML file; and when the type of the file is XLS, calling the JAVA algorithm to analyze XLS so as to generate an XML file. The invention also provides a file analysis system. By the method and the system, a binary file can be analyzed into a file which can be processed by a file sender adapter and is in an XML format.

Description

technical field [0001] The invention relates to a file parsing system and method. Background technique [0002] With the continuous advancement of information technology, more and more application systems have emerged within the enterprise, such as procurement systems, accounting systems, bonded systems, logistics systems and sales systems. Each application system has a different data format and adopts a different data storage method, such as storing data according to FTP (File Transfer Protocol, file transfer protocol). When the SAP (Systems Applications and Products in Data Processing) system is introduced into the original application system, due to the difference in data format and data storage method, the data interaction between the SAP system and the original application system becomes difficult. To this end, the SAPPI (Process Integration, process integration) server provides some adapters, but these adapters are limited in type and have a single function, and there...

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/30H04L29/06
Inventor 王台弘黄玉玺刘柏廷甘淑慧简吉廷梁文广姚进罗伟何宝儒林晟
Owner 北京首冠教育科技集团有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products