Patents by Inventor Edmund A. DAVIS
Edmund A. DAVIS has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Publication number: 20240080354Abstract: Server-side custom actions are associated with data fields. The data fields are associated with multiple rows of a client-side spread sheet. The server-side custom actions are defined by one or more web services. Input is received into the data fields of the client-side spread sheet. The input from the data fields is transmitted in a single request to the one or more web services. Results of the server-side custom actions are received. The results are displayed in the client-side spread sheet.Type: ApplicationFiled: November 7, 2023Publication date: March 7, 2024Applicant: Oracle International CorporationInventors: Shaun Logan, Edmund A. Davis
-
Publication number: 20240037208Abstract: Tests are transmitted from a client device to server-side software located on a server device. Results of the tests are received from the server-side software. An authentication sub-flow is selected, based on results of the tests, from a plurality of authentication sub-flows enabling a client-side program to operate on cloud-based data associated with server-side software. Client authentication is facilitated for the client-side program to operate on the cloud-based data using the selected authentication sub-flow. The cloud-based data is operated on from the client-side program using the client-authentication.Type: ApplicationFiled: October 13, 2023Publication date: February 1, 2024Inventors: Edmund A Davis, Shaun Logan
-
Patent number: 11848976Abstract: Example embodiments facilitate extending client-side software functionality to leverage server-side functionality, such as server-side business logic implementing custom actions and accessible to a specialized add-in to the client-side software, e.g., a client-side spreadsheet. An example method includes exposing one or more parameters of server-side logic in a client-side spreadsheet, wherein the server-side logic includes code for implementing one or more software actions; providing input to one or more spreadsheet fields corresponding to the one or more parameters, there by allocating one or more values to the one or more parameters; detecting user selection of a User Interface (UI) control for using the server-side logic to implement the one or more software actions; and sending the one or more values to the server-side logic via one or more web services, thereby providing the one or more values as input to the server-side logic.Type: GrantFiled: June 30, 2020Date of Patent: December 19, 2023Assignee: Oracle International CorporationInventors: Shaun Logan, Edmund A. Davis
-
Patent number: 11822637Abstract: An example method facilitates authenticating a client-side program, such as a spreadsheet, for access to and use of protected server-side data and/or functionality provided via a web service, such as a REpresentational State Transfer (REST) service or Application Programming Interface (API). The example method uses an add-in or plugin to the spreadsheet (which may run on a mobile device, desktop computer, other client system) to interrogate, negotiate with, or otherwise test or poll the web service to be accessed, so as to determine an authentication method used by the web service when authenticating clients; and to implement an authentication flow in accordance with the authentication method, thereby facilitating authentication of the spreadsheet for interaction with the web service in accordance with permissions associated with the authenticated client software, i.e., spreadsheet.Type: GrantFiled: September 4, 2019Date of Patent: November 21, 2023Assignee: Oracle International CorporationInventors: Edmund A. Davis, Shaun Logan
-
Publication number: 20230102947Abstract: A client-side spreadsheet with client-side worksheets is constructed. The constructing includes structuring worksheet relationships between the client-side worksheets of the client-side spreadsheet in accordance with data object relationships of data objects of a server-side data structure. A determination is made that an operation has been selected for performing on data of at least one of the client-side worksheets. User input operative to initiate performance of the at least one of the client-side worksheets is detected. Implementation of the operation is initiated in accordance with the worksheet relationships and the data object relationships.Type: ApplicationFiled: December 8, 2022Publication date: March 30, 2023Applicant: Oracle International CorporationInventors: Shaun Logan, Edmund A. Davis, Brian Rowles
-
Patent number: 11556702Abstract: Example embodiments facilitate orchestrating changes of data made (and/or actions specified for execution) in a client-side program with changes of corresponding data made in one or more server-side data objects. An example method includes structuring one or more worksheet relationships between one or more worksheets of a client-side spreadsheet in accordance with one or more data object relationships of one or more data objects of a server-side data structure; determining that one or more operations have been selected for performing on data of one or more of the worksheets; detecting user input operative to initiate performance of the one or more operations; and initiating implementation of the one or more operations (e.g., CRUD (Create, Read, Update, Delete) operations) in accordance with the one or more worksheet relationships and the one or more data object relationships (e.g., hierarchical relationships).Type: GrantFiled: August 31, 2020Date of Patent: January 17, 2023Assignee: Oracle International CorporationInventors: Shaun Logan, Edmund A. Davis, Brian Rowles
-
Patent number: 11443109Abstract: Implementations generally relate to a spreadsheet add-in that provides data entry validation. As described in more detail herein, the spreadsheet add-in integrates a spreadsheet-based table component with a remote web service. The spreadsheet add-in uses web service metadata to validate data that a user enters into the spreadsheet. The spreadsheet add-in provides immediate feedback on errors in an interactive fashion for the user. Furthermore, during a data upload process, any errors that are reported by the web service are displayed in context such that the user may quickly affect corrections.Type: GrantFiled: June 30, 2021Date of Patent: September 13, 2022Assignee: Oracle International CorporationInventors: Edmund A. Davis, Shaun Logan, Brian Rowles
-
Patent number: 11443110Abstract: Implementations generally relate to an editable table in a spreadsheet integrated with a web service. In some implementations, a method includes obtaining web service metadata from a web service. The method further includes determining one or more capabilities of the web service based on the web service metadata. The method further includes configuring a table component in a spreadsheet based on the one or more capabilities and the web service metadata. The method further includes retrieving data from the web service. The method further includes converting the data to a predetermined format. The method further includes tracking data changes in the spreadsheet based on user input. The method further includes sending the data changes from the spreadsheet to the web service.Type: GrantFiled: July 28, 2021Date of Patent: September 13, 2022Assignee: Oracle International CorporationInventors: Edmund A. Davis, Brian Rowles, Shaun Logan, Kelsey Von Tish
-
Patent number: 11354493Abstract: An example method facilitates data entry into fields or cells of client-side programs, such as spreadsheets, using a versatile data-selection dialog that provides User Interface (UI) controls and associated user options and functionality for efficiently selecting from among lists of values or computing objects for entry into an associated field or cell. The lists can be bounded or unbounded. The listed items can also be sorted and/or searched as needed. The dialog is further supported by functionality enabling selective retrieval of server-side data for populating values in the lists and caching of the retrieved values to meet the needs of a given implementation. Additional controls enable implementing advanced searches via the dialog, where associated advance-search functionality enables, for instance, searching by ranges of values; the addition of new types of search criteria (e.g., by enabling the adding of fields to a set of advanced-search controls), and so on.Type: GrantFiled: November 22, 2019Date of Patent: June 7, 2022Assignee: Oracle International CorporationInventors: Kelsey Von Tish, Edmund A. Davis, Shaun Logan
-
Publication number: 20220067271Abstract: Example embodiments facilitate orchestrating changes of data made (and/or actions specified for execution) in a client-side program with changes of corresponding data made in one or more server-side data objects. An example method includes structuring one or more worksheet relationships between one or more worksheets of a client-side spreadsheet in accordance with one or more data object relationships of one or more data objects of a server-side data structure; determining that one or more operations have been selected for performing on data of one or more of the worksheets; detecting user input operative to initiate performance of the one or more operations; and initiating implementation of the one or more operations (e.g., CRUD (Create, Read, Update, Delete) operations) in accordance with the one or more worksheet relationships and the one or more data object relationships (e.g., hierarchical relationships).Type: ApplicationFiled: August 31, 2020Publication date: March 3, 2022Applicant: Oracle International CorporationInventors: Shaun Logan, Edmund A. Davis, Brian Rowles
-
Publication number: 20210409518Abstract: Example embodiments facilitate extending client-side software functionality to leverage server-side functionality, such as server-side business logic implementing custom actions and accessible to a specialized add-in to the client-side software, e.g., a client-side spreadsheet. An example method includes exposing one or more parameters of server-side logic in a client-side spreadsheet, wherein the server-side logic includes code for implementing one or more software actions; providing input to one or more spreadsheet fields corresponding to the one or more parameters, there by allocating one or more values to the one or more parameters; detecting user selection of a User Interface (UI) control for using the server-side logic to implement the one or more software actions; and sending the one or more values to the server-side logic via one or more web services, thereby providing the one or more values as input to the server-side logic.Type: ApplicationFiled: June 30, 2020Publication date: December 30, 2021Applicant: Oracle International CorporationInventors: Shaun Logan, Edmund A. Davis
-
Publication number: 20210357582Abstract: Implementations generally relate to an editable table in a spreadsheet integrated with a web service. In some implementations, a method includes obtaining web service metadata from a web service. The method further includes determining one or more capabilities of the web service based on the web service metadata. The method further includes configuring a table component in a spreadsheet based on the one or more capabilities and the web service metadata. The method further includes retrieving data from the web service. The method further includes converting the data to a predetermined format. The method further includes tracking data changes in the spreadsheet based on user input. The method further includes sending the data changes from the spreadsheet to the web service.Type: ApplicationFiled: July 28, 2021Publication date: November 18, 2021Applicant: Oracle International CorporationInventors: Edmund A. Davis, Brian Rowles, Shaun Logan, Kelsey Von Tish
-
Publication number: 20210326520Abstract: Implementations generally relate to a spreadsheet add-in that provides data entry validation. As described in more detail herein, the spreadsheet add-in integrates a spreadsheet-based table component with a remote web service. The spreadsheet add-in uses web service metadata to validate data that a user enters into the spreadsheet. The spreadsheet add-in provides immediate feedback on errors in an interactive fashion for the user. Furthermore, during a data upload process, any errors that are reported by the web service are displayed in context such that the user may quickly affect corrections.Type: ApplicationFiled: June 30, 2021Publication date: October 21, 2021Applicant: Oracle International CorporationInventors: Edmund A. Davis, Shaun Logan, Brian Rowles
-
Patent number: 11138371Abstract: Implementations generally relate to an editable table in a spreadsheet integrated with a web service. In some implementations, a method includes obtaining web service metadata from a web service. The method further includes determining one or more capabilities of the web service based on the web service metadata. The method further includes configuring a table component in a spreadsheet based on the one or more capabilities and the web service metadata. The method further includes retrieving data from the web service. The method further includes converting the data to a predetermined format. The method further includes tracking data changes in the spreadsheet based on user input. The method further includes sending the data changes from the spreadsheet to the web service.Type: GrantFiled: September 27, 2018Date of Patent: October 5, 2021Assignee: Oracle International CorporationInventors: Edmund A. Davis, Brian Rowles, Shaun Logan, Kelsey Von Tish
-
Patent number: 11080476Abstract: Implementations generally relate to a spreadsheet add-in that provides data entry validation. As described in more detail herein, the spreadsheet add-in integrates a spreadsheet-based table component with a remote web service. The spreadsheet add-in uses web service metadata to validate data that a user enters into the spreadsheet. The spreadsheet add-in provides immediate feedback on errors in an interactive fashion for the user. Furthermore, during a data upload process, any errors that are reported by the web service are displayed in context such that the user may quickly affect corrections.Type: GrantFiled: September 27, 2018Date of Patent: August 3, 2021Assignee: Oracle International CorporationInventors: Edmund A. Davis, Shaun Logan, Brian Rowles
-
Publication number: 20200125713Abstract: An example method facilitates authenticating a client-side program, such as a spreadsheet, for access to and use of protected server-side data and/or functionality provided via a web service, such as a REpresentational State Transfer (REST) service or Application Programming Interface (API). The example method uses an add-in or plugin to the spreadsheet (which may run on a mobile device, desktop computer, other client system) to interrogate, negotiate with, or otherwise test or poll the web service to be accessed, so as to determine an authentication method used by the web service when authenticating clients; and to implement an authentication flow in accordance with the authentication method, thereby facilitating authentication of the spreadsheet for interaction with the web service in accordance with permissions associated with the authenticated client software, i.e., spreadsheet.Type: ApplicationFiled: September 4, 2019Publication date: April 23, 2020Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Edmund A. Davis, Shaun Logan
-
TABLE CELL EDITING IN EXCEL CONSTRAINED TO UNBOUNDED AND SEARCHABLE LISTS OF VALUES FROM WEB SERVICE
Publication number: 20200097534Abstract: An example method facilitates data entry into fields or cells of client-side programs, such as spreadsheets, using a versatile data-selection dialog that provides User Interface (UI) controls and associated user options and functionality for efficiently selecting from among lists of values or computing objects for entry into an associated field or cell. The lists can be bounded or unbounded. The listed items can also be sorted and/or searched as needed. The dialog is further supported by functionality enabling selective retrieval of server-side data for populating values in the lists and caching of the retrieved values to meet the needs of a given implementation. Additional controls enable implementing advanced searches via the dialog, where associated advance-search functionality enables, for instance, searching by ranges of values; the addition of new types of search criteria (e.g., by enabling the adding of fields to a set of advanced-search controls), and so on.Type: ApplicationFiled: November 22, 2019Publication date: March 26, 2020Applicant: Oracle International CorporationInventors: Kelsey Von Tish, Edmund A. Davis, Shaun Logan -
Patent number: 10582012Abstract: A system transfers data for an application. The system determines a per request data size, and sends a data transfer request for transferring a portion of the data from a client to a server according to the per request data size, where the server is configured to host the application. The system then receives a response from the server for the data transfer request, and adjusts the per request data size based on a measure of the data transfer request and the response. The adjusted per request data size is configured to be used for sending other portions of the data from the client to the server.Type: GrantFiled: May 18, 2016Date of Patent: March 3, 2020Assignee: Oracle International CorporationInventors: Edmund A. Davis, Brian C. Rowles
-
Publication number: 20190095414Abstract: Implementations generally relate to a spreadsheet add-in that provides data entry validation. As described in more detail herein, the spreadsheet add-in integrates a spreadsheet-based table component with a remote web service. The spreadsheet add-in uses web service metadata to validate data that a user enters into the spreadsheet. The spreadsheet add-in provides immediate feedback on errors in an interactive fashion for the user. Furthermore, during a data upload process, any errors that are reported by the web service are displayed in context such that the user may quickly affect corrections.Type: ApplicationFiled: September 27, 2018Publication date: March 28, 2019Applicant: Oracle International CorporationInventors: Edmund A. Davis, Shaun Logan, Brian Rowles
-
Publication number: 20190095413Abstract: Implementations generally relate to an editable table in a spreadsheet integrated with a web service. In some implementations, a method includes obtaining web service metadata from a web service. The method further includes determining one or more capabilities of the web service based on the web service metadata. The method further includes configuring a table component in a spreadsheet based on the one or more capabilities and the web service metadata. The method further includes retrieving data from the web service. The method further includes converting the data to a predetermined format. The method further includes tracking data changes in the spreadsheet based on user input. The method further includes sending the data changes from the spreadsheet to the web service.Type: ApplicationFiled: September 27, 2018Publication date: March 28, 2019Applicant: Oracle International CorporationInventors: Edmund A. Davis, Brian Rowles, Shaun Logan, Kelsey Von Tish