US2021056110A1PendingUtilityA1

Automatically migrating computer content

Assignee: AUDITFILE INCPriority: Jul 22, 2014Filed: Nov 9, 2020Published: Feb 25, 2021
Est. expiryJul 22, 2034(~8 yrs left)· nominal 20-yr term from priority
G06F 16/1873G06Q 40/10G06Q 10/06375G06Q 40/12G06F 16/24573G06F 16/9535
39
PatentIndex Score
0
Cited by
0
References
0
Claims

Abstract

A user provided content provided via the Internet is identified. The user provided content belongs to a previous version content item of a content page accessible via the Internet. A previous version content item identifier for the previous version content item is generated including by combining a content from a title of the previous version content item and a content from a description text of the previous version content item. A new version content item identifier for each content item of a plurality of content items belonging to a new version of the content page are generated, including by combining a content from a title of the corresponding content item belonging to the new version and a content from a description text of the corresponding content item belonging to the new version. Measures of similarity between the previous version content item identifier and each of the new version content item identifiers are calculated. The calculated measures of similarity are used to identify which of the new version content item identifiers most closely matches the previous version content item identifier. It is determined whether the calculated measure similarity corresponding to the most closely matched new version content item identifier meets a threshold. In the event the calculated measure similarity corresponding to the most closely matched new version content item identifier meets the threshold, the user provided content is identified for automatic migration to the new version's content item corresponding to the most closely matched new version content item identifier.

Claims

