Interactive data entry validation and problem correction in a table component in a spreadsheet driven by a web service

Patent metadata

Field	Value
Publication number	US-11080476-B2
Application number	US-201816145051-A
Country	US
Kind code	B2
Filing date	Sep 27, 2018
Priority date	Sep 28, 2017
Publication date	Aug 3, 2021
Grant date	Aug 3, 2021

Abstract

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.

First claim

We claim:

1. A method for validating a user-provided data entry to a spreadsheet at a client device with web service metadata, the method comprising:
making a request, by the client device, for web service metadata from a representational state transfer (REST)-compliant web service, wherein data is populated into different fields of the spreadsheet sourced by various databases that pass such data through the REST-compliant web service;
determining one or more requirements of the REST-compliant web service based on the web service metadata, the one or more requirements including one or more of a field is required, a field is read-only, or a particular data type is needed, wherein at least one of the one or more requirements indicated by a visual feature of a respective column on a spreadsheet;
accepting the user-provided data entry into the spreadsheet;
validating if the user-provided data entry meets the one or more requirements of the web service metadata without an additional query to the REST-compliant web service;
backend validating, using the REST-compliant web service, if the user-provided data entry meets one or more requirements specified by the REST-compliant web service but not specified by the web service metadata, wherein the backend validating is initiated by a user-provided input; and
indicating an invalid data entry on the spreadsheet if the user-provided data entry does not meet one or more of the one or more requirements of the web service metadata.

2. The method of claim 1 , wherein validating the user-provided data entry occurs without being initiated by user-provided input.

3. The method of claim 1 , further comprising indicating a valid data entry if the user-provided data entry meets the one or more requirements of the web service metadata.

4. The method of claim 1 , further comprising indicating, by the visual feature, at least one read-only field in the spreadsheet based on the web service metadata.

5. The method of claim 1 , wherein a message about the backend validation of the user-provided data entry is shown next to the user-provided data entry in the spreadsheet.

6. The method of claim 1 , wherein a backend validation message about the user-provided data entry is shown in a status window.

7. A non-transitory computer-readable storage medium carrying program instructions thereon, the instructions when executed by one or more processors cause the one or more processors to perform operations comprising:
making a request, by a client device, for web service metadata from a representational state transfer (REST)-compliant web service, wherein data is populated into different fields of a spreadsheet sourced by various databases that pass such data through the REST-compliant web service
determining one or more requirements of the REST-compliant web service based on the web service metadata, the one or more requirements including one or more of a field is required, a field is read-only, or a particular data type is needed, wherein at least one of the one or more requirements is indicated by a visual feature of a respective column on a spreadsheet;
accepting a user-provided data entry into the spreadsheet;
validating if the user-provided data entry meets the one or more requirements of the web service metadata without an additional query to the REST-compliant web service;
backend validating, using the REST-compliant web service, if the user-provided data entry meets one or more requirements specified by the REST-compliant web service but not specified by the web service metadata, wherein the backend validating is initiated by a user-provided input; and
indicating an invalid data entry on the spreadsheet if the user-provided data entry does not meet one or more of the one or more requirements of the web service metadata.

8. The computer-readable storage medium of claim 7 , wherein validating the user-provided data entry occurs without being initiated by user-provided input.

9. The computer-readable storage medium of claim 7 , further comprising indicating a valid data entry if the user-provided data entry meets the one or more requirements of the web service metadata.

10. The computer-readable storage medium of claim 7 , further comprising indicating mandatory fields in the spreadsheet based on the web service metadata.

11. The computer-readable storage medium of claim 7 , further comprising indicating, by the visual feature, at least one read-only field in the spreadsheet based on the web service metadata.

12. The computer-readable storage medium of claim 7 , wherein a message about the backend validation of the user-provided data entry is shown next to the user-provided data entry in the spreadsheet.

13. The computer-readable storage medium of claim 7 , wherein a backend validation message about the user-provided data entry is shown in a status window.

14. An apparatus comprising:
one or more processors; and
logic encoded in one or more non-transitory computer-readable storage media for execution by the one or more processors and when executed operable to perform operations comprising:
making a request, by a client device, for web service metadata from a representational state transfer (REST)-compliant web service, wherein data is populated into different fields of a spreadsheet sourced by various databases that pass such data through the REST-compliant web service;
determining one or more requirements of the REST-compliant web service based on the web service metadata, the one or more requirements including one or more of a field is required, a field is read-only, or a particular data type is needed, wherein at least one of the one or more requirements is indicated by a visual feature of a respective column on a spreadsheet;
accepting a user-provided data entry into the spreadsheet;
validating if the user-provided data entry meets the one or more requirements of the web service metadata without an additional query to the REST-compliant web service;
backend validating, using the REST-compliant web service, if the user-provided data entry meets one or more requirements specified by the REST-compliant web service but not specified by the web service metadata, wherein the backend validating is initiated by a user-provided input; and
indicating an invalid data entry if the user-provided data entry does not meet one or more of the one or more requirements of the web service metadata.

15. The apparatus of claim 14 , wherein the operations further comprise indicating, by the visual feature, at least one read-only field in the spreadsheet based on the web service metadata.

Assignees

• Oracle Int Corp

Inventors

• Davis Edmund A
• Logan Shaun
• Rowles Brian

Classifications

• G06F16/958 Primary

  Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking · CPC title

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F16/907

  Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually · CPC title