Web Data Comparison via Code Token Extraction
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The transfer of data between software applications, such as from a web application to a spreadsheet, often results in inaccuracies due to differences in character encodings, data representations, and incomplete data transfer, making manual verification tedious and error-prone.
Innovation Solution
A method for comparing source data with data extracted from a web application by analyzing the web application code for a table identifier token, extracting the data, and comparing it with the exported data, presenting differences to the user on a user interface.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If data is transferred from web application to spreadsheet, then data portability is improved, but data accuracy deteriorates due to encoding differences and representation variations
Solution Approach 1:
The patent introduces an intermediary comparison system that acts as a mediator between the web application data and spreadsheet data. This system extracts data from both sources, normalizes their representations, and performs automated comparison to identify discrepancies caused by encoding differences, date format variations, and numerical representation differences, thereby resolving the accuracy problem while maintaining portability
Solution Approach 2:
The patent implements feedback mechanisms where the comparison system provides detailed information about data discrepancies back to the user. This feedback includes specific differences in encoding, date interpretations, and numerical values, allowing users to understand and correct accuracy issues while maintaining the benefits of data transfer
2Manufacturing precision
If manual verification of exported data is performed, then data accuracy can be confirmed, but time consumption and error probability increase
Solution Approach 1:
The patent enables the system to perform self-verification by automatically comparing exported spreadsheet data against the original web application data sources. The comparison system autonomously identifies discrepancies without requiring manual intervention, thereby maintaining high verification accuracy while eliminating the time loss and error probability associated with manual checking
Solution Approach 2:
The patent replaces the mechanical manual verification process with an automated computational system. This substitution uses software-based data extraction, normalization, and comparison algorithms to perform verification tasks that were previously done manually, dramatically reducing time consumption while maintaining or improving accuracy
3Loss of information
If complete data transfer is ensured, then data completeness is improved, but data transfer reliability deteriorates due to interruptions and buffer limitations
Solution Approach 1:
The patent applies preliminary action by performing data comparison before finalizing the transfer process. The system extracts and compares data samples during the transfer process to verify completeness and accuracy, allowing for early detection of transfer issues such as interruptions or buffer overflows, thereby ensuring data completeness while improving overall transfer reliability
Data Source
AI summary
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.