System for synchronization of configuration values between a data base and its input utility

• US 7,882,063 B2
• Filed: 09/03/2008
• Issued: 02/01/2011
• Est. Priority Date: 04/27/2006
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Murray, Douglas G., Martin, James A. Jr.
• Primary Examiner(s): Jalil; Neveen Abel
• Assistant Examiner(s): LIANG, VEI CHUNG
• Application Number:
  US12/203,346
• Publication Number:
  US 20090024672A1
• Time in Patent Office: 881 Days
• Field of Search: None
• US Class Current: 707/617
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A system, method, and computer program product are provided for synchronizing configuration values between a database and a remote input utility by configuring the database for remote input and loading the configuration values to a control file at the server, and copying the configuration values to a control file at remote system including the input utility, executing the input utility at a remote system using configuration values from the control file at the remote system to prepare data for input to the database, and responsive to the configuration values at the control file of the server, updating the configuration values in the control file at the remote system before migrating the new data from the input utility to the database.

Claims

1. A system for synchronizing configuration values between a database and a remote input utility for a computer hardware inventory application, comprising:

a server computer including said database, a configuration edit tool, and a first control file;

a remote workstation for executing said remote input utility, and including a second control file;

said configuration edit tool configures said database for input from said remote input utility and for loading configuration values to said first control file, said configuration values including yes, no, blocked port, unknown serial, unknown owner, adapter delivered, adapter not delivered, adapter not required, status open, status pending, status no migration, status complete, serial not in directory, machine not available, and a special needs section comprising a plurality of entries defining special needs for a workstation configuration of the form indicia A=B;

where yes is a value returned whenever a yes response is needed, no is a value returned whenever a no response is needed, blocked is a value returned as a port identifier when said port is blocked and inventory personnel can not read it, unknown serial is a value returned as machine serial if said machine serial is not known at the time of executing said inventory application, unknown owner is a value returned if an owner is not known at the time of executing said inventory application, adapter delivered is a text string used to indicate that a card has been delivered for installation by a user, adapter not delivered is a text string used to indicate that a card is required but not delivered for installation by said user, adapter not required is a text string used to indicate that a card is not required for installation by said user, status open is a value returned when a new document is to be in open status in said inventory application, status pending is a value returned when a new document is to be in pending status in said inventory application, status no migration is a value returned when a new document is to be in no migration status in said inventory application, status complete is a value to be returned when a new document is to be in complete status in said inventory application, serial not in directory is a value returned when said user'"'"'s identifier is not found in a directory of users, and machine not available is a value returned when an employee machine is not available;

said first control file responsive to modification of said configuration values and to the existence of a connection between said remote workstation and said server computer adapted for copying said configuration values to said second control file;

said input utility using configuration values from said second control file to prepare and load to an output file configuration data for input to said database, indicia B represents dialog text presented to a user for prompting a response and indicia A represents corresponding text provided to said output file thereby presenting to said user as indicia B choices as understood by said user and returning to said database indicia A choices as known to said database; and

said second control file responsive to configuration values at said first control file changing with respect to those in said second control file for receiving updating configuration values from said first control file for configuring new data for migration from said input utility to said database.

2. The system of claim 1, said input utility presents migration instructions to a user at a user interface derived from configuration values in said second control file.

3. The system of claim 2, said input utility executes while disconnected from said server to prepare new input data using configuration values most recently loaded to said second control file.

4. The system of claim 3, said input utility is responsive to connecting to said server for receiving updated configuration values from said server for updating said new input data to said updated configuration values before migrating said new input data to said database.

5. A computer readable storage medium encoded with a computer program for synchronizing configuration values between a database and a remote input utility, said computer program comprising:

first program instructions for configuring said database at a server for input from said input utility at said remote system;

second program instructions for loading configuration values to a control file at said server, said configuration values including yes, no, blocked port, unknown serial, unknown owner, adapter delivered, adapter not delivered, adapter not required, status open, status pending, status no migration, status complete, serial not in directory, machine not available, and a special needs section comprising a plurality of entries defining special needs for a workstation configuration of the form indicia A=B;

where yes is a value returned whenever a yes response is needed, no is a value returned whenever a no response is needed, blocked is a value returned as a port identifier when said port is blocked and inventory personnel can not read it, unknown serial is a value returned as machine serial if said machine serial is not known at the time of executing said inventory application, unknown owner is a value returned if an owner is not known at the time of executing said inventory application, adapter delivered is a text string used to indicate that a card has been delivered for installation by a user, adapter not delivered is a text string used to indicate that a card is required but not delivered for installation by said user, adapter not required is a text string used to indicate that a card is not required for installation by said user, status open is a value returned when a new document is to be in open status in said inventory application, status pending is a value returned when a new document is to be in pending status in said inventory application, status no migration is a value returned when a new document is to be in no migration status in said inventory application, status complete is a value to be returned when a new document is to be in complete status in said inventory application, serial not in directory is a value returned when said user'"'"'s identifier is not found in a directory of users, and machine not available is a value returned when an employee machine is not available;

third program instructions for copying said configuration values to a control file at said remote system;

fourth program instructions for executing said input utility using configuration values from said control file at said remote system to prepare and load to an output file configuration data for input to said database, indicia B represents dialog text presented to a user for prompting a response and indicia A represents corresponding text provided to said output file thereby presenting to said user as indicia B choices as understood by said user and returning to said database indicia A choices as known to said database; and

fifth program instructions, responsive to configuration values at said control file changing with respect to those in said control file at said server, for updating configuration values in said control file at said remote system before migrating new data from said input utility to said database; and

wherein

said first, second, third, fourth, and fifth program instructions are recorded on said medium.

6. The computer readable storage medium of claim 5, further comprising sixth program instructions for executing said input utility to present migration instructions to a user at a user interface derived from configuration values in said control file at said remote system;

and wherein said sixth program instructions are recorded on said medium.

7. The computer readable storage medium of claim 6, further comprising seventh program instructions for executing said input utility while disconnected from said server to prepare new input data using configuration values most recently loaded to said control file at said remote system;

and wherein said seventh program instructions are recorded on said medium.

8. The computer readable storage medium of claim 7, further comprising eighth program instructions responsive to said utility being connected to said server for receiving updated configuration values from said server for updating said new input data to said updated configuration values before migrating said new input data to said database;

and where in said eighth program instructions are recorded on said medium.