Back to results
US 11,599,553 B1Granted
Interactive smart copy method
AssigneeCapital One Services, LLC
InventorsJeremy Goodsitt, Austin Walters, Anh Truong, Vincent Pham, Galen Rafferty
Life of this patent
Estimating the term…
Abstract
Systems and methods for automatically profiling data a user selects to transfer to a paste area are described. Data may be automatically profiled the at the user selected target paste area to determine if sets of data are of the same data type. There may be a clarification for a target paste area or for identifying the data type. Additionally, there may be reformatting the selected data set to match the target data's format. Machine learning may trigger formatting or prompting actions according to one or more predetermined thresholds.
Claims20
A method comprising:
- receiving, by a computing device, a request to import a selection of a first data set, the first data set corresponding to a first portion of a first database, to a destination portion of a second database;
- determining, by the computing device and based on analyzing the selection of a first data set, a first data profile corresponding to the first data set;
- determining, by the computing device and based on the first data profile, a first identifier;
- determining, by the computing device, a second data set corresponding to the destination portion of the second database;
- determining, by the computing device and based on analyzing the second data set, a second data profile corresponding to the second data set;
- determining, by the computing device and based on the second data profile, a second identifier;
- determining, by the computing device, based on comparing the first data profile with the second data profile, and based on comparing the first identifier with the second identifier, a confidence score;
- determining, by the computing device and based on determining that the confidence score exceeds a first threshold, that the first data set and the second data set share a same data type;
- determining, by the computing device, based on determining the same data type, to add the selection of the first data set to unused data entries of the destination portion of the second database;
- determining, by the computing device and based on the same data type, a first data entry format for the first data set;
- determining, by the computing device and based on the same data type, a second data entry format for the second data set;
- translating, by the computing device, and based on determining to add the selection of the first data set to the unused data entries, the selection of the first data set from the first data entry format to the second data entry format;
- and
- adding, by the computing device and according to the second data entry format, the translated selection of the first data set to the destination portion of the second database.
11 more elements
A method comprising:
- receiving, by a computing device, a request to import a selection of a first data set, the first data set corresponding to a first portion of a first spreadsheet, to a destination portion of the first spreadsheet;
- determining, by the computing device and based on analyzing the selection of the first data set, a first identifier corresponding to the first data set;
- determining, by the computing device, a second data set corresponding to the destination portion of the first spreadsheet;
- determining, by the computing device and based on analyzing the second data set, a second identifier corresponding to the second data set;
- determining, by the computing device, based on comparing the first identifier with the second identifier, a confidence score;
- determining, by the computing device and based on determining that the confidence score exceeds a first threshold, that the first data set and the second data set share a data type;
- determining, by the computing device, based on determining the data type, to replace the second data set at the destination portion of the first spreadsheet with the selection of the first data set;
- determining, by the computing device and based on the data type, a first data entry format for the first data set;
- determining, by the computing device and based on the data type, a second data entry format for the second data set;
- translating, by the computing device, and based on determining to replace the second data set with the first data set, the selection of a first data set from the first data entry format to the second data entry format;
- and
- adding, by the computing device and according to the second data entry format, the translated selection of a first data set to the destination portion of the first spreadsheet.
9 more elements
A method comprising:
- receiving, by a computing device, a request to import a selection of a first data set, the first data set corresponding to a columnar first portion of a database, to a destination portion of a spreadsheet;
- determining, by the computing device and based on analyzing the selection of the first data set, a first data profile corresponding to the first data set;
- determining, by the computing device and based on the first data profile, a first identifier;
- determining, by the computing device, a second data set corresponding to the destination portion of the spreadsheet;
- determining, by the computing device and based on analyzing the second data set, a second data profile corresponding to the second data set;
- determining, by the computing device and based on the second data profile, a second identifier;
- determining, by the computing device, based on comparing the first data profile with the second data profile, and based on comparing the first identifier with the second identifier, a confidence score;
- determining, by the computing device and based on determining that the confidence score exceeds a first threshold, that the first data set and the second data set share a same data type;
- determining, by the computing device, based on determining the same data type, to add the selection of the first data set to unused data entries of the destination portion of the spreadsheet;
- determining, by the computing device and based on the same data type, a first data entry format for the first data set;
- determining, by the computing device and based on the same data type, a second data entry format for the second data set;
- translating, by the computing device, and based on determining to add the selection of the first data set to the unused data entries, the selection of the first data set from the first data entry format to the second data entry format;
- and
- adding, by the computing device and according to the second data entry format, the translated selection of the first data set to the destination portion of the spreadsheet;
- wherein after determining that the confidence score exceeds the first threshold and after determining to add the selection of the first data set to the unused data entries, sending, by the computing device, a confirmation request;
- and
- wherein the confirmation request requires confirmation of the added selection.
14 more elements
Dependencies are inferred from the claim text.