Beth A Bolstad

US Patent:

7801849, Sep 21, 2010

Filed:

Aug 16, 2007

Appl. No.:

11/839732

Inventors:

Beth Bolstad - Minnetonka MN, US
Debbie Counce - Brooklyn Center MN, US
Elizabeth Gray - Minneapolis MN, US
Alana King - Champlin MN, US
Carla Nelson - Burnsville MN, US

Assignee:

American Express Travel Related Services Company, Inc. - New York NY

International Classification:

G06F 17/30
G06F 17/00

US Classification:

707609, 7079991, 707999107, 707999101, 707999102

Abstract:

The present invention provides 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. In accordance with an exemplary embodiment of the present invention, a user acquires data information from a client. 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 spreadsheet is configured in a fashion such that it is consistent with the host's database or network. The user requests and receives a test file from the client and uses a developed algorithm, generally in the form of a computer program, 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.

US Patent:

8037020, Oct 11, 2011

Filed:

Aug 12, 2010

Appl. No.:

12/855386

Inventors:

Beth Bolstad - Minnetonka MN, US
Debbie Counce - Brooklyn Center MN, US
Elizabeth Gray - Minneapolis MN, US
Alana King - Champlin MN, US
Carla Nelson - Burnsville MN, US

Assignee:

American Express Travel Related Services Company, Inc. - New York NY

International Classification:

G06F 17/30
G06F 17/00

US Classification:

707609, 707705

Abstract:

The present invention provides 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. In accordance with an exemplary embodiment of the present invention, a user acquires data information from a client. 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 spreadsheet is configured in a fashion such that it is consistent with the host's database or network. The user requests and receives a test file from the client and uses a developed algorithm, generally in the form of a computer program, 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.

US Patent:

8538913, Sep 17, 2013

Filed:

Sep 7, 2011

Appl. No.:

13/227338

Inventors:

Beth Bolstad - Minnetonka MN, US
Debbie Counce - Brooklyn Center MN, US
Elizabeth Gray - Minneapolis MN, US
Alana King - Champlin MN, US
Carla Nelson - Burnsville MN, US

Assignee:

American Express Travel Related Services Company, Inc. - New York NY

International Classification:

G06F 17/00
G06F 17/30

US Classification:

707602, 707803

Abstract:

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.

US Patent:

20050086193, Apr 21, 2005

Filed:

Feb 4, 2004

Appl. No.:

10/772199

Inventors:

Beth Bolstad - Minnetonka MN, US
Debbie Counce - Brocklyn Center MN, US
Elizabeth Gray - Minneapolis MN, US
Alana King - Champlin MN, US
Carla Nelson - Burnsville MN, US

International Classification:

G06F007/00

US Classification:

707001000

Abstract:

The present invention provides 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. In accordance with an exemplary embodiment of the present invention, a user acquires data information from a client. 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 spreadsheet is configured in a fashion such that it is consistent with the host's database or network. The user requests and receives a test file from the client and uses a developed algorithm, generally in the form of a computer program, 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. When all the updates are complete and the reformatting algorithm has been deemed appropriate to carry out the data transformation function, the entire client database log is sent to the user in the form of an input file. The input file is duplicated to protect the original information and then reformatted using the updated algorithm. The reformatted file may then be uploaded to the host's network or database so that the information contained may be used by others who access the database or network for information.