Test strategy system and method for accounts held direct at-fund
View Patent ↗A system and method for a user to test and transfer data from a client's database or network to a host's database or network is disclosed. A user acquires data information from a client and the user uses this information to generate a spreadsheet, and to populate the spreadsheet with assumed values based on the information received from the client. The user requests and receives a test file from the client and uses a developed algorithm to reformat the file so that it is consistent with the host's database configuration. The user determines the consistency between the reformatted file and the host's database by comparing the reformatted file to the previously generated spreadsheet. Any inconsistencies identified alert the user that the file reformatting algorithm needs updating.
1. A method comprising:
creating, by a computer-based system for facilitating a transfer of data from a client database to a host database, a reformatted test file with a test file using an algorithm, wherein said algorithm is configured to reformat data associated with a data field from said client database and desired for said host database;
identifying, by the computer-based system, a change that would substantially conform said reformatted test file to a spreadsheet;
creating, by the computer-based system, an updated algorithm from said algorithm which incorporates said change;
creating, by the computer-based system, a reformatted input file by applying said updated algorithm to an input file; and
uploading, by the computer-based system, said reformatted input file to said host database.
2. The method of claim 1 , further comprising receiving and analyzing a client record layout to identify said data fields desired by a host.
3. The method of claim 2 , wherein said receiving said client record layout further comprises receiving said client record layout from a database clearinghouse.
4. The method of claim 3 , wherein said receiving said client record layout further comprises receiving said client record layout from said database clearinghouse further comprises receiving said client record layout from at least one of DST and DAZL, database clearinghouse.
5. The method of claim 1 , further comprising receiving a 529 plan test file from said client database.
6. The method of claim 1 , further comprising at least one of:
determining an order to organize said data fields into said spreadsheet;
determining data field headers from said data fields and populating at least a portion of said data field headers into said spreadsheet in said order; and
determining parameters for said data fields and formatting said data fields using said parameters.
7. The method of claim 6 , wherein said determining parameters for said data fields and formatting said data fields using said parameters further comprises formatting said data fields to include at least one of an alphabetical, a numeric, and an alpha-numeric character.
8. The method of claim 1 , further comprising:
generating fictitious data in accordance with said parameters of said data fields;
populating at least a portion of said fictitious data into said spreadsheet; and
forwarding said spreadsheet to said client database for feedback regarding the accuracy and the organization of said spreadsheet.
9. The method in claim 1 , further comprising:
comparing data fields from said reformatted test file to data fields from said spreadsheet;
comparing parameters from said data fields from said reformatted test file to parameters from said data fields from said spreadsheet;
comparing data values from said data fields from said reformatted test file to data values from said data fields from said spreadsheet; and
identifying inconsistencies between said data values from said data fields from said reformatted test file to said data values from said data fields from said spreadsheet.
10. The method of claim 9 , wherein said identifying inconsistencies between said data values from said data fields from said reformatted test file to said data values from said data fields from said spreadsheet further comprises at least one of:
identifying said inconsistencies by a visual comparison, and
identifying said inconsistencies by an automated comparison.
11. The method of claim 1 , further comprising copying at least a portion of said input file to create at least a portion of a duplicate input file to minimize the possibility of losing information from said input file.
12. The method of claim 1 , further comprising:
identifying, by the computer-based system, at least one data field from said client database desired for said host database;
incorporating, by the computer-based system, said data field in a spreadsheet; and
populating, by the computer-based system, at least a portion of said data field in said spreadsheet with assumed data values.
13. The method of claim 1 , further comprising receiving, by the computer-based system, said input file from said client database.
14. The method of claim 1 , wherein said test file is from said client database.
15. A system comprising:
a processor for facilitating a transfer of data from a client database to a host database,
a tangible, non-transitory memory configured to communicate with the processor,
the tangible, non-transitory memory having instructions stored thereon that, in response to execution by the processor, cause the processor to perform operations comprising:
creating, by the processor, a reformatted test file with a test file using an algorithm, wherein said algorithm is configured to reformat data associated with a data field from said client database and desired for said host database;
identifying, by the processor, a change that would substantially conform said reformatted test file to a spreadsheet;
creating, by the processor, an updated algorithm from said algorithm which incorporates said change;
creating, by the processor, a reformatted input file by applying said updated algorithm to an input file; and
uploading, by the processor, said reformatted input file to said host database.
16. The system of claim 15 , further comprising receiving and analyzing a client record layout to identify said data fields desired by a host.
17. The system of claim 15 , further comprising at least one of:
determining an order to organize said data fields into said spreadsheet;
determining data field headers from said data fields and populating at least a portion of said data field headers into said spreadsheet in said order; and
determining parameters for said data fields and formatting said data fields using said parameters.
18. The system of claim 17 , wherein said determining parameters for said data fields and formatting said data fields using said parameters further comprises formatting said data fields to include at least one of an alphabetical, a numeric, and an alpha-numeric character.
19. The system of claim 15 , further comprising:
generating fictitious data in accordance with said parameters of said data fields;
populating at least a portion of said fictitious data into said spreadsheet; and
forwarding said spreadsheet to said client database for feedback regarding the accuracy and the organization of said spreadsheet.
20. An article of manufacture including a non-transitory, tangible computer readable medium having instructions stored thereon that, in response to execution by a computer-based system for facilitating a transfer of data from a client database to a host database, cause the computer-based system to perform operations comprising:
creating, by the computer-based system, a reformatted test file with a test file using an algorithm, wherein said algorithm is configured to reformat data associated with a data field from said client database and desired for said host database;
identifying, by the computer-based system, a change that would substantially conform said reformatted test file to a spreadsheet;
creating, by the computer-based system, an updated algorithm from said algorithm which incorporates said change;
creating, by the computer-based system, a reformatted input file by applying said updated algorithm to an input file; and
uploading, by the computer-based system, said reformatted input file to said host database.