US 11,748,368 B1
Data field transaction repair interface
Seth M. Blacher, San Francisco, CA (US); Karin L. Farnsworth, Glen Allen, VA (US); Kellie L. Thomas, St. Johns, FL (US); and Irvin J. Cooper, Columbia Heights, MN (US)
Assigned to Wells Fargo Bank, N.A., San Francisco, CA (US)
Filed by Wells Fargo Bank, N.A., San Francisco, CA (US)
Filed on Nov. 8, 2021, as Appl. No. 17/453,932.
Application 17/453,932 is a continuation of application No. 14/876,182, filed on Oct. 6, 2015, granted, now 11,170,019.
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 7/00 (2006.01); G06F 16/25 (2019.01); G06F 3/04842 (2022.01); G06F 40/205 (2020.01)
CPC G06F 16/254 (2019.01) [G06F 3/04842 (2013.01); G06F 40/205 (2020.01)] 17 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, at a computer device with at least one processor, a data file comprising receivable information associated with at least one auction clearing house (ACH) transaction;
automatically detecting, by the at least one processor, that the data file fails to conform to an ACH standardized defined data format;
in response to the detecting, automatically separating, by the at least one processor, the receivable information into a plurality of fields, the separating including parsing the data file to extract perceived remittance information for the at least one transaction;
presenting a first user interface including:
the perceived remittance information from a transaction of the at least one transaction that fails to conform to the ACH standardized defined data format; and
a confirmation user interface element to indicate whether or not the perceived remittance information has been parsed corrected;
receiving, from a user via the first user interface, an indication that the perceived remittance information has not been parsed correctly;
in response to the indication:
presenting a second user interface, the second user interface including requests for configuration characteristics of the data file and labels for one or more of the plurality of fields; and
presenting a column splitter user interface, the column splitter user interface including:
a field selection input element configured to receive a selection of a field of the plurality of fields; and
a new columns input element configured to receive a value reflecting a number of new columns for the field;
receiving input to save a rule for reformatting the data file according to the configuration characteristics of the data file and labels of the second user interface and the selection and value of the column splitter user interface;
saving the rule;
automatically reformatting, by the at least one processor, the data file according to the rule into a reformatted data file;
updating the rule for reformatting the data file based on received identification of at least two fields of the plurality of fields to merge into a single column; and
transmitting the reformatted data file for processing the remittance information.