Data Transformation System

Abstract

Various aspects of the disclosure relate to automated conversion or transformation of data received from a plurality of sources, and of any format, into forms compatible as input to an application computing system. The data conversion platform identifies a format of an input data file or structure and imports characters, both printable and non-printable, from the input file and stores the imported characters as a string. The data conversion platform generates from the string data to an array of strings based on delimiters or other special characters. The data conversion platform applies a pattern model to the array string to identify patterns of data and stores matches as a second array of strings. The second array of strings is compared to a match file to identify bindings between input data and desired output data. These matches are then formatted as output data and communicated to the desired application for processing.

1 . A system comprising:
 a data conversion platform, comprising:
 a processor; and 
 memory storing computer-readable instructions that, when executed by the processor, cause the data conversion platform to:
 receive, via a network, a first input data comprising a file, wherein the file is in a first format of a plurality of formats corresponding to a first source computing system and comprising printable and non-printable characters; 
 import the first input data as a string based on identification of a format associated with the first source computing system; 
 generate, based on an input pattern file, a first array from pattern matches identified from the imported first input data; 
 generate, based on a configuration file, a second array comprising matches between an input information format and an output information format; 
 send, automatically via the network and based on generation of the second array, output data as an output file and in a format capable of being processed by an application computing system as second input data; and 
 trigger, automatically and based on an indication the output file is received at the application computing system, processing of the output file by the application computing system; and 
 
   the application computing system comprising:
 a second processor; and 
 second memory storing second instructions that, when executed by the second processor, cause the application computing system to:
 import, automatically upon receipt of the output file, the output file, wherein the output file is in a second format incompatible with the first format; and 
 perform an operation based on the second input data of the output file received from the data conversion platform. 
 
   
     
     
         2 . The system of  claim 1 , wherein the data conversion platform is integrated, at least in part, within the application computing system. 
     
     
         3 . The system of  claim 1 , wherein the first input data is incompatible with the application computing system. 
     
     
         4 . The system of  claim 1 , wherein the instructions further cause the data conversion platform to:
 identify a file format of the first input data; and   import, based on the file format, the printable and non-printable characters from the first input data.   
     
     
         5 . The system of  claim 1 , wherein the instructions further cause the data conversion platform to:
 identify a file format of the first input data; and   perform, based on an identification of an image file, optical character recognition to identify characters within the first input data; and   import identified characters from the first input data.   
     
     
         6 . The system of  claim 5 , wherein the first input data is a pdf document. 
     
     
         7 . The system of  claim 1 , wherein the output data is formatted as an extensible markup language (XML) file. 
     
     
         8 . The system of  claim 1 , wherein the instructions further cause the data conversion platform to:
 import characters from the first input data;   compare a count of imported characters to a threshold; and   perform, based on the count of imported characters not meeting the threshold, optical character recognition on the first input data.   
     
     
         9 . The system of  claim 8 , wherein the instructions further cause the data conversion platform to convert the first input data to gray scale before performing optical character recognition. 
     
     
         10 . A method comprising:
 receiving, via a network, a first input data comprising a file, wherein the file is in a first format of a plurality of formats corresponding to a first source computing system and comprising printable and non-printable characters;   importing the first input data as a string based on identification of a format associated with the first source computing system;   generating, based on an input pattern file, a first array from pattern matches identified from the imported first input data;   generating, based on a configuration file, a second array comprising matches between an input information format and an output information format;   sending, automatically via the network and based on generation of the second array, output data as an output file and in a format capable of being processed by an application computing system as second input data; and   triggering, automatically and based on an indication the output file is received at the application computing system, processing of the output file by the application computing system; and   processing, by an application computing system the second input data received from a data conversion platform.   
     
     
         11 . The method of  claim 10 , wherein the data conversion platform is integrated, at least in part, within the application computing system. 
     
     
         12 . The method of  claim 10 , wherein the first input data is incompatible with the application computing system. 
     
     
         13 . The method of  claim 10 , further comprising:
 identifying a file format of the first input data; and   importing, based on the file format, printable and non-printable characters from the first input data.   
     
     
         14 . The method of  claim 10 , further comprising:
 identifying a file format of the first input data; and   performing, based on an identification of an image file, optical character recognition to identify characters within the first input data; and   importing identified characters from the first input data.   
     
     
         15 . The method of  claim 14 , wherein the first input data is a pdf document. 
     
     
         16 . The method of  claim 10 , wherein the output data is formatted as an extensible markup language (XML) file. 
     
     
         17 . The method of  claim 10 , further comprising:
 importing characters from the first input data;   comparing a count of imported characters to a threshold; and   performing, based on the count of imported characters not meeting the threshold, optical character recognition on the first input data.   
     
     
         18 . The method of  claim 17 , further comprising converting the first input data to gray scale before performing optical character recognition. 
     
     
         19 . Non-transitory computer readable media storing instructions that, when executed by a processor, cause a data conversion platform to:
 receive, via a network, a first input data file, wherein the data file is in a first format of a plurality of formats corresponding to a first source computing system and comprising printable and non-printable characters;   import the first input data file as a string based on identification of a format associated with the first source computing system;   generate, based on an input pattern file, a first array from pattern matches identified from the imported first input data file;   generate, based on a configuration file, a second array comprising matches between an input information format and an output information format;   send, via the network, output data as an output file and in a format capable of being processed by an application computing system as second input data; and   trigger, automatically and based on an indication the output file is received at the application computing system, processing of the output file by the application computing system.   
     
     
         20 . The non-transitory computer readable media of  claim 19 , wherein the instructions cause the data conversion platform to:
 import characters from the first input data;   compare a count of imported characters to a threshold; and   perform, based on the count of imported characters not meeting the threshold, optical character recognition on the first input data.