File analysis system and method

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...

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

Images