Abstract: Disclosed are a method, system and computer program for collecting inventory data about a group of machines at an office. This method comprises the steps of running an inventory tool on each of the machines, and the tool presenting dialog displays on each of the machines, filling in or changing data in the dialogs presented by the tool, and submitting the collected information to a server. Also disclosed are a method, system and computer program for customizing an inventory data collection tool for a plurality of logical groups of users. Each of the logical groups of users is provided with a copy of the inventory data collection tool and with a first copy of a common control file. Each of the groups of users uses the first copy of the common control file to customize the tool for the group of users.

Abstract: The present invention provides a vehicle for the exchange of data between a database and an independent spreadsheet. Specifically, the present invention may be used to import data from a database to a spreadsheet and/or to export data to a spreadsheet. To facilitate this exchange, one or more controls are entered into cells in the spreadsheet. The controls specify the manner in which the data is exchanged between the database and the spreadsheet. For example, a control may specify a data type, a formatting parameter, a source field, a destination field, and/or a formula for a designated cell in the spreadsheet. The controls are executed by a linker that links the data in the database and the data in the spreadsheet to effect the exchange of data between the two.

Abstract: A solution for managing data received from multiple sources is provided. In particular, when conflicting data values are received from multiple sources for a data element, a conflict rule is used to determine the main data value for the data element, which is subsequently stored for use. The conflict rule can define any automatic, semi-automatic, or manual procedure for resolving the conflict. The conflict rule, or an identifier thereof, can be stored with each data value and the main data value for the data element.

Abstract: Disclosed are a method, system and computer program for collecting inventory data about a group of machines at an office. This method comprises the steps of running an inventory tool on each of the machines, and the tool presenting dialogue displays on each of the machines, filling in or changing data in the dialogues presented by the tool, and submitting the collected information to a server. Also disclosed are a method, system and computer program for customizing an inventory data collection tool for a plurality of logical groups of users. Each of the logical groups of users is provided with a copy of the inventory data collection tool and with a first copy of a common control file. Each of the groups of users uses the first copy of the common control file to customize the tool for the group of users.

Abstract: Disclosed are a method, system and computer program for collecting inventory data about a group of machines at an office. This method comprises the steps of running an inventory tool on each of the machines, and the tool presenting dialog displays on each of the machines, filling in or changing data in the dialogs presented by the tool, and submitting the collected information to a server. Also disclosed are a method, system and computer program for customizing an inventory data collection tool for a plurality of logical groups of users. Each of the logical groups of users is provided with a copy of the inventory data collection tool and with a first copy of a common control file. Each of the groups of users uses the first copy of the common control file to customize the tool for the group of users.

Abstract: A solution for managing data received from multiple sources is provided. In particular, when conflicting data values are received from multiple sources for a data element, a conflict rule is used to determine the main data value for the data element, which is subsequently stored for use. The conflict rule can define any automatic, semi-automatic, or manual procedure for resolving the conflict. The conflict rule, or an identifier thereof, can be stored with each data value and the main data value for the data element.

Abstract: A system, method and program product for synchronizing spreadsheet data. A system is provided having: a scheduling system for scheduling a first import time, a second import time, a first export time and a second export time; an import system for obtaining a first spreadsheet from a first entity at the first import time, and for obtaining a second spreadsheet from a second entity at the second import time; a synchronization system for synchronizing the first spreadsheet and the second spreadsheet to obtain a first revised spreadsheet and a second revised spreadsheet; and an export system for providing the first revised spreadsheet to the first entity at the first export time, and for providing the second revised spreadsheet to the second entity at the second export time.

Abstract: Under the present invention, a distribution list of message recipients within an organization undergoing the IT migration is generated by analyzing the infrastructure of the organization. Once the message recipients are known, they can be grouped into a set of mailing groups. Thereafter, specific message templates can be assigned to each group, and a schedule for sending messages to the message recipients can be set. Messages will then be generated and sent to the message recipients using the message templates assigned to their respective mailing group(s) and the schedule. Responses to the messages will be tracked and processed, and records associated with the message recipients will be updated based thereon. Follow-up messages containing additional questions and/or instructions can be generated and sent using any data that is contained in the responses. Also, “non-responses” can be tracked so that reminder messages can be sent.

Abstract: Disclosed are a method, system and computer program for collecting inventory data about a group of machines at an office. This method comprises the steps of running an inventory tool on each of the machines, and the tool presenting dialogue displays on each of the machines, filling in or changing data in the dialogues presented by the tool, and submitting the collected information to a server. Also disclosed are a method, system and computer program for customizing an inventory data collection tool for a plurality of logical groups of users. Each of the logical groups of users is provided with a copy of the inventory data collection tool and with a first copy of a common control file. Each of the groups of users uses the first copy of the common control file to customize the tool for the group of users.

