Patent ID: 7287040

Claim:
A method to facilitate transfer of data from a client database to a host database, comprising: identifying a data field from the client database desired for the host database; incorporating the data field in a spreadsheet; populating 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; developing an algorithm configured to reformat data associated with the data field from the client database and desired for the host database; receiving a test file from the client database; creating a reformatted test file from the test file using the algorithm; comparing the reformatted test file to the spreadsheet; identifying a change, wherein the change would substantially conform the reformatted test file to the spreadsheet; creating an updated algorithm from the algorithm, the updated algorithm incorporating the change; receiving an input file from the client database; creating a reformatted input file by applying the updated algorithm to the input file; and uploading the reformatted input file to the host database.