International Business Machines Corporation

Andrew John Garrett

James A Martin, Jr

Jeffrey E Prince

Scott Denison Hicks

Douglas George Murray

Philip J Taylor

Tanya J Ellis

A method, system and program product for performing one or more actions in response to a change made to a key data field in a project management application for managing a project. The method includes establishing one or more metrics to be monitored for a project, defining one or more actions for at least one key data field of a plurality of key data fields in the project management application, the one or more actions being defined in accordance with a level of control to be exercised and being triggered by one or more pre-specified conditions associated with the one or more metrics monitored for the project. The method further includes automatically performing at least one action of the one or more actions in response to a relative impact to the project caused by a change made to the at least one key data field.

Method, system and program product for conditionally controlling changes to key data fields in a project database

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.

Method, system and program product for defining imports into and exports out from a database system using spread sheets by use of a control language

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.

Multiple source data management using a conflict rule

A workflow management system and method that includes approval of workflow changes. A workflow management system is disclosed that includes: a mapping system for mapping tier types to workflows; a modification system for changing tier types, wherein a tier type change causes a new workflow to replace an original workflow; a workflow snapshot system for taking a snapshot of the original workflow when the tier type change occurs; and an approval system for approving tier type changes.

System and method of providing snapshot to support approval of workflow changes

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.

Cyclical and synchronized multi-source spreadsheet imports and exports

A software generation method and system. The method includes receiving by a computing system, a first data file including first data associated with an entity. The first data file includes a first file format. The first data file is converted to a second data file including a second file format. The second data file includes the first data. A data dictionary including second data is generated. Computer source code is generated within the data dictionary. The computer source code is generated from the second data. The computer source code is transferred from the data dictionary to an import agent source code editor of a software application.

Growing community of inventors

Herts, United Kingdom

Andrew John Garrett