| Patent application number | Description | Published |
| 20080209444 | 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 - 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. | 08-28-2008 |
| 20080270443 | LIST UPDATE EMPLOYING NEUTRAL SORT KEYS - A system for updating a list. A first list associated with a first platform includes a first plurality and a second plurality of keys. A second list associated with a second platform includes a third plurality of keys. The first and second platforms sort a first subset of characters differently. The second plurality and third plurality of keys are formed from a second subset of n characters sorted identically on the first and second platforms. An initial key in the first plurality of keys is converted to a neutral key to be included in the second plurality of keys by converting a character in the initial key to a number represented in a number system having a base b where n≧b. After the first list is updated, the lists are sorted and compared, and the second list is updated. | 10-30-2008 |
| 20080275898 | LIST UPDATE EMPLOYING NEUTRAL SORT KEYS - A program product for updating a list. A first list associated with a first platform includes a first plurality and a second plurality of keys. A second list associated with a second platform includes a third plurality of keys. The first and second platforms sort a first subset of characters differently. The second plurality and third plurality of keys are formed from a second subset of n characters sorted identically on the first and second platforms. An initial key in the first plurality of keys is converted to a neutral key to be included in the second plurality of keys by converting a character in the initial key to a number represented in a number system having a base b where n≧b. After the first list is updated, the lists are sorted and compared, and the second list is updated. | 11-06-2008 |
| 20090024600 | SYSTEM AND METHOD FOR SYNCHRONIZING LANGUAGES AND DATA ELEMENTS - Data languages, executable programs, and user interfaces are synchronized by a database for storing data enumerations in a first language, a configuration file for mapping language neutral tags to the data enumerations, a user interface operable responsive to the language neutral tags for presenting to a user interface view selected data enumerations in the second language; the user interface responsive to user selection at the user interface view of a data enumeration in the second language corresponding to a selected language neutral tag for accessing the configuration file to retrieve a corresponding data enumeration in the first language, and for returning the corresponding data enumeration to the database. | 01-22-2009 |
| 20090024672 | SYSTEM FOR SYNCHRONIZATION OF CONFIGURATION VALUES BETWEEN A DATA BASE AND ITS INPUT UTILITY - 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. | 01-22-2009 |
| 20090259692 | MANAGING DATABASE AGENTS - Aspects of the present invention provide a solution for managing database agents. Specifically, an embodiment of the present invention produces a predetermined number of replica databases for running the agents. Agent scheduling documents are produced and parsed to determine on which database the agent should be run and on which database the agent should run if the first choice of databases is not functioning. The agent scheduling documents also specify whether running of a specific agent has certain prerequisites, such as a time constraint and/or whether its running is dependent upon successful completion of another agent. | 10-15-2009 |
| 20100005382 | Method And System For Recording Asset Installations - 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. The record is transferred from the independent spreadsheet application to the asset management database in accordance with controls stored in a control worksheet of the independent spreadsheet application that control the manner of exchange of data with the asset management database. | 01-07-2010 |