Abstract: Disclosed are a method, system and computer program for collecting inventory data about a group of machines at an office. This method comprises the steps of running an inventory tool on each of the machines, and the tool presenting dialogue displays on each of the machines, filling in or changing data in the dialogues presented by the tool, and submitting the collected information to a server. Also disclosed are a method, system and computer program for customizing an inventory data collection tool for a plurality of logical groups of users. Each of the logical groups of users is provided with a copy of the inventory data collection tool and with a first copy of a common control file. Each of the groups of users uses the first copy of the common control file to customize the tool for the group of users.

Abstract: A computer-implemented method for recording an asset survey or installation, comprising storing data received from an electronic database in an independent spreadsheet application operable on a portable electronic device, the data including identifying information for new and/or old assets and an employee listing. At least one field of the independent spreadsheet application is prepopulated with a set of data displayed in a drop down menu when the independent spreadsheet application is not operably connected to the asset management database. A variable is selected from the set of data presented in the drop-down menu associated with the at least one field displayed on the independent spreadsheet when the independent spreadsheet application is not operably connected to the asset management database. The selected variable is stored as a record located in a storage worksheet of the independent spreadsheet application when the spreadsheet application is not operably connected to the asset management database.

Abstract: Under the present invention, an initial distribution list of electronic message recipients within an organization undergoing an IT migration is generated using a personnel directory of the organization and at least one selection criterion. Once initial electronic message recipients are known, messages will be generated and sent using information from a mailing database and a designated schedule. User records for each of the initial electronic message recipients will be created in an inventory database and will include user information from the personnel directory as well as message information. Based on responses to the initial electronic message, follow-up and final electronic messages can be sent to respective distribution lists, and corresponding information stored in the user records of the inventory database.

Abstract: The present invention provides a vehicle for the exchange of data between a database and an independent spreadsheet. Specifically, the present invention may be used to import data from a database to a spreadsheet and/or to export data to a spreadsheet. To facilitate this exchange, one or more controls are entered into cells in the spreadsheet. The controls specify the manner in which the data is exchanged between the database and the spreadsheet. For example, a control may specify a data type, a formatting parameter, a source field, a destination field, and/or a formula for a designated cell in the spreadsheet. The controls are executed by a linker that links the data in the database and the data in the spreadsheet to effect the exchange of data between the two.

Abstract: A system, method and program product for synchronizing spreadsheet data. A system is provided having: a scheduling system for scheduling a first import time, a second import time, a first export time and a second export time; an import system for obtaining a first spreadsheet from a first entity at the first import time, and for obtaining a second spreadsheet from a second entity at the second import time; a synchronization system for synchronizing the first spreadsheet and the second spreadsheet to obtain a first revised spreadsheet and a second revised spreadsheet; and an export system for providing the first revised spreadsheet to the first entity at the first export time, and for providing the second revised spreadsheet to the second entity at the second export time.

Abstract: A solution for improving the logging, tracking, and/or reporting of activities and incidents of a project, and more particularly, to an integrated activity logging and incident reporting system is provided. A method may include: providing an on-line electronic database, wherein the database includes a plurality of activities related to the project and at least one incident, wherein the at least one incident is related to at least one activity; providing an activity log from the database; and providing an incident report from the database, wherein the incident report is integrated to the activity log, and wherein access to at least one of the activity log and the incident report is selectable. In an embodiment, the on-line electronic database communicates with an enterprise migration manager (EMM) database for an information technology (IT) transformation project.

Abstract: A solution for improving control of changes made to data, and more particularly, to a method, system, and computer program product for providing an intermediary document for critical change control is provided. A method may include receiving a proposed change to a field in a dataset, wherein the field is critical; and updating an intermediary document that indicates the proposed change to the field, wherein the proposed change is not processable to the dataset until the intermediary document is updated. In an embodiment, the intermediary document is displayed on a graphical user interface (GUI).

Abstract: A solution for managing data received from multiple sources is provided. In particular, when conflicting data values are received from multiple sources for a data element, a conflict rule is used to determine the main data value for the data element, which is subsequently stored for use. The conflict rule can define any automatic, semi-automatic, or manual procedure for resolving the conflict. The conflict rule, or an identifier thereof, can be stored with each data value and the main data value for the data element.

Abstract: A computer based technician terminal is connected to a vehicle being serviced using an assembly line data link (ALDL) connection from an on-board computer. The data link provides status information and fault codes. The technician is led through various procedures. During set up, the technician connects an ALDL cable from the terminal to the vehicle, the vehicle indentification number (VIN) is entered and vehicle options are identified. A fault detection procedure (FDP) in the terminal detects vehicle malfunctions by interrogating data received (via the ALDL) from the on-board computer. A fault analysis procedure (FAP), using the fault codes from a table as arguments, does a sequential compare against the contents of a fault analysis table containing fault codes. In a fault sequencing procedure (FSP), for each fault code passed by the FAP, there is a list containing the name(s) of one or more isolation procedures.