Patent ID: 9020988
Filing Date: 2015-04-28
Classification: G06F,G06Q

Abstract:
1. An automated method of aggregating data for a database comprising: acquiring a purchase data file from one of a multiplicity purchasing agencies; converting the purchase data file into a multiplicity of text files using a multiplicity of configuration files, each configuration file having for each of the multiplicity of configuration files, processing the intermediate text file into the intermediate data file having the plurality of fields and analyzing the processing to produce processing results; selecting a best match configuration file of the multiplicity of configuration files determined to have a higher level of processing results; testing the best match configuration file for a minimum level of acceptable data; parsing the intermediate text file of the best match configuration file into an intermediate annotated data file using the best match configuration file; normalizing the intermediate annotated data file to produce a normalized intermediate annotated data file; loading the normalized intermediate annotated data file into a backend database; and publishing changes in the backend database to a customer facing database, wherein the minimum level of acceptable data includes a population of at least one of the following fields: purchase order number, vendor name, date, quantity, description and amount.