Generic web page extraction and data comparison framework
AssigneeSap SE
InventorAshish Kumar
Life of this patent
Estimating the term…
Abstract
The present disclosure provides techniques and solutions for comparing source data with data extracted from a source. A user provides an identifier of a web page and an identifier of a file having data exported from the web page. Data for a table of a web application is extracted from web application code by analyzing the web application code for a table identifier token. The extracted data is compared with data exported from the web application to the file. Differences between the extracted data and the data exported from the web application to the file are determined. The differences are presented to a user on a user interface display.
Claims20
A computing system comprising:
- at least one memory;
- one or more hardware processor units coupled to the at least one memory;
- and
- one or more computer readable storage media storing computer-executable instructions that, when executed, cause the computing system to perform operations comprising:
- receiving an identifier of a spreadsheet file;
- receiving an identifier of a web page comprising table data of a table, the web page comprising an identifier of the table;
- analyzing code of the web page;
- identifying a table identifier token for the table in the code of the web page based on the analyzing;
- extracting table data for the table associated with the table identifier token from the code of the web page to provide extracted table data;
- comparing the extracted table data with spreadsheet data of the spreadsheet file;
- based on the comparing, identifying one or more differences between the extracted table data and the spreadsheet data to provide one or more identified differences;
- and
- storing the one or more identified differences, wherein the one or more identified differences are displayed to a user on a user interface.
A method, implemented in a computing system comprising at least one hardware processor and at least one memory coupled to the at least one hardware processor, the method comprising:
- receiving an identifier of a spreadsheet file;
- receiving an identifier of a web page comprising table data of a table, the web page comprising an identifier of the table;
- analyzing code of the web page;
- identifying a table identifier token for the table in the code of the web page based on the analyzing;
- extracting table data for the table associated with the table identifier token from the code of the web page to provide extracted table data;
- comparing the extracted table data with spreadsheet data of the spreadsheet file;
- based on the comparing, identifying one or more differences between the extracted table data and the spreadsheet data to provide one or more identified differences;
- and
- storing the one or more identified differences, wherein the one or more identified differences are displayed to a user on a user interface.
One or more computer-readable storage media comprising:
- computer-executable instructions that, when executed by a computing system comprising at least one hardware processor and at least one memory coupled to the at least one hardware processor, cause the computing system to receive an identifier of a spreadsheet file;
- computer-executable instructions that, when executed by the computing system, cause the computing system to receive an identifier of a web page comprising table data of a table, the web page comprising an identifier of the table;
- computer-executable instructions that, when executed by the computing system, cause the computing system to analyze code of the web page;
- computer-executable instructions that, when executed by the computing system, cause the computing system to identify a table identifier token for the table in the code of the web page based on the analyzing;
- computer-executable instructions that, when executed by the computing system, cause the computing system to extract table data for the table associated with the table identifier token from the code of the web page to provide extracted table data;
- computer-executable instructions that, when executed by the computing system, cause the computing system to compare the extracted table data with spreadsheet data of the spreadsheet file;
- computer-executable instructions that, when executed by the computing system, cause the computing system to, based on the comparing, identify one or more differences between the extracted table data and the spreadsheet data to provide one or more identified differences;
- and
- computer-executable instructions that, when executed by the computing system, cause the computing system to store the one or more identified differences, wherein the one or more identified differences are displayed to a user on a user interface.
Dependencies are inferred from the claim text.