Patent ID: 7801849

Claim:
A system to facilitate transfer of data from a client database to a host database, comprising: a processor configured to identify a data field from the client database desired for the host database, incorporate the data field into a spreadsheet, populate at least a portion of the data field in the spreadsheet with test data values, wherein the test data values are formatted in accordance with format requirements of the data field, reformat data associated with the data field from the client database and desired for the host database, create a reformatted test file from the test file using an algorithm, compare the reformatted test file to the spreadsheet, and identify a change, wherein the change would substantially conform the reformatted test file to the spreadsheet, create an updated algorithm from the algorithm, the updated algorithm incorporating the change, receive a test file and an input file from the client database, create a reformatted input file by applying the updated algorithm to the input file, and upload the reformatted input file to the host database.