exact text as granted — not AI-modified
What is claimed is: 
     
         1 . A system for automatically tagging a trial balance, comprising:
 a communication interface configured to receive the trial balance in a user specific format; and   a processor coupled with the communication interface and configured to:
 analyze items in the trial balance to identify a first item that likely corresponds to a first data grouping of a first data subset of the trial balance, comprising to:
 in response to a determination that a data item of the trial balance does not exactly match one identifier of a group of identifiers of the first data grouping:
 determine a measure of similarity between the data item and the one identifier of the group of identifiers of the first data grouping; and 
 in response to a determination that the measure of similarity does not match another measure of similarity between the data item and another identifier of the group of identifiers of the first data grouping, provide an identifier of the group of identifiers of the first data grouping as the matching identifier, the identifier being associated with the closest similarity identified measure of similarity among the group of identifiers of the first data grouping; 
 
 
 analyze items in the trial balance to identify a second item that likely corresponds to a second data grouping of a second data subset of the trial balance; and 
 provide information to display at least a portion of the first data subset of the trial balance identified as the first data grouping and to display at least a portion of the second data subset of the trial balance identified as the second data grouping to facilitate user verification of the identification of the first data subset as the first data grouping and the identification of the second data subset as the second data grouping. 
   
     
     
         2 . The system of  claim 1 , wherein the trial balance is received in a spreadsheet file formatted in a format defined by an accountant of an entity of the trial balance. 
     
     
         3 . The system of  claim 1 , wherein the first item is a first spreadsheet cell, the first data subset is a first column of the trial balance, the second item is a second spreadsheet cell, and the second data subset is a second column of the trial balance. 
     
     
         4 . The system of  claim 1 , wherein the first item is a first column heading identifier and the second item is a second column heading identifier. 
     
     
         5 . The system of  claim 1 , wherein the first data grouping includes one of the following: account name data grouping, account number data grouping, current year balance data grouping, previous year balance data grouping, associated entity/fund data grouping, current year credit data grouping, current year debit data grouping, previous year credit data grouping, previous year debit data grouping, and leadsheet identifier data grouping. 
     
     
         6 . The system of  claim 1 , wherein analyzing items in the trial balance to identify the first item that likely corresponds to the first data grouping includes comparing the data item of the trial balance with each of the group of identifiers of the first data grouping. 
     
     
         7 . The system of  claim 1 , wherein the communication interface is configured to receive a user indication that the identification of the first data subset as the first data grouping is incorrect and the first data subset is to be identified as a third data grouping. 
     
     
         8 . The system of  claim 1 , wherein analyzing items in the trial balance to identify the first item that likely corresponds to the first data grouping includes testing items in the first data subset of the trial balance to confirm that the first data subset of the trial balance corresponds to the first data grouping. 
     
     
         9 . The system of  claim 1 , wherein the processor is further configured to import data records of the trial balance based at least in part on the identification of the first data subset as the first data grouping and the identification of the second data subset as the second data grouping. 
     
     
         10 . The system of  claim 9 , wherein the data records of the trial balance include information corresponding to a financial account specified in a row of the trial balance. 
     
     
         11 . The system of  claim 1 , wherein the processor is further configured to assign to a leadsheet one or more accounts identified in the trial balance. 
     
     
         12 . The system of  claim 11 , wherein the assignment of an account of the trial balance to the leadsheet is associated with an indicator of a confidence that the account has been correctly assigned to the leadsheet. 
     
     
         13 . The system of  claim 11 , wherein assigning to the leadsheet includes comparing a third data item of the leadsheet with a plurality of predetermined leadsheet identifiers. 
     
     
         14 . The system of  claim 11 , wherein the communication interface is further configured to receive an identification that an account of the trial balance assigned to the leadsheet has been incorrectly assigned and that the account should be assigned to a different leadsheet. 
     
     
         15 . The system of  claim 11 , wherein assigning to the leadsheet includes determining a measure of similarity between the first item and a predetermined identifier of the leadsheet and determining that the measure of similarity is greater than a threshold value. 
     
     
         16 . The system of  claim 11 , wherein assigning to the leadsheet includes determining a Sorensen-Dice coefficient of the first item and a predetermined identifier of the leadsheet and determining that the Sorensen-Dice coefficient of the predetermined identifier of the leadsheet is greater than any other Sorensen-Dice coefficient between the first data item and any other predetermined leadsheet identifier. 
     
     
         17 . The system of  claim 11 , wherein assigning to the leadsheet includes determining a Sorensen-Dice coefficient and a Levenshtein Edit Distance between the first item and a predetermined identifier of the leadsheet. 
     
     
         18 . A method for automatically tagging a trial balance, comprising:
 receiving the trial balance in a user specific format;   using a processor to analyze items in the trial balance to identify a first item that likely corresponds to a first data grouping of a first data subset of the trial balance, comprising:
 in response to a determination that a data item of the trial balance does not exactly match one identifier of a group of identifiers of the first data grouping:
 determining a measure of similarity between the data item and the one identifier of the group of identifiers of the first data grouping; and 
 in response to a determination that the measure of similarity does not match another measure of similarity between the data item and another identifier of the group of identifiers of the first data grouping, providing an identifier of the group of identifiers of the first data grouping as the matching identifier, the identifier being associated with the closest similarity identified measure of similarity among the group of identifiers of the first data grouping; 
 
   analyzing items in the trial balance to identify a second item that likely corresponds to a second data grouping of a second data subset of the trial balance; and   providing information to display at least a portion of the first data subset of the trial balance identified as the first data grouping and to display at least a portion of the second data subset of the trial balance identified as the second data grouping to facilitate user verification of the identification of the first data subset as the first data grouping and the identification of the second data subset as the second data grouping.   
     
     
         19 . A computer program product for automatically tagging a trial balance, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:
 receiving the trial balance in a user specific format;   analyzing items in the trial balance to identify a first item that likely corresponds to a first data grouping of a first data subset of the trial balance, comprising:
 in response to a determination that a data item of the trial balance does not exactly match one identifier of a group of identifiers of the first data grouping:
 determining a measure of similarity between the data item and the one identifier of the group of identifiers of the first data grouping; and 
 in response to a determination that the measure of similarity does not match another measure of similarity between the data item and another identifier of the group of identifiers of the first data grouping, providing an identifier of the group of identifiers of the first data grouping as the matching identifier, the identifier being associated with the closest similarity identified measure of similarity among the group of identifiers of the first data grouping; 
 
   analyzing items in the trial balance to identify a second item that likely corresponds to a second data grouping of a second data subset of the trial balance; and   providing information to display at least a portion of the first data subset of the trial balance identified as the first data grouping and to display at least a portion of the second data subset of the trial balance identified as the second data grouping to facilitate user verification of the identification of the first data subset as the first data grouping and the identification of the second data subset as the second data grouping.

Join the waitlist — get patent alerts

Track US2021056110A1 — get alerts on status changes and closely related new filings.

We store only your email — no account needed. See our privacy policy.